sp118_work_locations

Table Definition

Field	Type	Default	Nullable
location_no	number(4)
name	varchar2(20)
address1	varchar2(50)
address2	varchar2(50)
address3	varchar2(50)
address4	varchar2(50)
postcode	varchar2(30)
region_no	number(9)
region_ref	varchar2(26)
printer	varchar2(10)

Keys 

primary key (location_no) 
unique (name) 
foreign key (region_no, region_ref) references sp057_regions (region_no, region_ref)

Primary Key Referenced From

• sp252_team_locations
• sp206_capabilities

Column Descriptions