erd_new
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 — Foreign key → users.user_id — 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 — Foreign key → student.student_id — 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 — Foreign key → users.user_id
- 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 — Foreign key → users.user_id — 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 — Foreign key → users.user_id
- processed_date — DATETIME
- process_comment — VARCHAR(255)
survey
- survey_id — BIGINT — Primary key — NOT NULL
- program_id — BIGINT — Foreign key → sw_program.program_id — 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 — Foreign key → student.student_id — 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 — Foreign key → users.user_id — 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