개념적erd
테이블 (22)
conceptual_attachment
- file_id — BIGINT — 기본 키 — NOT NULL
conceptual_budget_allowance
- allowance_id — BIGINT — 기본 키 — NOT NULL
- project_id — BIGINT — 외래 키 → conceptual_budget_project.project_id
- category_id — BIGINT — 외래 키 → conceptual_budget_category.category_id
conceptual_budget_category
- category_id — BIGINT — 기본 키 — NOT NULL
conceptual_budget_project
- project_id — BIGINT — 기본 키 — NOT NULL
conceptual_change_log
- log_id — BIGINT — 기본 키 — NOT NULL
conceptual_common_code
- code_id — BIGINT — 기본 키 — NOT NULL
conceptual_expenditure
- expense_id — BIGINT — 기본 키 — NOT NULL
- allowance_id — BIGINT — 외래 키 → conceptual_budget_allowance.allowance_id
- professor_id — BIGINT — 외래 키 → conceptual_professor.professor_id
conceptual_expense_stu_labor
- labor_id — BIGINT — 기본 키 — NOT NULL
- expense_id — BIGINT — 외래 키 → conceptual_expenditure.expense_id
- student_id — BIGINT — 외래 키 → conceptual_student.student_id
conceptual_mileage_req
- req_id — BIGINT — 기본 키 — NOT NULL
- student_id — BIGINT — 외래 키 → conceptual_student.student_id
- program_id — BIGINT — 외래 키 → conceptual_sw_program.program_id
conceptual_permission
- permission_id — BIGINT — 기본 키 — NOT NULL
conceptual_professor
- professor_id — BIGINT — 기본 키 — NOT NULL
conceptual_response_detail
- detail_id — BIGINT — 기본 키 — NOT NULL
- response_id — BIGINT — 외래 키 → conceptual_survey_response.response_id
- question_id — BIGINT — 외래 키 → conceptual_survey_question.question_id
conceptual_student
- student_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → conceptual_users.user_id
conceptual_student_update_req
- req_id — BIGINT — 기본 키 — NOT NULL
- student_id — BIGINT — 외래 키 → conceptual_student.student_id
conceptual_survey
- survey_id — BIGINT — 기본 키 — NOT NULL
- program_id — BIGINT — 외래 키 → conceptual_sw_program.program_id
conceptual_survey_question
- question_id — BIGINT — 기본 키 — NOT NULL
- survey_id — BIGINT — 외래 키 → conceptual_survey.survey_id
conceptual_survey_response
- response_id — BIGINT — 기본 키 — NOT NULL
- survey_id — BIGINT — 외래 키 → conceptual_survey.survey_id
- student_id — BIGINT — 외래 키 → conceptual_student.student_id
conceptual_sw_program
- program_id — BIGINT — 기본 키 — NOT NULL
conceptual_topcit_round
- round_id — BIGINT — 기본 키 — NOT NULL
conceptual_topcit_score
- score_id — BIGINT — 기본 키 — NOT NULL
- student_id — BIGINT — 외래 키 → conceptual_student.student_id
- round_id — BIGINT — 외래 키 → conceptual_topcit_round.round_id
conceptual_user_permission
- user_id — BIGINT — 외래 키 → conceptual_users.user_id — NOT NULL
- permission_id — BIGINT — 외래 키 → conceptual_permission.permission_id — NOT NULL
conceptual_users
- user_id — BIGINT — 기본 키 — NOT NULL