project-schema-otherORMapper
Table Name Entity Name Foreign Table Refferer Table
AUTHOR Author BOOK
BLACK_ACTION BlackAction BLACK_LIST, BLACK_ACTION_LOOKUP
BLACK_ACTION_LOOKUP BlackActionLookup BLACK_ACTION
BLACK_LIST BlackList LB_USER BLACK_ACTION
BOOK Book AUTHOR, PUBLISHER, GENRE COLLECTION
COLLECTION Collection LIBRARY, BOOK COLLECTION_STATUS, LENDING_COLLECTION
COLLECTION_STATUS CollectionStatus COLLECTION, COLLECTION_STATUS_LOOKUP
COLLECTION_STATUS_LOOKUP CollectionStatusLookup COLLECTION_STATUS
GARBAGE Garbage
GENRE Genre GENRE BOOK, GENRE
LB_USER LbUser BLACK_LIST, LIBRARY_USER
LENDING Lending LIBRARY_USER LENDING_COLLECTION
LENDING_COLLECTION LendingCollection COLLECTION, LENDING
LIBRARY Library COLLECTION, LIBRARY_USER, NEXT_LIBRARY, NEXT_LIBRARY
LIBRARY_USER LibraryUser LIBRARY, LB_USER LENDING
NEXT_LIBRARY NextLibrary LIBRARY, LIBRARY
PUBLISHER Publisher BOOK

AUTHOR

Name Type of dbflute PK AutoInc NotNull Size Default ForeignTable ReffererTable CapPropName Type of java Classification
AUTHOR_ID INTEGER
o
o
o
  GENERATED_BY_DEFAULT   BOOK  AuthorId java.math.BigDecimal  
AUTHOR_NAME VARCHAR
 
 
o
(80)       AuthorName String  
AUTHOR_AGE SMALLINT
 
 
 
        AuthorAge java.math.BigDecimal  
R_TIME TIMESTAMP
 
 
o
  CURRENT_TIMESTAMP     RTime java.sql.Timestamp  
U_TIME TIMESTAMP
 
 
o
  CURRENT_TIMESTAMP     UTime java.sql.Timestamp  
R_USER VARCHAR
 
 
o
(50) default-user     RUser String  
U_USER VARCHAR
 
 
o
(50) default-user     UUser String  

BLACK_ACTION

Name Type of dbflute PK AutoInc NotNull Size Default ForeignTable ReffererTable CapPropName Type of java Classification
BLACK_ACTION_ID INTEGER
o
o
o
  GENERATED_BY_DEFAULT     BlackActionId java.math.BigDecimal  
BLACK_LIST_ID INTEGER
 
 
o
    BLACK_LIST    BlackListId java.math.BigDecimal  
BLACK_ACTION_CODE CHAR
 
 
o
(3)   BLACK_ACTION_LOOKUP    BlackActionCode String  
BLACK_LEVEL SMALLINT
 
 
o
        BlackLevel java.math.BigDecimal  
ACTION_DATE TIMESTAMP
 
 
 
        ActionDate java.sql.Timestamp  
EVIDENCE_PHOTOGRAPH BLOB
 
 
 
        EvidencePhotograph byte[]  
R_TIME TIMESTAMP
 
 
o
  CURRENT_TIMESTAMP     RTime java.sql.Timestamp  
U_TIME TIMESTAMP
 
 
o
  CURRENT_TIMESTAMP     UTime java.sql.Timestamp  
R_USER VARCHAR
 
 
o
(50) default-user     RUser String  
U_USER VARCHAR
 
 
o
(50) default-user     UUser String  

BLACK_ACTION_LOOKUP

Name Type of dbflute PK AutoInc NotNull Size Default ForeignTable ReffererTable CapPropName Type of java Classification
BLACK_ACTION_CODE CHAR
o
 
o
(3)     BLACK_ACTION  BlackActionCode String  
BLACK_ACTION_NAME VARCHAR
 
 
o
(80)       BlackActionName String  
R_TIME TIMESTAMP
 
 
o
  CURRENT_TIMESTAMP     RTime java.sql.Timestamp  
U_TIME TIMESTAMP
 
 
o
  CURRENT_TIMESTAMP     UTime java.sql.Timestamp  
R_USER VARCHAR
 
 
o
(50) default-user     RUser String  
U_USER VARCHAR
 
 
o
(50) default-user     UUser String  

