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