-- Name: ETAT_RAPPORT; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."ETAT_RAPPORT" (
    "ID" integer NOT NULL,
    "NOM" character varying(2048),
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."ETAT_RAPPORT" OWNER TO openconcerto;

--
-- TOC entry 536 (class 1259 OID 6911082)
-- Name: ETAT_RAPPORT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."ETAT_RAPPORT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."ETAT_RAPPORT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24687 (class 0 OID 0)
-- Dependencies: 536
-- Name: ETAT_RAPPORT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."ETAT_RAPPORT_ID_seq" OWNED BY "Default"."ETAT_RAPPORT"."ID";


--
-- TOC entry 537 (class 1259 OID 6911084)
-- Name: ETAT_STOCK; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."ETAT_STOCK" (
    "ID" integer NOT NULL,
    "DATE" date,
    "MONTANT_HA" numeric(16,8) DEFAULT 0,
    "MONTANT_VT" numeric(16,8) DEFAULT 0,
    "INVENTAIRE" boolean DEFAULT false NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8),
    "ID_DEPOT_STOCK" integer DEFAULT 1
);


ALTER TABLE "Default"."ETAT_STOCK" OWNER TO openconcerto;

--
-- TOC entry 538 (class 1259 OID 6911092)
-- Name: ETAT_STOCK_ELEMENT; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."ETAT_STOCK_ELEMENT" (
    "ID" integer NOT NULL,
    "ID_ARTICLE" integer DEFAULT 1,
    "ID_ETAT_STOCK" integer DEFAULT 1,
    "PA" numeric(16,8) DEFAULT 0,
    "PV" numeric(16,8) DEFAULT 0,
    "T_PA" numeric(16,8) DEFAULT 0,
    "T_PV" numeric(16,8) DEFAULT 0,
    "QTE" numeric(16,8) DEFAULT 0,
    "ECART" numeric(16,8) DEFAULT 0,
    "CODE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(2048) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8)
);


ALTER TABLE "Default"."ETAT_STOCK_ELEMENT" OWNER TO openconcerto;

--
-- TOC entry 539 (class 1259 OID 6911109)
-- Name: ETAT_STOCK_ELEMENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."ETAT_STOCK_ELEMENT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."ETAT_STOCK_ELEMENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24688 (class 0 OID 0)
-- Dependencies: 539
-- Name: ETAT_STOCK_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."ETAT_STOCK_ELEMENT_ID_seq" OWNED BY "Default"."ETAT_STOCK_ELEMENT"."ID";


--
-- TOC entry 540 (class 1259 OID 6911111)
-- Name: ETAT_STOCK_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."ETAT_STOCK_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."ETAT_STOCK_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24689 (class 0 OID 0)
-- Dependencies: 540
-- Name: ETAT_STOCK_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."ETAT_STOCK_ID_seq" OWNED BY "Default"."ETAT_STOCK"."ID";


--
-- TOC entry 541 (class 1259 OID 6911113)
-- Name: FABRICANT; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."FABRICANT" (
    "ID" integer NOT NULL,
    "NOM" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8)
);


ALTER TABLE "Default"."FABRICANT" OWNER TO openconcerto;

--
-- TOC entry 542 (class 1259 OID 6911118)
-- Name: FABRICANT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."FABRICANT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."FABRICANT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24690 (class 0 OID 0)
-- Dependencies: 542
-- Name: FABRICANT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."FABRICANT_ID_seq" OWNED BY "Default"."FABRICANT"."ID";


--
-- TOC entry 543 (class 1259 OID 6911120)
-- Name: FACTURATION_COMMANDE_CLIENT; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."FACTURATION_COMMANDE_CLIENT" (
    "ID" integer NOT NULL,
    "NOM" character varying(256) DEFAULT ''::character varying NOT NULL,
    "TYPE_FACTURE" integer DEFAULT 1 NOT NULL,
    "CHOICE" boolean DEFAULT false NOT NULL,
    "ID_TYPE_REGLEMENT" integer DEFAULT 1,
    "ID_COMMANDE_CLIENT" integer DEFAULT 1,
    "ID_SAISIE_VENTE_FACTURE" integer DEFAULT 1,
    "ID_MODELE" integer DEFAULT 1,
    "AJOURS" integer DEFAULT 0 NOT NULL,
    "MONTANT" numeric(16,8) DEFAULT 0 NOT NULL,
    "POURCENT" numeric(16,8) DEFAULT 0 NOT NULL,
    "COMPTANT" boolean DEFAULT false NOT NULL,
    "DATE_PREVISIONNELLE" date,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8),
    "FIN_MOIS" boolean DEFAULT false NOT NULL,
    "LENJOUR" integer DEFAULT 0 NOT NULL
);


ALTER TABLE "Default"."FACTURATION_COMMANDE_CLIENT" OWNER TO openconcerto;

--
-- TOC entry 544 (class 1259 OID 6911137)
-- Name: FACTURATION_COMMANDE_CLIENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."FACTURATION_COMMANDE_CLIENT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."FACTURATION_COMMANDE_CLIENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24691 (class 0 OID 0)
-- Dependencies: 544
-- Name: FACTURATION_COMMANDE_CLIENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."FACTURATION_COMMANDE_CLIENT_ID_seq" OWNED BY "Default"."FACTURATION_COMMANDE_CLIENT"."ID";


--
-- TOC entry 545 (class 1259 OID 6911139)
-- Name: FACTURE_FOURNISSEUR; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."FACTURE_FOURNISSEUR" (
    "ID" integer NOT NULL,
    "NOM" character varying(256) DEFAULT ''::character varying NOT NULL,
    "NUMERO" character varying(45) DEFAULT ''::character varying NOT NULL,
    "INFOS" character varying(2048) DEFAULT ''::character varying NOT NULL,
    "DATE" date,
    "ID_FOURNISSEUR" integer DEFAULT 1,
    "ID_AVOIR_FOURNISSEUR" integer DEFAULT 1,
    "ID_COMPTE_PCE" integer DEFAULT 1,
    "ID_COMMERCIAL" integer DEFAULT 1,
    "ID_MODE_REGLEMENT" integer DEFAULT 1,
    "ID_MOUVEMENT" integer DEFAULT 1,
    "ID_DEVISE" integer DEFAULT 1,
    "T_HT" bigint DEFAULT 0,
    "T_TVA" bigint DEFAULT 0,
    "T_TTC" bigint DEFAULT 0,
    "T_SERVICE" bigint DEFAULT 0,
    "T_DEVISE" bigint DEFAULT 0,
    "T_POIDS" real DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric,
    "TAUX_APPLIQUE" numeric(12,6) DEFAULT 1,
    "T_ECO_CONTRIBUTION" bigint DEFAULT 0,
    "ID_TAXE_PORT" integer DEFAULT 1,
    "PORT_HT" bigint DEFAULT 0 NOT NULL,
    "REMISE_HT" bigint DEFAULT 0 NOT NULL,
    "ATTACHMENTS" integer DEFAULT 0 NOT NULL,
    "NET_A_PAYER" bigint DEFAULT 0 NOT NULL,
    "AVOIR_TTC" bigint DEFAULT 0 NOT NULL,
    "DATE_REGLEMENT" date,
    "ID_AVOIR_FOURNISSEUR_2" integer DEFAULT 1
);


ALTER TABLE "Default"."FACTURE_FOURNISSEUR" OWNER TO openconcerto;

--
-- TOC entry 546 (class 1259 OID 6911172)
-- Name: FACTURE_FOURNISSEUR_ELEMENT; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."FACTURE_FOURNISSEUR_ELEMENT" (
    "ID" integer NOT NULL,
    "PRIX_METRIQUE_HA_1" numeric(16,6) DEFAULT 0 NOT NULL,
    "PRIX_METRIQUE_HA_2" numeric(16,6) DEFAULT 0 NOT NULL,
    "PRIX_METRIQUE_HA_3" numeric(16,6) DEFAULT 0 NOT NULL,
    "PRIX_METRIQUE_VT_1" numeric(16,6) DEFAULT 0 NOT NULL,
    "PRIX_METRIQUE_VT_2" numeric(16,6) DEFAULT 0 NOT NULL,
    "PRIX_METRIQUE_VT_3" numeric(16,6) DEFAULT 0 NOT NULL,
    "T_PV_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "T_PA_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "PV_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "PA_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "T_PV_TTC" numeric(16,6) DEFAULT 0 NOT NULL,
    "T_PA_TTC" numeric(16,6) DEFAULT 0 NOT NULL,
    "QTE_UNITAIRE" numeric(16,6) DEFAULT 0 NOT NULL,
    "PA_DEVISE_T" numeric(16,6) DEFAULT 0 NOT NULL,
    "PA_DEVISE" numeric(16,6) DEFAULT 0 NOT NULL,
    "QTE" integer DEFAULT 1 NOT NULL,
    "QTE_ACHAT" integer DEFAULT 1 NOT NULL,
    "VALEUR_METRIQUE_1" real DEFAULT 0,
    "VALEUR_METRIQUE_2" real DEFAULT 0,
    "VALEUR_METRIQUE_3" real DEFAULT 0,
    "T_POIDS" real DEFAULT 0,
    "POIDS" real DEFAULT 0,
    "SERVICE" boolean DEFAULT false,
    "CODE" character varying(45) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(256) DEFAULT ''::character varying NOT NULL,
    "DATE" date,
    "ID_STYLE" integer DEFAULT 1,
    "ID_METRIQUE_3" integer DEFAULT 1,
    "ID_METRIQUE_2" integer DEFAULT 1,
    "ID_METRIQUE_1" integer DEFAULT 1,
    "ID_FACTURE_FOURNISSEUR" integer DEFAULT 1,
    "ID_TAXE" integer DEFAULT 1,
    "ID_MODE_VENTE_ARTICLE" integer DEFAULT 5,
    "ID_UNITE_VENTE" integer DEFAULT 1,
    "ID_ARTICLE" integer DEFAULT 1,
    "ID_DEVISE" integer DEFAULT 1,
    "ID_CODE_FOURNISSEUR" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric,
    "NIVEAU" integer DEFAULT 1 NOT NULL,
    "DESCRIPTIF" character varying(2048) DEFAULT ''::character varying NOT NULL,
    "ID_ECO_CONTRIBUTION" integer DEFAULT 1,
    "ECO_CONTRIBUTION" numeric(16,2) DEFAULT 0,
    "T_ECO_CONTRIBUTION" numeric(16,2) DEFAULT 0,
    "ID_DEMANDE_ACHAT_ELEMENT" integer DEFAULT 1,
    "ID_FAMILLE_ARTICLE" integer DEFAULT 1,
    "ID_DEPOT_STOCK" integer DEFAULT 1,
    "LONGUEUR" numeric(16,8),
    "LARGEUR" numeric(16,8),
    "HAUTEUR" numeric(16,8),
    "POIDS_COLIS_NET" numeric(16,8) DEFAULT 0,
    "T_POIDS_COLIS_NET" numeric(16,8) DEFAULT 0,
    "NB_COLIS" integer DEFAULT 0,
    "TARE" numeric(16,8),
    "T_POIDS_BRUT" numeric(16,8) DEFAULT 0,
    "ID_ARTICLE_DECLINAISON_TAILLE" integer DEFAULT 1,
    "ID_ARTICLE_DECLINAISON_COULEUR" integer DEFAULT 1
);


ALTER TABLE "Default"."FACTURE_FOURNISSEUR_ELEMENT" OWNER TO openconcerto;

--
-- TOC entry 547 (class 1259 OID 6911230)
-- Name: FACTURE_FOURNISSEUR_ELEMENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."FACTURE_FOURNISSEUR_ELEMENT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."FACTURE_FOURNISSEUR_ELEMENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24692 (class 0 OID 0)
-- Dependencies: 547
-- Name: FACTURE_FOURNISSEUR_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."FACTURE_FOURNISSEUR_ELEMENT_ID_seq" OWNED BY "Default"."FACTURE_FOURNISSEUR_ELEMENT"."ID";


--
-- TOC entry 548 (class 1259 OID 6911232)
-- Name: FACTURE_FOURNISSEUR_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."FACTURE_FOURNISSEUR_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."FACTURE_FOURNISSEUR_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24693 (class 0 OID 0)
-- Dependencies: 548
-- Name: FACTURE_FOURNISSEUR_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."FACTURE_FOURNISSEUR_ID_seq" OWNED BY "Default"."FACTURE_FOURNISSEUR"."ID";


--
-- TOC entry 549 (class 1259 OID 6911234)
-- Name: FAMILLE_ARTICLE; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."FAMILLE_ARTICLE" (
    "ID" integer NOT NULL,
    "NOM" character varying(256) DEFAULT ''::character varying NOT NULL,
    "CODE" character varying(45) DEFAULT ''::character varying,
    "ID_FAMILLE_ARTICLE_PERE" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "ID_COMPTE_PCE" integer DEFAULT 1,
    "ID_COMPTE_PCE_ACHAT" integer DEFAULT 1
);


ALTER TABLE "Default"."FAMILLE_ARTICLE" OWNER TO openconcerto;

--
-- TOC entry 550 (class 1259 OID 6911245)
-- Name: FAMILLE_ARTICLE_FOURNISSEUR; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."FAMILLE_ARTICLE_FOURNISSEUR" (
    "ID" integer NOT NULL,
    "CODE" character varying(45) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(2048) DEFAULT ''::character varying NOT NULL,
    "ID_FAMILLE_ARTICLE_FOURNISSEUR_PERE" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "Default"."FAMILLE_ARTICLE_FOURNISSEUR" OWNER TO openconcerto;

--
-- TOC entry 551 (class 1259 OID 6911256)
-- Name: FAMILLE_ARTICLE_FOURNISSEUR_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."FAMILLE_ARTICLE_FOURNISSEUR_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."FAMILLE_ARTICLE_FOURNISSEUR_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24694 (class 0 OID 0)
-- Dependencies: 551
-- Name: FAMILLE_ARTICLE_FOURNISSEUR_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."FAMILLE_ARTICLE_FOURNISSEUR_ID_seq" OWNED BY "Default"."FAMILLE_ARTICLE_FOURNISSEUR"."ID";


--
-- TOC entry 552 (class 1259 OID 6911258)
-- Name: FAMILLE_ARTICLE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."FAMILLE_ARTICLE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."FAMILLE_ARTICLE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24695 (class 0 OID 0)
-- Dependencies: 552
-- Name: FAMILLE_ARTICLE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."FAMILLE_ARTICLE_ID_seq" OWNED BY "Default"."FAMILLE_ARTICLE"."ID";


--
-- TOC entry 553 (class 1259 OID 6911260)
-- Name: FICHE_PAYE; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."FICHE_PAYE" (
    "ID" integer NOT NULL,
    "ANNEE" integer DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID_SALARIE" integer DEFAULT 1,
    "ID_PROFIL_PAYE" integer DEFAULT 1,
    "SAL_BRUT" numeric(16,2) DEFAULT 0,
    "COT_PAT" numeric(16,2) DEFAULT 0,
    "COT_SAL" numeric(16,2) DEFAULT 0,
    "NET_IMP" numeric(16,2) DEFAULT 0,
    "NET_A_PAYER" numeric(16,2) DEFAULT 0,
    "ACOMPTE" numeric(16,2) DEFAULT 0,
    "ID_MOIS" integer DEFAULT 1,
    "VALIDE" boolean DEFAULT false,
    "CSG" numeric(16,2) DEFAULT 0,
    "DU" date,
    "AU" date,
    "CONGES_ACQUIS" real DEFAULT 0,
    "ID_CUMULS_PAYE" integer DEFAULT 1,
    "ID_CUMULS_CONGES" integer DEFAULT 1,
    "ID_VARIABLE_SALARIE" integer DEFAULT 1,
    "ID_REGLEMENT_PAYE" integer DEFAULT 1,
    "NATURE_EMPLOI" character varying(150) DEFAULT ''::character varying,
    "ID_IDCC" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "ID_INFOS_SALARIE_PAYE" integer DEFAULT 1,
    "SAL_BASE_BRUT" numeric(16,2) DEFAULT 0 NOT NULL,
    "TAXE_CM_SAL" numeric(16,2) DEFAULT 0 NOT NULL,
    "TAXE_CM_PAT" numeric(16,2) DEFAULT 0 NOT NULL,
    "SAL_BRUT_COTISABLE" numeric(16,2) DEFAULT 0 NOT NULL,
    "SAL_BRUT_TAXABLE" numeric(16,2) DEFAULT 0 NOT NULL,
    "ALLEGEMENT_COTISATION" numeric(16,2) DEFAULT 0 NOT NULL,
    "CICE" numeric(16,2) DEFAULT 0 NOT NULL,
    "AVANTAGE_NATURE" numeric(16,2) DEFAULT 0 NOT NULL,
    "HEURE_TRAV" numeric(16,2) DEFAULT 0 NOT NULL,
    "DETAILS_CONGES" character varying(512) DEFAULT ''::character varying NOT NULL,
    "REDUCTION_GVT" numeric(16,2) DEFAULT 0 NOT NULL,
    "ID_PAS" integer DEFAULT 1,
    "TOTAL_PAS" numeric(16,2) DEFAULT 0 NOT NULL,
    "NET_AVANT_PAS" numeric(16,2) DEFAULT 0 NOT NULL,
    "CSG_REDUITE" numeric(16,2) DEFAULT 0 NOT NULL,
    "SAL_BRUT_CSG" numeric(16,2) DEFAULT 0 NOT NULL,
    "SAL_BRUT_CSG_REDUITE" numeric(16,2) DEFAULT 0 NOT NULL,
    "PERTE_TPT" numeric(16,2) DEFAULT 0 NOT NULL,
    "NET_SOCIAL" numeric(16,2) DEFAULT 0 NOT NULL,
    "HEURE_SUP_EXO_NET" numeric(16,2) DEFAULT 0 NOT NULL,
    "HEURE_SUP_EXO_BRUT" numeric(16,2) DEFAULT 0 NOT NULL,
    "HEURE_SUP_EXO_COEFF" numeric(16,8) DEFAULT 0 NOT NULL
);


ALTER TABLE "Default"."FICHE_PAYE" OWNER TO openconcerto;

--
-- TOC entry 554 (class 1259 OID 6911307)
-- Name: FICHE_PAYE_ELEMENT; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."FICHE_PAYE_ELEMENT" (
    "ID" integer NOT NULL,
    "ID_FICHE_PAYE" integer DEFAULT 1,
    "SOURCE" character varying(45) DEFAULT ''::character varying,
    "IDSOURCE" integer DEFAULT 1,
    "NOM" character varying(512) DEFAULT ''::character varying NOT NULL,
    "NB_BASE" numeric(16,6) DEFAULT 0,
    "TAUX_SAL" numeric(16,6) DEFAULT 0,
    "TAUX_PAT" numeric(16,6) DEFAULT 0,
    "MONTANT_SAL_AJ" numeric(16,2) DEFAULT 0,
    "MONTANT_PAT" numeric(16,2) DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "POSITION" integer DEFAULT 0,
    "MONTANT_SAL_DED" numeric(16,2) DEFAULT 0,
    "VALIDE" boolean DEFAULT false,
    "IMPRESSION" boolean DEFAULT true,
    "IN_PERIODE" boolean DEFAULT true,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "ID_STYLE" integer DEFAULT 1
);


ALTER TABLE "Default"."FICHE_PAYE_ELEMENT" OWNER TO openconcerto;

--
-- TOC entry 555 (class 1259 OID 6911331)
-- Name: FICHE_PAYE_ELEMENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."FICHE_PAYE_ELEMENT_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."FICHE_PAYE_ELEMENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24696 (class 0 OID 0)
-- Dependencies: 555
-- Name: FICHE_PAYE_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."FICHE_PAYE_ELEMENT_ID_seq" OWNED BY "Default"."FICHE_PAYE_ELEMENT"."ID";


--
-- TOC entry 556 (class 1259 OID 6911333)
-- Name: FICHE_PAYE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."FICHE_PAYE_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."FICHE_PAYE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24697 (class 0 OID 0)
-- Dependencies: 556
-- Name: FICHE_PAYE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."FICHE_PAYE_ID_seq" OWNED BY "Default"."FICHE_PAYE"."ID";


--
-- TOC entry 557 (class 1259 OID 6911335)
-- Name: FIN_CONTRAT; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."FIN_CONTRAT" (
    "ID" integer NOT NULL,
    "ID_FICHE_PAYE" integer DEFAULT 1,
    "ID_MOTIF_FIN_CONTRAT" integer DEFAULT 1,
    "DATE_FIN" timestamp without time zone,
    "DATE_NOTIFICATION" timestamp without time zone,
    "DATE_SIGNATURE_CONVENTION" timestamp without time zone,
    "DATE_ENGAGEMENT_PROCEDURE" timestamp without time zone,
    "DERNIER_JOUR_TRAV_PAYE" timestamp without time zone,
    "TRANSACTION_EN_COURS" boolean DEFAULT false NOT NULL,
    "PORTABILITE_PREVOYANCE" boolean DEFAULT false NOT NULL,
    "NB_DIF_RESTANT" integer,
    "NB_MOIS_CSP" integer,
    "SALAIRE_NET_HORAIRE" numeric(16,8),
    "INDEMNITE_VERSE" numeric(16,8),
    "ID_TYPE_PREAVIS" integer DEFAULT 1,
    "DATE_DEBUT_PREAVIS" timestamp without time zone,
    "DATE_FIN_PREAVIS" timestamp without time zone,
    "INFOS" character varying(2048) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "Default"."FIN_CONTRAT" OWNER TO openconcerto;

--
-- TOC entry 558 (class 1259 OID 6911349)
-- Name: FIN_CONTRAT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."FIN_CONTRAT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."FIN_CONTRAT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24698 (class 0 OID 0)
-- Dependencies: 558
-- Name: FIN_CONTRAT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."FIN_CONTRAT_ID_seq" OWNED BY "Default"."FIN_CONTRAT"."ID";


--
-- TOC entry 559 (class 1259 OID 6911351)
-- Name: FOURNISSEUR; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."FOURNISSEUR" (
    "ID_FOURNISSEUR" integer NOT NULL,
    "TYPE" character varying(2048) DEFAULT ''::text,
    "NOM" character varying(2048) DEFAULT ''::text,
    "CODE" character varying(2048) DEFAULT ''::text,
    "ID_ADRESSE" integer DEFAULT 1,
    "ID_ADRESSE_E" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "UE" boolean DEFAULT false NOT NULL,
    "ID_COMPTE_PCE" integer DEFAULT 1 NOT NULL,
    "ID_MODE_REGLEMENT" integer DEFAULT 1 NOT NULL,
    "TEL" character varying(2048) DEFAULT ''::text,
    "FAX" character varying(2048) DEFAULT ''::text,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "ID_LANGUE" integer DEFAULT 1,
    "ID_DEVISE" integer DEFAULT 1,
    "RESPONSABLE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "TEL_P" character varying(256) DEFAULT ''::character varying NOT NULL,
    "MAIL" character varying(256) DEFAULT ''::character varying NOT NULL,
    "INFOS" character varying(2048) DEFAULT ''::character varying NOT NULL,
    "ID_COMPTE_PCE_CHARGE" integer DEFAULT 1,
    "ATTACHMENTS" integer DEFAULT 0 NOT NULL,
    "NUMERO_TVA" character varying(128) DEFAULT ''::character varying NOT NULL,
    "SIRET" character varying(128) DEFAULT ''::character varying NOT NULL,
    "IBAN" character varying(128) DEFAULT ''::character varying NOT NULL,
    "BIC" character varying(128) DEFAULT ''::character varying NOT NULL,
    "ID_CATEGORIE_COMPTABLE" integer DEFAULT 1,
    "CONDITIONS_PORT" character varying(128) DEFAULT ''::character varying NOT NULL
);


ALTER TABLE "Default"."FOURNISSEUR" OWNER TO openconcerto;

--
-- TOC entry 560 (class 1259 OID 6911384)
-- Name: FOURNISSEUR_ID_FOURNISSEUR_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."FOURNISSEUR_ID_FOURNISSEUR_seq"
    START WITH 2
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."FOURNISSEUR_ID_FOURNISSEUR_seq" OWNER TO openconcerto;

--
-- TOC entry 24699 (class 0 OID 0)
-- Dependencies: 560
-- Name: FOURNISSEUR_ID_FOURNISSEUR_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."FOURNISSEUR_ID_FOURNISSEUR_seq" OWNED BY "Default"."FOURNISSEUR"."ID_FOURNISSEUR";


--
-- TOC entry 561 (class 1259 OID 6911386)
-- Name: FRAIS_DOCUMENT; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."FRAIS_DOCUMENT" (
    "ID" integer NOT NULL,
    "CODE" character varying(48) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(256) DEFAULT ''::character varying NOT NULL,
    "MONTANT_HT" bigint DEFAULT 0 NOT NULL,
    "ID_TAXE" integer DEFAULT 1,
    "MONTANT_TTC" bigint DEFAULT 0 NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8)
);


ALTER TABLE "Default"."FRAIS_DOCUMENT" OWNER TO openconcerto;

--
-- TOC entry 562 (class 1259 OID 6911395)
-- Name: FRAIS_DOCUMENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."FRAIS_DOCUMENT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."FRAIS_DOCUMENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24700 (class 0 OID 0)
-- Dependencies: 562
-- Name: FRAIS_DOCUMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."FRAIS_DOCUMENT_ID_seq" OWNED BY "Default"."FRAIS_DOCUMENT"."ID";


--
-- TOC entry 563 (class 1259 OID 6911397)
-- Name: FWK_MODULE_DEP; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."FWK_MODULE_DEP" (
    "ID_MODULE" integer NOT NULL,
    "ID_MODULE_NEEDED" integer NOT NULL
);


ALTER TABLE "Default"."FWK_MODULE_DEP" OWNER TO openconcerto;

--
-- TOC entry 564 (class 1259 OID 6911400)
-- Name: FWK_MODULE_METADATA; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."FWK_MODULE_METADATA" (
    "ID" integer NOT NULL,
    "MODULE_NAME" character varying(128) DEFAULT ''::character varying NOT NULL,
    "TABLE" character varying(128),
    "FIELD" character varying(128),
    "KEY" boolean,
    "MODULE_VERSION" bigint NOT NULL
);


ALTER TABLE "Default"."FWK_MODULE_METADATA" OWNER TO openconcerto;

--
-- TOC entry 565 (class 1259 OID 6911404)
-- Name: FWK_MODULE_METADATA_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."FWK_MODULE_METADATA_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."FWK_MODULE_METADATA_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24701 (class 0 OID 0)
-- Dependencies: 565
-- Name: FWK_MODULE_METADATA_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."FWK_MODULE_METADATA_ID_seq" OWNED BY "Default"."FWK_MODULE_METADATA"."ID";


--
-- TOC entry 566 (class 1259 OID 6911406)
-- Name: FWK_SCHEMA_METADATA; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."FWK_SCHEMA_METADATA" (
    "NAME" character varying(100) DEFAULT ''::character varying NOT NULL,
    "VALUE" character varying(250) DEFAULT ''::character varying NOT NULL
);


ALTER TABLE "Default"."FWK_SCHEMA_METADATA" OWNER TO openconcerto;

--
-- TOC entry 567 (class 1259 OID 6911411)
-- Name: FWK_UNDEFINED_IDS; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."FWK_UNDEFINED_IDS" (
    "TABLENAME" character varying(250) DEFAULT ''::character varying NOT NULL,
    "UNDEFINED_ID" integer DEFAULT 0
);


ALTER TABLE "Default"."FWK_UNDEFINED_IDS" OWNER TO openconcerto;

--
-- TOC entry 568 (class 1259 OID 6911416)
-- Name: INFOS_SALARIE_PAYE; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."INFOS_SALARIE_PAYE" (
    "ID" integer NOT NULL,
    "ID_IDCC" integer DEFAULT 1,
    "ID_CONTRAT_SALARIE" integer DEFAULT 1,
    "ID_CLASSEMENT_CONVENTIONNEL" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "DUREE_HEBDO" real DEFAULT 0,
    "DUREE_MOIS" real DEFAULT 0,
    "DATE_ARRIVE" date,
    "CONGES_PAYES" real DEFAULT 0,
    "TAUX_AT" real DEFAULT 0,
    "SALAIRE_MOIS" real DEFAULT 0,
    "DATE_SORTIE" date,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "CODE_AT" character varying(18) DEFAULT ''::character varying NOT NULL,
    "CODE_SECTION_AT" character varying(18) DEFAULT ''::character varying NOT NULL,
    "ID_COEFF_PRIME" integer DEFAULT 1,
    "ID_SALARIE" integer DEFAULT 1,
    "DUREE_FORFAIT" real
);


ALTER TABLE "Default"."INFOS_SALARIE_PAYE" OWNER TO openconcerto;

--
-- TOC entry 569 (class 1259 OID 6911434)
-- Name: INFOS_SALARIE_PAYE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."INFOS_SALARIE_PAYE_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."INFOS_SALARIE_PAYE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24702 (class 0 OID 0)
-- Dependencies: 569
-- Name: INFOS_SALARIE_PAYE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."INFOS_SALARIE_PAYE_ID_seq" OWNED BY "Default"."INFOS_SALARIE_PAYE"."ID";


--
-- TOC entry 570 (class 1259 OID 6911436)
-- Name: JOURNAL; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."JOURNAL" (
    "ID" integer NOT NULL,
    "NOM" character varying(2048) DEFAULT ''::text,
    "CODE" character varying(2048) DEFAULT ''::text,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "PAR_DEFAUT" boolean DEFAULT false,
    "TYPE_BANQUE" boolean DEFAULT false,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."JOURNAL" OWNER TO openconcerto;

--
-- TOC entry 571 (class 1259 OID 6911449)
-- Name: JOURNAL_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."JOURNAL_ID_seq"
    START WITH 7
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."JOURNAL_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24703 (class 0 OID 0)
-- Dependencies: 571
-- Name: JOURNAL_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."JOURNAL_ID_seq" OWNED BY "Default"."JOURNAL"."ID";


--
-- TOC entry 572 (class 1259 OID 6911451)
-- Name: LANGUE; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."LANGUE" (
    "ID" integer NOT NULL,
    "CODE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(256) DEFAULT ''::character varying NOT NULL,
    "CHEMIN" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "Default"."LANGUE" OWNER TO openconcerto;

--
-- TOC entry 573 (class 1259 OID 6911462)
-- Name: LANGUE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."LANGUE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."LANGUE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24704 (class 0 OID 0)
-- Dependencies: 573
-- Name: LANGUE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."LANGUE_ID_seq" OWNED BY "Default"."LANGUE"."ID";


--
-- TOC entry 574 (class 1259 OID 6911464)
-- Name: LOT; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."LOT" (
    "ID" integer NOT NULL,
    "ID_STOCK" integer DEFAULT 1,
    "QUANTITE" numeric(16,6) DEFAULT 1 NOT NULL,
    "NUMERO_LOT" character varying(256) DEFAULT ''::character varying NOT NULL,
    "NUMERO_SERIE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "DLC" date,
    "DLUO" date,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8)
);


ALTER TABLE "Default"."LOT" OWNER TO openconcerto;

--
-- TOC entry 575 (class 1259 OID 6911475)
-- Name: LOT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."LOT_ID_seq"
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."LOT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24705 (class 0 OID 0)
-- Dependencies: 575
-- Name: LOT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."LOT_ID_seq" OWNED BY "Default"."LOT"."ID";


--
-- TOC entry 576 (class 1259 OID 6911477)
-- Name: LOT_LIVRAISON; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."LOT_LIVRAISON" (
    "ID" integer NOT NULL,
    "DATE_LIVRAISON" timestamp without time zone,
    "CLIENT" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ARTICLE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ID_ARTICLE" integer DEFAULT 1,
    "ID_DEPOT_STOCK" integer DEFAULT 1,
    "QUANTITE" numeric(16,6) DEFAULT 1 NOT NULL,
    "NUMERO_LOT" character varying(256) DEFAULT ''::character varying NOT NULL,
    "NUMERO_SERIE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "DLC" date,
    "DLUO" date,
    "ID_BON_DE_LIVRAISON_ELEMENT" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8),
    "ID_LOT" integer DEFAULT 1
);


ALTER TABLE "Default"."LOT_LIVRAISON" OWNER TO openconcerto;

--
-- TOC entry 577 (class 1259 OID 6911493)
-- Name: LOT_LIVRAISON_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."LOT_LIVRAISON_ID_seq"
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."LOT_LIVRAISON_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24706 (class 0 OID 0)
-- Dependencies: 577
-- Name: LOT_LIVRAISON_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."LOT_LIVRAISON_ID_seq" OWNED BY "Default"."LOT_LIVRAISON"."ID";


--
-- TOC entry 578 (class 1259 OID 6911495)
-- Name: LOT_RECEPTION; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."LOT_RECEPTION" (
    "ID" integer NOT NULL,
    "DATE_RECEPTION" timestamp without time zone,
    "FOURNISSEUR" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ARTICLE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ID_ARTICLE" integer DEFAULT 1,
    "ID_DEPOT_STOCK" integer DEFAULT 1,
    "QUANTITE" numeric(16,6) DEFAULT 1 NOT NULL,
    "NUMERO_LOT" character varying(256) DEFAULT ''::character varying NOT NULL,
    "NUMERO_SERIE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "DLC" date,
    "DLUO" date,
    "ID_BON_RECEPTION_ELEMENT" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8),
    "ID_LOT" integer DEFAULT 1
);


