-- Table: archive_interventions

-- DROP TABLE archive_interventions;

CREATE TABLE archive_interventions
(
  id_archive serial NOT NULL,
  nom_marche_quitte character varying(150),
  numero_marche_quitte character varying(20),
  societe_cliente character varying(56),
  id_unite_maintenance character varying(150),
  cd_unite_maintenance character varying(10),
  lib_unite_maintenance character varying(50),
  id_type_unite_maintenance character varying(150),
  prestation_lib character varying(50),
  prestation_description character varying(150),
  prestation_nb_visites character varying(150),
  prestation_delai_intervention_urgence character varying(150),
  prestation_delai_mise_en_securite character varying(150),
  prestation_delai_remise_en_etat_initial character varying(150),
  prestation_id_contrats character varying(150),
  prestation_date_insert character varying(150),
  prestation_statut character varying(1),
  prestation_societe_destinataire character varying(56),
  demande_id_contrats character varying(150),
  demande_id_demande character varying(150),
  demande_id_prestations character varying(150),
  demande_date_enregistrement character varying(150),
  demande_date_demande character varying(150),
  demande_date_remise_en_service character varying(150),
  demande_date_cloture character varying(150),
  demande_delai_souhaite character varying(150),
  demande_demandeur character varying(150),
  demande_createur character varying(150),
  demande_societes_cliente character varying(56),
  demande_societe_prestataires character varying(56),
  demande_statut character varying(1),
  demande_nature character varying(50),
  demande_etat character varying(50),
  demande_observations character varying(3000),
  demande_commentaire character varying(3000),
  id_interventions character varying(150),
  id_demandes character varying(150),
  cd_intervention character varying(20),
  observation character varying(3000),
  lib_intervention character varying(50),
  date_approbation_client character varying(150),
  date_validationrt character varying(150),
  date_enregistrement character varying(150),
  date_planifiee character varying(150),
  date_creation character varying(150),
  date_annulation character varying(150),
  etat character varying(1),
  type_intervention character varying(50),
  date_debut_intervention character varying(150),
  date_fin_intervention character varying(150),
  etat_intervention character varying(50),
  nom_marche character varying(50),
  societe_prestatrice character varying(56),
  societe_destinatrice character varying(56),
  observations_arrivee character varying(3000),
  observations_depart character varying(3000),
  transfert character varying(1),
  tps_en_heures character varying(150),
  temps_passe character varying(150),
  id_prestations character varying(150),
  temps_site_hh character varying(2),
  temps_site_mm character varying(2),
  temps_atel_hh character varying(2),
  temps_atel_mm character varying(2),
  temps_depl_hh character varying(2),
  temps_depl_mm character varying(2),
  numero_affaire character varying(20),
  etat_arrive character varying(3000),
  etat_depart character varying(3000),
  nom_intervenant1 character varying(150),
  nom_intervenant2 character varying(150),
  nom_intervenant3 character varying(150),
  date_archivage timestamp without time zone DEFAULT now(),
  CONSTRAINT "PK_archivage" PRIMARY KEY (id_archive)
) 
WITHOUT OIDS;
ALTER TABLE archive_interventions OWNER TO postgres;

-- Table: archive_interventions_taches

-- DROP TABLE archive_interventions_taches;

CREATE TABLE archive_interventions_taches
(
  id_archive integer,
  id_taches character varying(150),
  date_creation timestamp without time zone,
  id_interventions character varying(150),
  commentaires character varying(150),
  checked character varying(1),
  CONSTRAINT "FK_archivage" FOREIGN KEY (id_archive)
      REFERENCES archive_interventions (id_archive) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION
) 
WITHOUT OIDS;
ALTER TABLE archive_interventions_taches OWNER TO postgres;


-- Index: "FKI_archivage"

-- DROP INDEX "FKI_archivage";

CREATE INDEX "FKI_archivage"
  ON archive_interventions_taches
  USING btree
  (id_archive);