KOVO CRM ERD

테이블 (28)

Copy Of Copy Of season2 (stadium)

  • id — bigint(20) — 기본 키 — NOT NULL
  • team_id — bigint(20) — 외래 키 → team.id — NOT NULL
  • name — varchar(128) — NOT NULL
  • name_eng — varchar(128) — NOT NULL
  • code — varchar(16) — NOT NULL
  • description — text — NOT NULL
  • total_seat_count — int

ETL 결과 로그 (etl_result_log)

  • id — bigint(20) — 기본 키 — NOT NULL
  • EXE_CMD — nvarchar(256)
  • start_at — datetime
  • end_at — datetime
  • err_message — nvarchar(4000)
  • err_line — int
  • success_yn — boolean

Untitled (menu)

  • id — bigint(20) — 기본 키 — NOT NULL
  • team_id — bigint(20) — 외래 키 → team.id — NOT NULL
  • number — int — NOT NULL
  • content

Untitled (banner)

  • id — bigint(20) — 기본 키 — NOT NULL
  • id (team_id) — bigint(20) — 외래 키 → team.id — NOT NULL
  • image_url — text — NOT NULL
  • link_url — text — NOT NULL

err_log

  • id — bigint(20) — 기본 키 — NOT NULL
  • err_no — int
  • err_severity — int
  • err_state — int
  • err_procedure — nvarchar(256)
  • err_line — int
  • err_message — nvarchar(4000)
  • err_dt — datetime

event

  • id — bigint(20) — 기본 키 — NOT NULL
  • title — varchar(128) — NOT NULL
  • type — int — NOT NULL
  • class — int — NOT NULL
  • status — int — NOT NULL
  • content_url — text — NOT NULL
  • image_url — text
  • question — varchar(256)
  • start_at — datetime
  • end_at — datetime
  • winner_at — datetime
  • correct_answer — varchar(128)
  • qr_text — varchar(32)
  • total_answer_ccnt — int
  • team_code — varchar(16)
  • team_name — varchar(128)
  • game_name — nvarchar(128)
  • game_date — datetime

event_answer_option

  • id — bigint(20) — 기본 키 — NOT NULL
  • event_id — bigint(20) — 외래 키 → event.id — NOT NULL
  • option_label — varchar(128) — NOT NULL
  • option_value — nvarchar(64) — NOT NULL
  • sort — int — NOT NULL
  • answer_ccnt — int — NOT NULL
  • sync_dt — datetime — NOT NULL

event_answer_option_roulette

  • id — bigint(20) — 기본 키 — NOT NULL
  • event_id — bigint(20) — 외래 키 → event.id — NOT NULL
  • option_label — varchar(128) — NOT NULL
  • option_value — nvarchar(64) — NOT NULL
  • sort — int — NOT NULL
  • offer_display_name — nvarchar(128) — NOT NULL
  • offer_image_url — nvarchar(1024) — NOT NULL
  • max_winning_persons — int
  • current_winning_persons — int
  • sync_dt — datetime

event_goods

  • id — bigint(20) — 기본 키 — NOT NULL
  • event_id — bigint(20) — 외래 키 → event.id — NOT NULL
  • name — varchar(128) — NOT NULL
  • rank — int — NOT NULL
  • offer_display_name — nvarchar(128) — NOT NULL
  • offer_image_url — nvarchar(1024) — NOT NULL
  • winning_persons — int — NOT NULL
  • sync_dt — datetime
  • game_date — datetime

event_result

  • id — bigint(20) — 기본 키 — NOT NULL
  • event_id — bigint(20) — 외래 키 → event.id — NOT NULL
  • membership_no — nvarchar(16)
  • result_val — naverchar(64)
  • winning_yn — boolean
  • winning_rank — int
  • offer_display_name — nvarchar(128)
  • remark — nvarchar(1024)
  • sync_yn — boolean

ket_value

  • id — bigint(20) — 기본 키 — NOT NULL
  • key_group — nvarchar(256)
  • key — nvarchar(256)
  • value — nvarchar(512)
  • remark — nvarchar(1024)

