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)