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