Library
Tables (7)
book (책)
- ID (Key) — bigint — Primary key — NOT NULL
- name (Field) — varchar(40)
- description (Field2) — text
- created_at (Field3) — datetime(6)
- updated_at (Field4) — datetime(6)
- category_id (Key3) — bigint — Foreign key → book_category.ID — NOT NULL
book_category (카테고리)
- ID (Key) — bigint — Primary key — NOT NULL
- name (Field) — varchar(20)
- created_at (Field2) — datetime(6)
- updated_at (Field3) — datetime(6)
book_hash_tag (책/해시태그)
- ID (Key) — bigint — Primary key — NOT NULL
- created_at (Field) — datetime(6)
- updated_at (Field2) — datetime(6)
- book_id (Key2) — bigint — Foreign key → book.ID — NOT NULL
- hash_tag_id (Key3) — bigint — Foreign key → hash_tag.ID — NOT NULL
book_likes (회원/책 좋아요)
- ID (Key) — bigint — Primary key — NOT NULL
- created_at (Field) — datetime(6)
- updated_at (Field2) — datetime(6)
- member_id (Key2) — bigint — Foreign key → member.ID — NOT NULL
- book_id (Key3) — bigint — Foreign key → book.ID — NOT NULL
hash_tag (해시태그)
- ID (Key) — bigint — Primary key — NOT NULL
- name (Field3) — varchar(20)
- created_at (Field) — datetime(6)
- updated_at (Field2) — datetime(6)
member (회원정보)
- ID (Key) — bigint — Primary key — NOT NULL
- name (Field) — varchar(10) — NOT NULL
- nickname (Field2) — varchar(20)
- phone_no (Field3) — varchar(11)
- gender (Field4) — varchar(10) — NOT NULL
- kakao_id (Field5)
- created_at (Field6) — datetime(6)
- updated_at (Field7) — datetime(6)
- status (Field8) — varchar(15)
- inactive_date (Field9) — datetime
rent (대여)
- ID (Key) — bigint — Primary key — NOT NULL
- created_at (Field) — datetime(6)
- updated_at (Field2) — datetime(6)
- member_id (Key2) — bigint — Foreign key → member.ID — NOT NULL
- book_id (Key3) — bigint — Foreign key → book.ID — NOT NULL