BLACK_LIST

Name Type of dbflute PK AutoInc NotNull Size Default ForeignTable ReffererTable CapPropName Type of java Classification
BLACK_LIST_ID INTEGER
o
o
o
  GENERATED_BY_DEFAULT   BLACK_ACTION  BlackListId java.math.BigDecimal  
LB_USER_ID INTEGER
 
 
o
    LB_USER    LbUserId java.math.BigDecimal  
BLACK_RANK CHAR
 
 
o
(3)       BlackRank String  
R_TIME TIMESTAMP
 
 
o
  CURRENT_TIMESTAMP     RTime java.sql.Timestamp  
U_TIME TIMESTAMP
 
 
o
  CURRENT_TIMESTAMP     UTime java.sql.Timestamp  
R_USER VARCHAR
 
 
o
(50) default-user     RUser String  
U_USER VARCHAR
 
 
o
(50) default-user     UUser String  

BOOK

Name Type of dbflute PK AutoInc NotNull Size Default ForeignTable ReffererTable CapPropName Type of java Classification
BOOK_ID INTEGER
o
o
o
  GENERATED_BY_DEFAULT   COLLECTION  BookId java.math.BigDecimal  
ISBN_NO VARCHAR
 
 
o
(20)       IsbnNo String  
BOOK_NAME VARCHAR
 
 
o
(80)       BookName String  
AUTHOR_ID INTEGER
 
 
o
    AUTHOR    AuthorId java.math.BigDecimal  
PUBLISHER_ID INTEGER
 
 
o
    PUBLISHER    PublisherId java.math.BigDecimal  
MAX_LENDING_DATE_COUNT SMALLINT
 
 
o
        MaxLendingDateCount java.math.BigDecimal  
GENRE_CODE VARCHAR
 
 
 
(12)   GENRE    GenreCode String  
OPENING_PART CLOB
 
 
 
        OpeningPart String  
OUT_OF_USER_SELECT_YN CHAR
 
 
o
(1)       OutOfUserSelectYn String  
OUT_OF_USER_SELECT_REASON VARCHAR
 
 
 
(200)       OutOfUserSelectReason String  
R_TIME TIMESTAMP
 
 
o
  CURRENT_TIMESTAMP     RTime java.sql.Timestamp  
U_TIME TIMESTAMP
 
 
o
  CURRENT_TIMESTAMP     UTime java.sql.Timestamp  
R_USER VARCHAR
 
 
o
(50) default-user     RUser String  
U_USER VARCHAR
 
 
o
(50) default-user     UUser String  

COLLECTION

Name Type of dbflute PK AutoInc NotNull Size Default ForeignTable ReffererTable CapPropName Type of java Classification
COLLECTION_ID INTEGER
o
o
o
  GENERATED_BY_DEFAULT   COLLECTION_STATUS, LENDING_COLLECTION  CollectionId java.math.BigDecimal  
LIBRARY_ID SMALLINT
 
 
o
    LIBRARY    LibraryId java.math.BigDecimal  
BOOK_ID INTEGER
 
 
o
    BOOK    BookId java.math.BigDecimal  
ARRIVAL_DATE TIMESTAMP
 
 
o
        ArrivalDate java.sql.Timestamp  
R_TIME TIMESTAMP
 
 
o
  CURRENT_TIMESTAMP     RTime java.sql.Timestamp  
U_TIME TIMESTAMP
 
 
o
  CURRENT_TIMESTAMP     UTime java.sql.Timestamp  
R_USER VARCHAR
 
 
o
(50) default-user     RUser String  
U_USER VARCHAR
 
 
o
(50) default-user     UUser String  

COLLECTION_STATUS

Name Type of dbflute PK AutoInc NotNull Size Default ForeignTable ReffererTable CapPropName Type of java Classification
COLLECTION_ID INTEGER
o
 
o
    COLLECTION    CollectionId java.math.BigDecimal  
COLLECTION_STATUS_CODE CHAR
 
 
o
(3)   COLLECTION_STATUS_LOOKUP    CollectionStatusCode String  
R_TIME TIMESTAMP
 
 
o
  CURRENT_TIMESTAMP     RTime java.sql.Timestamp  
U_TIME TIMESTAMP
 
 
o
  CURRENT_TIMESTAMP     UTime java.sql.Timestamp  
