_999.reports_schedules
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| rsched_id | int(11) | NO | PRI | auto_increment | ||
| rsched_cus_id | int(11) | NO | 0 | MUL | ||
| rsched_cli_id | int(11) | NO | 0 | MUL | ||
| rsched_usr_id | int(11) | NO | 0 | MUL | ||
| rsched_session_data | text | NO | ||||
| rsched_confrp_id | int(11) | NO | 0 | MUL | ||
| rsched_rptgrp_id | int(11) | NO | 0 | MUL | ||
| rsched_repeat_start | int(11) | NO | ||||
| rsched_start_dt | datetime | YES | Datetime version of start date | |||
| rsched_recurring | tinyint(1) | NO | 1 | Boolean indicating if report should repeat | ||
| rsched_interval | int(11) | NO | ||||
| rsched_year | int(11) | NO | ||||
| rsched_quarter | int(11) | NO | ||||
| rsched_month | int(11) | NO | ||||
| rsched_week | int(11) | NO | ||||
| rsched_day | int(11) | NO | ||||
| rsched_weekday | int(11) | NO | ||||
| rsched_modified | datetime | YES | CURRENT_TIMESTAMP | |||
| rsched_created | datetime | YES | CURRENT_TIMESTAMP |
References
| Local Column | References |
|---|