Project_management_tables

Tables (36)

Copy Of Untitled (BoardPermission)

  • Key (BoardPermission_name) — varchar(5) — Primary key — NOT NULL
  • Key (Board_id) — int unsigned — Foreign key → Untitled.Key — NOT NULL
  • Key (UserType_id) — int unsigned — Foreign key → Untitled.Key — NOT NULL

Copy Of Untitled2 (CommentLike)

  • Key (Comment_id) — int unsigned — Foreign key → Untitled.Key — NOT NULL
  • Key (User_ID) — int unsigned — Foreign key → Untitled.Key — NOT NULL — auto_increment
  • Key (LikeType_id) — int unsigned — Foreign key → Untitled.Key — NOT NULL

Untitled (Post)

  • Key (Psot_id) — int unsigned — Primary key — NOT NULL
  • Field (Post_title) — varchar(50) — NOT NULL
  • Field (Post_content) — TEXT — NOT NULL
  • Field (Post_viewers) — int unsigned — NOT NULL — 게시글 조회수
  • Field (Post_likes) — int unsigned — NOT NULL — 개시글 좋아요 수
  • Field (Post_comments) — int unsigned — NOT NULL — 게시글 댓글 수
  • Field (Post_createdt) — DateTime — NOT NULL
  • Field (Post_updatedt) — DateTime — NOT NULL
  • Key (Board_id) — int unsigned — Foreign key → Untitled.Key — NOT NULL
  • Key (User_ID) — int unsigned — Foreign key → Untitled.Key — NOT NULL — auto_increment

Untitled (UserType)

  • Key (UserType_id) — int unsigned — Primary key — NOT NULL
  • Field (UserType_name) — varchar(10) — NOT NULL — "Admin", "User", "Member"

Untitled (LoginType)

  • Key (LoginType_id) — int unsigned — Primary key — NOT NULL
  • Field (LoginType_name) — varchar(10) — "Google", "Kakao", "Local"

Untitled (CurriculumUser)

  • Key (Curriculum_id) — int unsigned — Foreign key → Untitled.Key — NOT NULL
  • Key (User_ID) — int unsigned — Foreign key → Untitled.Key — NOT NULL — auto_increment

Untitled (Curriculum)

  • Key (Curriculum_id) — int unsigned — Primary key — NOT NULL
  • Field (Curriculum_name) — varchar(50) — NOT NULL — 커리큘럼을 생성한 유저 id
  • Field (Curriculum_prompt1) — varchar(300) — NOT NULL — "어떤 주제를 학습하고 싶은지 구체적으로 알려주세요." 의 입력
  • Field (Curriculum_prompt2) — varchar(300) — NOT NULL — "당신의 수준을 알려주세요."의 입력
  • Field (Curriculum_period) — DateTime — NOT NULL
  • Field (Curriculum_result) — varchar(500) — NOT NULL — 출력 결과 커리큘럼을 문자열로 저장
  • Key (User_ID) — int unsigned — Foreign key → Untitled.Key — NOT NULL — auto_increment

Untitled (CurriculumTechstack)

  • Key (Curriculum_id) — int unsigned — Foreign key → Untitled.Key — NOT NULL
  • Key (Techstack_id) — int unsigned — Foreign key → Untitled.Key — NOT NULL

Untitled (Techstack)

  • Key (Techstack_id) — int unsigned — Primary key — NOT NULL
  • Field (Techstack_name) — varchar(50) — NOT NULL

Untitled (Board)

  • Key (Board_id) — int unsigned — Primary key — NOT NULL
  • Field (Board_name) — varchar(50) — NOT NULL

Untitled (User_bookmark_project)

  • Key (Bookmark_ID) — int unsigned — Primary key — NOT NULL — auto_increment
  • Key (User_ID) — int unsigned — Foreign key → Untitled.Key — NOT NULL — auto_increment
  • Key (Project_ID) — int unsigned — Foreign key → Untitled.Key — NOT NULL — on delete cascade

