개념적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