red

Tables (6)

Festival

  • festival_id — int — Primary key — NOT NULL
  • festival_name — varchar(100)
  • festival_location (festival_description) — text
  • Field3 (festival_startdate) — int
  • Field (festival_enddate) — int
  • Field (festival_keyword) — varchar(100)

Untitled (Review)

  • Key (review_id) — int — Primary key — NOT NULL
  • festival_id — int — Foreign key → Festival.festival_id — NOT NULL
  • Field (rating(별점)) — int
  • Field (content) — varchar
  • Field2 (review_pic) — formdata
  • Field3 (review_createddate) — int
  • Field (review_modifieddate) — int

Untitled (Bookmark)

  • Key (bookmark_id) — int — Primary key — NOT NULL
  • user_id — int — Foreign key → User.user_id — NOT NULL
  • festival_id (festival_id2) — int — Foreign key → Festival.festival_id — NOT NULL

Untitled (User_Keyword)

  • Key (keyword_id) — int — Primary key — NOT NULL
  • user_id — int — Foreign key → User.user_id — NOT NULL

Untitled (AI_Recommendation)

  • Field (result) — int — Primary key
  • festival_id — int — Foreign key → Festival.festival_id — NOT NULL
  • Key (keyword_id) — int — Foreign key → Untitled.Key — NOT NULL
  • user_id — int — Foreign key → Untitled.user_id — NOT NULL

User

  • user_id — int — Primary key — NOT NULL
  • user_password (user_name) — varchar(100)
  • user_name (user_password) — varchar(100)