Column Summary | ||||||
---|---|---|---|---|---|---|
Name | SqlType | Length | Precision | Scale | Nullable | Unique |
ORDER_ITEM_CD | VARCHAR(40) | 255 | 19 | 2 | false | false |
ORDER_ITEM_TYPE_CD | VARCHAR(40) | 255 | 19 | 2 | false | false |
ORDER_ITEM_NM | VARCHAR(100) | 255 | 19 | 2 | false | false |
ORDER_ITEM_NUMBER | integer | 255 | 19 | 2 | false | false |
UPDATE_DT | TIMESTAMP | 255 | 19 | 2 | true | false |
Primary Key | |
---|---|
Name | Columns |
ALRT_ORDER_ITPK | ORDER_ITEM_CD ORDER_ITEM_TYPE_CD |
Foreign Keys | ||
---|---|---|
Name | Referenced Table | Columns |
ALRT_ORDER_ITEM_ORDER_ITEM_TYC | ALRT_ORDER_ITEM_TYPE | ORDER_ITEM_TYPE_CD |
Column Detail