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)