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