칸반 프로젝트
테이블 (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)