past
Tables (15)
comments
- id — INT
- review_id — INT
- user_id — INT
- content — TEXT
- created_at — DATETIME
- updated_at — DATETIME
email_verification
- id — INT
- email — VARCHAR(255)
- token — VARCHAR(255)
- user_id — VARCHAR(100)
- password — VARCHAR(255)
- real_name — VARCHAR(100)
- nickname — VARCHAR(100)
- gender — VARCHAR(10)
- dob — VARCHAR(20)
- tags — VARCHAR(255)
- created_at — DATETIME
festival_images
- id — INT
- festival_id — INT
- image — VARCHAR(255)
- uploaded_at — DATETIME
festivals
- id — INT
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- start_date — DATE
- end_date — DATE
- region — VARCHAR(50)
- detail_region — VARCHAR(50)
- latitude — DECIMAL(10,6)
- longitude — DECIMAL(10,6)
- fee — VARCHAR(50)
- organizer — VARCHAR(100)
- contact_phone — VARCHAR(20)
- website_url — VARCHAR(255)
- visitor_count — INT
- created_at — DATETIME
- updated_at — DATETIME
festivals_tags
- festival_id — INT
- tag_id — INT
inquiries
- id — INT
- user_id — INT
- title — VARCHAR(200)
- content — TEXT
- status — VARCHAR(20)
- created_at — DATETIME
inquiry_replies
- id — INT
- inquiry_id — INT
- admin_id — INT
- content — TEXT
- created_at — DATETIME
review_images
- id — INT
- review_id — INT
- image — VARCHAR(255)
- created_at — DATETIME
reviews
- id — INT
- festival_id — INT
- user_id — INT
- rating — INT
- content — TEXT
- created_at — DATETIME
- updated_at — DATETIME
shortform_images
- id — INT
- shortform_id — INT
- image — VARCHAR(255)
- uploaded_at — DATETIME
shortforms
- id — INT
- festival_id — INT
- user_id — INT
- title — VARCHAR(100)
- frame_color — VARCHAR(30)
- created_at — DATETIME
tags
- id — INT
- name — VARCHAR(50) — NOT NULL
users
- id — INT
- user_id — VARCHAR(100) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(100) — NOT NULL
- real_name — VARCHAR(100) — NOT NULL
- phone_number — VARCHAR(20)
- is_active — BOOLEAN
- is_staff — BOOLEAN
- login_type — VARCHAR(30)
- social_id — VARCHAR(50)
- gender — VARCHAR(10)
- dob — VARCHAR(20)
- date_joined — DATETIME
users_tags
- user_id — INT
- tag_id — INT
wishlist
- id — INT
- user_id — INT
- festival_id — INT
- notify — BOOLEAN
- added_date — DATETIME