Table: Principal Project Pillar Sponsor Elements
Primary Key: Principal
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| Principal Project Pillar Sponsor Element ID | Long | 4 | ✓ | |
| Principal Project Pillar ID | Long | 4 | ||
| Element Type | Text | 50 | ||
| Sponsorship Amount | Double | 8 | ||
| Admin Fee | Double | 8 | ||
| Number of Entrepreneurs | Long | 4 | ||
| Frequency of Payments | Text | 50 | ||
| Once Off Payment Date | DateTime | 8 | ||
| Monthly Day of Month | Text | 50 | ||
| Payment Amount | Double | 8 |
Indexes
- PK_Principal Project Pillar Sponsor Elements [PRIMARY KEY] [UNIQUE]