| arec_id | int(11) | NO | | PRI | auto_increment | |
| arec_cus_id | int(11) | YES | | | | |
| arec_cli_id | int(11) | YES | | | | |
| arec_origin_apt_id | int(11) | YES | | MUL | | Origin Appointment ID# |
| arec_pat_id | int(11) | YES | | MUL | | |
| arec_phy_id | int(11) | YES | | MUL | | |
| arec_rsc_id | int(11) | YES | | MUL | | |
| arec_apt_are_id | int(11) | YES | | MUL | | |
| arec_apt_type_id | tinyint(1) | YES | 0 | | | |
| arec_apt_datestamp | date | YES | | | | |
| arec_apt_datestamp_start | datetime | YES | | | | |
| arec_apt_datestamp_end | datetime | YES | | | | |
| arec_apt_duration | int(4) | YES | 0 | | | Appointment duration in minutes |
| arec_frequency | varchar(10) | YES | | | | daily, weekly, monthly, yearly |
| arec_interval | int(11) | YES | | | | Describes how often the frequency applies, e.g. every 2 days, every 3 months, etc. |
| arec_days | varchar(8) | YES | | | | Contains the applicable days of the week as numbers in a string, e.g. Sunday as 0, Sunday & Tuesday as 02 |
| arec_month_day | tinyint(2) | YES | | | | Day of a month |
| arec_month_positions | varchar(80) | YES | | | | Comma separated string containing the position description for days of the week in a month, e.g. "first,second,last" |
| arec_month | tinyint(2) | YES | | | | |
| arec_exclude_days | varchar(8) | YES | | | | Similar to arec_days, but specifies the days to not schedule |
| arec_exclude_dates | varchar(256) | YES | | | | |
| arec_initial_datestamp | date | YES | | | | Recurring will begin after this date (original appointment can be on or before this date) |
| arec_until_datestamp | date | YES | | | | Recurring will not go beyond this date |
| arec_max_count | int(11) | YES | | | | The maximum number of appointments |
| arec_modified | timestamp | NO | CURRENT_TIMESTAMP | | on update CURRENT_TIMESTAMP | |
| arec_created | timestamp | NO | CURRENT_TIMESTAMP | | | |