7

Tables (6)

Untitled (abc_corporation)

  • Key (ID) — Char(10) — Primary key — NOT NULL

Untitled (project)

  • Key (number) — char(10) — Primary key — NOT NULL
  • Key (ID) — Char(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (PMID) — char(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (loan)

  • Key (ID) — char(10) — Primary key — NOT NULL
  • Key (number) — char(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (project_manager)

  • Key (PMID) — char(10) — Primary key — NOT NULL
  • Field (name) — char(20)

Untitled (subcontractor)

  • Key (ID) — char(10) — Primary key — NOT NULL
  • Field (name) — char(20)
  • Key (number) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (ID2) — Char(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (specialization)

  • Key (uniquecode) — char(20) — Primary key — NOT NULL
  • Key (ID) — char(10) — Foreign key → Untitled.Key — NOT NULL