ca_asset_source_location

Contains a list of database locations for asset sources

Column Name Column Datatype Column Null Option Column Comment
source_location_uuid byte(16) not null Unique identifier for the source location database. Primary key.
server_name nvarchar(20) with null Name of the server on which the database exists.
db_instance_name nvarchar(255) with null Name of the database instance.
db_name nvarchar(255) with null Name of the database.
db_type integer with null Numeric value to differentiate between database types (e.g. SQL Server, Ingres).
creation_user nvarchar(64) with null User or process that created the record.
creation_date integer with null Date the record was created.
last_update_user nvarchar(64) with null User or process that last updated the record.
last_update_date integer with null Date the record was last updated.
version_number integer with null Version number for transaction integrity.
exclude_registration integer with null Exclude Registration
delete_time integer with null Delete time

Product Name: Asset

Table Type: Table

Relationships:

Primary Key Related Table Related Column
source_location_uuid ca_asset_source source_location_uuid


Copyright © 2006 CA. All rights reserved.