/* Domain definitions */ CREATE DOMAIN "BARRE" AS CHAR(18); CREATE DOMAIN "BOOL" AS CHAR(3); CREATE DOMAIN "CODE" AS CHAR(4); CREATE DOMAIN "CODEBQ" AS CHAR(5); CREATE DOMAIN "COMMENTAIRE" AS CHAR(100); CREATE DOMAIN "COMPTE" AS CHAR(6); CREATE DOMAIN "CPTBQ" AS CHAR(11); CREATE DOMAIN "DAT" AS TIMESTAMP; CREATE DOMAIN "DOM_BOOL" AS CHAR(1) default 'F' check (value in ('F','T')) NOT NULL; CREATE DOMAIN "EMETTEUR" AS CHAR(6); CREATE DOMAIN "HEURE" AS CHAR(5); CREATE DOMAIN "INSEE" AS CHAR(5); CREATE DOMAIN "JOUR" AS CHAR(2); CREATE DOMAIN "JOURNAL" AS CHAR(3); CREATE DOMAIN "LIBCOURT" AS CHAR(10); CREATE DOMAIN "LIBELLE" AS CHAR(25); CREATE DOMAIN "LIBLG" AS CHAR(50); CREATE DOMAIN "LIEU" AS CHAR(25); CREATE DOMAIN "LOGIN" AS CHAR(10); CREATE DOMAIN "MOIS" AS CHAR(7); CREATE DOMAIN "NBMOIS" AS SMALLINT; CREATE DOMAIN "NBPRISE" AS INTEGER; CREATE DOMAIN "NBRUE" AS INTEGER CHECK (value > 10000); CREATE DOMAIN "NUMABONNE" AS INTEGER; CREATE DOMAIN "NUMCONVERT" AS CHAR(12); CREATE DOMAIN "NUMLOGIC" AS SMALLINT; CREATE DOMAIN "NUMTERMINAL" AS CHAR(9); CREATE DOMAIN "PB" AS CHAR(8); CREATE DOMAIN "PIECECPT" AS INTEGER; CREATE DOMAIN "PRICE" AS NUMERIC(15, 2); CREATE DOMAIN "PRISE" AS CHAR(17); CREATE DOMAIN "QTE" AS NUMERIC(15, 2); CREATE DOMAIN "QUANTITE" AS SMALLINT; CREATE DOMAIN "RIB" AS CHAR(2); CREATE DOMAIN "SERIE" AS CHAR(4); CREATE DOMAIN "SEXE" AS CHAR(1); CREATE DOMAIN "SIGNAL" AS SMALLINT; CREATE DOMAIN "STATUT" AS CHAR(1) DEFAULT 'P' CHECK (value in ('P','A','I')) NOT NULL; CREATE DOMAIN "TAUX" AS NUMERIC(15, 5) DEFAULT 0 CHECK (value >= 0); CREATE DOMAIN "TELEPHONE" AS CHAR(14); CREATE DOMAIN "ZONE" AS CHAR(4);