Untitled (PostImage)

  • Key (PostImage_id) — int unsigned — Primary key — NOT NULL
  • Key (Psot_id) — int unsigned — Foreign key → Untitled.Key — NOT NULL
  • Field (PostImage_image) — varchar(255) — NOT NULL — 이미지 URL

Untitled (Comment)

  • Key (Comment_id) — int unsigned — Primary key — NOT NULL
  • Field (Comment_parentid) — int unsigned — 대댓글의 부모 댓글id
  • Field (Comment_content) — TEXT — NOT NULL
  • Field (Comment_createdt) — DateTime — NOT NULL
  • Field (Comment_updatedt) — DateTime — NOT NULL
  • Key (User_ID) — int unsigned — Foreign key → Untitled.Key — NOT NULL — auto_increment
  • Key (Psot_id) — int unsigned — Foreign key → Untitled.Key — NOT NULL

Untitled (PostLike)

  • Key (Psot_id) — int unsigned — Foreign key → Untitled.Key — NOT NULL
  • Key (User_ID) — int unsigned — Foreign key → Untitled.Key — NOT NULL — auto_increment
  • Key (LikeType_id) — int unsigned — Foreign key → Untitled.Key — NOT NULL

Untitled (LikeType)

  • Key (LikeType_id) — int unsigned — Primary key — NOT NULL
  • Field (LikeType_name) — varchar(20) — NOT NULL — "Like", "Dislike"

Untitled (Tag)

  • Key (Tag_id) — int unsigned — Primary key — NOT NULL
  • Field (Tag_name) — varchar(10)

Untitled (PostTags)

  • Key (Psot_id) — int unsigned — Foreign key → Untitled.Key — NOT NULL
  • Key (Tag_id) — int unsigned — Foreign key → Untitled.Key — NOT NULL

Untitled (Scrap)

  • Key (User_ID) — int unsigned — Foreign key → Untitled.Key — NOT NULL — auto_increment
  • Key (Psot_id) — int unsigned — Foreign key → Untitled.Key — NOT NULL

Untitled (User_skill)

  • Key (User_ID) — int unsigned — Foreign key → Untitled.Key — NOT NULL — on delete cascade
  • Key (Skill_ID) — int unsigned — Foreign key → Untitled.Key — NOT NULL — on delete cascade
  • Field (Skill_level) — int — NOT NULL

Untitled (User)

  • Key (User_ID) — int unsigned — Primary key — NOT NULL — auto_increment
  • Field (Job_position_ID) — int unsigned — NOT NULL — auto_increment
  • Field (User_account) — varchar(30) — NOT NULL — 사용자 계정
  • Field (User_password) — varchar(20) — NOT NULL — 사용자 비밀번호
  • Field (User_name) — varchar(20) — NOT NULL — 사용자 이름
  • Field (User_nickname) — varchar(20) — NOT NULL — 사용자 닉네임
  • Field (User_introduce) — varchar(200) — 사용자 자기소개
  • Field (User_career) — tinyint — 사용자 경력기간
  • Field (User_address) — varchar(200) — 사용자 주소
  • Field (User_number) — varchar(20) — 사용자 연락처
  • Field (User_gender) — varchar(10) — NOT NULL — 사용자 성별
  • Field (User_email) — varchar(255) — NOT NULL — 사용자 이메일
  • Field (User_image) — varchar(255) — 이미지 URL
  • Key (UserType_id) — int unsigned — Foreign key → Untitled.Key — NOT NULL
  • Key (LoginType_id) — int unsigned — Foreign key → Untitled.Key — NOT NULL

Untitled (Job_position)

  • Key (Job_position_ID) — int unsigned — Primary key — NOT NULL — auto_increment
  • Field (Job_position_name) — varchar(20) — NOT NULL
  • Field (Job_position_desc) — varchar(200)

