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