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)