BOOK

Tables (3)

bookjoin (Untitled)

  • Key (id) — VARCHAR2(50) — Primary key — NOT NULL
  • Field2 (pw) — VARCHAR2(50)
  • Field (name) — VARCHAR2(50)
  • Field (email) — VARCHAR2(100)
  • Field (age) — NUMBER(3)
  • Field (reg_date) — DATE
  • Field (phon) — VARCHAR2(20)

booklist (Untitled2)

  • Key (cnumber) — VARCHAR2(20) — Primary key — NOT NULL
  • Field (title) — VARCHAR2(100)
  • Field2 (author) — VARCHAR2(100)
  • Field3 (classify) — VARCHAR2(10)
  • Field (Initial_date) — DATE
  • Field (publisher) — VARCHAR2(50)
  • Key (id) — VARCHAR2(50) — Foreign key → librarian.Key — NOT NULL
  • Field (image) — VARCHAR2(50)

librarian (Untitled5)

  • Key (id) — VARCHAR2(50) — Primary key — NOT NULL
  • Field (pw) — VARCHAR2(50)
  • Field (name) — VARCHAR2(50)
  • Field2 (emp_num) — VARCHAR2(50)