교수님 리포트용 PWD (Task-Item-Doc)

테이블 (13)

Document (document)

  • Document ID (doc id) — Number — 기본 키 — NOT NULL
  • Folder ID (folder id) — Number — 외래 키 → Folder.Folder ID — NOT NULL
  • Project ID (project id) — Number — 외래 키 → 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 — 기본 키 — NOT NULL
  • Document ID (doc id) — Number — 외래 키 → Document.Document ID — NOT NULL
  • Folder ID (folder id) — Number — 외래 키 → Document.Folder ID — NOT NULL
  • Task ID (task id) — Number — 외래 키 → Task.Task ID — NOT NULL
  • Item ID (item id) — Number — 외래 키 → Item.Item ID — NOT NULL
  • Project ID (project id) — Number — 외래 키 → Project.Project ID — NOT NULL
  • Revision Count (revision count) — Number

Document Relation Revision

  • id — Number — 기본 키 — NOT NULL
  • Relation ID (relation id) — Number — 외래 키 → Document Relation.Relation ID — NOT NULL
  • Document ID (doc id) — Number — 외래 키 → Document Relation.Document ID — NOT NULL
  • Folder ID (folder id) — Number — 외래 키 → Document Relation.Folder ID — NOT NULL
  • Task ID (task id) — Number — 외래 키 → Document Relation.Task ID — NOT NULL
  • Item ID (item id) — Number — 외래 키 → Document Relation.Item ID — NOT NULL
  • Project ID (project id) — Number — 외래 키 → 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 — 기본 키 — NOT NULL
  • Document ID (doc id2) — Number — 외래 키 → Document.Document ID — NOT NULL
  • Folder ID (folder id) — Number — 외래 키 → Document.Folder ID — NOT NULL
  • Project ID (project id) — Number — 외래 키 → 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 — 기본 키 — NOT NULL
  • Project ID (project id) — Number — 외래 키 → Project.Project ID — NOT NULL
  • Folder Name (name) — Varchar
  • Parent ID (parent id) — Number

Folder Revision (folder revision)

  • id — 기본 키 — NOT NULL
  • Folder ID (id2) — Number — 외래 키 → Folder.Folder ID — NOT NULL
  • Project ID (project id) — Number — 외래 키 → Folder.Project ID — NOT NULL
  • Folder Name (name) — Varchar
  • Parent ID (parent id) — Number
  • Revision Count (revision count) — Number

Item (item)

  • Item ID (item id) — Number — 기본 키 — NOT NULL
  • Project ID (project id) — Number — 외래 키 → Project.Project ID — NOT NULL
  • Item Name (name) — Varchar
  • Parent ID (parent id) — Number
  • Revision Count (revision count) — Number

Item Revision (item revision)

  • id — Number — 기본 키 — NOT NULL
  • Item ID (item id) — Number — 외래 키 → Item.Item ID — NOT NULL
  • Project ID (project id) — Number — 외래 키 → Item.Project ID — NOT NULL
  • PBS Name (name) — Varchar
  • Parent ID (parent id) — Number
  • Revision Count (revision count) — Number

Project (project)

  • Project ID (id) — Number — 기본 키 — NOT NULL
  • Project Name (name) — Varchar
  • Create Date (date) — DateTime
  • Create User ID (user id) — Number

Relation (relation)

  • Relation ID (id) — Number — 기본 키 — NOT NULL
  • Task ID (task id) — Number — 외래 키 → Task.Task ID — NOT NULL
  • Item ID (item id) — Number — 외래 키 → Item.Item ID — NOT NULL
  • Project ID (project id) — Number — 외래 키 → Project.Project ID — NOT NULL

Relation Revision

  • id — Number — 기본 키 — NOT NULL
  • Relation ID (relation id) — Number — 외래 키 → Relation.Relation ID — NOT NULL
  • Task ID (task id) — Number — 외래 키 → Relation.Task ID — NOT NULL
  • Item ID (item id) — Number — 외래 키 → Relation.Item ID — NOT NULL
  • Project ID (project id) — Number — 외래 키 → Relation.Project ID — NOT NULL
  • Item Revision Count (item revision count) — Number
  • Task Revision Count (task revision count) — Number
  • Folder Revision Count (folder revision count) — Number
  • Doc Recision Count (doc revision count)

Task (task)

  • Task ID (task id) — Number — 기본 키 — NOT NULL
  • Project ID (Project id) — Number — 외래 키 → Project.Project ID — NOT NULL
  • Task Name (name) — Varchar
  • Parent ID (parent id) — Number
  • Revision Count (revision count) — Number

Task Revision (task revision)

  • id — Number — 기본 키 — NOT NULL
  • Task ID (Task id) — Number — 외래 키 → Task.Task ID — NOT NULL
  • Project ID (Project id) — Number — 외래 키 → Task.Project ID — NOT NULL
  • Task Name (name) — Varchar
  • Parent ID (parent id) — Number
  • Revision Count (revision count) — Number