Table: person_time_day_tito

Previous: person_time_day

Unanet Data Model

Next: plan_set

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	time_day_tito_key	decimal(15)
2.		time_day_key	decimal(15)		person_time_day	fk_person_time_day_tito1
3.		start_time	datetime
4.		stop_time	datetime
5.		nonwork_hours	decimal(4,2)
6.		comments	varchar(2000)

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
time_day_key	person_time_day	time_day_key	fk_person_time_day_tito1

Check Constraints

Name	Definition
cc_ptdayt_start_time	([start_time]>='1900-01-01' AND [start_time]<='2099-12-31')
cc_ptdayt_stop_time	([stop_time]>='1900-01-01' AND [stop_time]<='2099-12-31')

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_person_time_day_tito	true	time_day_tito_key	Asc
idx_person_time_day_tito1	true	time_day_key	Asc
		start_time