ACA_DOCUMENT_VERSION

Details

Schema: FUSION
Object owner: ACA
Object type: TABLE
Tablespace: Default

Primary Key

Name	Columns
ACA_DOCUMENT_VERSION_B_PK	DOCUMENT_VERSION_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
DOCUMENT_VERSION_ID	NUMBER		18	Yes	Primary key of the document version.
START_EFFECTIVE_DATE	DATE				Date when last version/rev became effective
END_EFFECTIVE_DATE	DATE				Date when this version/rev became ineffective
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
DOCUMENT_NUMBER	VARCHAR2	150		Yes	The document ID is a user-friendly identifier of the document.
DOCUMENT_TYPE	VARCHAR2	80		Yes	Classification Type, which also defines attribution and behaviour
DOCUMENT_VERSION	VARCHAR2	200			Sequential version number; maybe configurable in the future e.g. A,B,C
LATEST_VERSION	VARCHAR2	1			'Y' if this document version is latest (current) version
VERSION_NUMBER	NUMBER		9		Internal incremental number of the document version
REVISION	VARCHAR2	100			Revision indicator, which is assigned manually or by ECO
PRODUCT_LINE	VARCHAR2	80			Description of the product line assigned to a document version.
DOCUMENT_CATEGORY	VARCHAR2	80			Describes the purpose of the document e.g. spec, test doc, design etc.
LIFECYCLE_PHASE	VARCHAR2	30			Lifecycle Phase of the document
APPROVAL_STATUS	VARCHAR2	30			Approval Status of the document
DOCUMENT_VERSION_MASTER_ID	NUMBER		18		The Master ID for all versions of a document.
DOCUMENT_MASTER_ID	VARCHAR2	20			Id of Master document related to the document version.	Obsolete
LOCKED_DATE	DATE				Indicates if the document is locked
LOCKED_BY	VARCHAR2	64			Who has locked the document currently
LAST_UNLOCKED_DATE	DATE				Date when the document was unlocked last.
LAST_UNLOCKED_BY	VARCHAR2	64			Who has unlocked the document last time
SOURCE_SYSTEM	VARCHAR2	64			Name of source System e.g. Solidworks
SOURCE_SYSTEM_VERSION	VARCHAR2	64			Version of the source system; not used by CAD Integration today, but may be interesting for users
SOURCE_FILE_TYPE	VARCHAR2	32			Type of the source file document e.g. CAX_TYPE.
SOURCE_FILE_SUBTYPE	VARCHAR2	64			Subtype of the source file document e.g. CAX_SUBTYPE.
FAMILY	VARCHAR2	256			Part family template file name.
CONFIGURATION	VARCHAR2	512			Configuration or variant of the part family instance
VARIANT	VARCHAR2	512			Part family instance identifier; value, depending on CAD system
MODEL_TYPE	VARCHAR2	128			Internal identifier to detect part family templates, members, instances, generics, drawings from normal files
STANDARD_PART	VARCHAR2	256			Identifier if the document version is a standard part.
DOCUMENT_TIMESTAMP	VARCHAR2	64			Internal timestamp used for CAD integration.
FROM_CONTEXT_ACTION_ID	NUMBER		18		The From Context Action Id for document version.
UNTIL_CONTEXT_ACTION_ID	NUMBER		18		The Until Context Action Id for document version.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.

Foreign Keys

Table	Foreign Table	Foreign Key Column
aca_document_version_tl	aca_document_version_b	DOCUMENT_VERSION_ID
aca_document_structure	aca_document_version_b	PARENT_DOCUMENT_VERSION_ID

Indexes

Index	Uniqueness	Tablespace	Columns
ACA_DOCUMENT_VERSION_B_N1	Non Unique	Default	DOCUMENT_VERSION_MASTER_ID
ACA_DOCUMENT_VERSION_B_U1	Unique	Default	DOCUMENT_VERSION_ID