project_contact


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
project_id INT 10 null
project.id FKAA0AECFAFE2B983 R
role_id INT 10 √ null
sys_roles.role_id FKAA0AECFA839C9EC3 R
first_name VARCHAR 20 √ null
last_name VARCHAR 20 √ null
title VARCHAR 50 √ null
company VARCHAR 100 √ null
phone VARCHAR 20 √ null
fax VARCHAR 20 √ null
email VARCHAR 50 √ null
address VARCHAR 50 √ null
address2 VARCHAR 50 √ null
city VARCHAR 40 √ null
state CHAR 2 √ null
zip VARCHAR 10 √ null
contact_id INT 10 √ null
contact.contact_id FKAA0AECFA51C65451 R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FKAA0AECFA51C65451 Performance Asc contact_id
FKAA0AECFA839C9EC3 Performance Asc role_id
FKAA0AECFAFE2B983 Performance Asc project_id

Relationships

Close relationships within degrees of separation