ERD
테이블 (17)
Copy Of Untitled (curator_like)
- Key (like_id) — BIGINT — 기본 키 — NOT NULL
- ID (curator_id) — BIGINT — 외래 키 — NOT NULL
- Key (member_id) — BIGINT — 외래 키 → 사용자.Key — NOT NULL
- Key (member_id2) — BIGINT — 외래 키 → 큐레이터.Key — NOT NULL
Event (event)
- Key (event_id) — BIGINT — 기본 키 — NOT NULL
- Field (title) — VARCHAR
- Field (content) — VARCHAR(65536)
- Field (area) — VARCHAR
- Field (latitude) — DOUBLE
- Field (longitude) — DOUBLE
- Field2 (detail_address) — STRING
- Field (start_time) — DATETIME
- Field (end_time) — DATETIME
- Field (price) — INT
- Field (total_seats) — INT
- Field (left_seats) — INT
- Field (category) — VARCHAR
- Field (thumbnail_url) — BOOLEAN
- Field (host_id) — BIGINT
Untitled (advertisement)
- Key (advertisement_id) — BIGINT — 기본 키 — NOT NULL
- Field (title) — VARCHAR
- Field2 (advertisement_image_id) — BIGINT
- Field3 (start_time) — DATETIME
- Field (end_time) — DATETIME
Untitled (member_image)
- Key (member_image_id) — BIGINT — 기본 키 — NOT NULL
- Field (name) — VARCHAR
- Field (size) — BIGINT
- Field2 (extension) — VARCHAR
- Field3 (created_date) — DATETIME
- Key (abs_member_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
Untitled (event_image)
- Key (event_image_id) — BIGINT — 기본 키 — NOT NULL
- Field (name) — VARCHAR
- Field (size) — BIGINT
- Field2 (extension) — VARCHAR
- Field3 (created_date) — DATETIME
- Key (event_id) — BIGINT — 외래 키 → Event.Key — NOT NULL
Untitled (advertisement_image)
- Key (advertisement_image_id) — BIGINT — 기본 키 — NOT NULL
- Field (name) — VARCHAR
- Field (size) — BIGINT
- Field2 (extenstion) — BIGINT
- Field2 (created_date) — VARCHAR
- Key (advertisement_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
Untitled (curation_card_image)
- Key (curation_image_id) — BIGINT — 기본 키 — NOT NULL
- Field (name) — VARCHAR
- Field2 (size) — BIGINT
- Field3 (extension) — VARCHAR
- Field (created_date) — DATETIME
- Key (curation_card_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
Untitled (curation_card)
- Key (curation_card_id) — BIGINT — 기본 키 — NOT NULL
- Field (subtitle) — VARCHAR
- Field2 (content) — VARCHAR
- Key (curation_id) — BIGINT — 외래 키 → 큐레이션.Key — NOT NULL
Untitled (curation_event_relation)
- Key (curation_event_id) — BIGINT — 기본 키 — NOT NULL
- Key (event_id) — BIGINT — 외래 키 → Event.Key — NOT NULL
- Key (curation_id) — BIGINT — 외래 키 → 큐레이션.Key — NOT NULL
Untitled (base_member)
- Key (abs_member_id) — BIGINT — 기본 키 — NOT NULL
- Field (account_type) — ENUM
- Field (email) — VARCHAR
- Field (nickname) — VARCHAR
- Field2 (phone) — VARCHAR
- Field (profile_image_id) — BIGINT
- Field (member_type) — ENUM
Untitled (review)
- Key (review_id) — BIGINT — 기본 키 — NOT NULL
- Field (score) — VARCHAR
- Field (content) — VARCHAR
- Key (event_id) — BIGINT — 외래 키 → Event.Key — NOT NULL
- Key (member_id) — BIGINT — 외래 키 → 사용자.Key — NOT NULL
Untitled (host_like)
- Key (host_like_id) — BIGINT — 기본 키 — NOT NULL
- Key (host_id) — BIGINT — 외래 키 → 주최자.Key — NOT NULL
- Key (member_id) — BIGINT — 외래 키 → 사용자.Key — NOT NULL
Untitled (reservation)
- Key (reservation_id) — BIGINT — 기본 키 — NOT NULL
- Key (member_id) — BIGINT — 외래 키 → 사용자.Key — NOT NULL
- Key (event_id) — BIGINT — 외래 키 → Event.Key — NOT NULL
- Field (price) — INT
- Field (quantity) — DATETIME
- Field (reservation_date) — DATETIME
사용자 (member)
- Key (member_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
- 지역 (area) — VARCHAR — 지역
- 성별 (gender) — ENUM
- Field (social_id) — VARCHAR
- Field (refresh_token) — VARCHAR
주최자 (host)
- Key (host_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
- Field (hashed_password) — VARCHAR — hash화됨
- 자기소개 (intro) — VARCHAR — 자기소개
- Field (likes) — INT
- 해시태그 (hashtags) — VARCHAR — #a#b#c 형식으로 함축저장
- Key (event_id) — BIGINT — 외래 키 → Event.Key — NOT NULL
큐레이션 (curation)
- Key (curation_id) — BIGINT — 기본 키 — NOT NULL
- Field (title) — VARCHAR
- Field (content) — VARCHAR
- Field3 (area) — VARCHAR
- Field (hashtag) — VARCHAR
- Field (thumbnailUrl) — VARCHAR
- Field (created_date) — DATETIME
- Field (modified_date) — DATETIME
큐레이터 (curator)
- Key (curator_id) — BIGINT — 외래 키 → 사용자.Key — NOT NULL
- 자기소개 (intro) — VARCHAR
- 팔로워수 (likes) — INT — 큐레이터 팔로워수
- Field (hashtags) — VARCHAR