교수님 리포트용 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