...
Field | Type | Length | Unique | Required | Format | Description |
---|---|---|---|---|---|---|
identifier | varchar | 80 | yes | yes | Patient ID | |
ownerclient_id | varchar | 255 | no | yes | table: clients-csv: company_identifier, 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 sexgender | |
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