해커톤 5팀_erd

테이블 (6)

Festival

  • festival_id — int — 기본 키 — NOT NULL
  • name — VARCHAR(100)
  • description — text
  • image_path — VARCHAR(255)
  • ar_review (ai_review) — TEXT
  • created_at — DATETIME
  • updated_at — DATETIME

Post_review (Post_reviews)

  • post_id — INT — 기본 키 — NOT NULL
  • title — VARCHAR(100)
  • contentc (content) — TEST
  • created_at (created_id) — DATETIME
  • updated_at — DATETIME
  • user_id — VARCHAR(20) — 외래 키 → User.user_id — NOT NULL
  • festival_id — int — 외래 키 → Festival.festival_id — NOT NULL

User

  • user_id — VARCHAR(20) — 기본 키 — NOT NULL
  • password — VARCHAR(255)
  • nickname — VARCHAR(20)
  • birthday — DATE

bookmark

  • bookmark_id — INT — 기본 키 — NOT NULL
  • user_id — VARCHAR(20) — 외래 키 → User.user_id — NOT NULL
  • festival_id — int — 외래 키 → Festival.festival_id — NOT NULL

keyword (Keyword)

  • keyword_id — INT — 기본 키 — NOT NULL
  • keyword_name — VARCHAR(50)
  • image_path — VARCHAR(255)

keyword_user

  • user_keyword_id — INT — 기본 키 — NOT NULL
  • is_selected — BOOLEAN
  • user_id — VARCHAR(20) — 외래 키 → User.user_id — NOT NULL
  • keyword_id — INT — 외래 키 → keyword.keyword_id — NOT NULL