투표

테이블 (3)

admin

  • id — bigint(20) — 기본 키 — NOT NULL
  • created_at — datetime(3)
  • updated_at — datetime(3)
  • deleted_at — datetime(3)
  • grade — int(11)
  • username — varchar(16)
  • password — varchar(64)
  • name — varchar(24)
  • pwd_update_time — datetime(3)
  • pwd_expire_time — datetime(3)

contents

  • 컨탠츠 아이디 (id) — bigint(20) — 기본 키 — NOT NULL
  • created_at — datetime(3)
  • updated_at — datetime(3)
  • deleted_at — datetime(3)
  • is_view — tinyint(1)
  • category_id — bigint(20) — NOT NULL
  • mc_id — bigint(20)
  • video_type — tinyint(1)
  • user_count — int(11) — '최대 접속자 수'
  • view_count — int(11) — 'live: 최대 동접자, vod:클릭수'
  • ovp_user_count — int(11)
  • ovp_view_count — int(11)
  • comment_user — int(11) — 'live: 채팅 참여자, vod:댓글 참여자'
  • comment_count — int(11) — 'live: 채팅글, vod:댓글'
  • like_count — int(11) — '좋아요 글수'
  • live_count — int(11) — '라이브 실시간 동접수'
  • live_start_time — datetime(3)
  • live_end_time — datetime(3)
  • title — varchar(256)
  • content_type — varchar(4)
  • status — varchar(8)
  • description — text
  • curriculum — text
  • live_url — varchar(512)
  • live_mobile_url — varchar(512)
  • thumbnail — varchar(256)
  • file_name — varchar(1024)
  • duration — varchar(16)
  • media_key — varchar(24)
  • old_id — bigint(20) — 'migration용 아이디'
  • live_attach_id — bigint(20)
  • live_view_count — int(11)
  • is_free — tinyint(4)

user

  • id — bigint(20) — 기본 키 — NOT NULL
  • created_at — datetime(3)
  • updated_at — datetime(3)
  • deleted_at — datetime(3)
  • is_black — tinyint(1)
  • is_nick_set — tinyint(1)
  • is_prime_club — tinyint(1)
  • is_manager — tinyint(1)
  • login_date — datetime(3)
  • block_chat_date — datetime(3)
  • reg_block_chat_date — datetime(3)
  • nickname — varchar(24)
  • login_key — varchar(64)
  • live_count — int(11)
  • chat_count — int(11)
  • chat_write — int(11)
  • video_count — int(11)
  • like_count — int(11)
  • comment_count — int(11)
  • comment_write — int(11)
  • block_chat_count — int(11)
  • block_type — int(11)
  • block_reason — varchar(64)