Table: Job Code Pre Appointment Documents
Primary Key: Job
Fields
| Field | Type | Size | Required | PK |
|---|---|---|---|---|
| Job Code Pre Appointment Document ID | Long | 4 | ✓ | |
| Job ID | Long | 4 | ||
| Pre Appointment Document ID | Long | 4 | ||
| SSMA_TimeStamp | Binary | 8 | ✓ |
Indexes
- Job Code Pre Appointment Documents$Application Status ID
- Job Code Pre Appointment Documents$Job Code Application Step ID
- Job Code Pre Appointment Documents$Job ID
- Job Code Pre Appointment Documents$PrimaryKey [PRIMARY KEY] [UNIQUE]