Alc Schedule

schedule id of the schedule. primary key.

allocation id to which this schedule belongs. it is a not null and unique field. there is a referential integrity of this column to the column alloc_id in the table alc_alloc

start date of the schedule. this is a not null field. there is a check constraint between start_date and end_date: i.e.: end_date >= start_date

end date of the schedule information. this is a not null field. there is a check constraint between start_date and end_date: i.e.: end_date >= start_date

frequency information: weekly or bi-weekly. it is a not null field. there is a check on this column for valid values being w or b.