book

Tables (3)

Untitled (rental)

  • Key (rental_id) — bigint — Primary key — NOT NULL
  • Field (created_at) — date — NOT NULL
  • Field (modified_at) — date — NOT NULL
  • Field (due_date) — date — NOT NULL
  • Field (is_returned) — bit(1) — NOT NULL
  • Field (returned_date) — date — NOT NULL
  • Key (member_id) — bigint — Foreign key → Untitled2.Key — NOT NULL
  • Key (book_id) — bigint — Foreign key → book.Key — NOT NULL

Untitled2 (member)

  • Key (member_id) — bigint — Primary key — NOT NULL
  • Field (created_at) — datetime — NOT NULL
  • Field (modified_at) — date — NOT NULL
  • Field (address) — varchar — NOT NULL
  • Field (gender) — varchar — NOT NULL
  • Field (name) — varchar — NOT NULL
  • Field (phone_nember) — varchar — NOT NULL
  • Field (resident_registration_number) — varchar — NOT NULL

book

  • Key (book_id) — bigint — Primary key — NOT NULL
  • Field (language) — varchar — NOT NULL
  • Field (publisher) — varchar — NOT NULL
  • Field (title) — varchar(100) — NOT NULL
  • Field (writer) — varchar — NOT NULL
  • Field (created_at) — date — NOT NULL
  • Field (modified_at) — date — NOT NULL
  • Field (is_avaliable) — bit(1) — NOT NULL