Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
---|---|---|---|---|---|---|---|---|---|---|---|
id | INT | 10 | √ | null |
|
|
The primary key which is the same as the forms.form_id column |
||||
pid | INT | 10 | √ | null |
|
|
The internal patient identifier |
||||
activity | TINYINT | 3 | 0 |
|
|
||||||
date | DATETIME | 19 | √ | null |
|
|
|||||
prior_auth_number | VARCHAR | 35 | √ | null |
|
|
|||||
comments | VARCHAR | 255 | √ | null |
|
|
|||||
date_from | DATE | 10 | √ | null |
|
|
|||||
date_to | DATE | 10 | √ | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PRIMARY | Primary key | Asc | id |