PWD

Tables (17)

Activity (activity)

  • Activity ID (activity id) — Number — Primary key — NOT NULL
  • WBS ID (wbs id) — Number — Foreign key → WBS.WBS ID — NOT NULL
  • Project ID (Project id) — Number — Foreign key → WBS.Project ID — NOT NULL
  • Activity Name (name) — Varchar
  • Start Date (start date) — DateTime
  • End Date (end date) — DateTime
  • Revision Count (revision count) — Number

Activity Revision (activity revision)

  • id — Number — Primary key — NOT NULL
  • Activity ID (activity id) — Number — Foreign key → Activity.Activity ID — NOT NULL
  • WBS ID (wbs id) — Number — Foreign key → Activity.WBS ID — NOT NULL
  • Project ID (Project id) — Number — Foreign key → Activity.Project ID — NOT NULL
  • Activity Name (name) — Varchar
  • Start Date (start date) — DateTime
  • End Date (end date) — DateTime
  • Revision Count (revision count) — Number

Document (document)

  • Document ID (doc id) — Number — Primary key — NOT NULL
  • Folder ID (folder id) — Number — Foreign key → Folder.Folder ID — NOT NULL
  • Project ID (project id) — Number — Foreign key → Folder.Project ID — NOT NULL
  • Document Name (name) — Varchar
  • File Format (format) — Varcher
  • File Path (path) — Varcher
  • Create Date (date) — DateTime
  • Revision Count (revision count) — Number

Document Relation (Doc Relation)

  • Relation ID (id) — Number — Primary key — NOT NULL
  • Document ID (doc id) — Number — Foreign key → Document.Document ID — NOT NULL
  • Folder ID (folder id) — Number — Foreign key → Document.Folder ID — NOT NULL
  • WBS ID (wbs id) — Number — Foreign key → WBS.WBS ID — NOT NULL
  • Activity ID (activity id) — Number — Foreign key → Activity.Activity ID — NOT NULL
  • PBS ID (pbs id) — Number — Foreign key → PBS.PBS ID — NOT NULL
  • Part ID (part id) — Number — Foreign key → Part.Part ID — NOT NULL
  • Project ID (project id) — Number — Foreign key → Project.Project ID — NOT NULL
  • Revision Count (revision count) — Number

Document Relation Revision

  • id — Number — Primary key — NOT NULL
  • Relation ID (relation id) — Number — Foreign key → Document Relation.Relation ID — NOT NULL
  • Document ID (doc id) — Number — Foreign key → Document Relation.Document ID — NOT NULL
  • Folder ID (folder id) — Number — Foreign key → Document Relation.Folder ID — NOT NULL
  • WBS ID (wbs id) — Number — Foreign key → Document Relation.WBS ID — NOT NULL
  • Activity ID (activity id) — Number — Foreign key → Document Relation.Activity ID — NOT NULL
  • PBS ID (pbs id) — Number — Foreign key → Document Relation.PBS ID — NOT NULL
  • Part ID (part id) — Number — Foreign key → Document Relation.Part ID — NOT NULL
  • Project ID (id2) — Number — Foreign key → Document Relation.Project ID — NOT NULL
  • Doc Revision Count (doc revision count) — Number
  • item Revision Count (item revision count) — Number
  • Revision Count (revision count) — Number

Document Revision (document revision)

  • id — Primary key — NOT NULL
  • Document ID (doc id2) — Number — Foreign key → Document.Document ID — NOT NULL
  • Folder ID (folder id) — Number — Foreign key → Document.Folder ID — NOT NULL
  • Project ID (project id) — Number — Foreign key → Document.Project ID — NOT NULL
  • Document ID (doc id) — Number
  • Document Name (name) — Varchar
  • File Format (format) — Varcher
  • File Path (path) — Varcher
  • Create Date (date) — DateTime
  • Revision Count (revision count) — Number

Folder (folder)

  • Folder ID (id) — Number — Primary key — NOT NULL
  • Project ID (project id) — Number — Foreign key → Project.Project ID — NOT NULL
  • Folder Name (name) — Varchar
  • Parent ID (parent id) — Number

