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)