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