BOOK
Tables (4)
TB_BOOK (Untitled)
- BOOK_NO (Key) — VARCHAR2 — Primary key — NOT NULL
- PUBLISHER_NM (Key2) — VARCHAR2 — Foreign key → TB_PUBLISHER.PUBLISHER_NM — NOT NULL
- BOOK_NM (Field) — VARCHAR2
- ISBN (Field2) — VARCHAR2
- PAGE (Field3) — NUMBER
- PRICE (Field4) — NUMBER
- MAINCTG (Field5) — VARCHAR2
- SUBCTG (Field6) — VARCHAR2
- ISSUE_DATE (Field7) — DATE
- SALE_YN (Field8) — CHAR
- STOCK_QTY (Field9) — NUMBER
TB_BOOK_AUTHOR (Untitled2)
- WRITER_NO (Field2) — VARCHAR2 — Primary key
- BOOK_NO (Field) — VARCHAR2 — Primary key
- COMPOSE_TYPE (Field3) — VARCHAR2
TB_PUBLISHER (Untitled3)
- PUBLISHER_NM (Key) — VARCHAR2 — Primary key — NOT NULL
- PUBLISHER_TELNO (Field) — VARCHAR2
- DEAL_YN (Field2) — CHAR
TB_WRITER (Untitled4)
- WRITER_NO (Key) — VARCHAR2 — Primary key — NOT NULL
- WRITER_NM (Field) — VARCHAR2
- OFFICE_TELNO (Field2) — VARCHAR2
- HOME_TELNO (Field3) — VARCHAR2
- MOBILE_NO (Field4) — VARCHAR2
- EMAIL_ADDR (Field5) — VARCHAR2
- REGIST_DATE (Field6) — DATE