BlaBlaENM
Tables (49)
active_admin_comments
- id — bigint — Primary key — NOT NULL
- namespace — varchar(255)
- body — text
- resource_type — varchar(255)
- resource_id — bigint
- author_type — varchar(255)
- author_id — bigint
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
admin_push_users
- id — bigint — Primary key — NOT NULL
- admin_push_id — bigint — NOT NULL
- user_id — bigint — NOT NULL
- created_at — datetime
admin_pushes
- id — bigint — Primary key — NOT NULL
- admin_user_id — bigint — NOT NULL
- update_admin_user_id — bigint
- kind — varchar(255) — NOT NULL
- push_title — varchar(255)
- push_msg — varchar(255) — NOT NULL
- push_data — varchar(255)
- is_to_all_users — tinyint(1)
- status — varchar(255) — NOT NULL
- reservation_at — datetime — NOT NULL
- sent_at — datetime
- created_at — datetime
admin_users
- id — bigint — Primary key — NOT NULL
- email — varchar(255) — NOT NULL
- encrypted_password — varchar(255) — NOT NULL
- reset_password_token — varchar(255)
- reset_password_sent_at — datetime
- remember_created_at — datetime
- sign_in_count — int — NOT NULL
- current_sign_in_at — datetime
- last_sign_in_at — datetime
- current_sign_in_ip — varchar(255)
- last_sign_in_ip — varchar(255)
- name — varchar(255)
- phone — varchar(255)
- kind — varchar(255)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
advertisements
- id — bigint — Primary key — NOT NULL
- admin_user_id — bigint
- update_admin_user_id — bigint
- title — varchar(255)
- img_file_name — varchar(255)
- audio_content_type — varchar(255)
- audio_file_size — int
- audio_updated_at — datetime
- img_content_type — varchar(255)
- img_file_size — int
- img_updated_at — datetime
- audio_file_name — varchar(255)
- start_at — datetime
- end_at — datetime
- time_start_at — varchar(255)
- time_end_at — varchar(255)
- day_of_weeks — text
- ages — text
- genders — text
- end_kind — varchar(255)
- scheme_kind — varchar(255)
- scheme — varchar(255)
- click_count — int
- visible — tinyint(1)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
agora_recording_designated_users
- id — int — Primary key — NOT NULL
- admin_user_id — int
- update_admin_user_id — int
- user_id — int
- enable — tinyint(1)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
agora_recordings
- id — int — Primary key — NOT NULL
- bla_id — int — NOT NULL
- resource_id — mediumtext
- sid — varchar(255)
- file_url — varchar(255)
- records_add_upload_yn — varchar(45)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
announcements
- id — bigint — Primary key — NOT NULL
- user_id — bigint
- content — text
- visible — tinyint(1)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
application_forms
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- title — varchar(255)
- img_file_name — varchar(255)
- img_content_type — varchar(255)
- img_file_size — int
- img_updated_at — datetime
- description — text
- apply_start_at — datetime
- apply_end_at — datetime
- active_start_at — datetime
- active_end_at — datetime
- max_recruit — int
- bla_show_time — int
- bla_show_count — int
- is_name — tinyint(1)
- is_phone — tinyint(1)
- is_bla_show_title — tinyint(1)
- is_saying — tinyint(1)
- is_personal_agreement — tinyint(1)
- personal_agreement_content — text
- is_marketing_agreement — tinyint(1)
- marketing_agreement_content — text
- is_attach_file — tinyint(1)
- support_fund_guide — text
- admin_user_id — bigint
- is_bla_show_intro — tinyint(1)
- is_bla_show_times — tinyint(1)
- bla_show_times_count — int
- update_admin_user_id — bigint
- attach_file_placeholder — varchar(255)
- is_use — tinyint(1)
- applycount — int
- applysendcount — int
- applypasscount — int
ar_internal_metadata
- key — varchar(255) — Primary key — NOT NULL
- value — varchar(255)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
banners
- id — bigint — Primary key — NOT NULL
- admin_user_id — bigint
- update_admin_user_id — bigint
- user_id — bigint
- kind — varchar(255)
- title — varchar(255)
- img_file_name — varchar(255)
- img_content_type — varchar(255)
- img_file_size — int
- img_updated_at — datetime
- start_at — datetime
- end_at — datetime
- time_start_at — varchar(255)
- time_end_at — varchar(255)
- day_of_weeks — text
- ages — text
- genders — text
- scheme_kind — varchar(255)
- scheme — varchar(255)
- priority — int
- visible — tinyint(1)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
bla_anonymities
- id — bigint — Primary key — NOT NULL
- bla_id — bigint
- remote_ip — varchar(255)
- count — int
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
bla_badge_users
- id — int — Primary key — NOT NULL
- admin_user_id — int
- update_admin_user_id — int
- user_id — int — NOT NULL
- bla_badge_id — int — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
bla_badges
- id — int — Primary key — NOT NULL
- admin_user_id — int
- update_admin_user_id — int
- title — varchar(45) — NOT NULL
- img_file_name — varchar(255)
- img_content_type — varchar(255)
- img_file_size — int
- img_updated_at — datetime
- priority — int — 노출우선순위
- visible — tinyint(1) — 노출여부
- is_eternal — tinyint(1) — 영구노출여부
- visible_start_at — datetime — 노출시작일시
- visible_end_at — datetime — 노출종료일시
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
bla_contents
- id — int — Primary key — NOT NULL
- admin_user_id — int
- update_admin_user_id — int
- user_id — int — 해당 콘텐츠를 진행하는 유저id
- title — varchar(255)
- bla_kind — varchar(45)
- description — varchar(255) — 어떤 컨텐츠 인지 간단한 설명
- img_file_name — varchar(255)
- img_content_type — varchar(255)
- img_file_size — varchar(255)
- img_updated_at — varchar(255)
- link_url — varchar(255) — 연결할 url
- start_at — datetime(6) — 게시 시작 시간
- end_at — datetime(6) — 게시 종료시간
- priority — int — 노출 우선순위
- visible — tinyint(1) — 노출여부
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
bla_histories
- id — bigint — Primary key — NOT NULL
- user_id — bigint — NOT NULL
- bla_id — bigint — NOT NULL
- start_at — datetime — NOT NULL
- end_at — datetime
- duration_sec — bigint
- chat_count — bigint
- created_at — datetime
- updated_at — datetime
bla_invites
- id — bigint — Primary key — NOT NULL
- bla_id — bigint
- user_id — bigint
- content — text
- approve — tinyint(1)
- self_party_exit — tinyint(1)
- approve_user_id — bigint
- invite_user_id — bigint
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
bla_likes
- id — bigint — Primary key — NOT NULL
- bla_id — bigint
- user_id — bigint
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
bla_live_duration
- id — bigint — Primary key — NOT NULL
- user_id — bigint
- kind — varchar(255)
- yyyyMM — varchar(255)
- duration — int
- created_at — datetime — NOT NULL
- updated_at — datetime
bla_mall_buys
- id — int — Primary key — NOT NULL
- user_id — int — 콘텐츠를 구매한 유저ID
- bla_mall_content_id — int — 유저가 구매한 콘텐츠ID
- sponsor_user_id — int — 후원받는유저(bla_mall_content.user)
- pay_cookie — int — 유저가 실제로 지불한 쿠키 수
- company_pay_cookie — int — 회사가 지불한 쿠키수(할인받은 쿠키 수)
- discount_type — varchar(45) — 할인유형(all_contents: 모든 콘텐츠, all_users: 모든 유저, first_content: 첫 콘텐츠, first_buying: 첫 구매)
- discount_method — varchar(45) — 할인방식(percent: 할인율, minus: 할인수량, flat_price: 균일가)
- discount_cookie — int
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
bla_mall_categories
- id — int — Primary key — NOT NULL
- admin_user_id — int
- update_admin_user_id — int
- name — varchar(255)
- button_color — varchar(45) — 카테고리버튼 color code
- img_file_name — varchar(255)
- img_content_type — varchar(255)
- img_file_size — int
- img_updated_at — datetime
- visible — tinyint(1) — 유저 업로드폼 카테고리 노출여부
- priority — int — 노출우선순위
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
bla_mall_content_likes
- id — int — Primary key — NOT NULL
- user_id — int
- bla_mall_content_id — int
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
bla_mall_contents
- id — int — Primary key — NOT NULL
- user_id — int
- bla_mall_category_id — int
- first_yn — varchar(45) — 첫 콘텐츠 여부
- title — varchar(255)
- cover_image_path — varchar(255) — 대표 이미지path
- audio_file_path — varchar(255) — 오디오 파일path
- preview_audio_file_path — varchar(255) — 오디오원본파일30초컷 file_path
- duration — int — 재생시간(초)
- description — text — 콘텐츠 설명
- detail_image_path — varchar(255) — 상세 이미지path
- dynamic_link — varchar(255)
- cookie — int
- option — varchar(45) — 출시옵션(ALL(모두), SUBSCRIBE(구독자전용))
- status — varchar(45) — 상태(content_release(출시중), content_stop(출시중단), content_suspend(강제중지), content_delete(삭제))
- like_count — int — 좋아요 수
- play_count — int — 재생 수
- buy_count — int — 소장된 수
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
bla_mall_discounts
- id — int — Primary key — NOT NULL
- admin_user_id — int
- update_admin_user_id — int
- discount_type — varchar(45) — 할인유형(all_contents: 모든 콘텐츠, all_users: 모든 유저, first_content: 첫 콘텐츠, first_buying: 첫 구매)\n
- discount_method — varchar(45) — 할인방식(percent: 할인율, minus: 할인수량, flat_price: 균일가)
- discount_cookie — int — 할인금액
- discount_start_at — datetime(6)
- discount_end_at — datetime(6)
- created_at — datetime(6)
- updated_at — datetime(6)
bla_mall_messages
- id — int — Primary key — NOT NULL
- user_id — int
- bla_mall_buy_id — int
- content — varchar(255)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
bla_party_histories
- id — bigint — Primary key — NOT NULL
- bla_id — bigint — NOT NULL — 블라파티 ID
- user_id — bigint — 블라파티 호스트 id
- start_at — datetime — 방송 시작 시간
- end_at — datetime — 방송 종료 시간
- bla_party_seconds — bigint — 방송시간 (초단위)
- end_type — varchar(45) — 블라파티 종료 타입(정상적으로 중지한건지 rake를통해 중지된건지)
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
bla_party_modify_histories
- id — int — Primary key — NOT NULL
- bla_id — int — NOT NULL — 수정한 블라파티id
- modify_data — varchar(45) — 수정한 부분(제목, 파티입장타입,…)
- modify_before_data — varchar(255) — 수정전 데이터
- modify_after_data — varchar(255) — 수정후 데이터
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
bla_record_likes
- id — bigint — Primary key — NOT NULL
- bla_record_id — bigint
- user_id — bigint
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
bla_records
- id — bigint — Primary key — NOT NULL
- user_id — bigint
- bla_id — bigint
- category_id — bigint
- title — varchar(255)
- dynamic_link — varchar(255)
- tags — varchar(255)
- file_path — varchar(255)
- duration — int
- adult — tinyint(1)
- subscriber_only — varchar(255)
- likes — int
- plays — int
- cookies — int
- report_count — int
- admin_comment — varchar(255)
- status — varchar(255)
- created_at — datetime
- updated_at — datetime
bla_records_add_likes
- id — bigint — Primary key — NOT NULL
- bla_records_add_id — bigint
- user_id — bigint
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
bla_records_adds
- id — bigint — Primary key — NOT NULL
- admin_user_id — bigint
- bla_records_category_id — bigint
- img_file_name — varchar(255)
- img_content_type — varchar(255)
- img_file_size — int
- img_updated_at — datetime
- audio_file_name — varchar(255)
- audio_content_type — varchar(255)
- audio_file_size — int
- audio_updated_at — datetime
- title — varchar(255)
- adult — tinyint(1)
- priority — int
- likes — int
- plays — int
- cookies — int
- status — varchar(255)
- report_count — int
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- duration — varchar(255)
- update_admin_user_id — bigint
- user_id — bigint
- dynamic_link — varchar(255)
bla_records_categories
- id — bigint — Primary key — NOT NULL
- admin_user_id — bigint
- update_admin_user_id — bigint
- name — varchar(255)
- users_count — int
- priority — int
- adult — tinyint(1)
- img_file_name — varchar(255)
- img_content_type — varchar(255)
- img_file_size — int
- img_updated_at — datetime
- status — varchar(255)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- scheme — varchar(255)
bla_records_pls
- id — bigint — Primary key — NOT NULL
- title — varchar(255)
- dynamic_link — varchar(255)
- file_path — varchar(255)
- sortname — varchar(255)
- register — varchar(255)
- duration — int
- adult — int
- likes — int
- plays — int
- cookies — int
- status — varchar(255)
- report_count — int
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
bla_reports
- id — bigint — Primary key — NOT NULL
- admin_user_id — bigint
- bla_id — bigint
- bla_record_id — bigint
- spontalk_content_id — int
- bla_mall_content_id — int — 신고할 블라몰 콘텐츠ID
- bla_mall_message_id — int
- user_id — bigint
- reported_user_id — bigint
- kind — varchar(255)
- status — varchar(255)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
bla_user_sponsors
- id — bigint — Primary key — NOT NULL
- bla_user_id — bigint
- cookie — int
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
bla_users
- id — bigint — Primary key — NOT NULL
- bla_id — bigint
- bla_user_id — bigint
- user_id — bigint
- broadcast_user_id — int
- key — varchar(255)
- manager — tinyint(1)
- host — tinyint(1)
- thanks — text
- exit — tinyint(1)
- force_exit — tinyint(1)
- party_exit — tinyint(1)
- cookie — int
- mike — tinyint(1)
- sponsor_at — datetime
- key_history — text
- device_info — varchar(255) — 방송접속시 유저 기기정보
- remote_ip — varchar(45) — 유저ip
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
bla_vote_items
- id — int — Primary key — NOT NULL
- bla_vote_id — int — NOT NULL — 투표id
- item_name — varchar(255) — 투표항목이름
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
bla_vote_results
- id — int — Primary key — NOT NULL
- user_id — int — 투표참여한 유저id
- bla_vote_id — int — 참여한 투표id
- bla_vote_item_id — int — 투표항목id
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
bla_votes
- id — int — Primary key — NOT NULL
- user_id — int — NOT NULL — 투표개설한 유저id
- bla_id — int — 투표개설한 방송id
- title — varchar(225) — 투표제목
- status — varchar(45) — 투표 상태 (storage(임시저장), progress(투표중), end(투표종료), suspend(정책위반))
- result_open_way — varchar(45) — 공개방식(after_open(종료후 공개), progress_open(진행중 공개))
- deleted_yn — varchar(45) — 삭제여부
- end_at — datetime(6) — 투표종료한 날짜
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
blas
- id — bigint — Primary key — NOT NULL
- user_id — bigint
- broadcast_user_id — int — BLA에서 음성 송출이 되는 유저ID
- category_id — bigint
- kind — varchar(255)
- max_play_time — int
- channel_id — varchar(255)
- key — varchar(255)
- remon_key — varchar(255)
- title — varchar(255)
- tags — varchar(255)
- bla_records_add_id — int — 방송안에서 bgm으로 쓸 짤플러스 id
- start_greeting — varchar(255)
- end_greeting — varchar(255)
- cover_img — varchar(255)
- adult — tinyint(1)
- subscriber_only — varchar(255)
- notice — varchar(255)
- notice_visible — tinyint(1)
- sendbird_info — text
- like_count — int
- join_count — int
- party_exit_count — int
- anonymous_count — int
- max_join_count — int
- report_count — int
- warning_count — int
- invite_count — int
- before_chat_count — int
- now_chat_count — int
- chat_count — int
- cookie — int
- score — int
- recent_score — int
- duration — bigint
- mike — tinyint(1)
- chat_off — tinyint(1)
- invite_link — varchar(255)
- invites — varchar(255)
- join_request — int
- join_request_message — text
- recommend — tinyint(1)
- is_host_calling — tinyint(1)
- current_start_at — datetime
- start — tinyint(1)
- start_at — datetime
- end — tinyint(1)
- end_at — datetime
- alarm_10_at — datetime
- alarm_5_at — int
- deleted — tinyint(1)
- deleted_at — datetime
- key_history — text
- device_info — varchar(255)
- remote_ip — varchar(45)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- agora_token — varchar(255)
- agora_channel — varchar(255)
block_users
- id — bigint — Primary key — NOT NULL
- user_id — bigint
- blocked_user_id — bigint
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
board_comment_likes
- id — bigint — Primary key — NOT NULL
- board_comment_id — bigint
- user_id — bigint
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
board_comments
- id — bigint — Primary key — NOT NULL
- user_id — bigint
- write_user_id — bigint
- parent_id — bigint
- content — text
- like_count — int
- read — tinyint(1)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
boards
- id — bigint — Primary key — NOT NULL
- user_id — bigint
- write_user_id — bigint
- content — text
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
bug_report_comment_likes
- id — bigint — Primary key — NOT NULL
- bug_report_id — bigint
- bug_report_comment_id — bigint
- user_id — bigint
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
bug_report_comments
- id — bigint — Primary key — NOT NULL
- bug_report_id — bigint
- parent_id — bigint
- user_id — bigint
- content — text
- like_count — int
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
bug_reports
- id — bigint — Primary key — NOT NULL
- admin_user_id — bigint
- user_id — bigint
- kind — varchar(255)
- title — varchar(255)
- content — text
- os — varchar(255)
- version — varchar(255)
- url — varchar(255)
- comment_count — int
- image_count — int
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
bulk_insert_tests
- id — int — Primary key — NOT NULL
- user_id — int
- user_nickname — varchar(255)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
categories
- id — bigint — Primary key — NOT NULL
- admin_user_id — bigint
- update_admin_user_id — bigint
- name — varchar(255)
- users_count — int
- priority — int
- img_file_name — varchar(255)
- img_content_type — varchar(255)
- img_file_size — int
- img_updated_at — datetime
- visible — tinyint(1)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL