ivs

Tables (9)

live.broadcast_notice_history

  • id — BIGINT — Primary key
  • ivs_channel_id — BIGINT
  • content — TEXT — NOT NULL
  • created — DATETIME
  • updated — DATETIME

live.chat_settings

  • id — BIGINT — Primary key
  • ivs_channel_id — BIGINT
  • operation_name — VARCHAR(10) — NOT NULL
  • operation_background_color — VARCHAR(10)
  • client_name — VARCHAR(20)
  • client_background_color — VARCHAR(10)
  • influencer_name — VARCHAR(20)
  • influencer_background_color — VARCHAR(10)
  • operation_font_color — VARCHAR(10)
  • client_font_color — VARCHAR(10)
  • influencer_font_color — VARCHAR(10)
  • created — DATETIME
  • updated — DATETIME

live.chat_user_map

  • id — BIGINT — Primary key
  • user_idx — BIGINT
  • ivs_channel_id — BIGINT
  • type — VARCHAR(10) — NOT NULL
  • status — VARCHAR(10)
  • created — DATETIME
  • updated — DATETIME

live.forbidden_group

  • id — BIGINT — Primary key
  • user_idx — BIGINT
  • content — VARCHAR(15)
  • type — ENUM — NOT NULL
  • created — DATETIME
  • updated — DATETIME

live.forbidden_group_map

  • id — BIGINT — Primary key
  • ivs_channel_id — BIGINT
  • forbidden_group_idx — BIGINT — NOT NULL
  • created — DATETIME
  • updated — DATETIME

live.forbidden_word

  • id — BIGINT — Primary key
  • forbidden_group_idx — BIGINT
  • content — VARCHAR(15)
  • created — DATETIME
  • updated — DATETIME

live.forbidden_word_map

  • id — BIGINT — Primary key
  • ivs_channel_id — BIGINT
  • forbidden_word_idx — BIGINT — NOT NULL
  • forbidden_group_map_idx — BIGINT
  • created — DATETIME
  • updated — DATETIME

live.ivs_channel

  • id — BIGINT — Primary key — NOT NULL
  • user_idx — BIGINT
  • channel_name — VARCHAR(100)
  • stream_key — VARCHAR(100)
  • stream_key_arn — VARCHAR(100)
  • channel_arn — VARCHAR(100)
  • type — ENUM
  • ingest_endpoint — VARCHAR(100)
  • playback_url — VARCHAR(255)
  • chat_room_general_arn — VARCHAR(100) — NOT NULL
  • chat_room_vip_arn — VARCHAR(100)
  • stream_id — VARCHAR(50)
  • group_buying_shop_idx — BIGINT
  • vod_url — VARCHAR(255)
  • thumbnail_url — VARCHAR(255)
  • status — ENUM
  • is_on_air — VARCHAR(1)
  • live_start_time — DATETIME
  • live_end_time — DATETIME
  • vod_start_time — time
  • vod_end_time — time
  • download_url — VARCHAR(255)
  • created — DATETIME
  • updated — DATETIME

live.ivs_viewer_history

  • id — BIGINT — Primary key
  • ivs_channel_id — BIGINT
  • user_idx — BIGINT
  • join_time — DATETIME — NOT NULL
  • leave_time — DATETIME
  • status — VARCHAR(100)
  • created — DATETIME
  • updated — DATETIME