document
Core TableDocuments
Stores all documents including drawings, manuals, certificates with revision control.
Primary Key
document_code
Record Type
Operational
Log Tables
document_revision_log
Summary Views
monthly_document_summary
Last Updated
May 20, 2026
AI Usefulness
4.4
/ 5.0
High value for AI analytics, prediction and automation.
All (6)Key (1)Calculated (2)
| Field Code | Caption | Data Type | Length | PK | Calculated | Description |
|---|---|---|---|---|---|---|
| document_code | Document Code | Varchar | 50 | — | Unique code for each document. | |
| document_name | Document Name | Varchar | 255 | — | — | Name of the document. |
| document_type_code | Document Type Code | Varchar | 50 | — | — | Reference to document_type. |
| revision_no | Revision No | Varchar | 20 | — | — | Current revision number. |
| file_url | File URL | Varchar | 1000 | — | — | Location of the document file. |
| effective_date | Effective Date | Date | — | — | — | Date the document is effective. |
Showing 6 of 6 (29 total in schema)
Relationships (Links to)
- document_type N:1Document classification.
- building N:1Document linked to a building.
- equipment N:NDocuments attached to equipment.
Operational Meaning
Versioned document store powering compliance, O&M handover and audit-ready evidence.
AI Opportunities
- Document compliance & expiry tracking
- Auto-tagging & classification
- Semantic search over manuals
- Drawing-to-asset linking
Suggested Queries
- "Show all expired certificates in Building 2."
- "Which O&M manuals are missing for critical equipment?"
- "List documents revised in the last 30 days."