book_rental

Tables (5)

Untitled (reservation)

  • Key (resv_id) — BIGSERIAL — Primary key — NOT NULL
  • Key (member_id) — bigint(20) — Foreign key → Untitled2.Key — NOT NULL
  • book_id — bigint — Foreign key → books.book_id — NOT NULL

Untitled (book_info)

  • Key (isbn) — BIGSERIAL — Primary key — NOT NULL
  • Field (kdc) — varchar(10)
  • Field2 (author) — varchar(5)
  • Field3 (pub_date) — timestamp
  • Field (title) — varchar(10)
  • Field (publisher) — varchar(10)

Untitled2 (member)

  • Key (member_id) — BIGSERIAL — Primary key — NOT NULL
  • Field (name) — varchar(5)
  • Field (email) — varchar(16)
  • Field (password) — varchar(16)
  • Field (role) — varchar(5)
  • Field (address) — varchar(20) — NOT NULL
  • Field (phone) — varchar(11) — NOT NULL

books (book)

  • book_id — BIGSERIAL — Primary key — NOT NULL
  • Field (resv) — boolean
  • Key (isbn) — int — Foreign key → Untitled.Key — NOT NULL

rent_record

  • Key (rent_id) — BIGSERIAL — Primary key — NOT NULL
  • Field (rent_time) — timestamp — NOT NULL
  • Field (return_time) — timestamp
  • Key (member_id) — bigint(20) — Foreign key → Untitled2.Key — NOT NULL
  • book_id — bigint(20) — Foreign key → books.book_id — NOT NULL