site_contact


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
address VARCHAR 50 √ null
address2 VARCHAR 50 √ null
city VARCHAR 40 √ null
company VARCHAR 100 √ null
email VARCHAR 50 √ null
fax VARCHAR 20 √ null
first_name VARCHAR 20 √ null
last_name VARCHAR 20 √ null
phone VARCHAR 20 √ null
role_id INT 10 √ null
sys_roles.role_id FK7C287328839C9EC3 R
site_id INT 10 null
site.id FK7C28732892D2B99F R
state VARCHAR 2 √ null
title VARCHAR 50 √ null
zip VARCHAR 10 √ null
contact_id INT 10 √ null
contact.contact_id FK7C28732851C65451 R
costar BIT 1 √ null
costar_change_pending BIT 1 null
costar_change_request_date DATETIME 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK7C28732851C65451 Performance Asc contact_id
FK7C287328839C9EC3 Performance Asc role_id
FK7C28732892D2B99F Performance Asc site_id

Relationships

Close relationships within degrees of separation