Table: dbo_Product Guiding Sessions
Primary Key: Product
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| Product Guiding Session ID | Long | 4 | ✓ | |
| Product ID | Long | 4 | ||
| Phase Number | Long | 4 | ||
| Guiding Session ID | Long | 4 | ||
| Number of Sessions | Long | 4 | ||
| Hours per Session | Currency | 8 | ||
| Month 1 | Integer | 2 | ||
| Month 2 | Integer | 2 | ||
| Month 3 | Integer | 2 | ||
| Month 4 | Integer | 2 | ||
| Month 5 | Integer | 2 | ||
| Month 6 | Integer | 2 | ||
| Month 7 | Integer | 2 | ||
| Month 8 | Integer | 2 | ||
| Month 9 | Integer | 2 | ||
| Month 10 | Integer | 2 | ||
| Month 11 | Integer | 2 | ||
| Month 12 | Integer | 2 | ||
| nGuiding Session ID | Long | 4 |
Indexes
- PK_Product Guiding Sessions [PRIMARY KEY] [UNIQUE]