Library
Tables (6)
TB_LIBRARY
- REG_NO — VARCHAR — Primary key — NOT NULL
- STATUS_CD — INT — Foreign key → TB_LIB_STATUS.STATUS_CD — NOT NULL
- LOCATION — VARCHAR
- REF_ROOM — VARCHAR
- BOOK_NAME — VARCHAR
- AUTHOR — VARCHAR
- PUBLISHER — VARCHAR
- YR_PUBLICATION — VARCHAR
- CALL_SIGN — VARCHAR
- REF_DATE — DATE
- CREATE_DATE — DATETIME
- UPDATE_DATE — DATETIME
TB_LIB_MANAGER
- ID — INT — Foreign key → TB_USER_MST.ID — NOT NULL
- USER_ID — VARCHAR — Foreign key → TB_USER_MST.USER_ID
- REG_NO — VARCHAR — Foreign key → TB_LIBRARY.REG_NO — NOT NULL
- RENT_CD — INT — Foreign key → TB_RENT_CD.RENT_CD
- STATUS_CD — INT — Foreign key → TB_LIBRARY.STATUS_CD — NOT NULL
- RENT_DATE — DATETIME
- RETURN_DATE — DATETIME
TB_LIB_STATUS
- STATUS_CD — INT — Primary key — NOT NULL
- STATUS_TYPE — VARCHAR
TB_RENT_CD
- RENT_CD — INT — Primary key
- REG_NO — VARCHAR — Foreign key → TB_LIBRARY.REG_NO — NOT NULL
- STATUS_CD — INT — Foreign key → TB_LIBRARY.STATUS_CD — NOT NULL
- RENT_TYPE — VARCHAR
TB_USER_DTL
- ID — INT — Foreign key → TB_USER_MST.ID — NOT NULL
- USER_ID — VARCHAR — Foreign key → TB_USER_MST.USER_ID
- USER_GENDER — VARCHAR
- USER_BIRTHDAY — VARCHAR
- USER_PHONE — VARCHAR
- USER_ADDR — VARCHAR
- MEMBER_LIB — VARHCAR
- HOME_PHONE — VARHCAR
TB_USER_MST
- ID — INT — Primary key — NOT NULL
- USER_ID — VARCHAR — Primary key
- USER_NAME — VARCHAR
- USER_PASSWORD — VARCHAR
- USER_EMAIL — VARHCAR
- USER_PROVIDER — VARCHAR
- USER_ROLE — VARCHAR
- OAUTH2_USERNAME — VARCHAR
- CREATE_DATE — DATETIME
- UPDATE_DATE — DATETIME