The following table briefly describes the most important database tables and its attributes. The 
descriptions are provided to give the reader a general overview over the contents of the Permit 
System database. For a more detailed analysis of the tables and their attributes, please refer to 
the Street Opening Permit System Project Report that is available from the CEE Department of 
the Massachusetts Institute of Technology. 
Table Name 
Primary Key(s) 
Description 
Company ComID 
The Company table contains the information on all 
contractors and utility companies that are registered with 
the Arlington Department of Public Works. 
Contact ConCompanyID 
This table contains contact information for each company. 
ConName 
Several contacts may be given. 
Company 
CoTType 
This table contains the company types that are possible, 
Type 
which are Utility or Contractor. 
Company 
CWTCompanyID  This table contains all types of work that a particular 
Work Type 
CWTType 
company may perform. E.g. a company registered for the 
type of work CableTV will not be allowed to perform work of 
type Gas. 
Company 
CSTCompanyID  This table contains all types of street work that a particular 
Street Work 
CSTType 
company may perform. Similarly to the Company Work 
Type 
Type table, a company registered for street work of type  
Street Opening Only will not be permitted to perform work 
of type Water. 
Work Type 
WoTType 
The Work Type table enumerates all possible work types. 
Street Work 
SWTType 
The Street Work Type table enumerates all possible types 
Type 
of street work. 
Permit PerID 
The Permit table contains a history of all issued permits, 
including all application data, such as issue date, location, 
size of the work area, etc. 
Street StrID 
This table contains a list of all the streets that exist in the 
Town of Arlington. 
Restriction ResID 
This table is used to store all restrictions that have been 
applied to street or street segments. Permits will not be 
issued for restricted streets.  
60 




Java Web Hosting Application Development Using Java Technologies Hosting




 
TotalRoute.net Business web hosting division of Vision Web Hosting Inc. All rights reserved.