Table: Temp Entrepreneur Steps
Primary Key: Record
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| Record ID | Long | 4 | ||
| OwnedBy | Text | 255 | ||
| Entrepreneur ID | Long | 4 | ||
| Entrepreneur Company ID | Long | 4 | ||
| Pipeline ID | Long | 4 | ||
| Reactivated | Boolean | 1 | ||
| Steps Skipped | Boolean | 1 | ||
| Date Record Created | DateTime | 8 | ||
| Step 0 Last Date | DateTime | 8 | ||
| Step 1 Last Date | DateTime | 8 | ||
| Step 2 Last Date | DateTime | 8 | ||
| Step 3 Last Date | DateTime | 8 | ||
| Step 4 Last Date | DateTime | 8 | ||
| Step 5 Last Date | DateTime | 8 | ||
| Step 6 Last Date | DateTime | 8 | ||
| Step 7 Last Date | DateTime | 8 | ||
| Step 8 First Date | DateTime | 8 | ||
| Step 8 Last Date | DateTime | 8 |
Indexes
- Entrepreneur Company ID
- Entrepreneur ID
- Pipeline ID
- PrimaryKey [PRIMARY KEY] [UNIQUE]