Untitled (Project_applicant)

  • Key (Project_ID) — int unsigned — Foreign key → Untitled.Key — NOT NULL — on delete cascade
  • Key (Applicant_ID) — int unsigned — Foreign key → Untitled.Key — NOT NULL — on delete cascade
  • Key (Project_position_ID) — int unsigned — Foreign key → Untitled.Key — NOT NULL — on delete cascade
  • Field (Apply_dt) — timestamp — NOT NULL
  • Field (Apply_status) — varchar(10) — NOT NULL — 'accept', 'reject', 'wait'

Untitled (Project_required_position)

  • Key (Project_ID) — int unsigned — Foreign key → Untitled.Key — NOT NULL — on delete cascade
  • Key (Project_position_ID) — int unsigned — Foreign key → Untitled.Key — NOT NULL — on delete cascade
  • Field (Recruit_num) — int — NOT NULL
  • Field (Recruited_num) — int — NOT NULL

Untitled (Project_task)

  • Key (Task_ID) — int unsigned — Primary key — NOT NULL — auto_increment
  • Key (Project_WBS_ID) — int unsigned — Foreign key → Untitled.Key — NOT NULL — auto_increment
  • Field (Parent_Task_ID) — references Project_task(Task_ID) on delete cascade
  • Field (Task_name) — varchar(20) — NOT NULL
  • Field (Task_desc) — varchar(200)
  • Key (Task_User_ID) — int unsigned — Foreign key → Untitled.Key
  • Field (Task_start_dt) — datetime — NOT NULL
  • Field (Task_end_dt) — datetime — NOT NULL
  • Field (Task_status) — varchar(20) — NOT NULL — 'stuck', 'proceed', 'complete', 'before start'
  • Field (Task_color) — varchar(7) — NOT NULL

Untitled (Project_issue)

  • Key (Issue_ID) — int unsigned — Primary key — NOT NULL — auto_increment
  • Key (Project_ID) — int unsigned — Foreign key → Untitled.Key — NOT NULL — on delete cascade
  • Field (Parent_Issue_ID) — int unsigned — references Project_issue(Issue_ID) on delete cascade
  • Key (Issue_creater_ID) — int unsigned — Foreign key → Untitled.Key
  • Field (Issue_name) — varchar(50) — NOT NULL
  • Field (Issue_desc) — varchar(200)
  • Field (Issue_create_dt) — timestamp — NOT NULL
  • Field (Issue_status) — varchar(10) — NOT NULL — 'resolving', 'complete', 'stuck'

Untitled (User_test_score)

  • Key (Test_ID) — int unsigned — Primary key — NOT NULL — auto_increment
  • Key (User_ID) — int unsigned — Foreign key → Untitled.Key — NOT NULL — on delete cascade
  • Field (Test_start_time) — timestamp — NOT NULL
  • Field (Test_end_time) — timestamp — NOT NULL
  • Field (Test_level) — varchar(10) — NOT NULL
  • Field (Test_score) — int — NOT NULL

Untitled (Skill)

  • Key (Skill_ID) — int unsigned — Primary key — NOT NULL — auto_increment
  • Field (Skill_name) — varchar(20) — NOT NULL
  • Field (Skill_desc) — varchar(200)

Untitled (Project)

  • Key (Project_ID) — int unsigned — Primary key — NOT NULL — auto_increment
  • Key (Project_creater_ID) — int unsigned — Foreign key → Untitled.Key — NOT NULL — on delete cascade
  • Field (Project_name) — varchar(50) — NOT NULL
  • Field (Project_desc) — varchar(200)
  • Field (Project_start_date) — datetime — NOT NULL
  • Field (Project_end_date) — datetime — NOT NULL
  • Field (Project_member_num) — int unsigned — NOT NULL
  • Field (Project_status) — varchar(10) — NOT NULL — 'hold', 'proceed', 'complete'
  • Field (Project_detailed_desc) — varchar(5000)
  • Field (Project_recruit_status) — varchar(20) — NOT NULL — 'in progress', 'closing'

