CREATE DOMAIN THDATETIME AS TIMESTAMP;
CREATE DOMAIN THDOUBLE AS DOUBLE PRECISION;
CREATE DOMAIN THV60 AS VARCHAR(60);
CREATE DOMAIN THMEMO AS BLOB SUB_TYPE TEXT SEGMENT SIZE 80;
CREATE DOMAIN THTF AS VARCHAR(1)
DEFAULT 'F';
CREATE DOMAIN THNUM AS NUMERIC(15,2);
CREATE DOMAIN BUDGET AS NUMERIC(15, 2)
DEFAULT 50000
CHECK (VALUE > 10000 AND VALUE <= 2000000);
CREATE DOMAIN CUSTNO AS INTEGER
CHECK (VALUE > 1000);
CREATE DOMAIN DEPTNO AS CHAR(3)
CHECK (VALUE = '000' OR (VALUE > '0' AND VALUE <= '999') OR VALUE IS NULL);
CREATE DOMAIN EMPNO AS SMALLINT;
CREATE DOMAIN JOBCODE AS VARCHAR(5)
CHECK (VALUE > '99999');
CREATE DOMAIN JOBGRADE AS SMALLINT
CHECK (VALUE BETWEEN 0 AND 6);
CREATE DOMAIN PONUMBER AS CHAR(8)
CHECK (VALUE STARTING WITH 'V');
CREATE DOMAIN PRODTYPE AS VARCHAR(12)
DEFAULT 'software'
CHECK (VALUE IN ('software', 'hardware', 'other', 'N/A')) NOT NULL;
CREATE DOMAIN PROJNO AS CHAR(5)
CHECK (VALUE = UPPER (VALUE));
CREATE DOMAIN SALARY AS NUMERIC(15, 2)
DEFAULT 0
CHECK (VALUE > 0);
CREATE DOMAIN THDOUBLE AS DOUBLE PRECISION;
CREATE DOMAIN THV60 AS VARCHAR(60);
CREATE DOMAIN THMEMO AS BLOB SUB_TYPE TEXT SEGMENT SIZE 80;
CREATE DOMAIN THTF AS VARCHAR(1)
DEFAULT 'F';
CREATE DOMAIN THNUM AS NUMERIC(15,2);
CREATE DOMAIN BUDGET AS NUMERIC(15, 2)
DEFAULT 50000
CHECK (VALUE > 10000 AND VALUE <= 2000000);
CREATE DOMAIN CUSTNO AS INTEGER
CHECK (VALUE > 1000);
CREATE DOMAIN DEPTNO AS CHAR(3)
CHECK (VALUE = '000' OR (VALUE > '0' AND VALUE <= '999') OR VALUE IS NULL);
CREATE DOMAIN EMPNO AS SMALLINT;
CREATE DOMAIN JOBCODE AS VARCHAR(5)
CHECK (VALUE > '99999');
CREATE DOMAIN JOBGRADE AS SMALLINT
CHECK (VALUE BETWEEN 0 AND 6);
CREATE DOMAIN PONUMBER AS CHAR(8)
CHECK (VALUE STARTING WITH 'V');
CREATE DOMAIN PRODTYPE AS VARCHAR(12)
DEFAULT 'software'
CHECK (VALUE IN ('software', 'hardware', 'other', 'N/A')) NOT NULL;
CREATE DOMAIN PROJNO AS CHAR(5)
CHECK (VALUE = UPPER (VALUE));
CREATE DOMAIN SALARY AS NUMERIC(15, 2)
DEFAULT 0
CHECK (VALUE > 0);