연_디_ERD

테이블 (36)

DevelPlan_veiw (요약뷰)

  • Key (seq) — int — 기본 키 — NOT NULL
  • Field (type) — varchar(10) — 중장기 발전계획 요약뷰(2030) / 분야별 발전 계획 요약뷰 (part)
  • Field (part) — varchar(10)
  • Field (file_nm) — varchar(200)
  • Field (file_org_nm) — varchar(200)
  • Field (user_seq) — int
  • Field (reg_dt) — date
  • Field (del_dt) — date

approval

  • Key (seq) — int — 기본 키
  • Field (appro_seq) — int
  • Field (user_seq) — int
  • Field (manager_seq) — int
  • Field (status) — int
  • Field (reg_dt) — date
  • Field (appro_dt) — date
  • Field2 (remark) — varchar(400)

code

  • Key (seq) — int — 기본 키
  • Field (parent_seq) — int
  • Field (code_nm) — varchar(20)
  • Field (remark) — varchar(50)
  • Field (red_dt) — date

communication_committee (위원회)

  • Key (seq) — int — 기본 키 — NOT NULL
  • Field (committee_nm) — varchar(100)
  • Field (committee_role) — varchar(4000)
  • Field (committee_composition) — varchar(4000)
  • Field (committee_stats) — varchar(4000)
  • Field (reg_dt) — date
  • Field (mod_dt) — date
  • Field (del_dt) — date

communication_committee_file (위원회 파일)

  • Key (seq) — int — 기본 키 — NOT NULL
  • Field (committee_seq) — int
  • Field (file_nm) — varchar(200)
  • Field (file_org_nm) — varchar(200)
  • Field (reg_dt) — date
  • Field (del_dt) — date

communication_result (주요 개선실적)

  • Key (seq) — int — 기본 키 — NOT NULL
  • Field (befor_content) — varchar(4000)
  • Field (after_content) — varchar(4000)
  • Field (year) — int
  • Field (section) — varchar(10)
  • Field (department_seq) — int
  • Field (program_nm) — varchar(200)
  • Field (reg_dt) — date
  • Field (mod_dt) — date
  • Field (del_dt) — date

communication_rule (규정)

  • Key (seq) — int — 기본 키 — NOT NULL
  • Field (rule_nm) — varchar(100)
  • Field (committee_seq) — int
  • Field (rule_content) — varchar(4000)
  • Field (reg_dt) — date
  • Field (mod_dt) — date
  • Field (del_dt) — date

communication_rule_file (규정 파일)

  • Key (seq) — int — 기본 키 — NOT NULL
  • Field (rule_seq) — int
  • Field (file_nm) — varchar(200)
  • Field (file_org_nm) — varchar(200)
  • Field (reg_dt) — date
  • Field (del_dt) — date

notic_reply

  • Key (seq) — int — 기본 키 — NOT NULL
  • Field (notic_seq) — int
  • Field (user_seq) — int
  • Field (parent_seq) — int
  • Field (depth) — int
  • Field (order_no) — int
  • Field (content) — varchar(4000)
  • Field (reg_dt) — date
  • Field (mod_dt) — date
  • Field (del_dt) — date

notice

  • Key (seq) — int — 기본 키 — NOT NULL
  • Field (user_seq) — int
  • Field (title) — varchar(400)
  • Field (content) — varchar(4000)
  • Field (reg_dt) — date
  • Field (mod_dt) — date
  • Field (del_dt) — date

result_appraisal (대학자체평가)

  • Key (seq) — int — 기본 키 — NOT NULL
  • Field (type) — varchar(10) — 중장기 발전계획 요약뷰(2030) / 분야별 발전 계획 요약뷰 (part)
  • Field (appraisal_field_nm) — varchar(200)
  • Field (reg_dt) — date
  • Field (mod_dt) — date

result_appraisal_report (자체평가 보고서)

  • Key (seq) — int — 기본 키 — NOT NULL
  • Field (user_seq) — varchar(10)
  • Field2 (title) — varchar(400)
  • Field (content) — varchar(4000)
  • Field (reg_dt) — date
  • Field (mod_dt) — date
  • Field (del_dt) — date

result_appraisal_report_file (자체평가 보고서 파일)

  • Key (seq) — int — 기본 키 — NOT NULL
  • Field (report_seq) — int
  • Field (file_nm) — varchar(200)
  • Field (file_org_nm) — varchar(200)
  • Field (reg_dt) — date

result_appraisal_year (대학자체평가 연도)

  • Key (seq) — int — 기본 키 — NOT NULL
  • Field (appraisal_seq) — int
  • Field (year) — int — 중장기 발전계획 요약뷰(2030) / 분야별 발전 계획 요약뷰 (part)
  • Field (appraisal_field) — int
  • Field (reg_dt) — date
  • Field (use_yn) — char(1)

result_finance (재정지원사업 선정현황)

  • Key (seq) — int — 기본 키 — NOT NULL
  • Field (user_seq) — varchar(10)
  • Field2 (title) — varchar(400)
  • Field (content) — varchar(4000)
  • Field (account) — int
  • Field (department) — varchar(10)
  • Field (facilities) — varchar(10)
  • Field (start_dt) — date
  • Field (end_dt) — date
  • Field (reg_dt) — date
  • Field (mod_dt) — date
  • Field (del_dt) — date

