초이스erd

테이블 (8)

Alarm

  • alarm_id — BIGINT — 기본 키 — NOT NULL
  • comment_id — BIGINT — 외래 키 → Comment.comment_id — NOT NULL
  • target_member_id — BIGINT — 외래 키 → Member.member_id — NOT NULL
  • is_read — TINYINT — NOT NULL
  • created_at — DATETIME — NOT NULL

Comment

  • comment_id — BIGINT — 기본 키 — NOT NULL
  • content — VARCHAR(500) — NOT NULL
  • like_count — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • member_id — BIGINT — 외래 키 → Member.member_id — NOT NULL
  • post_id — BIGINT — 외래 키 → Post.post_id — NOT NULL
  • parent_id — BIGINT — 외래 키 → Comment.comment_id
  • status — TINYINT — NOT NULL

Destination

  • destination_id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • country — VARCHAR(100) — NOT NULL
  • city — VARCHAR(100)
  • average_cost — INT — NOT NULL
  • feature — VARCHAR(50) — NOT NULL
  • is_domestic — TINYINT — NOT NULL
  • description — TEXT
  • created_at — DATETIME — NOT NULL

Like_Post

  • like_post_id — BIGINT — 기본 키 — NOT NULL
  • post_id — BIGINT — 외래 키 → Post.post_id — NOT NULL
  • member_id — BIGINT — 외래 키 → Member.member_id — NOT NULL
  • created_at — DATETIME — NOT NULL

MBTI_Preference

  • mbti_id — BIGINT — 기본 키 — NOT NULL
  • mbti_type — CHAR(4) — NOT NULL
  • lodging_weight — TINYINT — NOT NULL
  • food_weight — TINYINT
  • flight_weight — TINYINT — NOT NULL
  • shopping_weight — TINYINT — NOT NULL
  • activity_weight — TINYINT — NOT NULL
  • sightseeing_weight — TINYINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

Member

  • member_id — BIGINT — 기본 키 — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • login_id — VARCHAR(50) — NOT NULL
  • username — VARCHAR(50) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • mbti_id — BIGINT — 외래 키 → MBTI_Preference.mbti_id — NOT NULL

Post

  • post_id — BIGINT — 기본 키 — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • member_id — BIGINT — 외래 키 → Member.member_id — NOT NULL
  • status — TINYINT — NOT NULL

Travel_Place

  • place_id — BIGINT — 기본 키 — NOT NULL
  • destination_id — BIGINT — 외래 키 → Destination.destination_id — NOT NULL
  • category — VARCHAR(30) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • address — VARCHAR(255)
  • estimated_cost — INT — NOT NULL
  • rating — DECIMAL(2,1)
  • created_at — DATETIME — NOT NULL