Company Table

This table holds contact information for companies that are referenced by the Establishment and Item tables. Examples would include companies like Safeway, Hain Celestial Group and Blimpie.

Since companies can also be owned by other companies, a link field Owning_Company_ID is included to represent that type of connection.

Table Layout

Column Type Length Description
Company_ID Number (Long)
4
 Unique ID for each Company record
Owning_Company_ID Number (Long)
4
 Record ID of the Company that owns this Company.  (May be Null)
Name Text
25
 Name of the company
Address1 Text
25
 Mailing address first line
Address2 Text
25
 Mailing address second line
State Text
15
 Mailing address state
City Text
20
 Mailing address city
Zip Text
10
 Mailing address zip code
Phone1 Text
20
 Primary phone number
Phone2 Text
20
 Secondary phone number
Fax Text
20
 Fax phone number
Web Text
50
 Internet web site address
Email Text
50
 Primary email address
Location_Finder Text
50
 Internet web site address or phone number used to find where their products or establishments are located.
Contact_Name Text
25
 Name of a person that can be contacted at the company
Contact_Title Text
30
 The person's title
Contact_Phone Text
16
 The person's primary phone number. (may include extension)
Contact_Fax Text
16
 The person's fax phone number
Contact_Email Text
50
 The person's email address
Comments_ID Number (Long)
4
 Record ID of any comments related to the contact person or the company. (May be NULL)
Modified Date/Time
8
 Timestamp when this record was last modified.
Modified_By Number (Long)
4
 Record ID for the food detective that last updated this record.
Created Date/Time
8
 Timestamp when this record was created.
Created_By Number (Long)
4
 Record ID for the food detective that created this record.

Relationships

These records are used by the Establishment and Item tables.  Each record in those tables points to only one record in this table. This is a one to many relationship from these records to those records.

The Owning_Company_ID field in these records can point to a single record in this table.  Since a company can own multiple other companies, this can produce a mildly recursive one to many relationship between records in this same table.

The Comments_ID field in this record can point to a record in the Comments table.  This can be a one to one relationship between this table and to that table. If the user does not wish to add any comments about the Location, then this ID field will be NULL.

The Modified_By and Created_By fields in these records each point to single records in the Food Detective table. Because a food detective can create multiple entries in the database, this can produce a many to one relationship between these records and the Food Detective records.

See also:

Comments Table,
Company Table,
Establishment Table,
Food Detective Table.
Send comments and suggestions to:
DBA@AllergyFreeFood.org
Home | Documentation

Last updated on 12/12/00