library

Tables (3)

History (history)

  • member_id (Key) — Foreign key → Membership.member_id — NOT NULL
  • book_id (Key2) — integer — Foreign key → book.book_id — NOT NULL
  • rent (Field) — date
  • return (Field2) — date

Membership (membership)

  • member_id (Key) — Primary key — NOT NULL
  • name (Field) — varchar(50)
  • phone_number (Field2) — varchar(100)
  • address (Field3) — varchar(200)
  • age (Field4) — int
  • member_pw (Field5) — varchar(100)

book

  • book_id (Key) — integer — Primary key — NOT NULL
  • title (Field) — varchar(100)
  • author (Field2) — varchar(50)
  • pub (Field3) — varchar(100)
  • pub_date (Field4) — date