The assetStatus table has a one-to-one relationship to the assets table on id. It is primarily to hold process-related data which changes as the ingest, update and delete processes progress.
| Expand | ||||||
|---|---|---|---|---|---|---|
| ||||||
|
| Expand | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||
Derived from: Asset Status Schema Google Doc
|
Schema Summary
Column Name SQL Server | Datatype SQL Server | Column Name PostgreSQL (if different) | Datatype PostgreS | Nullable | Managed by? | Is Netx Attribute? | Required for insert? |
assetstatusid | int identity(1,1) | not null | DB (auto) | (auto) | |||
assetid | int | not null | (insertAsset) | Yes | |||
derivativepath | nvarchar(512) | null | TMAN | ||||
derivativename | nvarchar(100) | null | TMAN | ||||
masterpath | nvarchar(512) | null | TMAN | ||||
ingestrequested | smallint | not null | Unit+TMAN | def 0 | |||
deleterequested | smallint | not null | Unit+TMAN | def 0 | |||
metadatasyncrequested | smallint | not null | Unit+TMAN | def 0 | |||
deleted | smallint | not null | TMAN | def 0 | |||
preservica_du_uuid | nchar(36) | null | TMAN | ||||
preservica_fileref_uuid | nchar(36) | null | TMAN | yes | |||
preservica_ingested | datetime | null | TMAN | ||||
preservica_url | nvarchar(512) | null | TMAN | ||||
preservica_status | smallint | null | TMAN | ||||
preservica_error | nvarchar(max) | null | TMAN | ||||
preservica_lastmodified | datetime | null | TMAN | ||||
preservica_securitytag | nchar(100) | not null | Unit | ||||
preservica_colref | nchar(36) | not null | Unit | ||||
netx_id | integer | null | TMAN | ||||
netx_folderid | int | null | TMAN | ||||
netx_ingested | datetime | null | TMAN | ||||
netx_status | smallint | null | TMAN | ||||
netx_error | nvarchar(max) | null | TMAN | ||||
netx_lastmodified | datetime | null | TMAN | ||||
netx_last_sync_checksum | nchar(32) | null | TMAN | ||||
cds_uuid | nchar(36) | null | TMAN | ||||
cds_lastmodified | datetime | null | TMAN | ||||
cds_status | smallint | null | TMAN | ||||
cds_error | nvarchar(max) | null | TMAN | ||||
cds_last_sync_checksum | nchar(32) | null | TMAN | ||||
cdslevel_last_syn | smallint | null | TMAN |
...