R_USER VARCHAR
 
 
o
(50) default-user     RUser String  
U_USER VARCHAR
 
 
o
(50) default-user     UUser String  

COLLECTION_STATUS_LOOKUP

Name Type of dbflute PK AutoInc NotNull Size Default ForeignTable ReffererTable CapPropName Type of java Classification
COLLECTION_STATUS_CODE CHAR
o
 
o
(3)     COLLECTION_STATUS  CollectionStatusCode String  
COLLECTION_STATUS_NAME VARCHAR
 
 
o
(80)       CollectionStatusName String  
R_TIME TIMESTAMP
 
 
o
  CURRENT_TIMESTAMP     RTime java.sql.Timestamp  
U_TIME TIMESTAMP
 
 
o
  CURRENT_TIMESTAMP     UTime java.sql.Timestamp  
R_USER VARCHAR
 
 
o
(50) default-user     RUser String  
U_USER VARCHAR
 
 
o
(50) default-user     UUser String  

GARBAGE

Name Type of dbflute PK AutoInc NotNull Size Default ForeignTable ReffererTable CapPropName Type of java Classification
GARBAGE_MEMO VARCHAR
 
 
 
(50)       GarbageMemo String  
GARBAGE_TIME TIMESTAMP
 
 
 
        GarbageTime java.sql.Timestamp  

GENRE

Name Type of dbflute PK AutoInc NotNull Size Default ForeignTable ReffererTable CapPropName Type of java Classification
GENRE_CODE VARCHAR
o
 
o
(12)     BOOK, GENRE  GenreCode String  
GENRE_NAME VARCHAR
 
 
o
(80)       GenreName String  
PARENT_GENRE_CODE VARCHAR
 
 
 
(12)   GENRE    ParentGenreCode String  
R_TIME TIMESTAMP
 
 
o
  CURRENT_TIMESTAMP     RTime java.sql.Timestamp  
U_TIME TIMESTAMP
 
 
o
  CURRENT_TIMESTAMP     UTime java.sql.Timestamp  
R_USER VARCHAR
 
 
o
(50) default-user     RUser String  
U_USER VARCHAR
 
 
o
(50) default-user     UUser String  

LB_USER

Name Type of dbflute PK AutoInc NotNull Size Default ForeignTable ReffererTable CapPropName Type of java Classification
LB_USER_ID INTEGER
o
o
o
  GENERATED_BY_DEFAULT   BLACK_LIST, LIBRARY_USER  LbUserId java.math.BigDecimal  
LB_USER_NAME VARCHAR
 
 
o
(80)       LbUserName String  
USER_PASSWORD VARCHAR
 
 
o
(50)       UserPassword String  
R_TIME TIMESTAMP
 
 
o
  CURRENT_TIMESTAMP     RTime java.sql.Timestamp  
U_TIME TIMESTAMP
 
 
o
  CURRENT_TIMESTAMP     UTime java.sql.Timestamp  
R_USER VARCHAR
 
 
o
(50) default-user     RUser String  
U_USER VARCHAR
 
 
o
(50) default-user     UUser String  

LENDING

Name Type of dbflute PK AutoInc NotNull Size Default ForeignTable ReffererTable CapPropName Type of java Classification
LIBRARY_ID SMALLINT
o
 
o
    LIBRARY_USER  LENDING_COLLECTION  LibraryId java.math.BigDecimal  
LB_USER_ID INTEGER
o
 
o
    LIBRARY_USER  LENDING_COLLECTION  LbUserId java.math.BigDecimal  
LENDING_DATE TIMESTAMP
o
 
o
      LENDING_COLLECTION  LendingDate java.sql.Timestamp  
R_TIME TIMESTAMP
 
 
o
  CURRENT_TIMESTAMP     RTime java.sql.Timestamp  
U_TIME TIMESTAMP
 
 
o
  CURRENT_TIMESTAMP     UTime java.sql.Timestamp  
R_USER VARCHAR
 
 
o
(50) default-user     RUser String  
U_USER VARCHAR
 
 
o
(50) default-user     UUser String  

LENDING_COLLECTION

Name Type of dbflute PK AutoInc NotNull Size Default ForeignTable ReffererTable CapPropName Type of java Classification
LIBRARY_ID SMALLINT
o
 
