Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | VARCHAR | 36 | null |
|
|
||||||||||||
| name | VARCHAR | 255 | null |
|
|
Full credential name |
|||||||||||
| short_name | VARCHAR | 50 | null |
|
|
Abbreviation (e.g., BCBA, RBT) |
|||||||||||
| organization_name | VARCHAR | 255 | √ | null |
|
|
Certifying organization |
||||||||||
| website | VARCHAR | 500 | √ | null |
|
|
Organization website URL |
||||||||||
| taxonomy_code | VARCHAR | 20 | √ | null |
|
|
Healthcare Provider Taxonomy Code |
||||||||||
| description | TEXT | 65535 | √ | null |
|
|
Credential description |
||||||||||
| logo | VARCHAR | 500 | √ | null |
|
|
Logo URL or base64 encoded image |
||||||||||
| is_active | BIT | 1 | √ | 1 |
|
|
Whether credential is active for use in agency |
||||||||||
| location_business_line_id | VARCHAR | 36 | √ | null |
|
|
|||||||||||
| created_at | TIMESTAMP | 19 | CURRENT_TIMESTAMP |
|
|
||||||||||||
| updated_at | TIMESTAMP | 19 | CURRENT_TIMESTAMP |
|
|
||||||||||||
| created_by | VARCHAR | 255 | √ | system |
|
|
|||||||||||
| updated_by | VARCHAR | 255 | √ | system |
|
|
|||||||||||
| requires_supervision | BIT | 1 | 0 |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| idx_credential_active | Performance | Asc | is_active |
| idx_credential_short_name | Performance | Asc | short_name |
| idx_credentials_location_business_line_id | Performance | Asc | location_business_line_id |
| uk_credential_location_short_name | Must be unique | Asc/Asc | short_name + location_business_line_id |