| Field | Type | Length | Unique | Required | Format | Description |
|---|---|---|---|---|---|---|
| identifier | varchar | 255 | yes | yes | Client ID | |
| is_active | boolean | no | yes | true/false | Is client active | |
| title | varchar | 40 | no | no | Title | |
| first_name | varchar | 50 | no | no | First name | |
| last_name | varchar | 255 | no | yes | Last name | |
| street | varchar | 255 | no | no | Street | |
| postcode | varchar | 20 | no | no | Postcode | |
| city | varchar | 255 | no | no | City | |
| state | varchar | 255 | no | no | State | |
| country | varchar | 255 | no | no | Country | |
| telephone | varchar | 40 | no | no | Phone number | |
| mobile_phone | varchar | 40 | no | no | Mobile phone | |
| varchar | 80 | no | no | Email Address |
Example CSV-File: clients.csv