샵라이브 권한개선
테이블 (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