ssafy_voicelegned
Tables (7)
album_users
- id — BIGINT
- album_id — BIGINT — Foreign key → albums.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- created_at — DATETIME — NOT NULL
album_videos
- id — BIGINT
- album_id — BIGINT — Foreign key → albums.id — NOT NULL
- video_id — BIGINT — Foreign key → videos.id — NOT NULL
- created_at — DATETIME — NOT NULL
albums
- id — BIGINT
- owner_id — BIGINT — Foreign key → users.id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
users
- id — BIGINT
- kakao_id — BIGINT — NOT NULL
- user_code — VARCHAR(20) — NOT NULL
- nickname — VARCHAR(100) — NOT NULL
- profile_image_url — VARCHAR(500)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
video_comments
- id — BIGINT
- album_video_id — BIGINT — Foreign key → album_videos.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
video_reactions
- id — BIGINT
- album_video_id — BIGINT — Foreign key → album_videos.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- emoji — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
videos
- id — BIGINT
- uploader_id — BIGINT — Foreign key → users.id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- video_url — VARCHAR(500) — NOT NULL
- thumbnail_url — VARCHAR(500)
- duration_sec — DECIMAL(10,3)
- subtitle_file_url — VARCHAR(500)
- vibration_file_url — VARCHAR(500)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL