Care units
DDL script| Name | Type | Nullable | Default value | Comment |
|---|---|---|---|---|
| CUID | NUMBER(7) | N | Table record unique identifier, the care unit id. | |
| LABEL | VARCHAR2(20) | Y | Name of the unit, like MICU, CCU. |
| Constraint Name | Columns |
|---|---|
| MIMIC2V26.D_CAREUNITS_PK | CUID |
| 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_CAREUNITS_PK | NORMAL | UNIQUE | CUID | DDL script |