funware

Tables (13)

tbl_category (Untitled13)

  • ai_category (Field) — int — Primary key
  • f_category_name (Field2) — varchar
  • f_div (Field3) — char

tbl_enterprise (Untitled12)

  • ai_enterprise_id (Field) — int
  • sys_project_id (Field2) — int
  • f_etp_name (Field3) — varchar
  • f_etp_desc (Field4) — longtext
  • f_etp_logo (Field5) — varchar
  • f_etp_url (Field6) — varchar
  • f_etp_value (Field7) — bigint
  • f_etp_ir (Field8) — varchar

tbl_etp_value_history (Untitled11)

  • sys_enterprise_id (Field) — int
  • f_change_per (Field2) — float
  • f_etp_new (Field3) — bigint
  • auto_date (Field4) — timestamp

tbl_img (Untitled10)

  • ai_img (Field) — int
  • sys_projcet_id (Field2) — int
  • f_thumbnail (Field3) — varchar
  • f_thumbnail (Field4) — varchar
  • f_storyline_img (Field5) — varchar
  • f_storyline_img (Field6) — varchar
  • f_summary_img (Field7) — varchar
  • f_gamepv (Field8) — varchar

tbl_invest_history (Untitled9)

  • sys_user_id (Field) — int
  • sys_project_id (Field2) — int
  • f_invset (Field3) — bigint
  • f_invest_new (Field4) — bigint
  • f_change_per (Field5) — float
  • auto_date (Field6) — timestamp

tbl_notice (Untitled8)

  • ai_notice (Field) — int
  • f_notice_title (Field2) — varchar
  • f_notice_contents (Field3) — longtext
  • f_ne (Field4) — char
  • f_div (Field5) — char
  • f_notice_img (Field6) — varchar
  • f_date (Field7) — timestamp

tbl_notice_dat (Untitled7)

  • ai_dat_id (Field) — int
  • sys_notice_id (Field2) — int
  • sys_user_id (Field3) — int
  • f_dat (Field4) — longtext
  • auto_date (Field5) — timestamp
  • f_div (Field6) — char

tbl_payment (Untitled6)

  • ai_payment_id (Field) — int
  • sys_user_id (Field2) — int
  • sys_project_id (Field3) — int
  • f_date (Field4) — timestamp
  • f_asi (Field5) — char
  • f_div (Field6) — char
  • f_invest (Field7) — bigint
  • f_invest_new (Field8) — bigint
  • f_spon (Field9) — bigint
  • f_cardbank (Field10) — varchar
  • f_cardnum (Field11) — varchar
  • f_halbu (Field12) — varchar
  • f_name (Field13) — varchar
  • f_num (Field14) — char
  • sys_rewards_id (Field15) — int
  • f_sf_desc (Field16) — varchar
  • f_paykey (Field17) — varchar

tbl_pj_bookmark (Untitled5)

  • sys_user_id (Field) — int — Primary key
  • sys_project_id (Field2) — int — Primary key

tbl_pj_category (Untitled4)

  • sys_project_id (Field) — int — Primary key
  • sys_category_id (Field2) — int — Primary key

tbl_project (Untitled3)

  • sys_project_id (Field22) — int — Foreign key → tbl_rewards.sys_project_id
  • ai_project_id (Field) — int
  • f_project_name (Field2) — varchar
  • f_storyline (Field3) — longtext
  • f_summary (Field4) — longtext
  • f_donate_limit (Field5) — bigint
  • auto_date (Field6) — timestamp
  • f_date_limit (Field7) — date
  • f_par_value (Field8) — bigint
  • f_div (Field10) — char
  • f_cardbank (Field11) — varchar
  • f_cardnum (Field12) — varchar
  • sys_register_id (Field9) — int

tbl_rewards (Untitled2)

  • sys_project_id (Field2) — int — Primary key
  • ai_rewards (Field) — int
  • f_reward_div (Field3) — varchar
  • f_reward_desc (Field4) — longtext
  • f_reward_cont (Field5) — longtext
  • f_reward_money (Field6) — bigint
  • f_div (Field7) — char

tbl_user (Untitled)

  • ai_id (PK) — int
  • f_email (Field2) — VARCHAR — NOT NULL
  • f_user_pw (Field) — VARCHAR
  • f_profile (Field3) — VARCHAR
  • autodate (Field4) — TIMESTAMP
  • f_token (unique) — CHAR
  • f_marketing (Field6) — TINYINT
  • f_div (Field7) — CHAR
  • f_post_num (Field8) — varchar
  • f_roadname (Field9) — varchar
  • f_address_detail (Field10) — varchar