| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| r_ID | INT | 10 | √ | null |
|
|
Unique ID for the recall record |
||||
| r_PRACTID | INT | 10 | null |
|
|
UNUSED - Practice ID associated with the recall |
|||||
| r_pid | INT | 10 | null |
|
|
The internal patient identifier |
|||||
| r_eventDate | DATE | 10 | null |
|
|
Date of Appointment or Recall |
|||||
| r_facility | INT | 10 | null |
|
|
FK facility.id associated with the recall |
|||||
| r_provider | INT | 10 | null |
|
|
Provider ID associated with the recall FK to users.id |
|||||
| r_reason | VARCHAR | 255 | √ | NULL |
|
|
Reason for the recall |
||||
| r_created | TIMESTAMP | 19 | '0000-00-00 00:00:00' |
|
|
Timestamp when the recall was created |
Showing 1 to 8 of 8 entries