CREATE TABLE atu
(
  idatu bigserial NOT NULL,
  iddata bigint NOT NULL,
  numconsultation character varying(14),
  geometrie xml,
  datedeclaration timestamp without time zone,
  datereception timestamp without time zone,
  signatairenom character varying,
  ordonnantnom character varying,
  ordonnantcompladresse character varying,
  ordonnantvoie character varying,
  ordonnantlieudit character varying,
  ordonnantcp character varying(5),
  ordonnantcommune character varying,
  ordonnantpays character varying,
  ordonnantsiret character varying,
  ordonnantnomcontact character varying,
  ordonnanttelephonecontact character varying,
  ordonnantfaxcontact character varying,
  ordonnantemailcontact character varying,
  emplacementnumvoie character varying,
  emplacementnomvoie character varying,
  emplacementcodepostal character varying(5),
  emplacementcodeinsee character varying(5),
  emplacementcommune character varying,
  emplacementnbcommunes character varying(2),
  emplacementlistecommunes character varying,
  cacpasderep boolean,
  cacreponseattendue boolean,
  nomrepresentant character varying,
  datecontact timestamp without time zone,
  heurecontact character varying,
  entrepriseexecnom character varying,
  entrepriseexecadresse character varying,
  entrepriseexeccodepostal character varying,
  entrepriseexeccommune character varying,
  naturedescription character varying,
  cacjustificatifsecurite boolean,
  cacjustificatifcontinuitesp boolean,
  cacjustificatifsauvegardepb boolean,
  cacjustificatifcasfm boolean,
  datedebut timestamp without time zone,
  heuredebut character varying,
  dureetravaux integer,
  CONSTRAINT pk_atu_iddt PRIMARY KEY (idatu ),
  CONSTRAINT fk_atu_iddata FOREIGN KEY (iddata)
      REFERENCES data (iddata) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE CASCADE
)