연_디_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