Firdbird创建域的一些常见实例

 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);