test

Tables (4)

Book

  • Key — Primary key — NOT NULL
  • book_id — BIGINT — Primary key
  • title — VARCHAR(200) — NOT NULL
  • author — VARCHAR(100) — NOT NULL
  • isbn — VARCHAR(20)
  • published_year — INT
  • created_at — TIMESTAMP

Member

  • Key — Primary key — NOT NULL
  • member_id — BIGINT — Primary key
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(200) — NOT NULL
  • phone — VARCHAR(30)
  • created_at — TIMESTAMP

Rental

  • Key — Primary key — NOT NULL
  • rental_id — BIGINT — Primary key
  • member_id — BIGINT — Primary key — NOT NULL
  • Key (Key2) — Foreign key → Member.Key — NOT NULL
  • member_id (member_id2) — BIGINT — Foreign key → Member.member_id
  • book_id — BIGINT — NOT NULL
  • rental_date — DATE — NOT NULL
  • due_date — DATE — NOT NULL
  • return_date — DATE
  • status — VARCHAR(20) — NOT NULL

Untitled

  • Key — Primary key — NOT NULL
  • Key2 — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4