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)