offer

  • id — bigint(20) — 기본 키 — NOT NULL
  • service_type — int
  • store_code — naverchar(16)
  • offer_code — naverchar(1024)
  • apply_ticket_price_codes — nvarchar(128)
  • offer_title — nvarchar(128)
  • offer_type — int
  • personal_yn — boolean
  • valid_period — int
  • use_yn — boolean
  • valid_start_dt — datetime
  • valid_end_dt — datetime
  • offer_unit_cost — int
  • offer_unit_type — int
  • unit_val — float
  • offer_info — nvarchar(4000)
  • max_possible_qty — int
  • cancel_exp_yn — boolean
  • all_qty — int
  • reg_qty — int
  • use_qty — int
  • recovery_qty — int
  • exp_qty — int
  • remain_qty — int
  • mall_db_update_dt — datetime

player

  • id — bigint(20) — 기본 키 — NOT NULL
  • team_id — bigint(20) — 외래 키 → team.id — NOT NULL
  • code — varchar(16) — NOT NULL
  • name — varchar(16) — NOT NULL
  • name_eng — varchar(16)
  • number — varchar(8)
  • position — varchar(128)
  • status — varchar(16)
  • gender — varchar(16)
  • height — int
  • weight — int
  • blood_type — varchar(16)
  • nick_name (nick_name) — varchar(16)
  • education (education) — varchar(128)
  • image_url — text
  • image_name — text

project

  • id — bigint(20) — 기본 키 — NOT NULL
  • name — navarchar(512)
  • status — int
  • dscr — nvarchar(4000)
  • create_dt — datetime

season

  • id — bigint(20) — 기본 키 — NOT NULL
  • name — varchar(128)
  • code — varchar(16)
  • year (year) — varchar(32)
  • sponsor — varchar(32)
  • grade — int
  • start_date — datetime
  • end_date — datetime

sms_certify_log

  • id — bigint(20) — 기본 키 — NOT NULL
  • mobile — mobile
  • certify_message — nvarchar(2000)
  • create_at — datetime

survey

  • id — bigint(20) — 기본 키 — NOT NULL
  • project_id — bigint(20) — 외래 키 → project.id — NOT NULL
  • name — navarchar(512)
  • survey_url — nvarchar(4000)
  • dscr — nvarchar(4000)
  • create_dt — datetime

survey_answer

  • id — bigint(20) — 기본 키 — NOT NULL
  • survey_id — bigint(20) — 외래 키 → survey.id — NOT NULL
  • user_id — bigint(20) — 외래 키 → user.id — NOT NULL
  • name — navarchar(512)
  • subject — naverchar(512)
  • answer_dt — datetime
  • respondent_name — naverchar(64)
  • respondent_email — navarchar(64)
  • survey_response_url — nvarchar(2000)
  • question_answer_use_yn — boolean
  • answer_nps_score — int
  • answer_text — nvarchar(1000000)

survey_question

  • id — bigint(20) — 기본 키 — NOT NULL
  • survey_id — bigint(20) — 외래 키 → survey.id — NOT NULL
  • name — navarchar(512)
  • sub_name — naverchar(5000)
  • question_text — nvarchar(100000)
  • question_type — int
  • question_option — navarchar(100000)
  • option_choice_type — int
  • sort — int
  • multi_line_yn — boolean
  • response_mandatory_yn — boolean

team

  • id — bigint(20) — 기본 키 — NOT NULL
  • team_code — varchar(16) — NOT NULL
  • team_name — varchar(128) — NOT NULL
  • team_full_name — varchar(256) — NOT NULL
  • team_owner (team_owner) — varchar(128)
  • team_city — varchar(128)
  • founding_date — datetime
  • break_up_date — datetime
  • phone_no — varchar(16)
  • fax_no — varchar(16)
  • zip_code — varchar(16)
  • use — boolean
  • team_addreess (team_address) — varchar(128)
  • gender — varchar(16)

