Care givers
DDL script| Name | Type | Nullable | Default value | Comment |
|---|---|---|---|---|
| CGID | NUMBER(7) | N | Table record unique identifier, the care giver id. | |
| LABEL | VARCHAR2(6) | Y | Title for care giver, like Nurse, MD. |
| Constraint Name | Columns |
|---|---|
| MIMIC2V26.D_CAREGIVERS_PK | CGID |
| Option | Settings |
|---|---|
| Tablespace | MIMIC2_DAT |
| Index Organized | No |
| Generated by Oracle | No |
| Clustered | No |
| Nested | No |
| Temporary | No |
| Index Name | Type | Unuqueness | Columns | DDL script |
|---|---|---|---|---|
| MIMIC2V26.D_CAREGIVERS_PK | NORMAL | UNIQUE | CGID | DDL script |