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