ㅁㄴㅇㄹ
Tables (14)
InfoDetail
- id — VARCHAR(100) — Foreign key → users.id — NOT NULL
- Name — VARCHAR(100)
- Married — VARCHAR(50)
- Gender — VARCHAR(50)
- BirthDate — DATE
- Income — INT
- ConsentGiven — BOOLEAN
- City — VARCHAR(100)
- District — VARCHAR(100)
InfoDetailFull
- id — VARCHAR(100) — Foreign key → users.id — NOT NULL
- HighestEducation — VARCHAR(100)
- CurrentJob — VARCHAR(100)
- ResidentialStatus — VARCHAR(100)
- Special — VARCHAR(255)
T_ch2
- ch2_id — INT — Primary key — NOT NULL
- content — TEXT
T_ch3
- ch3_id — INT — Primary key — NOT NULL
- value_ch3 — VARCHAR(100)
- content — TEXT
T_ch4
- ch4_id — INT — Primary key — NOT NULL
- value_ch4 — VARCHAR(100)
- content — TEXT
T_ch6
- ch6_id — INT — Primary key — NOT NULL
- value_ch6 — VARCHAR(100)
- solution — TEXT
policy
- key — INT — Primary key — NOT NULL
- city — VARCHAR(100)
- title — VARCHAR(255)
- sub_title — TEXT
- img — TEXT
policy_content
- key — INT — Foreign key → policy.key — NOT NULL
- Application_period — VARCHAR(255)
- supported_period — VARCHAR(255)
- way — TEXT
- supported_target — TEXT
- surpported_contents — TEXT
- submission_papers — TEXT
user_T1
- user_id — VARCHAR(100) — Foreign key → users.id — NOT NULL
- user_useableMoney — INT
- user_selectedDaechu — VARCHAR(100)
- user_inputValue — INT
user_T2
- user_id — VARCHAR(100) — Foreign key → users.id — NOT NULL
- user_inputAddress — VARCHAR(255)
- user_inputDanji — VARCHAR(100)
- user_inputDong — VARCHAR(100)
- user_inputHo — VARCHAR(100)
- user_tltp — VARCHAR(100)
- user_selectedZoneCode — VARCHAR(100)
user_T3
- user_t3_id — INT — Primary key — NOT NULL
- user_id — VARCHAR(100) — Foreign key → users.id — NOT NULL
- user_checkData — VARCHAR(100)
user_T4
- user_t4_id — INT — Primary key — NOT NULL
- user_id — VARCHAR(100) — Foreign key → users.id — NOT NULL
- user_checkData — VARCHAR(100)
user_T6
- user_t6_id — INT — Primary key — NOT NULL
- user_id — VARCHAR(100) — Foreign key → users.id — NOT NULL
- user_solution — TEXT
users
- id — VARCHAR(100) — Primary key — NOT NULL
- email — VARCHAR(255)
- name — VARCHAR(100)
- password — VARCHAR(255)
- contact — VARCHAR(50)