new_erd

Tables (22)

attachment

  • file_id — BIGINT — Primary key — NOT NULL
  • target_table — VARCHAR(50) — NOT NULL
  • target_id — BIGINT — NOT NULL
  • file_name — VARCHAR(255) — NOT NULL
  • file_path — VARCHAR(500) — NOT NULL
  • created_at — DATETIME — NOT NULL

budget_allowance

  • allowance_id — BIGINT — Primary key — NOT NULL
  • project_id — BIGINT — Foreign key → budget_project.project_id — NOT NULL
  • category_id — BIGINT — Foreign key → budget_category.category_id — NOT NULL
  • initial_budget — DECIMAL(15,2) — NOT NULL
  • limit_amt — DECIMAL(15,2) — NOT NULL
  • created_by — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL

budget_category

  • category_id — BIGINT — Primary key — NOT NULL
  • category_code — VARCHAR(50) — NOT NULL
  • category_name — VARCHAR(100) — NOT NULL
  • use_yn — CHAR(1) — NOT NULL

budget_project

  • project_id — BIGINT — Primary key — NOT NULL
  • project_year — INT — NOT NULL
  • project_turn — INT — NOT NULL
  • project_name — VARCHAR(200) — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • status — VARCHAR(20) — NOT NULL

change_log

  • log_id — BIGINT — Primary key — NOT NULL
  • target_table — VARCHAR(50) — NOT NULL
  • target_id — BIGINT — NOT NULL
  • action_type — VARCHAR(20) — NOT NULL
  • old_val — TEXT
  • new_val — TEXT
  • processed_by — BIGINT — Foreign key → users.user_id — NOT NULL
  • processed_date — DATETIME — NOT NULL
  • reason — VARCHAR(255)

common_code

  • code_id — VARCHAR(50) — Primary key — NOT NULL
  • group_id — VARCHAR(50) — NOT NULL
  • code_name — VARCHAR(100) — NOT NULL
  • use_yn — CHAR(1) — NOT NULL

expenditure

  • expense_id — BIGINT — Primary key — NOT NULL
  • allowance_id — BIGINT — Foreign key → budget_allowance.allowance_id — NOT NULL
  • professor_id — BIGINT — Foreign key → professor.professor_id — NOT NULL
  • expense_date — DATE — NOT NULL
  • subject_code — VARCHAR(50) — NOT NULL
  • amount — DECIMAL(15,2) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL

expense_stu_labor

  • labor_id — BIGINT — Primary key — NOT NULL
  • expense_id — BIGINT — Foreign key → expenditure.expense_id — NOT NULL
  • student_id — BIGINT — NOT NULL
  • target_year_month — VARCHAR(7) — NOT NULL
  • amount — DECIMAL(15,2) — NOT NULL

mileage_req

  • req_id — BIGINT — Primary key — NOT NULL
  • student_id — BIGINT — Foreign key → student.student_id — NOT NULL
  • program_id — BIGINT — Foreign key → sw_program.program_id — NOT NULL
  • req_type — VARCHAR(20) — NOT NULL
  • req_point — INT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • req_date — DATETIME — NOT NULL
  • memo — VARCHAR(500)
  • processed_by — BIGINT
  • processed_date — DATETIME
  • process_comment — VARCHAR(255)

permission

  • permission_id — BIGINT — Primary key — NOT NULL
  • permission_name — VARCHAR(50) — NOT NULL
  • description — VARCHAR(255)

professor

  • professor_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • dept_code — VARCHAR(50) — NOT NULL

response_detail

  • detail_id — BIGINT — Primary key — NOT NULL
  • response_id — BIGINT — Foreign key → survey_response.response_id — NOT NULL
  • question_id — BIGINT — Foreign key → survey_question.question_id — NOT NULL
  • score — INT
  • essay — TEXT

student

  • student_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • student_no — VARCHAR(20) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • dept_code — VARCHAR(50) — NOT NULL
  • grade — INT — NOT NULL
  • academic_status — VARCHAR(20) — NOT NULL
  • admission_type — VARCHAR(20) — NOT NULL
  • admission_date — DATE — NOT NULL
  • phone_number — VARCHAR(20) — NOT NULL
  • sms_agree_yn — CHAR(1) — NOT NULL
  • email — VARCHAR(100) — NOT NULL

student_update_req

  • req_id — BIGINT — Primary key — NOT NULL
  • student_id — BIGINT — Foreign key → student.student_id — NOT NULL
  • target_col — VARCHAR(50) — NOT NULL
  • old_val — VARCHAR(255)
  • new_val — VARCHAR(255) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • req_date — DATETIME — NOT NULL
  • processed_by — BIGINT
  • processed_date — DATETIME
  • process_comment — VARCHAR(255)

survey

  • survey_id — BIGINT — Primary key — NOT NULL
  • program_id — BIGINT — NOT NULL
  • survey_title — VARCHAR(200) — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • status — VARCHAR(20) — NOT NULL

survey_question

  • question_id — BIGINT — Primary key — NOT NULL
  • survey_id — BIGINT — Foreign key → survey.survey_id — NOT NULL
  • content — VARCHAR(500) — NOT NULL
  • question_type — VARCHAR(20) — NOT NULL

survey_response

  • response_id — BIGINT — Primary key — NOT NULL
  • survey_id — BIGINT — Foreign key → survey.survey_id — NOT NULL
  • student_id — BIGINT — NOT NULL
  • is_completed — BOOLEAN — NOT NULL
  • response_date — DATETIME — NOT NULL

sw_program

  • program_id — BIGINT — Primary key — NOT NULL
  • program_type — VARCHAR(50) — NOT NULL
  • program_name — VARCHAR(200) — NOT NULL
  • event_date — DATE — NOT NULL
  • host_org — VARCHAR(100)
  • participate_point — INT — NOT NULL
  • award_point — INT — NOT NULL

topcit_round

  • round_id — BIGINT — Primary key — NOT NULL
  • round_name — VARCHAR(100) — NOT NULL
  • exam_date — DATE — NOT NULL

topcit_score

  • score_id — BIGINT — Primary key — NOT NULL
  • student_id — BIGINT — Foreign key → student.student_id — NOT NULL
  • round_id — BIGINT — Foreign key → topcit_round.round_id — NOT NULL
  • total_score — INT — NOT NULL
  • created_by — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL

user_permission

  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • permission_id — BIGINT — Foreign key → permission.permission_id — NOT NULL

users

  • user_id — BIGINT — Primary key — NOT NULL
  • login_id — VARCHAR(50) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • use_yn — CHAR(1) — NOT NULL
  • created_at — DATETIME — NOT NULL