ERD
Tables (28)
ATTACH_FILE
- file_id — NUMBER(12) — Primary key — NOT NULL
- apply_id — NUMBER(12) — Foreign key → MILEAGE_APPLY.apply_id
- file_name — VARCHAR2(255)
- file_path — VARCHAR2(500)
- file_size — NUMBER(12)
- upload_dt — TIMESTAMP
- uploaded_by — NUMBER(10)
BUDGET_CHANGE_HIST
- budget_hist_id — NUMBER(14) — Primary key — NOT NULL
- project_budget_id — NUMBER(10) — Foreign key → PROJECT_BUDGET.project_budget_id
- change_type — VARCHAR2(20)
- before_amount — NUMBER(15)
- after_amount — NUMBER(15)
- change_reason — VARCHAR2(500)
- changed_by — NUMBER(10)
- changed_at — TIMESTAMP
BUDGET_ITEM
- item_id — NUMBER(4) — Primary key — NOT NULL
- item_code — VARCHAR2(20)
- item_name — VARCHAR2(50)
- sort_order — NUMBER(2)
- is_use — CHAR(1)
BUDGET_PROJECT
- project_id — NUMBER(8) — Primary key — NOT NULL
- fiscal_year — NUMBER(4)
- project_round — NUMBER(2)
- project_name — VARCHAR2(200)
- start_date — DATE
- end_date — DATE
- status — VARCHAR2(20)
CHANGE_LOG
- log_id — NUMBER(18) — Primary key — NOT NULL
- target_entity — VARCHAR2(30)
- target_id — VARCHAR2(50)
- action_type — VARCHAR2(20)
- before_data — CLOB
- after_data — CLOB
- created_by — NUMBER(10) — Foreign key → USER.user_id
- created_at — TIMESTAMP
- reason — VARCHAR2(500)
COMMON_CODE
- code — VARCHAR2(20) — Primary key — NOT NULL
- group_code — VARCHAR2(20) — Foreign key → COMMON_CODE_GROUP.group_code — NOT NULL
- code_name — VARCHAR2(50)
- sort_order — NUMBER(3)
- is_use — CHAR(1)
COMMON_CODE_GROUP
- group_code — VARCHAR2(20) — Primary key — NOT NULL
- group_name — VARCHAR2(50)
- description — VARCHAR2(200)
- is_use — CHAR(1)
DEPARTMENT
- dept_id — NUMBER(6) — Primary key — NOT NULL
- dept_code — VARCHAR2(20)
- dept_name — VARCHAR2(50)
- college — VARCHAR2(50)
- campus — VARCHAR2(30)
- is_use — CHAR(1)
ENROLLMENT_HISTORY
- enroll_hist_id — NUMBER(12) — Primary key — NOT NULL
- student_id — NUMBER(10) — Foreign key → STUDENT.student_id
- change_type — VARCHAR2(20)
- before_status — VARCHAR2(20)
- after_status — VARCHAR2(20)
- change_date — DATE
- created_by — NUMBER(10) — Foreign key → USER.user_id
- created_at — TIMESTAMP
EXPENSE
- expense_id — NUMBER(14) — Primary key — NOT NULL
- project_budget_id — NUMBER(10) — Foreign key → PROJECT_BUDGET.project_budget_id
- professor_id — NUMBER(8) — Foreign key → PROFESSOR.professor_id
- expense_entity — VARCHAR2(20)
- expense_date — DATE
- amount — NUMBER(15)
- description — VARCHAR2(500)
- status — VARCHAR2(20)
- created_by — NUMBER(10)
- created_at — TIMESTAMP
- approver_id — NUMBER(10)
- approve_dt — TIMESTAMP
- process_comment — VARCHAR2(500)
MILEAGE_APPLY
- apply_id — NUMBER(12) — Primary key — NOT NULL
- student_id — NUMBER(10) — Foreign key → STUDENT.student_id
- program_id — NUMBER(10) — Foreign key → PROGRAM.program_id
- policy_id — NUMBER(10) — Foreign key → MILEAGE_POLICY.policy_id
- apply_points — NUMBER(6)
- apply_dt — TIMESTAMP
- status — VARCHAR2(20)
- memo — VARCHAR2(500)
- approver_id — NUMBER(10) — Foreign key → USER.user_id
- approve_dt — TIMESTAMP
- process_comment — VARCHAR2(500)
MILEAGE_LEDGER
- ledger_id — NUMBER(14) — Primary key — NOT NULL
- student_id — NUMBER(10) — Foreign key → STUDENT.student_id
- apply_id — NUMBER(12) — Foreign key → MILEAGE_APPLY.apply_id
- trans_type — VARCHAR2(10)
- points — NUMBER(7)
- trans_dt — TIMESTAMP
- created_by — NUMBER(10)
- reason — VARCHAR2(500)
MILEAGE_POLICY
- policy_id — NUMBER(10) — Primary key — NOT NULL
- program_id — NUMBER(10) — Foreign key → PROGRAM.program_id
- participate_type — VARCHAR2(10)
- mileage_points — NUMBER(6)
- apply_start_date — DATE
- created_by — NUMBER(10)
- created_at — TIMESTAMP
PROFESSOR
- professor_id — NUMBER(8) — Primary key — NOT NULL
- prof_no — VARCHAR2(20)
- prof_name — VARCHAR2(50)
- dept_id — NUMBER(6) — Foreign key → DEPARTMENT.dept_id
- is_active — CHAR(1)
PROGRAM
- program_id — NUMBER(10) — Primary key — NOT NULL
- category — VARCHAR2(20)
- program_name — VARCHAR2(200)
- start_date — DATE
- end_date — DATE
- host_dept — VARCHAR2(100)
- is_use — CHAR(1)
PROJECT_BUDGET
- project_budget_id — NUMBER(10) — Primary key — NOT NULL
- project_id — NUMBER(8) — Foreign key → BUDGET_PROJECT.project_id
- item_id — NUMBER(4) — Foreign key → BUDGET_ITEM.item_id
- allocated_amount — NUMBER(15)
- expense_limit — NUMBER(15)
- status — VARCHAR2(20)
- created_by — NUMBER(10)
- created_at — TIMESTAMP
- confirmed_by — NUMBER(10)
- confirmed_at — TIMESTAMP
ROLE
- role_id — NUMBER(6) — Primary key — NOT NULL
- role_code — VARCHAR2(20)
- role_name — VARCHAR2(50)
- description — VARCHAR2(200)
- is_use — CHAR(1)
STUDENT
- student_id — NUMBER(10) — Primary key — NOT NULL
- user_id — NUMBER(10) — Foreign key → USER.user_id
- student_no — VARCHAR2(20)
- dept_id — NUMBER(6) — Foreign key → DEPARTMENT.dept_id
- track_code — VARCHAR2(20)
- grade — NUMBER(1)
- academic_status — VARCHAR2(20)
- admission_type — VARCHAR2(20)
- admission_date — DATE
- phone — VARCHAR2(20)
- sms_agree_yn — CHAR(1)
- email — VARCHAR2(100)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
STUDENT_INFO_REQUEST
- request_id — NUMBER(12) — Primary key — NOT NULL
- student_id — NUMBER(10) — Foreign key → STUDENT.student_id
- request_field — VARCHAR2(30)
- before_val — VARCHAR2(200)
- after_val — VARCHAR2(200)
- request_dt — TIMESTAMP
- status — VARCHAR2(20)
- approver_id — NUMBER(10) — Foreign key → USER.user_id
- process_dt — TIMESTAMP
- process_comment — VARCHAR2(500)
STUDENT_STIPEND
- stipend_id — NUMBER(14) — Primary key — NOT NULL
- expense_id — NUMBER(14) — Foreign key → EXPENSE.expense_id
- student_id — NUMBER(10) — Foreign key → STUDENT.student_id
- payment_month — CHAR(6)
- amount — NUMBER(12)
- tax_deducted — NUMBER(12)
- status — VARCHAR2(20)
SURVEY
- survey_id — NUMBER(10) — Primary key — NOT NULL
- program_id — NUMBER(10) — Foreign key → PROGRAM.program_id
- title — VARCHAR2(200)
- start_date — DATE
- end_date — DATE
- status — VARCHAR2(20)
- dup_allow_yn — CHAR(1)
- created_by — NUMBER(10)
SURVEY_ANSWER
- answer_id — NUMBER(16) — Primary key — NOT NULL
- response_id — NUMBER(14) — Foreign key → SURVEY_RESPONSE.response_id
- question_id — NUMBER(12) — Foreign key → SURVEY_QUESTION.question_id
- score — NUMBER(2)
- subjective_opinion — VARCHAR2(1000)
SURVEY_QUESTION
- question_id — NUMBER(12) — Primary key — NOT NULL
- survey_id — NUMBER(10) — Foreign key → SURVEY.survey_id
- question_no — NUMBER(3)
- question_text — VARCHAR2(500)
- question_type — VARCHAR2(20)
- scale_min — NUMBER(2)
- scale_max — NUMBER(2)
- required_yn — CHAR(1)
SURVEY_RESPONSE
- response_id — NUMBER(14) — Primary key — NOT NULL
- survey_id — NUMBER(10) — Foreign key → SURVEY.survey_id
- student_id — NUMBER(10) — Foreign key → STUDENT.student_id
- submitted_at — TIMESTAMP
- is_complete — CHAR(1)
- completed_at — TIMESTAMP
TOPCIT_ROUND
- round_id — NUMBER(6) — Primary key — NOT NULL
- round_no — NUMBER(3)
- round_name — VARCHAR2(50)
- exam_date — DATE
- max_score — NUMBER(4)
- is_active — CHAR(1)
TOPCIT_SCORE
- score_id — NUMBER(12) — Primary key — NOT NULL
- student_id — NUMBER(10) — Foreign key → STUDENT.student_id
- round_id — NUMBER(6) — Foreign key → TOPCIT_ROUND.round_id
- total_score — NUMBER(4)
- remark — VARCHAR2(500)
- created_by — NUMBER(10)
- created_at — TIMESTAMP
- updated_by — NUMBER(10)
- updated_at — TIMESTAMP
USER
- user_id — NUMBER(10) — Primary key — NOT NULL
- login_id — VARCHAR2(30)
- password_hash — VARCHAR2(255)
- user_name — VARCHAR2(50)
- user_type — VARCHAR2(20)
- is_active — CHAR(1)
- password_changed_at — TIMESTAMP
- created_at — TIMESTAMP
- last_login_at — TIMESTAMP
USER_ROLE
- user_role_id — NUMBER(10) — Primary key — NOT NULL
- user_id — NUMBER(10) — Foreign key → USER.user_id
- role_id — NUMBER(6) — Foreign key → ROLE.role_id
- granted_at — TIMESTAMP
- granted_by — NUMBER(10)