Home
Genesis
Navaho
Web Design
Download
Support
Contact

Business

Fields:

Field Type Comments

Reference
BusinessID int(11)  

Contact
BusinessName char(255)  
DepartmentName char(255)  
BuildingNumber char(255)  
Building char(255)  
StreetNumber char(255)  
Street char(255)  
Locality char(255)  
Town char(255)  
County char(255)  
PostCode char(255)  
Country char(255)  
Telephone1 char(255) Packed phone numbers
Telephone2 char(255)  
Telephone3 char(255)  
Telephone4 char(255)  

Data
BusinessType char(255) eg Developer or Solicitor
Notes char(255)  

System
Closed tinyint(1)  
CreationOffice int(11)  
CreationUser int(11)  
CreationDate datetime  
ModificationOffice int(11)  
ModificationUser int(11)  
ModificationDate datetime  

Indexes:

Key Fields Comment
PRIMARY BusinessID  
Building Building  
BusinessName BusinessName  
BusinessType BusinessType  
County County  
Locality Locality  
PostCode PostCode  
Street Street  
Town Town