Firdbird创建域的一些常见实例

最新推荐文章于 2017-10-27 17:37:50 发布

最新推荐文章于 2017-10-27 17:37:50 发布 · 93 阅读

博客展示了一系列数据库自定义域的创建语句，包括THDATETIME、THDOUBLE等多种类型，部分域有默认值和检查约束，如BUDGET域默认值为50000，需满足值大于10000且小于等于2000000。

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