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