| User-defined datatypes (UDD) | |
| Name | Definition |
| TPrice | DECIMAL(8,2) CHECK (VALUE>0) |
| TCustNo | INTEGER DEFAULT 9999 CHECK (VALUE>1000) |
| TDescript | BLOB SUB_TYPE TEXT SEGMENT SIZE 80 CHARACTER SET SJIS |
| TCateg | VARCHAR(12) CHECK (VALUE IN ('software', 'hardware', 'other', 'N/A')) |