후즈북 ERD

테이블 (12)

InfluencerCuration (influencer_curation)

  • infl_cura_id — int — 기본 키 — NOT NULL
  • infl_cura_title — varchar(30) — NOT NULL
  • infl_cura_content — varchar(3000) — NOT NULL
  • infl_cura_created_at — datetime

InfluencerTag (influencer_tag)

  • infl_cura_tag_id — int — 기본 키 — NOT NULL
  • infl_cura_tag_title — varchar(30) — NOT NULL

book

  • book_id — bigint — 기본 키 — NOT NULL
  • title — varchar(255) — NOT NULL
  • authors — varchar(255) — NOT NULL
  • thumbnail — text
  • url — text
  • isbn — varchar(255)
  • publisher — varchar(255)

book_curation

  • book_curation_id — bigint — 기본 키 — NOT NULL
  • book_id — bigint — 외래 키 → book.book_id — NOT NULL
  • curation_id (curation_id2) — bigint — 외래 키 → curation.curation_id — NOT NULL

category

  • category_id — bigint — 기본 키 — NOT NULL
  • name — varchar(30) — NOT NULL

curation

  • curation_id — bigint — 기본 키 — NOT NULL
  • member_id — bigint — 외래 키 → member.member_id — NOT NULL
  • category_id — bigint — 외래 키 → category.category_id — NOT NULL
  • title — varchar(255) — NOT NULL
  • content — text — NOT NULL
  • emoji — varchar(191)
  • visibility — varchar(150)
  • curation_status — varchar(150)
  • created_at — datetime
  • updated_at — datetime
  • curation_like_count — int

curation_image (CopyOfimage)

  • curation_image_id — bigint — 기본 키 — NOT NULL
  • curation_id — bigint — 외래 키 → curation.curation_id — NOT NULL
  • image_id (image_id2) — bigint — 외래 키 → image.image_id — NOT NULL

image

  • image_id — bigint — 기본 키 — NOT NULL
  • image_key — varchar(255) — NOT NULL
  • image_path — varchar(255) — NOT NULL

like

  • like_id — bigint — 기본 키 — NOT NULL
  • member_id — bigint — 외래 키 → member.member_id — NOT NULL
  • curation_id — bigint — 외래 키 → curation.curation_id — NOT NULL

member

  • member_id — bigint — 기본 키 — NOT NULL
  • email — varchar(20) — NOT NULL
  • nickname — varchar(20) — NOT NULL
  • password — varchar(40)
  • status — varchar(50)
  • created_at — datetime
  • updated_at — datetime
  • introduction — varchar(255)
  • image_url — varchar(255)
  • image_key (Field) — varchar(255)

reply

  • reply_id — bigint — 기본 키 — NOT NULL
  • member_id — bigint — 외래 키 → member.member_id — NOT NULL
  • curation_id — bigint — 외래 키 → curation.curation_id — NOT NULL
  • content — vachar(1000)
  • created_at — datetime
  • updated_at — datetime

subscribe

  • subscribe_id — bigint — 기본 키 — NOT NULL
  • subscribed_member — bigint — 외래 키 → member.member_id — NOT NULL
  • subscriber — bigint — 외래 키 → member.member_id — NOT NULL