| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | APPLICATION | Application in Project Planning | nvarchar | 3 | 0 | | | | Allow NULL? |
| 3 | VERSION | Version Number | nvarchar | 24 | 0 | | | | Allow NULL? |
| 4 | VERSION_TYPE | Version Type | nvarchar | 3 | 0 | | | | Allow NULL? |
| 5 | IS_RELEASED | Version Has Been Released for Use | char | 1 | 0 | | | | Allow NULL? |
| 6 | VALID_FROM | Date, from Which a Version Can Be Used | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | VALID_TO | Date, Until Which a Version Can Be Used | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | CREATED_BY | Name of Person Who Created Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 9 | CREATED_ON | Date When the Object Was Created | nvarchar | 8 | 0 | | | | Allow NULL? |
| 10 | CREATED_AT | Time at Which an Object Was Created | nvarchar | 6 | 0 | | | | Allow NULL? |
| 11 | CHANGED_BY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 12 | CHANGED_ON | Date on which object was last changed | nvarchar | 8 | 0 | | | | Allow NULL? |
| 13 | CHANGED_AT | Time of Last Change to Object | nvarchar | 6 | 0 | | | | Allow NULL? |
| 14 | SNP4MTA | Snapshot for MTA analysis | char | 1 | 0 | | | | Allow NULL? |