Leafly
Tables (6)
Book (책)
- id (기본키) — BIGINT — Primary key — NOT NULL
- title (제목) — VARCHAR
- author (저자) — VARCHAR
- image_url (이미지) — VARCHAR
- publisher (출판사) — VARCHAR
- pub_date (출판일) — DATETIME
- description (요약) — VARCHAR
- cost_price (원가) — INT
- sale_price (할인가) — INT
- rank (평점) — DEMICAL
- genre (장르) — VARHCAR
- pages (쪽수) — INT
Book-Review (독후감)
- id (기본키) — BIGINT — Primary key — NOT NULL
- title (제목) — VARCHAR
- string (내용) — VARCHAR
- rank (평점) — DEMICAL
- member_id (member기본키) — BIGINT — Foreign key → Member.id — NOT NULL
Member (회원)
- id (기본키) — BIGINT — Primary key — NOT NULL
- email (이메일/아이디) — VARCHAR
- password (비밀번호) — VARCHAR
- name (이름) — VARCHAR
MemberBook (좋아요/아카이빙)
- id (기본키) — Primary key — NOT NULL
- liked (좋아요 표시) — BOOLEAN
- status (상태) — ENUM(
- member_id (member기본키) — BIGINT — Foreign key → Member.id — NOT NULL
- book_id (book기본키) — BIGINT — Foreign key → Book.id — NOT NULL
ReviewImage (독후감 이미지)
- id (기본키) — BIGINT — Primary key — NOT NULL
- image_url (이미지) — VARCHAR
- review_id (독후감 기본키) — BIGINT — Foreign key → Book-Review.id — NOT NULL
UserOnboarding (회원 온보딩)
- id (기본키) — Primary key — NOT NULL
- age (나이) — INT
- gender (성별) — VARCHAR
- genre (장르) — VARCHAR
- purpose (목적) — VARCHAR
- frequency (빈도) — VARHCAR
- member_id (회원 ID) — BIGINT — Foreign key → Member.id — NOT NULL