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