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