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 |
Name | Type of dbflute | PK | AutoInc | NotNull | Size | Default | ForeignTable | ReffererTable | CapPropName | Type of java | Classification |
---|---|---|---|---|---|---|---|---|---|---|---|
AUTHOR_ID | INTEGER | GENERATED_BY_DEFAULT | BOOK | AuthorId | java.math.BigDecimal | ||||||
AUTHOR_NAME | VARCHAR | (80) | AuthorName | String | |||||||
AUTHOR_AGE | SMALLINT | AuthorAge | java.math.BigDecimal | ||||||||
R_TIME | TIMESTAMP | CURRENT_TIMESTAMP | RTime | java.sql.Timestamp | |||||||
U_TIME | TIMESTAMP | CURRENT_TIMESTAMP | UTime | java.sql.Timestamp | |||||||
R_USER | VARCHAR | (50) | default-user | RUser | String | ||||||
U_USER | VARCHAR | (50) | default-user | UUser | String |
Name | Type of dbflute | PK | AutoInc | NotNull | Size | Default | ForeignTable | ReffererTable | CapPropName | Type of java | Classification |
---|---|---|---|---|---|---|---|---|---|---|---|
BLACK_ACTION_ID | INTEGER | GENERATED_BY_DEFAULT | BlackActionId | java.math.BigDecimal | |||||||
BLACK_LIST_ID | INTEGER | BLACK_LIST | BlackListId | java.math.BigDecimal | |||||||
BLACK_ACTION_CODE | CHAR | (3) | BLACK_ACTION_LOOKUP | BlackActionCode | String | ||||||
BLACK_LEVEL | SMALLINT | BlackLevel | java.math.BigDecimal | ||||||||
ACTION_DATE | TIMESTAMP | ActionDate | java.sql.Timestamp | ||||||||
EVIDENCE_PHOTOGRAPH | BLOB | EvidencePhotograph | byte[] | ||||||||
R_TIME | TIMESTAMP | CURRENT_TIMESTAMP | RTime | java.sql.Timestamp | |||||||
U_TIME | TIMESTAMP | CURRENT_TIMESTAMP | UTime | java.sql.Timestamp | |||||||
R_USER | VARCHAR | (50) | default-user | RUser | String | ||||||
U_USER | VARCHAR | (50) | default-user | UUser | String |
Name | Type of dbflute | PK | AutoInc | NotNull | Size | Default | ForeignTable | ReffererTable | CapPropName | Type of java | Classification |
---|---|---|---|---|---|---|---|---|---|---|---|
BLACK_ACTION_CODE | CHAR | (3) | BLACK_ACTION | BlackActionCode | String | ||||||
BLACK_ACTION_NAME | VARCHAR | (80) | BlackActionName | String | |||||||
R_TIME | TIMESTAMP | CURRENT_TIMESTAMP | RTime | java.sql.Timestamp | |||||||
U_TIME | TIMESTAMP | CURRENT_TIMESTAMP | UTime | java.sql.Timestamp | |||||||
R_USER | VARCHAR | (50) | default-user | RUser | String | ||||||
U_USER | VARCHAR | (50) | default-user | UUser | String |
Name | Type of dbflute | PK | AutoInc | NotNull | Size | Default | ForeignTable | ReffererTable | CapPropName | Type of java | Classification |
---|---|---|---|---|---|---|---|---|---|---|---|
BLACK_LIST_ID | INTEGER | GENERATED_BY_DEFAULT | BLACK_ACTION | BlackListId | java.math.BigDecimal | ||||||
LB_USER_ID | INTEGER | LB_USER | LbUserId | java.math.BigDecimal | |||||||
BLACK_RANK | CHAR | (3) | BlackRank | String | |||||||
R_TIME | TIMESTAMP | CURRENT_TIMESTAMP | RTime | java.sql.Timestamp | |||||||
U_TIME | TIMESTAMP | CURRENT_TIMESTAMP | UTime | java.sql.Timestamp | |||||||
R_USER | VARCHAR | (50) | default-user | RUser | String | ||||||
U_USER | VARCHAR | (50) | default-user | UUser | String |
Name | Type of dbflute | PK | AutoInc | NotNull | Size | Default | ForeignTable | ReffererTable | CapPropName | Type of java | Classification |
---|---|---|---|---|---|---|---|---|---|---|---|
BOOK_ID | INTEGER | GENERATED_BY_DEFAULT | COLLECTION | BookId | java.math.BigDecimal | ||||||
ISBN_NO | VARCHAR | (20) | IsbnNo | String | |||||||
BOOK_NAME | VARCHAR | (80) | BookName | String | |||||||
AUTHOR_ID | INTEGER | AUTHOR | AuthorId | java.math.BigDecimal | |||||||
PUBLISHER_ID | INTEGER | PUBLISHER | PublisherId | java.math.BigDecimal | |||||||
MAX_LENDING_DATE_COUNT | SMALLINT | MaxLendingDateCount | java.math.BigDecimal | ||||||||
GENRE_CODE | VARCHAR | (12) | GENRE | GenreCode | String | ||||||
OPENING_PART | CLOB | OpeningPart | String | ||||||||
OUT_OF_USER_SELECT_YN | CHAR | (1) | OutOfUserSelectYn | String | |||||||
OUT_OF_USER_SELECT_REASON | VARCHAR | (200) | OutOfUserSelectReason | String | |||||||
R_TIME | TIMESTAMP | CURRENT_TIMESTAMP | RTime | java.sql.Timestamp | |||||||
U_TIME | TIMESTAMP | CURRENT_TIMESTAMP | UTime | java.sql.Timestamp | |||||||
R_USER | VARCHAR | (50) | default-user | RUser | String | ||||||
U_USER | VARCHAR | (50) | default-user | UUser | String |
Name | Type of dbflute | PK | AutoInc | NotNull | Size | Default | ForeignTable | ReffererTable | CapPropName | Type of java | Classification |
---|---|---|---|---|---|---|---|---|---|---|---|
COLLECTION_ID | INTEGER | GENERATED_BY_DEFAULT | COLLECTION_STATUS, LENDING_COLLECTION | CollectionId | java.math.BigDecimal | ||||||
LIBRARY_ID | SMALLINT | LIBRARY | LibraryId | java.math.BigDecimal | |||||||
BOOK_ID | INTEGER | BOOK | BookId | java.math.BigDecimal | |||||||
ARRIVAL_DATE | TIMESTAMP | ArrivalDate | java.sql.Timestamp | ||||||||
R_TIME | TIMESTAMP | CURRENT_TIMESTAMP | RTime | java.sql.Timestamp | |||||||
U_TIME | TIMESTAMP | CURRENT_TIMESTAMP | UTime | java.sql.Timestamp | |||||||
R_USER | VARCHAR | (50) | default-user | RUser | String | ||||||
U_USER | VARCHAR | (50) | default-user | UUser | String |
Name | Type of dbflute | PK | AutoInc | NotNull | Size | Default | ForeignTable | ReffererTable | CapPropName | Type of java | Classification |
---|---|---|---|---|---|---|---|---|---|---|---|
COLLECTION_ID | INTEGER | COLLECTION | CollectionId | java.math.BigDecimal | |||||||
COLLECTION_STATUS_CODE | CHAR | (3) | COLLECTION_STATUS_LOOKUP | CollectionStatusCode | String | ||||||
R_TIME | TIMESTAMP | CURRENT_TIMESTAMP | RTime | java.sql.Timestamp | |||||||
U_TIME | TIMESTAMP | CURRENT_TIMESTAMP | UTime | java.sql.Timestamp | |||||||
R_USER | VARCHAR | (50) | default-user | RUser | String | ||||||
U_USER | VARCHAR | (50) | default-user | UUser | String |
Name | Type of dbflute | PK | AutoInc | NotNull | Size | Default | ForeignTable | ReffererTable | CapPropName | Type of java | Classification |
---|---|---|---|---|---|---|---|---|---|---|---|
COLLECTION_STATUS_CODE | CHAR | (3) | COLLECTION_STATUS | CollectionStatusCode | String | ||||||
COLLECTION_STATUS_NAME | VARCHAR | (80) | CollectionStatusName | String | |||||||
R_TIME | TIMESTAMP | CURRENT_TIMESTAMP | RTime | java.sql.Timestamp | |||||||
U_TIME | TIMESTAMP | CURRENT_TIMESTAMP | UTime | java.sql.Timestamp | |||||||
R_USER | VARCHAR | (50) | default-user | RUser | String | ||||||
U_USER | VARCHAR | (50) | default-user | UUser | String |
Name | Type of dbflute | PK | AutoInc | NotNull | Size | Default | ForeignTable | ReffererTable | CapPropName | Type of java | Classification |
---|---|---|---|---|---|---|---|---|---|---|---|
GENRE_CODE | VARCHAR | (12) | BOOK, GENRE | GenreCode | String | ||||||
GENRE_NAME | VARCHAR | (80) | GenreName | String | |||||||
PARENT_GENRE_CODE | VARCHAR | (12) | GENRE | ParentGenreCode | String | ||||||
R_TIME | TIMESTAMP | CURRENT_TIMESTAMP | RTime | java.sql.Timestamp | |||||||
U_TIME | TIMESTAMP | CURRENT_TIMESTAMP | UTime | java.sql.Timestamp | |||||||
R_USER | VARCHAR | (50) | default-user | RUser | String | ||||||
U_USER | VARCHAR | (50) | default-user | UUser | String |
Name | Type of dbflute | PK | AutoInc | NotNull | Size | Default | ForeignTable | ReffererTable | CapPropName | Type of java | Classification |
---|---|---|---|---|---|---|---|---|---|---|---|
LB_USER_ID | INTEGER | GENERATED_BY_DEFAULT | BLACK_LIST, LIBRARY_USER | LbUserId | java.math.BigDecimal | ||||||
LB_USER_NAME | VARCHAR | (80) | LbUserName | String | |||||||
USER_PASSWORD | VARCHAR | (50) | UserPassword | String | |||||||
R_TIME | TIMESTAMP | CURRENT_TIMESTAMP | RTime | java.sql.Timestamp | |||||||
U_TIME | TIMESTAMP | CURRENT_TIMESTAMP | UTime | java.sql.Timestamp | |||||||
R_USER | VARCHAR | (50) | default-user | RUser | String | ||||||
U_USER | VARCHAR | (50) | default-user | UUser | String |
Name | Type of dbflute | PK | AutoInc | NotNull | Size | Default | ForeignTable | ReffererTable | CapPropName | Type of java | Classification |
---|---|---|---|---|---|---|---|---|---|---|---|
LIBRARY_ID | SMALLINT | LIBRARY_USER | LENDING_COLLECTION | LibraryId | java.math.BigDecimal | ||||||
LB_USER_ID | INTEGER | LIBRARY_USER | LENDING_COLLECTION | LbUserId | java.math.BigDecimal | ||||||
LENDING_DATE | TIMESTAMP | LENDING_COLLECTION | LendingDate | java.sql.Timestamp | |||||||
R_TIME | TIMESTAMP | CURRENT_TIMESTAMP | RTime | java.sql.Timestamp | |||||||
U_TIME | TIMESTAMP | CURRENT_TIMESTAMP | UTime | java.sql.Timestamp | |||||||
R_USER | VARCHAR | (50) | default-user | RUser | String | ||||||
U_USER | VARCHAR | (50) | default-user | UUser | String |
Name | Type of dbflute | PK | AutoInc | NotNull | Size | Default | ForeignTable | ReffererTable | CapPropName | Type of java | Classification |
---|---|---|---|---|---|---|---|---|---|---|---|
LIBRARY_ID | SMALLINT | LENDING | LibraryId | java.math.BigDecimal | |||||||
LB_USER_ID | INTEGER | LENDING | LbUserId | java.math.BigDecimal | |||||||
LENDING_DATE | TIMESTAMP | LENDING | LendingDate | java.sql.Timestamp | |||||||
COLLECTION_ID | INTEGER | COLLECTION | CollectionId | java.math.BigDecimal | |||||||
RETURN_LIMIT_DATE | TIMESTAMP | ReturnLimitDate | java.sql.Timestamp | ||||||||
R_TIME | TIMESTAMP | CURRENT_TIMESTAMP | RTime | java.sql.Timestamp | |||||||
U_TIME | TIMESTAMP | CURRENT_TIMESTAMP | UTime | java.sql.Timestamp | |||||||
R_USER | VARCHAR | (50) | default-user | RUser | String | ||||||
U_USER | VARCHAR | (50) | default-user | UUser | String |
Name | Type of dbflute | PK | AutoInc | NotNull | Size | Default | ForeignTable | ReffererTable | CapPropName | Type of java | Classification |
---|---|---|---|---|---|---|---|---|---|---|---|
LIBRARY_ID | SMALLINT | GENERATED_BY_DEFAULT | COLLECTION, LIBRARY_USER, NEXT_LIBRARY, NEXT_LIBRARY | LibraryId | java.math.BigDecimal | ||||||
LIBRARY_NAME | VARCHAR | (80) | LibraryName | String | |||||||
R_TIME | TIMESTAMP | CURRENT_TIMESTAMP | RTime | java.sql.Timestamp | |||||||
U_TIME | TIMESTAMP | CURRENT_TIMESTAMP | UTime | java.sql.Timestamp | |||||||
R_USER | VARCHAR | (50) | default-user | RUser | String | ||||||
U_USER | VARCHAR | (50) | default-user | UUser | String |
Name | Type of dbflute | PK | AutoInc | NotNull | Size | Default | ForeignTable | ReffererTable | CapPropName | Type of java | Classification |
---|---|---|---|---|---|---|---|---|---|---|---|
LIBRARY_ID | SMALLINT | LIBRARY | LENDING | LibraryId | java.math.BigDecimal | ||||||
LB_USER_ID | INTEGER | LB_USER | LENDING | LbUserId | java.math.BigDecimal | ||||||
R_TIME | TIMESTAMP | CURRENT_TIMESTAMP | RTime | java.sql.Timestamp | |||||||
U_TIME | TIMESTAMP | CURRENT_TIMESTAMP | UTime | java.sql.Timestamp | |||||||
R_USER | VARCHAR | (50) | default-user | RUser | String | ||||||
U_USER | VARCHAR | (50) | default-user | UUser | String |
Name | Type of dbflute | PK | AutoInc | NotNull | Size | Default | ForeignTable | ReffererTable | CapPropName | Type of java | Classification |
---|---|---|---|---|---|---|---|---|---|---|---|
LIBRARY_ID | SMALLINT | LIBRARY | LibraryId | java.math.BigDecimal | |||||||
NEXT_LIBRARY_ID | SMALLINT | LIBRARY | NextLibraryId | java.math.BigDecimal | |||||||
DISTANCE_KM | INTEGER | DistanceKm | java.math.BigDecimal | ||||||||
R_TIME | TIMESTAMP | CURRENT_TIMESTAMP | RTime | java.sql.Timestamp | |||||||
U_TIME | TIMESTAMP | CURRENT_TIMESTAMP | UTime | java.sql.Timestamp | |||||||
R_USER | VARCHAR | (50) | default-user | RUser | String | ||||||
U_USER | VARCHAR | (50) | default-user | UUser | String |
Name | Type of dbflute | PK | AutoInc | NotNull | Size | Default | ForeignTable | ReffererTable | CapPropName | Type of java | Classification |
---|---|---|---|---|---|---|---|---|---|---|---|
PUBLISHER_ID | INTEGER | GENERATED_BY_DEFAULT | BOOK | PublisherId | java.math.BigDecimal | ||||||
PUBLISHER_NAME | VARCHAR | (80) | PublisherName | String | |||||||
R_TIME | TIMESTAMP | CURRENT_TIMESTAMP | RTime | java.sql.Timestamp | |||||||
U_TIME | TIMESTAMP | CURRENT_TIMESTAMP | UTime | java.sql.Timestamp | |||||||
R_USER | VARCHAR | (50) | default-user | RUser | String | ||||||
U_USER | VARCHAR | (50) | default-user | UUser | String |