test
Tables (16)
cl_a_sites
- idx — mediumint(9) — Primary key — NOT NULL
- site_name — varchar(50) — NOT NULL
- site_prefix — varchar(50) — NOT NULL
- reg_date — datetime — NOT NULL
cl_admin_amount
- idx — int(11) — Primary key — NOT NULL
- type — mediumint(9) — Foreign key → cl_type_amount.idx — NOT NULL
- admin_idx — int(11) — Foreign key → cl_admin_user.idx — NOT NULL
- value — decimal(20,4) — NOT NULL
- update_dt — datetime — NOT NULL
cl_admin_auth_password
- idx — int(11) — Primary key — NOT NULL
- admin_idx — int(11) — Foreign key → cl_admin_user.idx — NOT NULL
- password — varchar(50) — NOT NULL
- hash — varchar(128) — NOT NULL
- update_dt — datetime — NOT NULL
cl_admin_fee
- idx — int(11) — Primary key — NOT NULL
- type — mediumint(9) — Foreign key → cl_type_fee.idx — NOT NULL — 어떤 종류인지
- admin_idx — int(11) — Foreign key → cl_admin_user.idx — NOT NULL
- deal — decimal(6, 4) — NOT NULL
- update_dt — datetime
- reg_date — datetime — NOT NULL
cl_admin_info
- idx — int(11) — Primary key — NOT NULL
- admin_idx — int(11) — Foreign key → cl_admin_user.idx — NOT NULL
- nick_name — varchar(50)
- name — varchar(50)
- email — varchar(128)
- birthday — datetime
- bank_name — varchar(30)
- bank_holder_name — varchar(50)
- bank_number — varchar(50)
- phone_code — varchar(10)
- phone_number — varchar(50)
- update_dt — datetime
- reg_date — datetime — NOT NULL
cl_admin_joincode
- idx — int(11) — Primary key — NOT NULL
- site_idx — mediumint(9) — Foreign key → cl_a_sites.idx — NOT NULL
- admin_idx — int(11) — Foreign key → cl_admin_user.idx — NOT NULL
- code — varchar(50) — NOT NULL
- state — tinyint(4) — NOT NULL — 0 활성 1 비활성 2 삭제
- update_dt — datetime
- reg_date — datetime — NOT NULL
cl_admin_tree
- idx — int(11) — Primary key — NOT NULL
- site_idx — mediumint(9) — Foreign key → cl_a_sites.idx — NOT NULL
- admin_idx — int(11) — Foreign key → cl_admin_user.idx — NOT NULL
- admin_lv — tinyint(4) — NOT NULL
- head_1_idx — int(11)
- head_2_idx — int(11)
- head_3_idx — int(11)
- head_4_idx — int(11)
- head_5_idx — int(11)
- head_6_idx — int(11)
- head_7_idx — int(11)
- head_8_idx — int(11)
- head_9_idx — int(11)
- head_10_idx — int(11)
- reg_date — datetime
cl_admin_user
- idx — int(11) — Primary key — NOT NULL
- site_idx — mediumint(9) — Foreign key → cl_a_sites.idx — NOT NULL
- state — tinyint(4) — NOT NULL
- admin_id — varchar(50) — NOT NULL
- admin_rank — tinyint(4) — NOT NULL — admin.rank 참조
- admin_lv — tinyint(4) — NOT NULL — admin.lv 참조
- top_lv — tinyint(4) — NOT NULL
- top_idx — int(11) — NOT NULL
- reg_date — datetime — NOT NULL
cl_member_auth_password
- idx — int(11) — Primary key — NOT NULL
- user_idx — int(11) — Foreign key → cl_member_user.idx — NOT NULL
- password — varchar(50) — NOT NULL
- hash — varchar(128) — NOT NULL
- update_dt — datetime — NOT NULL
- idx (idx2) — mediumint(9) — Foreign key → cl_member_user.idx — NOT NULL
cl_member_info
- idx — int(11) — Primary key — NOT NULL
- user_idx — int(11) — Foreign key → cl_member_user.idx — NOT NULL
- nick_name — varchar(50)
- name — varchar(50)
- email — varchar(128)
- birthday — datetime
- bank_name — varchar(30)
- bank_holder_name — varchar(50)
- bank_number — varchar(50)
- phone_code — varchar(10)
- phone_number — varchar(50)
- recommender_id — varchar(50)
- admin_top_id — varchar(50)
- join_ip — varchar(128) — NOT NULL
- join_domain — text — NOT NULL
- last_auth — int(11) — NOT NULL
- last_date — datetime — NOT NULL
- update_dt — datetime
- reg_date — datetime — NOT NULL
- idx (idx2) — mediumint(9) — Foreign key → cl_member_user.idx — NOT NULL
cl_member_user
- idx — int(11) — Primary key — NOT NULL
- idx (idx2) — mediumint(9) — Foreign key → cl_a_sites.idx — NOT NULL
- site_idx — mediumint(9) — NOT NULL
- state — tinyint(4) — NOT NULL
- member_id — varchar(50) — NOT NULL
- recommender_join — tinyint(4) — NOT NULL
- recommender_idx — int(11)
- top_lv — tinyint(4) — NOT NULL
- top_idx — int(11) — NOT NULL
- reg_date — datetime — NOT NULL
cl_owner_user
- idx — mediumint(9) — Primary key — NOT NULL
- owner_id — varchar(50) — NOT NULL
- owner_lv — tinyint(4) — NOT NULL
- memo — text — NOT NULL
- state — tinyint(4) — NOT NULL
- reg_date — datetime — NOT NULL
cl_type_amount
- idx — mediumint(9) — Primary key — NOT NULL
- name — varchar(50) — NOT NULL — 지역화일때 따로 확장해야 합니다.
- memo — varchar(100)
- admin_required — tinyint(4) — NOT NULL — 어드민에 필수로 생성 되는지 0 필수
- member_required — tinyint(4) — NOT NULL — 유저에 필수로 생성 되는지 0 필수
- owner_required — tinyint(4) — NOT NULL — 오너에 필수로 생성 되는지 0 필수
- reg_date — datetime — NOT NULL
cl_type_fee
- idx — mediumint(9) — Primary key — NOT NULL
- name — varchar(50) — NOT NULL — 지역화일때 따로 확장해야 합니다.
- memo — varchar(100)
- admin_required — tinyint(4) — NOT NULL — 어드민에 필수로 생성 되는지 0 필수
- member_required — tinyint(4) — NOT NULL — 유저에 필수로 생성 되는지 0 필수
- owner_required — tinyint(4) — NOT NULL — 오너에 필수로 생성 되는지 0 필수
- reg_date — datetime — NOT NULL
clg_minigame_config
- idx — int(11) — Primary key — NOT NULL
- game_type — tinyint(4) — NOT NULL
- game_gmt — tinyint(4) — NOT NULL
- game_group — tinyint(4) — NOT NULL
- game_name — varchar(200) — NOT NULL
- game_time — mediumint(9) — NOT NULL
- game_result_method — tinyint(4) — NOT NULL
- game_result_url — text — NOT NULL
- game_round_method — tinyint(4) — NOT NULL
- game_round_url — text — NOT NULL
- game_iframe_url — text — NOT NULL
- game_site_url — text
- game_state — tinyint(4) — NOT NULL
- update_at — datetime
- created_at — datetime — NOT NULL
clg_minigame_scores
- idx — bigint(20) — Primary key — NOT NULL
- game_type — smallint(6)
- result — longtext
- round — smallint(6)
- update_count — smallint(6)
- updated_at — datetime
- game_at — datetime — NOT NULL
- created_at — datetime — NOT NULL