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