ㅇㅇ
Tables (7)
Favorite
- favorite_no — INT
- user_no — INT
- festival_no — INT
- favorite_date — DATETIME
Festival
- festival_no — INT
- addr — VARCHAR(200)
- title — VARCHAR(100)
- mapx — FLOAT
- mapy — FLOAT
- event_startdate — DATETIME
- event_enddate — DATETIME
- playtime — VARCHAR(50)
- is_active — BOOLEAN
Festival_detail
- festival_no — INT
- infotext_1 — TEXT
- infotext_2 — TEXT
- host — VARCHAR(200)
- host_tel — VARCHAR(50)
- homepage — VARCHAR(300)
- festival_fee — VARCHAR(200)
Festival_image
- image_no — INT
- festival_no — INT
- image_url — VARCHAR(100)
Festival_tag
- festival_tag_no — INT
- festival_no — INT
- tag — VARCHAR(30)
Member
- user_no — INT
- user_id — VARCHAR(50)
- password — VARCHAR(255)
- name — VARCHAR(50)
- email — VARCHAR(100)
- phone — VARCHAR(20)
- gender — CHAR(1)
- birth_date — DATE
- join_date — DATETIME
- role — VARCHAR(20)
- is_active — BOOLEAN
- withdraw_date — DATETIME
- favorite_tag — VARCHAR(100)
Review
- review_no — INT
- user_no — INT
- festival_no — INT
- rating — INT
- content — VARCHAR(1000)
- created_at — DATETIME
- updated_at — DATETIME