mojadol

Tables (8)

click priority (click_priority)

  • user ID (uID) — varchar(50) — Primary key — NOT NULL
  • user ID (uID2) — varchar(50) — Foreign key → user.user ID — NOT NULL
  • Employment sup priority (E_s_priority) — double
  • Startup sup priority (S_s_priority) — double
  • Life welfare priority (L_w_priority) — double
  • Residential financial priority (R_f_priority) — double

interest

  • policy code (p_code2) — int — Foreign key → policy.policy code — NOT NULL
  • Employment_Support (Employment_Sup) — tinyint(1)
  • Startup_support (Startup_sup) — tinyint(1)
  • Life and welfare (Life_welfare) — tinyint(1)
  • Residential and financial (Residential_financial) — tinyint(1)

my list priority (mylist_priority)

  • user ID (uID) — varchar(50) — Primary key — NOT NULL
  • user ID (uID2) — varchar(50) — Foreign key → user.user ID — NOT NULL
  • Employment sup priority (E_s_priority) — double
  • Startup sup priority (S_s_priority) — double
  • Life welfare priority (L_w_priority) — double
  • Residential financial priority (R_f_priority) — double

origin of policy data (origin_policy)

  • policy code (p_code) — int — Foreign key → policy.policy code — NOT NULL
  • union of contents (Ucontents) — varchar(10000)

policy

  • policy code (p_code) — int — Primary key — NOT NULL
  • title — varchar(50)
  • url — varchar(150)
  • apply start time (apply_start) — timestamp
  • apply end time (apply_end) — timestamp
  • policy start time (policy_start) — timestamp
  • start age — int
  • end age (end_age) — int
  • contents — varchar(1000)
  • target application (target_application) — varchar(50)
  • crawing date (crawing_date) — timestamp
  • expiration flag (expiration_flag) — tinyint(1)
  • location 1st (do) (dor) — varchar(50)
  • location 2nd (si) (si) — si

request to administrator (request)

  • request code (req_code) — int — Primary key — NOT NULL
  • request category (req_category) — varchar(50)
  • request contents (contents) — varchar(600)
  • request time (req_time) — timestamp
  • request processing flag (req_flag) — tinyint(1)
  • user ID (uID2) — varchar(50) — Foreign key → user.user ID — NOT NULL

stored code (stored_code)

  • store code — int — Primary key — NOT NULL
  • user ID (uID) — varchar(50) — Foreign key → user.user ID — NOT NULL
  • policy code (p_code2) — int — Foreign key → policy.policy code — NOT NULL
  • policy storing time (s_p_time) — timestamp

user

  • user ID (uID) — varchar(50) — Primary key — NOT NULL
  • Employment sup priority (E_s_priority) — int
  • Startup sup priority (S_s_priority) — int
  • Life welfare priority (L_w_priority) — int
  • Residential financial priority (R_f_priority) — int
  • user name (name) — varchar(50)
  • region 1st (do) (dor) — varchar(50)
  • region 2nd (si) (si) — varchar(50)
  • user age (age) — int
  • user sex (sex) — varchar(50)