샵라이브 권한개선

테이블 (7)

고객사 계정 (customer_accounts)

  • id (id2) — bigint — 외래 키 → 운영자 계정.id
  • customer_id — bigint — NOT NULL
  • access_key — varchar(255)
  • enc_secret_key — varchar(255)
  • name — varchar(128) — NOT NULL
  • description — varchar(255)
  • profile_image_url — varchar(255)
  • skin_id — bigint
  • background_url — varchar(255)
  • poster_url — varchar(255)
  • poster2_url — varchar(255)
  • unsupport_info_url — varchar(255)
  • live_server_id — bigint — NOT NULL
  • theme — mediumtext — 기본 테마 정보
  • chat_message_color — varchar(16) — NOT NULL — 채팅 기본 컬러
  • admin_chat_notice_message_color — varchar(16) — NOT NULL — 운영자 채팅 공지 기본 컬러
  • manage_admin_id — bigint
  • timezone — varchar(32)
  • authorization_method — varchar(16) — NOT NULL
  • currency — varchar(8) — NOT NULL — 기본 통화 단위
  • connection_limit — int — NOT NULL — 접속 제한
  • functions — text
  • valid_until — datetime
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

고객사 계층 정보 (customer_hierarchys)

  • Key — 기본 키 — NOT NULL
  • ROOT 고객사ID (root_customer_id) — bigint — 외래 키 → 고객사 정보.id — NOT NULL — ROOT 고객사ID
  • 부모 고객사ID (parent_customer_id) — bigint — NOT NULL — 부모 고객사ID
  • 고객사ID (customer_id) — bigint — NOT NULL — 고객사ID
  • 뎁스 (depth) — int — NOT NULL — 뎁스
  • 정렬순서 (order) — int — NOT NULL — 정렬순서
  • 생성일시 (created_at) — datetime — NOT NULL — 생성일시
  • 수정일시 (updated_at) — datetime — NOT NULL — 수정일시

고객사 운영자 계정그룹 (customer_admin_groups)

  • 고객ID (customer_id) — bigint — 외래 키 → 고객사 정보.id — NOT NULL — 고객ID
  • 고객관리자ID (customer_admins_id) — bigint — 외래 키 → 운영자 계정.id — NOT NULL — 고객관리자ID
  • 하위 고객사 접근 가능 여부 (child_accessible) — tinyint(1) — NOT NULL — 하위 고객사 접근 가능 여부
  • 허용 캠페인ID (allow_campaign_ids) — text — 허용 캠페인ID. delimited by comma
  • 어드민 메뉴 그룹 (roles) — text — 이 어드민이 속한 메뉴 그룹
  • 접근 가능 메뉴 (allow_menus) — text — 접근 가능 메뉴. delimited by comma
  • 접근 금지 메뉴 (deny_menus) — text — 접근 금지 메뉴. delimited by comma
  • 생성일시 (created_at) — datetime — NOT NULL — 생성일시
  • 수정일시 (updated_at) — datetime — NOT NULL — 수정일시

고객사 정보 (customers)

  • id — bigint — 기본 키
  • zone_id — bigint — NOT NULL
  • parent_customer_id — bigint
  • active — tinyint(1) — NOT NULL
  • identifier — varchar(64) — NOT NULL
  • name — varchar(32) — NOT NULL
  • description — text
  • note — text
  • profile_image_url — varchar(255)
  • admin_logo_image_url — varchar(255)
  • site_text — varchar(32)
  • site_url — varchar(255)
  • contract_started_at — datetime — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deactivated_at — datetime

변경전 운영자 계정 (old_customer_admins)

  • id — bigint — 기본 키
  • auth_type — varchar(32) — NOT NULL
  • enc_auth_user_id — varchar(255) — NOT NULL
  • email — varchar(255) — NOT NULL
  • password_hash — varchar(255)
  • password_change_required — tinyint(1) — NOT NULL
  • password_incorrect_count — bigint — NOT NULL
  • customer_id — bigint — NOT NULL
  • customer_account_id — bigint — NOT NULL
  • current_zone_id — bigint — NOT NULL
  • current_customer_id — bigint — NOT NULL
  • current_customer_account_id — bigint — NOT NULL
  • zone_changeable — tinyint(1) — NOT NULL
  • child_accessible — tinyint(1) — NOT NULL — 하위 고객사 접근 가능 여부
  • enc_phone_number — varchar(255)
  • name — varchar(255) — NOT NULL
  • language — varchar(16)
  • roles — text — 이 어드민이 속한 메뉴 그룹
  • allow_menus — text — 접근 가능 메뉴. delimited by comma
  • deny_menus — text — 접근 금지 메뉴. delimited by comma
  • active — tinyint(1)
  • email_verified_at — datetime
  • phone_number_verified_at — datetime
  • use_otp — tinyint(1) — NOT NULL
  • otp_secret_key — varchar(255)
  • otp_qr_code_url — varchar(255)
  • otp_verified_at — datetime
  • last_logged_in_at — datetime
  • manage_admin_id — bigint — 이 계정을 추가/수정한 운영자
  • valid_until — datetime — 유효 시간을 지정
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