Folder Revision (folder revision)

  • id — Primary key — NOT NULL
  • Folder ID (id2) — Number — Foreign key → Folder.Folder ID — NOT NULL
  • Project ID (project id) — Number — Foreign key → Folder.Project ID — NOT NULL
  • Folder Name (name) — Varchar
  • Parent ID (parent id) — Number
  • Revision Count (revision count) — Number

PBS (pbs)

  • PBS ID (pbs id) — Number — Primary key — NOT NULL
  • Project ID (project id) — Number — Foreign key → Project.Project ID — NOT NULL
  • PBS Name (name) — Varchar
  • Parent ID (parent id) — Number
  • Revision Count (revision count) — Number

PBS Revision (pbs revision)

  • id — Number — Primary key — NOT NULL
  • PBS ID (pbs id) — Number — Foreign key → PBS.PBS ID — NOT NULL
  • Project ID (project id) — Number — Foreign key → PBS.Project ID — NOT NULL
  • PBS Name (name) — Varchar
  • Parent ID (parent id) — Number
  • Revision Count (revision count) — Number

Part (part)

  • Part ID (part id) — Number — Primary key — NOT NULL
  • PBS ID (pbs id) — Number — Foreign key → PBS.PBS ID — NOT NULL
  • Project ID (project id) — Number — Foreign key → PBS.Project ID — NOT NULL
  • Part Name (name) — Varchar
  • Model (model) — Varchar
  • Manufacturer (manufacturer) — Varchar
  • Size (Field) — Varchar
  • Serial Number (serial number) — Varchar
  • Revision Count (revision count) — Number

Part Revision (part revision)

  • id — Number — Primary key — NOT NULL
  • Part ID (part id) — Number — Foreign key → Part.Part ID — NOT NULL
  • PBS ID (pbs id) — Number — Foreign key → Part.PBS ID — NOT NULL
  • Project ID (project id) — Number — Foreign key → Part.Project ID — NOT NULL
  • Part Name (name) — Varchar
  • Model (model) — Varchar
  • Manufacturer (manufacturer) — Varchar
  • Size (size) — Varchar
  • Serial Number (serial number) — Varchar
  • Revision Count (revision count) — Number

Project (project)

  • Project ID (id) — Number — Primary key — NOT NULL
  • Project Name (name) — Varchar
  • Create Date (date) — DateTime
  • Create User ID (user id) — Number

Relation (relation)

  • Relation ID (id) — Number — Primary key — NOT NULL
  • WBS ID (wbs id) — Number — Foreign key → WBS.WBS ID — NOT NULL
  • PBS ID (pbs id) — Number — Foreign key → PBS.PBS ID — NOT NULL
  • Project ID (project id) — Number — Foreign key → Project.Project ID — NOT NULL

Relation Revision

  • id — Number — Primary key — NOT NULL
  • Relation ID (relation id) — Number — Foreign key → Relation.Relation ID — NOT NULL
  • WBS ID (wbs id) — Number — Foreign key → Relation.WBS ID — NOT NULL
  • PBS ID (pbs id) — Number — Foreign key → Relation.PBS ID — NOT NULL
  • Project ID (project id) — Number — Foreign key → Relation.Project ID — NOT NULL
  • WBS Revision Count (wbs revision count) — Number
  • PBS Revision Count (pbs revision count) — Number
  • Revision Count (revision count) — Number

WBS

  • WBS ID (wbs id) — Number — Primary key — NOT NULL
  • Project ID (Project id) — Number — Foreign key → Project.Project ID — NOT NULL
  • WBS Name (name) — Varchar
  • Parent ID (parent id) — Number
  • Revision Count (revision count) — Number

WBS Revision (wbs revision)

  • id — Number — Primary key — NOT NULL
  • WBS ID (wbs id) — Number — Foreign key → WBS.WBS ID — NOT NULL
  • Project ID (Project id) — Number — Foreign key → WBS.Project ID — NOT NULL
  • WBS Name (name) — Varchar
  • Parent ID (parent id) — Number
  • Revision Count (revision count) — Number