| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | CLAIM | Number of Claim | nvarchar | 17 | 0 | | | | Allow NULL? |
| 3 | LB | Left Bottom Of Whole Picture (1 if damaged, 0 if not) | char | 1 | 0 | | | | Allow NULL? |
| 4 | LT | Left Top Of Whole Picture (1 if damaged, 0 if not) | char | 1 | 0 | | | | Allow NULL? |
| 5 | MB | Left Middle Of Whole Picture (1 if damaged, 0 if not) | char | 1 | 0 | | | | Allow NULL? |
| 6 | MT | Middle Top Of Whole Picture (1 if damaged, 0 if not) | char | 1 | 0 | | | | Allow NULL? |
| 7 | RB | Right Bottom Of Whole Picture (1 if damaged, 0 if not) | char | 1 | 0 | | | | Allow NULL? |
| 8 | RT | Right Top Of Whole Picture (1 if damaged, 0 if not) | char | 1 | 0 | | | | Allow NULL? |
| 9 | PROPMAKE | Make of Insured Object | nvarchar | 4 | 0 | | | | Allow NULL? |
| 10 | PROPMODEL | Insured Object Model | nvarchar | 4 | 0 | | | | Allow NULL? |
| 11 | PLATENO | License Plate Number | nvarchar | 12 | 0 | | | | Allow NULL? |
| 12 | VIN | Vehicle Identification Number | nvarchar | 17 | 0 | | | | Allow NULL? |
