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