ALTER TABLE "Default"."LOT_RECEPTION" OWNER TO openconcerto;

--
-- TOC entry 579 (class 1259 OID 6911511)
-- Name: LOT_RECEPTION_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."LOT_RECEPTION_ID_seq"
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."LOT_RECEPTION_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24707 (class 0 OID 0)
-- Dependencies: 579
-- Name: LOT_RECEPTION_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."LOT_RECEPTION_ID_seq" OWNED BY "Default"."LOT_RECEPTION"."ID";


--
-- TOC entry 580 (class 1259 OID 6911513)
-- Name: METRIQUE; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."METRIQUE" (
    "ID" integer NOT NULL,
    "NOM" character varying(45) DEFAULT ''::character varying,
    "UNITE" character varying(45) DEFAULT ''::character varying,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."METRIQUE" OWNER TO openconcerto;

--
-- TOC entry 581 (class 1259 OID 6911521)
-- Name: METRIQUE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."METRIQUE_ID_seq"
    START WITH 4
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."METRIQUE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24708 (class 0 OID 0)
-- Dependencies: 581
-- Name: METRIQUE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."METRIQUE_ID_seq" OWNED BY "Default"."METRIQUE"."ID";


--
-- TOC entry 582 (class 1259 OID 6911523)
-- Name: MODELE; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."MODELE" (
    "ID" integer NOT NULL,
    "NOM" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ID_TYPE_MODELE" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "Default"."MODELE" OWNER TO openconcerto;

--
-- TOC entry 583 (class 1259 OID 6911530)
-- Name: MODELE_COURRIER_CLIENT; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."MODELE_COURRIER_CLIENT" (
    "ID" integer NOT NULL,
    "NOM" character varying(45) DEFAULT ''::character varying,
    "CODE" character varying(10) DEFAULT ''::character varying,
    "LOCATION" character varying(2048) DEFAULT ''::text,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "CONTENU" character varying(2048) DEFAULT ''::text,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "TEMPLATE_NAME" character varying(256) DEFAULT ''::character varying NOT NULL
);


ALTER TABLE "Default"."MODELE_COURRIER_CLIENT" OWNER TO openconcerto;

--
-- TOC entry 584 (class 1259 OID 6911544)
-- Name: MODELE_COURRIER_CLIENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."MODELE_COURRIER_CLIENT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."MODELE_COURRIER_CLIENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24709 (class 0 OID 0)
-- Dependencies: 584
-- Name: MODELE_COURRIER_CLIENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."MODELE_COURRIER_CLIENT_ID_seq" OWNED BY "Default"."MODELE_COURRIER_CLIENT"."ID";


--
-- TOC entry 585 (class 1259 OID 6911546)
-- Name: MODELE_EMAIL; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."MODELE_EMAIL" (
    "ID" integer NOT NULL,
    "NOM" character varying(80) DEFAULT ''::character varying NOT NULL,
    "TITRE" character varying(80) DEFAULT ''::character varying NOT NULL,
    "TEXTE" character varying(4096) DEFAULT ''::character varying NOT NULL,
    "FORMAT_DATE" character varying(20) DEFAULT ''::character varying NOT NULL,
    "PAR_DEFAUT" boolean DEFAULT false NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8),
    "TABLE_NAME" character varying(256) DEFAULT ''::character varying NOT NULL
);


ALTER TABLE "Default"."MODELE_EMAIL" OWNER TO openconcerto;

--
-- TOC entry 586 (class 1259 OID 6911559)
-- Name: MODELE_EMAIL_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."MODELE_EMAIL_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."MODELE_EMAIL_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24710 (class 0 OID 0)
-- Dependencies: 586
-- Name: MODELE_EMAIL_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."MODELE_EMAIL_ID_seq" OWNED BY "Default"."MODELE_EMAIL"."ID";


--
-- TOC entry 587 (class 1259 OID 6911561)
-- Name: MODELE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."MODELE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."MODELE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24711 (class 0 OID 0)
-- Dependencies: 587
-- Name: MODELE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."MODELE_ID_seq" OWNED BY "Default"."MODELE"."ID";


--
-- TOC entry 588 (class 1259 OID 6911563)
-- Name: MODE_REGLEMENT; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."MODE_REGLEMENT" (
    "ID_MODE_REGLEMENT" integer NOT NULL,
    "NOM" character varying(2048) DEFAULT ''::text,
    "CODE" character varying(2048) DEFAULT ''::text,
    "AJOURS" integer DEFAULT 0,
    "LENJOUR" integer DEFAULT 0,
    "ID_TYPE_REGLEMENT" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "FIN_MOIS" boolean DEFAULT false,
    "COMPTANT" boolean DEFAULT false,
    "DATE_DEPOT" date,
    "DATE_FACTURE" boolean DEFAULT false,
    "DATE" date,
    "NUMERO" character varying(2048) DEFAULT ''::text,
    "ETS" character varying(2048) DEFAULT ''::text,
    "DATE_VIREMENT" date,
    "ID_BANQUE" integer DEFAULT 1,
    "ID_SEPA_MANDATE" integer,
    "RG" boolean DEFAULT false NOT NULL
);


ALTER TABLE "Default"."MODE_REGLEMENT" OWNER TO openconcerto;

--
-- TOC entry 589 (class 1259 OID 6911584)
-- Name: MODE_REGLEMENT_ID_MODE_REGLEMENT_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."MODE_REGLEMENT_ID_MODE_REGLEMENT_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."MODE_REGLEMENT_ID_MODE_REGLEMENT_seq" OWNER TO openconcerto;

--
-- TOC entry 24712 (class 0 OID 0)
-- Dependencies: 589
-- Name: MODE_REGLEMENT_ID_MODE_REGLEMENT_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."MODE_REGLEMENT_ID_MODE_REGLEMENT_seq" OWNED BY "Default"."MODE_REGLEMENT"."ID_MODE_REGLEMENT";


--
-- TOC entry 590 (class 1259 OID 6911586)
-- Name: MODE_REGLEMENT_PAYE; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."MODE_REGLEMENT_PAYE" (
    "ID" integer NOT NULL,
    "NOM" character varying(45) DEFAULT ''::character varying
);


ALTER TABLE "Default"."MODE_REGLEMENT_PAYE" OWNER TO openconcerto;

--
-- TOC entry 591 (class 1259 OID 6911590)
-- Name: MODE_REGLEMENT_PAYE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."MODE_REGLEMENT_PAYE_ID_seq"
    START WITH 4
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."MODE_REGLEMENT_PAYE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24713 (class 0 OID 0)
-- Dependencies: 591
-- Name: MODE_REGLEMENT_PAYE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."MODE_REGLEMENT_PAYE_ID_seq" OWNED BY "Default"."MODE_REGLEMENT_PAYE"."ID";


--
-- TOC entry 592 (class 1259 OID 6911592)
-- Name: MODE_VENTE_ARTICLE; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."MODE_VENTE_ARTICLE" (
    "ID" integer NOT NULL,
    "NOM" character varying(45) DEFAULT ''::character varying,
    "ID_METRIQUE_1" integer DEFAULT 1,
    "PRIX_METRIQUE_HA_1" bigint DEFAULT 0,
    "PRIX_METRIQUE_VT_1" bigint DEFAULT 0,
    "ID_METRIQUE_2" integer DEFAULT 1,
    "PRIX_METRIQUE_HA_2" bigint DEFAULT 0,
    "PRIX_METRIQUE_VT_2" bigint DEFAULT 0,
    "ID_METRIQUE_3" integer DEFAULT 1,
    "PRIX_METRIQUE_VT_3" bigint DEFAULT 0,
    "PRIX_METRIQUE_HA_3" bigint DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8) DEFAULT 0.00000000,
    "CODE" character varying(45) DEFAULT ''::character varying,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."MODE_VENTE_ARTICLE" OWNER TO openconcerto;

--
-- TOC entry 593 (class 1259 OID 6911610)
-- Name: MODE_VENTE_ARTICLE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."MODE_VENTE_ARTICLE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."MODE_VENTE_ARTICLE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24714 (class 0 OID 0)
-- Dependencies: 593
-- Name: MODE_VENTE_ARTICLE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."MODE_VENTE_ARTICLE_ID_seq" OWNED BY "Default"."MODE_VENTE_ARTICLE"."ID";


--
-- TOC entry 594 (class 1259 OID 6911612)
-- Name: MOIS; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."MOIS" (
    "ID" integer NOT NULL,
    "NOM" character varying(45) DEFAULT ''::character varying,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."MOIS" OWNER TO openconcerto;

--
-- TOC entry 595 (class 1259 OID 6911619)
-- Name: MOIS_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."MOIS_ID_seq"
    START WITH 14
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."MOIS_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24715 (class 0 OID 0)
-- Dependencies: 595
-- Name: MOIS_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."MOIS_ID_seq" OWNED BY "Default"."MOIS"."ID";


--
-- TOC entry 596 (class 1259 OID 6911621)
-- Name: MOUVEMENT; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."MOUVEMENT" (
    "ID" integer NOT NULL,
    "NUMERO" integer DEFAULT 0,
    "IDSOURCE" integer DEFAULT 1,
    "SOURCE" character varying(2048) DEFAULT ''::text,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID_MOUVEMENT_PERE" integer DEFAULT 1,
    "ID_PIECE" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "ATTACHMENTS" integer DEFAULT 0 NOT NULL
);


ALTER TABLE "Default"."MOUVEMENT" OWNER TO openconcerto;

--
-- TOC entry 597 (class 1259 OID 6911636)
-- Name: MOUVEMENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."MOUVEMENT_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."MOUVEMENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24716 (class 0 OID 0)
-- Dependencies: 597
-- Name: MOUVEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."MOUVEMENT_ID_seq" OWNED BY "Default"."MOUVEMENT"."ID";


--
-- TOC entry 598 (class 1259 OID 6911638)
-- Name: MOUVEMENT_STOCK; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."MOUVEMENT_STOCK" (
    "ID" integer NOT NULL,
    "QTE" real DEFAULT 0,
    "SOURCE" character varying(45) DEFAULT ''::character varying,
    "IDSOURCE" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "NUMERO" character varying(150) DEFAULT ''::character varying,
    "NOM" character varying(512) DEFAULT ''::character varying NOT NULL,
    "DATE" date,
    "ID_ARTICLE" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "REEL" boolean DEFAULT true NOT NULL,
    "CLOTURE" boolean DEFAULT false NOT NULL,
    "OUVERTURE" boolean DEFAULT false NOT NULL,
    "ID_ETAT_STOCK" integer DEFAULT 1,
    "ID_STOCK" integer DEFAULT 1,
    "SOURCE_ELEMENTID" integer DEFAULT 1 NOT NULL
);


ALTER TABLE "Default"."MOUVEMENT_STOCK" OWNER TO openconcerto;

--
-- TOC entry 599 (class 1259 OID 6911659)
-- Name: MOUVEMENT_STOCK_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."MOUVEMENT_STOCK_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."MOUVEMENT_STOCK_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24717 (class 0 OID 0)
-- Dependencies: 599
-- Name: MOUVEMENT_STOCK_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."MOUVEMENT_STOCK_ID_seq" OWNED BY "Default"."MOUVEMENT_STOCK"."ID";


--
-- TOC entry 600 (class 1259 OID 6911661)
-- Name: NATURE_COMPTE; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."NATURE_COMPTE" (
    "ID" integer NOT NULL,
    "NOM" character varying(2048) DEFAULT ''::text,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."NATURE_COMPTE" OWNER TO openconcerto;

--
-- TOC entry 601 (class 1259 OID 6911671)
-- Name: NATURE_COMPTE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."NATURE_COMPTE_ID_seq"
    START WITH 13
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."NATURE_COMPTE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24718 (class 0 OID 0)
-- Dependencies: 601
-- Name: NATURE_COMPTE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."NATURE_COMPTE_ID_seq" OWNED BY "Default"."NATURE_COMPTE"."ID";


--
-- TOC entry 602 (class 1259 OID 6911673)
-- Name: NUMEROTATION_AUTO; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."NUMEROTATION_AUTO" (
    "ID" integer NOT NULL,
    "DEVIS_FORMAT" character varying(45) DEFAULT ''::character varying,
    "DEVIS_START" integer DEFAULT 1,
    "BON_L_FORMAT" character varying(45) DEFAULT ''::character varying,
    "BON_L_START" integer DEFAULT 1,
    "FACT_FORMAT" character varying(45) DEFAULT ''::character varying,
    "FACT_START" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "SALARIE_FORMAT" character varying(45) DEFAULT ''::character varying,
    "SALARIE_START" integer DEFAULT 1,
    "PROPOSITION_FORMAT" character varying(45) DEFAULT ''::character varying,
    "PROPOSITION_START" integer DEFAULT 0,
    "RELANCE_FORMAT" character varying(45) DEFAULT ''::character varying,
    "RELANCE_START" integer DEFAULT 0,
    "COMMANDE_CLIENT_START" integer DEFAULT 0,
    "COMMANDE_CLIENT_FORMAT" character varying(45) DEFAULT ''::character varying,
    "COMMANDE_START" integer DEFAULT 0,
    "COMMANDE_FORMAT" character varying(45) DEFAULT ''::character varying,
    "BON_R_FORMAT" character varying(45) DEFAULT ''::character varying,
    "BON_R_START" integer DEFAULT 0,
    "AFFAIRE_START" integer DEFAULT 0,
    "AFFAIRE_FORMAT" character varying(45) DEFAULT ''::character varying,
    "AVOIR_START" integer DEFAULT 0,
    "AVOIR_FORMAT" character varying(45) DEFAULT ''::character varying,
    "CODE_LETTRAGE" character varying(128) DEFAULT 'AAA'::character varying,
    "COURRIER_FORMAT" character varying(45) DEFAULT ''::character varying,
    "COURRIER_START" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "AVOIR_F_START" integer DEFAULT 0,
    "AVOIR_F_FORMAT" character varying(48) DEFAULT ''::character varying NOT NULL,
    "CLIENT_START" integer DEFAULT 0,
    "CLIENT_FORMAT" character varying(48) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(256) DEFAULT 'Standard'::character varying,
    "DMD_PRIX_FORMAT" character varying(128) DEFAULT ''::character varying NOT NULL,
    "DMD_PRIX_START" integer DEFAULT 1 NOT NULL,
    "CODE_LETTRAGE_PARTIEL" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ARTICLE_FORMAT" character varying(128) DEFAULT ''::character varying NOT NULL,
    "ARTICLE_START" integer DEFAULT 1 NOT NULL
);


ALTER TABLE "Default"."NUMEROTATION_AUTO" OWNER TO openconcerto;

--
-- TOC entry 603 (class 1259 OID 6911717)
-- Name: NUMEROTATION_AUTO_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."NUMEROTATION_AUTO_ID_seq"
    START WITH 3
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."NUMEROTATION_AUTO_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24719 (class 0 OID 0)
-- Dependencies: 603
-- Name: NUMEROTATION_AUTO_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."NUMEROTATION_AUTO_ID_seq" OWNED BY "Default"."NUMEROTATION_AUTO"."ID";


--
-- TOC entry 604 (class 1259 OID 6911719)
-- Name: OBJECTIF_COMMERCIAL; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."OBJECTIF_COMMERCIAL" (
    "ID" integer NOT NULL,
    "MOIS" character varying(32) DEFAULT ''::character varying NOT NULL,
    "ANNEE" integer,
    "MARGE_HT" bigint DEFAULT 0,
    "POURCENT_MARGE" numeric(16,8),
    "CHIFFRE_AFFAIRE" bigint DEFAULT 0,
    "ID_COMMERCIAL" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "Default"."OBJECTIF_COMMERCIAL" OWNER TO openconcerto;

--
-- TOC entry 605 (class 1259 OID 6911728)
-- Name: OBJECTIF_COMMERCIAL_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."OBJECTIF_COMMERCIAL_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."OBJECTIF_COMMERCIAL_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24720 (class 0 OID 0)
-- Dependencies: 605
-- Name: OBJECTIF_COMMERCIAL_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."OBJECTIF_COMMERCIAL_ID_seq" OWNED BY "Default"."OBJECTIF_COMMERCIAL"."ID";


--
-- TOC entry 606 (class 1259 OID 6911730)
-- Name: PAS; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."PAS" (
    "ID" integer NOT NULL,
    "ID_TYPE_TAUX_PAS" integer DEFAULT 1,
    "CODE_PAS" character varying(256) DEFAULT ''::character varying NOT NULL,
    "TAUX_PAS" numeric(16,2) DEFAULT 0 NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8)
);


ALTER TABLE "Default"."PAS" OWNER TO openconcerto;

--
-- TOC entry 607 (class 1259 OID 6911737)
-- Name: PAS_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."PAS_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."PAS_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24721 (class 0 OID 0)
-- Dependencies: 607
-- Name: PAS_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."PAS_ID_seq" OWNED BY "Default"."PAS"."ID";


--
-- TOC entry 608 (class 1259 OID 6911739)
-- Name: PAYS; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."PAYS" (
    "ID" integer NOT NULL,
    "CODE" character varying(15) DEFAULT ''::character varying,
    "NOM" character varying(50) DEFAULT ''::character varying,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "ID_TARIF" integer DEFAULT 1,
    "ID_LANGUE" integer DEFAULT 1
);


ALTER TABLE "Default"."PAYS" OWNER TO openconcerto;

--
-- TOC entry 609 (class 1259 OID 6911749)
-- Name: PAYS_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."PAYS_ID_seq"
    START WITH 194
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."PAYS_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24722 (class 0 OID 0)
-- Dependencies: 609
-- Name: PAYS_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."PAYS_ID_seq" OWNED BY "Default"."PAYS"."ID";


--
-- TOC entry 610 (class 1259 OID 6911751)
-- Name: PIECE; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."PIECE" (
    "ID" integer NOT NULL,
    "NOM" character varying(2048) DEFAULT ''::text,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."PIECE" OWNER TO openconcerto;

--
-- TOC entry 611 (class 1259 OID 6911761)
-- Name: PIECE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."PIECE_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."PIECE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24723 (class 0 OID 0)
-- Dependencies: 611
-- Name: PIECE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."PIECE_ID_seq" OWNED BY "Default"."PIECE"."ID";


--
-- TOC entry 612 (class 1259 OID 6911763)
-- Name: POSTE_ANALYTIQUE; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."POSTE_ANALYTIQUE" (
    "ID" integer NOT NULL,
    "NOM" character varying(2048) DEFAULT ''::text,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID_AXE_ANALYTIQUE" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "DEFAULT" boolean DEFAULT false NOT NULL,
    "OBSOLETE" boolean DEFAULT false NOT NULL
);


ALTER TABLE "Default"."POSTE_ANALYTIQUE" OWNER TO openconcerto;

--
-- TOC entry 613 (class 1259 OID 6911776)
-- Name: POSTE_ANALYTIQUE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."POSTE_ANALYTIQUE_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."POSTE_ANALYTIQUE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24724 (class 0 OID 0)
-- Dependencies: 613
-- Name: POSTE_ANALYTIQUE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."POSTE_ANALYTIQUE_ID_seq" OWNED BY "Default"."POSTE_ANALYTIQUE"."ID";


--
-- TOC entry 614 (class 1259 OID 6911778)
-- Name: PREFERENCES; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."PREFERENCES" (
    "NAME" character varying(2048) NOT NULL,
    "VALUE" character varying(2048),
    "ID" integer NOT NULL,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."PREFERENCES" OWNER TO openconcerto;

--
-- TOC entry 615 (class 1259 OID 6911788)
-- Name: PREFERENCES_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."PREFERENCES_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."PREFERENCES_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24725 (class 0 OID 0)
-- Dependencies: 615
-- Name: PREFERENCES_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."PREFERENCES_ID_seq" OWNED BY "Default"."PREFERENCES"."ID";


--
-- TOC entry 616 (class 1259 OID 6911790)
-- Name: PREFS_COMPTE; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."PREFS_COMPTE" (
    "ID" integer NOT NULL,
    "ID_COMPTE_PCE_ACHAT" integer DEFAULT 1,
    "ID_COMPTE_PCE_TVA_ACHAT" integer DEFAULT 1,
    "ID_COMPTE_PCE_FOURNISSEUR" integer DEFAULT 1,
    "ID_COMPTE_PCE_VENTE_PRODUIT" integer DEFAULT 1,
    "ID_COMPTE_PCE_TVA_VENTE" integer DEFAULT 1,
    "ID_COMPTE_PCE_CLIENT" integer DEFAULT 1,
    "ID_COMPTE_PCE_VENTE_SERVICE" integer DEFAULT 1,
    "ID_COMPTE_PCE_ACOMPTE" integer DEFAULT 1,
    "ID_COMPTE_PCE_ACOMPTE_REGL" integer DEFAULT 1,
    "ID_COMPTE_PCE_PAYE" integer DEFAULT 1,
    "ID_COMPTE_PCE_TVA_INTRA" integer DEFAULT 1 NOT NULL,
    "ID_COMPTE_PCE_TVA_IMMO" integer DEFAULT 1,
    "ID_COMPTE_PCE_BILAN_O" integer DEFAULT 1,
    "ID_COMPTE_PCE_RESULTAT" integer DEFAULT 1,
    "ID_COMPTE_PCE_BILAN_F" integer DEFAULT 1,
    "ID_COMPTE_PCE_ACHAT_INTRA" integer DEFAULT 1,
    "ID_JOURNAL_FACTOR" integer DEFAULT 1,
    "ID_COMPTE_PCE_FACTOR" integer DEFAULT 1,
    "ID_COMPTE_PCE_RESULTAT_PERTE" integer DEFAULT 1,
    "ID_COMPTE_PCE_PORT_SOUMIS" integer DEFAULT 1,
    "ID_COMPTE_PCE_PORT_NON_SOUMIS" integer DEFAULT 1,
    "ID_COMPTE_PCE_AVANCE_CLIENT" integer DEFAULT 1,
    "ID_COMPTE_PCE_VALEUR_ENCAISSEMENT" integer DEFAULT 1,
    "ID_JOURNAL_AN" integer DEFAULT 1,
    "CREATE_NUL_SOLDE_ECR" boolean DEFAULT true NOT NULL,
    "AUTO_LETTRAGE" boolean DEFAULT false NOT NULL,
    "ID_JOURNAL_VALEUR_ENCAISSEMENT" integer DEFAULT 1,
    "ID_JOURNAL_CB_ATTENTE" integer DEFAULT 1,
    "ID_COMPTE_PCE_CB_ATTENTE" integer DEFAULT 1,
    "ID_COMPTE_PCE_PORT_SOUMIS_ACHAT" integer DEFAULT 1,
    "ID_COMPTE_PCE_PORT_NON_SOUMIS_ACHAT" integer DEFAULT 1
);


ALTER TABLE "Default"."PREFS_COMPTE" OWNER TO openconcerto;

--
-- TOC entry 617 (class 1259 OID 6911824)
-- Name: PREFS_COMPTE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."PREFS_COMPTE_ID_seq"
    START WITH 3
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."PREFS_COMPTE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24726 (class 0 OID 0)
-- Dependencies: 617
-- Name: PREFS_COMPTE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."PREFS_COMPTE_ID_seq" OWNED BY "Default"."PREFS_COMPTE"."ID";


--
-- TOC entry 1483 (class 1259 OID 6941534)
-- Name: RAPPROCHEMENT_BANCAIRE; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."RAPPROCHEMENT_BANCAIRE" (
    "ID" integer NOT NULL,
    "ID_RELEVE_BANCAIRE_ELEMENT" integer,
    "ID_ECRITURE" integer DEFAULT 1,
    "DATE" timestamp without time zone,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8)
);


ALTER TABLE "Default"."RAPPROCHEMENT_BANCAIRE" OWNER TO openconcerto;

--
-- TOC entry 1482 (class 1259 OID 6941532)
-- Name: RAPPROCHEMENT_BANCAIRE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."RAPPROCHEMENT_BANCAIRE_ID_seq"
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."RAPPROCHEMENT_BANCAIRE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24727 (class 0 OID 0)
-- Dependencies: 1482
-- Name: RAPPROCHEMENT_BANCAIRE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."RAPPROCHEMENT_BANCAIRE_ID_seq" OWNED BY "Default"."RAPPROCHEMENT_BANCAIRE"."ID";


--
-- TOC entry 618 (class 1259 OID 6911826)
-- Name: REFERENCE_CLIENT; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."REFERENCE_CLIENT" (
    "ID" integer NOT NULL,
    "NOM" character varying(2048) DEFAULT ''::text,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."REFERENCE_CLIENT" OWNER TO openconcerto;

--
-- TOC entry 619 (class 1259 OID 6911837)
-- Name: REFERENCE_CLIENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."REFERENCE_CLIENT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."REFERENCE_CLIENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24728 (class 0 OID 0)
-- Dependencies: 619
-- Name: REFERENCE_CLIENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."REFERENCE_CLIENT_ID_seq" OWNED BY "Default"."REFERENCE_CLIENT"."ID";


--
-- TOC entry 620 (class 1259 OID 6911839)
-- Name: REGIME_BASE; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."REGIME_BASE" (
    "ID" integer NOT NULL,
    "ID_CODE_REGIME_BASE" integer DEFAULT 1,
    "ID_CODE_REGIME_MALADIE" integer DEFAULT 1,
    "ID_CODE_REGIME_AT" integer DEFAULT 1,
    "ID_CODE_REGIME_VIEL_P" integer DEFAULT 1,
    "ID_CODE_REGIME_VIEL_S" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "NOM" character varying(128) DEFAULT ''::character varying NOT NULL,
    "CODE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."REGIME_BASE" OWNER TO openconcerto;

--
-- TOC entry 621 (class 1259 OID 6911852)
-- Name: REGIME_BASE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."REGIME_BASE_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."REGIME_BASE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24729 (class 0 OID 0)
-- Dependencies: 621
-- Name: REGIME_BASE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."REGIME_BASE_ID_seq" OWNED BY "Default"."REGIME_BASE"."ID";


--
-- TOC entry 622 (class 1259 OID 6911854)
-- Name: REGLEMENT_PAYE; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."REGLEMENT_PAYE" (
    "ID" integer NOT NULL,
    "NOM_BANQUE" character varying(45) DEFAULT ''::character varying,
    "RIB" character varying(45) DEFAULT ''::character varying,
    "ID_COMPTE_PCE" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "LE" integer DEFAULT 1,
    "ID_MODE_REGLEMENT_PAYE" integer DEFAULT 1,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "IBAN" character varying(128) DEFAULT ''::character varying NOT NULL,
    "BIC" character varying(40) DEFAULT ''::character varying NOT NULL
);


ALTER TABLE "Default"."REGLEMENT_PAYE" OWNER TO openconcerto;

--
-- TOC entry 623 (class 1259 OID 6911867)
-- Name: REGLEMENT_PAYE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."REGLEMENT_PAYE_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."REGLEMENT_PAYE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24730 (class 0 OID 0)
-- Dependencies: 623
-- Name: REGLEMENT_PAYE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."REGLEMENT_PAYE_ID_seq" OWNED BY "Default"."REGLEMENT_PAYE"."ID";


--
-- TOC entry 624 (class 1259 OID 6911869)
-- Name: REGLER_MONTANT; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."REGLER_MONTANT" (
    "ID" integer NOT NULL,
    "DATE" date,
    "MONTANT" bigint DEFAULT 0,
    "ID_ECHEANCE_FOURNISSEUR" integer DEFAULT 1,
    "ID_MODE_REGLEMENT" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "ID_FOURNISSEUR" integer DEFAULT 1,
    "NOM" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ID_MOUVEMENT" integer DEFAULT 1
);


ALTER TABLE "Default"."REGLER_MONTANT" OWNER TO openconcerto;

--
-- TOC entry 625 (class 1259 OID 6911880)
-- Name: REGLER_MONTANT_ELEMENT; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."REGLER_MONTANT_ELEMENT" (
    "ID" integer NOT NULL,
    "ID_ECHEANCE_FOURNISSEUR" integer DEFAULT 1,
    "ID_REGLER_MONTANT" integer DEFAULT 1,
    "ID_MOUVEMENT_ECHEANCE" integer DEFAULT 1,
    "DATE" date,
    "MONTANT_REGLE" bigint DEFAULT 0,
    "MONTANT_A_REGLER" bigint DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "Default"."REGLER_MONTANT_ELEMENT" OWNER TO openconcerto;

--
-- TOC entry 626 (class 1259 OID 6911890)
-- Name: REGLER_MONTANT_ELEMENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."REGLER_MONTANT_ELEMENT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."REGLER_MONTANT_ELEMENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24731 (class 0 OID 0)
-- Dependencies: 626
-- Name: REGLER_MONTANT_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."REGLER_MONTANT_ELEMENT_ID_seq" OWNED BY "Default"."REGLER_MONTANT_ELEMENT"."ID";


--
-- TOC entry 627 (class 1259 OID 6911892)
-- Name: REGLER_MONTANT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."REGLER_MONTANT_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."REGLER_MONTANT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24732 (class 0 OID 0)
-- Dependencies: 627
-- Name: REGLER_MONTANT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."REGLER_MONTANT_ID_seq" OWNED BY "Default"."REGLER_MONTANT"."ID";


--
-- TOC entry 628 (class 1259 OID 6911894)
-- Name: RELANCE; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."RELANCE" (
    "ID" integer NOT NULL,
    "DATE" date,
    "ID_TYPE_LETTRE_RELANCE" integer DEFAULT 1,
    "ID_CLIENT" integer DEFAULT 1,
    "MONTANT" bigint DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "INFOS" character varying(2048) DEFAULT ''::text,
    "ID_SAISIE_VENTE_FACTURE" integer DEFAULT 1,
    "NUMERO" character varying(45) DEFAULT ''::character varying,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "ID_ECHEANCE_CLIENT" integer DEFAULT 1
);


ALTER TABLE "Default"."RELANCE" OWNER TO openconcerto;

--
-- TOC entry 629 (class 1259 OID 6911910)
-- Name: RELANCE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."RELANCE_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."RELANCE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24733 (class 0 OID 0)
-- Dependencies: 629
-- Name: RELANCE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."RELANCE_ID_seq" OWNED BY "Default"."RELANCE"."ID";


--
-- TOC entry 1479 (class 1259 OID 6941483)
-- Name: RELEVE_BANCAIRE; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."RELEVE_BANCAIRE" (
    "ID" integer NOT NULL,
    "ID_BANQUE" integer DEFAULT 1,
    "LABEL" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ANNEE" integer DEFAULT 0 NOT NULL,
    "MOIS" integer DEFAULT 1 NOT NULL,
    "DEBIT" numeric(16,8) DEFAULT 0 NOT NULL,
    "CREDIT" numeric(16,8) DEFAULT 0 NOT NULL,
    "SOLDE_FIN_DE_MOIS" numeric(16,8),
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8)
);


ALTER TABLE "Default"."RELEVE_BANCAIRE" OWNER TO openconcerto;

--
-- TOC entry 1481 (class 1259 OID 6941506)
-- Name: RELEVE_BANCAIRE_ELEMENT; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."RELEVE_BANCAIRE_ELEMENT" (
    "ID" integer NOT NULL,
    "ID_RELEVE_BANCAIRE" integer,
    "UUID" character varying(60) DEFAULT ''::character varying NOT NULL,
    "HASH" character varying(128) DEFAULT ''::character varying NOT NULL,
    "TYPE" character varying(20) DEFAULT ''::character varying NOT NULL,
    "NAME" character varying(128) DEFAULT ''::character varying NOT NULL,
    "DESCRIPTION" character varying(256) DEFAULT ''::character varying NOT NULL,
    "COMMENT" character varying(256) DEFAULT ''::character varying NOT NULL,
    "MONTANT" numeric(16,8) DEFAULT 0 NOT NULL,
    "DATE" timestamp without time zone,
    "DATE_VALEUR" timestamp without time zone,
    "POINTE" boolean DEFAULT false NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8)
);


ALTER TABLE "Default"."RELEVE_BANCAIRE_ELEMENT" OWNER TO openconcerto;

--
-- TOC entry 1480 (class 1259 OID 6941504)
-- Name: RELEVE_BANCAIRE_ELEMENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."RELEVE_BANCAIRE_ELEMENT_ID_seq"
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."RELEVE_BANCAIRE_ELEMENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24734 (class 0 OID 0)
-- Dependencies: 1480
-- Name: RELEVE_BANCAIRE_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."RELEVE_BANCAIRE_ELEMENT_ID_seq" OWNED BY "Default"."RELEVE_BANCAIRE_ELEMENT"."ID";


--
-- TOC entry 1478 (class 1259 OID 6941481)
-- Name: RELEVE_BANCAIRE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."RELEVE_BANCAIRE_ID_seq"
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."RELEVE_BANCAIRE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24735 (class 0 OID 0)
-- Dependencies: 1478
-- Name: RELEVE_BANCAIRE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."RELEVE_BANCAIRE_ID_seq" OWNED BY "Default"."RELEVE_BANCAIRE"."ID";


--
-- TOC entry 630 (class 1259 OID 6911912)
-- Name: REPARTITION_ANALYTIQUE; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."REPARTITION_ANALYTIQUE" (
    "ID" integer NOT NULL,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "NOM" character varying(2048) DEFAULT ''::text,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."REPARTITION_ANALYTIQUE" OWNER TO openconcerto;

--
-- TOC entry 631 (class 1259 OID 6911922)
-- Name: REPARTITION_ANALYTIQUE_ELEMENT; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."REPARTITION_ANALYTIQUE_ELEMENT" (
    "ID" integer NOT NULL,
    "ID_REPARTITION_ANALYTIQUE" integer DEFAULT 1,
    "ID_POSTE_ANALYTIQUE" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "TAUX" real DEFAULT 0,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."REPARTITION_ANALYTIQUE_ELEMENT" OWNER TO openconcerto;

--
-- TOC entry 632 (class 1259 OID 6911931)
-- Name: REPARTITION_ANALYTIQUE_ELEMENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."REPARTITION_ANALYTIQUE_ELEMENT_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."REPARTITION_ANALYTIQUE_ELEMENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24736 (class 0 OID 0)
-- Dependencies: 632
-- Name: REPARTITION_ANALYTIQUE_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."REPARTITION_ANALYTIQUE_ELEMENT_ID_seq" OWNED BY "Default"."REPARTITION_ANALYTIQUE_ELEMENT"."ID";


--
-- TOC entry 633 (class 1259 OID 6911933)
-- Name: REPARTITION_ANALYTIQUE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."REPARTITION_ANALYTIQUE_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."REPARTITION_ANALYTIQUE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24737 (class 0 OID 0)
-- Dependencies: 633
-- Name: REPARTITION_ANALYTIQUE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."REPARTITION_ANALYTIQUE_ID_seq" OWNED BY "Default"."REPARTITION_ANALYTIQUE"."ID";


--
-- TOC entry 634 (class 1259 OID 6911935)
-- Name: REPRISE_TRAVAIL; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."REPRISE_TRAVAIL" (
    "ID" integer NOT NULL,
    "ID_SALARIE" integer DEFAULT 1,
    "DATE_DERNIER_JOUR_TRAV" timestamp without time zone,
    "DATE_FIN_PREV" timestamp without time zone,
    "SUBROGATION" boolean DEFAULT false NOT NULL,
    "DATE_DEBUT_SUBROGATION" timestamp without time zone,
    "DATE_FIN_SUBROGATION" timestamp without time zone,
    "ID_MOTIF_ARRET_TRAVAIL" integer DEFAULT 1,
    "ID_MOTIF_REPRISE_ARRET_TRAVAIL" integer DEFAULT 1,
    "DATE_REPRISE" timestamp without time zone,
    "DATE_ACCIDENT" timestamp without time zone,
    "DATE" timestamp without time zone,
    "COMMENTAIRES" character varying(2048) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "Default"."REPRISE_TRAVAIL" OWNER TO openconcerto;

--
-- TOC entry 635 (class 1259 OID 6911948)
-- Name: REPRISE_TRAVAIL_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."REPRISE_TRAVAIL_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."REPRISE_TRAVAIL_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24738 (class 0 OID 0)
-- Dependencies: 635
-- Name: REPRISE_TRAVAIL_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."REPRISE_TRAVAIL_ID_seq" OWNED BY "Default"."REPRISE_TRAVAIL"."ID";


--
-- TOC entry 636 (class 1259 OID 6911950)
-- Name: SAISIE_ACHAT; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."SAISIE_ACHAT" (
    "ID" integer NOT NULL,
    "DATE" date,
    "NOM" character varying(2048) DEFAULT ''::text,
    "MONTANT_TTC" bigint DEFAULT 0,
    "ID_TAXE" integer DEFAULT 1,
    "ID_MODE_REGLEMENT" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "NUMERO_COMMANDE" character varying(2048) DEFAULT ''::text,
    "NUMERO_FACTURE" character varying(2048) DEFAULT ''::text,
    "ID_FOURNISSEUR" integer DEFAULT 1,
    "ID_MOUVEMENT" integer DEFAULT 1,
    "INFOS" character varying(2048) DEFAULT ''::text,
    "MONTANT_HT" bigint DEFAULT 0,
    "MONTANT_TVA" bigint DEFAULT 0,
    "IDSOURCE" integer DEFAULT 1,
    "SOURCE" character varying(45) DEFAULT ''::character varying,
    "ID_COMPTE_PCE" integer DEFAULT 1 NOT NULL,
    "ID_AVOIR_FOURNISSEUR" integer DEFAULT 1,
    "IMMO" boolean DEFAULT false,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."SAISIE_ACHAT" OWNER TO openconcerto;

--
-- TOC entry 637 (class 1259 OID 6911975)
-- Name: SAISIE_ACHAT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."SAISIE_ACHAT_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."SAISIE_ACHAT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24739 (class 0 OID 0)
-- Dependencies: 637
-- Name: SAISIE_ACHAT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."SAISIE_ACHAT_ID_seq" OWNED BY "Default"."SAISIE_ACHAT"."ID";


--
-- TOC entry 638 (class 1259 OID 6911977)
-- Name: SAISIE_KM; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."SAISIE_KM" (
    "ID" integer NOT NULL,
    "DATE" date,
    "NOM" character varying(2048) DEFAULT ''::text,
    "ID_JOURNAL" integer DEFAULT 1,
    "ID_MOUVEMENT" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."SAISIE_KM" OWNER TO openconcerto;

--
-- TOC entry 639 (class 1259 OID 6911989)
-- Name: SAISIE_KM_ELEMENT; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."SAISIE_KM_ELEMENT" (
    "ID_SAISIE_KM" integer DEFAULT 1,
    "ID" integer NOT NULL,
    "NUMERO" character varying(100) DEFAULT ''::character varying,
    "NOM" character varying(2048) DEFAULT ''::text,
    "NOM_ECRITURE" character varying(2048) DEFAULT ''::text,
    "DEBIT" bigint DEFAULT 0,
    "CREDIT" bigint DEFAULT 0,
    "ID_ECRITURE" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "NOM_PIECE" character varying(1024) DEFAULT ''::character varying NOT NULL,
    "ANALYTIQUE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "JOUR" integer DEFAULT 1 NOT NULL
);


ALTER TABLE "Default"."SAISIE_KM_ELEMENT" OWNER TO openconcerto;

--
-- TOC entry 640 (class 1259 OID 6912008)
-- Name: SAISIE_KM_ELEMENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."SAISIE_KM_ELEMENT_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."SAISIE_KM_ELEMENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24740 (class 0 OID 0)
-- Dependencies: 640
-- Name: SAISIE_KM_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."SAISIE_KM_ELEMENT_ID_seq" OWNED BY "Default"."SAISIE_KM_ELEMENT"."ID";


--
-- TOC entry 641 (class 1259 OID 6912010)
-- Name: SAISIE_KM_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."SAISIE_KM_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."SAISIE_KM_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24741 (class 0 OID 0)
-- Dependencies: 641
-- Name: SAISIE_KM_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."SAISIE_KM_ID_seq" OWNED BY "Default"."SAISIE_KM"."ID";


--
-- TOC entry 642 (class 1259 OID 6912012)
-- Name: SAISIE_VENTE_COMPTOIR; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."SAISIE_VENTE_COMPTOIR" (
    "ID" integer NOT NULL,
    "NOM" character varying(2048) DEFAULT ''::text,
    "ID_ARTICLE" integer DEFAULT 1,
    "DATE" date,
    "ID_CLIENT" integer DEFAULT 0,
    "MONTANT_TTC" bigint DEFAULT 0,
    "MONTANT_SERVICE" bigint DEFAULT 0,
    "ID_MODE_REGLEMENT" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "INFOS" character varying(2048) DEFAULT ''::text,
    "ID_FOURNISSEUR" integer DEFAULT 1,
    "ECHEANCE" integer DEFAULT 0,
    "ID_TAXE" integer DEFAULT 1,
    "ID_MOUVEMENT" integer DEFAULT 1,
    "ID_AVOIR_CLIENT" integer DEFAULT 1,
    "MONTANT_HT" bigint DEFAULT 0,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "ID_COMPTE_PCE_PRODUIT" integer DEFAULT 1,
    "ID_COMPTE_PCE_SERVICE" integer DEFAULT 1
);


ALTER TABLE "Default"."SAISIE_VENTE_COMPTOIR" OWNER TO openconcerto;

--
-- TOC entry 643 (class 1259 OID 6912036)
-- Name: SAISIE_VENTE_COMPTOIR_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."SAISIE_VENTE_COMPTOIR_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."SAISIE_VENTE_COMPTOIR_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24742 (class 0 OID 0)
-- Dependencies: 643
-- Name: SAISIE_VENTE_COMPTOIR_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."SAISIE_VENTE_COMPTOIR_ID_seq" OWNED BY "Default"."SAISIE_VENTE_COMPTOIR"."ID";


--
-- TOC entry 644 (class 1259 OID 6912038)
-- Name: SAISIE_VENTE_FACTURE; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."SAISIE_VENTE_FACTURE" (
    "ID_DEVIS" integer DEFAULT 1,
    "ID" integer NOT NULL,
    "NOM" character varying(250) DEFAULT ''::character varying,
    "DATE" date,
    "ID_COMMERCIAL" integer DEFAULT 1,
    "ID_CLIENT" integer DEFAULT 1,
    "T_HT" bigint DEFAULT 0,
    "T_TVA" bigint DEFAULT 0,
    "T_TTC" bigint DEFAULT 0,
    "PORT_HT" bigint DEFAULT 0,
    "REMISE_HT" bigint DEFAULT 0,
    "ID_TAXE" integer DEFAULT 1,
    "ID_MOUVEMENT" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID_MODE_REGLEMENT" integer DEFAULT 1,
    "T_SERVICE" bigint DEFAULT 0,
    "NUMERO" character varying(45) DEFAULT ''::character varying,
    "INFOS" character varying(2048) DEFAULT ''::text,
    "T_POIDS" real DEFAULT 0,
    "PREVISIONNELLE" boolean DEFAULT false NOT NULL,
    "COMPLEMENT" boolean DEFAULT false NOT NULL,
    "ID_AVOIR_CLIENT" integer DEFAULT 1,
    "ID_COMPTE_PCE_SERVICE" integer DEFAULT 1,
    "DATE_ENVOI" timestamp without time zone,
    "DATE_REGLEMENT" timestamp without time zone,
    "ACOMPTE" boolean DEFAULT false,
    "POURCENT_ACOMPTE" real DEFAULT 0,
    "ENVOYE_EN_AFFACTURAGE" boolean DEFAULT false,
    "DATE_ENVOI_AFFACTURAGE" date,
    "AFFACTURAGE" boolean DEFAULT false,
    "ID_CONTACT" integer DEFAULT 1,
    "TYPE_INTERVENTION" character varying(2048) DEFAULT ''::text,
    "ID_REFERENCE_CLIENT" integer DEFAULT 1,
    "COMPTE_SERVICE_AUTO" boolean DEFAULT false,
    "T_AVOIR_TTC" bigint DEFAULT 0,
    "REF_CLIENT" character varying(256) DEFAULT ''::character varying NOT NULL,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "T_HA" bigint DEFAULT 0,
    "ID_ADRESSE" integer DEFAULT 1,
    "ID_COMPTE_PCE_VENTE" integer DEFAULT 1,
    "ID_MOIS_CCIP" integer DEFAULT 1,
    "RETOUR_NATEXIS" boolean DEFAULT false,
    "CONTROLE_TECHNIQUE" boolean DEFAULT false,
    "T_DEVISE" bigint DEFAULT 0,
    "ID_TARIF" integer DEFAULT 1,
    "ID_MODELE" integer DEFAULT 1,
    "ID_TAXE_PORT" integer DEFAULT 1,
    "POURCENT_FACTURABLE" numeric(16,8),
    "MONTANT_FACTURABLE" numeric(16,8),
    "SOLDE" boolean DEFAULT false,
    "PARTIAL" boolean DEFAULT false,
    "ID_ADRESSE_LIVRAISON" integer DEFAULT 1,
    "POURCENT_REMISE" numeric(12,8),
    "MONTANT_REMISE" numeric(16,8),
    "ID_CLIENT_DEPARTEMENT" integer DEFAULT 1,
    "CREATE_VIRTUAL_STOCK" boolean DEFAULT true NOT NULL,
    "SOUMIS_TIMBRE_FISCAL" boolean DEFAULT false,
    "TAUX_TIMBRE_FISCAL" numeric(16,4) DEFAULT 1,
    "TOTAL_TIMBRE_FISCAL" bigint DEFAULT 0,
    "NET_A_PAYER" bigint DEFAULT 0,
    "T_ECO_CONTRIBUTION" bigint DEFAULT 0,
    "T_ACOMPTE" bigint DEFAULT 0 NOT NULL,
    "ATTACHMENTS" integer DEFAULT 0 NOT NULL,
    "ID_SDD_MESSAGE" integer,
    "SDD_EndToEndId" character varying(35) DEFAULT ''::character varying NOT NULL,
    "FRAIS_DOCUMENT_HT" bigint DEFAULT 0 NOT NULL,
    "ID_TAXE_FRAIS_DOCUMENT" integer DEFAULT 1,
    "ID_CATEGORIE_COMPTABLE" integer DEFAULT 1,
    "ID_FACTURATION_COMMANDE_CLIENT" integer DEFAULT 1,
    "POURCENT_RG" numeric(6,2) DEFAULT 0,
    "MONTANT_INTERFEL_HT" bigint DEFAULT 0 NOT NULL
);


ALTER TABLE "Default"."SAISIE_VENTE_FACTURE" OWNER TO openconcerto;

--
-- TOC entry 645 (class 1259 OID 6912105)
-- Name: SAISIE_VENTE_FACTURE_ELEMENT; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."SAISIE_VENTE_FACTURE_ELEMENT" (
    "LIVREE" boolean DEFAULT false,
    "QTE_LIVREE" integer DEFAULT 0,
    "ID" integer NOT NULL,
    "ID_STYLE" integer DEFAULT 1,
    "CODE" character varying(45) DEFAULT ''::character varying,
    "NOM" character varying(2048) DEFAULT ''::text,
    "PV_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "ID_TAXE" integer DEFAULT 1,
    "POIDS" real DEFAULT 0,
    "QTE" integer DEFAULT 0,
    "ID_SAISIE_VENTE_FACTURE" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "SERVICE" boolean DEFAULT false,
    "PRIX_METRIQUE_HA_1" numeric(16,6) DEFAULT 0 NOT NULL,
    "PRIX_METRIQUE_VT_1" numeric(16,6) DEFAULT 0 NOT NULL,
    "VALEUR_METRIQUE_1" real DEFAULT 0,
    "ID_METRIQUE_1" integer DEFAULT 1,
    "PRIX_METRIQUE_HA_2" numeric(16,6) DEFAULT 0 NOT NULL,
    "PRIX_METRIQUE_VT_2" numeric(16,6) DEFAULT 0 NOT NULL,
    "VALEUR_METRIQUE_2" real DEFAULT 0,
    "ID_METRIQUE_2" integer DEFAULT 1,
    "PRIX_METRIQUE_HA_3" numeric(16,6) DEFAULT 0 NOT NULL,
    "PRIX_METRIQUE_VT_3" numeric(16,6) DEFAULT 0 NOT NULL,
    "VALEUR_METRIQUE_3" real DEFAULT 0,
    "ID_METRIQUE_3" integer DEFAULT 1,
    "PA_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "T_POIDS" real DEFAULT 0,
    "T_PA_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "T_PV_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "T_PV_TTC" numeric(16,2) DEFAULT 0 NOT NULL,
    "ID_MODE_VENTE_ARTICLE" integer DEFAULT 1 NOT NULL,
    "CODE_MISSION" character varying(45) DEFAULT ''::character varying,
    "NOM_MISSION" character varying(256) DEFAULT ''::character varying,
    "ACTIVITE" character varying(45) DEFAULT ''::character varying,
    "SOUS_ACTIVITE" character varying(45) DEFAULT ''::character varying,
    "INDICE_0" bigint DEFAULT 0,
    "INDICE_N" bigint DEFAULT 0,
    "MONTANT_INITIAL" numeric(16,6) DEFAULT 0 NOT NULL,
    "REFERENTIEL_INSPECTION" character varying(2048) DEFAULT ''::text,
    "OBJET_INSPECTE" character varying(2048) DEFAULT ''::text,
    "INFOS_OBJET_INSPECTE" character varying(2048) DEFAULT ''::text,
    "LOCAL_OBJET_INSPECTE" character varying(2048) DEFAULT ''::text,
    "Q18" boolean DEFAULT false,
    "TARIF_Q18_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "MONTANT_REVISABLE" boolean DEFAULT false,
    "POURCENT_SERVICE" character varying(2048) DEFAULT ''::text,
    "DATE" date,
    "ID_CONTACT" integer DEFAULT 1,
    "DATE_FIN" timestamp without time zone,
    "POURCENT_CCIP" character varying(256) DEFAULT ''::character varying NOT NULL,
    "SITUATION_ADMIN" character varying(2048) DEFAULT ''::text,
    "ACOMPTE" boolean DEFAULT false,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "POURCENT_REMISE" numeric(12,8) DEFAULT 0,
    "POURCENT_ACOMPTE" numeric(6,2) DEFAULT 100 NOT NULL,
    "REPARTITION_POURCENT" numeric(6,2) DEFAULT 0 NOT NULL,
    "ID_TICKET_CAISSE" integer DEFAULT 1,
    "QTE_ACHAT" integer DEFAULT 1,
    "CODE_DOUANIER" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ID_PAYS" integer DEFAULT 1,
    "ID_DEVISE" integer DEFAULT 1,
    "PV_U_DEVISE" numeric(16,6) DEFAULT 0 NOT NULL,
    "PV_T_DEVISE" numeric(16,6) DEFAULT 0 NOT NULL,
    "TAUX_DEVISE" numeric(16,8) DEFAULT 1,
    "DESCRIPTIF" character varying(2048) DEFAULT ''::character varying NOT NULL,
    "MARGE_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "QTE_UNITAIRE" numeric(16,6) DEFAULT 1,
    "ID_UNITE_VENTE" integer DEFAULT 2,
    "ID_ARTICLE" integer DEFAULT 1,
    "POIDS_COLIS_NET" numeric(16,8) DEFAULT 0,
    "T_POIDS_COLIS_NET" numeric(16,8) DEFAULT 0,
    "NB_COLIS" integer DEFAULT 0,
    "MONTANT_FACTURABLE" numeric(16,8),
    "POURCENT_FACTURABLE" numeric(16,8),
    "MONTANT_REMISE" numeric(16,8),
    "ID_FAMILLE_ARTICLE" integer DEFAULT 1,
    "NIVEAU" integer DEFAULT 1 NOT NULL,
    "ID_ECO_CONTRIBUTION" integer DEFAULT 1,
    "ECO_CONTRIBUTION" numeric(16,2) DEFAULT 0,
    "T_ECO_CONTRIBUTION" numeric(16,2) DEFAULT 0,
    "ID_COMMANDE_CLIENT_ELEMENT" integer DEFAULT 1,
    "ID_DEPOT_STOCK" integer DEFAULT 1,
    "LONGUEUR" numeric(16,8),
    "LARGEUR" numeric(16,8),
    "HAUTEUR" numeric(16,8),
    "TARE" numeric(16,8),
    "T_POIDS_BRUT" numeric(16,8) DEFAULT 0,
    "ID_ARTICLE_DECLINAISON_TAILLE" integer DEFAULT 1,
    "ID_ARTICLE_DECLINAISON_COULEUR" integer DEFAULT 1
);


ALTER TABLE "Default"."SAISIE_VENTE_FACTURE_ELEMENT" OWNER TO openconcerto;

--
-- TOC entry 646 (class 1259 OID 6912191)
-- Name: SAISIE_VENTE_FACTURE_ELEMENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."SAISIE_VENTE_FACTURE_ELEMENT_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."SAISIE_VENTE_FACTURE_ELEMENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24743 (class 0 OID 0)
-- Dependencies: 646
-- Name: SAISIE_VENTE_FACTURE_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."SAISIE_VENTE_FACTURE_ELEMENT_ID_seq" OWNED BY "Default"."SAISIE_VENTE_FACTURE_ELEMENT"."ID";


--
-- TOC entry 647 (class 1259 OID 6912193)
-- Name: SAISIE_VENTE_FACTURE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."SAISIE_VENTE_FACTURE_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."SAISIE_VENTE_FACTURE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24744 (class 0 OID 0)
-- Dependencies: 647
-- Name: SAISIE_VENTE_FACTURE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."SAISIE_VENTE_FACTURE_ID_seq" OWNED BY "Default"."SAISIE_VENTE_FACTURE"."ID";


--
-- TOC entry 648 (class 1259 OID 6912195)
-- Name: SALARIE; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."SALARIE" (
    "ID" integer NOT NULL,
    "CODE" character varying(45) DEFAULT ''::character varying,
    "ID_TITRE_PERSONNEL" integer DEFAULT 1,
    "NOM" character varying(45) DEFAULT ''::character varying,
    "PRENOM" character varying(45) DEFAULT ''::character varying,
    "NOM_JEUNE_FILLE" character varying(45) DEFAULT ''::character varying,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID_ETAT_CIVIL" integer DEFAULT 1,
    "ID_REGLEMENT_PAYE" integer DEFAULT 1,
    "ID_INFOS_SALARIE_PAYE" integer DEFAULT 1,
    "ID_FICHE_PAYE" integer DEFAULT 1,
    "ID_CUMULS_PAYE" integer DEFAULT 1,
    "DERNIER_MOIS" integer DEFAULT 0,
    "DERNIERE_ANNEE" integer DEFAULT 0,
    "ID_CUMULS_CONGES" integer DEFAULT 1,
    "ID_VARIABLE_SALARIE" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "ATTACHMENTS" integer DEFAULT 0 NOT NULL,
    "ID_PAS" integer DEFAULT 1,
    "ID_USER_COMMON" integer DEFAULT 1
);


ALTER TABLE "Default"."SALARIE" OWNER TO openconcerto;

--
-- TOC entry 649 (class 1259 OID 6912218)
-- Name: SALARIE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."SALARIE_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."SALARIE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24745 (class 0 OID 0)
-- Dependencies: 649
-- Name: SALARIE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."SALARIE_ID_seq" OWNED BY "Default"."SALARIE"."ID";


--
-- TOC entry 650 (class 1259 OID 6912220)
-- Name: SEPA_DIRECT_DEBIT_MESSAGE; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."SEPA_DIRECT_DEBIT_MESSAGE" (
    "ID" integer NOT NULL,
    "MessageIdentification" character varying(35) DEFAULT ''::character varying NOT NULL,
    "CreationDateTime" timestamp without time zone NOT NULL,
    "NumberOfTransactions" integer DEFAULT 0 NOT NULL,
    "ControlSum" numeric(16,6) DEFAULT 0 NOT NULL,
    "XML" text NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8)
);


ALTER TABLE "Default"."SEPA_DIRECT_DEBIT_MESSAGE" OWNER TO openconcerto;

--
-- TOC entry 651 (class 1259 OID 6912230)
-- Name: SEPA_DIRECT_DEBIT_MESSAGE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."SEPA_DIRECT_DEBIT_MESSAGE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."SEPA_DIRECT_DEBIT_MESSAGE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24746 (class 0 OID 0)
-- Dependencies: 651
-- Name: SEPA_DIRECT_DEBIT_MESSAGE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."SEPA_DIRECT_DEBIT_MESSAGE_ID_seq" OWNED BY "Default"."SEPA_DIRECT_DEBIT_MESSAGE"."ID";


--
-- TOC entry 652 (class 1259 OID 6912232)
-- Name: SEPA_MANDATE; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."SEPA_MANDATE" (
    "ID" integer NOT NULL,
    "ID_CLIENT" integer DEFAULT 1,
    "MandateIdentification" character varying(35) DEFAULT ''::character varying NOT NULL,
    "DateOfSignature" date,
    "SequenceType" character varying(8) DEFAULT ''::character varying NOT NULL,
    "ACTIVE" boolean DEFAULT true NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8)
);


ALTER TABLE "Default"."SEPA_MANDATE" OWNER TO openconcerto;

--
-- TOC entry 653 (class 1259 OID 6912240)
-- Name: SEPA_MANDATE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."SEPA_MANDATE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."SEPA_MANDATE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24747 (class 0 OID 0)
-- Dependencies: 653
-- Name: SEPA_MANDATE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."SEPA_MANDATE_ID_seq" OWNED BY "Default"."SEPA_MANDATE"."ID";


--
-- TOC entry 654 (class 1259 OID 6912242)
-- Name: SITUATION_FAMILIALE; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."SITUATION_FAMILIALE" (
    "ID" integer NOT NULL,
    "NOM" character varying(45) DEFAULT ''::character varying,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "CODE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."SITUATION_FAMILIALE" OWNER TO openconcerto;

--
-- TOC entry 655 (class 1259 OID 6912250)
-- Name: SITUATION_FAMILIALE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."SITUATION_FAMILIALE_ID_seq"
    START WITH 7
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."SITUATION_FAMILIALE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24748 (class 0 OID 0)
-- Dependencies: 655
-- Name: SITUATION_FAMILIALE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."SITUATION_FAMILIALE_ID_seq" OWNED BY "Default"."SITUATION_FAMILIALE"."ID";


--
-- TOC entry 656 (class 1259 OID 6912252)
-- Name: STOCK; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."STOCK" (
    "ID" integer NOT NULL,
    "QTE_REEL" real DEFAULT 0,
    "QTE_TH" real DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "QTE_RECEPT_ATTENTE" real DEFAULT 0,
    "QTE_LIV_ATTENTE" real DEFAULT 0,
    "ID_DEPOT_STOCK" integer DEFAULT 1,
    "ID_ARTICLE" integer DEFAULT 1,
    "QTE_MIN" real DEFAULT 0
);


ALTER TABLE "Default"."STOCK" OWNER TO openconcerto;

--
-- TOC entry 657 (class 1259 OID 6912265)
-- Name: STOCK_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."STOCK_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."STOCK_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24749 (class 0 OID 0)
-- Dependencies: 657
-- Name: STOCK_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."STOCK_ID_seq" OWNED BY "Default"."STOCK"."ID";


--
-- TOC entry 658 (class 1259 OID 6912267)
-- Name: STYLE; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."STYLE" (
    "ID_STYLE" integer NOT NULL,
    "NOM" character varying(2048) DEFAULT ''::text,
    "CODE" character varying(2048) DEFAULT ''::text,
    "ARCHIVE" integer DEFAULT 0
);


ALTER TABLE "Default"."STYLE" OWNER TO openconcerto;

--
-- TOC entry 659 (class 1259 OID 6912276)
-- Name: STYLE_ID_STYLE_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."STYLE_ID_STYLE_seq"
    START WITH 5
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."STYLE_ID_STYLE_seq" OWNER TO openconcerto;

--
-- TOC entry 24750 (class 0 OID 0)
-- Dependencies: 659
-- Name: STYLE_ID_STYLE_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."STYLE_ID_STYLE_seq" OWNED BY "Default"."STYLE"."ID_STYLE";


--
-- TOC entry 660 (class 1259 OID 6912278)
-- Name: TARIF; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."TARIF" (
    "ID" integer NOT NULL,
    "NOM" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ID_DEVISE" integer DEFAULT 1,
    "ID_TAXE" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "Default"."TARIF" OWNER TO openconcerto;

--
-- TOC entry 661 (class 1259 OID 6912286)
-- Name: TARIF_ARTICLE_CLIENT; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."TARIF_ARTICLE_CLIENT" (
    "ID" integer NOT NULL,
    "ID_ARTICLE" integer DEFAULT 1,
    "ID_CLIENT" integer DEFAULT 1,
    "QUANTITE" numeric(16,3) DEFAULT 1 NOT NULL,
    "POURCENT_REMISE" numeric(16,3),
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8)
);


ALTER TABLE "Default"."TARIF_ARTICLE_CLIENT" OWNER TO openconcerto;

--
-- TOC entry 662 (class 1259 OID 6912293)
-- Name: TARIF_ARTICLE_CLIENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."TARIF_ARTICLE_CLIENT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."TARIF_ARTICLE_CLIENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24751 (class 0 OID 0)
-- Dependencies: 662
-- Name: TARIF_ARTICLE_CLIENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."TARIF_ARTICLE_CLIENT_ID_seq" OWNED BY "Default"."TARIF_ARTICLE_CLIENT"."ID";


--
-- TOC entry 663 (class 1259 OID 6912295)
-- Name: TARIF_FAMILLE_ARTICLE_CLIENT; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."TARIF_FAMILLE_ARTICLE_CLIENT" (
    "ID" integer NOT NULL,
    "ID_FAMILLE_ARTICLE" integer DEFAULT 1,
    "ID_CLIENT" integer DEFAULT 1,
    "QUANTITE" numeric(16,3) DEFAULT 1 NOT NULL,
    "POURCENT_REMISE" numeric(16,3),
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8)
);


ALTER TABLE "Default"."TARIF_FAMILLE_ARTICLE_CLIENT" OWNER TO openconcerto;

--
-- TOC entry 664 (class 1259 OID 6912302)
-- Name: TARIF_FAMILLE_ARTICLE_CLIENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."TARIF_FAMILLE_ARTICLE_CLIENT_ID_seq"
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."TARIF_FAMILLE_ARTICLE_CLIENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24752 (class 0 OID 0)
-- Dependencies: 664
-- Name: TARIF_FAMILLE_ARTICLE_CLIENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."TARIF_FAMILLE_ARTICLE_CLIENT_ID_seq" OWNED BY "Default"."TARIF_FAMILLE_ARTICLE_CLIENT"."ID";


--
-- TOC entry 665 (class 1259 OID 6912304)
-- Name: TARIF_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."TARIF_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."TARIF_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24753 (class 0 OID 0)
-- Dependencies: 665
-- Name: TARIF_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."TARIF_ID_seq" OWNED BY "Default"."TARIF"."ID";


--
-- TOC entry 666 (class 1259 OID 6912306)
-- Name: TARIF_PROMOTION; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."TARIF_PROMOTION" (
    "ID" integer NOT NULL,
    "NOM" character varying(256) DEFAULT ''::character varying NOT NULL,
    "START" date,
    "END" date,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8)
);


ALTER TABLE "Default"."TARIF_PROMOTION" OWNER TO openconcerto;

--
-- TOC entry 667 (class 1259 OID 6912311)
-- Name: TARIF_PROMOTION_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."TARIF_PROMOTION_ID_seq"
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."TARIF_PROMOTION_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24754 (class 0 OID 0)
-- Dependencies: 667
-- Name: TARIF_PROMOTION_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."TARIF_PROMOTION_ID_seq" OWNED BY "Default"."TARIF_PROMOTION"."ID";


--
-- TOC entry 668 (class 1259 OID 6912313)
-- Name: TARIF_QUANTITE; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."TARIF_QUANTITE" (
    "ID" integer NOT NULL,
    "ID_ARTICLE" integer DEFAULT 1,
    "QUANTITE" numeric(16,3) DEFAULT 1 NOT NULL,
    "POURCENT_REMISE" numeric(16,3),
    "PRIX_METRIQUE_VT_1" numeric(16,6),
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "Default"."TARIF_QUANTITE" OWNER TO openconcerto;

--
-- TOC entry 669 (class 1259 OID 6912320)
-- Name: TARIF_QUANTITE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."TARIF_QUANTITE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."TARIF_QUANTITE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24755 (class 0 OID 0)
-- Dependencies: 669
-- Name: TARIF_QUANTITE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."TARIF_QUANTITE_ID_seq" OWNED BY "Default"."TARIF_QUANTITE"."ID";


--
-- TOC entry 670 (class 1259 OID 6912322)
-- Name: TAXE; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."TAXE" (
    "ID_TAXE" integer NOT NULL,
    "NOM" character varying(2048) DEFAULT ''::text,
    "TAUX" real DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0,
    "CODE" character varying(2048) DEFAULT ''::text,
    "ID_COMPTE_PCE" integer DEFAULT 1,
    "ORDRE" numeric(16,8),
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "ID_COMPTE_PCE_DED" integer DEFAULT 1,
    "ID_COMPTE_PCE_COLLECTE" integer DEFAULT 1,
    "DEFAULT" boolean DEFAULT false,
    "ID_COMPTE_PCE_VENTE" integer DEFAULT 1,
    "ID_COMPTE_PCE_VENTE_SERVICE" integer DEFAULT 1,
    "ID_COMPTE_PCE_COLLECTE_INTRA" integer DEFAULT 1,
    "ID_COMPTE_PCE_DED_INTRA" integer DEFAULT 1,
    "DEFAULT_ACHAT" boolean DEFAULT false NOT NULL
);


ALTER TABLE "Default"."TAXE" OWNER TO openconcerto;

--
-- TOC entry 671 (class 1259 OID 6912343)
-- Name: TAXE_CATEGORIE_COMPTABLE; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."TAXE_CATEGORIE_COMPTABLE" (
    "ID" integer NOT NULL,
    "ID_CATEGORIE_COMPTABLE" integer DEFAULT 1,
    "ID_TAXE" integer DEFAULT 1,
    "ID_COMPTE_PCE_VENTE" integer DEFAULT 1,
    "ID_COMPTE_PCE_ACHAT" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8)
);


ALTER TABLE "Default"."TAXE_CATEGORIE_COMPTABLE" OWNER TO openconcerto;

--
-- TOC entry 672 (class 1259 OID 6912351)
-- Name: TAXE_CATEGORIE_COMPTABLE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."TAXE_CATEGORIE_COMPTABLE_ID_seq"
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."TAXE_CATEGORIE_COMPTABLE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24756 (class 0 OID 0)
-- Dependencies: 672
-- Name: TAXE_CATEGORIE_COMPTABLE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."TAXE_CATEGORIE_COMPTABLE_ID_seq" OWNED BY "Default"."TAXE_CATEGORIE_COMPTABLE"."ID";


--
-- TOC entry 673 (class 1259 OID 6912353)
-- Name: TAXE_COMPLEMENTAIRE; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."TAXE_COMPLEMENTAIRE" (
    "ID" integer NOT NULL,
    "ID_COMPTE_PCE_PRODUITS" integer DEFAULT 1,
    "ID_COMPTE_PCE" integer DEFAULT 1,
    "POURCENT" numeric(16,6) DEFAULT 0 NOT NULL,
    "CODE" character varying(25) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "Default"."TAXE_COMPLEMENTAIRE" OWNER TO openconcerto;

--
-- TOC entry 674 (class 1259 OID 6912363)
-- Name: TAXE_COMPLEMENTAIRE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."TAXE_COMPLEMENTAIRE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."TAXE_COMPLEMENTAIRE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24757 (class 0 OID 0)
-- Dependencies: 674
-- Name: TAXE_COMPLEMENTAIRE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."TAXE_COMPLEMENTAIRE_ID_seq" OWNED BY "Default"."TAXE_COMPLEMENTAIRE"."ID";


--
-- TOC entry 675 (class 1259 OID 6912365)
-- Name: TAXE_ID_TAXE_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."TAXE_ID_TAXE_seq"
    START WITH 6
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."TAXE_ID_TAXE_seq" OWNER TO openconcerto;

--
-- TOC entry 24758 (class 0 OID 0)
-- Dependencies: 675
-- Name: TAXE_ID_TAXE_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."TAXE_ID_TAXE_seq" OWNED BY "Default"."TAXE"."ID_TAXE";


--
-- TOC entry 1477 (class 1259 OID 6941300)
-- Name: TAXE_INTERFEL; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."TAXE_INTERFEL" (
    "ID" integer NOT NULL,
    "NOM" character varying(128) DEFAULT ''::character varying NOT NULL,
    "TAUX" numeric(16,6) DEFAULT 1 NOT NULL,
    "ID_COMPTE_PCE_PRODUITS" integer DEFAULT 1,
    "ID_COMPTE_PCE" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8)
);


ALTER TABLE "Default"."TAXE_INTERFEL" OWNER TO openconcerto;

--
-- TOC entry 1476 (class 1259 OID 6941298)
-- Name: TAXE_INTERFEL_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."TAXE_INTERFEL_ID_seq"
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."TAXE_INTERFEL_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24759 (class 0 OID 0)
-- Dependencies: 1476
-- Name: TAXE_INTERFEL_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."TAXE_INTERFEL_ID_seq" OWNED BY "Default"."TAXE_INTERFEL"."ID";


--
-- TOC entry 676 (class 1259 OID 6912367)
-- Name: TICKET_CAISSE; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."TICKET_CAISSE" (
    "ID" integer NOT NULL,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "ID_CLIENT" integer DEFAULT 1,
    "NOM" character varying(2048) DEFAULT ''::text,
    "DATE" timestamp without time zone,
    "ID_COMMERCIAL" integer DEFAULT 1,
    "NUMERO" character varying(2048) DEFAULT ''::text,
    "TOTAL_TTC" bigint DEFAULT 0,
    "TOTAL_TVA" bigint DEFAULT 0,
    "TOTAL_HT" bigint DEFAULT 0,
    "ID_CAISSE" integer DEFAULT 1,
    "ID_MOUVEMENT" integer DEFAULT 1,
    "FILE_HASH" character varying(128) DEFAULT NULL::character varying,
    "FILE_HASH_PREVIOUS" character varying(128) DEFAULT NULL::character varying
);


ALTER TABLE "Default"."TICKET_CAISSE" OWNER TO openconcerto;

--
-- TOC entry 677 (class 1259 OID 6912386)
-- Name: TICKET_CAISSE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."TICKET_CAISSE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."TICKET_CAISSE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24760 (class 0 OID 0)
-- Dependencies: 677
-- Name: TICKET_CAISSE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."TICKET_CAISSE_ID_seq" OWNED BY "Default"."TICKET_CAISSE"."ID";


--
-- TOC entry 678 (class 1259 OID 6912388)
-- Name: TITRE_PERSONNEL; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."TITRE_PERSONNEL" (
    "ID" integer NOT NULL,
    "NOM" character varying(45) DEFAULT ''::character varying,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "SEXE_M" boolean DEFAULT true,
    "CODE" character varying(8) DEFAULT ''::character varying,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "OBSOLETE" boolean DEFAULT false NOT NULL
);


ALTER TABLE "Default"."TITRE_PERSONNEL" OWNER TO openconcerto;

--
-- TOC entry 679 (class 1259 OID 6912398)
-- Name: TITRE_PERSONNEL_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."TITRE_PERSONNEL_ID_seq"
    START WITH 5
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."TITRE_PERSONNEL_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24761 (class 0 OID 0)
-- Dependencies: 679
-- Name: TITRE_PERSONNEL_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."TITRE_PERSONNEL_ID_seq" OWNED BY "Default"."TITRE_PERSONNEL"."ID";


--
-- TOC entry 680 (class 1259 OID 6912400)
-- Name: TRANSFERT_STOCK; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."TRANSFERT_STOCK" (
    "ID" integer NOT NULL,
    "DATE" timestamp without time zone,
    "ID_ARTICLE" integer DEFAULT 1,
    "ID_DEPOT_STOCK_SOURCE" integer DEFAULT 1,
    "ID_DEPOT_STOCK_DEST" integer DEFAULT 1,
    "QUANTITE" numeric(16,6) DEFAULT 1 NOT NULL,
    "NUMEROS_SERIE" character varying(50000) DEFAULT ''::character varying NOT NULL,
    "NUMEROS_LOT" character varying(50000) DEFAULT ''::character varying NOT NULL,
    "CONTEXTE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8)
);


ALTER TABLE "Default"."TRANSFERT_STOCK" OWNER TO openconcerto;

--
-- TOC entry 681 (class 1259 OID 6912414)
-- Name: TRANSFERT_STOCK_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."TRANSFERT_STOCK_ID_seq"
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."TRANSFERT_STOCK_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24762 (class 0 OID 0)
-- Dependencies: 681
-- Name: TRANSFERT_STOCK_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."TRANSFERT_STOCK_ID_seq" OWNED BY "Default"."TRANSFERT_STOCK"."ID";


--
-- TOC entry 682 (class 1259 OID 6912416)
-- Name: TR_BON_DE_LIVRAISON; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."TR_BON_DE_LIVRAISON" (
    "ID" integer NOT NULL,
    "ID_BON_DE_LIVRAISON" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric,
    "ID_SAISIE_VENTE_FACTURE" integer DEFAULT 1
);


ALTER TABLE "Default"."TR_BON_DE_LIVRAISON" OWNER TO openconcerto;

--
-- TOC entry 683 (class 1259 OID 6912423)
-- Name: TR_BON_DE_LIVRAISON_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."TR_BON_DE_LIVRAISON_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."TR_BON_DE_LIVRAISON_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24763 (class 0 OID 0)
-- Dependencies: 683
-- Name: TR_BON_DE_LIVRAISON_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."TR_BON_DE_LIVRAISON_ID_seq" OWNED BY "Default"."TR_BON_DE_LIVRAISON"."ID";


--
-- TOC entry 684 (class 1259 OID 6912425)
-- Name: TR_BON_RECEPTION; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."TR_BON_RECEPTION" (
    "ID" integer NOT NULL,
    "ID_BON_RECEPTION" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric,
    "ID_SAISIE_ACHAT" integer DEFAULT 1,
    "ID_FACTURE_FOURNISSEUR" integer DEFAULT 1
);


ALTER TABLE "Default"."TR_BON_RECEPTION" OWNER TO openconcerto;

--
-- TOC entry 685 (class 1259 OID 6912433)
-- Name: TR_BON_RECEPTION_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."TR_BON_RECEPTION_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."TR_BON_RECEPTION_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24764 (class 0 OID 0)
-- Dependencies: 685
-- Name: TR_BON_RECEPTION_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."TR_BON_RECEPTION_ID_seq" OWNED BY "Default"."TR_BON_RECEPTION"."ID";


--
-- TOC entry 686 (class 1259 OID 6912435)
-- Name: TR_COMMANDE; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."TR_COMMANDE" (
    "ID" integer NOT NULL,
    "ID_COMMANDE" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric,
    "ID_SAISIE_ACHAT" integer DEFAULT 1,
    "ID_BON_RECEPTION" integer DEFAULT 1,
    "ID_FACTURE_FOURNISSEUR" integer DEFAULT 1
);


ALTER TABLE "Default"."TR_COMMANDE" OWNER TO openconcerto;

--
-- TOC entry 687 (class 1259 OID 6912444)
-- Name: TR_COMMANDE_CLIENT; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."TR_COMMANDE_CLIENT" (
    "ID" integer NOT NULL,
    "ID_COMMANDE_CLIENT" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric,
    "ID_SAISIE_VENTE_FACTURE" integer DEFAULT 1,
    "ID_COMMANDE" integer DEFAULT 1,
    "ID_BON_DE_LIVRAISON" integer DEFAULT 1
);


ALTER TABLE "Default"."TR_COMMANDE_CLIENT" OWNER TO openconcerto;

--
-- TOC entry 688 (class 1259 OID 6912453)
-- Name: TR_COMMANDE_CLIENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."TR_COMMANDE_CLIENT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."TR_COMMANDE_CLIENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24765 (class 0 OID 0)
-- Dependencies: 688
-- Name: TR_COMMANDE_CLIENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."TR_COMMANDE_CLIENT_ID_seq" OWNED BY "Default"."TR_COMMANDE_CLIENT"."ID";


--
-- TOC entry 689 (class 1259 OID 6912455)
-- Name: TR_COMMANDE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."TR_COMMANDE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."TR_COMMANDE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24766 (class 0 OID 0)
-- Dependencies: 689
-- Name: TR_COMMANDE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."TR_COMMANDE_ID_seq" OWNED BY "Default"."TR_COMMANDE"."ID";


--
-- TOC entry 690 (class 1259 OID 6912457)
-- Name: TR_DEVIS; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."TR_DEVIS" (
    "ID" integer NOT NULL,
    "ID_DEVIS" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric,
    "ID_COMMANDE_CLIENT" integer DEFAULT 1,
    "ID_SAISIE_VENTE_FACTURE" integer DEFAULT 1,
    "ID_COMMANDE" integer DEFAULT 1,
    "ID_BON_DE_LIVRAISON" integer DEFAULT 1
);


ALTER TABLE "Default"."TR_DEVIS" OWNER TO openconcerto;

--
-- TOC entry 691 (class 1259 OID 6912467)
-- Name: TR_DEVIS_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."TR_DEVIS_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."TR_DEVIS_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24767 (class 0 OID 0)
-- Dependencies: 691
-- Name: TR_DEVIS_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."TR_DEVIS_ID_seq" OWNED BY "Default"."TR_DEVIS"."ID";


--
-- TOC entry 692 (class 1259 OID 6912469)
-- Name: TR_SAISIE_ACHAT; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."TR_SAISIE_ACHAT" (
    "ID" integer NOT NULL,
    "ID_SAISIE_ACHAT" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric,
    "ID_AVOIR_FOURNISSEUR" integer DEFAULT 1
);


ALTER TABLE "Default"."TR_SAISIE_ACHAT" OWNER TO openconcerto;

--
-- TOC entry 693 (class 1259 OID 6912476)
-- Name: TR_SAISIE_ACHAT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."TR_SAISIE_ACHAT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."TR_SAISIE_ACHAT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24768 (class 0 OID 0)
-- Dependencies: 693
-- Name: TR_SAISIE_ACHAT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."TR_SAISIE_ACHAT_ID_seq" OWNED BY "Default"."TR_SAISIE_ACHAT"."ID";


--
-- TOC entry 694 (class 1259 OID 6912478)
-- Name: TR_SAISIE_VENTE_FACTURE; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."TR_SAISIE_VENTE_FACTURE" (
    "ID" integer NOT NULL,
    "ID_SAISIE_VENTE_FACTURE" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric,
    "ID_AVOIR_CLIENT" integer DEFAULT 1,
    "ID_COMMANDE" integer DEFAULT 1,
    "ID_BON_DE_LIVRAISON" integer DEFAULT 1
);


ALTER TABLE "Default"."TR_SAISIE_VENTE_FACTURE" OWNER TO openconcerto;

--
-- TOC entry 695 (class 1259 OID 6912487)
-- Name: TR_SAISIE_VENTE_FACTURE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."TR_SAISIE_VENTE_FACTURE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."TR_SAISIE_VENTE_FACTURE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24769 (class 0 OID 0)
-- Dependencies: 695
-- Name: TR_SAISIE_VENTE_FACTURE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."TR_SAISIE_VENTE_FACTURE_ID_seq" OWNED BY "Default"."TR_SAISIE_VENTE_FACTURE"."ID";


--
-- TOC entry 696 (class 1259 OID 6912489)
-- Name: TYPE_COMPTE_PCG; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."TYPE_COMPTE_PCG" (
    "ID" integer NOT NULL,
    "RACINE" boolean DEFAULT false,
    "NOM" character varying(2048) DEFAULT ''::text
);


ALTER TABLE "Default"."TYPE_COMPTE_PCG" OWNER TO openconcerto;

--
-- TOC entry 697 (class 1259 OID 6912497)
-- Name: TYPE_COMPTE_PCG_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."TYPE_COMPTE_PCG_ID_seq"
    START WITH 8
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."TYPE_COMPTE_PCG_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24770 (class 0 OID 0)
-- Dependencies: 697
-- Name: TYPE_COMPTE_PCG_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."TYPE_COMPTE_PCG_ID_seq" OWNED BY "Default"."TYPE_COMPTE_PCG"."ID";


--
-- TOC entry 698 (class 1259 OID 6912499)
-- Name: TYPE_LETTRE_RELANCE; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."TYPE_LETTRE_RELANCE" (
    "ID" integer NOT NULL,
    "NOM" character varying(45) DEFAULT ''::character varying,
    "MODELE" character varying(2048) DEFAULT ''::text,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."TYPE_LETTRE_RELANCE" OWNER TO openconcerto;

--
-- TOC entry 699 (class 1259 OID 6912510)
-- Name: TYPE_LETTRE_RELANCE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."TYPE_LETTRE_RELANCE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."TYPE_LETTRE_RELANCE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24771 (class 0 OID 0)
-- Dependencies: 699
-- Name: TYPE_LETTRE_RELANCE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."TYPE_LETTRE_RELANCE_ID_seq" OWNED BY "Default"."TYPE_LETTRE_RELANCE"."ID";


--
-- TOC entry 700 (class 1259 OID 6912512)
-- Name: TYPE_REGLEMENT; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."TYPE_REGLEMENT" (
    "ID" integer NOT NULL,
    "NOM" character varying(2048) DEFAULT ''::text,
    "COMPTANT" boolean DEFAULT false,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID_COMPTE_PCE_CLIENT" integer DEFAULT 1,
    "ID_COMPTE_PCE_FOURN" integer DEFAULT 1,
    "ECHEANCE" boolean DEFAULT false,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "SEPA" boolean DEFAULT false NOT NULL
);


ALTER TABLE "Default"."TYPE_REGLEMENT" OWNER TO openconcerto;

--
-- TOC entry 701 (class 1259 OID 6912527)
-- Name: TYPE_REGLEMENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."TYPE_REGLEMENT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."TYPE_REGLEMENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24772 (class 0 OID 0)
-- Dependencies: 701
-- Name: TYPE_REGLEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."TYPE_REGLEMENT_ID_seq" OWNED BY "Default"."TYPE_REGLEMENT"."ID";


--
-- TOC entry 702 (class 1259 OID 6912529)
-- Name: UNITE_VENTE; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."UNITE_VENTE" (
    "ID" integer NOT NULL,
    "CODE" character varying(32) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(256) DEFAULT ''::character varying NOT NULL,
    "A_LA_PIECE" boolean DEFAULT false,
    "INFOS" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "Default"."UNITE_VENTE" OWNER TO openconcerto;

--
-- TOC entry 703 (class 1259 OID 6912541)
-- Name: UNITE_VENTE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."UNITE_VENTE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."UNITE_VENTE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24773 (class 0 OID 0)
-- Dependencies: 703
-- Name: UNITE_VENTE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."UNITE_VENTE_ID_seq" OWNED BY "Default"."UNITE_VENTE"."ID";


--
-- TOC entry 704 (class 1259 OID 6912543)
-- Name: VARIABLE_SALARIE; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."VARIABLE_SALARIE" (
    "ID" integer NOT NULL,
    "HEURE_ABS" real DEFAULT 0,
    "HEURE_110" real DEFAULT 0,
    "HEURE_125" real DEFAULT 0,
    "HEURE_150" real DEFAULT 0,
    "HEURE_200" real DEFAULT 0,
    "CONGES_PRIS" real DEFAULT 0,
    "HEURE_TRAV" real DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "HEURE_200_DEFAULT_VAL" real DEFAULT 0,
    "HEURE_ABS_DEFAULT_VAL" real DEFAULT 0,
    "HEURE_150_DEFAULT_VAL" real DEFAULT 0,
    "HEURE_110_DEFAULT_VAL" real DEFAULT 0,
    "HEURE_125_DEFAULT_VAL" real DEFAULT 0,
    "CONGES_PRIS_DEFAULT_VAL" real DEFAULT 0,
    "IJSS_BRUT" real DEFAULT 0,
    "IJSS_BRUT_DEFAULT_VAL" real DEFAULT 0,
    "IJSS_NET" real DEFAULT 0,
    "IJSS_NET_DEFAULT_VAL" real DEFAULT 0,
    "FRAIS_PRO" real DEFAULT 0,
    "FRAIS_PRO_DEFAULT_VAL" real DEFAULT 0,
    "RBT_TRANSPORT" real DEFAULT 0,
    "RBT_TRANSPORT_DEFAULT_VAL" real DEFAULT 0,
    "HEURE_125_CUMUL_VAL" real DEFAULT 0,
    "IJSS_BRUT_CUMUL_VAL" real DEFAULT 0,
    "HEURE_150_CUMUL_VAL" real DEFAULT 0,
    "HEURE_ABS_CUMUL_VAL" real DEFAULT 0,
    "HEURE_TRAV_CUMUL_VAL" real DEFAULT 0,
    "RBT_TRANSPORT_CUMUL_VAL" real DEFAULT 0,
    "FRAIS_PRO_CUMUL_VAL" real DEFAULT 0,
    "IJSS_NET_CUMUL_VAL" real DEFAULT 0,
    "CONGES_PRIS_CUMUL_VAL" real DEFAULT 0,
    "HEURE_110_CUMUL_VAL" real DEFAULT 0,
    "HEURE_200_CUMUL_VAL" real DEFAULT 0,
    "HEURE_CHOM" real DEFAULT 0,
    "HEURE_CHOM_DEFAULT_VAL" real DEFAULT 0,
    "HEURE_CHOM_CUMUL_VAL" real DEFAULT 0,
    "TAUX_CHOM" real DEFAULT 0,
    "TAUX_CHOM_DEFAULT_VAL" real DEFAULT 0,
    "TAUX_CHOM_CUMUL_VAL" real DEFAULT 0,
    "HEURE_INDEM" real DEFAULT 0,
    "HEURE_INDEM_DEFAULT_VAL" real DEFAULT 0,
    "HEURE_INDEM_CUMUL_VAL" real DEFAULT 0,
    "ECRETEMENT_CSG" real DEFAULT 0,
    "ECRETEMENT_CSG_DEFAULT_VAL" real DEFAULT 0,
    "ECRETEMENT_CSG_CUMUL_VAL" real DEFAULT 0,
    "IJSS_BRUT_SECU_PAS" real DEFAULT 0,
    "IJSS_BRUT_SECU_PAS_DEFAULT_VAL" real DEFAULT 0,
    "IJSS_BRUT_SECU_PAS_CUMUL_VAL" real DEFAULT 0
);


ALTER TABLE "Default"."VARIABLE_SALARIE" OWNER TO openconcerto;

--
-- TOC entry 705 (class 1259 OID 6912596)
-- Name: VARIABLE_SALARIE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."VARIABLE_SALARIE_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."VARIABLE_SALARIE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24774 (class 0 OID 0)
-- Dependencies: 705
-- Name: VARIABLE_SALARIE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."VARIABLE_SALARIE_ID_seq" OWNED BY "Default"."VARIABLE_SALARIE"."ID";


--
-- TOC entry 706 (class 1259 OID 6912598)
-- Name: VILLE; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."VILLE" (
    "ID" integer NOT NULL,
    "X_LAMBERT" bigint DEFAULT 0,
    "Y_LAMBERT" bigint DEFAULT 0,
    "POPULATION" bigint DEFAULT 0,
    "NOM" character varying(512) DEFAULT ''::character varying NOT NULL,
    "CODE_POSTAL" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "Default"."VILLE" OWNER TO openconcerto;

--
-- TOC entry 707 (class 1259 OID 6912611)
-- Name: VILLE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "Default"."VILLE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Default"."VILLE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24775 (class 0 OID 0)
-- Dependencies: 707
-- Name: VILLE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."VILLE_ID_seq" OWNED BY "Default"."VILLE"."ID";


--
-- TOC entry 708 (class 1259 OID 6912613)
-- Name: ACOMPTE; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."ACOMPTE" (
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "CREATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MONTANT" real DEFAULT 0,
    "ID_SALARIE" integer DEFAULT 1,
    "ID_MOUVEMENT" integer DEFAULT 1,
    "ORDRE" numeric(16,8),
    "ID" integer NOT NULL,
    "ARCHIVE" integer DEFAULT 0
);


ALTER TABLE "OpenConcerto42"."ACOMPTE" OWNER TO openconcerto;

--
-- TOC entry 709 (class 1259 OID 6912622)
-- Name: ACOMPTE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."ACOMPTE_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."ACOMPTE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24776 (class 0 OID 0)
-- Dependencies: 709
-- Name: ACOMPTE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."ACOMPTE_ID_seq" OWNED BY "OpenConcerto42"."ACOMPTE"."ID";


--
-- TOC entry 710 (class 1259 OID 6912624)
-- Name: ADRESSE; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."ADRESSE" (
    "MODIFICATION_DATE" timestamp without time zone,
    "CREATION_DATE" timestamp without time zone,
    "ORDRE" numeric(16,8),
    "ID_ADRESSE" integer NOT NULL,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "DEST" character varying(2048) DEFAULT ''::text,
    "ARCHIVE" integer DEFAULT 0,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CEDEX" integer,
    "RUE" character varying(2048) DEFAULT ''::text,
    "ID_CLIENT" integer DEFAULT 1,
    "HAS_CEDEX" boolean DEFAULT false,
    "VILLE" character varying(2048) DEFAULT ''::text,
    "PAYS" character varying(100) DEFAULT ''::character varying,
    "CODE_POSTAL" character varying(256) DEFAULT ''::character varying,
    "PROVINCE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "LIBELLE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "TYPE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "EMAIL_CONTACT" character varying(256) DEFAULT ''::character varying NOT NULL
);


ALTER TABLE "OpenConcerto42"."ADRESSE" OWNER TO openconcerto;

--
-- TOC entry 711 (class 1259 OID 6912644)
-- Name: ADRESSE_ID_ADRESSE_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."ADRESSE_ID_ADRESSE_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."ADRESSE_ID_ADRESSE_seq" OWNER TO openconcerto;

--
-- TOC entry 24777 (class 0 OID 0)
-- Dependencies: 711
-- Name: ADRESSE_ID_ADRESSE_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."ADRESSE_ID_ADRESSE_seq" OWNED BY "OpenConcerto42"."ADRESSE"."ID_ADRESSE";


--
-- TOC entry 712 (class 1259 OID 6912646)
-- Name: AGENCE; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."AGENCE" (
    "ID" integer NOT NULL,
    "DESIGNATION" character varying(256) DEFAULT ''::character varying NOT NULL,
    "TEL_1" character varying(256) DEFAULT ''::character varying NOT NULL,
    "EMAIL" character varying(256) DEFAULT ''::character varying NOT NULL,
    "FAX" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ID_CLIENT" integer DEFAULT 1,
    "ID_ADRESSE" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8)
);


ALTER TABLE "OpenConcerto42"."AGENCE" OWNER TO openconcerto;

--
-- TOC entry 713 (class 1259 OID 6912659)
-- Name: AGENCE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."AGENCE_ID_seq"
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."AGENCE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24778 (class 0 OID 0)
-- Dependencies: 713
-- Name: AGENCE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."AGENCE_ID_seq" OWNED BY "OpenConcerto42"."AGENCE"."ID";


--
-- TOC entry 714 (class 1259 OID 6912661)
-- Name: ARRET_CHOMAGE_INTEMPERIE; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."ARRET_CHOMAGE_INTEMPERIE" (
    "ID" integer NOT NULL,
    "ID_INFOS_SALARIE_PAYE" integer DEFAULT 1,
    "ID_CODE_AMENAGEMENT_PARTIEL" integer DEFAULT 1,
    "ID_CODE_SUSPENSION" integer DEFAULT 1,
    "DATE_DEBUT_SUSPENSION" date,
    "DATE_FIN_SUSPENSION" date,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8)
);


ALTER TABLE "OpenConcerto42"."ARRET_CHOMAGE_INTEMPERIE" OWNER TO openconcerto;

--
-- TOC entry 715 (class 1259 OID 6912668)
-- Name: ARRET_CHOMAGE_INTEMPERIE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."ARRET_CHOMAGE_INTEMPERIE_ID_seq"
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."ARRET_CHOMAGE_INTEMPERIE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24779 (class 0 OID 0)
-- Dependencies: 715
-- Name: ARRET_CHOMAGE_INTEMPERIE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."ARRET_CHOMAGE_INTEMPERIE_ID_seq" OWNED BY "OpenConcerto42"."ARRET_CHOMAGE_INTEMPERIE"."ID";


--
-- TOC entry 716 (class 1259 OID 6912670)
-- Name: ARRET_TRAVAIL; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."ARRET_TRAVAIL" (
    "ID" integer NOT NULL,
    "ID_SALARIE" integer DEFAULT 1,
    "DATE_DERNIER_JOUR_TRAV" timestamp without time zone,
    "DATE_FIN_PREV" timestamp without time zone,
    "SUBROGATION" boolean DEFAULT false NOT NULL,
    "DATE_DEBUT_SUBROGATION" timestamp without time zone,
    "DATE_FIN_SUBROGATION" timestamp without time zone,
    "ID_MOTIF_ARRET_TRAVAIL" integer DEFAULT 1,
    "ID_MOTIF_REPRISE_ARRET_TRAVAIL" integer DEFAULT 1,
    "DATE_REPRISE" timestamp without time zone,
    "DATE_ACCIDENT" timestamp without time zone,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric,
    "DATE" timestamp without time zone,
    "COMMENTAIRES" character varying(2048) DEFAULT ''::character varying NOT NULL
);


ALTER TABLE "OpenConcerto42"."ARRET_TRAVAIL" OWNER TO openconcerto;

--
-- TOC entry 717 (class 1259 OID 6912683)
-- Name: ARRET_TRAVAIL_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."ARRET_TRAVAIL_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."ARRET_TRAVAIL_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24780 (class 0 OID 0)
-- Dependencies: 717
-- Name: ARRET_TRAVAIL_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."ARRET_TRAVAIL_ID_seq" OWNED BY "OpenConcerto42"."ARRET_TRAVAIL"."ID";


--
-- TOC entry 718 (class 1259 OID 6912685)
-- Name: ARTICLE; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."ARTICLE" (
    "PRIX_METRIQUE_VT_1" numeric(16,6) DEFAULT 0 NOT NULL,
    "ARCHIVE" integer DEFAULT 0,
    "PV_TTC" numeric(16,2) DEFAULT 0 NOT NULL,
    "POIDS" real DEFAULT 0,
    "ID_METRIQUE_3" integer DEFAULT 1,
    "PRIX_METRIQUE_HA_2" numeric(16,6) DEFAULT 0 NOT NULL,
    "NOM" character varying(2048) DEFAULT ''::text,
    "CREATION_DATE" timestamp without time zone,
    "PRIX_METRIQUE_HA_3" numeric(16,6) DEFAULT 0 NOT NULL,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "PA_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "ID_TAXE" integer DEFAULT 1,
    "VALEUR_METRIQUE_2" real DEFAULT 0,
    "SERVICE" boolean DEFAULT false,
    "ID_METRIQUE_2" integer DEFAULT 1,
    "CREATION_AUTO" boolean DEFAULT false,
    "ORDRE" numeric(16,8),
    "PRIX_METRIQUE_HA_1" numeric(16,6) DEFAULT 0 NOT NULL,
    "ID_STOCK" integer DEFAULT 1,
    "ID_MODE_VENTE_ARTICLE" integer DEFAULT 1,
    "PV_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "PRIX_METRIQUE_VT_2" numeric(16,6) DEFAULT 0 NOT NULL,
    "ID_METRIQUE_1" integer DEFAULT 1,
    "VALEUR_METRIQUE_1" real DEFAULT 0,
    "VALEUR_METRIQUE_3" real DEFAULT 0,
    "ID" integer NOT NULL,
    "CODE" character varying(45) DEFAULT ''::text,
    "MODIFICATION_DATE" timestamp without time zone,
    "PRIX_METRIQUE_VT_3" numeric(16,6) DEFAULT 0 NOT NULL,
    "OBSOLETE" boolean DEFAULT false,
    "ID_FAMILLE_ARTICLE" integer DEFAULT 1,
    "INFOS" character varying(2048) DEFAULT ''::character varying NOT NULL,
    "QTE_ACHAT" integer DEFAULT 1,
    "DESCRIPTIF" character varying(2048) DEFAULT ''::character varying NOT NULL,
    "CODE_BARRE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "GESTION_STOCK" boolean DEFAULT true,
    "CODE_DOUANIER" character varying(256) DEFAULT ''::character varying NOT NULL,
    "QTE_MIN" integer DEFAULT 1,
    "ID_DEVISE" integer DEFAULT 1,
    "ID_FOURNISSEUR" integer DEFAULT 1,
    "PV_U_DEVISE" numeric(16,6) DEFAULT 0 NOT NULL,
    "ID_DEVISE_HA" integer DEFAULT 1,
    "PA_DEVISE" numeric(16,6) DEFAULT 0 NOT NULL,
    "ID_PAYS" integer DEFAULT 1,
    "ID_UNITE_VENTE" integer DEFAULT 2,
    "ID_COMPTE_PCE" integer DEFAULT 1,
    "ID_COMPTE_PCE_ACHAT" integer DEFAULT 1,
    "SKU" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ID_ECO_CONTRIBUTION" integer DEFAULT 1,
    "ID_TAXE_COMPLEMENTAIRE" integer DEFAULT 1,
    "ATTACHMENTS" integer DEFAULT 0 NOT NULL,
    "ID_FABRICANT" integer DEFAULT 1,
    "TARE" numeric(16,8) DEFAULT 0,
    "IFCO" integer DEFAULT 0 NOT NULL,
    "MASQUE_CAISSE" boolean DEFAULT false NOT NULL,
    "ADDITIONAL_TICKET_COPY" boolean DEFAULT false NOT NULL,
    "MATIERE" character varying(128) DEFAULT ''::character varying NOT NULL,
    "QTE_UNITAIRE" numeric(16,6) DEFAULT 1 NOT NULL,
    "ID_COUT_REVIENT" integer DEFAULT 1,
    "MARGE_WITH_COUT_REVIENT" boolean DEFAULT false NOT NULL,
    "AUTO_PRIX_ACHAT_NOMENCLATURE" boolean DEFAULT false NOT NULL,
    "ID_DEPOT_STOCK" integer DEFAULT 1,
    "DLC" date,
    "LONGUEUR" numeric(16,8),
    "LARGEUR" numeric(16,8),
    "HAUTEUR" numeric(16,8),
    "AUTO_PRIX_MIN_VENTE_NOMENCLATURE" boolean DEFAULT false NOT NULL,
    "DERNIER_DATE_ACHAT" date,
    "OPTION" boolean DEFAULT false NOT NULL,
    "VIRTUEL" boolean DEFAULT false NOT NULL,
    "ID_ARTICLE_VIRTUEL_PERE" integer DEFAULT 1,
    "ID_ARTICLE_DECLINAISON_TAILLE" integer DEFAULT 1,
    "ID_ARTICLE_DECLINAISON_COULEUR" integer DEFAULT 1,
    "NUMERO_LOT_REQUIS" boolean DEFAULT false NOT NULL,
    "NUMERO_SERIE_REQUIS" boolean DEFAULT false NOT NULL,
    "DLC_REQUIS" boolean DEFAULT false NOT NULL,
    "DLUO_REQUIS" boolean DEFAULT false NOT NULL,
    "ID_TAXE_INTERFEL" integer
);


ALTER TABLE "OpenConcerto42"."ARTICLE" OWNER TO openconcerto;

--
-- TOC entry 719 (class 1259 OID 6912760)
-- Name: ARTICLE_CATEGORIE_COMPTABLE; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."ARTICLE_CATEGORIE_COMPTABLE" (
    "ID" integer NOT NULL,
    "ID_CATEGORIE_COMPTABLE" integer DEFAULT 1,
    "ID_ARTICLE" integer DEFAULT 1,
    "ID_TAXE_ACHAT" integer DEFAULT 1,
    "ID_TAXE_VENTE" integer DEFAULT 1,
    "ID_COMPTE_PCE_VENTE" integer DEFAULT 1,
    "ID_COMPTE_PCE_ACHAT" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8)
);


ALTER TABLE "OpenConcerto42"."ARTICLE_CATEGORIE_COMPTABLE" OWNER TO openconcerto;

--
-- TOC entry 720 (class 1259 OID 6912770)
-- Name: ARTICLE_CATEGORIE_COMPTABLE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."ARTICLE_CATEGORIE_COMPTABLE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."ARTICLE_CATEGORIE_COMPTABLE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24781 (class 0 OID 0)
-- Dependencies: 720
-- Name: ARTICLE_CATEGORIE_COMPTABLE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."ARTICLE_CATEGORIE_COMPTABLE_ID_seq" OWNED BY "OpenConcerto42"."ARTICLE_CATEGORIE_COMPTABLE"."ID";


--
-- TOC entry 721 (class 1259 OID 6912772)
-- Name: ARTICLE_CODE_CLIENT; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."ARTICLE_CODE_CLIENT" (
    "ID" integer NOT NULL,
    "NOM" character varying(512) DEFAULT ''::character varying NOT NULL,
    "CODE" character varying(512) DEFAULT ''::character varying NOT NULL,
    "ID_CLIENT" integer DEFAULT 1,
    "ID_ARTICLE" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8)
);


ALTER TABLE "OpenConcerto42"."ARTICLE_CODE_CLIENT" OWNER TO openconcerto;

--
-- TOC entry 722 (class 1259 OID 6912783)
-- Name: ARTICLE_CODE_CLIENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."ARTICLE_CODE_CLIENT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."ARTICLE_CODE_CLIENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24782 (class 0 OID 0)
-- Dependencies: 722
-- Name: ARTICLE_CODE_CLIENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."ARTICLE_CODE_CLIENT_ID_seq" OWNED BY "OpenConcerto42"."ARTICLE_CODE_CLIENT"."ID";


--
-- TOC entry 723 (class 1259 OID 6912785)
-- Name: ARTICLE_DECLINAISON_COULEUR; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."ARTICLE_DECLINAISON_COULEUR" (
    "ID" integer NOT NULL,
    "NOM" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8)
);


ALTER TABLE "OpenConcerto42"."ARTICLE_DECLINAISON_COULEUR" OWNER TO openconcerto;

--
-- TOC entry 724 (class 1259 OID 6912790)
-- Name: ARTICLE_DECLINAISON_COULEUR_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."ARTICLE_DECLINAISON_COULEUR_ID_seq"
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."ARTICLE_DECLINAISON_COULEUR_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24783 (class 0 OID 0)
-- Dependencies: 724
-- Name: ARTICLE_DECLINAISON_COULEUR_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."ARTICLE_DECLINAISON_COULEUR_ID_seq" OWNED BY "OpenConcerto42"."ARTICLE_DECLINAISON_COULEUR"."ID";


--
-- TOC entry 725 (class 1259 OID 6912792)
-- Name: ARTICLE_DECLINAISON_TAILLE; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."ARTICLE_DECLINAISON_TAILLE" (
    "ID" integer NOT NULL,
    "NOM" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8)
);


ALTER TABLE "OpenConcerto42"."ARTICLE_DECLINAISON_TAILLE" OWNER TO openconcerto;

--
-- TOC entry 726 (class 1259 OID 6912797)
-- Name: ARTICLE_DECLINAISON_TAILLE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."ARTICLE_DECLINAISON_TAILLE_ID_seq"
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."ARTICLE_DECLINAISON_TAILLE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24784 (class 0 OID 0)
-- Dependencies: 726
-- Name: ARTICLE_DECLINAISON_TAILLE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."ARTICLE_DECLINAISON_TAILLE_ID_seq" OWNED BY "OpenConcerto42"."ARTICLE_DECLINAISON_TAILLE"."ID";


--
-- TOC entry 727 (class 1259 OID 6912799)
-- Name: ARTICLE_DESIGNATION; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."ARTICLE_DESIGNATION" (
    "ID" integer NOT NULL,
    "ID_ARTICLE" integer DEFAULT 1,
    "ID_LANGUE" integer DEFAULT 1,
    "NOM" character varying(1024) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "OpenConcerto42"."ARTICLE_DESIGNATION" OWNER TO openconcerto;

--
-- TOC entry 728 (class 1259 OID 6912810)
-- Name: ARTICLE_DESIGNATION_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."ARTICLE_DESIGNATION_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."ARTICLE_DESIGNATION_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24785 (class 0 OID 0)
-- Dependencies: 728
-- Name: ARTICLE_DESIGNATION_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."ARTICLE_DESIGNATION_ID_seq" OWNED BY "OpenConcerto42"."ARTICLE_DESIGNATION"."ID";


--
-- TOC entry 729 (class 1259 OID 6912812)
-- Name: ARTICLE_ELEMENT; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."ARTICLE_ELEMENT" (
    "ID" integer NOT NULL,
    "ID_ARTICLE" integer DEFAULT 1,
    "ID_ARTICLE_PARENT" integer DEFAULT 1,
    "QTE" integer DEFAULT 1 NOT NULL,
    "QTE_UNITAIRE" numeric(16,6) DEFAULT 1 NOT NULL,
    "ID_UNITE_VENTE" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "OpenConcerto42"."ARTICLE_ELEMENT" OWNER TO openconcerto;

--
-- TOC entry 730 (class 1259 OID 6912822)
-- Name: ARTICLE_ELEMENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."ARTICLE_ELEMENT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."ARTICLE_ELEMENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24786 (class 0 OID 0)
-- Dependencies: 730
-- Name: ARTICLE_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."ARTICLE_ELEMENT_ID_seq" OWNED BY "OpenConcerto42"."ARTICLE_ELEMENT"."ID";


--
-- TOC entry 731 (class 1259 OID 6912824)
-- Name: ARTICLE_FOURNISSEUR; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."ARTICLE_FOURNISSEUR" (
    "ID" integer NOT NULL,
    "CODE" character varying(45) DEFAULT ''::character varying NOT NULL,
    "CODE_BARRE" character varying(45) DEFAULT ''::character varying NOT NULL,
    "CODE_DOUANIER" character varying(45) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(2048) DEFAULT ''::character varying NOT NULL,
    "DESCRIPTIF" character varying(2048) DEFAULT ''::character varying NOT NULL,
    "INFOS" character varying(2048) DEFAULT ''::character varying NOT NULL,
    "PRIX_METRIQUE_HA_1" numeric(16,6) DEFAULT 0,
    "PRIX_METRIQUE_HA_2" numeric(16,8) DEFAULT 0,
    "PRIX_METRIQUE_HA_3" numeric(16,8) DEFAULT 0,
    "PRIX_METRIQUE_VT_1" numeric(16,8) DEFAULT 0,
    "PRIX_METRIQUE_VT_2" numeric(16,8) DEFAULT 0,
    "PRIX_METRIQUE_VT_3" numeric(16,8) DEFAULT 0,
    "ID_METRIQUE_1" integer DEFAULT 1,
    "ID_METRIQUE_2" integer DEFAULT 1,
    "ID_METRIQUE_3" integer DEFAULT 1,
    "PA_DEVISE" numeric(16,8) DEFAULT 0,
    "PV_U_DEVISE" numeric(16,8) DEFAULT 0,
    "PA_HT" numeric(16,8) DEFAULT 0,
    "PV_HT" numeric(16,8) DEFAULT 0,
    "PV_TTC" numeric(16,2) DEFAULT 0,
    "ID_TAXE" integer DEFAULT 1,
    "ID_FAMILLE_ARTICLE_FOURNISSEUR" integer DEFAULT 1,
    "ID_MODE_VENTE_ARTICLE" integer DEFAULT 1,
    "ID_FOURNISSEUR" integer DEFAULT 1,
    "ID_PAYS" integer DEFAULT 1,
    "ID_DEVISE" integer DEFAULT 1,
    "ID_DEVISE_HA" integer DEFAULT 1,
    "ID_UNITE_VENTE" integer DEFAULT 1,
    "ID_COMPTE_PCE" integer DEFAULT 1,
    "ID_COMPTE_PCE_ACHAT" integer DEFAULT 1,
    "ID_ARTICLE" integer DEFAULT 1,
    "POIDS" real DEFAULT 0,
    "VALEUR_METRIQUE_1" real DEFAULT 0,
    "VALEUR_METRIQUE_2" real DEFAULT 0,
    "VALEUR_METRIQUE_3" real DEFAULT 0,
    "SERVICE" boolean DEFAULT false NOT NULL,
    "OBSOLETE" boolean DEFAULT false NOT NULL,
    "GESTION_STOCK" boolean DEFAULT false NOT NULL,
    "QTE_ACHAT" integer DEFAULT 1 NOT NULL,
    "QTE_MIN" integer DEFAULT 1 NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric,
    "ID_FAMILLE_ARTICLE" integer DEFAULT 1,
    "QTE_UNITAIRE" numeric(16,6) DEFAULT 1 NOT NULL
);


ALTER TABLE "OpenConcerto42"."ARTICLE_FOURNISSEUR" OWNER TO openconcerto;

--
-- TOC entry 732 (class 1259 OID 6912874)
-- Name: ARTICLE_FOURNISSEUR_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."ARTICLE_FOURNISSEUR_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."ARTICLE_FOURNISSEUR_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24787 (class 0 OID 0)
-- Dependencies: 732
-- Name: ARTICLE_FOURNISSEUR_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."ARTICLE_FOURNISSEUR_ID_seq" OWNED BY "OpenConcerto42"."ARTICLE_FOURNISSEUR"."ID";


--
-- TOC entry 733 (class 1259 OID 6912876)
-- Name: ARTICLE_FOURNISSEUR_SECONDAIRE; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."ARTICLE_FOURNISSEUR_SECONDAIRE" (
    "ID" integer NOT NULL,
    "ID_ARTICLE" integer DEFAULT 1,
    "ID_FOURNISSEUR" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8)
);


ALTER TABLE "OpenConcerto42"."ARTICLE_FOURNISSEUR_SECONDAIRE" OWNER TO openconcerto;

--
-- TOC entry 734 (class 1259 OID 6912882)
-- Name: ARTICLE_FOURNISSEUR_SECONDAIRE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."ARTICLE_FOURNISSEUR_SECONDAIRE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."ARTICLE_FOURNISSEUR_SECONDAIRE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24788 (class 0 OID 0)
-- Dependencies: 734
-- Name: ARTICLE_FOURNISSEUR_SECONDAIRE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."ARTICLE_FOURNISSEUR_SECONDAIRE_ID_seq" OWNED BY "OpenConcerto42"."ARTICLE_FOURNISSEUR_SECONDAIRE"."ID";


--
-- TOC entry 735 (class 1259 OID 6912884)
-- Name: ARTICLE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."ARTICLE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."ARTICLE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24789 (class 0 OID 0)
-- Dependencies: 735
-- Name: ARTICLE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."ARTICLE_ID_seq" OWNED BY "OpenConcerto42"."ARTICLE"."ID";


--
-- TOC entry 736 (class 1259 OID 6912886)
-- Name: ARTICLE_TARIF; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."ARTICLE_TARIF" (
    "ID" integer NOT NULL,
    "ID_DEVISE" integer DEFAULT 1,
    "ID_TAXE" integer DEFAULT 1,
    "ID_TARIF" integer DEFAULT 1,
    "ID_ARTICLE" integer DEFAULT 1,
    "PV_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "PV_TTC" numeric(16,2) DEFAULT 0 NOT NULL,
    "PRIX_METRIQUE_VT_1" numeric(16,6) DEFAULT 0 NOT NULL,
    "PRIX_METRIQUE_VT_2" numeric(16,6) DEFAULT 0 NOT NULL,
    "PRIX_METRIQUE_VT_3" numeric(16,6) DEFAULT 0 NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric,
    "POURCENT_REMISE" numeric(16,6) DEFAULT 0 NOT NULL,
    "QTE" integer DEFAULT 1 NOT NULL
);


ALTER TABLE "OpenConcerto42"."ARTICLE_TARIF" OWNER TO openconcerto;

--
-- TOC entry 737 (class 1259 OID 6912902)
-- Name: ARTICLE_TARIF_FOURNISSEUR; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."ARTICLE_TARIF_FOURNISSEUR" (
    "ID" integer NOT NULL,
    "ID_ARTICLE" integer DEFAULT 1,
    "ID_FOURNISSEUR" integer DEFAULT 1,
    "REF_FOURNISSEUR" character varying(500) DEFAULT ''::character varying NOT NULL,
    "TYPE_REAPPRO" character varying(256) DEFAULT ''::character varying NOT NULL,
    "CONDITIONS" character varying(1024) DEFAULT ''::character varying NOT NULL,
    "ACHETEUR" character varying(256) DEFAULT ''::character varying NOT NULL,
    "CODE_PAYS_ORIGINE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "PRIX_ACHAT_DEVISE_F" numeric(16,6) DEFAULT 0 NOT NULL,
    "PRIX_ACHAT" numeric(16,6) DEFAULT 0 NOT NULL,
    "QTE" integer DEFAULT 1 NOT NULL,
    "DATE_PRIX" timestamp without time zone,
    "DELAI_REAPPRO" integer DEFAULT 0 NOT NULL,
    "DELAI_TRANSPORT" integer DEFAULT 0 NOT NULL,
    "PRIORITE" integer DEFAULT 0 NOT NULL,
    "COEF_PRIX_MINI" numeric(16,2) DEFAULT 0 NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8)
);


ALTER TABLE "OpenConcerto42"."ARTICLE_TARIF_FOURNISSEUR" OWNER TO openconcerto;

--
-- TOC entry 738 (class 1259 OID 6912923)
-- Name: ARTICLE_TARIF_FOURNISSEUR_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."ARTICLE_TARIF_FOURNISSEUR_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."ARTICLE_TARIF_FOURNISSEUR_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24790 (class 0 OID 0)
-- Dependencies: 738
-- Name: ARTICLE_TARIF_FOURNISSEUR_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."ARTICLE_TARIF_FOURNISSEUR_ID_seq" OWNED BY "OpenConcerto42"."ARTICLE_TARIF_FOURNISSEUR"."ID";


--
-- TOC entry 739 (class 1259 OID 6912925)
-- Name: ARTICLE_TARIF_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."ARTICLE_TARIF_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."ARTICLE_TARIF_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24791 (class 0 OID 0)
-- Dependencies: 739
-- Name: ARTICLE_TARIF_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."ARTICLE_TARIF_ID_seq" OWNED BY "OpenConcerto42"."ARTICLE_TARIF"."ID";


--
-- TOC entry 740 (class 1259 OID 6912927)
-- Name: ARTICLE_TARIF_PROMOTION; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."ARTICLE_TARIF_PROMOTION" (
    "ID" integer NOT NULL,
    "ID_DEVISE" integer DEFAULT 1,
    "ID_TAXE" integer DEFAULT 1,
    "ID_TARIF_PROMOTION" integer DEFAULT 1,
    "ID_ARTICLE" integer DEFAULT 1,
    "QTE" integer DEFAULT 1 NOT NULL,
    "PV_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "PV_TTC" numeric(16,6) DEFAULT 0 NOT NULL,
    "PRIX_METRIQUE_VT_1" numeric(16,6) DEFAULT 0 NOT NULL,
    "PRIX_METRIQUE_VT_2" numeric(16,6) DEFAULT 0 NOT NULL,
    "PRIX_METRIQUE_VT_3" numeric(16,6) DEFAULT 0 NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8)
);


ALTER TABLE "OpenConcerto42"."ARTICLE_TARIF_PROMOTION" OWNER TO openconcerto;

--
-- TOC entry 741 (class 1259 OID 6912941)
-- Name: ARTICLE_TARIF_PROMOTION_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."ARTICLE_TARIF_PROMOTION_ID_seq"
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."ARTICLE_TARIF_PROMOTION_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24792 (class 0 OID 0)
-- Dependencies: 741
-- Name: ARTICLE_TARIF_PROMOTION_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."ARTICLE_TARIF_PROMOTION_ID_seq" OWNED BY "OpenConcerto42"."ARTICLE_TARIF_PROMOTION"."ID";


--
-- TOC entry 742 (class 1259 OID 6912943)
-- Name: ASSOCIATION_ANALYTIQUE; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."ASSOCIATION_ANALYTIQUE" (
    "ID" integer NOT NULL,
    "ID_ECRITURE" integer DEFAULT 1,
    "ID_SAISIE_KM_ELEMENT" integer DEFAULT 1,
    "ID_POSTE_ANALYTIQUE" integer DEFAULT 1,
    "POURCENT" numeric(16,8) DEFAULT 100,
    "MONTANT" bigint DEFAULT 0,
    "GESTION_AUTO" boolean DEFAULT false NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "OpenConcerto42"."ASSOCIATION_ANALYTIQUE" OWNER TO openconcerto;

--
-- TOC entry 743 (class 1259 OID 6912954)
-- Name: ASSOCIATION_ANALYTIQUE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."ASSOCIATION_ANALYTIQUE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."ASSOCIATION_ANALYTIQUE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24793 (class 0 OID 0)
-- Dependencies: 743
-- Name: ASSOCIATION_ANALYTIQUE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."ASSOCIATION_ANALYTIQUE_ID_seq" OWNED BY "OpenConcerto42"."ASSOCIATION_ANALYTIQUE"."ID";


--
-- TOC entry 744 (class 1259 OID 6912956)
-- Name: ASSOCIATION_COMPTE_ANALYTIQUE; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."ASSOCIATION_COMPTE_ANALYTIQUE" (
    "ID_REPARTITION_ANALYTIQUE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ID_COMPTE_PCE" integer DEFAULT 1,
    "ORDRE" numeric(16,8),
    "ARCHIVE" integer DEFAULT 0,
    "ID_AXE_ANALYTIQUE" integer DEFAULT 1,
    "ID" integer NOT NULL,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone
);


ALTER TABLE "OpenConcerto42"."ASSOCIATION_COMPTE_ANALYTIQUE" OWNER TO openconcerto;

--
-- TOC entry 745 (class 1259 OID 6912965)
-- Name: ASSOCIATION_COMPTE_ANALYTIQUE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."ASSOCIATION_COMPTE_ANALYTIQUE_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."ASSOCIATION_COMPTE_ANALYTIQUE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24794 (class 0 OID 0)
-- Dependencies: 745
-- Name: ASSOCIATION_COMPTE_ANALYTIQUE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."ASSOCIATION_COMPTE_ANALYTIQUE_ID_seq" OWNED BY "OpenConcerto42"."ASSOCIATION_COMPTE_ANALYTIQUE"."ID";


--
-- TOC entry 746 (class 1259 OID 6912967)
-- Name: ATTACHMENT; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."ATTACHMENT" (
    "ID" integer NOT NULL,
    "SOURCE_TABLE" character varying(128) DEFAULT ''::character varying NOT NULL,
    "SOURCE_ID" integer DEFAULT 0 NOT NULL,
    "NAME" character varying(256) DEFAULT ''::character varying NOT NULL,
    "MIMETYPE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "FILENAME" character varying(256) DEFAULT ''::character varying NOT NULL,
    "FILESIZE" bigint DEFAULT 0 NOT NULL,
    "STORAGE_PATH" character varying(256) DEFAULT ''::character varying NOT NULL,
    "STORAGE_FILENAME" character varying(256) DEFAULT ''::character varying NOT NULL,
    "DIRECTORY" character varying(256) DEFAULT ''::character varying NOT NULL,
    "THUMBNAIL" character varying(256) DEFAULT ''::character varying NOT NULL,
    "THUMBNAIL_WIDTH" integer DEFAULT 32 NOT NULL,
    "THUMBNAIL_HEIGHT" integer DEFAULT 32 NOT NULL,
    "TAG" character varying(128) DEFAULT ''::character varying NOT NULL,
    "VERSION" integer DEFAULT 0 NOT NULL,
    "HASH" character varying(32) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric,
    "ID_PARENT" integer DEFAULT 1,
    "ENCRYPTED" boolean DEFAULT false NOT NULL
);


ALTER TABLE "OpenConcerto42"."ATTACHMENT" OWNER TO openconcerto;

--
-- TOC entry 747 (class 1259 OID 6912992)
-- Name: ATTACHMENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."ATTACHMENT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."ATTACHMENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24795 (class 0 OID 0)
-- Dependencies: 747
-- Name: ATTACHMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."ATTACHMENT_ID_seq" OWNED BY "OpenConcerto42"."ATTACHMENT"."ID";


--
-- TOC entry 748 (class 1259 OID 6912994)
-- Name: AVOIR_CLIENT; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."AVOIR_CLIENT" (
    "MONTANT_SOLDE" bigint DEFAULT 0,
    "SOLDE" boolean DEFAULT false,
    "ID_MOUVEMENT" integer DEFAULT 1,
    "MONTANT_SERVICE" bigint DEFAULT 0,
    "ID" integer NOT NULL,
    "ID_MODE_REGLEMENT" integer DEFAULT 1,
    "MOTIF" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ENVOYE_EN_AFFACTURAGE" boolean DEFAULT false,
    "REMISE_HT" bigint DEFAULT 0,
    "ID_COMMERCIAL" integer DEFAULT 1,
    "NOM" character varying(256) DEFAULT ''::character varying,
    "CREATION_DATE" timestamp without time zone,
    "MONTANT_TTC" bigint DEFAULT 0,
    "MONTANT_HT" bigint DEFAULT 0,
    "PORT_HT" bigint DEFAULT 0,
    "ID_ADRESSE" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_COMPTE_PCE_SERVICE" integer DEFAULT 1,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "DATE_ENVOI_AFFACTURAGE" date,
    "ID_CLIENT" integer DEFAULT 1,
    "ID_CONTACT" integer DEFAULT 1,
    "DATE" date,
    "AFFACTURE" boolean DEFAULT false,
    "MONTANT_TVA" bigint DEFAULT 0,
    "ID_SAISIE_VENTE_FACTURE" integer DEFAULT 1,
    "COMPTE_SERVICE_AUTO" boolean DEFAULT false,
    "AFFACTURAGE" boolean DEFAULT false,
    "A_DEDUIRE" boolean DEFAULT false,
    "ID_TAXE" integer DEFAULT 1,
    "MONTANT_RESTANT" bigint DEFAULT 0,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ORDRE" numeric(16,8),
    "ARCHIVE" integer DEFAULT 0,
    "NUMERO" character varying(45) DEFAULT ''::character varying,
    "T_DEVISE" bigint DEFAULT 0,
    "T_POIDS" real DEFAULT 0,
    "ID_TARIF" integer DEFAULT 1,
    "ID_MODELE" integer DEFAULT 1,
    "INFOS" character varying(1024) DEFAULT ''::character varying NOT NULL,
    "ID_ADRESSE_LIVRAISON" integer DEFAULT 1,
    "POURCENT_REMISE" numeric(12,8),
    "MONTANT_REMISE" numeric(16,8),
    "ID_CLIENT_DEPARTEMENT" integer DEFAULT 1,
    "T_ECO_CONTRIBUTION" bigint DEFAULT 0,
    "ID_CATEGORIE_COMPTABLE" integer DEFAULT 1,
    "ID_TAXE_PORT" integer DEFAULT 1,
    "MONTANT_INTERFEL_HT" bigint DEFAULT 0 NOT NULL
);


ALTER TABLE "OpenConcerto42"."AVOIR_CLIENT" OWNER TO openconcerto;

--
-- TOC entry 749 (class 1259 OID 6913039)
-- Name: AVOIR_CLIENT_ELEMENT; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."AVOIR_CLIENT_ELEMENT" (
    "INDICE_N" bigint DEFAULT 0,
    "ID_CONTACT" integer DEFAULT 1,
    "LOCAL_OBJET_INSPECTE" character varying(2048) DEFAULT ''::text,
    "PRIX_METRIQUE_VT_2" numeric(16,6) DEFAULT 0 NOT NULL,
    "T_PV_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "ID_METRIQUE_3" integer DEFAULT 1,
    "NOM" character varying(2048) DEFAULT ''::text,
    "POURCENT_SERVICE" character varying(2048) DEFAULT ''::text,
    "SOUS_ACTIVITE" character varying(45) DEFAULT ''::character varying,
    "PRIX_METRIQUE_HA_3" numeric(16,6) DEFAULT 0 NOT NULL,
    "ID_STYLE" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "POIDS" real DEFAULT 0,
    "POURCENT_ACOMPTE" numeric(6,2) DEFAULT 100 NOT NULL,
    "CREATION_DATE" timestamp without time zone,
    "MONTANT_REVISABLE" boolean DEFAULT false,
    "TARIF_Q18_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "OBJET_INSPECTE" character varying(2048) DEFAULT ''::text,
    "ID_METRIQUE_2" integer DEFAULT 1,
    "VALEUR_METRIQUE_2" real DEFAULT 0,
    "DATE" timestamp without time zone,
    "ID_TAXE" integer DEFAULT 1,
    "CODE_MISSION" character varying(45) DEFAULT ''::character varying,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "DATE_FIN" timestamp without time zone,
    "ACOMPTE" boolean DEFAULT false,
    "PRIX_METRIQUE_VT_3" numeric(16,6) DEFAULT 0 NOT NULL,
    "VALEUR_METRIQUE_1" real DEFAULT 0,
    "PV_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "PA_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "MODIFICATION_DATE" timestamp without time zone,
    "Q18" boolean DEFAULT false,
    "T_POIDS" real DEFAULT 0,
    "MONTANT_INITIAL" numeric(16,6) DEFAULT 0 NOT NULL,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ID_METRIQUE_1" integer DEFAULT 1,
    "POURCENT_REMISE" numeric(12,8) DEFAULT 0,
    "T_PA_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "VALEUR_METRIQUE_3" real DEFAULT 0,
    "ID_MODE_VENTE_ARTICLE" integer DEFAULT 1,
    "ID_AVOIR_CLIENT" integer DEFAULT 1,
    "T_PV_TTC" numeric(16,2) DEFAULT 0 NOT NULL,
    "PRIX_METRIQUE_VT_1" numeric(16,6) DEFAULT 0 NOT NULL,
    "PRIX_METRIQUE_HA_2" numeric(16,6) DEFAULT 0 NOT NULL,
    "NOM_MISSION" character varying(256) DEFAULT ''::character varying,
    "QTE" integer DEFAULT 1,
    "PRIX_METRIQUE_HA_1" numeric(16,6) DEFAULT 0 NOT NULL,
    "SERVICE" boolean DEFAULT false,
    "CODE" character varying(45) DEFAULT ''::character varying,
    "ACTIVITE" character varying(45) DEFAULT ''::character varying,
    "INDICE_0" bigint DEFAULT 0,
    "INFOS_OBJET_INSPECTE" character varying(2048) DEFAULT ''::text,
    "ID" integer NOT NULL,
    "REFERENTIEL_INSPECTION" character varying(2048) DEFAULT ''::text,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "SITUATION_ADMIN" character varying(2048) DEFAULT ''::text,
    "QTE_ACHAT" integer DEFAULT 1,
    "CODE_DOUANIER" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ID_PAYS" integer DEFAULT 1,
    "ID_DEVISE" integer DEFAULT 1,
    "PV_U_DEVISE" numeric(16,6) DEFAULT 0 NOT NULL,
    "PV_T_DEVISE" numeric(16,6) DEFAULT 0 NOT NULL,
    "TAUX_DEVISE" numeric(16,8) DEFAULT 1,
    "DESCRIPTIF" character varying(2048) DEFAULT ''::character varying NOT NULL,
    "MARGE_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "QTE_UNITAIRE" numeric(16,6) DEFAULT 1,
    "ID_UNITE_VENTE" integer DEFAULT 2,
    "ID_ARTICLE" integer DEFAULT 1,
    "POIDS_COLIS_NET" numeric(16,8) DEFAULT 0,
    "T_POIDS_COLIS_NET" numeric(16,8) DEFAULT 0,
    "NB_COLIS" integer DEFAULT 0,
    "MONTANT_REMISE" numeric(16,8),
    "ID_FAMILLE_ARTICLE" integer DEFAULT 1,
    "NIVEAU" integer DEFAULT 1 NOT NULL,
    "RETOUR_STOCK" boolean DEFAULT false NOT NULL,
    "ID_ECO_CONTRIBUTION" integer DEFAULT 1,
    "ECO_CONTRIBUTION" numeric(16,2) DEFAULT 0,
    "T_ECO_CONTRIBUTION" numeric(16,2) DEFAULT 0,
    "ID_DEPOT_STOCK" integer DEFAULT 1,
    "LONGUEUR" numeric(16,8),
    "LARGEUR" numeric(16,8),
    "HAUTEUR" numeric(16,8),
    "TARE" numeric(16,8),
    "T_POIDS_BRUT" numeric(16,8) DEFAULT 0,
    "ID_ARTICLE_DECLINAISON_TAILLE" integer DEFAULT 1,
    "ID_ARTICLE_DECLINAISON_COULEUR" integer DEFAULT 1
);


ALTER TABLE "OpenConcerto42"."AVOIR_CLIENT_ELEMENT" OWNER TO openconcerto;

--
-- TOC entry 750 (class 1259 OID 6913121)
-- Name: AVOIR_CLIENT_ELEMENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."AVOIR_CLIENT_ELEMENT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."AVOIR_CLIENT_ELEMENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24796 (class 0 OID 0)
-- Dependencies: 750
-- Name: AVOIR_CLIENT_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."AVOIR_CLIENT_ELEMENT_ID_seq" OWNED BY "OpenConcerto42"."AVOIR_CLIENT_ELEMENT"."ID";


--
-- TOC entry 751 (class 1259 OID 6913123)
-- Name: AVOIR_CLIENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."AVOIR_CLIENT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."AVOIR_CLIENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24797 (class 0 OID 0)
-- Dependencies: 751
-- Name: AVOIR_CLIENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."AVOIR_CLIENT_ID_seq" OWNED BY "OpenConcerto42"."AVOIR_CLIENT"."ID";


--
-- TOC entry 752 (class 1259 OID 6913125)
-- Name: AVOIR_FOURNISSEUR; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."AVOIR_FOURNISSEUR" (
    "SOLDE" boolean DEFAULT false,
    "ID_COMPTE_PCE" integer DEFAULT 1,
    "MONTANT_TVA" bigint DEFAULT 0,
    "DATE" date,
    "NUMERO" character varying(2048) DEFAULT ''::text,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "A_DEDUIRE" boolean DEFAULT false,
    "CREATION_DATE" timestamp without time zone,
    "MODIFICATION_DATE" timestamp without time zone,
    "IMMO" boolean DEFAULT false,
    "ID_MOUVEMENT" integer DEFAULT 1,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID" integer NOT NULL,
    "NOM" character varying(2048) DEFAULT ''::text,
    "ID_FOURNISSEUR" integer DEFAULT 1,
    "MONTANT_HT" bigint DEFAULT 0,
    "ID_MODE_REGLEMENT" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ID_TAXE" integer DEFAULT 1,
    "MONTANT_TTC" bigint DEFAULT 0,
    "INFOS" character varying(1024) DEFAULT ''::character varying NOT NULL
);


ALTER TABLE "OpenConcerto42"."AVOIR_FOURNISSEUR" OWNER TO openconcerto;

--
-- TOC entry 753 (class 1259 OID 6913149)
-- Name: AVOIR_FOURNISSEUR_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."AVOIR_FOURNISSEUR_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."AVOIR_FOURNISSEUR_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24798 (class 0 OID 0)
-- Dependencies: 753
-- Name: AVOIR_FOURNISSEUR_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."AVOIR_FOURNISSEUR_ID_seq" OWNED BY "OpenConcerto42"."AVOIR_FOURNISSEUR"."ID";


--
-- TOC entry 754 (class 1259 OID 6913151)
-- Name: AXE_ANALYTIQUE; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."AXE_ANALYTIQUE" (
    "CREATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "NOM" character varying(2048) DEFAULT ''::text,
    "ORDRE" numeric(16,8),
    "ARCHIVE" integer DEFAULT 0,
    "ID" integer NOT NULL,
    "MODIFICATION_DATE" timestamp without time zone,
    "TYPE" character varying(256) DEFAULT ''::character varying NOT NULL
);


ALTER TABLE "OpenConcerto42"."AXE_ANALYTIQUE" OWNER TO openconcerto;

--
-- TOC entry 755 (class 1259 OID 6913162)
-- Name: AXE_ANALYTIQUE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."AXE_ANALYTIQUE_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."AXE_ANALYTIQUE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24799 (class 0 OID 0)
-- Dependencies: 755
-- Name: AXE_ANALYTIQUE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."AXE_ANALYTIQUE_ID_seq" OWNED BY "OpenConcerto42"."AXE_ANALYTIQUE"."ID";


--
-- TOC entry 756 (class 1259 OID 6913164)
-- Name: AYANT_DROIT; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."AYANT_DROIT" (
    "ID" integer NOT NULL,
    "NOM" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ID_SALARIE" integer DEFAULT 1,
    "ID_AYANT_DROIT_TYPE" integer DEFAULT 1,
    "REGIME_ALSACE" boolean DEFAULT false NOT NULL,
    "NIR" character varying(256) DEFAULT ''::character varying NOT NULL,
    "PRENOMS" character varying(256) DEFAULT ''::character varying NOT NULL,
    "CODE_ORGANISME_AFFILIATION" character varying(256) DEFAULT ''::character varying NOT NULL,
    "CODE_OPTION" character varying(256) DEFAULT ''::character varying NOT NULL,
    "NIR_OUVRANT_DROIT" character varying(256) DEFAULT ''::character varying NOT NULL,
    "DATE_DEBUT_RATTACHEMENT" timestamp without time zone,
    "DATE_FIN_RATTACHEMENT" timestamp without time zone,
    "DATE_NAISSANCE" timestamp without time zone,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "OpenConcerto42"."AYANT_DROIT" OWNER TO openconcerto;

--
-- TOC entry 757 (class 1259 OID 6913181)
-- Name: AYANT_DROIT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."AYANT_DROIT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."AYANT_DROIT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24800 (class 0 OID 0)
-- Dependencies: 757
-- Name: AYANT_DROIT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."AYANT_DROIT_ID_seq" OWNED BY "OpenConcerto42"."AYANT_DROIT"."ID";


--
-- TOC entry 758 (class 1259 OID 6913183)
-- Name: BANQUE; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."BANQUE" (
    "ID" integer NOT NULL,
    "ID_JOURNAL" integer DEFAULT 1,
    "INFOS" character varying(2048) DEFAULT ''::character varying NOT NULL,
    "NUMERO_RUE" character varying(45) DEFAULT ''::character varying NOT NULL,
    "RUE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "IBAN" character varying(256) DEFAULT ''::character varying NOT NULL,
    "BIC" character varying(256) DEFAULT ''::character varying NOT NULL,
    "VOIE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "VILLE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(256) DEFAULT ''::character varying NOT NULL,
    "DOMICILIATION" character varying(256) DEFAULT ''::character varying NOT NULL,
    "CODE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "AFFACTURAGE" boolean DEFAULT false NOT NULL,
    "ID_COMPTE_PCE" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric,
    "ID_COMPTE_PCE_CB_ATTENTE" integer DEFAULT 1,
    "ID_JOURNAL_CB_ATTENTE" integer DEFAULT 1,
    "ID_COMPTE_PCE_FRAIS_CB" integer DEFAULT 1
);


ALTER TABLE "OpenConcerto42"."BANQUE" OWNER TO openconcerto;

--
-- TOC entry 759 (class 1259 OID 6913204)
-- Name: BANQUE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."BANQUE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."BANQUE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24801 (class 0 OID 0)
-- Dependencies: 759
-- Name: BANQUE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."BANQUE_ID_seq" OWNED BY "OpenConcerto42"."BANQUE"."ID";


--
-- TOC entry 760 (class 1259 OID 6913206)
-- Name: BON_DE_LIVRAISON; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."BON_DE_LIVRAISON" (
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "DATE" date,
    "ID" integer NOT NULL,
    "ID_COMMANDE_CLIENT" integer DEFAULT 1,
    "NOM" character varying(45) DEFAULT ''::character varying,
    "ARCHIVE" integer DEFAULT 0,
    "CREATION_DATE" timestamp without time zone,
    "TOTAL_TTC" bigint DEFAULT 0,
    "ID_CLIENT" integer DEFAULT 1,
    "ORDRE" numeric(16,8),
    "TOTAL_TVA" bigint DEFAULT 0,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "TOTAL_HT" bigint DEFAULT 0,
    "INFOS" character varying(2048) DEFAULT ''::text,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_SAISIE_VENTE_FACTURE" integer DEFAULT 1,
    "NUMERO" character varying(45) DEFAULT ''::character varying,
    "TOTAL_POIDS" real DEFAULT 0,
    "SOURCE" character varying(512) DEFAULT ''::character varying NOT NULL,
    "IDSOURCE" integer DEFAULT 1,
    "T_DEVISE" bigint DEFAULT 0,
    "T_POIDS" real DEFAULT 0,
    "ID_TARIF" integer DEFAULT 1,
    "ID_MODELE" integer DEFAULT 1,
    "DATE_LIVRAISON" date,
    "ID_ADRESSE" integer DEFAULT 1,
    "ID_ADRESSE_LIVRAISON" integer DEFAULT 1,
    "POURCENT_REMISE" numeric(12,8),
    "MONTANT_REMISE" numeric(16,8),
    "ID_CONTACT" integer DEFAULT 1,
    "ID_CLIENT_DEPARTEMENT" integer DEFAULT 1,
    "TOTAL_DEVISE" bigint DEFAULT 0 NOT NULL,
    "TOTAL_SERVICE" bigint DEFAULT 0 NOT NULL,
    "ID_TAXE_PORT" integer DEFAULT 1,
    "PORT_HT" bigint DEFAULT 0 NOT NULL,
    "REMISE_HT" bigint DEFAULT 0 NOT NULL,
    "CREATE_VIRTUAL_STOCK" boolean DEFAULT true NOT NULL,
    "T_ECO_CONTRIBUTION" bigint DEFAULT 0,
    "FRAIS_DOCUMENT_HT" bigint DEFAULT 0 NOT NULL,
    "ID_TAXE_FRAIS_DOCUMENT" integer DEFAULT 1,
    "ID_COMMERCIAL" integer DEFAULT 1,
    "ID_CATEGORIE_COMPTABLE" integer DEFAULT 1,
    "VERROU_FACTURATION" boolean DEFAULT false NOT NULL,
    "ID_LOT" integer DEFAULT 1,
    "T_ACOMPTE" bigint DEFAULT 0 NOT NULL,
    "MONTANT_INTERFEL_HT" bigint DEFAULT 0 NOT NULL
);


ALTER TABLE "OpenConcerto42"."BON_DE_LIVRAISON" OWNER TO openconcerto;

--
-- TOC entry 761 (class 1259 OID 6913249)
-- Name: BON_DE_LIVRAISON_ELEMENT; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."BON_DE_LIVRAISON_ELEMENT" (
    "T_POIDS" real DEFAULT 0,
    "NOM" character varying(2048) DEFAULT ''::text,
    "T_PV_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "PRIX_METRIQUE_HA_1" numeric(16,6) DEFAULT 0 NOT NULL,
    "ID_METRIQUE_3" integer DEFAULT 1,
    "PV_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "ID_MODE_VENTE_ARTICLE" integer DEFAULT 1,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_METRIQUE_1" integer DEFAULT 1,
    "VALEUR_METRIQUE_3" real DEFAULT 0,
    "SERVICE" boolean DEFAULT false,
    "VALEUR_METRIQUE_2" real DEFAULT 0,
    "ID_BON_DE_LIVRAISON" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "PRIX_METRIQUE_VT_3" numeric(16,6) DEFAULT 0 NOT NULL,
    "PRIX_METRIQUE_HA_3" numeric(16,6) DEFAULT 0 NOT NULL,
    "QTE_A_LIVRER" integer DEFAULT 0,
    "ID_METRIQUE_2" integer DEFAULT 1,
    "PRIX_METRIQUE_VT_1" numeric(16,6) DEFAULT 0 NOT NULL,
    "QTE" integer DEFAULT 0,
    "T_PV_TTC" numeric(16,2) DEFAULT 0 NOT NULL,
    "T_PA_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_STYLE" integer DEFAULT 1,
    "VALEUR_METRIQUE_1" real DEFAULT 0,
    "PRIX_METRIQUE_VT_2" numeric(16,6) DEFAULT 0 NOT NULL,
    "CODE" character varying(45) DEFAULT ''::character varying,
    "POIDS" real DEFAULT 0,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "T_POIDS_LIVREE" real DEFAULT 0,
    "ID" integer NOT NULL,
    "PA_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "ID_SAISIE_VENTE_FACTURE_ELEMENT" integer DEFAULT 1,
    "QTE_LIVREE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID_TAXE" integer DEFAULT 1,
    "PRIX_METRIQUE_HA_2" numeric(16,6) DEFAULT 0 NOT NULL,
    "ARCHIVE" integer DEFAULT 0,
    "QTE_ACHAT" integer DEFAULT 1,
    "CODE_DOUANIER" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ID_PAYS" integer DEFAULT 1,
    "ID_DEVISE" integer DEFAULT 1,
    "PV_U_DEVISE" numeric(16,6) DEFAULT 0 NOT NULL,
    "POURCENT_REMISE" numeric(12,8) DEFAULT 0,
    "PV_T_DEVISE" numeric(16,6) DEFAULT 0 NOT NULL,
    "TAUX_DEVISE" numeric(16,8) DEFAULT 1,
    "DESCRIPTIF" character varying(2048) DEFAULT ''::character varying NOT NULL,
    "MARGE_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "QTE_UNITAIRE" numeric(16,6) DEFAULT 1,
    "ID_UNITE_VENTE" integer DEFAULT 2,
    "ID_ARTICLE" integer DEFAULT 1,
    "POIDS_COLIS_NET" numeric(16,8) DEFAULT 0,
    "T_POIDS_COLIS_NET" numeric(16,8) DEFAULT 0,
    "NB_COLIS" integer DEFAULT 0,
    "MONTANT_REMISE" numeric(16,8),
    "ID_FAMILLE_ARTICLE" integer DEFAULT 1,
    "NIVEAU" integer DEFAULT 1 NOT NULL,
    "ID_ECO_CONTRIBUTION" integer DEFAULT 1,
    "ECO_CONTRIBUTION" numeric(16,2) DEFAULT 0,
    "T_ECO_CONTRIBUTION" numeric(16,2) DEFAULT 0,
    "ID_COMMANDE_CLIENT_ELEMENT" integer DEFAULT 1,
    "ID_DEPOT_STOCK" integer DEFAULT 1,
    "ID_DEVIS_ELEMENT" integer DEFAULT 1,
    "LONGUEUR" numeric(16,8),
    "LARGEUR" numeric(16,8),
    "HAUTEUR" numeric(16,8),
    "TARE" numeric(16,8),
    "T_POIDS_BRUT" numeric(16,8) DEFAULT 0,
    "ID_ARTICLE_DECLINAISON_TAILLE" integer DEFAULT 1,
    "ID_ARTICLE_DECLINAISON_COULEUR" integer DEFAULT 1
);


ALTER TABLE "OpenConcerto42"."BON_DE_LIVRAISON_ELEMENT" OWNER TO openconcerto;

--
-- TOC entry 762 (class 1259 OID 6913316)
-- Name: BON_DE_LIVRAISON_ELEMENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."BON_DE_LIVRAISON_ELEMENT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."BON_DE_LIVRAISON_ELEMENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24802 (class 0 OID 0)
-- Dependencies: 762
-- Name: BON_DE_LIVRAISON_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."BON_DE_LIVRAISON_ELEMENT_ID_seq" OWNED BY "OpenConcerto42"."BON_DE_LIVRAISON_ELEMENT"."ID";


--
-- TOC entry 763 (class 1259 OID 6913318)
-- Name: BON_DE_LIVRAISON_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."BON_DE_LIVRAISON_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."BON_DE_LIVRAISON_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24803 (class 0 OID 0)
-- Dependencies: 763
-- Name: BON_DE_LIVRAISON_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."BON_DE_LIVRAISON_ID_seq" OWNED BY "OpenConcerto42"."BON_DE_LIVRAISON"."ID";


--
-- TOC entry 764 (class 1259 OID 6913320)
-- Name: BON_RECEPTION; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."BON_RECEPTION" (
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "NUMERO" character varying(45) DEFAULT ''::character varying,
    "ID" integer NOT NULL,
    "MODIFICATION_DATE" timestamp without time zone,
    "ORDRE" numeric(16,8),
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "NOM" character varying(45) DEFAULT ''::character varying,
    "TOTAL_TVA" bigint DEFAULT 0,
    "INFOS" character varying(2048) DEFAULT ''::text,
    "ID_FOURNISSEUR" integer DEFAULT 1,
    "ID_COMMANDE" integer DEFAULT 1,
    "TOTAL_HT" bigint DEFAULT 0,
    "DATE" date,
    "TOTAL_TTC" bigint DEFAULT 0,
    "CREATION_DATE" timestamp without time zone,
    "TOTAL_POIDS" real DEFAULT 0,
    "ID_DEVISE" integer DEFAULT 1,
    "T_DEVISE" bigint DEFAULT 0,
    "CREATE_VIRTUAL_STOCK" boolean DEFAULT true NOT NULL,
    "T_ECO_CONTRIBUTION" bigint DEFAULT 0,
    "ID_TAXE_PORT" integer DEFAULT 1,
    "PORT_HT" bigint DEFAULT 0 NOT NULL,
    "REMISE_HT" bigint DEFAULT 0 NOT NULL,
    "ID_MODELE" integer DEFAULT 1
);


ALTER TABLE "OpenConcerto42"."BON_RECEPTION" OWNER TO openconcerto;

--
-- TOC entry 765 (class 1259 OID 6913346)
-- Name: BON_RECEPTION_ELEMENT; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."BON_RECEPTION_ELEMENT" (
    "PRIX_METRIQUE_HA_2" numeric(16,6) DEFAULT 0 NOT NULL,
    "CODE" character varying(45) DEFAULT ''::character varying,
    "ORDRE" numeric(16,8),
    "VALEUR_METRIQUE_1" real DEFAULT 0,
    "PRIX_METRIQUE_VT_2" numeric(16,6) DEFAULT 0 NOT NULL,
    "ARCHIVE" integer DEFAULT 0,
    "T_POIDS" real DEFAULT 0,
    "VALEUR_METRIQUE_3" real DEFAULT 0,
    "ID_STYLE" integer DEFAULT 1,
    "PRIX_METRIQUE_HA_1" numeric(16,6) DEFAULT 0 NOT NULL,
    "POIDS" real DEFAULT 0,
    "ID_METRIQUE_1" integer DEFAULT 1,
    "T_PA_TTC" numeric(16,2) DEFAULT 0 NOT NULL,
    "T_PV_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "QTE" integer DEFAULT 0,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_METRIQUE_3" integer DEFAULT 1,
    "SERVICE" boolean DEFAULT false,
    "PRIX_METRIQUE_VT_3" numeric(16,6) DEFAULT 0 NOT NULL,
    "ID_TAXE" integer DEFAULT 1,
    "VALEUR_METRIQUE_2" real DEFAULT 0,
    "ID_BON_RECEPTION" integer DEFAULT 1,
    "NOM" character varying(2048) DEFAULT ''::character varying,
    "ID_METRIQUE_2" integer DEFAULT 1,
    "T_PV_TTC" numeric(16,2) DEFAULT 0 NOT NULL,
    "PV_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "PRIX_METRIQUE_HA_3" numeric(16,6) DEFAULT 0 NOT NULL,
    "ID" integer NOT NULL,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ID_MODE_VENTE_ARTICLE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "PA_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "T_PA_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "PRIX_METRIQUE_VT_1" numeric(16,6) DEFAULT 0 NOT NULL,
    "QTE_ACHAT" integer DEFAULT 1,
    "PA_DEVISE" numeric(16,6) DEFAULT 0 NOT NULL,
    "ID_DEVISE" integer DEFAULT 1,
    "PA_DEVISE_T" numeric(16,6) DEFAULT 0 NOT NULL,
    "QTE_UNITAIRE" numeric(16,6) DEFAULT 1,
    "ID_UNITE_VENTE" integer DEFAULT 2,
    "ID_ARTICLE" integer DEFAULT 1,
    "ID_CODE_FOURNISSEUR" integer DEFAULT 1,
    "DESCRIPTIF" character varying(2048) DEFAULT ''::character varying NOT NULL,
    "NIVEAU" integer DEFAULT 1 NOT NULL,
    "ID_ECO_CONTRIBUTION" integer DEFAULT 1,
    "ECO_CONTRIBUTION" numeric(16,2) DEFAULT 0,
    "T_ECO_CONTRIBUTION" numeric(16,2) DEFAULT 0,
    "ID_COMMANDE_ELEMENT" integer DEFAULT 1,
    "ID_DEMANDE_ACHAT_ELEMENT" integer DEFAULT 1,
    "ID_FAMILLE_ARTICLE" integer DEFAULT 1,
    "QTE_ORIGINE" integer,
    "ID_DEPOT_STOCK" integer DEFAULT 1,
    "LONGUEUR" numeric(16,8),
    "LARGEUR" numeric(16,8),
    "HAUTEUR" numeric(16,8),
    "POIDS_COLIS_NET" numeric(16,8) DEFAULT 0,
    "T_POIDS_COLIS_NET" numeric(16,8) DEFAULT 0,
    "NB_COLIS" integer DEFAULT 0,
    "TARE" numeric(16,8),
    "T_POIDS_BRUT" numeric(16,8) DEFAULT 0,
    "ID_ARTICLE_DECLINAISON_TAILLE" integer DEFAULT 1,
    "ID_ARTICLE_DECLINAISON_COULEUR" integer DEFAULT 1,
    "ID_LOT" integer DEFAULT 1
);


ALTER TABLE "OpenConcerto42"."BON_RECEPTION_ELEMENT" OWNER TO openconcerto;

--
-- TOC entry 766 (class 1259 OID 6913407)
-- Name: BON_RECEPTION_ELEMENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."BON_RECEPTION_ELEMENT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."BON_RECEPTION_ELEMENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24804 (class 0 OID 0)
-- Dependencies: 766
-- Name: BON_RECEPTION_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."BON_RECEPTION_ELEMENT_ID_seq" OWNED BY "OpenConcerto42"."BON_RECEPTION_ELEMENT"."ID";


--
-- TOC entry 767 (class 1259 OID 6913409)
-- Name: BON_RECEPTION_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."BON_RECEPTION_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."BON_RECEPTION_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24805 (class 0 OID 0)
-- Dependencies: 767
-- Name: BON_RECEPTION_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."BON_RECEPTION_ID_seq" OWNED BY "OpenConcerto42"."BON_RECEPTION"."ID";


--
-- TOC entry 768 (class 1259 OID 6913411)
-- Name: CAISSE; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."CAISSE" (
    "ORDRE" numeric(16,8) DEFAULT 0,
    "ID" integer NOT NULL,
    "NOM" character varying(2048) DEFAULT ''::text,
    "ARCHIVE" integer DEFAULT 0,
    "NUMERO" character varying(2048) DEFAULT ''::text,
    "ID_DERNIERE_CLOTURE" integer
);


ALTER TABLE "OpenConcerto42"."CAISSE" OWNER TO openconcerto;

--
-- TOC entry 769 (class 1259 OID 6913421)
-- Name: CAISSE_CLOTURE; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."CAISSE_CLOTURE" (
    "ID" integer NOT NULL,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_ENTREE_JOURNAL" integer,
    "PERIODE" character varying(32) DEFAULT ''::character varying NOT NULL,
    "DEBUT" date NOT NULL,
    "FIN" date NOT NULL,
    "TOTAL_TTC" numeric(16,6) DEFAULT 0 NOT NULL,
    "PREMIER_TICKET" character varying(64) DEFAULT NULL::character varying,
    "PREMIER_TICKET_HASH" character varying(128) DEFAULT NULL::character varying,
    "DERNIER_TICKET" character varying(64) DEFAULT NULL::character varying,
    "DERNIER_TICKET_HASH" character varying(128) DEFAULT NULL::character varying,
    "ARCHIVE" integer DEFAULT 0 NOT NULL
);


ALTER TABLE "OpenConcerto42"."CAISSE_CLOTURE" OWNER TO openconcerto;

--
-- TOC entry 770 (class 1259 OID 6913433)
-- Name: CAISSE_CLOTURE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."CAISSE_CLOTURE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."CAISSE_CLOTURE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24806 (class 0 OID 0)
-- Dependencies: 770
-- Name: CAISSE_CLOTURE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."CAISSE_CLOTURE_ID_seq" OWNED BY "OpenConcerto42"."CAISSE_CLOTURE"."ID";


--
-- TOC entry 771 (class 1259 OID 6913435)
-- Name: CAISSE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."CAISSE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."CAISSE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24807 (class 0 OID 0)
-- Dependencies: 771
-- Name: CAISSE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."CAISSE_ID_seq" OWNED BY "OpenConcerto42"."CAISSE"."ID";


--
-- TOC entry 772 (class 1259 OID 6913437)
-- Name: CAISSE_JOURNAL; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."CAISSE_JOURNAL" (
    "ID" integer NOT NULL,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_CAISSE" integer DEFAULT 1,
    "DATE" timestamp without time zone,
    "ID_USER" integer DEFAULT 1,
    "EVT" character varying(128) DEFAULT ''::character varying NOT NULL,
    "CREATOR" character varying(128) DEFAULT ''::character varying NOT NULL,
    "CREATOR_VERSION" character varying(128) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "HOST_NAME" character varying(128),
    "HOST_USER" character varying(128)
);


ALTER TABLE "OpenConcerto42"."CAISSE_JOURNAL" OWNER TO openconcerto;

--
-- TOC entry 773 (class 1259 OID 6913451)
-- Name: CAISSE_JOURNAL_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."CAISSE_JOURNAL_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."CAISSE_JOURNAL_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24808 (class 0 OID 0)
-- Dependencies: 773
-- Name: CAISSE_JOURNAL_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."CAISSE_JOURNAL_ID_seq" OWNED BY "OpenConcerto42"."CAISSE_JOURNAL"."ID";


--
-- TOC entry 774 (class 1259 OID 6913453)
-- Name: CALENDAR_ITEM; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."CALENDAR_ITEM" (
    "ID" integer NOT NULL,
    "START" timestamp without time zone,
    "END" timestamp without time zone,
    "DURATION_S" bigint DEFAULT 0 NOT NULL,
    "SUMMARY" character varying(1024) DEFAULT ''::character varying NOT NULL,
    "DESCRIPTION" character varying(8192) DEFAULT ''::character varying NOT NULL,
    "FLAGS" character varying(1024) DEFAULT ''::character varying NOT NULL,
    "STATUS" character varying(128) DEFAULT ''::character varying NOT NULL,
    "ID_CALENDAR_ITEM_GROUP" integer DEFAULT 1,
    "SOURCE_ID" bigint,
    "SOURCE_TABLE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric,
    "UID" character varying(1024) DEFAULT ''::character varying NOT NULL,
    "LOCATION" character varying(4096) DEFAULT ''::character varying NOT NULL
);


ALTER TABLE "OpenConcerto42"."CALENDAR_ITEM" OWNER TO openconcerto;

--
-- TOC entry 775 (class 1259 OID 6913470)
-- Name: CALENDAR_ITEM_GROUP; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."CALENDAR_ITEM_GROUP" (
    "ID" integer NOT NULL,
    "NAME" character varying(1024) DEFAULT ''::character varying NOT NULL,
    "DESCRIPTION" character varying(8192) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "OpenConcerto42"."CALENDAR_ITEM_GROUP" OWNER TO openconcerto;

--
-- TOC entry 776 (class 1259 OID 6913480)
-- Name: CALENDAR_ITEM_GROUP_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."CALENDAR_ITEM_GROUP_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."CALENDAR_ITEM_GROUP_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24809 (class 0 OID 0)
-- Dependencies: 776
-- Name: CALENDAR_ITEM_GROUP_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."CALENDAR_ITEM_GROUP_ID_seq" OWNED BY "OpenConcerto42"."CALENDAR_ITEM_GROUP"."ID";


--
-- TOC entry 777 (class 1259 OID 6913482)
-- Name: CALENDAR_ITEM_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."CALENDAR_ITEM_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."CALENDAR_ITEM_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24810 (class 0 OID 0)
-- Dependencies: 777
-- Name: CALENDAR_ITEM_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."CALENDAR_ITEM_ID_seq" OWNED BY "OpenConcerto42"."CALENDAR_ITEM"."ID";


--
-- TOC entry 778 (class 1259 OID 6913484)
-- Name: CATEGORIE_CLIENT; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."CATEGORIE_CLIENT" (
    "ID" integer NOT NULL,
    "NOM" character varying(1024) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "OpenConcerto42"."CATEGORIE_CLIENT" OWNER TO openconcerto;

--
-- TOC entry 779 (class 1259 OID 6913493)
-- Name: CATEGORIE_CLIENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."CATEGORIE_CLIENT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."CATEGORIE_CLIENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24811 (class 0 OID 0)
-- Dependencies: 779
-- Name: CATEGORIE_CLIENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."CATEGORIE_CLIENT_ID_seq" OWNED BY "OpenConcerto42"."CATEGORIE_CLIENT"."ID";


--
-- TOC entry 780 (class 1259 OID 6913495)
-- Name: CATEGORIE_COMPTABLE; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."CATEGORIE_COMPTABLE" (
    "ID" integer NOT NULL,
    "NOM" character varying(128) DEFAULT ''::character varying NOT NULL,
    "ID_TAXE_VENTE" integer DEFAULT 1,
    "ID_TAXE_ACHAT" integer DEFAULT 1,
    "ID_COMPTE_PCE_VENTE" integer DEFAULT 1,
    "ID_COMPTE_PCE_ACHAT" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8)
);


ALTER TABLE "OpenConcerto42"."CATEGORIE_COMPTABLE" OWNER TO openconcerto;

--
-- TOC entry 781 (class 1259 OID 6913504)
-- Name: CATEGORIE_COMPTABLE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."CATEGORIE_COMPTABLE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."CATEGORIE_COMPTABLE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24812 (class 0 OID 0)
-- Dependencies: 781
-- Name: CATEGORIE_COMPTABLE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."CATEGORIE_COMPTABLE_ID_seq" OWNED BY "OpenConcerto42"."CATEGORIE_COMPTABLE"."ID";


--
-- TOC entry 782 (class 1259 OID 6913506)
-- Name: CHEQUE_AVOIR_CLIENT; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."CHEQUE_AVOIR_CLIENT" (
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "DATE_MIN_DECAISSE" date,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "DECAISSE" boolean DEFAULT false,
    "DATE_AVOIR" date,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ID_MOUVEMENT" integer DEFAULT 1,
    "NUMERO" character varying(2048) DEFAULT ''::text,
    "CREATION_DATE" timestamp without time zone,
    "DATE" date,
    "ID_CLIENT" integer DEFAULT 1,
    "ID" integer NOT NULL,
    "DATE_DECAISSE" date,
    "ARCHIVE" integer DEFAULT 0,
    "REG_COMPTA" boolean DEFAULT false,
    "ETS" character varying(2048) DEFAULT ''::text,
    "MONTANT" bigint DEFAULT 0,
    "ID_BANQUE" integer DEFAULT 1
);


ALTER TABLE "OpenConcerto42"."CHEQUE_AVOIR_CLIENT" OWNER TO openconcerto;

--
-- TOC entry 783 (class 1259 OID 6913524)
-- Name: CHEQUE_AVOIR_CLIENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."CHEQUE_AVOIR_CLIENT_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."CHEQUE_AVOIR_CLIENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24813 (class 0 OID 0)
-- Dependencies: 783
-- Name: CHEQUE_AVOIR_CLIENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."CHEQUE_AVOIR_CLIENT_ID_seq" OWNED BY "OpenConcerto42"."CHEQUE_AVOIR_CLIENT"."ID";


--
-- TOC entry 784 (class 1259 OID 6913526)
-- Name: CHEQUE_A_ENCAISSER; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."CHEQUE_A_ENCAISSER" (
    "ORDRE" numeric(16,8),
    "NUMERO" character varying(2048) DEFAULT ''::text,
    "DATE_MIN_DEPOT" date,
    "DATE_VENTE" date,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ENCAISSE" boolean DEFAULT false,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "ID_MOUVEMENT" integer DEFAULT 1,
    "DATE" date,
    "ETS" character varying(2048) DEFAULT ''::text,
    "MONTANT" bigint DEFAULT 0,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID" integer NOT NULL,
    "ID_CLIENT" integer DEFAULT 1,
    "REG_COMPTA" boolean DEFAULT false,
    "DATE_DEPOT" date,
    "ID_BANQUE" integer DEFAULT 1,
    "SANS_VALEUR_ENCAISSEMENT" boolean DEFAULT false NOT NULL,
    "TIERS" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ID_COMPTE_PCE_TIERS" integer DEFAULT 1
);


ALTER TABLE "OpenConcerto42"."CHEQUE_A_ENCAISSER" OWNER TO openconcerto;

--
-- TOC entry 785 (class 1259 OID 6913546)
-- Name: CHEQUE_A_ENCAISSER_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."CHEQUE_A_ENCAISSER_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."CHEQUE_A_ENCAISSER_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24814 (class 0 OID 0)
-- Dependencies: 785
-- Name: CHEQUE_A_ENCAISSER_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."CHEQUE_A_ENCAISSER_ID_seq" OWNED BY "OpenConcerto42"."CHEQUE_A_ENCAISSER"."ID";


--
-- TOC entry 786 (class 1259 OID 6913548)
-- Name: CHEQUE_FOURNISSEUR; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."CHEQUE_FOURNISSEUR" (
    "ORDRE" numeric(16,8),
    "ETS" character varying(2048) DEFAULT ''::text,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID" integer NOT NULL,
    "DATE_MIN_DECAISSE" date,
    "DATE_ACHAT" date,
    "CREATION_DATE" timestamp without time zone,
    "MONTANT" bigint DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0,
    "NUMERO" character varying(2048) DEFAULT ''::text,
    "DATE_DECAISSE" date,
    "DATE" date,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ID_FOURNISSEUR" integer DEFAULT 1,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "DECAISSE" boolean DEFAULT false,
    "ID_MOUVEMENT" integer DEFAULT 1,
    "REG_COMPTA" boolean DEFAULT false,
    "ID_BANQUE" integer DEFAULT 1,
    "SANS_VALEUR_ENCAISSEMENT" boolean DEFAULT false NOT NULL
);


ALTER TABLE "OpenConcerto42"."CHEQUE_FOURNISSEUR" OWNER TO openconcerto;

--
-- TOC entry 787 (class 1259 OID 6913566)
-- Name: CHEQUE_FOURNISSEUR_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."CHEQUE_FOURNISSEUR_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."CHEQUE_FOURNISSEUR_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24815 (class 0 OID 0)
-- Dependencies: 787
-- Name: CHEQUE_FOURNISSEUR_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."CHEQUE_FOURNISSEUR_ID_seq" OWNED BY "OpenConcerto42"."CHEQUE_FOURNISSEUR"."ID";


--
-- TOC entry 788 (class 1259 OID 6913568)
-- Name: CHIFFRAGE_COMMANDE_CLIENT; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."CHIFFRAGE_COMMANDE_CLIENT" (
    "ID" integer NOT NULL,
    "NOM" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ID_COMMANDE_CLIENT" integer DEFAULT 1,
    "ID_UNITE_VENTE" integer DEFAULT 1,
    "ID_FAMILLE_ARTICLE" integer DEFAULT 1,
    "QTE" numeric(16,8) DEFAULT 0 NOT NULL,
    "PA_HT" numeric(16,8) DEFAULT 0 NOT NULL,
    "PV_HT" numeric(16,8) DEFAULT 0 NOT NULL,
    "T_PV_HT" numeric(16,8) DEFAULT 0 NOT NULL,
    "T_PA_HT" numeric(16,8) DEFAULT 0 NOT NULL,
    "MARGE" numeric(16,8) DEFAULT 0 NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8)
);


ALTER TABLE "OpenConcerto42"."CHIFFRAGE_COMMANDE_CLIENT" OWNER TO openconcerto;

--
-- TOC entry 789 (class 1259 OID 6913582)
-- Name: CHIFFRAGE_COMMANDE_CLIENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."CHIFFRAGE_COMMANDE_CLIENT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."CHIFFRAGE_COMMANDE_CLIENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24816 (class 0 OID 0)
-- Dependencies: 789
-- Name: CHIFFRAGE_COMMANDE_CLIENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."CHIFFRAGE_COMMANDE_CLIENT_ID_seq" OWNED BY "OpenConcerto42"."CHIFFRAGE_COMMANDE_CLIENT"."ID";


--
-- TOC entry 790 (class 1259 OID 6913584)
-- Name: CLASSEMENT_CONVENTIONNEL; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."CLASSEMENT_CONVENTIONNEL" (
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ID" integer NOT NULL,
    "COEFF" character varying(45) DEFAULT ''::character varying,
    "ECHELON" character varying(45) DEFAULT ''::character varying,
    "NIVEAU" character varying(45) DEFAULT ''::character varying,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "POSITION" character varying(45) DEFAULT ''::character varying,
    "CREATION_DATE" timestamp without time zone,
    "INDICE" character varying(45) DEFAULT ''::character varying,
    "ORDRE" numeric(16,8)
);


ALTER TABLE "OpenConcerto42"."CLASSEMENT_CONVENTIONNEL" OWNER TO openconcerto;

--
-- TOC entry 791 (class 1259 OID 6913595)
-- Name: CLASSEMENT_CONVENTIONNEL_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."CLASSEMENT_CONVENTIONNEL_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."CLASSEMENT_CONVENTIONNEL_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24817 (class 0 OID 0)
-- Dependencies: 791
-- Name: CLASSEMENT_CONVENTIONNEL_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."CLASSEMENT_CONVENTIONNEL_ID_seq" OWNED BY "OpenConcerto42"."CLASSEMENT_CONVENTIONNEL"."ID";


--
-- TOC entry 792 (class 1259 OID 6913597)
-- Name: CLASSE_COMPTE; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."CLASSE_COMPTE" (
    "CREATION_DATE" timestamp without time zone,
    "NOM" character varying(2048) DEFAULT ''::text,
    "ORDRE" numeric(16,8),
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "TYPE_NUMERO_COMPTE" character varying(2048) DEFAULT ''::text,
    "ID" integer NOT NULL,
    "ARCHIVE" integer DEFAULT 0,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1
);


ALTER TABLE "OpenConcerto42"."CLASSE_COMPTE" OWNER TO openconcerto;

--
-- TOC entry 793 (class 1259 OID 6913608)
-- Name: CLASSE_COMPTE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."CLASSE_COMPTE_ID_seq"
    START WITH 12
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."CLASSE_COMPTE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24818 (class 0 OID 0)
-- Dependencies: 793
-- Name: CLASSE_COMPTE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."CLASSE_COMPTE_ID_seq" OWNED BY "OpenConcerto42"."CLASSE_COMPTE"."ID";


--
-- TOC entry 794 (class 1259 OID 6913610)
-- Name: CLIENT; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."CLIENT" (
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "TEL_TECH" character varying(100) DEFAULT ''::character varying,
    "TEL_P_COM" character varying(100) DEFAULT ''::character varying,
    "MAIL_TECH" character varying(100) DEFAULT ''::character varying,
    "NUMERO_TVA" character varying(100) DEFAULT ''::character varying,
    "TEL_COM" character varying(100) DEFAULT ''::character varying,
    "FAX_TECH" character varying(100) DEFAULT ''::character varying,
    "ID_MODE_REGLEMENT" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "MAX_FACTURE" bigint DEFAULT 0,
    "ID_COMPTE_PCE" integer DEFAULT 1,
    "ORDRE" numeric(16,8),
    "AFFACTURAGE" boolean DEFAULT false,
    "RIB" character varying(2048) DEFAULT ''::text,
    "ARCHIVE" integer DEFAULT 0,
    "ID_ADRESSE_F" integer DEFAULT 1,
    "COMPTE_CLIENT_AUTO" boolean DEFAULT false,
    "MAIL_COM" character varying(100) DEFAULT ''::character varying,
    "FAX_COM" character varying(100) DEFAULT ''::character varying,
    "FAX" character varying(100) DEFAULT ''::character varying,
    "RESPONSABLE_COM" character varying(100) DEFAULT ''::character varying,
    "TEL_P" character varying(100) DEFAULT ''::character varying,
    "RESPONSABLE_TECH" character varying(100) DEFAULT ''::character varying,
    "ID" integer NOT NULL,
    "TEL" character varying(100) DEFAULT ''::character varying,
    "TEL_P_TECH" character varying(100) DEFAULT ''::character varying,
    "RESPONSABLE" character varying(100) DEFAULT ''::character varying,
    "COMPTANT" boolean DEFAULT false,
    "ID_ADRESSE_L" integer DEFAULT 1,
    "INFOS" character varying(2048) DEFAULT ''::text,
    "CREATION_DATE" timestamp without time zone,
    "MAIL" character varying(100) DEFAULT ''::character varying,
    "ID_ADRESSE" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "MARCHE_PUBLIC" boolean DEFAULT false,
    "MARCHE_PRIVE" boolean DEFAULT false,
    "FORME_JURIDIQUE" character varying(2048) DEFAULT ''::text,
    "CODE" character varying(2048) DEFAULT ''::text,
    "NOM" character varying(2048) DEFAULT ''::text,
    "SIRET" character varying(2048) DEFAULT ''::text,
    "ID_TARIF" integer DEFAULT 1,
    "ID_PAYS" integer DEFAULT 1,
    "ID_LANGUE" integer DEFAULT 1,
    "ID_DEVISE" integer DEFAULT 1,
    "BLOQUE_LIVRAISON" boolean DEFAULT false NOT NULL,
    "BLOQUE" boolean DEFAULT false NOT NULL,
    "ID_COMPTE_PCE_SERVICE" integer DEFAULT 1,
    "ID_COMPTE_PCE_PRODUIT" integer DEFAULT 1,
    "ENCOURS_MAX" numeric(16,2) DEFAULT 0 NOT NULL,
    "CATEGORIES" character varying(2048) DEFAULT ''::character varying NOT NULL,
    "NOTE_FINANCIERE" character varying(1024) DEFAULT ''::character varying NOT NULL,
    "CENTRE_GESTION" character varying(1024) DEFAULT ''::character varying NOT NULL,
    "METHODE_RELANCE" character varying(1024) DEFAULT ''::character varying NOT NULL,
    "SITE_INTERNET" character varying(2048) DEFAULT ''::character varying NOT NULL,
    "GROUPE" character varying(1024) DEFAULT ''::character varying NOT NULL,
    "ID_COMMERCIAL" integer DEFAULT 1,
    "TIMBRE_FISCAL" boolean DEFAULT false NOT NULL,
    "OBSOLETE" boolean DEFAULT false NOT NULL,
    "REMIND_DATE" timestamp without time zone,
    "SOLDE_COMPTE" numeric(16,6) DEFAULT 0 NOT NULL,
    "ATTACHMENTS" integer DEFAULT 0 NOT NULL,
    "COMMENTAIRES" character varying(2048) DEFAULT ''::character varying NOT NULL,
    "CODE_FOURNISSEUR" character varying(256) DEFAULT ''::character varying NOT NULL,
    "CONDITIONS_LIVRAISON" character varying(512) DEFAULT ''::character varying NOT NULL,
    "DATE" date,
    "IBAN" character varying(128) DEFAULT ''::character varying NOT NULL,
    "BIC" character varying(128) DEFAULT ''::character varying NOT NULL,
    "ACCEPTE_EMAIL" boolean DEFAULT false NOT NULL,
    "ACCEPTE_COURRIER" boolean DEFAULT false NOT NULL,
    "ACCEPTE_SMS" boolean DEFAULT false NOT NULL,
    "ACCEPTE_TEL" boolean DEFAULT false NOT NULL,
    "ID_FRAIS_DOCUMENT" integer DEFAULT 1,
    "ID_CATEGORIE_COMPTABLE" integer DEFAULT 1,
    "ID_SEPA_MANDATE_DEFAULT" integer,
    "ALERTE" character varying(4096) DEFAULT ''::character varying NOT NULL,
    "INTERFEL" boolean DEFAULT false NOT NULL
);


ALTER TABLE "OpenConcerto42"."CLIENT" OWNER TO openconcerto;

--
-- TOC entry 795 (class 1259 OID 6913684)
-- Name: CLIENT_DEPARTEMENT; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."CLIENT_DEPARTEMENT" (
    "ID" integer NOT NULL,
    "ID_CLIENT" integer DEFAULT 1,
    "ID_ADRESSE" integer DEFAULT 1,
    "INFOS" character varying(2048) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "OpenConcerto42"."CLIENT_DEPARTEMENT" OWNER TO openconcerto;

--
-- TOC entry 796 (class 1259 OID 6913696)
-- Name: CLIENT_DEPARTEMENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."CLIENT_DEPARTEMENT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."CLIENT_DEPARTEMENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24819 (class 0 OID 0)
-- Dependencies: 796
-- Name: CLIENT_DEPARTEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."CLIENT_DEPARTEMENT_ID_seq" OWNED BY "OpenConcerto42"."CLIENT_DEPARTEMENT"."ID";


--
-- TOC entry 797 (class 1259 OID 6913698)
-- Name: CLIENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."CLIENT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."CLIENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24820 (class 0 OID 0)
-- Dependencies: 797
-- Name: CLIENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."CLIENT_ID_seq" OWNED BY "OpenConcerto42"."CLIENT"."ID";


--
-- TOC entry 798 (class 1259 OID 6913700)
-- Name: CODE_CARACT_ACTIVITE; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."CODE_CARACT_ACTIVITE" (
    "CREATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "NOM" character varying(45) DEFAULT ''::character varying,
    "ORDRE" numeric(16,8),
    "ARCHIVE" integer DEFAULT 0,
    "CODE" character varying(5) DEFAULT ''::character varying,
    "ID" integer NOT NULL,
    "MODIFICATION_DATE" timestamp without time zone
);


ALTER TABLE "OpenConcerto42"."CODE_CARACT_ACTIVITE" OWNER TO openconcerto;

--
-- TOC entry 799 (class 1259 OID 6913708)
-- Name: CODE_CARACT_ACTIVITE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."CODE_CARACT_ACTIVITE_ID_seq"
    START WITH 12
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."CODE_CARACT_ACTIVITE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24821 (class 0 OID 0)
-- Dependencies: 799
-- Name: CODE_CARACT_ACTIVITE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."CODE_CARACT_ACTIVITE_ID_seq" OWNED BY "OpenConcerto42"."CODE_CARACT_ACTIVITE"."ID";


--
-- TOC entry 800 (class 1259 OID 6913710)
-- Name: CODE_CONTRAT_TRAVAIL; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."CODE_CONTRAT_TRAVAIL" (
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "ID" integer NOT NULL,
    "CODE" character varying(5) DEFAULT ''::character varying,
    "ORDRE" numeric(16,8),
    "ARCHIVE" integer DEFAULT 0,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "NOM" character varying(128) DEFAULT ''::character varying
);


ALTER TABLE "OpenConcerto42"."CODE_CONTRAT_TRAVAIL" OWNER TO openconcerto;

--
-- TOC entry 801 (class 1259 OID 6913718)
-- Name: CODE_CONTRAT_TRAVAIL_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."CODE_CONTRAT_TRAVAIL_ID_seq"
    START WITH 14
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."CODE_CONTRAT_TRAVAIL_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24822 (class 0 OID 0)
-- Dependencies: 801
-- Name: CODE_CONTRAT_TRAVAIL_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."CODE_CONTRAT_TRAVAIL_ID_seq" OWNED BY "OpenConcerto42"."CODE_CONTRAT_TRAVAIL"."ID";


--
-- TOC entry 802 (class 1259 OID 6913720)
-- Name: CODE_DROIT_CONTRAT; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."CODE_DROIT_CONTRAT" (
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CODE" character varying(4) DEFAULT ''::character varying,
    "CREATION_DATE" timestamp without time zone,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID" integer NOT NULL,
    "ARCHIVE" integer DEFAULT 0,
    "NOM" character varying(45) DEFAULT ''::character varying,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ORDRE" numeric(16,8)
);


ALTER TABLE "OpenConcerto42"."CODE_DROIT_CONTRAT" OWNER TO openconcerto;

--
-- TOC entry 803 (class 1259 OID 6913728)
-- Name: CODE_DROIT_CONTRAT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."CODE_DROIT_CONTRAT_ID_seq"
    START WITH 4
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."CODE_DROIT_CONTRAT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24823 (class 0 OID 0)
-- Dependencies: 803
-- Name: CODE_DROIT_CONTRAT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."CODE_DROIT_CONTRAT_ID_seq" OWNED BY "OpenConcerto42"."CODE_DROIT_CONTRAT"."ID";


--
-- TOC entry 804 (class 1259 OID 6913730)
-- Name: CODE_EMPLOI; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."CODE_EMPLOI" (
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ORDRE" numeric(16,8),
    "CODE" character varying(11) DEFAULT ''::character varying,
    "ID" integer NOT NULL,
    "NOM" character varying(195) DEFAULT ''::character varying,
    "CREATION_DATE" timestamp without time zone,
    "MODIFICATION_DATE" timestamp without time zone
);


ALTER TABLE "OpenConcerto42"."CODE_EMPLOI" OWNER TO openconcerto;

--
-- TOC entry 805 (class 1259 OID 6913738)
-- Name: CODE_EMPLOI_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."CODE_EMPLOI_ID_seq"
    START WITH 1036
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."CODE_EMPLOI_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24824 (class 0 OID 0)
-- Dependencies: 805
-- Name: CODE_EMPLOI_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."CODE_EMPLOI_ID_seq" OWNED BY "OpenConcerto42"."CODE_EMPLOI"."ID";


--
-- TOC entry 806 (class 1259 OID 6913740)
-- Name: CODE_FOURNISSEUR; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."CODE_FOURNISSEUR" (
    "ID" integer NOT NULL,
    "CODE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ID_FOURNISSEUR" integer DEFAULT 1,
    "ID_ARTICLE" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "OpenConcerto42"."CODE_FOURNISSEUR" OWNER TO openconcerto;

--
-- TOC entry 807 (class 1259 OID 6913748)
-- Name: CODE_FOURNISSEUR_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."CODE_FOURNISSEUR_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."CODE_FOURNISSEUR_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24825 (class 0 OID 0)
-- Dependencies: 807
-- Name: CODE_FOURNISSEUR_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."CODE_FOURNISSEUR_ID_seq" OWNED BY "OpenConcerto42"."CODE_FOURNISSEUR"."ID";


--
-- TOC entry 808 (class 1259 OID 6913750)
-- Name: CODE_PENIBILITE_CONTRAT_SALARIE; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."CODE_PENIBILITE_CONTRAT_SALARIE" (
    "ID" integer NOT NULL,
    "ID_INFOS_SALARIE_PAYE" integer DEFAULT 1,
    "ID_CODE_PENIBILITE" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "OpenConcerto42"."CODE_PENIBILITE_CONTRAT_SALARIE" OWNER TO openconcerto;

--
-- TOC entry 809 (class 1259 OID 6913757)
-- Name: CODE_PENIBILITE_CONTRAT_SALARIE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."CODE_PENIBILITE_CONTRAT_SALARIE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."CODE_PENIBILITE_CONTRAT_SALARIE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24826 (class 0 OID 0)
-- Dependencies: 809
-- Name: CODE_PENIBILITE_CONTRAT_SALARIE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."CODE_PENIBILITE_CONTRAT_SALARIE_ID_seq" OWNED BY "OpenConcerto42"."CODE_PENIBILITE_CONTRAT_SALARIE"."ID";


--
-- TOC entry 810 (class 1259 OID 6913759)
-- Name: CODE_REGIME; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."CODE_REGIME" (
    "CREATION_DATE" timestamp without time zone,
    "NOM" character varying(100) DEFAULT ''::character varying,
    "ORDRE" numeric(16,8),
    "ID" integer NOT NULL,
    "MODIFICATION_DATE" timestamp without time zone,
    "CODE" character varying(4) DEFAULT ''::character varying,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1
);


ALTER TABLE "OpenConcerto42"."CODE_REGIME" OWNER TO openconcerto;

--
-- TOC entry 811 (class 1259 OID 6913767)
-- Name: CODE_REGIME_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."CODE_REGIME_ID_seq"
    START WITH 23
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."CODE_REGIME_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24827 (class 0 OID 0)
-- Dependencies: 811
-- Name: CODE_REGIME_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."CODE_REGIME_ID_seq" OWNED BY "OpenConcerto42"."CODE_REGIME"."ID";


--
-- TOC entry 812 (class 1259 OID 6913769)
-- Name: CODE_STATUT_CATEGORIEL; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."CODE_STATUT_CATEGORIEL" (
    "ARCHIVE" integer DEFAULT 0,
    "NOM" character varying(45) DEFAULT ''::character varying,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CODE" character varying(5) DEFAULT ''::character varying,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID" integer NOT NULL,
    "CREATION_DATE" timestamp without time zone,
    "MODIFICATION_DATE" timestamp without time zone,
    "ORDRE" numeric(16,8)
);


ALTER TABLE "OpenConcerto42"."CODE_STATUT_CATEGORIEL" OWNER TO openconcerto;

--
-- TOC entry 813 (class 1259 OID 6913777)
-- Name: CODE_STATUT_CATEGORIEL_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."CODE_STATUT_CATEGORIEL_ID_seq"
    START WITH 6
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."CODE_STATUT_CATEGORIEL_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24828 (class 0 OID 0)
-- Dependencies: 813
-- Name: CODE_STATUT_CATEGORIEL_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."CODE_STATUT_CATEGORIEL_ID_seq" OWNED BY "OpenConcerto42"."CODE_STATUT_CATEGORIEL"."ID";


--
-- TOC entry 814 (class 1259 OID 6913779)
-- Name: CODE_STATUT_CAT_CONV; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."CODE_STATUT_CAT_CONV" (
    "ID" integer NOT NULL,
    "CODE" character varying(6) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "OpenConcerto42"."CODE_STATUT_CAT_CONV" OWNER TO openconcerto;

--
-- TOC entry 815 (class 1259 OID 6913786)
-- Name: CODE_STATUT_CAT_CONV_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."CODE_STATUT_CAT_CONV_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."CODE_STATUT_CAT_CONV_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24829 (class 0 OID 0)
-- Dependencies: 815
-- Name: CODE_STATUT_CAT_CONV_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."CODE_STATUT_CAT_CONV_ID_seq" OWNED BY "OpenConcerto42"."CODE_STATUT_CAT_CONV"."ID";


--
-- TOC entry 816 (class 1259 OID 6913788)
-- Name: CODE_STATUT_PROF; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."CODE_STATUT_PROF" (
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ORDRE" numeric(16,8),
    "NOM" character varying(256) DEFAULT ''::character varying,
    "ID" integer NOT NULL,
    "ARCHIVE" integer DEFAULT 0,
    "CREATION_DATE" timestamp without time zone,
    "CODE" character varying(5) DEFAULT ''::character varying,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone
);


ALTER TABLE "OpenConcerto42"."CODE_STATUT_PROF" OWNER TO openconcerto;

--
-- TOC entry 817 (class 1259 OID 6913796)
-- Name: CODE_STATUT_PROF_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."CODE_STATUT_PROF_ID_seq"
    START WITH 51
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."CODE_STATUT_PROF_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24830 (class 0 OID 0)
-- Dependencies: 817
-- Name: CODE_STATUT_PROF_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."CODE_STATUT_PROF_ID_seq" OWNED BY "OpenConcerto42"."CODE_STATUT_PROF"."ID";


--
-- TOC entry 818 (class 1259 OID 6913798)
-- Name: COEFF_PRIME; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."COEFF_PRIME" (
    "ID" integer NOT NULL,
    "PRIME_PERSO" real DEFAULT 0,
    "PRIME_RECONSTRUCTION" real DEFAULT 0,
    "PRIME_ANCIENNETE" real DEFAULT 0,
    "PRIME_DEROULEMENT" real DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "OpenConcerto42"."COEFF_PRIME" OWNER TO openconcerto;

--
-- TOC entry 819 (class 1259 OID 6913807)
-- Name: COEFF_PRIME_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."COEFF_PRIME_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."COEFF_PRIME_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24831 (class 0 OID 0)
-- Dependencies: 819
-- Name: COEFF_PRIME_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."COEFF_PRIME_ID_seq" OWNED BY "OpenConcerto42"."COEFF_PRIME"."ID";


--
-- TOC entry 820 (class 1259 OID 6913809)
-- Name: COMMANDE; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."COMMANDE" (
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ID_FOURNISSEUR" integer DEFAULT 1,
    "DATE_ECHEANCE" date,
    "SOURCE" character varying(100) DEFAULT ''::character varying,
    "T_HT" bigint DEFAULT 0,
    "NOM" character varying(2048) DEFAULT ''::text,
    "INFOS" character varying(2048) DEFAULT ''::text,
    "T_TVA" bigint DEFAULT 0,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ORDRE" numeric(16,8),
    "DATE" date,
    "T_SERVICE" bigint DEFAULT 0,
    "NUMERO" character varying(45) DEFAULT ''::character varying,
    "ID_COMMERCIAL" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "ID" integer NOT NULL,
    "T_TTC" bigint DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0,
    "MODIFICATION_DATE" timestamp without time zone,
    "IDSOURCE" integer DEFAULT 1,
    "T_POIDS" real DEFAULT 0,
    "ID_DEVISE" integer DEFAULT 1,
    "T_DEVISE" bigint DEFAULT 0,
    "EN_COURS" boolean DEFAULT true,
    "ID_ADRESSE" integer DEFAULT 1,
    "ID_CLIENT" integer DEFAULT 1,
    "ID_MODELE" integer DEFAULT 1,
    "DATE_RECEPTION_DEMANDEE" date,
    "DATE_RECEPTION_CONFIRMEE" date,
    "T_ECO_CONTRIBUTION" bigint DEFAULT 0,
    "ID_TAXE_PORT" integer DEFAULT 1,
    "PORT_HT" bigint DEFAULT 0 NOT NULL,
    "REMISE_HT" bigint DEFAULT 0 NOT NULL,
    "ETAT_COMMANDE" integer DEFAULT 2 NOT NULL
);


ALTER TABLE "OpenConcerto42"."COMMANDE" OWNER TO openconcerto;

--
-- TOC entry 821 (class 1259 OID 6913841)
-- Name: COMMANDE_CLIENT; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."COMMANDE_CLIENT" (
    "MODIFICATION_DATE" timestamp without time zone,
    "T_POIDS" real DEFAULT 0,
    "INFOS" character varying(2048) DEFAULT ''::text,
    "ID" integer NOT NULL,
    "NUMERO" character varying(45) DEFAULT ''::character varying,
    "T_SERVICE" bigint DEFAULT 0,
    "ID_COMMERCIAL" integer DEFAULT 1,
    "DATE_ECHEANCE" date,
    "NOM" character varying(2048) DEFAULT ''::text,
    "ARCHIVE" integer DEFAULT 0,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "T_TTC" bigint DEFAULT 0,
    "T_TVA" bigint DEFAULT 0,
    "SOURCE" character varying(100) DEFAULT ''::character varying,
    "ORDRE" numeric(16,8),
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "T_HT" bigint DEFAULT 0,
    "ID_CLIENT" integer DEFAULT 1,
    "DATE" date,
    "CREATION_DATE" timestamp without time zone,
    "IDSOURCE" integer DEFAULT 1,
    "ID_DEVIS" integer DEFAULT 1,
    "T_DEVISE" bigint DEFAULT 0,
    "ID_TARIF" integer DEFAULT 1,
    "ID_MODELE" integer DEFAULT 1,
    "ID_ADRESSE" integer DEFAULT 1,
    "ID_ADRESSE_LIVRAISON" integer DEFAULT 1,
    "POURCENT_REMISE" numeric(12,8),
    "MONTANT_REMISE" numeric(16,8),
    "ID_CONTACT" integer DEFAULT 1,
    "ID_CLIENT_DEPARTEMENT" integer DEFAULT 1,
    "ETAT_COMMANDE" integer DEFAULT 1 NOT NULL,
    "EMBALLAGE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "NUMERO_EXPEDITION" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ID_TAXE_PORT" integer DEFAULT 1,
    "PORT_HT" bigint DEFAULT 0 NOT NULL,
    "REMISE_HT" bigint DEFAULT 0 NOT NULL,
    "TYPE_EXPEDITION" character varying(256) DEFAULT ''::character varying NOT NULL,
    "T_ECO_CONTRIBUTION" bigint DEFAULT 0,
    "DATE_LIVRAISON_PREV" date,
    "FRAIS_DOCUMENT_HT" bigint DEFAULT 0 NOT NULL,
    "ID_TAXE_FRAIS_DOCUMENT" integer DEFAULT 1,
    "ID_CATEGORIE_COMPTABLE" integer DEFAULT 1,
    "T_ACOMPTE" bigint DEFAULT 0 NOT NULL,
    "POURCENT_RG" numeric(6,2) DEFAULT 0,
    "MONTANT_INTERFEL_HT" bigint DEFAULT 0 NOT NULL
);


ALTER TABLE "OpenConcerto42"."COMMANDE_CLIENT" OWNER TO openconcerto;

--
-- TOC entry 822 (class 1259 OID 6913883)
-- Name: COMMANDE_CLIENT_ELEMENT; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."COMMANDE_CLIENT_ELEMENT" (
    "ORDRE" numeric(16,8),
    "PRIX_METRIQUE_VT_3" numeric(16,6) DEFAULT 0 NOT NULL,
    "NOM" character varying(2048) DEFAULT ''::character varying,
    "ID_MODE_VENTE_ARTICLE" integer DEFAULT 1,
    "PRIX_METRIQUE_HA_2" numeric(16,6) DEFAULT 0 NOT NULL,
    "ID_COMMANDE_CLIENT" integer DEFAULT 1,
    "ID" integer NOT NULL,
    "ID_METRIQUE_2" integer DEFAULT 1,
    "PRIX_METRIQUE_VT_1" numeric(16,6) DEFAULT 0 NOT NULL,
    "CREATION_DATE" timestamp without time zone,
    "ID_METRIQUE_1" integer DEFAULT 1,
    "PV_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "ID_TAXE" integer DEFAULT 1,
    "T_PA_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "QTE" integer DEFAULT 0,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "SERVICE" boolean DEFAULT false,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "T_PV_TTC" numeric(16,2) DEFAULT 0 NOT NULL,
    "VALEUR_METRIQUE_1" real DEFAULT 0,
    "CODE" character varying(45) DEFAULT ''::character varying,
    "POIDS" real DEFAULT 0,
    "T_PV_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "PA_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_METRIQUE_3" integer DEFAULT 1,
    "VALEUR_METRIQUE_3" real DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0,
    "VALEUR_METRIQUE_2" real DEFAULT 0,
    "PRIX_METRIQUE_HA_1" numeric(16,6) DEFAULT 0 NOT NULL,
    "T_POIDS" real DEFAULT 0,
    "ID_STYLE" integer DEFAULT 1,
    "PRIX_METRIQUE_VT_2" numeric(16,6) DEFAULT 0 NOT NULL,
    "PRIX_METRIQUE_HA_3" numeric(16,6) DEFAULT 0 NOT NULL,
    "QTE_ACHAT" integer DEFAULT 1,
    "CODE_DOUANIER" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ID_PAYS" integer DEFAULT 1,
    "ID_DEVISE" integer DEFAULT 1,
    "PV_U_DEVISE" numeric(16,6) DEFAULT 0 NOT NULL,
    "POURCENT_REMISE" numeric(12,8) DEFAULT 0,
    "PV_T_DEVISE" numeric(16,6) DEFAULT 0 NOT NULL,
    "TAUX_DEVISE" numeric(16,8) DEFAULT 1,
    "DESCRIPTIF" character varying(2048) DEFAULT ''::character varying NOT NULL,
    "MARGE_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "QTE_UNITAIRE" numeric(16,6) DEFAULT 1,
    "ID_UNITE_VENTE" integer DEFAULT 2,
    "ID_ARTICLE" integer DEFAULT 1,
    "POIDS_COLIS_NET" numeric(16,8) DEFAULT 0,
    "T_POIDS_COLIS_NET" numeric(16,8) DEFAULT 0,
    "NB_COLIS" integer DEFAULT 0,
    "MONTANT_REMISE" numeric(16,8),
    "ID_FAMILLE_ARTICLE" integer DEFAULT 1,
    "NIVEAU" integer DEFAULT 1 NOT NULL,
    "ID_ECO_CONTRIBUTION" integer DEFAULT 1,
    "ECO_CONTRIBUTION" numeric(16,2) DEFAULT 0,
    "T_ECO_CONTRIBUTION" numeric(16,2) DEFAULT 0,
    "LIVRE_FORCED" boolean DEFAULT false NOT NULL,
    "LIVRE" boolean DEFAULT false NOT NULL,
    "QTE_LIVREE" numeric(16,6) DEFAULT 0,
    "ID_DEPOT_STOCK" integer DEFAULT 1,
    "LONGUEUR" numeric(16,8),
    "LARGEUR" numeric(16,8),
    "HAUTEUR" numeric(16,8),
    "TARE" numeric(16,8),
    "T_POIDS_BRUT" numeric(16,8) DEFAULT 0,
    "ID_ARTICLE_DECLINAISON_TAILLE" integer DEFAULT 1,
    "ID_ARTICLE_DECLINAISON_COULEUR" integer DEFAULT 1
);


ALTER TABLE "OpenConcerto42"."COMMANDE_CLIENT_ELEMENT" OWNER TO openconcerto;

--
-- TOC entry 823 (class 1259 OID 6913947)
-- Name: COMMANDE_CLIENT_ELEMENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."COMMANDE_CLIENT_ELEMENT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."COMMANDE_CLIENT_ELEMENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24832 (class 0 OID 0)
-- Dependencies: 823
-- Name: COMMANDE_CLIENT_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."COMMANDE_CLIENT_ELEMENT_ID_seq" OWNED BY "OpenConcerto42"."COMMANDE_CLIENT_ELEMENT"."ID";


--
-- TOC entry 824 (class 1259 OID 6913949)
-- Name: COMMANDE_CLIENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."COMMANDE_CLIENT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."COMMANDE_CLIENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24833 (class 0 OID 0)
-- Dependencies: 824
-- Name: COMMANDE_CLIENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."COMMANDE_CLIENT_ID_seq" OWNED BY "OpenConcerto42"."COMMANDE_CLIENT"."ID";


--
-- TOC entry 825 (class 1259 OID 6913951)
-- Name: COMMANDE_ELEMENT; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."COMMANDE_ELEMENT" (
    "T_PA_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "VALEUR_METRIQUE_3" real DEFAULT 0,
    "ID_METRIQUE_1" integer DEFAULT 1,
    "CODE" character varying(45) DEFAULT ''::character varying,
    "CREATION_DATE" timestamp without time zone,
    "PRIX_METRIQUE_VT_2" numeric(16,6) DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8),
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "PV_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "PRIX_METRIQUE_HA_2" numeric(16,6) DEFAULT 0 NOT NULL,
    "VALEUR_METRIQUE_2" real DEFAULT 0,
    "PRIX_METRIQUE_VT_1" numeric(16,6) DEFAULT 0 NOT NULL,
    "T_PV_TTC" numeric(16,2) DEFAULT 0 NOT NULL,
    "PRIX_METRIQUE_HA_1" numeric(16,6) DEFAULT 0 NOT NULL,
    "ARCHIVE" integer DEFAULT 0,
    "SERVICE" boolean DEFAULT false,
    "T_POIDS" real DEFAULT 0,
    "T_PA_TTC" numeric(16,2) DEFAULT 0 NOT NULL,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ID_METRIQUE_3" integer DEFAULT 1,
    "PRIX_METRIQUE_HA_3" numeric(16,6) DEFAULT 0 NOT NULL,
    "T_PV_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "ID_MODE_VENTE_ARTICLE" integer DEFAULT 1,
    "NOM" character varying(2048) DEFAULT ''::character varying,
    "VALEUR_METRIQUE_1" real DEFAULT 0,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_TAXE" integer DEFAULT 1,
    "PA_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "ID_STYLE" integer DEFAULT 1,
    "QTE" integer DEFAULT 0,
    "PRIX_METRIQUE_VT_3" numeric(16,6) DEFAULT 0 NOT NULL,
    "POIDS" real DEFAULT 0,
    "ID_METRIQUE_2" integer DEFAULT 1,
    "ID_COMMANDE" integer DEFAULT 1,
    "ID" integer NOT NULL,
    "QTE_ACHAT" integer DEFAULT 1,
    "PA_DEVISE" numeric(16,6) DEFAULT 0 NOT NULL,
    "ID_DEVISE" integer DEFAULT 1,
    "PA_DEVISE_T" numeric(16,6) DEFAULT 0 NOT NULL,
    "QTE_UNITAIRE" numeric(16,6) DEFAULT 1,
    "ID_UNITE_VENTE" integer DEFAULT 2,
    "ID_ARTICLE" integer DEFAULT 1,
    "ID_CODE_FOURNISSEUR" integer DEFAULT 1,
    "DESCRIPTIF" character varying(2048) DEFAULT ''::character varying NOT NULL,
    "NIVEAU" integer DEFAULT 1 NOT NULL,
    "ID_ECO_CONTRIBUTION" integer DEFAULT 1,
    "ECO_CONTRIBUTION" numeric(16,2) DEFAULT 0,
    "T_ECO_CONTRIBUTION" numeric(16,2) DEFAULT 0,
    "RECU_FORCED" boolean DEFAULT false NOT NULL,
    "RECU" boolean DEFAULT false NOT NULL,
    "QTE_RECUE" numeric(16,6) DEFAULT 0,
    "ID_DEMANDE_ACHAT_ELEMENT" integer DEFAULT 1,
    "ID_FAMILLE_ARTICLE" integer DEFAULT 1,
    "ID_DEPOT_STOCK" integer DEFAULT 1,
    "LONGUEUR" numeric(16,8),
    "LARGEUR" numeric(16,8),
    "HAUTEUR" numeric(16,8),
    "POIDS_COLIS_NET" numeric(16,8) DEFAULT 0,
    "T_POIDS_COLIS_NET" numeric(16,8) DEFAULT 0,
    "NB_COLIS" integer DEFAULT 0,
    "TARE" numeric(16,8),
    "T_POIDS_BRUT" numeric(16,8) DEFAULT 0,
    "ID_ARTICLE_DECLINAISON_TAILLE" integer DEFAULT 1,
    "ID_ARTICLE_DECLINAISON_COULEUR" integer DEFAULT 1
);


ALTER TABLE "OpenConcerto42"."COMMANDE_ELEMENT" OWNER TO openconcerto;

--
-- TOC entry 826 (class 1259 OID 6914013)
-- Name: COMMANDE_ELEMENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."COMMANDE_ELEMENT_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."COMMANDE_ELEMENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24834 (class 0 OID 0)
-- Dependencies: 826
-- Name: COMMANDE_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."COMMANDE_ELEMENT_ID_seq" OWNED BY "OpenConcerto42"."COMMANDE_ELEMENT"."ID";


--
-- TOC entry 827 (class 1259 OID 6914015)
-- Name: COMMANDE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."COMMANDE_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."COMMANDE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24835 (class 0 OID 0)
-- Dependencies: 827
-- Name: COMMANDE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."COMMANDE_ID_seq" OWNED BY "OpenConcerto42"."COMMANDE"."ID";


--
-- TOC entry 828 (class 1259 OID 6914017)
-- Name: COMMERCIAL; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."COMMERCIAL" (
    "FONCTION" character varying(100) DEFAULT ''::character varying,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ORDRE" numeric(16,8),
    "FAX" character varying(100) DEFAULT ''::character varying,
    "MODIFICATION_DATE" timestamp without time zone,
    "ARCHIVE" integer DEFAULT 0,
    "NOM" character varying(100) DEFAULT ''::character varying,
    "CREATION_DATE" timestamp without time zone,
    "TEL_MOBILE" character varying(100) DEFAULT ''::character varying,
    "ID_COMMERCIAL" integer NOT NULL,
    "TEL_STANDARD" character varying(100) DEFAULT ''::character varying,
    "PRENOM" character varying(100) DEFAULT ''::character varying,
    "ID_TITRE_PERSONNEL" integer DEFAULT 1,
    "TEL_DIRECT" character varying(100) DEFAULT ''::character varying,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "EMAIL" character varying(100) DEFAULT ''::character varying,
    "ID_USER_COMMON" integer DEFAULT 1,
    "TEL_PERSONEL" character varying(100) DEFAULT ''::character varying
);


ALTER TABLE "OpenConcerto42"."COMMERCIAL" OWNER TO openconcerto;

--
-- TOC entry 829 (class 1259 OID 6914037)
-- Name: COMMERCIAL_ID_COMMERCIAL_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."COMMERCIAL_ID_COMMERCIAL_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."COMMERCIAL_ID_COMMERCIAL_seq" OWNER TO openconcerto;

--
-- TOC entry 24836 (class 0 OID 0)
-- Dependencies: 829
-- Name: COMMERCIAL_ID_COMMERCIAL_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."COMMERCIAL_ID_COMMERCIAL_seq" OWNED BY "OpenConcerto42"."COMMERCIAL"."ID_COMMERCIAL";


--
-- TOC entry 830 (class 1259 OID 6914039)
-- Name: COMPLETION; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."COMPLETION" (
    "CHAMP" character varying(100) DEFAULT ''::character varying NOT NULL,
    "LABEL" character varying(200) DEFAULT ''::character varying NOT NULL
);


ALTER TABLE "OpenConcerto42"."COMPLETION" OWNER TO openconcerto;

--
-- TOC entry 831 (class 1259 OID 6914044)
-- Name: COMPTE_CLIENT_TRANSACTION; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."COMPTE_CLIENT_TRANSACTION" (
    "ID" integer NOT NULL,
    "ID_CLIENT" integer DEFAULT 1,
    "DATE" timestamp without time zone,
    "MONTANT" numeric(16,6) DEFAULT 0 NOT NULL,
    "ID_MODE_REGLEMENT" integer DEFAULT 1,
    "ID_MOUVEMENT" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "OpenConcerto42"."COMPTE_CLIENT_TRANSACTION" OWNER TO openconcerto;

--
-- TOC entry 832 (class 1259 OID 6914053)
-- Name: COMPTE_CLIENT_TRANSACTION_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."COMPTE_CLIENT_TRANSACTION_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."COMPTE_CLIENT_TRANSACTION_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24837 (class 0 OID 0)
-- Dependencies: 832
-- Name: COMPTE_CLIENT_TRANSACTION_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."COMPTE_CLIENT_TRANSACTION_ID_seq" OWNED BY "OpenConcerto42"."COMPTE_CLIENT_TRANSACTION"."ID";


--
-- TOC entry 833 (class 1259 OID 6914055)
-- Name: COMPTE_PCE; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."COMPTE_PCE" (
    "CREATION_DATE" timestamp without time zone,
    "ID_NATURE_COMPTE" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "TOTAL_CREDIT" bigint DEFAULT 0,
    "INFOS" character varying(3072) DEFAULT ''::text,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "NUMERO" character varying(2048) DEFAULT ''::text,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "NOM" character varying(2048) DEFAULT ''::text,
    "TOTAL_DEBIT" bigint DEFAULT 0,
    "ORDRE" numeric(16,8),
    "RACINE" boolean DEFAULT false,
    "ARCHIVE" integer DEFAULT 0,
    "ID" integer NOT NULL,
    "OBSOLETE" boolean DEFAULT false NOT NULL
);


ALTER TABLE "OpenConcerto42"."COMPTE_PCE" OWNER TO openconcerto;

--
-- TOC entry 834 (class 1259 OID 6914072)
-- Name: COMPTE_PCE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."COMPTE_PCE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."COMPTE_PCE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24838 (class 0 OID 0)
-- Dependencies: 834
-- Name: COMPTE_PCE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."COMPTE_PCE_ID_seq" OWNED BY "OpenConcerto42"."COMPTE_PCE"."ID";


--
-- TOC entry 835 (class 1259 OID 6914074)
-- Name: COMPTE_PCG; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."COMPTE_PCG" (
    "ARCHIVE" integer DEFAULT 0,
    "ID_TYPE_COMPTE_PCG_BASE" integer DEFAULT 1,
    "NUMERO" character varying(2048) DEFAULT ''::text,
    "ID_NATURE_COMPTE" integer DEFAULT 1,
    "ID" integer NOT NULL,
    "INFOS" character varying(3072) DEFAULT ''::text,
    "CREATION_DATE" timestamp without time zone,
    "NOM" character varying(2048) DEFAULT ''::text,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_TYPE_COMPTE_PCG_DEV" integer DEFAULT 1,
    "ORDRE" numeric(16,8),
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ID_TYPE_COMPTE_PCG_AB" integer DEFAULT 1,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1
);


ALTER TABLE "OpenConcerto42"."COMPTE_PCG" OWNER TO openconcerto;

--
-- TOC entry 836 (class 1259 OID 6914090)
-- Name: COMPTE_PCG_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."COMPTE_PCG_ID_seq"
    START WITH 978
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."COMPTE_PCG_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24839 (class 0 OID 0)
-- Dependencies: 836
-- Name: COMPTE_PCG_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."COMPTE_PCG_ID_seq" OWNED BY "OpenConcerto42"."COMPTE_PCG"."ID";


--
-- TOC entry 837 (class 1259 OID 6914092)
-- Name: CONTACT; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."CONTACT" (
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "FAX" character varying(100) DEFAULT ''::character varying,
    "TEL_MOBILE" character varying(100) DEFAULT ''::character varying,
    "CREATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ID" integer NOT NULL,
    "PRENOM" character varying(100) DEFAULT ''::character varying,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_CLIENT" integer DEFAULT 1,
    "TEL_PERSONEL" character varying(100) DEFAULT ''::character varying,
    "ID_TITRE_PERSONNEL" integer DEFAULT 2,
    "TEL_DIRECT" character varying(100) DEFAULT ''::character varying,
    "EMAIL" character varying(100) DEFAULT ''::character varying,
    "ARCHIVE" integer DEFAULT 0,
    "TEL_STANDARD" character varying(100) DEFAULT ''::character varying,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "NOM" character varying(100) DEFAULT ''::character varying,
    "FONCTION" character varying(2048) DEFAULT ''::text,
    "NO_MAILING" boolean DEFAULT false NOT NULL,
    "DATE_NAISSANCE" date
);


ALTER TABLE "OpenConcerto42"."CONTACT" OWNER TO openconcerto;

--
-- TOC entry 838 (class 1259 OID 6914114)
-- Name: CONTACT_ADMINISTRATIF; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."CONTACT_ADMINISTRATIF" (
    "ID" integer NOT NULL,
    "NOM" character varying(256) DEFAULT ''::character varying NOT NULL,
    "PRENOM" character varying(256) DEFAULT ''::character varying NOT NULL,
    "TEL_DIRECT" character varying(256) DEFAULT ''::character varying NOT NULL,
    "TEL_MOBILE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "EMAIL" character varying(256) DEFAULT ''::character varying NOT NULL,
    "FAX" character varying(256) DEFAULT ''::character varying NOT NULL,
    "FONCTION" character varying(256) DEFAULT ''::character varying NOT NULL,
    "TEL_PERSONEL" character varying(256) DEFAULT ''::character varying NOT NULL,
    "TEL_STANDARD" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ID_TITRE_PERSONNEL" integer DEFAULT 1,
    "N4DS" boolean DEFAULT false,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "OpenConcerto42"."CONTACT_ADMINISTRATIF" OWNER TO openconcerto;

--
-- TOC entry 839 (class 1259 OID 6914133)
-- Name: CONTACT_ADMINISTRATIF_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."CONTACT_ADMINISTRATIF_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."CONTACT_ADMINISTRATIF_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24840 (class 0 OID 0)
-- Dependencies: 839
-- Name: CONTACT_ADMINISTRATIF_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."CONTACT_ADMINISTRATIF_ID_seq" OWNED BY "OpenConcerto42"."CONTACT_ADMINISTRATIF"."ID";


--
-- TOC entry 840 (class 1259 OID 6914135)
-- Name: CONTACT_FOURNISSEUR; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."CONTACT_FOURNISSEUR" (
    "ID" integer NOT NULL,
    "NOM" character varying(256) DEFAULT ''::character varying NOT NULL,
    "PRENOM" character varying(256) DEFAULT ''::character varying NOT NULL,
    "TEL_DIRECT" character varying(256) DEFAULT ''::character varying NOT NULL,
    "TEL_MOBILE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "EMAIL" character varying(256) DEFAULT ''::character varying NOT NULL,
    "FAX" character varying(256) DEFAULT ''::character varying NOT NULL,
    "FONCTION" character varying(256) DEFAULT ''::character varying NOT NULL,
    "TEL_PERSONEL" character varying(256) DEFAULT ''::character varying NOT NULL,
    "TEL_STANDARD" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ID_TITRE_PERSONNEL" integer DEFAULT 1,
    "ID_FOURNISSEUR" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "OpenConcerto42"."CONTACT_FOURNISSEUR" OWNER TO openconcerto;

--
-- TOC entry 841 (class 1259 OID 6914154)
-- Name: CONTACT_FOURNISSEUR_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."CONTACT_FOURNISSEUR_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."CONTACT_FOURNISSEUR_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24841 (class 0 OID 0)
-- Dependencies: 841
-- Name: CONTACT_FOURNISSEUR_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."CONTACT_FOURNISSEUR_ID_seq" OWNED BY "OpenConcerto42"."CONTACT_FOURNISSEUR"."ID";


--
-- TOC entry 842 (class 1259 OID 6914156)
-- Name: CONTACT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."CONTACT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."CONTACT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24842 (class 0 OID 0)
-- Dependencies: 842
-- Name: CONTACT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."CONTACT_ID_seq" OWNED BY "OpenConcerto42"."CONTACT"."ID";


--
-- TOC entry 843 (class 1259 OID 6914158)
-- Name: CONTACT_SALARIE; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."CONTACT_SALARIE" (
    "ID" integer NOT NULL,
    "NOM" character varying(256) DEFAULT ''::character varying NOT NULL,
    "PRENOM" character varying(256) DEFAULT ''::character varying NOT NULL,
    "TEL_DIRECT" character varying(256) DEFAULT ''::character varying NOT NULL,
    "TEL_MOBILE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "EMAIL" character varying(256) DEFAULT ''::character varying NOT NULL,
    "FAX" character varying(256) DEFAULT ''::character varying NOT NULL,
    "FONCTION" character varying(256) DEFAULT ''::character varying NOT NULL,
    "TEL_PERSONEL" character varying(256) DEFAULT ''::character varying NOT NULL,
    "TEL_STANDARD" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ID_TITRE_PERSONNEL" integer DEFAULT 1,
    "ID_SALARIE" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8)
);


ALTER TABLE "OpenConcerto42"."CONTACT_SALARIE" OWNER TO openconcerto;

--
-- TOC entry 844 (class 1259 OID 6914176)
-- Name: CONTACT_SALARIE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."CONTACT_SALARIE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."CONTACT_SALARIE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24843 (class 0 OID 0)
-- Dependencies: 844
-- Name: CONTACT_SALARIE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto42"."CONTACT_SALARIE_ID_seq" OWNED BY "OpenConcerto42"."CONTACT_SALARIE"."ID";


--
-- TOC entry 845 (class 1259 OID 6914178)
-- Name: CONTRAT_PREVOYANCE; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."CONTRAT_PREVOYANCE" (
    "ID" integer NOT NULL,
    "REFERENCE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "DATE_DEBUT" timestamp without time zone,
    "DATE_FIN" timestamp without time zone,
    "CODE_ORGANISME" character varying(256) DEFAULT ''::character varying NOT NULL,
    "CODE_DELEGATAIRE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "CODE_UNIQUE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric,
    "COTISATION_ETABLISSEMENT" boolean DEFAULT false NOT NULL
);


ALTER TABLE "OpenConcerto42"."CONTRAT_PREVOYANCE" OWNER TO openconcerto;

--
-- TOC entry 846 (class 1259 OID 6914192)
-- Name: CONTRAT_PREVOYANCE_AYANT_DROIT; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE TABLE "OpenConcerto42"."CONTRAT_PREVOYANCE_AYANT_DROIT" (
    "ID" integer NOT NULL,
    "ID_AYANT_DROIT" integer DEFAULT 1,
    "ID_CONTRAT_PREVOYANCE" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "OpenConcerto42"."CONTRAT_PREVOYANCE_AYANT_DROIT" OWNER TO openconcerto;

--
-- TOC entry 847 (class 1259 OID 6914199)
-- Name: CONTRAT_PREVOYANCE_AYANT_DROIT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto42"."CONTRAT_PREVOYANCE_AYANT_DROIT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."CONTRAT_PREVOYANCE_AYANT_DROIT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24844 (class 0 OID 0)
-- Dependencies: 847
