ttttt
Tables (26)
alarm
- id — int — Primary key — NOT NULL — key
- recipient_id — int — Foreign key → users.id — 받을user
- actor_id — int — Foreign key → users.id — 액션을한 유저
- title — varchar(200) — 알림제목
- comment — varchar(200) — 알림내용
- link — varchar(200) — 알림링크
- read_status — tinyint(1) — 읽었는지여부
- updated_at — timestamp — NOT NULL
- created_at — timestamp — NOT NULL
attachments
- id — int — Primary key — NOT NULL — id
- file_category — varchar(50) — 카테고리(테이블명)
- file_nm — varchar(50) — 파일이름
- file_path — varchar(300) — 파일경로
- updated_at — timestamp
- created_at — timestamp
projects
- id — int — Primary key — NOT NULL — key
- task_id — int — Foreign key → tasks.id — NOT NULL — 과업id
- workspace_id — int — NOT NULL — 워크스페이스ID
- project_nm — varchar(100) — 프로젝트명
- deleted_at — timestamp
- updated_at — timestamp — NOT NULL
- created_at — timestamp — NOT NULL
subtask_comments
- id — int — Primary key — NOT NULL — key
- subtask_id — int — Foreign key → subtasks.id — NOT NULL — 상세업무ID
- user_id — int — Foreign key → users.id — NOT NULL — 유저ID
- parent_comment_id — int — 부모 코멘트
- subtask_comment — text — 코멘트내용
- updated_at — timestamp
- created_at — timestamp
subtask_issues
- id — int — Primary key — NOT NULL — key
- subtask_id — int — Foreign key → subtasks.id — NOT NULL — 상세업무ID
- user_id — int — Foreign key → users.id — NOT NULL — 유저ID
- issue_title — varchar(100) — 이슈제목
- issue_text — text — 이슈내용
- updated_at — timestamp — NOT NULL
- created_at — timestamp — NOT NULL
subtask_members
- id — int — Primary key — NOT NULL — subtask_memver_id
- user_id — int — Foreign key → users.id — NOT NULL — 유저ID
- subtask_id — int — Foreign key → subtasks.id — NOT NULL — 테스크ID
- start_date — date — 시작일자
- end_date — date — 종료일자
- status — varchar(100) — 상태(수행완료/수행요청중/수행대기/수행중/중단/취소)
- working_time — int — 일평균시간
- price — int — 시급
- updated_at — timestamp — NOT NULL
- created_at — timestamp — NOT NULL
subtask_reports
- id — int — Primary key — NOT NULL — key
- subtask_member_id — int — Foreign key → subtask_members.id — NOT NULL — subtask_memver_id
- title — varchar(200) — 제목
- text — mediumtext — 텍스트
- writed_date — date — 일지 작성일
- updated_at — timestamp
- created_at — timestamp
subtasks
- id — int — Primary key — NOT NULL — 상세업무ID
- workspace_id — int — Foreign key → tasks.workspace_id — NOT NULL — 워크스페이스ID
- task_id — int — Foreign key → tasks.id — NOT NULL — task ID
- subtask_name — varchar(100) — 상세업무명
- subtask_description — text — 설명
- subtask_category — int — 유형 tb_code 사용
- working_day — int — 수행일수
- order — int — 순번
- start_date — date — 시작일자
- end_date — date — 종료일자
- updated_at — timestamp — NOT NULL
- created_at — timestamp — NOT NULL
task_comments
- id — int — Primary key — NOT NULL — key
- task_id — int — Foreign key → tasks.id — NOT NULL — 과업ID
- user_id — int — Foreign key → users.id — NOT NULL — 유저ID
- parent_comment_id — int
- comment — text
- updated_at — timestamp — NOT NULL
- created_at — timestamp — NOT NULL
task_members
- id — int — Primary key — NOT NULL — KEY
- workspace_id — int — Foreign key → tasks.workspace_id — NOT NULL — 워크스페이스ID
- task_id — int — Foreign key → tasks.id — NOT NULL — task ID
- user_id — int — Foreign key → users.id — NOT NULL — 유저ID
- updated_at — timestamp — NOT NULL
- created_at — timestamp — NOT NULL
tasks
- id — int — Primary key — NOT NULL — 과업id
- workspace_id — int — Foreign key → workspaces.id — NOT NULL — 워크스페이스ID
- task_name — varchar(255) — 과업명
- task_category — int — 과업유형 tb_code 테이블 사용
- task_description — varchar(255) — 과업 한줄설명
- task_sub_description — varchar(255) — 과업 상세설명
- deleted_at — timestamp
- updated_at — timestamp — NOT NULL
- created_at — timestamp — NOT NULL
tb_code
- id — int — Primary key — NOT NULL — code_id
- category — int — 코드카테고리
- category_name — varchar(40) — 코드카테고리
- parent_code — int — 부모코드
- code — int — 코드
- code_name — varchar(50) — 코드한글명
- updated_at — timestamp
- created_at — timestamp
user_career
- id — int — Primary key — NOT NULL
- user_id — int — Foreign key → users.id — NOT NULL — 유저ID
- career_type — varchar(10) — 경력/학력
- career_name — varchar(50) — 회사/학교명
- career_role — varchar(50) — 업무분야
- start_date — date — 시작일자
- end_date — date — 시작일자
- description — text — 설명
- deleted_at — timestamp
- updated_at — timestamp — NOT NULL — 업데이트ts
- created_at — timestamp — NOT NULL — 생성ts
user_certification
- id — int — Primary key — NOT NULL
- user_id — int — Foreign key → users.id — NOT NULL — 유저ID
- certificate — varchar(50) — 자격증
- acquisition_date — date — 취득날짜
- updated_at — timestamp — NOT NULL — 업데이트ts
- created_at — timestamp — NOT NULL — 생성ts
user_education
- id — int — Primary key — NOT NULL
- user_id — int — Foreign key → users.id — NOT NULL — 유저ID
- degree — varchar(50) — 고등학교/전문대학/대학/대학원
- institution — varchar(50) — 기관이름
- major — varchar(50) — 전공
- start_date — date — 시작일자
- end_date — date — 시작일자
- deleted_at — timestamp
- updated_at — timestamp — 업데이트ts
- created_at — timestamp — 생성TS
user_keyword
- id — int — Primary key — NOT NULL
- user_id — int — Foreign key → users.id — NOT NULL — 유저ID
- code_id — int — Foreign key → tb_code.code — NOT NULL — code_id
- updated_at — timestamp — NOT NULL — 업데이트ts
- created_at — timestamp — NOT NULL — 생성ts
user_links
- id — int — Primary key — NOT NULL — key
- user_id — int — Foreign key → users.id — NOT NULL — 유저ID
- link_type — varchar(50) — 링킅타입(facebook/linkedin/etc)
- url — varchar(200) — url
- updated_at — timestamp — NOT NULL — 업데이트ts
- created_at — timestamp — NOT NULL — 생성ts
user_network
- id — int — Primary key — NOT NULL
- user_id — int — Foreign key → users.id — NOT NULL — 유저ID
- to_user_id — int — NOT NULL — 유저ID
- deleted_at — timestamp — 팔로워/팔로잉
- updated_at — timestamp — NOT NULL — 업데이트ts
- created_at — timestamp — NOT NULL — 생성ts
user_project
- id — int — Primary key — NOT NULL
- user_id — int — Foreign key → users.id — NOT NULL — 유저ID
- project_name — varchar(100) — 프로젝트이름
- project_describe — mediumtext — 프로젝트설명
- start_date — date — 시작날짜
- end_date — date — 종료날짜
- attached_file_id — int — Foreign key → attachments.id — 첨부파일id
- deleted_at — timestamp
- updated_at — timestamp — NOT NULL — 업데이트ts
- created_at — timestamp — NOT NULL — 생성ts
user_work_cate
- id — int — Primary key — NOT NULL
- code_id — int — Foreign key → tb_code.code — NOT NULL — code_id
- user_id — int — Foreign key → users.id — NOT NULL — 유저ID
- deleted_at — timestamp
- updated_at — timestamp — NOT NULL — 업데이트ts
- created_at — timestamp — NOT NULL — 생성ts
users
- id — int — Primary key — NOT NULL — 유저ID
- password — varchar(60) — 암호
- business_field — varchar(100) — 주요 역할 분야
- role_field — int — (코드사용) 사용자 롤 필드(상위카테고리)
- price — int — 시급
- working_time — int — 근무시간
- phone_num — varchar(15) — 휴대폰번호
- email — varchar(30) — 이메일
- nickname — varchar(50) — 닉네임
- self_introduction — text — 자기소개
- status — varchar(20) — 휴먼/활성화/가입대기)
- is_marketing_agreed — tinyint(1) — 마케팅동의여부
- is_privacy_agreed — tinyint(1) — 개인정보동의여부
- is_email_agreed — tinyint(1) — 이메일동의여부
- is_push_agreed — tinyint(1) — push알림동의여부
- is_sns_agreed — tinyint(1) — SNS알림동의여부
- profile_display_status — varchar(10) — 전체/팔로워/노출안함
- is_certificated — tinyint(1) — 완료/안함
- deleted_at — timestamp
- updated_at — timestamp — NOT NULL — 업데이트ts
- created_at — timestamp — NOT NULL — 생성ts
workspace_comments
- id — int — Primary key — NOT NULL — key
- workspace_id — int — Foreign key → workspaces.id — NOT NULL — 과업ID
- user_id — int — Foreign key → users.id — NOT NULL — 유저ID
- parent_comment_id — int
- comment — text
- updated_at — timestamp — NOT NULL
- created_at — timestamp — NOT NULL
workspace_members
- id — int — Primary key — NOT NULL — KEY
- workspace_id — int — NOT NULL — 워크스페이스ID
- user_id — int — Foreign key → users.id — NOT NULL — 유저ID
- status — varchar(10) — 권한(소유자/관리자/사용자/승인대기자/초대받음)
- deleted_at — timestamp
- updated_at — timestamp — NOT NULL — 업데이트TS
- created_at — timestamp — NOT NULL — 생성 TS
workspace_recruitment
- id — int — Primary key — NOT NULL — key
- workspace_id — int — Foreign key → workspaces.id — NOT NULL — 워크스페이스ID
- code_id — int — Foreign key → tb_code.id — NOT NULL — 코드id
- is_del — tinyint(1) — 삭제여부
- updated_at — timestamp — NOT NULL
- created_at — timestamp — NOT NULL
workspace_tag
- id — int — Primary key — NOT NULL — key
- workspace_id — int — Foreign key → workspaces.id — NOT NULL — 워크스페이스ID
- code_id — int — Foreign key → tb_code.id — NOT NULL — 코드id
- is_del — tinyint(1) — 삭제여부
- updated_at — timestamp — NOT NULL
- created_at — timestamp — NOT NULL
workspaces
- id — int — Primary key — NOT NULL — 워크스페이스ID
- major_title — varchar(100) — 가장 위에 있는 제목
- sub_title — varchar(200) — 소제목
- describe — mediumtext — 안에 설명 (text)
- is_recruitment_status — tinyint(1) — 모집여부
- read_cnt — int — 읽은횟수
- shared_cnt — int — 공유건수
- is_logo — tinyint(1) — 로고여부
- deleted_at — timestamp
- updated_at — timestamp — NOT NULL — 업데이트 ts
- created_at — timestamp — NOT NULL — 생성 ts