| aa_id | int(11) | NO | | PRI | auto_increment | |
| aa_name | varchar(100) | NO | | MUL | | |
| aa_item | varchar(256) | NO | | | | The item this action applies to (e.g. PATIENT, INSURANCE, ect) |
| aa_type | varchar(256) | NO | | | | The type of action (e.g. VIEW, ADD, etc) |
| aa_desc | text | NO | | | | |
| aa_suggested_keys | varchar(256) | NO | | | | pipe delimited set of keys that should be associated with this audit action. These should match keys outlined in the models table |
| aa_modified | timestamp | YES | CURRENT_TIMESTAMP | | on update CURRENT_TIMESTAMP | |
| aa_created | timestamp | YES | CURRENT_TIMESTAMP | | | |