minwon
Tables (9)
citizen_db
- c_code — number
- c_name — varchar2(50)
- c_rrn — varchar2(14)
- district_code — number — Foreign key → district.district_code
- c_rrcard — char(1)
complaint_category_info
- complaint_category_code — varchar2(10)
- complaint_category_name — varchar2(100)
- complaint_category_info — varchar2(200)
department
- department_code — number
- department_name — varchar2(50)
district
- district_code — number
- sd_code — number
- sd_name — varchar2(100)
- sgg_code — number
- sgg_name — varchar2(100)
employees
- employee_code — number
- district_code — number — Foreign key → district.district_code
- employee_name — varchar2(50)
- employee_id — varchar2(30)
- employee_password — varchar2(256)
- department_code — number — Foreign key → department.department_code
- position_code — number — Foreign key → position.position_code
- authority — number
members
- member_code — number
- member_id — varchar2(30)
- member_password — varchar2(256)
- member_name — varchar2(50)
- member_birthday — date
- member_gender — varchar2(1)
- district_code — number — Foreign key → district.district_code
- member_ad_detail — varchar2(200)
- member_phonenum — varchar2(20)
- member_email — varchar2(100)
position
- position_code — number
- position_name — varchar2(50)
simple_doc
- simple_doc_code — number
- complaint_category_code — varchar2(10) — Foreign key → complaint_category_info.complaint_category_code
- district_code — number
- household_type — char(1)
- household_member — char(1)
- rrn_last7 — char(1)
- status — varchar2(1) — 진행상태
- create_date — date
- complete_date — date
- count — number
sinmungo
- sinmungo_code — number
- member_code — number
- member_phonenum — varchar2(20)
- member_email — varchar2(100)
- member_name — varchar2(50)
- member_birthday — date
- sinmungo_title — varchar2(100)
- sinmungo_content — varchar2(1000)
- complaint_area — number — Foreign key → district.district_code
- create_date — date
- answer_date — date
- employee_code — number
- employees_answer — varchar2(1000)
- security_set — varchar2(1)
- security_password — varchar2(256)
- status — varchar2(1) — 진행상태