Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| MedicalDetailsSeq | int identity | 4 | √ | null |
|
|
||
| ID | int | 4 | null |
|
|
|||
| AmbulanceFlag | bit | 1 | √ | ((0)) |
|
|
||
| AmbulanceNo | varchar | 12 | √ | null |
|
|
||
| BloodGroup | varchar | 3 | √ | null |
|
|
||
| DisabilityLevel | varchar | 15 | √ | null |
|
|
||
| HealthCareCardExpiryDate | datetime | 16,3 | √ | null |
|
|
||
| HealthCareCardFlag | bit | 1 | √ | ((0)) |
|
|
||
| HealthCareCardNo | varchar | 30 | √ | null |
|
|
||
| ImmunisationFormDate | datetime | 16,3 | √ | null |
|
|
||
| ImmunisationFormFlag | bit | 1 | √ | ((0)) |
|
|
||
| ImmunisationFormStatus | varchar | 15 | √ | null |
|
|
||
| ImmunisationOtherDetails | varchar | 2147483647 | √ | null |
|
|
||
| MedicareExpiryDate | datetime | 16,3 | √ | null |
|
|
||
| MedicareLineNo | tinyint | 1 | √ | null |
|
|
||
| MedicareNo | varchar | 12 | √ | null |
|
|
||
| PrivateHealthFundExpiryDate | datetime | 16,3 | √ | null |
|
|
||
| PrivateInsuranceExtraCoverFlag | bit | 1 | √ | ((0)) |
|
|
||
| PrivateInsuranceFlag | bit | 1 | √ | ((0)) |
|
|
||
| PrivateInsuranceFund | varchar | 5 | √ | null |
|
|
||
| PrivateInsuranceNo | varchar | 30 | √ | null |
|
|
||
| PrivateInsuranceTable | varchar | 30 | √ | null |
|
|
||
| ModifiedBy | int | 4 | √ | null |
|
|
||
| ModifiedDate | datetime | 16,3 | √ | null |
|
|
Table contained -1 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_MedicalDetailsSeq | Primary key | Asc | MedicalDetailsSeq |
| AK_MedicalDetails_ID | Must be unique | Asc | ID |