졸업 프로젝트 초기 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