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