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