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 (하위코드명)