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)