_436_archive_testing.appointments_reminders
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| aptrem_id | int(11) | NO | PRI | auto_increment | ID sent with outbound and received with inbound file | |
| aptrem_cus_id | int(11) | NO | 0 | MUL | Customer ID | |
| aptrem_cli_id | int(11) | NO | 0 | MUL | Client ID | |
| aptrem_arv_id | int(11) | NO | 0 | MUL | Vendor ID | |
| aptrem_apt_id | int(11) | NO | 0 | MUL | Appointment ID | |
| aptrem_acs_id | int(11) | NO | 0 | MUL | Status/Resp ID | |
| aptrem_modified | timestamp | YES | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | ||
| aptrem_created | timestamp | YES | CURRENT_TIMESTAMP |
References
| Local Column | References |
|---|