o
    LENDING    LibraryId java.math.BigDecimal  
LB_USER_ID INTEGER
o
 
o
    LENDING    LbUserId java.math.BigDecimal  
LENDING_DATE TIMESTAMP
o
 
o
    LENDING    LendingDate java.sql.Timestamp  
COLLECTION_ID INTEGER
o
 
o
    COLLECTION    CollectionId java.math.BigDecimal  
RETURN_LIMIT_DATE TIMESTAMP
 
 
o
        ReturnLimitDate java.sql.Timestamp  
R_TIME TIMESTAMP
 
 
o
  CURRENT_TIMESTAMP     RTime java.sql.Timestamp  
U_TIME TIMESTAMP
 
 
o
  CURRENT_TIMESTAMP     UTime java.sql.Timestamp  
R_USER VARCHAR
 
 
o
(50) default-user     RUser String  
U_USER VARCHAR
 
 
o
(50) default-user     UUser String  

LIBRARY

Name Type of dbflute PK AutoInc NotNull Size Default ForeignTable ReffererTable CapPropName Type of java Classification
LIBRARY_ID SMALLINT
o
o
o
  GENERATED_BY_DEFAULT   COLLECTION, LIBRARY_USER, NEXT_LIBRARY, NEXT_LIBRARY  LibraryId java.math.BigDecimal  
LIBRARY_NAME VARCHAR
 
 
o
(80)       LibraryName String  
R_TIME TIMESTAMP
 
 
o
  CURRENT_TIMESTAMP     RTime java.sql.Timestamp  
U_TIME TIMESTAMP
 
 
o
  CURRENT_TIMESTAMP     UTime java.sql.Timestamp  
R_USER VARCHAR
 
 
o
(50) default-user     RUser String  
U_USER VARCHAR
 
 
o
(50) default-user     UUser String  

LIBRARY_USER

Name Type of dbflute PK AutoInc NotNull Size Default ForeignTable ReffererTable CapPropName Type of java Classification
LIBRARY_ID SMALLINT
o
 
o
    LIBRARY  LENDING  LibraryId java.math.BigDecimal  
LB_USER_ID INTEGER
o
 
o
    LB_USER  LENDING  LbUserId java.math.BigDecimal  
R_TIME TIMESTAMP
 
 
o
  CURRENT_TIMESTAMP     RTime java.sql.Timestamp  
U_TIME TIMESTAMP
 
 
o
  CURRENT_TIMESTAMP     UTime java.sql.Timestamp  
R_USER VARCHAR
 
 
o
(50) default-user     RUser String  
U_USER VARCHAR
 
 
o
(50) default-user     UUser String  

NEXT_LIBRARY

Name Type of dbflute PK AutoInc NotNull Size Default ForeignTable ReffererTable CapPropName Type of java Classification
LIBRARY_ID SMALLINT
o
 
o
    LIBRARY    LibraryId java.math.BigDecimal  
NEXT_LIBRARY_ID SMALLINT
o
 
o
    LIBRARY    NextLibraryId java.math.BigDecimal  
DISTANCE_KM INTEGER
 
 
o
        DistanceKm java.math.BigDecimal  
R_TIME TIMESTAMP
 
 
o
  CURRENT_TIMESTAMP     RTime java.sql.Timestamp  
U_TIME TIMESTAMP
 
 
o
  CURRENT_TIMESTAMP     UTime java.sql.Timestamp  
R_USER VARCHAR
 
 
o
(50) default-user     RUser String  
U_USER VARCHAR
 
 
o
(50) default-user     UUser String  

PUBLISHER

Name Type of dbflute PK AutoInc NotNull Size Default ForeignTable ReffererTable CapPropName Type of java Classification
PUBLISHER_ID INTEGER
o
o
o
  GENERATED_BY_DEFAULT   BOOK  PublisherId java.math.BigDecimal  
PUBLISHER_NAME VARCHAR
 
 
o
(80)       PublisherName String  
R_TIME TIMESTAMP
 
 
o
  CURRENT_TIMESTAMP     RTime java.sql.Timestamp  
U_TIME TIMESTAMP
 
 
o
  CURRENT_TIMESTAMP     UTime java.sql.Timestamp  
R_USER VARCHAR
 
 
o
(50) default-user     RUser String  
U_USER VARCHAR
 
 
o
(50) default-user     UUser String