Library

Tables (3)

book (Untitled)

  • id (bigint(20)) — bigint(20) — Primary key — NOT NULL
  • create_date (datetime(6)) — datetime(6)
  • modify_date (Field2) — datetime(6)
  • author (Field) — varchar(255)
  • introduce (Field3) — varchar(255)
  • title (Field4) — varchar(255)
  • reg_member_id (Key) — bigint(20) — Foreign key → member.id — NOT NULL

checkout_history (Untitled3)

  • id (Key) — bigint(20) — Primary key — NOT NULL
  • create_date (Field) — datetime(6)
  • modify_date (Field2) — datetime(6)
  • checkout_date (Field3) — datetime(6)
  • return_date (Field4) — datetime(6)
  • book_id (bigint(20)) — bigint(20) — Foreign key → book.id
  • member_id (Key2) — bigint(20) — Foreign key → member.id

member (Untitled2)

  • id (Key) — bigint(20) — Primary key — NOT NULL
  • create_date (bigint(20)) — datetime(6)
  • modify_date (Field2) — datetime(6)
  • email (Field) — varchar(255)
  • password (Field3) — varchar(255)
  • username (Field4) — varchar(255)