result_finance_file (재정지원사업 성정현황 파일)

  • Key (seq) — int — 기본 키 — NOT NULL
  • Field (finance_seq) — int
  • Field (file_nm) — varchar(200)
  • Field (file_org_nm) — varchar(200)
  • Field (reg_dt) — date

result_indicator (대학주요지표)

  • Key (seq) — int — 기본 키 — NOT NULL
  • Field (user_seq) — varchar(10)
  • Field2 (title) — varchar(400)
  • Field (content) — varchar(4000)
  • Field (reg_dt) — date
  • Field (mod_dt) — date
  • Field (del_dt) — date

result_indicator_file (대학주요지표 파일)

  • Key (seq) — int — 기본 키 — NOT NULL
  • Field (indicator_seq) — int
  • Field (file_nm) — varchar(200)
  • Field (file_org_nm) — varchar(200)
  • Field (reg_dt) — date

result_plan_2030_detail (2030 세부 실행 관리)

  • Key (seq) — int — 기본 키 — NOT NULL
  • Field (project_nm) — varchar(100)
  • Field (department_seq) — int
  • Field (cooperation_department_seq) — int
  • Field (goal) — varchar(400)
  • Field (project) — varchar(400)
  • Field (purpose) — varchar(400)
  • Field (effect) — varchar(400)
  • Field (year1) — int
  • Field (year1_edu_plan) — varchar(10)
  • Field (year1_edu_account) — int
  • Field (year1_edu_percent) — int
  • Field (year1_sup_plan) — varchar(10)
  • Field (year1_sup_account) — int
  • Field (year1_sup_percent) — int
  • Field (year1_etc_plan) — varchar(10)
  • Field (year1_etc_account) — int
  • Field (year1_etc_percent) — int
  • Field (year2) — int
  • Field (year2_edu_plan) — varchar(10)
  • Field (year2_edu_account) — int
  • Field (year2_edu_percent) — int
  • Field (year2_sup_plan) — varchar(10)
  • Field (year2_sup_account) — int
  • Field (year2_sup_percent) — int
  • Field (year2_etc_plan) — varchar(10)
  • Field (year2_etc_account) — int
  • Field (year2_etc_percent) — int
  • Field (reg_dt) — date
  • Field (mod_dt) — date
  • Field (del_dt) — date
  • Field (user_seq) — varchar(10)

result_plan_2030_detail_file (2030 세부 싱행관리 파일)

  • Key (seq) — int — 기본 키 — NOT NULL
  • Field (detail_seq) — int
  • Field (file_nm) — varchar(200)
  • Field (file_org_nm) — varchar(200)
  • Field (reg_dt) — date

result_plan_2030_detail_kpi (2020 세부 실행과제 세부내용(모달창))

  • Key (seq) — int — 기본 키 — NOT NULL
  • Field (detail_seq) — int
  • Field (department_seq) — int
  • Field (year1) — int
  • Field (year2) — int
  • Field (year3) — int
  • Field (year4) — int
  • Field (year1_percent) — int
  • Field (year2_percent) — int
  • Field (year3_percent) — int
  • Field (year4_percent) — int

result_plan_2030_report (2030 점검결과보고서)

  • Key (seq) — int — 기본 키 — NOT NULL
  • Field (user_seq) — varchar(10)
  • Field2 (title) — varchar(400)
  • Field (content) — varchar(4000)
  • Field (reg_dt) — date
  • Field (mod_dt) — date
  • Field (del_dt) — date

result_plan_2030_report_file (2030 점검경과보고서 파일)

  • Key (seq) — int — 기본 키 — NOT NULL
  • Field (report_seq) — int
  • Field (file_nm) — varchar(200)
  • Field (file_org_nm) — varchar(200)
  • Field (reg_dt) — date

result_plan_kpi (KPI)

  • Key (seq) — int — 기본 키 — NOT NULL
  • Field (type) — varchar(10) — 중장기 발전계획 요약뷰(2030) / 분야별 발전 계획 요약뷰 (part)
  • Field (part) — varchar(10)
  • Field (kpi_field_nm) — varchar(200)
  • Field (reg_dt) — date
  • Field (mod_dt) — date

result_plan_kpi_year (kpi 연도)

  • Key (seq) — int — 기본 키 — NOT NULL
  • Field (kpi_seq) — int
  • Field (year) — int — 중장기 발전계획 요약뷰(2030) / 분야별 발전 계획 요약뷰 (part)
  • Field (kpi_field) — int
  • Field (reg_dt) — date
  • Field (use_yn) — char(1)

