asdasdasd
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
- status — VARCHAR2(1) — 진행상태
- create_date — DATE
- complete_date — DATE
- member_code — NUMBER
- member_name_en — varchar2(50)
- member_name_hanja — varchar2(50)
- doc_count — NUMBER
- all_included — VARCHAR2(1)
- address_history — VARCHAR2(1)
- address_history_years — NUMBER(2)
- household_reason — VARCHAR2(1)
- household_date — VARCHAR2(1)
- occurrence_date — VARCHAR2(1)
- head_name — VARCHAR2(1)
- roommate — varchar2(1)
- head_relationship — VARCHAR2(1)
- personal_change_details — VARCHAR2(1)
- id_number — VARCHAR2(1)
- rrn_last7 — VARCHAR2(1)
- rrn_last7_self — VARCHAR2(1)
- rrn_last7_member — VARCHAR2(1)
- military_service — VARCHAR2(1)
- military_service_basic_only — VARCHAR2(1)
- military_service_full — VARCHAR2(1)
- previous_address — VARCHAR2(1)
- previous_address_self — VARCHAR2(1)
- previous_address_member — VARCHAR2(1)
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) — 진행상태