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