Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | DOCUMENT |
| Short Name | DOC |
| View Name | CI_DOCUMENTS |
| Description | Details of a document, including the location in which it can be |
| found | |
| Sub-type of | SHAREABLE_ELEMENT |
| Versioning: | Structure of DOCUMENT versionable object |
| Rules: |
API Spec Uniqueness Criteria Deletion Rules |
| Descriptor: |
NAME |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_DOC |
| Changes: | Summary of changes to DOCUMENT in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| AUTHOR | VARCHAR2(30) | N | Author of the document - defaults to Oracle username
Prompt: Author | ||
| AUTHORISATION_DATE | DATE | Y | Date document was authorised
Prompt: Authorisation Date | ||
| AUTHORISATION_ID | VARCHAR2(30) | Y | Person or committee that authorized the creation of the document
Prompt: Authorised By | ||
| DATE_DOCUMENT_CHANGED | DATE | Y | Date the document was last changed (ie the physical document, not this row in CI_DOCUMENTS)
Prompt: Date Document Changed | ||
| DATE_DOCUMENT_CREATED | DATE | Y | Date the document was created (ie the physical document, not this row in CI_DOCUMENTS)
Prompt: Date Document Created | ||
| DOCUMENT_CHANGED_BY | VARCHAR2(30) | Y | Person who last changed the document
Prompt: Changed By | ||
| DOCUMENT_TYPE | VARCHAR2(40) | Y | Type of document
Prompt: Type | DOC_TYPE Non-enforced | |
| DOCUMENT_VERSION | NUMBER(3, 0) | N | The latest version number of the document.
Prompt: Version | 1 | |
| FORMAT | VARCHAR2(20) | Y | Document format - eg ASCII, Framemaker
Prompt: Format | ||
| LIBRARY_REFERENCE | VARCHAR2(80) | Y | Library reference for the document
Prompt: Ref | ||
| NAME | VARCHAR2(100) | N | Name of the Document
Prompt: Name | ||
| REMARK | VARCHAR2(240) | Y | Comment on the document
Prompt: Comment | ||
| SOURCE_PATH | VARCHAR2(240) | Y | Location of the flat file containing the document
Prompt: Source Path | ||
| STATUS | VARCHAR2(10) | Y | Document status
Prompt: Status | DOC_STATUS Non-enforced | |
| Multi-line Text | ||
|---|---|---|
| Name | Text Type | Prompt |
| DESCRIPTION | CDIDSC | Description |
| DOCUMENT | CDIDOC | Document Text |
| NOTES | CDINOT | Notes |
| Other Properties |
|---|
| DOCUMENT has the 20 user definable properties (USER_DEFINED_PROPERTY_0, _1, _2, _3 etc) for User Extensibility |
The following 'standard' properties are also inherited by all element types:
|
Other element types that reference DOCUMENT:
Note: