| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
Comments |
| MedicalPlanHistorySeq |
int identity |
4 |
|
√ |
null |
|
|
|
| ID |
int |
4 |
√ |
|
null |
|
|
|
| ActiveFlag |
bit |
1 |
√ |
|
null |
|
|
|
| MedicalPlanType |
varchar |
20 |
√ |
|
null |
|
|
|
| IssuingAuthority |
varchar |
50 |
√ |
|
null |
|
|
|
| StartDate |
datetime |
16,3 |
√ |
|
null |
|
|
|
| ExpiryDate |
datetime |
16,3 |
√ |
|
null |
|
|
|
| MedicalPlanLocation |
varchar |
20 |
√ |
|
null |
|
|
|
| Instructions |
varchar |
2147483647 |
√ |
|
null |
|
|
|
| MedicalPlanDocumentID |
int |
4 |
√ |
|
null |
|
|
|
| ModifiedBy |
int |
4 |
√ |
|
null |
|
|
|
| ModifiedDate |
datetime |
16,3 |
√ |
|
null |
|
|
|
| AuditAction |
varchar |
30 |
√ |
|
null |
|
|
|
| MedicalPlanSeq |
int |
4 |
√ |
|
null |
|
|
|
Table contained -1 rows
| Constraint Name |
Type |
Sort |
Column(s) |
| PK_MedicalPlanHistorySeq |
Primary key |
Asc |
MedicalPlanHistorySeq |
| AK_MedicalPlan_ID |
Performance |
Asc |
ID |