result_plan_part_detail (분야별 세부 실행 관리)

  • Key (seq) — int — 기본 키 — NOT NULL
  • Field (project_nm) — varchar(100)
  • Field (department_seq) — int
  • Field (cooperation_department_seq) — int
  • Field (part) — varchar(10)
  • Field (goal) — varchar(400)
  • Field (project) — varchar(400)
  • Field (purpose) — varchar(400)
  • Field (effect) — varchar(400)
  • Field (year1) — int
  • Field (year1_edu_plan) — varchar(10)
  • Field (year1_edu_account) — int
  • Field (year1_edu_percent) — int
  • Field (year1_sup_plan) — varchar(10)
  • Field (year1_sup_account) — int
  • Field (year1_sup_percent) — int
  • Field (year1_etc_plan) — varchar(10)
  • Field (year1_etc_account) — int
  • Field (year1_etc_percent) — int
  • Field (year2) — int
  • Field (year2_edu_plan) — varchar(10)
  • Field (year2_edu_account) — int
  • Field (year2_edu_percent) — int
  • Field (year2_sup_plan) — varchar(10)
  • Field (year2_sup_account) — int
  • Field (year2_sup_percent) — int
  • Field (year2_etc_plan) — varchar(10)
  • Field (year2_etc_account) — int
  • Field (year2_etc_percent) — int
  • Field (reg_dt) — date
  • Field (mod_dt) — date
  • Field (del_dt) — date
  • Field (user_seq) — varchar(10)

result_plan_part_detail_file (분야별 세부 싱행관리 파일)

  • Key (seq) — int — 기본 키 — NOT NULL
  • Field (detail_seq) — int
  • Field (file_nm) — varchar(200)
  • Field (file_org_nm) — varchar(200)
  • Field (reg_dt) — date

result_plan_part_detail_kpi (분야별 세부 실행과제 세부내용(모달창))

  • Key (seq) — int — 기본 키 — NOT NULL
  • Field (detail_seq) — int
  • Field (department_seq) — int
  • Field (year1) — int
  • Field (year2) — int
  • Field (year3) — int
  • Field (year4) — int
  • Field (year1_percent) — int
  • Field (year2_percent) — int
  • Field (year3_percent) — int
  • Field (year4_percent) — int

runing_businessPlan (사업계획서)

  • Key (seq) — int — 기본 키 — NOT NULL
  • Field (year) — int
  • Field (semester) — int
  • Field (domain) — varchar(10)
  • Field (result_nm) — varchar(200)
  • Field (type) — varchar(10)
  • Field (department_seq) — int
  • Field (manager_seq) — int
  • Field (publish_dt) — date

runing_businessPlan_file (사업계획서 파일)

  • Key (seq) — int — 기본 키 — NOT NULL
  • Field (businessPlan_seq) — int
  • Field (file_nm) — varchar(200)
  • Field (file_org_nm) — varchar(200)
  • Field (reg_dt) — date
  • Field (del_dt) — date

runing_flowback (환류체계)

  • Key (seq) — int — 기본 키 — NOT NULL
  • Field (department_seq) — int
  • Field (plan) — varchar(400)
  • Field (runing) — varchar(400)
  • Field (analysis) — varchar(400)
  • Field (improvement) — varchar(400)
  • Field (start_dt) — date
  • Field (reg_dt) — date
  • Field (mod_dt) — date
  • Field (del_dt) — date

runing_part_attainment (부서별 프로그램 운영 현황)

  • Key (seq) — int — 기본 키 — NOT NULL
  • Field (attainment_nm) — varchar(200)
  • Field (semester) — int
  • Field (attainment_dt) — date
  • Field (university_cnt) — int
  • Field (graduate_cnt) — int
  • Field (resident_cnt) — int
  • Field (count) — int
  • Field (sup_account) — int
  • Field (edu_account) — int
  • Field (local_account) — int
  • Field (reg_dt) — date
  • Field (mod_dt) — date
  • Field (del_dt) — date

runing_part_attainment_file (부서별 프로그램 운영 현황 파일)

  • Key (seq) — int — 기본 키 — NOT NULL
  • Field (attainment_seq) — int
  • Field (file_type) — char(1)
  • Field (file_nm) — varchar(200)
  • Field (file_org_nm) — varchar(200)
  • Field (reg_dt) — date
  • Field (del_dt) — date

runing_result (각종 성과물)

  • Key (seq) — int — 기본 키 — NOT NULL
  • Field (year) — int
  • Field (semester) — int
  • Field (domain) — varchar(10)
  • Field (result_nm) — varchar(200)
  • Field (type) — varchar(10)
  • Field (department_seq) — int
  • Field (manager_seq) — int
  • Field (publish_dt) — date

runing_result_dt (각종 성과물 파일)

  • Key (seq) — int — 기본 키 — NOT NULL
  • Field (result_seq) — int
  • Field (file_nm) — varchar(200)
  • Field (file_org_nm) — varchar(200)
  • Field (reg_dt) — date
  • Field (del_dt) — date

user

  • Key (seq) — int — 기본 키 — NOT NULL
  • Field (department_seq) — int
  • Field (position_seq) — int
  • Field (user_nm) — varchar(20)
  • Field (user_id) — varchar(20)
  • Field (user_pw) — varchar(20)
  • Field (phone) — varchar(20)
  • Field (email) — varchar(50)
  • Field (gender) — char(1)
  • Field (reg_dt) — date
  • Field (mod_dt) — date
  • Field (del_dt) — date
  • Field (otp) — int