Medication items. Possible medications which can be administered to a patient
DDL script| Name | Type | Nullable | Default value | Comment |
|---|---|---|---|---|
| ITEMID | NUMBER(7) | N | Table record unique identifier, the medication item id. | |
| LABEL | VARCHAR2(20) | Y | Name of the medication item. |
| Constraint Name | Columns |
|---|---|
| MIMIC2V26.D_MEDITEMS_PK | ITEMID |
| 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_MEDITEMS_PK | NORMAL | UNIQUE | ITEMID | DDL script |