| cset_id | int(11) | NO | | PRI | auto_increment | |
| cset_cus_id | int(11) | NO | 0 | | | Customer ID# |
| cset_cli_id | int(11) | NO | 0 | | | Client ID# |
| cset_name | varchar(255) | NO | 0 | MUL | | user readable name for set |
| cset_key | varchar(45) | YES | | UNI | | Unique azalea key for global ID# purposes, Null if not global |
| cset_desc | text | YES | | | | description of the coding set |
| cset_code | varchar(255) | YES | | MUL | | |
| cset_has_tests | varchar(1) | NO | | | | Code set can be used for lab test codes |
| cset_has_drugs | varchar(1) | NO | | | | Code set can be used for vaccines/prescriptions/medications/rxnorm |
| cset_has_resulting | varchar(1) | NO | | | | Code set can be used for result codes |
| cset_has_procedures | varchar(1) | NO | | | | Code set can be used for procedures |
| cset_has_diagnostic | varchar(1) | NO | | | | Code set can be used diagnoses |
| cset_has_billable | varchar(1) | NO | | | | Code set can be used for billing |
| cset_modified | timestamp | YES | CURRENT_TIMESTAMP | | on update CURRENT_TIMESTAMP | |
| cset_created | timestamp | YES | CURRENT_TIMESTAMP | | | |