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)