Table: location

Columns
		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	location_key	decimal(15)
2.		location_name	varchar(50)
3.		active	char(1)	('Y')

Referenced from
Table	Column	Foreign Key Name
person	location_key	fk_person12
person_time_data	location_key	fk_person_time_data10
person_time_data_history	location_key	fk_person_time_data_history8
planned_time	location_key	fk_planned_time6
project	location_key	fk_project10
project_assignment	location_key	fk_project_assignment7
project_location	location_key	fk_project_location2
res_req_location	location_key	fk_res_req_location2
task_assignment	location_key	fk_task_assignment8

Check Constraints
Name	Definition
cc_location_active	([active]='N' OR [active]='Y')

Indices
Index Name	Unique	Column Name	Asc Or Desc
pk_location	true	location_key	Asc
idx_location1	true	location_name	Asc

Dependent Views
View Name
assignment_view