투표
테이블 (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)