| Table: dbo.Data_Origin | |||
| This table enumerates possible origins of certain data (for example, bank transactions or journal entries) in the database. For data integrity reasons, entries MUST NEVER BE REMOVED FROM THIS TABLE and can be instead documented as obsolete. Value 16 is reserved. It was OnBalance; it was removed from this table leading to the need to triage customer data by altering the audit trail to reflect such entries were manual data entry. | |||
| Columns | |||
| Name | Type | Constraints | Description |
| data_origin_KEY | int (4) | NOT NULL | Primary key. |
| description | nvarchar (50) | NOT NULL | Description of a data origin. |
| Primary key | |||
| Name | Columns | Description | |
| PK_Data_Origin | data_origin_KEY | ||
| Unique constraints | |||
| Name | Columns | Description | |
| UK_Data_Origin$description | description | ||