Diract

Tables (17)

feedback_tagged_users

  • id — VARCHAR(36) — NOT NULL
  • feedback_id — VARCHAR(36) — Foreign key → feedbacks.feedback_id — NOT NULL
  • user_id — VARCHAR(36) — Foreign key → users.user_id — NOT NULL

feedbacks

  • feedback_id — VARCHAR(36) — NOT NULL
  • content — TEXT — NOT NULL
  • author_id — VARCHAR(36) — Foreign key → users.user_id — NOT NULL
  • video_id — VARCHAR(36) — Foreign key → videos.video_id — NOT NULL
  • start_time — DOUBLE
  • end_time — DOUBLE
  • image_url — VARCHAR(512)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

formation (Untitled)

  • Key — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4
  • Field5

inquiries

  • inquiry_id — VARCHAR(36) — NOT NULL
  • content — TEXT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • user_id — VARCHAR(36) — Foreign key → users.user_id — NOT NULL
  • user_name — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

invites

  • invite_id — VARCHAR(36) — NOT NULL
  • token — VARCHAR(36) — NOT NULL
  • teamspace_id — VARCHAR(36) — Foreign key → teamspaces.teamspace_id — NOT NULL
  • inviter_id — VARCHAR(36) — Foreign key → users.user_id — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • uses — INT — NOT NULL
  • expires_at — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

notifications

  • notification_id — VARCHAR(36) — NOT NULL
  • type — VARCHAR(50) — NOT NULL
  • content — TEXT — NOT NULL
  • sender_id — VARCHAR(36) — Foreign key → users.user_id — NOT NULL
  • target_type — VARCHAR(20) — NOT NULL
  • target_id — VARCHAR(36) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

projects

  • project_id — VARCHAR(36) — NOT NULL
  • project_name — VARCHAR(100) — NOT NULL
  • creator_id — VARCHAR(36) — Foreign key → users.user_id — NOT NULL
  • teamspace_id — VARCHAR(36) — Foreign key → teamspaces.teamspace_id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

refresh_tokens

  • id — VARCHAR(36) — NOT NULL
  • user_id — VARCHAR(36) — Foreign key → users.user_id — NOT NULL
  • token — VARCHAR(512) — NOT NULL
  • expires_at — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

replies

  • reply_id — VARCHAR(36) — NOT NULL
  • content — TEXT — NOT NULL
  • author_id — VARCHAR(36) — Foreign key → users.user_id — NOT NULL
  • feedback_id — VARCHAR(36) — Foreign key → feedbacks.feedback_id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

reply_tagged_users

  • id — VARCHAR(36) — NOT NULL
  • reply_id — VARCHAR(36) — Foreign key → replies.reply_id — NOT NULL
  • user_id — VARCHAR(36) — Foreign key → users.user_id — NOT NULL

reports

  • report_id — VARCHAR(36) — NOT NULL
  • type — VARCHAR(50) — NOT NULL
  • report_content_type — VARCHAR(50)
  • description — TEXT — NOT NULL
  • reporter_id — VARCHAR(36) — Foreign key → users.user_id — NOT NULL
  • reported_id — VARCHAR(36)
  • status — VARCHAR(20) — NOT NULL
  • target_type — VARCHAR(50) — NOT NULL
  • target_id — VARCHAR(36) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

teamspace_members

  • id — VARCHAR(36) — NOT NULL
  • teamspace_id — VARCHAR(36) — Foreign key → teamspaces.teamspace_id — NOT NULL
  • user_id — VARCHAR(36) — Foreign key → users.user_id — NOT NULL
  • joined_at — TIMESTAMP — NOT NULL

teamspaces

  • teamspace_id — VARCHAR(36) — NOT NULL
  • teamspace_name — VARCHAR(100) — NOT NULL
  • owner_id — VARCHAR(36) — Foreign key → users.user_id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

tracks

  • track_id — VARCHAR(36) — NOT NULL
  • project_id — VARCHAR(36) — Foreign key → projects.project_id — NOT NULL
  • video_id — VARCHAR(36) — Foreign key → videos.video_id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

user_notifications

  • id — VARCHAR(36) — NOT NULL
  • notification_id — VARCHAR(36) — Foreign key → notifications.notification_id — NOT NULL
  • user_id — VARCHAR(36) — Foreign key → users.user_id — NOT NULL
  • is_read — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

users

  • user_id — VARCHAR(36) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • login_type — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • terms_agreed — BOOLEAN — NOT NULL
  • privacy_agreed — BOOLEAN — NOT NULL
  • last_login_at — TIMESTAMP
  • fcm_token — VARCHAR(255)
  • country — VARCHAR(10)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

videos

  • video_id — VARCHAR(36) — NOT NULL
  • video_title — VARCHAR(255) — NOT NULL
  • video_url — VARCHAR(512) — NOT NULL
  • thumbnail_url — VARCHAR(512)
  • uploader_id — VARCHAR(36) — Foreign key → users.user_id — NOT NULL
  • video_duration — BIGINT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP