TODO

Tables (6)

file (Untitled5)

  • Key (파일 pk) — Primary key — NOT NULL
  • path (경로)
  • Key (task pk) — Foreign key → task.Key — NOT NULL

img (Untitled2)

  • Key — Primary key — NOT NULL
  • path (저장경로)
  • Field

project (Untitled)

  • Key (pk) — int — Primary key — NOT NULL
  • pname (프로젝트명) — varchar
  • state (상태)
  • ispublic (공개여부)
  • pro_img (프로젝트 이미지) — Foreign key → img.Key — NOT NULL

project_member (Untitled3)

  • Key — Primary key — NOT NULL
  • Key (프로젝트 pk) — int — Foreign key → project.Key — NOT NULL
  • user_no (멤버) — ? — Foreign key → user.pk — NOT NULL
  • role (권한)

task (Untitled4)

  • Key — Primary key — NOT NULL
  • Key (생성자) — Foreign key → project_member.Key — NOT NULL
  • Key (담당자) — Foreign key → project_member.Key — NOT NULL
  • start_date (시작일)
  • due_date (기간)
  • state (상태)
  • progress_rate (진행률)
  • ispublic (공개여부)
  • parent (상위 pk) — Foreign key → task.Key — NOT NULL

user (사용자)

  • pk (사용자 pk) — ? — Primary key — NOT NULL
  • deptno (부서번호) — ?
  • id (아이디) — varchar
  • password (비밀번호)
  • name (이름)
  • phone (연락처)
  • email (이메일)
  • position (직급)
  • Field
  • user_img (사용자이미지) — Foreign key → img.Key — NOT NULL