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) — 진행상태