terms

  • id — bigint(20) — 기본 키 — NOT NULL
  • title — varchar(128)
  • terms_type — varchar(128)
  • content — text
  • mandatory (madatory) — boolean
  • use — boolean
  • applqy_start_at — datetime
  • apply_end_date — datetime

ticket_grade

  • id — bigint(20) — 기본 키 — NOT NULL
  • ticket_grade_code — navarchar(128)
  • ticket_grade_name — naverchar(256)
  • grade_dscr — naverchar(4000)
  • use_yn — boolean
  • apply_start_date — datetime
  • apply_end_date — datetime
  • remark — nvarchar(1024)
  • ticket_prod_code — naverchar(8)

user

  • id — bigint(20) — 기본 키 — NOT NULL
  • membership_no — nvarchar(16)
  • login_id — varchar(128) — NOT NULL
  • name — varchar(128) — NOT NULL
  • foreigner_yn — boolean
  • email — varchar(128) — NOT NULL
  • password — varchar(128) — NOT NULL
  • ban — boolean — NOT NULL
  • phone_number — varchar(128)
  • birth_day — date
  • last_login_at — datetime
  • gender — varchar(16)
  • zip_code — varchar(16)
  • addr1 — nvarchar(512)
  • addr2 — nvarchar(512)
  • device_token — nvaerchar(256)
  • device_token_update_dt — datetime
  • withdraw_yn — boolean

user_login

  • id — bigint(20) — 기본 키 — NOT NULL
  • name — navarchar(128)
  • login_channel — int
  • login_dt — datetime
  • device_token — nvarchar(256)
  • create_dt — datetime

user_offer

  • id — bigint(20) — 기본 키 — NOT NULL
  • service_type — int
  • store_code — naverchar(16)
  • offer_code — naverchar(1024)
  • apply_ticket_price_codes — nvarchar(128)
  • offer_title — nvarchar(128)
  • offer_type — int
  • personal_yn — boolean
  • valid_period — int
  • use_yn — boolean
  • valid_start_dt — datetime
  • valid_end_dt — datetime
  • offer_unit_cost — int
  • offer_unit_type — int
  • unit_val — float
  • offer_info — nvarchar(4000)
  • max_possible_qty — int
  • cancel_exp_yn — boolean
  • all_qty — int
  • reg_qty — int
  • use_qty — int
  • recovery_qty — int
  • exp_qty — int
  • remain_qty — int
  • mall_db_update_dt — datetime

web_log_page

  • id — bigint(20) — 기본 키 — NOT NULL
  • web_log_session_id — bigint(20) — 외래 키 → web_log_session.id — NOT NULL
  • user_id — bigint(20) — 외래 키 → user.id — NOT NULL
  • web_log_page_name — nvarchar(128)
  • ymd — varchar(8) — NOT NULL
  • sid — int — NOT NULL
  • hit_seq — int
  • access_time — datetime
  • url_id — int — NOT NULL
  • url_info_val01 — nvarchar(1024) — NOT NULL
  • url_info_val02 — nvarchar(1024) — NOT NULL
  • code_report_id — int
  • code_report_name — navarchar(128)
  • code_info_val01 — nvarchar(1024)
  • code_info_val02 — varchar(1024)

web_log_session

  • id — bigint(20) — 기본 키 — NOT NULL
  • log_session_name — nvarchar(64)
  • ymd — varchar(8) — NOT NULL
  • sid — int — NOT NULL
  • uid — nvarchar(64)
  • puid — varchar(64) — NOT NULL
  • ip — varchar(16) — NOT NULL
  • page_view — int — NOT NULL
  • duration — datetime
  • buy_count — int
  • buy_price — int
  • country — nvarchar(64)
  • region — varchar(64)
  • mobile_device — nvarchar(64)
  • os — nvarchar(64)
  • browser — nvaerchar(64)
  • browser_version — nvarchar(64)
  • withdraw_yn — boolean

work_log

  • id — bigint(20) — 기본 키 — NOT NULL
  • sp_name — nvarchar(256)
  • work_start_dt — datetime
  • work_end_dt — datetime
  • record_count — int
  • work_name — nvarchar(256)
  • work_dscr — nvarchar(2048)