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