Table: Principals Sales Contacts
Primary Key: Principal
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| Principal Contact ID | Long | 4 | ✓ | |
| Principal ID | Long | 4 | ||
| Contact Type ID | Long | 4 | ||
| Contact First Name | Text | 255 | ||
| Contact Surname | Text | 255 | ||
| Contact Position | Text | 255 | ||
| Contact Email | Text | 255 | ||
| Contact Phone | Text | 255 | ||
| Contact Cell Phone | Text | 50 | ||
| VA Pack Addressee | Boolean | 1 |
Indexes
- Principals Sales Contacts$Contact Type ID
- Principals Sales Contacts$PrimaryKey [PRIMARY KEY] [UNIQUE]
- Principals Sales Contacts$Principal ID