project
Tables (6)
AUTH (Untitled2)
- Auth_ID (Key) — PK — Primary key — NOT NULL
- Member_ID (PK) — FK — Foreign key → MEMBER.Member_ID — NOT NULL
- Key2 — Foreign key → MEMBER.Key2 — NOT NULL
- Auth (Field)
Address (Embedded)
- Street (Field) — VO
- Zipcode (Field2) — VO
MEMBER (Untitled)
- Member_ID (PK) — PK — Primary key — NOT NULL
- TEAM_ID (FK) — FK — Foreign key → TEAM.TEAM_ID — NOT NULL
- Auth_ID (Key) — FK — Foreign key → TEAM.Member_ID — NOT NULL
- Key2 — Foreign key → TEAM.Project_ID — NOT NULL
- Address (Field2) — VO
- email (Field)
- name (Field3)
PROJECT (Untitled3)
- Project_ID (Key) — PK — Primary key — NOT NULL
- TEAM_ID (PK) — PK — Foreign key → TEAM.TEAM_ID — NOT NULL
- Key2 — Foreign key → TEAM.Project_ID — NOT NULL
- projectName (Field)
- date (Field2)
- name (Field3)
- status (Field4) — VO
Status (Enum)
- on (Field)
- complete (Field2)
- over (Field3)
TEAM (/)
- TEAM_ID (PK) — FK — Primary key — NOT NULL
- Member_ID (Key) — PK — Primary key — NOT NULL
- Project_ID (Key2) — PK — Primary key — NOT NULL
- NAME (Field)