ARM_REFERENCES

This table stores the references and attachments.

Details

Object type: TABLE

Primary Key

Name	Columns
ARM_REFERENCES_PK	REFERENCE_ID

Columns

Name	Data Type	Length	Precision	Scale	Null Allowed	Comments
REFERENCE_ID	NUMBER		18	0	No	Primary Key
OBJECT_ID	NUMBER		18	0	No	The object ID that this reference/attachment belongs to
REFERENCE_TYPE	VARCHAR2	4			No	The reference type: 'URL' or 'FILE'
REFERENCE_NAME	VARCHAR2	765			Yes	The reference name
URL	VARCHAR2	4000			Yes	The URL of the reference
FILE_ID	NUMBER				Yes	The File ID, FK to ARM_REFERENCE_FILES
FILE_NAME	VARCHAR2	765			Yes	The file name
FILE_MIMETYPE	VARCHAR2	128			Yes	The file mime type
OBJECT_VERSION_NUMBER	NUMBER		9	0	No	Used to implement optimistic locking. This number is incremented every time 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.
LAST_UPDATE_LOGIN	NUMBER				Yes	Who column. Stores the login/session ID of the user who last updated this row.
LAST_UPDATED_BY	VARCHAR2	255			No	Who column. Stores the ID of the user who last updated this row.
LAST_UPDATE_DATE	DATE				No	Who column. Stores the date when this row was last updated.
CREATED_BY	VARCHAR2	255			No	Who column. Stores the ID of the user who created this row.
CREATION_DATE	DATE				No	Who column. Stores the date when this row was created in the database.
CREATOR_ROLE	VARCHAR2	3			Yes	The role of the creator of the reference/attachment.
CREATOR_ID	VARCHAR2	255			No	The user ID of the person who created this.
USER_CREATION_DATE	DATE				No	The date of creation.
CARRY_FORWARD	VARCHAR2	1			Yes	Whether to carry the attachment forward.

Indexes

Index	Uniqueness	Columns
ARM_REFERENCES_N1	NONUNIQUE	OBJECT_ID, REFERENCE_TYPE
ARM_REFERENCES_PK	UNIQUE	REFERENCE_ID