칸반 프로젝트

테이블 (3)

Kanban (CopyOfUntitled2)

  • kanbanNo (PK) — 기본 키 — NOT NULL
  • projectNo (FK) — 외래 키 → Project.projectNo — NOT NULL
  • content (Field3)
  • member (Field4)
  • tag (Field)
  • firstdate (Field2)
  • lastdate (Field5)

Member (Untitled)

  • userId (PK) — 기본 키 — NOT NULL
  • password (Field)
  • username (Field2)
  • email (Field3)
  • jobtitle (Field4)
  • department (Field5)

Project (Untitled2)

  • projectNo (PK) — 기본 키 — NOT NULL
  • userId (FK) — 외래 키 → Member.userId — NOT NULL
  • title (Field4)
  • memo (Field) — NOT NULL
  • pj_member (Field5)
  • pj_firstdate (Field7)
  • pj_lastdate (Field3)