erd

Tables (3)

ELBOOKCOPY (사본정보관리)

  • BOOKID (Key2) — Foreign key → ELBOOKMASTER.BOOKID — NOT NULL
  • USERID (Field2)
  • BOOKSEQ (Field3)
  • REGYMD (Field4)
  • BOOKSTATUSCD (Field5)
  • ACCDTYMD (Field6)
  • BOOKBARCODE (Field7)

ELBOOKMASTER (도서정보관리)

  • BOOKID (Key2) — Primary key — NOT NULL
  • CLASSCD (책분류코드) — Foreign key → ELCODEMNG.CD — NOT NULL
  • USERID (Field2)
  • BOOKNM (Field3)
  • AUTHOR (Field4)
  • PUBLER (Field6)
  • PUBLYY (Field7)
  • PAGENO (Field8)
  • DOMESTABRDTYPE (Field9)
  • KEYWORD (Field10)
  • DESCRIPTION (Field11)
  • COVERIMAGE (Field12)

ELCODEMNG (도서코드관리)

  • CDCLASSCD (상위분류코드) — Primary key — NOT NULL
  • CD (책분류코드) — Primary key — NOT NULL
  • CDNM (하위코드명)