mirror of https://github.com/buster-so/buster.git
72 lines
2.1 KiB
YAML
72 lines
2.1 KiB
YAML
name: document
|
|
data_source_name: adventure_works
|
|
schema: ont_ont
|
|
database: postgres
|
|
description: Enterprise document management model supporting technical documentation tracking, product specification management, and organizational knowledge management. Facilitates document versioning analysis, content lifecycle tracking, and cross-reference capabilities between products and their documentation. Essential for regulatory compliance, technical support, and content governance initiatives.
|
|
model: null
|
|
relationships:
|
|
- name: product_document
|
|
ref_: null
|
|
expr: documentnode
|
|
type: foreign
|
|
description: Reference to products linked to this document
|
|
project_path: null
|
|
dimensions:
|
|
- name: documentnode
|
|
expr: documentnode
|
|
type: character varying
|
|
description: Identifier of the document node in the system
|
|
searchable: false
|
|
- name: title
|
|
expr: title
|
|
type: character varying
|
|
description: Title of the document
|
|
searchable: true
|
|
- name: filename
|
|
expr: filename
|
|
type: character varying
|
|
description: Name of the file
|
|
searchable: true
|
|
- name: fileextension
|
|
expr: fileextension
|
|
type: character varying
|
|
description: File extension of the document file
|
|
searchable: true
|
|
- name: revision
|
|
expr: revision
|
|
type: character
|
|
description: Revision number or letter of the document
|
|
searchable: true
|
|
- name: documentsummary
|
|
expr: documentsummary
|
|
type: text
|
|
description: Short summary or abstract of the document
|
|
searchable: false
|
|
- name: document
|
|
expr: document
|
|
type: bytea
|
|
description: Binary content of the document
|
|
searchable: false
|
|
- name: rowguid
|
|
expr: rowguid
|
|
type: uuid
|
|
description: Row GUID for unique identification
|
|
searchable: false
|
|
- name: modifieddate
|
|
expr: modifieddate
|
|
type: timestamp without time zone
|
|
description: Timestamp when the document was last modified
|
|
searchable: false
|
|
- name: status
|
|
expr: status
|
|
type: smallint
|
|
description: Status code for the document
|
|
searchable: true
|
|
measures:
|
|
- name: changenumber
|
|
expr: changenumber
|
|
agg: sum
|
|
description: Total number of changes to the document
|
|
type: integer
|
|
metrics: []
|
|
filters: [] |