| id |
int(11)
|
|
|
|
| user_id |
int(11)
|
|
|
|
| content |
text
|
utf8mb4_general_ci
|
|
|
| media_type |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| media_url |
varchar(500)
|
utf8mb4_general_ci
|
|
|
| visibility |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| views_count |
int(11)
|
|
|
|
| shares_count |
int(11)
|
|
|
|
| ad_placement |
enum('auto', 'pre_roll', 'mid_roll', 'none')
|
utf8mb4_general_ci
|
|
|
| video_title |
varchar(200)
|
utf8mb4_general_ci
|
|
|
| category |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| tags |
varchar(500)
|
utf8mb4_general_ci
|
|
|
| thumbnail_path |
varchar(500)
|
utf8mb4_general_ci
|
|
|
| ad_enabled |
tinyint(1)
|
|
|
|
| ad_positions |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| is_short |
tinyint(1)
|
|
|
|
| deletion_status |
enum('none', 'pending', 'denied')
|
utf8mb4_general_ci
|
|
|
| created_at |
timestamp
|
|
|
|
| is_pinned |
tinyint(1)
|
|
|
|
| edited_at |
datetime
|
|
|
|
| page_id |
int(11)
|
|
|
|
| moderation_status |
varchar(12)
|
utf8mb4_general_ci
|
|
|
| moderation_score |
tinyint(3)
|
|
|
|
| moderation_note |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| max_quality |
varchar(8)
|
utf8mb4_general_ci
|
|
|
| allow_download |
tinyint(1)
|
|
|
|
| audience |
varchar(8)
|
utf8mb4_general_ci
|
|
|