연습
테이블 (5)
book (Untitled)
- book_id (Key) — 기본 키 — NOT NULL
- book_name (Field)
- book_description (Field2)
- created_at (Field3)
- updated_atd (Field4)
category (Untitled5)
- category_id (Key) — 기본 키 — NOT NULL
- category_name (Field)
likes (Untitled4)
- likes_id (Key) — 기본 키 — NOT NULL
- member_id (Key2) — 외래 키 → member.member_id — NOT NULL
- book_id (Key3) — 외래 키 → book.book_id — NOT NULL
- created_at (Field)
- updated_at (Field2)
member (Untitled2)
- member_id (Key) — 기본 키 — NOT NULL
- member_name (Field)
- member_nickname (Field2)
- member_gender (Field3)
- created_at (Field4)
- updated_at (Field5)
- status (Field6)
- inactive_date (Field7)
rent (Untitled3)
- rent_id (Key) — 기본 키 — NOT NULL
- book_id (Key2) — 외래 키 → book.book_id — NOT NULL
- member_id (Key3) — 외래 키 → member.member_id — NOT NULL
- created_at (Field)
- updated_at (Field2)