도서 대여 관리 app
테이블 (5)
book (Untitled2)
- id (Field) — bigint — 기본 키
- book_category_id (2) — bigint — 외래 키 → bookCategory.id — NOT NULL
- name (Field2) — varchar(20)
- description (Field4) — text
- created_at (Field3) — datatime(6)
- updated_at (Field5) — datatime(6)
bookCategory (Untitled)
- id — bigint — 기본 키 — NOT NULL
- name (Field) — archer(20)
- created_at (Field2) — datatime(6)
- updated_at (Field3) — datatime(6)
book_hash_tag (Untitled5)
- id (Key) — bigint — 기본 키 — NOT NULL
- id (Field) — bigint — 외래 키 → book.id
- book_category_id (2) — bigint — 외래 키 → book.book_category_id — NOT NULL
member (Untitled3)
- id (Key) — bigint — 기본 키 — NOT NULL
- phone_num (Field) — archer(15)
- name (Field2) — varchar(10)
- nickname (Field3) — varchar(20)
- gender (Field4) — archer(10)
- created_at (Field5) — datatime(6)
- updated_at (Field6) — datatime(6)
- status (Field7) — varchar(15)
- inactive_date (Field8) — datetime
rent (Untitled4)
- id (Field) — bigint — 기본 키 — NOT NULL
- book_id (Field2) — bigint — 외래 키 → book.id
- member_id (Key) — bigint — 외래 키 → member.id — NOT NULL
- book_category_id (22) — bigint — 외래 키 → book.book_category_id — NOT NULL
- created_at (Field4) — datetime(6)
- updated_at (Field5) — datetime(6)