후즈북 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