Untitled (Authority)

  • Key (Autoriry_ID) — int unsigned — Primary key — NOT NULL — auto_increment
  • Field (Autority_name) — varchar(20) — NOT NULL
  • Field (Autority_desc) — varchar(200)

Untitled (User_project)

  • Key (User_ID) — int unsigned — Foreign key → Untitled.Key — NOT NULL — on delete cascade
  • Key (Project_ID) — int unsigned — Foreign key → Untitled.Key — NOT NULL — on delete cascade
  • Key (Project_position_ID) — int unsigned — Foreign key → Untitled.Key — NOT NULL

Untitled (User_project_authority)

  • Key (User_ID) — int unsigned — Foreign key → Untitled.Key — NOT NULL — on delete cascade
  • Key (Project_ID) — int unsigned — Foreign key → Untitled.Key — NOT NULL — on delete cascade
  • Key (Autoriry_ID) — int unsigned — Foreign key → Untitled.Key — NOT NULL — on delete cascade

Untitled (User_project_todolist)

  • Key (Todolist_ID) — int unsigned — Primary key — NOT NULL — auto_increment
  • Key (User_ID) — int unsigned — Foreign key → Untitled.Key — NOT NULL — on delete cascade
  • Key (Project_ID) — int unsigned — Foreign key → Untitled.Key — NOT NULL — on delete cascade
  • Field (Todo_name) — varchar(20) — NOT NULL
  • Field (Todo_status) — varchar(10) — NOT NULL — 'todo', 'complete'

Untitled (User_project_invited)

  • Key (User_ID) — int unsigned — Foreign key → Untitled.Key — NOT NULL — on delete cascade
  • Key (Project_ID) — int unsigned — Foreign key → Untitled.Key — NOT NULL — on delete cascade
  • Key (Project_position_ID) — int unsigned — Foreign key → Untitled.Key — NOT NULL — on delete cascade
  • Field (Invited_dt) — timestamp — NOT NULL
  • Field (Accept_status) — varchar(10) — NOT NULL — 'accept', 'reject', 'wait'

Untitled (Project_task_comment)

  • Key (Comment_ID) — int unsigned — Primary key — NOT NULL — auto_increment
  • Key (Task_ID) — int unsigned — Foreign key → Untitled.Key — NOT NULL — on delete cascade
  • Field (Parent_Comment_ID) — int unsigned — references Project_task_comment(Comment_ID) on delete cascade
  • Key (Comment_User_ID) — int unsigned — Foreign key → Untitled.Key
  • Field (Comment) — varchar(500) — NOT NULL
  • Field (Comment_create_dt) — timestamp — NOT NULL
  • Field (Comment_like_cnt) — int — NOT NULL

Untitled (Project_WBS)

  • Key (Project_WBS_ID) — int unsigned — Primary key — NOT NULL — auto_increment
  • Key (Project_ID) — int unsigned — Foreign key → Untitled.Key — NOT NULL — on delete cascade
  • Field (Parent_WBS_ID) — int unsigned — references Project_WBS(Project_WBS_ID) on delete cascade
  • Field (WBS_num) — int — NOT NULL
  • Field (WBS_name) — varchar(20) — NOT NULL
  • Key (WBS_User_ID) — int unsigned — Foreign key → Untitled.Key
  • Field (WBS_start_dt) — datetime — NOT NULL
  • Field (WBS_end_dt) — datetime — NOT NULL

Untitled (User_notice)

  • Key (Notice_ID) — int unsigned — Primary key — NOT NULL — auto_increment
  • Key (User_ID) — int unsigned — Foreign key → Untitled.Key — NOT NULL — auto_increment
  • Field (Notice_name) — varchar(20) — NOT NULL
  • Field (Notice_desc) — varchar(200) — NOT NULL
  • Field (Notice_category) — varchar(20) — NOT NULL