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