_1.schedules

Field Type Null Default Key Extra Comment
sch_id int(11) NO PRI auto_increment
sch_cus_id int(11) NO MUL
sch_cli_id int(11) NO MUL
sch_loc_id int(11) NO MUL
sch_phy_id int(11) NO MUL
sch_rsc_id int(11) NO MUL
sch_are_id int(11) NO MUL
sch_from_date int(11) NO MUL
sch_to_date int(11) NO MUL
sch_time_start int(11) NO MUL
sch_time_end int(11) NO MUL
sch_duration char(4) NO
sch_sunday char(1) NO MUL
sch_monday char(1) NO MUL
sch_tuesday char(1) NO MUL
sch_wednesday char(1) NO MUL
sch_thursday char(1) NO MUL
sch_friday char(1) NO MUL
sch_saturday char(1) NO MUL
sch_1 char(1) NO MUL
sch_2 char(1) NO MUL
sch_3 char(1) NO MUL
sch_4 char(1) NO MUL
sch_5 char(1) NO MUL
sch_repeat_weekly int(11) NO 0
sch_lockout char(1) NO MUL
sch_reason varchar(60) NO
sch_interval_minutes int(11) NO
sch_updated char(1) NO
sch_group_id int(11) NO 0 MUL
sch_id_ext int(11) NO MUL
sch_modified datetime YES CURRENT_TIMESTAMP
sch_created datetime YES CURRENT_TIMESTAMP

References

Local Column References
sch_id
TableColumn
_1.schedules_insurances_blocksschins_sch_id
_1188.schedules_insurances_blocksschins_sch_id
_1218.schedules_insurances_blocksschins_sch_id
_1548.schedules_insurances_blocksschins_sch_id
_435.schedules_insurances_blocksschins_sch_id
_436.schedules_insurances_blocksschins_sch_id
_436_archive_testing.schedules_insurances_blocksschins_sch_id
_437.schedules_insurances_blocksschins_sch_id
_8.schedules_insurances_blocksschins_sch_id
_81.schedules_insurances_blocksschins_sch_id
_999.schedules_insurances_blocksschins_sch_id