WebsiteERD
Tables (7)
Appendix (Untitled6)
- code (Key) — VARCHAR(20) — Primary key — NOT NULL
- name (Field) — VARCHAR(50) — NOT NULL
- isbn (Key2) — BIGINT(10) — Foreign key → BookInfo.isbn — NOT NULL
Book (Untitled3)
- book_serial_no (Key) — BIGINT(10) — Primary key — NOT NULL
- reserved (Field) — BOOLEAN — NOT NULL
- isbn (Key2) — BIGINT(10) — Foreign key → BookInfo.isbn — NOT NULL
- id (Key3) — BIGINT(10) — Foreign key → LendInfo.id — NOT NULL
BookInfo (Untitled4)
- isbn (Key) — BIGINT(10) — Primary key — NOT NULL
- author (Field) — VARCHAR(50) — NOT NULL
- publisher (Field2) — VARCHAR(50) — NOT NULL
- title (Field3) — VARCHAR(50) — NOT NULL
- date_published (Field4) — DATETIME — NOT NULL
- symbol (Key2) — VARCHAR(20) — Foreign key → Classification.symbol — NOT NULL
Classification (Untitled5)
- symbol (Key) — VARCHAR(20) — Primary key — NOT NULL
- name (Field) — VARCHAR(50) — NOT NULL
LendInfo (Untitled2)
- id (Key) — BIGINT(10) — Primary key — NOT NULL
- lend_date (Field) — DATETIME — NOT NULL
- return_date (Field2) — DATETIME — NOT NULL
- appendix_lent (Field3) — BOOLEAN — NOT NULL
- extended (Field4) — BOOLEAN — NOT NULL
- member_id (Key2) — BIGINT(10) — Foreign key → Member.id — NOT NULL
Member (Untitled)
- id (Key) — BIGINT(10) — Primary key — NOT NULL
- username (Field) — VARCHAR(50) — NOT NULL
- res_reg_number (Field2) — VARCHAR(50) — NOT NULL
- member_class (Field3) — INTEGER — NOT NULL
- address (Field4) — VARCHAR(100 — NOT NULL
- phone_no (Field5) — VARCHAR(50) — NOT NULL
- email (Field6) — VARCHAR(50) — NOT NULL
Reservation (Untitled7)
- date (Key) — DATETIME — Primary key — NOT NULL
- member_id (Key2) — BIGINT(10) — Foreign key → Member.id — NOT NULL
- book_serial_no (Key3) — BIGINT(10) — Foreign key → Book.book_serial_no — NOT NULL