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)