project
Tables (7)
AdminProject (Untitled4)
- project_id (프로젝트아이디) — int — Foreign key → Project.project_id — NOT NULL
- user_id (유저아이디) — String — Foreign key → User.user_id — NOT NULL
Comment (커멘트)
- comment_id (커멘트 아이디) — int — Primary key — NOT NULL
- comment (내용) — String
- user_id (유저아이디) — String — Foreign key → User.user_id — NOT NULL
- task_id (테스크 아이디) — int — Foreign key → Task.task_id — NOT NULL
Milestone (Untitled2)
- task_id (테스크 아이디) — int — Foreign key → Task.task_id — NOT NULL
- 진행상황 (Field) — float
Project (프로젝트)
- project_id (프로젝트아이디) — int — Primary key — NOT NULL
- state (상태) — State
- user_id (유저아이디) — String — Foreign key → User.user_id — NOT NULL
Tag (Untitled3)
- tag_id (Key) — int — Primary key — NOT NULL
- Content (내용) — String
- task_id (테스크 아이디) — int — Foreign key → Task.task_id — NOT NULL
Task (Untitled)
- task_id (테스크 아이디) — int — Primary key — NOT NULL
- content (테스크 내용) — String
- project_id (프로젝트아이디) — int — Foreign key → Project.project_id — NOT NULL
User (사용자)
- user_id (유저아이디) — String — Primary key — NOT NULL
- e-mail (이메일) — String
- password (패스워드) — String
- project_id (프로젝트아이디) — int — Foreign key → Project.project_id — NOT NULL