The following section describes the tables used in support of asset registries.
caf_registry
This table contains information about a registry.
Column | Data Type | Constraint |
|---|---|---|
VARCHAR(40) | not null | |
(primary key) | The ID for the registry | |
VARCHAR(100) | not null | |
The name for the registry | ||
VARCHAR(1000) | Null | |
The description for the registry | ||
VARCHAR(100) | Null | |
The type of the asset | ||
caf_reg_folder
This table contains information on folders in a registry
Column | Data Type | Constraint |
|---|---|---|
VARCHAR(40) | not null | |
(primary key) | The ID for the folder | |
VARCHAR(100) | null | |
The name for the folder | ||
VARCHAR(40) | null | |
The ID for the parent folder | ||
caf_reg_rootfolder
This table associates the root folder with a registry.
Column | Data Type | Constraint |
|---|---|---|
VARCHAR(40) | not null | |
(primary key) | The ID for the registry | |
VARCHAR(40) | null | |
(primary key) | The ID for a root folder | |
caf_reg_asset
This table specifies the folder that holds an asset.
Column | Data Type | Constraint |
|---|---|---|
VARCHAR(40) | not null | |
(primary key) | The ID for the asset | |
VARCHAR(100) | null | |
The name for the asset | ||
VARCHAR(1000) | null | |
The description for the asset | ||
VARCHAR(40) | null | |
The ID for the parent folder | ||
INTEGER | null | |
They type of asset | ||
VARCHAR(40) | null | |
The ID for the registry of which the asset is a part | ||
caf_reg_repasset
This table contains information about assets of subtype repositoryAsset.
Column | Data Type | Constraint |
|---|---|---|
VARCHAR(40) | not null | |
(primary key) | The ID for the asset in the registry | |
VARCHAR(100) | not null | |
The repository to which the asset belongs | ||
VARCHAR(100) | not null | |
The repository item descriptor name for this item | ||
VARCHAR(100) | not null | |
The ID for the item in the repository | ||
caf_reg_pathasset
This table holds information about assets of subtype pathBasedAsset.
