| Field | Type | Length | Unique | Required | Format | Description |
|---|---|---|---|---|---|---|
| identifier | varchar | 80 | yes | yes | Patient ID | |
| client_id | varchar | 255 | no | yes | table: clients, field: identifier | Client ID of patient owner |
| is_active | boolean | no | yes | true/false | Is patient active | |
| name | varchar | 50 | no | yes | First name | |
| species | varchar | 50 | no | no | Animal species | |
| gender | varchar | 10 | no | no | Animal gender | |
| neutered | boolean | no | no | true/false | Is animal neutered | |
| date_of_birth | timestamp | no | no | YYYY-MM-DD | Animal Date of birth |
Example CSV-File: patients.csv