UMC

Tables (3)

book (Untitled)

  • PK (id) — bigint — Primary key — NOT NULL
  • (name) — varchar(20)
  • (created_at) — datetime(6)
  • (updated_at) — datetime(6)

member (Untitled2)

  • PK (phone_num) — varchar(10) — Primary key — NOT NULL
  • (name) — varchar(20)
  • (nickname) — varchar(20)
  • (gender) — varchar(20)
  • (created_at) — datetime(6)
  • (updated_at) — datetime(6)
  • (status) — varchar(20)
  • (inactive_date) — datetime

rent (Untitled3)

  • PK (id) — bigint — Primary key — NOT NULL
  • FK (member_id) — bigint — Primary key — NOT NULL
  • FK (book_id) — bigint — Primary key — NOT NULL
  • PK (id2) — bigint — Foreign key → book.PK — NOT NULL
  • (created_at) — datetime(6)
  • (updated_at) — datetime(6)