aurora_standard.chtshftc
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| shift_code | varchar(6) | YES | MUL | |||
| department | varchar(3) | YES | ||||
| shift_name | varchar(20) | YES | ||||
| shift_desc | varchar(30) | YES | ||||
| shift_start | time | YES | ||||
| shift_end | time | YES | ||||
| begin_lunch | time | YES | ||||
| end_lunch | time | YES | ||||
| min_time | smallint(6) | YES | ||||
| valid_mon | varchar(1) | YES | ||||
| valid_tue | varchar(1) | YES | ||||
| valid_wed | varchar(1) | YES | ||||
| valid_thu | varchar(1) | YES | ||||
| valid_fri | varchar(1) | YES | ||||
| valid_sat | varchar(1) | YES | ||||
| valid_sun | varchar(1) | YES | ||||
| latest_time | time | YES | ||||
| earlies_time | time | YES | ||||
| shift_inc_code | varchar(6) | YES | ||||
| shift_ot_code | varchar(6) | YES | ||||
| shift_oc_code | varchar(6) | YES | ||||
| next_rule | varchar(6) | YES | MUL | |||
| shift_diff_code | varchar(6) | YES | ||||
| other_inc_code | varchar(6) | YES | ||||
| holiday_inc_code | varchar(6) | YES | ||||
| shift_cb_code | varchar(6) | YES | ||||
| callback_min | time | YES | ||||
| callback_max | time | YES | ||||
| hrs_in_shift | int(2) unsigned | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |