졸업 프로젝트 초기 ERD

테이블 (12)

InterestingField

  • interesing_num (interesting_num) — number — 기본 키 — NOT NULL
  • primaryKey (interesting_person) — number — 외래 키 → personnel.primaryKey
  • InterestingField (interesting_Field) — varchar

ProjectParticipation

  • projectParticipation (part_num) — number — 기본 키 — NOT NULL
  • primaryKey (part_personnel) — number — 외래 키 → personnel.primaryKey
  • TeamProject (part_team) — number — 외래 키 → TeamProject.TeamProject — NOT NULL

ProjectSubtask

  • projectSubtask (subtask_num) — number — 기본 키 — NOT NULL
  • taskNum (subtask_task) — number — 외래 키 → teamprojectTask.taskNum — NOT NULL
  • subtask_content — varchar
  • subtask_startdate — date — NOT NULL
  • subtask_enddate — date — NOT NULL
  • subtask_ongoing — boolean

QnA_board

  • qna_num — number — 기본 키 — NOT NULL
  • qna_title — varchar
  • qna_field — varchar
  • primaryKey (qna_writer) — number — 외래 키 → personnel.primaryKey
  • qna_date — date
  • qna_hit — number
  • qna_content — varchar

TeamMatching

  • matching_num — number — 기본 키 — NOT NULL
  • TeamProject (matching_team) — number — 외래 키 → TeamProject.TeamProject — NOT NULL
  • Req_num (matching_rec) — number — 외래 키 → Untitled.Rec_num — NOT NULL

TeamProject

  • TeamProject (team_num) — number — 기본 키 — NOT NULL
  • teamName (team_name) — varchar
  • team_title — varchar
  • team_field — varchar
  • team_lecture — varchar — NOT NULL
  • team_content — varchar
  • team_privacybound — varchar
  • team_collaboration — boolean
  • team_ongoing — boolean

Untitled (Recruitment)

  • Rec_num (rec_num) — number — 기본 키 — NOT NULL
  • com_num (Rec_company) — number — 외래 키 → company.com_num — NOT NULL
  • rec_title — varchar
  • rec_field — varchar
  • rec_content — varchar
  • rec_ongoing (rec_ongoign) — boolean

Untitled (projectBoard)

  • prjboard_nu (prjboard_num) — number — 기본 키 — NOT NULL
  • prjboard_title — varchar
  • projectParticipation (prjboard_writer) — number — 외래 키 → ProjectParticipation.projectParticipation — NOT NULL
  • prjboard_date — date
  • prjboard_hit — number
  • prjboard_content — varchar

company

  • com_num — number — 기본 키 — NOT NULL
  • companyName (com_name) — varchar
  • comField (com_Field) — varchar
  • comRepresentive (com_representive) — varchar
  • com_cellPhone (com_cellphone) — varchar
  • email (com_email) — varchar
  • id (com_identification) — varchar
  • password (com_password) — varchar

personnel

  • primaryKey (p_num) — number — 기본 키
  • SchoolName (p_univ) — varchar
  • studentId (p_studentId) — number
  • Field3 (p_name) — varchar
  • Field4 (p_department) — varchar
  • email (p_email) — varchar
  • hpNum (p_cellPhone) — varchar — NOT NULL
  • id (p_identification) — varchar
  • p_password — varchar

qna_comment (QnA_comment)

  • qna_commentNum (comment_num) — number — 기본 키 — NOT NULL
  • primaryKey (comment_writer) — number — 외래 키 → personnel.primaryKey
  • qna_num (comemnt_qna) — number — 외래 키 → QnA_board.qna_num — NOT NULL
  • comment_content — varchar

teamprojectTask (projectTask)

  • taskNum (task_num) — number — 기본 키 — NOT NULL
  • TeamProject (task_team) — number — 외래 키 → TeamProject.TeamProject — NOT NULL
  • taskContent (task_content) — varchar
  • task_start (task_startdate) — date
  • task_enddate — date
  • task_ongoing — boolean