운영자 계정 (customer_admins)

  • id — bigint — 기본 키
  • auth_type — varchar(32) — NOT NULL
  • enc_auth_user_id — varchar(255) — NOT NULL
  • email — varchar(255) — NOT NULL
  • password_hash — varchar(255)
  • password_change_required — tinyint(1) — NOT NULL
  • password_incorrect_count — bigint — NOT NULL
  • customer_account_id — bigint — NOT NULL
  • zone_changeable — tinyint(1) — NOT NULL
  • enc_phone_number — varchar(255)
  • name — varchar(255) — NOT NULL
  • language — varchar(16)
  • active — tinyint(1)
  • email_verified_at — datetime
  • phone_number_verified_at — datetime
  • use_otp — tinyint(1) — NOT NULL
  • otp_secret_key — varchar(255)
  • otp_qr_code_url — varchar(255)
  • otp_verified_at — datetime
  • last_logged_in_at — datetime
  • manage_admin_id — bigint — 이 계정을 추가/수정한 운영자
  • valid_until — datetime — 유효 시간을 지정
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

캠페인 (episodes)

  • id — bigint — 외래 키 → 고객사 운영자 계정그룹.고객ID — NOT NULL
  • campaign_key — varchar(64)
  • access_key — varchar(255)
  • zone_id — bigint
  • channel_id — bigint
  • partner_id — bigint
  • customer_id — bigint
  • timezone — varchar(32)
  • additional_channel_ids — text
  • team_id — bigint — NOT NULL
  • nova_channel_id — varchar(64)
  • live_id — bigint
  • relay_live_id — bigint
  • cid — bigint
  • nth — int
  • quiz_count — int
  • bonus_excluded_quiz_count — int
  • first_main_quiz_nth — int
  • title — varchar(128)
  • description — varchar(255)
  • home_title — varchar(255)
  • home_image — varchar(255)
  • home_background_image_path — varchar(255)
  • exposure_on_home — tinyint(1) — NOT NULL
  • live_chat — tinyint(1) — NOT NULL
  • episode_format — smallint — NOT NULL
  • episode_status — varchar(16) — NOT NULL
  • heart_mode — varchar(16) — NOT NULL
  • heart_mode_limit — int — NOT NULL
  • controller_mode_available — tinyint(1) — NOT NULL
  • rehearsal — tinyint(1) — NOT NULL
  • compensation — int — NOT NULL
  • joinable — tinyint(1)
  • prize — double — NOT NULL
  • additional_prize — double
  • prize_currency — varchar(8) — NOT NULL
  • prizable — tinyint(1) — NOT NULL
  • rankable — tinyint(1) — NOT NULL
  • broadcasted — tinyint(1) — NOT NULL
  • winners_decided — tinyint(1) — NOT NULL
  • winners_broadcasted — tinyint — NOT NULL
  • winners_broadcasted_quiz_nth — int — NOT NULL
  • episode_type — smallint — NOT NULL
  • allow_guest_chat — tinyint(1) — NOT NULL
  • broadcast_chat — tinyint(1) — NOT NULL
  • broadcast_chat_probability — int — NOT NULL
  • save_chat_log — tinyint(1) — NOT NULL
  • memo — text
  • verbose — text
  • scheduled_at — datetime
  • scheduled_end_at — datetime
  • started_at — datetime
  • closing_at — datetime
  • ended_at — datetime
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • sponsor_id — bigint — NOT NULL
  • brand_id — bigint
  • host_id — int — NOT NULL
  • ts_logging — tinyint(1) — NOT NULL
  • … +17