zanchi
Tables (9)
Clip (clip)
- clip_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → User.user_id — NOT NULL
- video_url — VARCHAR
- caption — VARCHAR
- like_count — INT
- created_at — DATETIME
Comment (comment)
- comment_id — INT — Primary key — NOT NULL
- clip_id — INT — Foreign key → Clip.clip_id — NOT NULL
- user_id — INT — Foreign key → Clip.user_id — NOT NULL
- content — VARCHAR
- created_at — DATETIME
- parent_id (id) — INT — Foreign key → Comment.comment_id — NOT NULL
Follow (follow)
- follower_id — INT — Primary key — NOT NULL
- following_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → User.user_id — NOT NULL
- created_at — DATETIME
Like (like)
- like_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → User.user_id — NOT NULL
- clip_id — INT — Foreign key → Clip.clip_id — NOT NULL
- created_at — DATETIME
Preference (preference)
- pref_id — INT — Primary key — NOT NULL
- name — VARCHAR
Reservation (reservation)
- reservation_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → User.user_id — NOT NULL
- show_id — INT — Foreign key → Show.show_id — NOT NULL
- total_price — INT
- point_used — INT
- created_at — DATETIME
Show (show)
- show_id — INT — Primary key — NOT NULL
- title — VARCHAR
- date — DATETIME
- venue — VARCHAR
- poster_url — VARCHAR
- description — VARCHAR
User (user)
- user_id — INT — Primary key — NOT NULL
- email — VARCHAR — NOT NULL
- password — VARCHAR — NOT NULL
- nickname — VARCHAR
- phone_number — VARCHAR
- preference
- point — INT
- created_at — DATETIME
UserPreference (userPreference)
- user_id — INT — Foreign key → User.user_id — NOT NULL
- pref_id — INT — Foreign key → Preference.pref_id — NOT NULL