Table: History_Of_Schedule_Item_Series
Columns
NameTypeConstraintsDescription
create__changeset_KEYintNOT NULL
update__changeset_KEYintNOT NULL
revise__changeset_KEYintNOT NULL
history_action_KEYtinyint (3)NOT NULL
schedule_item_series_KEYintNOT NULL
update__staff_KEYintNOT NULL
recurrence_method_KEYintNOT NULL
recurrence_rulenvarchar (-1)NOT NULL
generation_date_based_on_fiscal_year_endbitNOT NULL
generation_date_must_occur_on_weekdaysbitNOT NULL
recurrence_expiration_method_KEYintNOT NULL
expiration_occurrencesintNOT NULL
expiration_date_utcsmalldatetime
recurrence_generation_method_KEYintNOT NULL
generation_monthintNOT NULL
generation_dayintNOT NULL
generate_descriptions_from_projectbitNOT NULL
generate_engagement_from_projectbitNOT NULL
generate_groupings_from_projectbitNOT NULL
generate_assigned_from_projectbitNOT NULL
generate_notes_from_projectbitNOT NULL
generate_links_from_projectbitNOT NULL
generate_custom_values_from_projectbitNOT NULL
generate_tasks_from_projectbitNOT NULL
budget_generation_KEYintNOT NULL
generate_budgeted_hours_factordecimal (6, 4)NOT NULL
generate_budgeted_amount_factordecimal (6, 4)NOT NULL
target_start_monthintNOT NULL
target_start_dayintNOT NULL
start__target_date_method_KEYintNOT NULL
target_complete_monthintNOT NULL
target_complete_dayintNOT NULL
complete__target_date_method_KEYintNOT NULL
generate_calendar_entries_from_projectbitNOT NULL
generate_descriptions_from_taskbitNOT NULL
generate_assigned_from_taskbitNOT NULL
generate_calendar_entries_from_taskbitNOT NULL
generate_notes_from_taskbitNOT NULL
generate_links_from_taskbitNOT NULL
generate_custom_values_from_taskbitNOT NULL
Primary key
NameColumnsDescription
PK_History_Of_Schedule_Item_Series$schedule_item_series_KEY$revise__changeset_KEY$create__changeset_KEY$update__changeset_KEY$hischedule_item_series_KEY, revise__changeset_KEY, create__changeset_KEY, update__changeset_KEY, history_action_KEYCLUSTERED

Schema diagram