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