Table Detail Report
DMS_MEDIA_OWNERSHIP
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Digital Media Services Media Ownership |
Definition: | Contains media ownership keys that relate to media objects. |
Table Type: | ACTIVITY |
Column Detail - DMS_MEDIA_OWNERSHIP
Column Name | Type | Null? | Definition |
---|---|---|---|
DMS_MEDIA_IDENTIFIER_ID | DOUBLE | N | The ID of the row in the DMS_MEDIA_IDENTIFIER table that the ownership key relates to. |
DMS_MEDIA_OWNERSHIP_ID | DOUBLE | N | The primary key of the DMS_MEDIA_OWNERSHIP table. |
OWNERSHIP_UUID | VARCHAR(255) | N | Contains the ownership key. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - DMS_MEDIA_OWNERSHIP
Child Column in DMS_MEDIA_OWNERSHIP(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | DMS_MEDIA_IDENTIFIER_ID | DMS_MEDIA_IDENTIFIER | DMS_MEDIA_IDENTIFIER_ID |
DMS_MEDIA_SIGNATURE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Digital Media Services Signature |
Definition: | Contains the digital signatures for media instances. |
Table Type: | ACTIVITY |
Column Detail - DMS_MEDIA_SIGNATURE
Column Name | Type | Null? | Definition |
---|---|---|---|
DMS_MEDIA_INSTANCE_ID | DOUBLE | N | The media instance that is associated with this row. |
DMS_MEDIA_SIGNATURE_ID | DOUBLE | N | Unique identifier for the row. |
SIGNATURE_BLOB_ID | DOUBLE | N | Id of the LONG_BLOB row where the signature is stored. |
SIGNER | VARCHAR(100) | N | The username of the person that signed the media instance. |
SIGN_DT_TM | DATETIME | N | The date and time that the media instance was signed. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - DMS_MEDIA_SIGNATURE
Child Column in DMS_MEDIA_SIGNATURE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | DMS_MEDIA_INSTANCE_ID | DMS_MEDIA_INSTANCE | DMS_MEDIA_INSTANCE_ID |
SIGNATURE_BLOB_ID | LONG_BLOB | LONG_BLOB_ID |
DMS_MEDIA_XREF
Column Section | Top of Page |
Table-level Detail
Description: | DMS media cross reference. |
Definition: | Contains information about the general classification of media items. |
Table Type: | ACTIVITY |
Column Detail - DMS_MEDIA_XREF
Column Name | Type | Null? | Definition |
---|---|---|---|
DMS_MEDIA_IDENTIFIER_ID | DOUBLE | N | References the DMS_MEDIA_IDENTIFIER table for the media object identifier. |
DMS_MEDIA_XREF_ID | DOUBLE | N | Unique identifier for this row. |
IDENTIFIER | VARCHAR(64) | Y | OBSOLETE - NO LONGER USED - Media cross ref identifier. |
PARENT_ENTITY_ID | DOUBLE | N | The foreign key that this media instance is referencing. |
PARENT_ENTITY_ID_STRING | VARCHAR(128) | Y | We now have a non-Millennium implementation and need the ability to create cross references to UIDs represented as strings instead of only indexes to other Millennium tables. So instead of just parent_entity_name/id of orders(table)/1234 we may have something like orders(table)/1234@domainxyz where the parent_entiry_id_string is a string representation of the ID. |
PARENT_ENTITY_NAME | VARCHAR(30) | N | The name of the foreign table that the parent_entity_id refers to. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
DMS_REF
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Digital Media Services Reference. |
Definition: | Contains reference names and display values for attributes of media instances. |
Table Type: | REFERENCE |
Column Detail - DMS_REF
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
DISPLAY | VARCHAR(60) | N | The user visible text |
DMS_REF_ID | DOUBLE | N | Unique identifier for this row |
REF_GROUP | VARCHAR(32) | N | String to group sets of reference rows (uppercase without spaces) |
REF_KEY | VARCHAR(32) | N | Unique string to identify a row (uppercase without spaces) within a group |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - DMS_REF
Parent Column in DMS_REF (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | DMS_REF_ID | DMS_EVENT | DMS_EVENT_REF_ID |
DMS_EVENT | DMS_REASON_REF_ID | ||
DMS_EVENT_REASON_R | DMS_REASON_REF_ID |
DMS_REPOSITORY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | DMS_REPOSITORY |
Definition: | Contains media object repository information |
Table Type: | REFERENCE |
Column Detail - DMS_REPOSITORY
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
DEFAULT_IND | DOUBLE | N | This column is used to indicate the default repository |
DMS_REPOSITORY_ID | DOUBLE | N | Primary dms_repository table |
ENCRYPTION_IND | DOUBLE | N | This column is used to indicate if the object is encrypted |
LOCATION | VARCHAR(255) | Y | Repository location |
OVERFLOW_ID | DOUBLE | N | The DMS_REPOSITORY_ID of the repository used to store objects that exceed the size limit |
PASSWORD | VARCHAR(64) | Y | Repository access password |
REPOSITORY_NAME | VARCHAR(16) | Y | name of the repository used |
SIZE_LIMIT | DOUBLE | N | This column contains the size limit for objects stored on this repository |
TYPE_FLAG | DOUBLE | N | This column is used to indicate the type of repository 0 - archive, 1 - share,2 - Millennium |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
USERNAME | VARCHAR(64) | Y | Repository access username |
Relationship Detail - DMS_REPOSITORY
Parent Column in DMS_REPOSITORY (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | DMS_REPOSITORY_ID | DMS_CONTENT_TYPE | DMS_REPOSITORY_ID |
DMS_MEDIA_INSTANCE | DMS_REPOSITORY_ID |