Table: Lead Types
Primary Key: Lead
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| Lead Type ID | Long | 4 | ✓ | |
| Lead Type | Text | 255 | ||
| Lead Source | Text | 255 | ||
| Principal Project ID | Long | 4 | ||
| Lead Format | Text | 255 | ||
| Industry ID | Long | 4 | ||
| Start Date | DateTime | 8 | ||
| End Date | DateTime | 8 | ||
| Import Template | Text | 255 | ||
| Last Modified By | Text | 255 | ||
| Date Modified | DateTime | 8 | ||
| Status | Text | 255 | ||
| Do Not Use in Digital | Boolean | 1 | ||
| SSMA_TimeStamp | Binary | 8 |
Indexes
- Lead Types$Industry ID
- Lead Types$PrimaryKey [PRIMARY KEY] [UNIQUE]
- Lead Types$Principal Project ID