myerd
Tables (12)
ARTIST_PROFILES
- artist_id — VARCHAR2(36)
- user_id — VARCHAR2(36) — NOT NULL
- artist_name — VARCHAR2(100) — NOT NULL
- artist_description — CLOB
- debut_date — DATE
- agency — VARCHAR2(100)
- official_website — VARCHAR2(255)
- thumbnail_image — VARCHAR2(255)
- banner_image — VARCHAR2(255)
- followers_count — NUMBER(10) — NOT NULL
- stream_key — VARCHAR2(100)
- category_id — VARCHAR2(36)
- verification_status — VARCHAR2(20) — NOT NULL
BOARD_POSTS
- post_id — VARCHAR2(36)
- author_id — VARCHAR2(36) — NOT NULL
- title — VARCHAR2(200) — NOT NULL
- content — CLOB
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
- post_type — VARCHAR2(20) — NOT NULL
- thumbnail_image — VARCHAR2(255)
- view_count — NUMBER(10) — NOT NULL
- related_stream_id — VARCHAR2(36)
CATEGORIES
- category_id — VARCHAR2(36)
- category_name — VARCHAR2(100) — NOT NULL
- parent_category_id — VARCHAR2(36)
- description — VARCHAR2(500)
- icon_image — VARCHAR2(255)
- is_active — NUMBER(1) — NOT NULL
CHAT_MESSAGES
- message_id — VARCHAR2(36)
- stream_id — VARCHAR2(36) — NOT NULL
- user_id — VARCHAR2(36) — NOT NULL
- message_content — VARCHAR2(1000) — NOT NULL
- sent_at — TIMESTAMP — NOT NULL
- message_status — VARCHAR2(20) — NOT NULL
FOLLOWS
- follow_id — VARCHAR2(36)
- follower_id — VARCHAR2(36) — NOT NULL
- artist_id — VARCHAR2(36) — NOT NULL
- follow_date — TIMESTAMP — NOT NULL
- notification_enabled — NUMBER(1) — NOT NULL
NOTIFICATIONS
- notif_id — VARCHAR2(36)
- user_id — VARCHAR2(36) — NOT NULL
- notif_type — VARCHAR2(50) — NOT NULL
- content — VARCHAR2(500) — NOT NULL
- related_id — VARCHAR2(36)
- created_at — TIMESTAMP — NOT NULL
- is_read — NUMBER(1) — NOT NULL
- read_at — TIMESTAMP
STREAMS
- stream_id — VARCHAR2(36)
- artist_id — VARCHAR2(36) — NOT NULL
- title — VARCHAR2(200) — NOT NULL
- description — CLOB
- scheduled_start_time — TIMESTAMP
- actual_start_time — TIMESTAMP
- end_time — TIMESTAMP
- status — VARCHAR2(20) — NOT NULL
- thumbnail_image — VARCHAR2(255)
- view_count — NUMBER(10) — NOT NULL
- peak_concurrent_viewers — NUMBER(10) — NOT NULL
- stream_url — VARCHAR2(255)
STREAM_INTERACTIONS
- interaction_id — VARCHAR2(36)
- stream_id — VARCHAR2(36) — NOT NULL
- user_id — VARCHAR2(36) — NOT NULL
- interaction_type — VARCHAR2(20) — NOT NULL
- interaction_time — TIMESTAMP — NOT NULL
- data — VARCHAR2(1000)
STREAM_SETTINGS
- setting_id — VARCHAR2(36)
- user_id — VARCHAR2(36) — NOT NULL
- setting_name — VARCHAR2(100) — NOT NULL
- video_codec — VARCHAR2(20)
- audio_codec — VARCHAR2(20)
- video_bitrate — NUMBER(10)
- audio_bitrate — NUMBER(10)
- resolution — VARCHAR2(20)
- fps — NUMBER(3)
USERS
- user_id — VARCHAR2(36)
- email — VARCHAR2(100) — NOT NULL
- password — VARCHAR2(255) — NOT NULL
- username — VARCHAR2(50) — NOT NULL
- profile_image — VARCHAR2(255)
- bio — CLOB
- register_date — TIMESTAMP — NOT NULL
- last_login_date — TIMESTAMP
- account_status — VARCHAR2(20) — NOT NULL
- user_type — VARCHAR2(20) — NOT NULL
- postal_code — VARCHAR2(10)
- address — VARCHAR2(200)
- language_preference — VARCHAR2(10) — NOT NULL
VIEW_LOGS
- log_id — VARCHAR2(36)
- user_id — VARCHAR2(36) — NOT NULL
- stream_id — VARCHAR2(36) — NOT NULL
- start_time — TIMESTAMP — NOT NULL
- end_time — TIMESTAMP
- device_info — VARCHAR2(255)
- view_status — VARCHAR2(20) — NOT NULL
VOD
- vod_id — VARCHAR2(36)
- stream_id — VARCHAR2(36) — NOT NULL
- title — VARCHAR2(200) — NOT NULL
- description — CLOB
- created_at — TIMESTAMP — NOT NULL
- file_path — VARCHAR2(255) — NOT NULL
- duration — NUMBER(10) — NOT NULL
- file_size — NUMBER(20) — NOT NULL
- is_public — NUMBER(1) — NOT NULL
- thumbnail_image — VARCHAR2(255)
- view_count — NUMBER(10) — NOT NULL