-- Name: CALENDAR_ITEM_GROUP_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."CALENDAR_ITEM_GROUP_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."CALENDAR_ITEM_GROUP_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24999 (class 0 OID 0)
-- Dependencies: 1153
-- Name: CALENDAR_ITEM_GROUP_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."CALENDAR_ITEM_GROUP_ID_seq" OWNED BY "OpenConcerto48"."CALENDAR_ITEM_GROUP"."ID";


--
-- TOC entry 1154 (class 1259 OID 6917254)
-- Name: CALENDAR_ITEM_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."CALENDAR_ITEM_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."CALENDAR_ITEM_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25000 (class 0 OID 0)
-- Dependencies: 1154
-- Name: CALENDAR_ITEM_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."CALENDAR_ITEM_ID_seq" OWNED BY "OpenConcerto48"."CALENDAR_ITEM"."ID";


--
-- TOC entry 1155 (class 1259 OID 6917256)
-- Name: CATEGORIE_CLIENT; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."CATEGORIE_CLIENT" OWNER TO openconcerto;

--
-- TOC entry 1156 (class 1259 OID 6917265)
-- Name: CATEGORIE_CLIENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."CATEGORIE_CLIENT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."CATEGORIE_CLIENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25001 (class 0 OID 0)
-- Dependencies: 1156
-- Name: CATEGORIE_CLIENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."CATEGORIE_CLIENT_ID_seq" OWNED BY "OpenConcerto48"."CATEGORIE_CLIENT"."ID";


--
-- TOC entry 1157 (class 1259 OID 6917267)
-- Name: CATEGORIE_COMPTABLE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."CATEGORIE_COMPTABLE" OWNER TO openconcerto;

--
-- TOC entry 1158 (class 1259 OID 6917276)
-- Name: CATEGORIE_COMPTABLE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."CATEGORIE_COMPTABLE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."CATEGORIE_COMPTABLE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25002 (class 0 OID 0)
-- Dependencies: 1158
-- Name: CATEGORIE_COMPTABLE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."CATEGORIE_COMPTABLE_ID_seq" OWNED BY "OpenConcerto48"."CATEGORIE_COMPTABLE"."ID";


--
-- TOC entry 1159 (class 1259 OID 6917278)
-- Name: CHEQUE_AVOIR_CLIENT; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."CHEQUE_AVOIR_CLIENT" (
    "CREATION_DATE" timestamp without time zone,
    "DATE_AVOIR" date,
    "DECAISSE" boolean DEFAULT false,
    "ID" integer NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "REG_COMPTA" boolean DEFAULT false,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ID_MOUVEMENT" integer DEFAULT 1,
    "ID_CLIENT" integer DEFAULT 1,
    "NUMERO" character varying(2048) DEFAULT ''::text,
    "ETS" character varying(2048) DEFAULT ''::text,
    "DATE" date,
    "DATE_DECAISSE" date,
    "MONTANT" bigint DEFAULT 0,
    "MODIFICATION_DATE" timestamp without time zone,
    "ARCHIVE" integer DEFAULT 0,
    "DATE_MIN_DECAISSE" date,
    "ID_BANQUE" integer DEFAULT 1
);


ALTER TABLE "OpenConcerto48"."CHEQUE_AVOIR_CLIENT" OWNER TO openconcerto;

--
-- TOC entry 1160 (class 1259 OID 6917296)
-- Name: CHEQUE_AVOIR_CLIENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."CHEQUE_AVOIR_CLIENT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."CHEQUE_AVOIR_CLIENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25003 (class 0 OID 0)
-- Dependencies: 1160
-- Name: CHEQUE_AVOIR_CLIENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."CHEQUE_AVOIR_CLIENT_ID_seq" OWNED BY "OpenConcerto48"."CHEQUE_AVOIR_CLIENT"."ID";


--
-- TOC entry 1161 (class 1259 OID 6917298)
-- Name: CHEQUE_A_ENCAISSER; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."CHEQUE_A_ENCAISSER" (
    "DATE_MIN_DEPOT" date,
    "ID_CLIENT" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "MONTANT" bigint DEFAULT 0,
    "ETS" character varying(2048) DEFAULT ''::text,
    "DATE" date,
    "ID_MOUVEMENT" integer DEFAULT 1,
    "NUMERO" character varying(2048) DEFAULT ''::text,
    "ORDRE" numeric(16,8),
    "CREATION_DATE" timestamp without time zone,
    "ARCHIVE" integer DEFAULT 0,
    "DATE_VENTE" date,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID" integer NOT NULL,
    "DATE_DEPOT" date,
    "ENCAISSE" boolean DEFAULT false,
    "REG_COMPTA" boolean DEFAULT false,
    "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 "OpenConcerto48"."CHEQUE_A_ENCAISSER" OWNER TO openconcerto;

--
-- TOC entry 1162 (class 1259 OID 6917318)
-- Name: CHEQUE_A_ENCAISSER_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."CHEQUE_A_ENCAISSER_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."CHEQUE_A_ENCAISSER_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25004 (class 0 OID 0)
-- Dependencies: 1162
-- Name: CHEQUE_A_ENCAISSER_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."CHEQUE_A_ENCAISSER_ID_seq" OWNED BY "OpenConcerto48"."CHEQUE_A_ENCAISSER"."ID";


--
-- TOC entry 1163 (class 1259 OID 6917320)
-- Name: CHEQUE_FOURNISSEUR; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."CHEQUE_FOURNISSEUR" (
    "DATE_DECAISSE" date,
    "ID_MOUVEMENT" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ID_FOURNISSEUR" integer DEFAULT 1,
    "DATE_MIN_DECAISSE" date,
    "NUMERO" character varying(2048) DEFAULT ''::text,
    "REG_COMPTA" boolean DEFAULT false,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "DATE_ACHAT" date,
    "CREATION_DATE" timestamp without time zone,
    "DATE" date,
    "MONTANT" bigint DEFAULT 0,
    "MODIFICATION_DATE" timestamp without time zone,
    "DECAISSE" boolean DEFAULT false,
    "ETS" character varying(2048) DEFAULT ''::text,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ORDRE" numeric(16,8),
    "ID" integer NOT NULL,
    "ID_BANQUE" integer DEFAULT 1,
    "SANS_VALEUR_ENCAISSEMENT" boolean DEFAULT false NOT NULL
);


ALTER TABLE "OpenConcerto48"."CHEQUE_FOURNISSEUR" OWNER TO openconcerto;

--
-- TOC entry 1164 (class 1259 OID 6917338)
-- Name: CHEQUE_FOURNISSEUR_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."CHEQUE_FOURNISSEUR_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."CHEQUE_FOURNISSEUR_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25005 (class 0 OID 0)
-- Dependencies: 1164
-- Name: CHEQUE_FOURNISSEUR_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."CHEQUE_FOURNISSEUR_ID_seq" OWNED BY "OpenConcerto48"."CHEQUE_FOURNISSEUR"."ID";


--
-- TOC entry 1165 (class 1259 OID 6917340)
-- Name: CHIFFRAGE_COMMANDE_CLIENT; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."CHIFFRAGE_COMMANDE_CLIENT" OWNER TO openconcerto;

--
-- TOC entry 1166 (class 1259 OID 6917354)
-- Name: CHIFFRAGE_COMMANDE_CLIENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."CHIFFRAGE_COMMANDE_CLIENT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."CHIFFRAGE_COMMANDE_CLIENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25006 (class 0 OID 0)
-- Dependencies: 1166
-- Name: CHIFFRAGE_COMMANDE_CLIENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."CHIFFRAGE_COMMANDE_CLIENT_ID_seq" OWNED BY "OpenConcerto48"."CHIFFRAGE_COMMANDE_CLIENT"."ID";


--
-- TOC entry 1167 (class 1259 OID 6917356)
-- Name: CLASSEMENT_CONVENTIONNEL; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."CLASSEMENT_CONVENTIONNEL" (
    "CREATION_DATE" timestamp without time zone,
    "ARCHIVE" integer DEFAULT 0,
    "ECHELON" character varying(45) DEFAULT ''::character varying,
    "INDICE" character varying(45) DEFAULT ''::character varying,
    "POSITION" character varying(45) DEFAULT ''::character varying,
    "NIVEAU" character varying(45) DEFAULT ''::character varying,
    "ORDRE" numeric(16,8),
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ID" integer NOT NULL,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "COEFF" character varying(45) DEFAULT ''::character varying
);


ALTER TABLE "OpenConcerto48"."CLASSEMENT_CONVENTIONNEL" OWNER TO openconcerto;

--
-- TOC entry 1168 (class 1259 OID 6917367)
-- Name: CLASSEMENT_CONVENTIONNEL_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."CLASSEMENT_CONVENTIONNEL_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."CLASSEMENT_CONVENTIONNEL_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25007 (class 0 OID 0)
-- Dependencies: 1168
-- Name: CLASSEMENT_CONVENTIONNEL_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."CLASSEMENT_CONVENTIONNEL_ID_seq" OWNED BY "OpenConcerto48"."CLASSEMENT_CONVENTIONNEL"."ID";


--
-- TOC entry 1169 (class 1259 OID 6917369)
-- Name: CLASSE_COMPTE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

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


ALTER TABLE "OpenConcerto48"."CLASSE_COMPTE" OWNER TO openconcerto;

--
-- TOC entry 1170 (class 1259 OID 6917380)
-- Name: CLASSE_COMPTE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."CLASSE_COMPTE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."CLASSE_COMPTE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25008 (class 0 OID 0)
-- Dependencies: 1170
-- Name: CLASSE_COMPTE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."CLASSE_COMPTE_ID_seq" OWNED BY "OpenConcerto48"."CLASSE_COMPTE"."ID";


--
-- TOC entry 1171 (class 1259 OID 6917382)
-- Name: CLIENT; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."CLIENT" (
    "ID_ADRESSE" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "TEL_COM" character varying(100) DEFAULT ''::character varying,
    "MAX_FACTURE" bigint DEFAULT 0,
    "TEL_P" character varying(100) DEFAULT ''::character varying,
    "TEL" character varying(100) DEFAULT ''::character varying,
    "ID_ADRESSE_F" integer DEFAULT 1,
    "MAIL_COM" character varying(100) DEFAULT ''::character varying,
    "TEL_P_TECH" character varying(100) DEFAULT ''::character varying,
    "CREATION_DATE" timestamp without time zone,
    "FAX_COM" character varying(100) DEFAULT ''::character varying,
    "RESPONSABLE_COM" character varying(100) DEFAULT ''::character varying,
    "COMPTE_CLIENT_AUTO" boolean DEFAULT false,
    "INFOS" character varying(2048) DEFAULT ''::text,
    "NOM" character varying(2048) DEFAULT ''::text,
    "ARCHIVE" integer DEFAULT 0,
    "ID_COMPTE_PCE" integer DEFAULT 1,
    "NUMERO_TVA" character varying(100) DEFAULT ''::character varying,
    "ID_ADRESSE_L" integer DEFAULT 1,
    "CODE" character varying(2048) DEFAULT ''::text,
    "SIRET" character varying(2048) DEFAULT ''::text,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "FORME_JURIDIQUE" character varying(2048) DEFAULT ''::text,
    "RESPONSABLE_TECH" character varying(100) DEFAULT ''::character varying,
    "TEL_P_COM" character varying(100) DEFAULT ''::character varying,
    "MARCHE_PRIVE" boolean DEFAULT false,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "COMPTANT" boolean DEFAULT false,
    "RESPONSABLE" character varying(100) DEFAULT ''::character varying,
    "RIB" character varying(2048) DEFAULT ''::text,
    "MARCHE_PUBLIC" boolean DEFAULT false,
    "FAX" character varying(100) DEFAULT ''::character varying,
    "TEL_TECH" character varying(100) DEFAULT ''::character varying,
    "ID" integer NOT NULL,
    "AFFACTURAGE" boolean DEFAULT false,
    "ORDRE" numeric(16,8),
    "MAIL" character varying(100) DEFAULT ''::character varying,
    "ID_MODE_REGLEMENT" integer DEFAULT 1,
    "MAIL_TECH" character varying(100) DEFAULT ''::character varying,
    "FAX_TECH" character varying(100) DEFAULT ''::character varying,
    "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 "OpenConcerto48"."CLIENT" OWNER TO openconcerto;

--
-- TOC entry 1172 (class 1259 OID 6917456)
-- Name: CLIENT_DEPARTEMENT; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."CLIENT_DEPARTEMENT" OWNER TO openconcerto;

--
-- TOC entry 1173 (class 1259 OID 6917468)
-- Name: CLIENT_DEPARTEMENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."CLIENT_DEPARTEMENT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."CLIENT_DEPARTEMENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25009 (class 0 OID 0)
-- Dependencies: 1173
-- Name: CLIENT_DEPARTEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."CLIENT_DEPARTEMENT_ID_seq" OWNED BY "OpenConcerto48"."CLIENT_DEPARTEMENT"."ID";


--
-- TOC entry 1174 (class 1259 OID 6917470)
-- Name: CLIENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."CLIENT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."CLIENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25010 (class 0 OID 0)
-- Dependencies: 1174
-- Name: CLIENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."CLIENT_ID_seq" OWNED BY "OpenConcerto48"."CLIENT"."ID";


--
-- TOC entry 1175 (class 1259 OID 6917472)
-- Name: CODE_CARACT_ACTIVITE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."CODE_CARACT_ACTIVITE" (
    "ID" integer NOT NULL,
    "CREATION_DATE" timestamp without time zone,
    "ORDRE" numeric(16,8),
    "CODE" character varying(5) DEFAULT ''::character varying,
    "ARCHIVE" integer DEFAULT 0,
    "MODIFICATION_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
);


ALTER TABLE "OpenConcerto48"."CODE_CARACT_ACTIVITE" OWNER TO openconcerto;

--
-- TOC entry 1176 (class 1259 OID 6917480)
-- Name: CODE_CARACT_ACTIVITE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."CODE_CARACT_ACTIVITE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."CODE_CARACT_ACTIVITE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25011 (class 0 OID 0)
-- Dependencies: 1176
-- Name: CODE_CARACT_ACTIVITE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."CODE_CARACT_ACTIVITE_ID_seq" OWNED BY "OpenConcerto48"."CODE_CARACT_ACTIVITE"."ID";


--
-- TOC entry 1177 (class 1259 OID 6917482)
-- Name: CODE_CONTRAT_TRAVAIL; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

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


ALTER TABLE "OpenConcerto48"."CODE_CONTRAT_TRAVAIL" OWNER TO openconcerto;

--
-- TOC entry 1178 (class 1259 OID 6917490)
-- Name: CODE_CONTRAT_TRAVAIL_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."CODE_CONTRAT_TRAVAIL_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."CODE_CONTRAT_TRAVAIL_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25012 (class 0 OID 0)
-- Dependencies: 1178
-- Name: CODE_CONTRAT_TRAVAIL_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."CODE_CONTRAT_TRAVAIL_ID_seq" OWNED BY "OpenConcerto48"."CODE_CONTRAT_TRAVAIL"."ID";


--
-- TOC entry 1179 (class 1259 OID 6917492)
-- Name: CODE_DROIT_CONTRAT; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

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


ALTER TABLE "OpenConcerto48"."CODE_DROIT_CONTRAT" OWNER TO openconcerto;

--
-- TOC entry 1180 (class 1259 OID 6917500)
-- Name: CODE_DROIT_CONTRAT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."CODE_DROIT_CONTRAT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."CODE_DROIT_CONTRAT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25013 (class 0 OID 0)
-- Dependencies: 1180
-- Name: CODE_DROIT_CONTRAT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."CODE_DROIT_CONTRAT_ID_seq" OWNED BY "OpenConcerto48"."CODE_DROIT_CONTRAT"."ID";


--
-- TOC entry 1181 (class 1259 OID 6917502)
-- Name: CODE_EMPLOI; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

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


ALTER TABLE "OpenConcerto48"."CODE_EMPLOI" OWNER TO openconcerto;

--
-- TOC entry 1182 (class 1259 OID 6917510)
-- Name: CODE_EMPLOI_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."CODE_EMPLOI_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."CODE_EMPLOI_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25014 (class 0 OID 0)
-- Dependencies: 1182
-- Name: CODE_EMPLOI_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."CODE_EMPLOI_ID_seq" OWNED BY "OpenConcerto48"."CODE_EMPLOI"."ID";


--
-- TOC entry 1183 (class 1259 OID 6917512)
-- Name: CODE_FOURNISSEUR; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."CODE_FOURNISSEUR" OWNER TO openconcerto;

--
-- TOC entry 1184 (class 1259 OID 6917520)
-- Name: CODE_FOURNISSEUR_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."CODE_FOURNISSEUR_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."CODE_FOURNISSEUR_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25015 (class 0 OID 0)
-- Dependencies: 1184
-- Name: CODE_FOURNISSEUR_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."CODE_FOURNISSEUR_ID_seq" OWNED BY "OpenConcerto48"."CODE_FOURNISSEUR"."ID";


--
-- TOC entry 1185 (class 1259 OID 6917522)
-- Name: CODE_PENIBILITE_CONTRAT_SALARIE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."CODE_PENIBILITE_CONTRAT_SALARIE" OWNER TO openconcerto;

--
-- TOC entry 1186 (class 1259 OID 6917529)
-- Name: CODE_PENIBILITE_CONTRAT_SALARIE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."CODE_PENIBILITE_CONTRAT_SALARIE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."CODE_PENIBILITE_CONTRAT_SALARIE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25016 (class 0 OID 0)
-- Dependencies: 1186
-- Name: CODE_PENIBILITE_CONTRAT_SALARIE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."CODE_PENIBILITE_CONTRAT_SALARIE_ID_seq" OWNED BY "OpenConcerto48"."CODE_PENIBILITE_CONTRAT_SALARIE"."ID";


--
-- TOC entry 1187 (class 1259 OID 6917531)
-- Name: CODE_REGIME; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

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


ALTER TABLE "OpenConcerto48"."CODE_REGIME" OWNER TO openconcerto;

--
-- TOC entry 1188 (class 1259 OID 6917539)
-- Name: CODE_REGIME_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."CODE_REGIME_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."CODE_REGIME_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25017 (class 0 OID 0)
-- Dependencies: 1188
-- Name: CODE_REGIME_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."CODE_REGIME_ID_seq" OWNED BY "OpenConcerto48"."CODE_REGIME"."ID";


--
-- TOC entry 1189 (class 1259 OID 6917541)
-- Name: CODE_STATUT_CATEGORIEL; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

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


ALTER TABLE "OpenConcerto48"."CODE_STATUT_CATEGORIEL" OWNER TO openconcerto;

--
-- TOC entry 1190 (class 1259 OID 6917549)
-- Name: CODE_STATUT_CATEGORIEL_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."CODE_STATUT_CATEGORIEL_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."CODE_STATUT_CATEGORIEL_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25018 (class 0 OID 0)
-- Dependencies: 1190
-- Name: CODE_STATUT_CATEGORIEL_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."CODE_STATUT_CATEGORIEL_ID_seq" OWNED BY "OpenConcerto48"."CODE_STATUT_CATEGORIEL"."ID";


--
-- TOC entry 1191 (class 1259 OID 6917551)
-- Name: CODE_STATUT_CAT_CONV; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."CODE_STATUT_CAT_CONV" OWNER TO openconcerto;

--
-- TOC entry 1192 (class 1259 OID 6917558)
-- Name: CODE_STATUT_CAT_CONV_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."CODE_STATUT_CAT_CONV_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."CODE_STATUT_CAT_CONV_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25019 (class 0 OID 0)
-- Dependencies: 1192
-- Name: CODE_STATUT_CAT_CONV_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."CODE_STATUT_CAT_CONV_ID_seq" OWNED BY "OpenConcerto48"."CODE_STATUT_CAT_CONV"."ID";


--
-- TOC entry 1193 (class 1259 OID 6917560)
-- Name: CODE_STATUT_PROF; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

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


ALTER TABLE "OpenConcerto48"."CODE_STATUT_PROF" OWNER TO openconcerto;

--
-- TOC entry 1194 (class 1259 OID 6917568)
-- Name: CODE_STATUT_PROF_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."CODE_STATUT_PROF_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."CODE_STATUT_PROF_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25020 (class 0 OID 0)
-- Dependencies: 1194
-- Name: CODE_STATUT_PROF_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."CODE_STATUT_PROF_ID_seq" OWNED BY "OpenConcerto48"."CODE_STATUT_PROF"."ID";


--
-- TOC entry 1195 (class 1259 OID 6917570)
-- Name: COEFF_PRIME; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."COEFF_PRIME" OWNER TO openconcerto;

--
-- TOC entry 1196 (class 1259 OID 6917579)
-- Name: COEFF_PRIME_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."COEFF_PRIME_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."COEFF_PRIME_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25021 (class 0 OID 0)
-- Dependencies: 1196
-- Name: COEFF_PRIME_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."COEFF_PRIME_ID_seq" OWNED BY "OpenConcerto48"."COEFF_PRIME"."ID";


--
-- TOC entry 1197 (class 1259 OID 6917581)
-- Name: COMMANDE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."COMMANDE" (
    "T_POIDS" real DEFAULT 0,
    "MODIFICATION_DATE" timestamp without time zone,
    "CREATION_DATE" timestamp without time zone,
    "ID_FOURNISSEUR" integer DEFAULT 1,
    "DATE" date,
    "ID_COMMERCIAL" integer DEFAULT 1,
    "SOURCE" character varying(100) DEFAULT ''::character varying,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "T_SERVICE" bigint DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0,
    "NUMERO" character varying(45) DEFAULT ''::character varying,
    "T_TTC" bigint DEFAULT 0,
    "INFOS" character varying(2048) DEFAULT ''::text,
    "IDSOURCE" integer DEFAULT 1,
    "DATE_ECHEANCE" date,
    "T_HT" bigint DEFAULT 0,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "T_TVA" bigint DEFAULT 0,
    "ID" integer NOT NULL,
    "ORDRE" numeric(16,8),
    "NOM" character varying(2048) DEFAULT ''::text,
    "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 "OpenConcerto48"."COMMANDE" OWNER TO openconcerto;

--
-- TOC entry 1198 (class 1259 OID 6917613)
-- Name: COMMANDE_CLIENT; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."COMMANDE_CLIENT" (
    "DATE" date,
    "SOURCE" character varying(100) DEFAULT ''::character varying,
    "T_TTC" bigint DEFAULT 0,
    "NOM" character varying(2048) DEFAULT ''::text,
    "ORDRE" numeric(16,8),
    "DATE_ECHEANCE" date,
    "T_SERVICE" bigint DEFAULT 0,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "T_TVA" bigint DEFAULT 0,
    "CREATION_DATE" timestamp without time zone,
    "ARCHIVE" integer DEFAULT 0,
    "MODIFICATION_DATE" timestamp without time zone,
    "T_HT" bigint DEFAULT 0,
    "ID" integer NOT NULL,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "T_POIDS" real DEFAULT 0,
    "ID_CLIENT" integer DEFAULT 1,
    "NUMERO" character varying(45) DEFAULT ''::character varying,
    "IDSOURCE" integer DEFAULT 1,
    "ID_COMMERCIAL" integer DEFAULT 1,
    "ID_DEVIS" integer DEFAULT 1,
    "INFOS" character varying(2048) DEFAULT ''::text,
    "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 "OpenConcerto48"."COMMANDE_CLIENT" OWNER TO openconcerto;

--
-- TOC entry 1199 (class 1259 OID 6917655)
-- Name: COMMANDE_CLIENT_ELEMENT; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."COMMANDE_CLIENT_ELEMENT" (
    "PRIX_METRIQUE_VT_1" numeric(16,6) DEFAULT 0 NOT NULL,
    "ID_TAXE" integer DEFAULT 1,
    "PA_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "ID_COMMANDE_CLIENT" integer DEFAULT 1,
    "VALEUR_METRIQUE_1" real DEFAULT 0,
    "PRIX_METRIQUE_HA_1" numeric(16,6) DEFAULT 0 NOT NULL,
    "MODIFICATION_DATE" timestamp without time zone,
    "QTE" integer DEFAULT 0,
    "VALEUR_METRIQUE_2" real DEFAULT 0,
    "CODE" character varying(45) DEFAULT ''::character varying,
    "ID_MODE_VENTE_ARTICLE" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "PRIX_METRIQUE_HA_2" numeric(16,6) DEFAULT 0 NOT NULL,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "T_POIDS" real DEFAULT 0,
    "PRIX_METRIQUE_VT_2" numeric(16,6) DEFAULT 0 NOT NULL,
    "T_PV_TTC" numeric(16,2) DEFAULT 0 NOT NULL,
    "SERVICE" boolean DEFAULT false,
    "ORDRE" numeric(16,8),
    "ID_METRIQUE_3" integer DEFAULT 1,
    "T_PV_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "ID" integer NOT NULL,
    "PRIX_METRIQUE_VT_3" numeric(16,6) DEFAULT 0 NOT NULL,
    "ID_METRIQUE_2" integer DEFAULT 1,
    "PRIX_METRIQUE_HA_3" numeric(16,6) DEFAULT 0 NOT NULL,
    "ARCHIVE" integer DEFAULT 0,
    "NOM" character varying(2048) DEFAULT ''::character varying,
    "T_PA_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "PV_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "POIDS" real DEFAULT 0,
    "ID_METRIQUE_1" integer DEFAULT 1,
    "VALEUR_METRIQUE_3" real DEFAULT 0,
    "ID_STYLE" 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,
    "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 "OpenConcerto48"."COMMANDE_CLIENT_ELEMENT" OWNER TO openconcerto;

--
-- TOC entry 1200 (class 1259 OID 6917719)
-- Name: COMMANDE_CLIENT_ELEMENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."COMMANDE_CLIENT_ELEMENT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."COMMANDE_CLIENT_ELEMENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25022 (class 0 OID 0)
-- Dependencies: 1200
-- Name: COMMANDE_CLIENT_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."COMMANDE_CLIENT_ELEMENT_ID_seq" OWNED BY "OpenConcerto48"."COMMANDE_CLIENT_ELEMENT"."ID";


--
-- TOC entry 1201 (class 1259 OID 6917721)
-- Name: COMMANDE_CLIENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."COMMANDE_CLIENT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."COMMANDE_CLIENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25023 (class 0 OID 0)
-- Dependencies: 1201
-- Name: COMMANDE_CLIENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."COMMANDE_CLIENT_ID_seq" OWNED BY "OpenConcerto48"."COMMANDE_CLIENT"."ID";


--
-- TOC entry 1202 (class 1259 OID 6917723)
-- Name: COMMANDE_ELEMENT; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."COMMANDE_ELEMENT" (
    "ID_COMMANDE" integer DEFAULT 1,
    "T_PV_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "PRIX_METRIQUE_VT_2" numeric(16,6) DEFAULT 0 NOT NULL,
    "T_POIDS" real DEFAULT 0,
    "ID" integer NOT NULL,
    "CODE" character varying(45) DEFAULT ''::character varying,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "ID_STYLE" integer DEFAULT 1,
    "VALEUR_METRIQUE_3" real DEFAULT 0,
    "ID_METRIQUE_1" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "NOM" character varying(2048) DEFAULT ''::character varying,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "PRIX_METRIQUE_HA_3" numeric(16,6) DEFAULT 0 NOT NULL,
    "T_PV_TTC" numeric(16,2) DEFAULT 0 NOT NULL,
    "ID_METRIQUE_2" integer DEFAULT 1,
    "ID_TAXE" integer DEFAULT 1,
    "VALEUR_METRIQUE_2" real DEFAULT 0,
    "T_PA_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "PRIX_METRIQUE_VT_1" numeric(16,6) DEFAULT 0 NOT NULL,
    "T_PA_TTC" numeric(16,2) DEFAULT 0 NOT NULL,
    "PV_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "PRIX_METRIQUE_VT_3" numeric(16,6) DEFAULT 0 NOT NULL,
    "PRIX_METRIQUE_HA_2" numeric(16,6) DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8),
    "POIDS" real DEFAULT 0,
    "ID_MODE_VENTE_ARTICLE" integer DEFAULT 1,
    "QTE" integer DEFAULT 0,
    "ID_METRIQUE_3" integer DEFAULT 1,
    "PRIX_METRIQUE_HA_1" numeric(16,6) DEFAULT 0 NOT NULL,
    "SERVICE" boolean DEFAULT false,
    "VALEUR_METRIQUE_1" real DEFAULT 0,
    "PA_HT" 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,
    "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 "OpenConcerto48"."COMMANDE_ELEMENT" OWNER TO openconcerto;

--
-- TOC entry 1203 (class 1259 OID 6917785)
-- Name: COMMANDE_ELEMENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."COMMANDE_ELEMENT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."COMMANDE_ELEMENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25024 (class 0 OID 0)
-- Dependencies: 1203
-- Name: COMMANDE_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."COMMANDE_ELEMENT_ID_seq" OWNED BY "OpenConcerto48"."COMMANDE_ELEMENT"."ID";


--
-- TOC entry 1204 (class 1259 OID 6917787)
-- Name: COMMANDE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."COMMANDE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."COMMANDE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25025 (class 0 OID 0)
-- Dependencies: 1204
-- Name: COMMANDE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."COMMANDE_ID_seq" OWNED BY "OpenConcerto48"."COMMANDE"."ID";


--
-- TOC entry 1205 (class 1259 OID 6917789)
-- Name: COMMERCIAL; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."COMMERCIAL" (
    "ID_COMMERCIAL" integer NOT NULL,
    "FONCTION" character varying(100) DEFAULT ''::character varying,
    "ARCHIVE" integer DEFAULT 0,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_TITRE_PERSONNEL" integer DEFAULT 1,
    "TEL_DIRECT" character varying(100) DEFAULT ''::character varying,
    "TEL_MOBILE" character varying(100) DEFAULT ''::character varying,
    "CREATION_DATE" timestamp without time zone,
    "ORDRE" numeric(16,8),
    "TEL_PERSONEL" character varying(100) DEFAULT ''::character varying,
    "FAX" character varying(100) DEFAULT ''::character varying,
    "NOM" character varying(100) DEFAULT ''::character varying,
    "PRENOM" character varying(100) DEFAULT ''::character varying,
    "ID_USER_COMMON" integer DEFAULT 1,
    "TEL_STANDARD" character varying(100) DEFAULT ''::character varying,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "EMAIL" character varying(100) DEFAULT ''::character varying
);


ALTER TABLE "OpenConcerto48"."COMMERCIAL" OWNER TO openconcerto;

--
-- TOC entry 1206 (class 1259 OID 6917809)
-- Name: COMMERCIAL_ID_COMMERCIAL_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."COMMERCIAL_ID_COMMERCIAL_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."COMMERCIAL_ID_COMMERCIAL_seq" OWNER TO openconcerto;

--
-- TOC entry 25026 (class 0 OID 0)
-- Dependencies: 1206
-- Name: COMMERCIAL_ID_COMMERCIAL_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."COMMERCIAL_ID_COMMERCIAL_seq" OWNED BY "OpenConcerto48"."COMMERCIAL"."ID_COMMERCIAL";


--
-- TOC entry 1207 (class 1259 OID 6917811)
-- Name: COMPLETION; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."COMPLETION" (
    "CHAMP" character varying(100) DEFAULT ''::character varying NOT NULL,
    "LABEL" character varying(200) DEFAULT ''::character varying NOT NULL
);


ALTER TABLE "OpenConcerto48"."COMPLETION" OWNER TO openconcerto;

--
-- TOC entry 1208 (class 1259 OID 6917816)
-- Name: COMPTE_CLIENT_TRANSACTION; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."COMPTE_CLIENT_TRANSACTION" OWNER TO openconcerto;

--
-- TOC entry 1209 (class 1259 OID 6917825)
-- Name: COMPTE_CLIENT_TRANSACTION_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."COMPTE_CLIENT_TRANSACTION_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."COMPTE_CLIENT_TRANSACTION_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25027 (class 0 OID 0)
-- Dependencies: 1209
-- Name: COMPTE_CLIENT_TRANSACTION_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."COMPTE_CLIENT_TRANSACTION_ID_seq" OWNED BY "OpenConcerto48"."COMPTE_CLIENT_TRANSACTION"."ID";


--
-- TOC entry 1210 (class 1259 OID 6917827)
-- Name: COMPTE_PCE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."COMPTE_PCE" (
    "TOTAL_DEBIT" bigint DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0,
    "INFOS" character varying(3072) DEFAULT ''::text,
    "CREATION_DATE" timestamp without time zone,
    "TOTAL_CREDIT" bigint DEFAULT 0,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ID_NATURE_COMPTE" integer DEFAULT 1,
    "ORDRE" numeric(16,8),
    "NUMERO" character varying(2048) DEFAULT ''::text,
    "MODIFICATION_DATE" timestamp without time zone,
    "RACINE" boolean DEFAULT false,
    "NOM" character varying(2048) DEFAULT ''::text,
    "ID" integer NOT NULL,
    "OBSOLETE" boolean DEFAULT false NOT NULL
);


ALTER TABLE "OpenConcerto48"."COMPTE_PCE" OWNER TO openconcerto;

--
-- TOC entry 1211 (class 1259 OID 6917844)
-- Name: COMPTE_PCE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."COMPTE_PCE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."COMPTE_PCE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25028 (class 0 OID 0)
-- Dependencies: 1211
-- Name: COMPTE_PCE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."COMPTE_PCE_ID_seq" OWNED BY "OpenConcerto48"."COMPTE_PCE"."ID";


--
-- TOC entry 1212 (class 1259 OID 6917846)
-- Name: COMPTE_PCG; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."COMPTE_PCG" (
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "INFOS" character varying(3072) DEFAULT ''::text,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "CREATION_DATE" timestamp without time zone,
    "ID_TYPE_COMPTE_PCG_AB" integer DEFAULT 1,
    "ID_NATURE_COMPTE" integer DEFAULT 1,
    "NUMERO" character varying(2048) DEFAULT ''::text,
    "ID_TYPE_COMPTE_PCG_BASE" integer DEFAULT 1,
    "ID_TYPE_COMPTE_PCG_DEV" integer DEFAULT 1,
    "ID" integer NOT NULL,
    "ORDRE" numeric(16,8),
    "NOM" character varying(2048) DEFAULT ''::text
);


ALTER TABLE "OpenConcerto48"."COMPTE_PCG" OWNER TO openconcerto;

--
-- TOC entry 1213 (class 1259 OID 6917862)
-- Name: COMPTE_PCG_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."COMPTE_PCG_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."COMPTE_PCG_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25029 (class 0 OID 0)
-- Dependencies: 1213
-- Name: COMPTE_PCG_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."COMPTE_PCG_ID_seq" OWNED BY "OpenConcerto48"."COMPTE_PCG"."ID";


--
-- TOC entry 1214 (class 1259 OID 6917864)
-- Name: CONTACT; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."CONTACT" (
    "ID_CLIENT" integer DEFAULT 1,
    "TEL_MOBILE" character varying(100) DEFAULT ''::character varying,
    "TEL_DIRECT" character varying(100) DEFAULT ''::character varying,
    "MODIFICATION_DATE" timestamp without time zone,
    "FONCTION" character varying(2048) DEFAULT ''::text,
    "EMAIL" character varying(100) DEFAULT ''::character varying,
    "PRENOM" character varying(100) DEFAULT ''::character varying,
    "TEL_PERSONEL" character varying(100) DEFAULT ''::character varying,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "ID_TITRE_PERSONNEL" integer DEFAULT 2,
    "FAX" character varying(100) DEFAULT ''::character varying,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "NOM" character varying(100) DEFAULT ''::character varying,
    "TEL_STANDARD" character varying(100) DEFAULT ''::character varying,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "ID" integer NOT NULL,
    "NO_MAILING" boolean DEFAULT false NOT NULL,
    "DATE_NAISSANCE" date
);


ALTER TABLE "OpenConcerto48"."CONTACT" OWNER TO openconcerto;

--
-- TOC entry 1215 (class 1259 OID 6917886)
-- Name: CONTACT_ADMINISTRATIF; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."CONTACT_ADMINISTRATIF" OWNER TO openconcerto;

--
-- TOC entry 1216 (class 1259 OID 6917905)
-- Name: CONTACT_ADMINISTRATIF_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."CONTACT_ADMINISTRATIF_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."CONTACT_ADMINISTRATIF_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25030 (class 0 OID 0)
-- Dependencies: 1216
-- Name: CONTACT_ADMINISTRATIF_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."CONTACT_ADMINISTRATIF_ID_seq" OWNED BY "OpenConcerto48"."CONTACT_ADMINISTRATIF"."ID";


--
-- TOC entry 1217 (class 1259 OID 6917907)
-- Name: CONTACT_FOURNISSEUR; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."CONTACT_FOURNISSEUR" OWNER TO openconcerto;

--
-- TOC entry 1218 (class 1259 OID 6917926)
-- Name: CONTACT_FOURNISSEUR_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."CONTACT_FOURNISSEUR_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."CONTACT_FOURNISSEUR_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25031 (class 0 OID 0)
-- Dependencies: 1218
-- Name: CONTACT_FOURNISSEUR_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."CONTACT_FOURNISSEUR_ID_seq" OWNED BY "OpenConcerto48"."CONTACT_FOURNISSEUR"."ID";


--
-- TOC entry 1219 (class 1259 OID 6917928)
-- Name: CONTACT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."CONTACT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."CONTACT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25032 (class 0 OID 0)
-- Dependencies: 1219
-- Name: CONTACT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."CONTACT_ID_seq" OWNED BY "OpenConcerto48"."CONTACT"."ID";


--
-- TOC entry 1220 (class 1259 OID 6917930)
-- Name: CONTACT_SALARIE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."CONTACT_SALARIE" OWNER TO openconcerto;

--
-- TOC entry 1221 (class 1259 OID 6917948)
-- Name: CONTACT_SALARIE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."CONTACT_SALARIE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."CONTACT_SALARIE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25033 (class 0 OID 0)
-- Dependencies: 1221
-- Name: CONTACT_SALARIE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."CONTACT_SALARIE_ID_seq" OWNED BY "OpenConcerto48"."CONTACT_SALARIE"."ID";


--
-- TOC entry 1222 (class 1259 OID 6917950)
-- Name: CONTRAT_PREVOYANCE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."CONTRAT_PREVOYANCE" OWNER TO openconcerto;

--
-- TOC entry 1223 (class 1259 OID 6917964)
-- Name: CONTRAT_PREVOYANCE_AYANT_DROIT; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."CONTRAT_PREVOYANCE_AYANT_DROIT" OWNER TO openconcerto;

--
-- TOC entry 1224 (class 1259 OID 6917971)
-- Name: CONTRAT_PREVOYANCE_AYANT_DROIT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."CONTRAT_PREVOYANCE_AYANT_DROIT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."CONTRAT_PREVOYANCE_AYANT_DROIT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25034 (class 0 OID 0)
-- Dependencies: 1224
-- Name: CONTRAT_PREVOYANCE_AYANT_DROIT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."CONTRAT_PREVOYANCE_AYANT_DROIT_ID_seq" OWNED BY "OpenConcerto48"."CONTRAT_PREVOYANCE_AYANT_DROIT"."ID";


--
-- TOC entry 1225 (class 1259 OID 6917973)
-- Name: CONTRAT_PREVOYANCE_CONTRAT_SALARIE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."CONTRAT_PREVOYANCE_CONTRAT_SALARIE" (
    "ID" integer NOT NULL,
    "ID_INFOS_SALARIE_PAYE" integer DEFAULT 1,
    "ID_CONTRAT_PREVOYANCE" integer DEFAULT 1,
    "CODE_OPTION" character varying(256) DEFAULT ''::character varying NOT NULL,
    "CODE_POPULATION" character varying(256) DEFAULT ''::character varying NOT NULL,
    "NB_ENFANT_CHARGE" integer,
    "NB_ADULTE_AYANT_DROIT" integer,
    "NB_AYANT_DROIT" integer,
    "NB_AYANT_DROIT_AUTRE" integer,
    "NB_ENFANT_AYANT_DROIT" integer,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "OpenConcerto48"."CONTRAT_PREVOYANCE_CONTRAT_SALARIE" OWNER TO openconcerto;

--
-- TOC entry 1226 (class 1259 OID 6917985)
-- Name: CONTRAT_PREVOYANCE_CONTRAT_SALARIE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."CONTRAT_PREVOYANCE_CONTRAT_SALARIE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."CONTRAT_PREVOYANCE_CONTRAT_SALARIE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25035 (class 0 OID 0)
-- Dependencies: 1226
-- Name: CONTRAT_PREVOYANCE_CONTRAT_SALARIE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."CONTRAT_PREVOYANCE_CONTRAT_SALARIE_ID_seq" OWNED BY "OpenConcerto48"."CONTRAT_PREVOYANCE_CONTRAT_SALARIE"."ID";


--
-- TOC entry 1227 (class 1259 OID 6917987)
-- Name: CONTRAT_PREVOYANCE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."CONTRAT_PREVOYANCE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."CONTRAT_PREVOYANCE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25036 (class 0 OID 0)
-- Dependencies: 1227
-- Name: CONTRAT_PREVOYANCE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."CONTRAT_PREVOYANCE_ID_seq" OWNED BY "OpenConcerto48"."CONTRAT_PREVOYANCE"."ID";


--
-- TOC entry 1228 (class 1259 OID 6917989)
-- Name: CONTRAT_PREVOYANCE_RUBRIQUE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."CONTRAT_PREVOYANCE_RUBRIQUE" (
    "ID" integer NOT NULL,
    "ID_RUBRIQUE_COTISATION" integer DEFAULT 1,
    "ID_CONTRAT_PREVOYANCE" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "OpenConcerto48"."CONTRAT_PREVOYANCE_RUBRIQUE" OWNER TO openconcerto;

--
-- TOC entry 1229 (class 1259 OID 6917996)
-- Name: CONTRAT_PREVOYANCE_RUBRIQUE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."CONTRAT_PREVOYANCE_RUBRIQUE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."CONTRAT_PREVOYANCE_RUBRIQUE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25037 (class 0 OID 0)
-- Dependencies: 1229
-- Name: CONTRAT_PREVOYANCE_RUBRIQUE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."CONTRAT_PREVOYANCE_RUBRIQUE_ID_seq" OWNED BY "OpenConcerto48"."CONTRAT_PREVOYANCE_RUBRIQUE"."ID";


--
-- TOC entry 1230 (class 1259 OID 6917998)
-- Name: CONTRAT_PREVOYANCE_RUBRIQUE_NET; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."CONTRAT_PREVOYANCE_RUBRIQUE_NET" (
    "ID" integer NOT NULL,
    "ID_RUBRIQUE_NET" integer DEFAULT 1,
    "ID_CONTRAT_PREVOYANCE" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "OpenConcerto48"."CONTRAT_PREVOYANCE_RUBRIQUE_NET" OWNER TO openconcerto;

--
-- TOC entry 1231 (class 1259 OID 6918005)
-- Name: CONTRAT_PREVOYANCE_RUBRIQUE_NET_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."CONTRAT_PREVOYANCE_RUBRIQUE_NET_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."CONTRAT_PREVOYANCE_RUBRIQUE_NET_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25038 (class 0 OID 0)
-- Dependencies: 1231
-- Name: CONTRAT_PREVOYANCE_RUBRIQUE_NET_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."CONTRAT_PREVOYANCE_RUBRIQUE_NET_ID_seq" OWNED BY "OpenConcerto48"."CONTRAT_PREVOYANCE_RUBRIQUE_NET"."ID";


--
-- TOC entry 1232 (class 1259 OID 6918007)
-- Name: CONTRAT_SALARIE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."CONTRAT_SALARIE" (
    "NATURE" character varying(2048) DEFAULT ''::text,
    "ID_CODE_STATUT_PROF" integer DEFAULT 1,
    "ID_CODE_CARACT_ACTIVITE" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ORDRE" numeric(16,8),
    "ID_CODE_DROIT_CONTRAT" integer DEFAULT 1,
    "ID_CODE_EMPLOI" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "ARCHIVE" integer DEFAULT 0,
    "ID_CODE_STATUT_CATEGORIEL" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ID" integer NOT NULL,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_CODE_CONTRAT_TRAVAIL" integer DEFAULT 1,
    "CODE_IRC_UGRR" character varying(18) DEFAULT ''::character varying NOT NULL,
    "NUMERO_RATTACHEMENT_UGRR" character varying(64) DEFAULT ''::character varying NOT NULL,
    "CODE_IRC_UGRC" character varying(18) DEFAULT ''::character varying NOT NULL,
    "NUMERO_RATTACHEMENT_UGRC" character varying(64) DEFAULT ''::character varying NOT NULL,
    "CODE_IRC_RETRAITE" character varying(18) DEFAULT ''::character varying NOT NULL,
    "NUMERO_RATTACHEMENT_RETRAITE" character varying(64) DEFAULT ''::character varying NOT NULL,
    "ID_CODE_STATUT_CAT_CONV" integer DEFAULT 1,
    "NUMERO" character varying(128) DEFAULT '00000'::character varying NOT NULL,
    "CODE_REGIME_RETRAITE_DSN" character varying(128) DEFAULT '00000'::character varying NOT NULL,
    "DATE_PREV_FIN" timestamp without time zone,
    "ID_CONTRAT_MODALITE_TEMPS" integer DEFAULT 1,
    "ID_CONTRAT_REGIME_MALADIE" integer DEFAULT 1,
    "ID_CONTRAT_REGIME_VIEILLESSE" integer DEFAULT 1,
    "ID_CONTRAT_MOTIF_RECOURS" integer DEFAULT 1,
    "ID_CONTRAT_DETACHE_EXPATRIE" integer DEFAULT 1,
    "ID_CONTRAT_DISPOSITIF_POLITIQUE" integer DEFAULT 1,
    "DATE_DEBUT" timestamp without time zone,
    "DATE_MODIFICATION" timestamp without time zone,
    "COMPLEMENT_PCS" character varying(54) DEFAULT ''::character varying NOT NULL,
    "ID_CODE_AMENAGEMENT_PARTIEL" integer DEFAULT 1,
    "DATE_DEBUT_SUSPENSION" date,
    "DATE_FIN_SUSPENSION" date,
    "ID_CODE_SUSPENSION" integer DEFAULT 1,
    "ID_DIPLOME_PREPARE" integer DEFAULT 1,
    "SPECTACLE_OBJET" character varying(54) DEFAULT ''::character varying NOT NULL,
    "SPECTACLE_JOUR_CONTRAT" numeric(16,2),
    "ID_CODE_CAISSE_CONGES_PAYES" integer DEFAULT 1,
    "TAUX_FRAIS_PROFESSIONNELS" numeric(16,4)
);


ALTER TABLE "OpenConcerto48"."CONTRAT_SALARIE" OWNER TO openconcerto;

--
-- TOC entry 1233 (class 1259 OID 6918044)
-- Name: CONTRAT_SALARIE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."CONTRAT_SALARIE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."CONTRAT_SALARIE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25039 (class 0 OID 0)
-- Dependencies: 1233
-- Name: CONTRAT_SALARIE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."CONTRAT_SALARIE_ID_seq" OWNED BY "OpenConcerto48"."CONTRAT_SALARIE"."ID";


--
-- TOC entry 1234 (class 1259 OID 6918046)
-- Name: COURRIER_CLIENT; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."COURRIER_CLIENT" (
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ID_CLIENT" integer DEFAULT 1,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "INFOS" character varying(2048) DEFAULT ''::text,
    "NOM" character varying(256) DEFAULT ''::character varying,
    "ID" integer NOT NULL,
    "ID_ADRESSE" integer DEFAULT 1,
    "ID_MODELE_COURRIER_CLIENT" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "DATE" date,
    "NUMERO" character varying(2048) DEFAULT ''::text,
    "MODIFICATION_DATE" timestamp without time zone,
    "CREATION_DATE" timestamp without time zone,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "ID_CONTACT" integer DEFAULT 1
);


ALTER TABLE "OpenConcerto48"."COURRIER_CLIENT" OWNER TO openconcerto;

--
-- TOC entry 1235 (class 1259 OID 6918062)
-- Name: COURRIER_CLIENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."COURRIER_CLIENT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."COURRIER_CLIENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25040 (class 0 OID 0)
-- Dependencies: 1235
-- Name: COURRIER_CLIENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."COURRIER_CLIENT_ID_seq" OWNED BY "OpenConcerto48"."COURRIER_CLIENT"."ID";


--
-- TOC entry 1236 (class 1259 OID 6918064)
-- Name: COUT_REVIENT; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."COUT_REVIENT" (
    "ID" integer NOT NULL,
    "CODE" character varying(48) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(256) DEFAULT ''::character varying NOT NULL,
    "POURCENT" numeric(16,6) DEFAULT 0 NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8)
);


ALTER TABLE "OpenConcerto48"."COUT_REVIENT" OWNER TO openconcerto;

--
-- TOC entry 1237 (class 1259 OID 6918071)
-- Name: COUT_REVIENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."COUT_REVIENT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."COUT_REVIENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25041 (class 0 OID 0)
-- Dependencies: 1237
-- Name: COUT_REVIENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."COUT_REVIENT_ID_seq" OWNED BY "OpenConcerto48"."COUT_REVIENT"."ID";


--
-- TOC entry 1238 (class 1259 OID 6918073)
-- Name: CUMULS_CONGES; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."CUMULS_CONGES" (
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ACQUIS" real DEFAULT 0,
    "ID" integer NOT NULL,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ORDRE" numeric(16,8),
    "RESTANT" real DEFAULT 0,
    "CREATION_DATE" timestamp without time zone,
    "ARCHIVE" integer DEFAULT 0
);


ALTER TABLE "OpenConcerto48"."CUMULS_CONGES" OWNER TO openconcerto;

--
-- TOC entry 1239 (class 1259 OID 6918081)
-- Name: CUMULS_CONGES_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."CUMULS_CONGES_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."CUMULS_CONGES_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25042 (class 0 OID 0)
-- Dependencies: 1239
-- Name: CUMULS_CONGES_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."CUMULS_CONGES_ID_seq" OWNED BY "OpenConcerto48"."CUMULS_CONGES"."ID";


--
-- TOC entry 1240 (class 1259 OID 6918083)
-- Name: CUMULS_PAYE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."CUMULS_PAYE" (
    "ORDRE" numeric(16,8),
    "NET_A_PAYER_C" numeric(16,2) DEFAULT 0,
    "MODIFICATION_DATE" timestamp without time zone,
    "COT_PAT_C" numeric(16,2) DEFAULT 0,
    "CREATION_DATE" timestamp without time zone,
    "ARCHIVE" integer DEFAULT 0,
    "COT_SAL_C" numeric(16,2) DEFAULT 0,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "SAL_BRUT_C" numeric(16,2) DEFAULT 0,
    "CSG_C" numeric(16,2) DEFAULT 0,
    "ID" integer NOT NULL,
    "NET_IMP_C" numeric(16,2) DEFAULT 0,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "HEURE_TRAV_C" numeric(16,2) DEFAULT 0 NOT NULL,
    "TAXE_CM_SAL_C" numeric(16,2) DEFAULT 0 NOT NULL,
    "TAXE_CM_PAT_C" numeric(16,2) DEFAULT 0 NOT NULL,
    "SAL_BRUT_COTISABLE_C" numeric(16,2) DEFAULT 0 NOT NULL,
    "SAL_BRUT_TAXABLE_C" numeric(16,2) DEFAULT 0 NOT NULL,
    "SAL_BASE_BRUT_C" numeric(16,2) DEFAULT 0 NOT NULL,
    "ALLEGEMENT_COTISATION_C" numeric(16,2) DEFAULT 0 NOT NULL,
    "CICE_C" numeric(16,2) DEFAULT 0 NOT NULL,
    "AVANTAGE_NATURE_C" numeric(16,2) DEFAULT 0 NOT NULL,
    "NET_SOCIAL_C" numeric(16,2) DEFAULT 0 NOT NULL,
    "HEURE_SUP_EXO_NET_C" numeric(16,2) DEFAULT 0 NOT NULL,
    "TOTAL_PAS_C" numeric(16,2) DEFAULT 0 NOT NULL,
    "NET_AVANT_PAS_C" numeric(16,2) DEFAULT 0 NOT NULL
);


ALTER TABLE "OpenConcerto48"."CUMULS_PAYE" OWNER TO openconcerto;

--
-- TOC entry 1241 (class 1259 OID 6918104)
-- Name: CUMULS_PAYE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."CUMULS_PAYE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."CUMULS_PAYE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25043 (class 0 OID 0)
-- Dependencies: 1241
-- Name: CUMULS_PAYE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."CUMULS_PAYE_ID_seq" OWNED BY "OpenConcerto48"."CUMULS_PAYE"."ID";


--
-- TOC entry 1242 (class 1259 OID 6918106)
-- Name: DECLARATION_DSN; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."DECLARATION_DSN" (
    "ID" integer NOT NULL,
    "ID_DSN_NATURE" integer DEFAULT 1,
    "DATE" timestamp without time zone,
    "DATE_ENVOI" timestamp without time zone,
    "TEST" boolean DEFAULT false NOT NULL,
    "ENVOYE" boolean DEFAULT false NOT NULL,
    "COMMENTAIRE" character varying(1024) DEFAULT ''::character varying NOT NULL,
    "DSN_FILE" character varying(75000) DEFAULT ''::character varying NOT NULL,
    "NUMERO" integer DEFAULT 1 NOT NULL,
    "ANNEE" integer DEFAULT 2016 NOT NULL,
    "ID_MOIS" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric,
    "ID_ARRET_TRAVAIL" integer DEFAULT 1,
    "ID_REPRISE_TRAVAIL" integer DEFAULT 1,
    "ID_MOIS_REGUL" integer DEFAULT 1,
    "ANNULE_REMPLACE" boolean DEFAULT false NOT NULL,
    "ID_FIN_CONTRAT" integer DEFAULT 1,
    "NUMERO_REFERENCE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ID_DECLARATION_DSN_ANNULATION" integer DEFAULT 1,
    "EFFECTIF_CVAE" integer,
    "CODE_INSEE_CVAE" character varying(32) DEFAULT ''::character varying NOT NULL,
    "PERIODE_CVAE_DEBUT" date,
    "PERIODE_CVAE_FIN" date
);


ALTER TABLE "OpenConcerto48"."DECLARATION_DSN" OWNER TO openconcerto;

--
-- TOC entry 1243 (class 1259 OID 6918130)
-- Name: DECLARATION_DSN_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."DECLARATION_DSN_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."DECLARATION_DSN_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25044 (class 0 OID 0)
-- Dependencies: 1243
-- Name: DECLARATION_DSN_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."DECLARATION_DSN_ID_seq" OWNED BY "OpenConcerto48"."DECLARATION_DSN"."ID";


--
-- TOC entry 1244 (class 1259 OID 6918132)
-- Name: DEMANDE_ACHAT_ELEMENT; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."DEMANDE_ACHAT_ELEMENT" (
    "ID" integer NOT NULL,
    "CODE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(256) DEFAULT ''::character varying NOT NULL,
    "QTE" integer DEFAULT 1 NOT NULL,
    "QTE_UNITAIRE" numeric(16,6) DEFAULT 1 NOT NULL,
    "REPERE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "REFERENCE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ID_FABRICANT" integer DEFAULT 1,
    "DATE" date,
    "ID_ETAT_DEMANDE_ACHAT_ELEMENT" integer DEFAULT 1,
    "ID_UNITE_VENTE" integer DEFAULT 1,
    "ID_ARTICLE" integer DEFAULT 1,
    "ID_FAMILLE_ARTICLE" integer DEFAULT 1,
    "ID_FOURNISSEUR" integer DEFAULT 1,
    "EN_STOCK" boolean DEFAULT false NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8),
    "REPERE_SOURCE" character varying(128) DEFAULT ''::character varying NOT NULL,
    "CODE_SOURCE" character varying(128) DEFAULT ''::character varying NOT NULL,
    "NOM_SOURCE" character varying(128) DEFAULT ''::character varying NOT NULL,
    "NUMERO_SE" character varying(128) DEFAULT ''::character varying NOT NULL,
    "DESCRIPTIF_SE" character varying(512) DEFAULT ''::character varying NOT NULL,
    "REVISION" character varying(48) DEFAULT ''::character varying NOT NULL,
    "P_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "T_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "ID_COMMANDE" integer DEFAULT 1,
    "ID_BON_RECEPTION" integer DEFAULT 1,
    "QTE_RECUE" integer DEFAULT 0 NOT NULL,
    "REPRISE" boolean DEFAULT false NOT NULL,
    "IMPORT" boolean DEFAULT false NOT NULL
);


ALTER TABLE "OpenConcerto48"."DEMANDE_ACHAT_ELEMENT" OWNER TO openconcerto;

--
-- TOC entry 1245 (class 1259 OID 6918165)
-- Name: DEMANDE_ACHAT_ELEMENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."DEMANDE_ACHAT_ELEMENT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."DEMANDE_ACHAT_ELEMENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25045 (class 0 OID 0)
-- Dependencies: 1245
-- Name: DEMANDE_ACHAT_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."DEMANDE_ACHAT_ELEMENT_ID_seq" OWNED BY "OpenConcerto48"."DEMANDE_ACHAT_ELEMENT"."ID";


--
-- TOC entry 1246 (class 1259 OID 6918167)
-- Name: DEMANDE_PRIX; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."DEMANDE_PRIX" (
    "ID" integer NOT NULL,
    "NUMERO" character varying(256) DEFAULT ''::character varying NOT NULL,
    "OBJET" character varying(1024) DEFAULT ''::character varying NOT NULL,
    "ID_FOURNISSEUR" integer DEFAULT 1,
    "DATE" date,
    "DATE_BUTOIRE" date,
    "T_HT" bigint DEFAULT 0,
    "T_TVA" bigint DEFAULT 0,
    "T_TTC" bigint DEFAULT 0,
    "ID_COMMERCIAL" integer DEFAULT 1,
    "ID_ETAT_DEMANDE_PRIX" integer DEFAULT 1,
    "INFOS" character varying(1024) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8)
);


ALTER TABLE "OpenConcerto48"."DEMANDE_PRIX" OWNER TO openconcerto;

--
-- TOC entry 1247 (class 1259 OID 6918183)
-- Name: DEMANDE_PRIX_ELEMENT; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."DEMANDE_PRIX_ELEMENT" (
    "ID" integer NOT NULL,
    "NOM" character varying(512) DEFAULT ''::character varying NOT NULL,
    "ID_DEMANDE_PRIX" integer DEFAULT 1,
    "ID_TAXE" integer DEFAULT 2,
    "QTE" integer DEFAULT 0 NOT NULL,
    "VALEUR_METRIQUE_3" real DEFAULT 0,
    "PRIX_METRIQUE_VT_3" bigint DEFAULT 0,
    "PA_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "PRIX_METRIQUE_HA_2" numeric(16,6) DEFAULT 0 NOT NULL,
    "PRIX_METRIQUE_HA_1" numeric(16,6) DEFAULT 0 NOT NULL,
    "T_PA_TTC" numeric(16,2) DEFAULT 0 NOT NULL,
    "VALEUR_METRIQUE_1" real DEFAULT 0,
    "T_PA_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "T_POIDS" real DEFAULT 0,
    "VALEUR_METRIQUE_2" real DEFAULT 0,
    "PRIX_METRIQUE_HA_3" numeric(16,6) DEFAULT 0 NOT NULL,
    "PRIX_METRIQUE_VT_2" numeric(16,6) DEFAULT 0 NOT NULL,
    "PRIX_METRIQUE_VT_1" numeric(16,6) DEFAULT 0 NOT NULL,
    "T_PV_TTC" numeric(16,2) DEFAULT 0 NOT NULL,
    "ID_METRIQUE_1" integer DEFAULT 1,
    "ID_MODE_VENTE_ARTICLE" integer DEFAULT 5,
    "ID_METRIQUE_3" integer DEFAULT 1,
    "ID_STYLE" integer DEFAULT 1,
    "ID_METRIQUE_2" integer DEFAULT 1,
    "QTE_ACHAT" integer DEFAULT 1 NOT NULL,
    "ID_DEVISE" integer DEFAULT 1,
    "ID_FAMILLE_ARTICLE" integer DEFAULT 1,
    "CODE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "SERVICE" boolean DEFAULT false,
    "T_PV_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "PV_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "POIDS" real DEFAULT 0,
    "PA_DEVISE" numeric(16,6) DEFAULT 0 NOT NULL,
    "PA_DEVISE_T" numeric(16,6) DEFAULT 0 NOT NULL,
    "ID_ARTICLE" integer DEFAULT 1,
    "QTE_UNITAIRE" numeric(16,6) DEFAULT 1 NOT NULL,
    "ID_UNITE_VENTE" 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 NOT NULL,
    "T_ECO_CONTRIBUTION" numeric(16,2) DEFAULT 0 NOT NULL,
    "ID_DEMANDE_ACHAT_ELEMENT" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8),
    "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 "OpenConcerto48"."DEMANDE_PRIX_ELEMENT" OWNER TO openconcerto;

--
-- TOC entry 1248 (class 1259 OID 6918239)
-- Name: DEMANDE_PRIX_ELEMENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."DEMANDE_PRIX_ELEMENT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."DEMANDE_PRIX_ELEMENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25046 (class 0 OID 0)
-- Dependencies: 1248
-- Name: DEMANDE_PRIX_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."DEMANDE_PRIX_ELEMENT_ID_seq" OWNED BY "OpenConcerto48"."DEMANDE_PRIX_ELEMENT"."ID";


--
-- TOC entry 1249 (class 1259 OID 6918241)
-- Name: DEMANDE_PRIX_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."DEMANDE_PRIX_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."DEMANDE_PRIX_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25047 (class 0 OID 0)
-- Dependencies: 1249
-- Name: DEMANDE_PRIX_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."DEMANDE_PRIX_ID_seq" OWNED BY "OpenConcerto48"."DEMANDE_PRIX"."ID";


--
-- TOC entry 1250 (class 1259 OID 6918243)
-- Name: DEPARTEMENT; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."DEPARTEMENT" (
    "ARCHIVE" integer DEFAULT 0,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "NOM" character varying(100) DEFAULT ''::character varying,
    "REGION_ADMIN" character varying(100) DEFAULT ''::character varying,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ORDRE" numeric(16,8),
    "CHEF_LIEU" character varying(100) DEFAULT ''::character varying,
    "NUMERO" character varying(10) DEFAULT ''::character varying,
    "ID" integer NOT NULL,
    "CREATION_DATE" timestamp without time zone,
    "MODIFICATION_DATE" timestamp without time zone
);


ALTER TABLE "OpenConcerto48"."DEPARTEMENT" OWNER TO openconcerto;

--
-- TOC entry 1251 (class 1259 OID 6918253)
-- Name: DEPARTEMENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."DEPARTEMENT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."DEPARTEMENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25048 (class 0 OID 0)
-- Dependencies: 1251
-- Name: DEPARTEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."DEPARTEMENT_ID_seq" OWNED BY "OpenConcerto48"."DEPARTEMENT"."ID";


--
-- TOC entry 1252 (class 1259 OID 6918255)
-- Name: DEPOT_CHEQUE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."DEPOT_CHEQUE" (
    "ID" integer NOT NULL,
    "NOM" character varying(512) DEFAULT ''::character varying NOT NULL,
    "MONTANT" bigint DEFAULT 0 NOT NULL,
    "DATE" date,
    "ID_BANQUE" integer DEFAULT 1,
    "ID_ECRITURE" integer DEFAULT 1,
    "ID_MOUVEMENT" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8)
);


ALTER TABLE "OpenConcerto48"."DEPOT_CHEQUE" OWNER TO openconcerto;

--
-- TOC entry 1253 (class 1259 OID 6918267)
-- Name: DEPOT_CHEQUE_ELEMENT; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."DEPOT_CHEQUE_ELEMENT" (
    "ID" integer NOT NULL,
    "NUMERO" character varying(128) DEFAULT ''::character varying NOT NULL,
    "BANQUE" character varying(128) DEFAULT ''::character varying NOT NULL,
    "PIECE" character varying(512) DEFAULT ''::character varying NOT NULL,
    "MONTANT" bigint DEFAULT 0 NOT NULL,
    "DATE" date,
    "ID_CHEQUE_A_ENCAISSER" integer DEFAULT 1,
    "ID_ECRITURE" integer DEFAULT 1,
    "ID_CLIENT" integer DEFAULT 1,
    "ID_DEPOT_CHEQUE" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8),
    "TIERS" character varying(256) DEFAULT ''::character varying NOT NULL
);


ALTER TABLE "OpenConcerto48"."DEPOT_CHEQUE_ELEMENT" OWNER TO openconcerto;

--
-- TOC entry 1254 (class 1259 OID 6918283)
-- Name: DEPOT_CHEQUE_ELEMENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."DEPOT_CHEQUE_ELEMENT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."DEPOT_CHEQUE_ELEMENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25049 (class 0 OID 0)
-- Dependencies: 1254
-- Name: DEPOT_CHEQUE_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."DEPOT_CHEQUE_ELEMENT_ID_seq" OWNED BY "OpenConcerto48"."DEPOT_CHEQUE_ELEMENT"."ID";


--
-- TOC entry 1255 (class 1259 OID 6918285)
-- Name: DEPOT_CHEQUE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."DEPOT_CHEQUE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."DEPOT_CHEQUE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25050 (class 0 OID 0)
-- Dependencies: 1255
-- Name: DEPOT_CHEQUE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."DEPOT_CHEQUE_ID_seq" OWNED BY "OpenConcerto48"."DEPOT_CHEQUE"."ID";


--
-- TOC entry 1256 (class 1259 OID 6918287)
-- Name: DEPOT_STOCK; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."DEPOT_STOCK" (
    "ID" integer NOT NULL,
    "CODE" character varying(25) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(256) DEFAULT ''::character varying NOT NULL,
    "UI_LOCK" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ID_USER_UI_LOCK" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8)
);


ALTER TABLE "OpenConcerto48"."DEPOT_STOCK" OWNER TO openconcerto;

--
-- TOC entry 1257 (class 1259 OID 6918298)
-- Name: DEPOT_STOCK_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."DEPOT_STOCK_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."DEPOT_STOCK_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25051 (class 0 OID 0)
-- Dependencies: 1257
-- Name: DEPOT_STOCK_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."DEPOT_STOCK_ID_seq" OWNED BY "OpenConcerto48"."DEPOT_STOCK"."ID";


--
-- TOC entry 1258 (class 1259 OID 6918300)
-- Name: DEVIS; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."DEVIS" (
    "T_POIDS" real DEFAULT 0,
    "DATE_ENVOI" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "T_SERVICE" bigint DEFAULT 0,
    "ID_DEVIS" integer NOT NULL,
    "ORDRE" numeric(16,8),
    "ID_ADRESSE" integer DEFAULT 1,
    "ID_ETAT_DEVIS" integer DEFAULT 1,
    "T_TTC" bigint DEFAULT 0,
    "OBJET" character varying(100) DEFAULT ''::character varying,
    "NUMERO" character varying(2048) DEFAULT ''::text,
    "PORT_HT" bigint DEFAULT 0,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "MODIFICATION_DATE" timestamp without time zone,
    "REMISE_HT" bigint DEFAULT 0,
    "T_HT" bigint DEFAULT 0,
    "DATE" date,
    "T_TVA" bigint DEFAULT 0,
    "INFOS" character varying(2048) DEFAULT ''::text,
    "CREATION_DATE" timestamp without time zone,
    "ID_CLIENT" integer DEFAULT 1,
    "ID_COMMERCIAL" integer DEFAULT 1,
    "DATE_VALIDITE" date,
    "T_DEVISE" bigint DEFAULT 0,
    "ID_TARIF" integer DEFAULT 1,
    "ID_MODELE" 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,
    "T_HA" bigint DEFAULT 0 NOT NULL,
    "DUNNING_DATE" date,
    "T_ECO_CONTRIBUTION" bigint DEFAULT 0,
    "ID_TAXE_PORT" integer DEFAULT 1,
    "T_ACOMPTE" bigint DEFAULT 0 NOT NULL,
    "FRAIS_DOCUMENT_HT" bigint DEFAULT 0 NOT NULL,
    "ID_TAXE_FRAIS_DOCUMENT" integer DEFAULT 1,
    "ID_CATEGORIE_COMPTABLE" integer DEFAULT 1,
    "DATE_LIVRAISON" date,
    "TRANSFORMATION" character varying(200) DEFAULT ''::character varying NOT NULL,
    "MONTANT_INTERFEL_HT" bigint DEFAULT 0 NOT NULL
);


ALTER TABLE "OpenConcerto48"."DEVIS" OWNER TO openconcerto;

--
-- TOC entry 1259 (class 1259 OID 6918337)
-- Name: DEVISE_HISTORIQUE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."DEVISE_HISTORIQUE" (
    "ID" integer NOT NULL,
    "DATE" timestamp without time zone,
    "SRC" character varying(8) DEFAULT ''::character varying NOT NULL,
    "DST" character varying(8) DEFAULT ''::character varying NOT NULL,
    "TAUX" numeric(12,6) DEFAULT 1 NOT NULL,
    "TAUX_COMMERCIAL" numeric(12,6) DEFAULT 1 NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "OpenConcerto48"."DEVISE_HISTORIQUE" OWNER TO openconcerto;

--
-- TOC entry 1260 (class 1259 OID 6918346)
-- Name: DEVISE_HISTORIQUE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."DEVISE_HISTORIQUE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."DEVISE_HISTORIQUE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25052 (class 0 OID 0)
-- Dependencies: 1260
-- Name: DEVISE_HISTORIQUE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."DEVISE_HISTORIQUE_ID_seq" OWNED BY "OpenConcerto48"."DEVISE_HISTORIQUE"."ID";


--
-- TOC entry 1261 (class 1259 OID 6918348)
-- Name: DEVIS_ELEMENT; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."DEVIS_ELEMENT" (
    "PRIX_METRIQUE_VT_2" numeric(16,6) DEFAULT 0 NOT NULL,
    "PV_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "QTE" integer DEFAULT 1,
    "SERVICE" boolean DEFAULT false,
    "PA_HT" 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_MODE_VENTE_ARTICLE" integer DEFAULT 1,
    "ORDRE" numeric(16,8),
    "ID_TAXE" integer DEFAULT 1,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "PRIX_METRIQUE_HA_2" numeric(16,6) DEFAULT 0 NOT NULL,
    "ID_STYLE" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "T_PV_TTC" numeric(16,2) DEFAULT 0 NOT NULL,
    "PRIX_METRIQUE_HA_1" numeric(16,6) DEFAULT 0 NOT NULL,
    "T_PV_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "ID_DEVIS" integer DEFAULT 1,
    "PRIX_METRIQUE_HA_3" numeric(16,6) DEFAULT 0 NOT NULL,
    "NOM" character varying(2048) DEFAULT ''::text,
    "VALEUR_METRIQUE_1" real DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ID_METRIQUE_3" integer DEFAULT 1,
    "ID_METRIQUE_1" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "T_PA_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "POIDS" real DEFAULT 0,
    "ID_METRIQUE_2" integer DEFAULT 1,
    "T_POIDS" real DEFAULT 0,
    "CODE" character varying(45) DEFAULT ''::text,
    "PRIX_METRIQUE_VT_1" numeric(16,6) DEFAULT 0 NOT NULL,
    "ID_DEVIS_ELEMENT" integer NOT NULL,
    "VALEUR_METRIQUE_2" real 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_DEPOT_STOCK" integer DEFAULT 1,
    "LIVRE_FORCED" boolean DEFAULT false NOT NULL,
    "LIVRE" boolean DEFAULT false NOT NULL,
    "QTE_LIVREE" numeric(16,6) DEFAULT 0,
    "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 "OpenConcerto48"."DEVIS_ELEMENT" OWNER TO openconcerto;

--
-- TOC entry 1262 (class 1259 OID 6918412)
-- Name: DEVIS_ELEMENT_ID_DEVIS_ELEMENT_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."DEVIS_ELEMENT_ID_DEVIS_ELEMENT_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."DEVIS_ELEMENT_ID_DEVIS_ELEMENT_seq" OWNER TO openconcerto;

--
-- TOC entry 25053 (class 0 OID 0)
-- Dependencies: 1262
-- Name: DEVIS_ELEMENT_ID_DEVIS_ELEMENT_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."DEVIS_ELEMENT_ID_DEVIS_ELEMENT_seq" OWNED BY "OpenConcerto48"."DEVIS_ELEMENT"."ID_DEVIS_ELEMENT";


--
-- TOC entry 1263 (class 1259 OID 6918414)
-- Name: DEVIS_ID_DEVIS_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."DEVIS_ID_DEVIS_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."DEVIS_ID_DEVIS_seq" OWNER TO openconcerto;

--
-- TOC entry 25054 (class 0 OID 0)
-- Dependencies: 1263
-- Name: DEVIS_ID_DEVIS_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."DEVIS_ID_DEVIS_seq" OWNED BY "OpenConcerto48"."DEVIS"."ID_DEVIS";


--
-- TOC entry 1264 (class 1259 OID 6918416)
-- Name: ECHANTILLON_ELEMENT; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."ECHANTILLON_ELEMENT" (
    "ID_TAXE" integer DEFAULT 1,
    "ID" integer NOT NULL,
    "NOM" character varying(128) DEFAULT ''::character varying NOT NULL,
    "PV_HT" bigint DEFAULT 0,
    "T_PV_HT" bigint DEFAULT 0,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_SAISIE_VENTE_FACTURE" integer DEFAULT 1,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "CREATION_DATE" timestamp without time zone,
    "ARCHIVE" integer DEFAULT 0,
    "QTE" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "T_PV_TTC" bigint DEFAULT 0
);


ALTER TABLE "OpenConcerto48"."ECHANTILLON_ELEMENT" OWNER TO openconcerto;

--
-- TOC entry 1265 (class 1259 OID 6918430)
-- Name: ECHANTILLON_ELEMENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."ECHANTILLON_ELEMENT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."ECHANTILLON_ELEMENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25055 (class 0 OID 0)
-- Dependencies: 1265
-- Name: ECHANTILLON_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."ECHANTILLON_ELEMENT_ID_seq" OWNED BY "OpenConcerto48"."ECHANTILLON_ELEMENT"."ID";


--
-- TOC entry 1266 (class 1259 OID 6918432)
-- Name: ECHEANCE_CLIENT; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."ECHEANCE_CLIENT" (
    "MODIFICATION_DATE" timestamp without time zone,
    "CREATION_DATE" timestamp without time zone,
    "REG_COMPTA" boolean DEFAULT false,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "DATE_LAST_RELANCE" date,
    "ID_MOUVEMENT" integer DEFAULT 1,
    "ORDRE" numeric(16,8),
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "MONTANT" bigint DEFAULT 0,
    "REGLE" boolean DEFAULT false,
    "ARCHIVE" integer DEFAULT 0,
    "INFOS" character varying(2048) DEFAULT ''::text,
    "ID_CLIENT" integer DEFAULT 1,
    "RETOUR_NATEXIS" boolean DEFAULT false,
    "NOMBRE_RELANCE" integer DEFAULT 0,
    "DATE" date,
    "ID" integer NOT NULL,
    "ID_SAISIE_VENTE_FACTURE" integer DEFAULT 1,
    "TIERS" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ID_COMPTE_PCE_TIERS" integer DEFAULT 1,
    "ID_SEPA_MANDATE" integer,
    "ID_SDD_MESSAGE" integer,
    "SDD_EndToEndId" character varying(35) DEFAULT ''::character varying NOT NULL,
    "FICHIER_CREE" boolean DEFAULT false NOT NULL,
    "REJETER" boolean DEFAULT false NOT NULL,
    "ETS" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ID_BANQUE" integer DEFAULT 1,
    "RG" boolean DEFAULT false NOT NULL
);


ALTER TABLE "OpenConcerto48"."ECHEANCE_CLIENT" OWNER TO openconcerto;

--
-- TOC entry 1267 (class 1259 OID 6918458)
-- Name: ECHEANCE_CLIENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."ECHEANCE_CLIENT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."ECHEANCE_CLIENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25056 (class 0 OID 0)
-- Dependencies: 1267
-- Name: ECHEANCE_CLIENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."ECHEANCE_CLIENT_ID_seq" OWNED BY "OpenConcerto48"."ECHEANCE_CLIENT"."ID";


--
-- TOC entry 1268 (class 1259 OID 6918460)
-- Name: ECHEANCE_FOURNISSEUR; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."ECHEANCE_FOURNISSEUR" (
    "ID_MOUVEMENT" integer DEFAULT 1,
    "MONTANT" bigint DEFAULT 0,
    "CREATION_DATE" timestamp without time zone,
    "ARCHIVE" integer DEFAULT 0,
    "ID_FOURNISSEUR" integer DEFAULT 1,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "REGLE" boolean DEFAULT false,
    "ORDRE" numeric(16,8),
    "MODIFICATION_DATE" timestamp without time zone,
    "ID" integer NOT NULL,
    "DATE" date,
    "REG_COMPTA" boolean DEFAULT false,
    "ID_FACTURE_FOURNISSEUR" integer DEFAULT 1
);


ALTER TABLE "OpenConcerto48"."ECHEANCE_FOURNISSEUR" OWNER TO openconcerto;

--
-- TOC entry 1269 (class 1259 OID 6918472)
-- Name: ECHEANCE_FOURNISSEUR_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."ECHEANCE_FOURNISSEUR_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."ECHEANCE_FOURNISSEUR_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25057 (class 0 OID 0)
-- Dependencies: 1269
-- Name: ECHEANCE_FOURNISSEUR_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."ECHEANCE_FOURNISSEUR_ID_seq" OWNED BY "OpenConcerto48"."ECHEANCE_FOURNISSEUR"."ID";


--
-- TOC entry 1270 (class 1259 OID 6918474)
-- Name: ECRITURE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."ECRITURE" (
    "ID_COMPTE_PCE" integer DEFAULT 1,
    "DATE_POINTEE" date,
    "DATE_LETTRAGE" date,
    "JOURNAL_NOM" character varying(2048) DEFAULT ''::text,
    "CREATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "POINTEE" character varying(45) DEFAULT ''::character varying,
    "DATE" date,
    "ID_MOUVEMENT" integer DEFAULT 1,
    "DEBIT" bigint DEFAULT 0,
    "CREDIT" bigint DEFAULT 0,
    "ID_JOURNAL" integer DEFAULT 1,
    "IDUSER_VALIDE" integer DEFAULT 1,
    "ID" integer NOT NULL,
    "IDUSER_CREATE" integer DEFAULT 1,
    "COMPTE_NUMERO" character varying(2048) DEFAULT ''::text,
    "ARCHIVE" integer DEFAULT 0,
    "MODIFICATION_DATE" timestamp without time zone,
    "COMPTE_NOM" character varying(2048) DEFAULT ''::text,
    "LETTRAGE" character varying(256) DEFAULT ''::character varying,
    "NOM" character varying(2048) DEFAULT ''::text,
    "JOURNAL_CODE" character varying(2048) DEFAULT ''::text,
    "VALIDE" boolean DEFAULT false,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ORDRE" numeric(16,8),
    "IDUSER_DELETE" integer DEFAULT 1,
    "DATE_VALIDE" date,
    "DATE_EXPORT" date,
    "CODE_CLIENT" character varying(256) DEFAULT ''::character varying NOT NULL,
    "NOM_PIECE" character varying(1024) DEFAULT ''::character varying NOT NULL,
    "CLOTURE" boolean DEFAULT false NOT NULL,
    "RAN" boolean DEFAULT false NOT NULL,
    "DATE_ECHEANCE" date,
    "LETTRAGE_PARTIEL" character varying(256) DEFAULT ''::character varying NOT NULL
);


ALTER TABLE "OpenConcerto48"."ECRITURE" OWNER TO openconcerto;

--
-- TOC entry 1271 (class 1259 OID 6918504)
-- Name: ECRITURE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."ECRITURE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."ECRITURE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25058 (class 0 OID 0)
-- Dependencies: 1271
-- Name: ECRITURE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."ECRITURE_ID_seq" OWNED BY "OpenConcerto48"."ECRITURE"."ID";


--
-- TOC entry 1272 (class 1259 OID 6918506)
-- Name: EMPLOYEUR_MULTIPLE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

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


ALTER TABLE "OpenConcerto48"."EMPLOYEUR_MULTIPLE" OWNER TO openconcerto;

--
-- TOC entry 1273 (class 1259 OID 6918513)
-- Name: EMPLOYEUR_MULTIPLE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."EMPLOYEUR_MULTIPLE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."EMPLOYEUR_MULTIPLE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25059 (class 0 OID 0)
-- Dependencies: 1273
-- Name: EMPLOYEUR_MULTIPLE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."EMPLOYEUR_MULTIPLE_ID_seq" OWNED BY "OpenConcerto48"."EMPLOYEUR_MULTIPLE"."ID";


--
-- TOC entry 1274 (class 1259 OID 6918515)
-- Name: ENCAISSER_MONTANT; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."ENCAISSER_MONTANT" (
    "ID_MODE_REGLEMENT" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "CREATION_DATE" timestamp without time zone,
    "ID" integer NOT NULL,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "MONTANT" bigint DEFAULT 0,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_ECHEANCE_CLIENT" integer DEFAULT 1,
    "ID_MOUVEMENT" integer DEFAULT 1,
    "NOM" character varying(200),
    "MODIFICATION_DATE" timestamp without time zone,
    "DATE" date,
    "ID_CLIENT" integer DEFAULT 1,
    "ID_TICKET_CAISSE" integer DEFAULT 1,
    "ORDRE" numeric(16,8),
    "ACOMPTE" boolean DEFAULT false NOT NULL,
    "ID_DEVIS" integer DEFAULT 1,
    "TIERS" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ID_COMPTE_PCE_TIERS" integer DEFAULT 1,
    "ID_COMMANDE_CLIENT" integer DEFAULT 1
);


ALTER TABLE "OpenConcerto48"."ENCAISSER_MONTANT" OWNER TO openconcerto;

--
-- TOC entry 1275 (class 1259 OID 6918532)
-- Name: ENCAISSER_MONTANT_ELEMENT; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."ENCAISSER_MONTANT_ELEMENT" (
    "MONTANT_A_REGLER" bigint DEFAULT 0,
    "MONTANT_REGLE" bigint DEFAULT 0,
    "ID_MOUVEMENT_ECHEANCE" integer DEFAULT 1,
    "ID" integer NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "ID_ENCAISSER_MONTANT" integer DEFAULT 1,
    "ID_ECHEANCE_CLIENT" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "DATE" date
);


ALTER TABLE "OpenConcerto48"."ENCAISSER_MONTANT_ELEMENT" OWNER TO openconcerto;

--
-- TOC entry 1276 (class 1259 OID 6918542)
-- Name: ENCAISSER_MONTANT_ELEMENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."ENCAISSER_MONTANT_ELEMENT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."ENCAISSER_MONTANT_ELEMENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25060 (class 0 OID 0)
-- Dependencies: 1276
-- Name: ENCAISSER_MONTANT_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."ENCAISSER_MONTANT_ELEMENT_ID_seq" OWNED BY "OpenConcerto48"."ENCAISSER_MONTANT_ELEMENT"."ID";


--
-- TOC entry 1277 (class 1259 OID 6918544)
-- Name: ENCAISSER_MONTANT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."ENCAISSER_MONTANT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."ENCAISSER_MONTANT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25061 (class 0 OID 0)
-- Dependencies: 1277
-- Name: ENCAISSER_MONTANT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."ENCAISSER_MONTANT_ID_seq" OWNED BY "OpenConcerto48"."ENCAISSER_MONTANT"."ID";


--
-- TOC entry 1278 (class 1259 OID 6918546)
-- Name: ETAT_CIVIL; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."ETAT_CIVIL" (
    "ID_DEPARTEMENT_NAISSANCE" integer DEFAULT 1,
    "PORTABLE" character varying(45) DEFAULT ''::character varying,
    "ID_SITUATION_FAMILIALE" integer DEFAULT 1,
    "MAIL" character varying(45) DEFAULT ''::character varying,
    "ARCHIVE" integer DEFAULT 0,
    "DATE_NAISSANCE" date,
    "NB_PERS_A_CHARGE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "CREATION_DATE" timestamp without time zone,
    "COMMUNE_NAISSANCE" character varying(45) DEFAULT ''::character varying,
    "ID" integer NOT NULL,
    "NB_ENFANTS" integer DEFAULT 0,
    "ID_ADRESSE" integer DEFAULT 1,
    "ID_PAYS_NAISSANCE" integer DEFAULT 1,
    "NUMERO_SS" character varying(45) DEFAULT ''::character varying,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "TELEPHONE" character varying(45) DEFAULT ''::character varying,
    "NATIONNALITE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "CNPS" character varying(256) DEFAULT ''::character varying NOT NULL,
    "TYPE_PIECE_IDENTITE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "NUMERO_PIECE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "NOM_PERE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "NOM_MERE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "CONJOINT_NOM" character varying(256) DEFAULT ''::character varying NOT NULL,
    "CONJOINT_DATE_NAISSANCE" date,
    "CONJOINT_LIEU_NAISSANCE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "CONJOINT_PROFESSION" character varying(256) DEFAULT ''::character varying NOT NULL,
    "DATE_DEBUT_PIECE" date,
    "DATE_FIN_PIECE" date,
    "NTT" character varying(50) DEFAULT ''::character varying NOT NULL
);


ALTER TABLE "OpenConcerto48"."ETAT_CIVIL" OWNER TO openconcerto;

--
-- TOC entry 1279 (class 1259 OID 6918576)
-- Name: ETAT_CIVIL_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."ETAT_CIVIL_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."ETAT_CIVIL_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25062 (class 0 OID 0)
-- Dependencies: 1279
-- Name: ETAT_CIVIL_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."ETAT_CIVIL_ID_seq" OWNED BY "OpenConcerto48"."ETAT_CIVIL"."ID";


--
-- TOC entry 1280 (class 1259 OID 6918578)
-- Name: ETAT_DEMANDE_ACHAT_ELEMENT; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

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


ALTER TABLE "OpenConcerto48"."ETAT_DEMANDE_ACHAT_ELEMENT" OWNER TO openconcerto;

--
-- TOC entry 1281 (class 1259 OID 6918583)
-- Name: ETAT_DEMANDE_ACHAT_ELEMENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."ETAT_DEMANDE_ACHAT_ELEMENT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."ETAT_DEMANDE_ACHAT_ELEMENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25063 (class 0 OID 0)
-- Dependencies: 1281
-- Name: ETAT_DEMANDE_ACHAT_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."ETAT_DEMANDE_ACHAT_ELEMENT_ID_seq" OWNED BY "OpenConcerto48"."ETAT_DEMANDE_ACHAT_ELEMENT"."ID";


--
-- TOC entry 1282 (class 1259 OID 6918585)
-- Name: ETAT_DEMANDE_PRIX; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."ETAT_DEMANDE_PRIX" (
    "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 "OpenConcerto48"."ETAT_DEMANDE_PRIX" OWNER TO openconcerto;

--
-- TOC entry 1283 (class 1259 OID 6918590)
-- Name: ETAT_DEMANDE_PRIX_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."ETAT_DEMANDE_PRIX_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."ETAT_DEMANDE_PRIX_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25064 (class 0 OID 0)
-- Dependencies: 1283
-- Name: ETAT_DEMANDE_PRIX_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."ETAT_DEMANDE_PRIX_ID_seq" OWNED BY "OpenConcerto48"."ETAT_DEMANDE_PRIX"."ID";


--
-- TOC entry 1284 (class 1259 OID 6918592)
-- Name: ETAT_DEVIS; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

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


ALTER TABLE "OpenConcerto48"."ETAT_DEVIS" OWNER TO openconcerto;

--
-- TOC entry 1285 (class 1259 OID 6918600)
-- Name: ETAT_DEVIS_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE SEQUENCE "OpenConcerto48"."ETAT_DEVIS_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto48"."ETAT_DEVIS_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 25065 (class 0 OID 0)
-- Dependencies: 1285
-- Name: ETAT_DEVIS_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

ALTER SEQUENCE "OpenConcerto48"."ETAT_DEVIS_ID_seq" OWNED BY "OpenConcerto48"."ETAT_DEVIS"."ID";


--
-- TOC entry 1286 (class 1259 OID 6918602)
-- Name: ETAT_RAPPORT; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 1287 (class 1259 OID 6918612)
-- Name: ETAT_RAPPORT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25066 (class 0 OID 0)
-- Dependencies: 1287
-- Name: ETAT_RAPPORT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1288 (class 1259 OID 6918614)
-- Name: ETAT_STOCK; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."ETAT_STOCK" OWNER TO openconcerto;

--
-- TOC entry 1289 (class 1259 OID 6918622)
-- Name: ETAT_STOCK_ELEMENT; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."ETAT_STOCK_ELEMENT" OWNER TO openconcerto;

--
-- TOC entry 1290 (class 1259 OID 6918639)
-- Name: ETAT_STOCK_ELEMENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25067 (class 0 OID 0)
-- Dependencies: 1290
-- Name: ETAT_STOCK_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1291 (class 1259 OID 6918641)
-- Name: ETAT_STOCK_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25068 (class 0 OID 0)
-- Dependencies: 1291
-- Name: ETAT_STOCK_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1292 (class 1259 OID 6918643)
-- Name: FABRICANT; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."FABRICANT" OWNER TO openconcerto;

--
-- TOC entry 1293 (class 1259 OID 6918648)
-- Name: FABRICANT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25069 (class 0 OID 0)
-- Dependencies: 1293
-- Name: FABRICANT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1294 (class 1259 OID 6918650)
-- Name: FACTURATION_COMMANDE_CLIENT; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."FACTURATION_COMMANDE_CLIENT" OWNER TO openconcerto;

--
-- TOC entry 1295 (class 1259 OID 6918667)
-- Name: FACTURATION_COMMANDE_CLIENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25070 (class 0 OID 0)
-- Dependencies: 1295
-- Name: FACTURATION_COMMANDE_CLIENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1296 (class 1259 OID 6918669)
-- Name: FACTURE_FOURNISSEUR; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."FACTURE_FOURNISSEUR" OWNER TO openconcerto;

--
-- TOC entry 1297 (class 1259 OID 6918702)
-- Name: FACTURE_FOURNISSEUR_ELEMENT; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."FACTURE_FOURNISSEUR_ELEMENT" OWNER TO openconcerto;

--
-- TOC entry 1298 (class 1259 OID 6918760)
-- Name: FACTURE_FOURNISSEUR_ELEMENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25071 (class 0 OID 0)
-- Dependencies: 1298
-- Name: FACTURE_FOURNISSEUR_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1299 (class 1259 OID 6918762)
-- Name: FACTURE_FOURNISSEUR_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25072 (class 0 OID 0)
-- Dependencies: 1299
-- Name: FACTURE_FOURNISSEUR_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1300 (class 1259 OID 6918764)
-- Name: FAMILLE_ARTICLE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 1301 (class 1259 OID 6918775)
-- Name: FAMILLE_ARTICLE_FOURNISSEUR; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."FAMILLE_ARTICLE_FOURNISSEUR" OWNER TO openconcerto;

--
-- TOC entry 1302 (class 1259 OID 6918786)
-- Name: FAMILLE_ARTICLE_FOURNISSEUR_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25073 (class 0 OID 0)
-- Dependencies: 1302
-- Name: FAMILLE_ARTICLE_FOURNISSEUR_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1303 (class 1259 OID 6918788)
-- Name: FAMILLE_ARTICLE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25074 (class 0 OID 0)
-- Dependencies: 1303
-- Name: FAMILLE_ARTICLE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1304 (class 1259 OID 6918790)
-- Name: FICHE_PAYE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."FICHE_PAYE" (
    "ID_VARIABLE_SALARIE" integer DEFAULT 1,
    "VALIDE" boolean DEFAULT false,
    "DU" date,
    "NET_A_PAYER" numeric(16,2) DEFAULT 0,
    "ORDRE" numeric(16,8),
    "NET_IMP" numeric(16,2) DEFAULT 0,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_CUMULS_CONGES" integer DEFAULT 1,
    "ID_IDCC" integer DEFAULT 1,
    "COT_PAT" numeric(16,2) DEFAULT 0,
    "ID_REGLEMENT_PAYE" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "NATURE_EMPLOI" character varying(150) DEFAULT ''::character varying,
    "ID" integer NOT NULL,
    "SAL_BRUT" numeric(16,2) DEFAULT 0,
    "CREATION_DATE" timestamp without time zone,
    "AU" date,
    "ACOMPTE" numeric(16,2) DEFAULT 0,
    "ID_MOIS" integer DEFAULT 1,
    "ID_CUMULS_PAYE" integer DEFAULT 1,
    "COT_SAL" numeric(16,2) DEFAULT 0,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CONGES_ACQUIS" real DEFAULT 0,
    "CSG" numeric(16,2) DEFAULT 0,
    "ANNEE" integer DEFAULT 0,
    "ID_SALARIE" integer DEFAULT 1,
    "ID_PROFIL_PAYE" integer DEFAULT 1,
    "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 "OpenConcerto48"."FICHE_PAYE" OWNER TO openconcerto;

--
-- TOC entry 1305 (class 1259 OID 6918837)
-- Name: FICHE_PAYE_ELEMENT; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 1306 (class 1259 OID 6918861)
-- Name: FICHE_PAYE_ELEMENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25075 (class 0 OID 0)
-- Dependencies: 1306
-- Name: FICHE_PAYE_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1307 (class 1259 OID 6918863)
-- Name: FICHE_PAYE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25076 (class 0 OID 0)
-- Dependencies: 1307
-- Name: FICHE_PAYE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1308 (class 1259 OID 6918865)
-- Name: FIN_CONTRAT; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."FIN_CONTRAT" OWNER TO openconcerto;

--
-- TOC entry 1309 (class 1259 OID 6918879)
-- Name: FIN_CONTRAT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25077 (class 0 OID 0)
-- Dependencies: 1309
-- Name: FIN_CONTRAT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1310 (class 1259 OID 6918881)
-- Name: FOURNISSEUR; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."FOURNISSEUR" (
    "TYPE" character varying(2048) DEFAULT ''::text,
    "ORDRE" numeric(16,8),
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_MODE_REGLEMENT" integer DEFAULT 1,
    "ID_COMPTE_PCE" integer DEFAULT 1,
    "CODE" character varying(2048) DEFAULT ''::text,
    "CREATION_DATE" timestamp without time zone,
    "ID_ADRESSE" integer DEFAULT 1,
    "ID_FOURNISSEUR" integer NOT NULL,
    "UE" boolean DEFAULT false,
    "ID_ADRESSE_E" integer DEFAULT 1,
    "FAX" character varying(2048) DEFAULT ''::text,
    "NOM" character varying(2048) DEFAULT ''::text,
    "TEL" character varying(2048) DEFAULT ''::text,
    "MODIFICATION_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 "OpenConcerto48"."FOURNISSEUR" OWNER TO openconcerto;

--
-- TOC entry 1311 (class 1259 OID 6918914)
-- Name: FOURNISSEUR_ID_FOURNISSEUR_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25078 (class 0 OID 0)
-- Dependencies: 1311
-- Name: FOURNISSEUR_ID_FOURNISSEUR_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1312 (class 1259 OID 6918916)
-- Name: FRAIS_DOCUMENT; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."FRAIS_DOCUMENT" OWNER TO openconcerto;

--
-- TOC entry 1313 (class 1259 OID 6918925)
-- Name: FRAIS_DOCUMENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25079 (class 0 OID 0)
-- Dependencies: 1313
-- Name: FRAIS_DOCUMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1314 (class 1259 OID 6918927)
-- Name: FWK_MODULE_DEP; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 1315 (class 1259 OID 6918930)
-- Name: FWK_MODULE_METADATA; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."FWK_MODULE_METADATA" OWNER TO openconcerto;

--
-- TOC entry 1316 (class 1259 OID 6918934)
-- Name: FWK_MODULE_METADATA_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25080 (class 0 OID 0)
-- Dependencies: 1316
-- Name: FWK_MODULE_METADATA_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1317 (class 1259 OID 6918936)
-- Name: FWK_SCHEMA_METADATA; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 1318 (class 1259 OID 6918941)
-- Name: FWK_UNDEFINED_IDS; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 1319 (class 1259 OID 6918946)
-- Name: INFOS_SALARIE_PAYE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."INFOS_SALARIE_PAYE" (
    "DUREE_HEBDO" real DEFAULT 0,
    "ORDRE" numeric(16,8),
    "TAUX_AT" real DEFAULT 0,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "SALAIRE_MOIS" real DEFAULT 0,
    "ID_CONTRAT_SALARIE" integer DEFAULT 1,
    "CONGES_PAYES" real DEFAULT 0,
    "CREATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID" integer NOT NULL,
    "DATE_SORTIE" date,
    "ID_IDCC" integer DEFAULT 1,
    "DATE_ARRIVE" date,
    "DUREE_MOIS" real DEFAULT 0,
    "ID_CLASSEMENT_CONVENTIONNEL" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "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 "OpenConcerto48"."INFOS_SALARIE_PAYE" OWNER TO openconcerto;

--
-- TOC entry 1320 (class 1259 OID 6918964)
-- Name: INFOS_SALARIE_PAYE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25081 (class 0 OID 0)
-- Dependencies: 1320
-- Name: INFOS_SALARIE_PAYE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1321 (class 1259 OID 6918966)
-- Name: JOURNAL; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 1322 (class 1259 OID 6918979)
-- Name: JOURNAL_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25082 (class 0 OID 0)
-- Dependencies: 1322
-- Name: JOURNAL_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1323 (class 1259 OID 6918981)
-- Name: LANGUE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."LANGUE" OWNER TO openconcerto;

--
-- TOC entry 1324 (class 1259 OID 6918992)
-- Name: LANGUE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25083 (class 0 OID 0)
-- Dependencies: 1324
-- Name: LANGUE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1325 (class 1259 OID 6918994)
-- Name: LOT; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."LOT" OWNER TO openconcerto;

--
-- TOC entry 1326 (class 1259 OID 6919005)
-- Name: LOT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25084 (class 0 OID 0)
-- Dependencies: 1326
-- Name: LOT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1327 (class 1259 OID 6919007)
-- Name: LOT_LIVRAISON; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."LOT_LIVRAISON" OWNER TO openconcerto;

--
-- TOC entry 1328 (class 1259 OID 6919023)
-- Name: LOT_LIVRAISON_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25085 (class 0 OID 0)
-- Dependencies: 1328
-- Name: LOT_LIVRAISON_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1329 (class 1259 OID 6919025)
-- Name: LOT_RECEPTION; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."LOT_RECEPTION" OWNER TO openconcerto;

--
-- TOC entry 1330 (class 1259 OID 6919041)
-- Name: LOT_RECEPTION_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25086 (class 0 OID 0)
-- Dependencies: 1330
-- Name: LOT_RECEPTION_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1331 (class 1259 OID 6919043)
-- Name: METRIQUE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 1332 (class 1259 OID 6919051)
-- Name: METRIQUE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25087 (class 0 OID 0)
-- Dependencies: 1332
-- Name: METRIQUE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1333 (class 1259 OID 6919053)
-- Name: MODELE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."MODELE" OWNER TO openconcerto;

--
-- TOC entry 1334 (class 1259 OID 6919060)
-- Name: MODELE_COURRIER_CLIENT; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 1335 (class 1259 OID 6919074)
-- Name: MODELE_COURRIER_CLIENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25088 (class 0 OID 0)
-- Dependencies: 1335
-- Name: MODELE_COURRIER_CLIENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1336 (class 1259 OID 6919076)
-- Name: MODELE_EMAIL; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."MODELE_EMAIL" OWNER TO openconcerto;

--
-- TOC entry 1337 (class 1259 OID 6919089)
-- Name: MODELE_EMAIL_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25089 (class 0 OID 0)
-- Dependencies: 1337
-- Name: MODELE_EMAIL_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1338 (class 1259 OID 6919091)
-- Name: MODELE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25090 (class 0 OID 0)
-- Dependencies: 1338
-- Name: MODELE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1339 (class 1259 OID 6919093)
-- Name: MODE_REGLEMENT; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 1340 (class 1259 OID 6919114)
-- Name: MODE_REGLEMENT_ID_MODE_REGLEMENT_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25091 (class 0 OID 0)
-- Dependencies: 1340
-- Name: MODE_REGLEMENT_ID_MODE_REGLEMENT_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1341 (class 1259 OID 6919116)
-- Name: MODE_REGLEMENT_PAYE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 1342 (class 1259 OID 6919120)
-- Name: MODE_REGLEMENT_PAYE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25092 (class 0 OID 0)
-- Dependencies: 1342
-- Name: MODE_REGLEMENT_PAYE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1343 (class 1259 OID 6919122)
-- Name: MODE_VENTE_ARTICLE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 1344 (class 1259 OID 6919140)
-- Name: MODE_VENTE_ARTICLE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25093 (class 0 OID 0)
-- Dependencies: 1344
-- Name: MODE_VENTE_ARTICLE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1345 (class 1259 OID 6919142)
-- Name: MOIS; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 1346 (class 1259 OID 6919149)
-- Name: MOIS_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25094 (class 0 OID 0)
-- Dependencies: 1346
-- Name: MOIS_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1347 (class 1259 OID 6919151)
-- Name: MOUVEMENT; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 1348 (class 1259 OID 6919166)
-- Name: MOUVEMENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25095 (class 0 OID 0)
-- Dependencies: 1348
-- Name: MOUVEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1349 (class 1259 OID 6919168)
-- Name: MOUVEMENT_STOCK; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."MOUVEMENT_STOCK" (
    "ID" integer NOT NULL,
    "DATE" date,
    "NUMERO" character varying(150) DEFAULT ''::character varying,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_ARTICLE" integer DEFAULT 1,
    "QTE" real DEFAULT 0,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "IDSOURCE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ORDRE" numeric(16,8),
    "SOURCE" character varying(45) DEFAULT ''::character varying,
    "NOM" character varying(512) DEFAULT ''::character varying NOT NULL,
    "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 "OpenConcerto48"."MOUVEMENT_STOCK" OWNER TO openconcerto;

--
-- TOC entry 1350 (class 1259 OID 6919189)
-- Name: MOUVEMENT_STOCK_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25096 (class 0 OID 0)
-- Dependencies: 1350
-- Name: MOUVEMENT_STOCK_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1351 (class 1259 OID 6919191)
-- Name: NATURE_COMPTE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 1352 (class 1259 OID 6919201)
-- Name: NATURE_COMPTE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25097 (class 0 OID 0)
-- Dependencies: 1352
-- Name: NATURE_COMPTE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1353 (class 1259 OID 6919203)
-- Name: NUMEROTATION_AUTO; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."NUMEROTATION_AUTO" (
    "BON_L_FORMAT" character varying(45) DEFAULT ''::character varying,
    "RELANCE_FORMAT" character varying(45) DEFAULT ''::character varying,
    "COURRIER_START" integer DEFAULT 1,
    "AFFAIRE_START" integer DEFAULT 0,
    "DEVIS_FORMAT" character varying(45) DEFAULT ''::character varying,
    "AVOIR_START" integer DEFAULT 0,
    "SALARIE_START" integer DEFAULT 1,
    "PROPOSITION_START" integer DEFAULT 0,
    "BON_R_START" integer DEFAULT 0,
    "MODIFICATION_DATE" timestamp without time zone,
    "CREATION_DATE" timestamp without time zone,
    "FACT_START" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "FACT_FORMAT" character varying(45) DEFAULT ''::character varying,
    "SALARIE_FORMAT" character varying(45) DEFAULT ''::character varying,
    "ARCHIVE" integer DEFAULT 0,
    "COMMANDE_FORMAT" character varying(45) DEFAULT ''::character varying,
    "COMMANDE_CLIENT_START" integer DEFAULT 0,
    "COMMANDE_START" integer DEFAULT 0,
    "BON_R_FORMAT" character varying(45) DEFAULT ''::character varying,
    "BON_L_START" integer DEFAULT 1,
    "DEVIS_START" integer DEFAULT 1,
    "RELANCE_START" integer DEFAULT 0,
    "ID" integer NOT NULL,
    "PROPOSITION_FORMAT" character varying(45) DEFAULT ''::character varying,
    "AFFAIRE_FORMAT" character varying(45) DEFAULT ''::character varying,
    "COURRIER_FORMAT" character varying(45) DEFAULT ''::character varying,
    "AVOIR_FORMAT" character varying(45) DEFAULT ''::character varying,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ORDRE" numeric(16,8),
    "CODE_LETTRAGE" character varying(128) DEFAULT 'AAA'::character varying,
    "COMMANDE_CLIENT_FORMAT" character varying(45) DEFAULT ''::character varying,
    "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 "OpenConcerto48"."NUMEROTATION_AUTO" OWNER TO openconcerto;

--
-- TOC entry 1354 (class 1259 OID 6919247)
-- Name: NUMEROTATION_AUTO_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25098 (class 0 OID 0)
-- Dependencies: 1354
-- Name: NUMEROTATION_AUTO_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1355 (class 1259 OID 6919249)
-- Name: OBJECTIF_COMMERCIAL; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."OBJECTIF_COMMERCIAL" OWNER TO openconcerto;

--
-- TOC entry 1356 (class 1259 OID 6919258)
-- Name: OBJECTIF_COMMERCIAL_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25099 (class 0 OID 0)
-- Dependencies: 1356
-- Name: OBJECTIF_COMMERCIAL_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1357 (class 1259 OID 6919260)
-- Name: PAS; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."PAS" OWNER TO openconcerto;

--
-- TOC entry 1358 (class 1259 OID 6919267)
-- Name: PAS_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25100 (class 0 OID 0)
-- Dependencies: 1358
-- Name: PAS_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1359 (class 1259 OID 6919269)
-- Name: PAYS; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 1360 (class 1259 OID 6919279)
-- Name: PAYS_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25101 (class 0 OID 0)
-- Dependencies: 1360
-- Name: PAYS_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1361 (class 1259 OID 6919281)
-- Name: PIECE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 1362 (class 1259 OID 6919291)
-- Name: PIECE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25102 (class 0 OID 0)
-- Dependencies: 1362
-- Name: PIECE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1363 (class 1259 OID 6919293)
-- Name: POSTE_ANALYTIQUE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 1364 (class 1259 OID 6919306)
-- Name: POSTE_ANALYTIQUE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25103 (class 0 OID 0)
-- Dependencies: 1364
-- Name: POSTE_ANALYTIQUE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1365 (class 1259 OID 6919308)
-- Name: PREFERENCES; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 1366 (class 1259 OID 6919318)
-- Name: PREFERENCES_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25104 (class 0 OID 0)
-- Dependencies: 1366
-- Name: PREFERENCES_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1367 (class 1259 OID 6919320)
-- Name: PREFS_COMPTE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."PREFS_COMPTE" (
    "ID_COMPTE_PCE_TVA_IMMO" integer DEFAULT 1,
    "ID_COMPTE_PCE_VENTE_SERVICE" integer DEFAULT 1,
    "ID_COMPTE_PCE_VENTE_PRODUIT" integer DEFAULT 1,
    "ID_COMPTE_PCE_BILAN_O" integer DEFAULT 1,
    "ID_COMPTE_PCE_ACOMPTE" integer DEFAULT 1,
    "ID_COMPTE_PCE_TVA_VENTE" integer DEFAULT 1,
    "ID_COMPTE_PCE_ACHAT" integer DEFAULT 1,
    "ID_COMPTE_PCE_BILAN_F" integer DEFAULT 1,
    "ID_COMPTE_PCE_CLIENT" integer DEFAULT 1,
    "ID_COMPTE_PCE_ACHAT_INTRA" integer DEFAULT 1,
    "ID_COMPTE_PCE_RESULTAT_PERTE" integer DEFAULT 1,
    "ID_COMPTE_PCE_ACOMPTE_REGL" integer DEFAULT 1,
    "ID_COMPTE_PCE_FACTOR" integer DEFAULT 1,
    "ID" integer NOT NULL,
    "ID_COMPTE_PCE_TVA_ACHAT" integer DEFAULT 1,
    "ID_COMPTE_PCE_PAYE" integer DEFAULT 1,
    "ID_COMPTE_PCE_FOURNISSEUR" integer DEFAULT 1,
    "ID_COMPTE_PCE_TVA_INTRA" integer DEFAULT 1,
    "ID_COMPTE_PCE_RESULTAT" integer DEFAULT 1,
    "ID_JOURNAL_FACTOR" 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 "OpenConcerto48"."PREFS_COMPTE" OWNER TO openconcerto;

--
-- TOC entry 1368 (class 1259 OID 6919354)
-- Name: PREFS_COMPTE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25105 (class 0 OID 0)
-- Dependencies: 1368
-- Name: PREFS_COMPTE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1467 (class 1259 OID 6940608)
-- Name: RAPPROCHEMENT_BANCAIRE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."RAPPROCHEMENT_BANCAIRE" OWNER TO openconcerto;

--
-- TOC entry 1466 (class 1259 OID 6940606)
-- Name: RAPPROCHEMENT_BANCAIRE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25106 (class 0 OID 0)
-- Dependencies: 1466
-- Name: RAPPROCHEMENT_BANCAIRE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1369 (class 1259 OID 6919356)
-- Name: REFERENCE_CLIENT; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 1370 (class 1259 OID 6919367)
-- Name: REFERENCE_CLIENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25107 (class 0 OID 0)
-- Dependencies: 1370
-- Name: REFERENCE_CLIENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1371 (class 1259 OID 6919369)
-- Name: REGIME_BASE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 1372 (class 1259 OID 6919382)
-- Name: REGIME_BASE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25108 (class 0 OID 0)
-- Dependencies: 1372
-- Name: REGIME_BASE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1373 (class 1259 OID 6919384)
-- Name: REGLEMENT_PAYE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 1374 (class 1259 OID 6919397)
-- Name: REGLEMENT_PAYE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25109 (class 0 OID 0)
-- Dependencies: 1374
-- Name: REGLEMENT_PAYE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1375 (class 1259 OID 6919399)
-- Name: REGLER_MONTANT; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 1376 (class 1259 OID 6919410)
-- Name: REGLER_MONTANT_ELEMENT; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."REGLER_MONTANT_ELEMENT" OWNER TO openconcerto;

--
-- TOC entry 1377 (class 1259 OID 6919420)
-- Name: REGLER_MONTANT_ELEMENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25110 (class 0 OID 0)
-- Dependencies: 1377
-- Name: REGLER_MONTANT_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1378 (class 1259 OID 6919422)
-- Name: REGLER_MONTANT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25111 (class 0 OID 0)
-- Dependencies: 1378
-- Name: REGLER_MONTANT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1379 (class 1259 OID 6919424)
-- Name: RELANCE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 1380 (class 1259 OID 6919440)
-- Name: RELANCE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25112 (class 0 OID 0)
-- Dependencies: 1380
-- Name: RELANCE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1463 (class 1259 OID 6940557)
-- Name: RELEVE_BANCAIRE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."RELEVE_BANCAIRE" OWNER TO openconcerto;

--
-- TOC entry 1465 (class 1259 OID 6940580)
-- Name: RELEVE_BANCAIRE_ELEMENT; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."RELEVE_BANCAIRE_ELEMENT" OWNER TO openconcerto;

--
-- TOC entry 1464 (class 1259 OID 6940578)
-- Name: RELEVE_BANCAIRE_ELEMENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25113 (class 0 OID 0)
-- Dependencies: 1464
-- Name: RELEVE_BANCAIRE_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1462 (class 1259 OID 6940555)
-- Name: RELEVE_BANCAIRE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25114 (class 0 OID 0)
-- Dependencies: 1462
-- Name: RELEVE_BANCAIRE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1381 (class 1259 OID 6919442)
-- Name: REPARTITION_ANALYTIQUE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 1382 (class 1259 OID 6919452)
-- Name: REPARTITION_ANALYTIQUE_ELEMENT; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 1383 (class 1259 OID 6919461)
-- Name: REPARTITION_ANALYTIQUE_ELEMENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25115 (class 0 OID 0)
-- Dependencies: 1383
-- Name: REPARTITION_ANALYTIQUE_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1384 (class 1259 OID 6919463)
-- Name: REPARTITION_ANALYTIQUE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25116 (class 0 OID 0)
-- Dependencies: 1384
-- Name: REPARTITION_ANALYTIQUE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1385 (class 1259 OID 6919465)
-- Name: REPRISE_TRAVAIL; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."REPRISE_TRAVAIL" OWNER TO openconcerto;

--
-- TOC entry 1386 (class 1259 OID 6919478)
-- Name: REPRISE_TRAVAIL_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25117 (class 0 OID 0)
-- Dependencies: 1386
-- Name: REPRISE_TRAVAIL_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1387 (class 1259 OID 6919480)
-- Name: SAISIE_ACHAT; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 1388 (class 1259 OID 6919505)
-- Name: SAISIE_ACHAT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25118 (class 0 OID 0)
-- Dependencies: 1388
-- Name: SAISIE_ACHAT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1389 (class 1259 OID 6919507)
-- Name: SAISIE_KM; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 1390 (class 1259 OID 6919519)
-- Name: SAISIE_KM_ELEMENT; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."SAISIE_KM_ELEMENT" (
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "NUMERO" character varying(100) DEFAULT ''::character varying,
    "NOM_ECRITURE" character varying(2048) DEFAULT ''::text,
    "ID_SAISIE_KM" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "DEBIT" bigint DEFAULT 0,
    "ORDRE" numeric(16,8),
    "CREDIT" bigint DEFAULT 0,
    "ID_ECRITURE" integer DEFAULT 1,
    "NOM" character varying(2048) DEFAULT ''::text,
    "CREATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID" integer NOT NULL,
    "MODIFICATION_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 "OpenConcerto48"."SAISIE_KM_ELEMENT" OWNER TO openconcerto;

--
-- TOC entry 1391 (class 1259 OID 6919538)
-- Name: SAISIE_KM_ELEMENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25119 (class 0 OID 0)
-- Dependencies: 1391
-- Name: SAISIE_KM_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1392 (class 1259 OID 6919540)
-- Name: SAISIE_KM_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25120 (class 0 OID 0)
-- Dependencies: 1392
-- Name: SAISIE_KM_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1393 (class 1259 OID 6919542)
-- Name: SAISIE_VENTE_COMPTOIR; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 1394 (class 1259 OID 6919566)
-- Name: SAISIE_VENTE_COMPTOIR_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25121 (class 0 OID 0)
-- Dependencies: 1394
-- Name: SAISIE_VENTE_COMPTOIR_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1395 (class 1259 OID 6919568)
-- Name: SAISIE_VENTE_FACTURE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."SAISIE_VENTE_FACTURE" (
    "NOM" character varying(250) DEFAULT ''::character varying,
    "T_TTC" bigint DEFAULT 0,
    "ID_COMPTE_PCE_SERVICE" integer DEFAULT 1,
    "T_POIDS" real DEFAULT 0,
    "DATE_ENVOI" timestamp without time zone,
    "ID_TAXE" integer DEFAULT 1,
    "COMPLEMENT" boolean DEFAULT false,
    "ACOMPTE" boolean DEFAULT false,
    "T_AVOIR_TTC" bigint DEFAULT 0,
    "T_HT" bigint DEFAULT 0,
    "ID_COMPTE_PCE_VENTE" integer DEFAULT 1,
    "REMISE_HT" bigint DEFAULT 0,
    "NUMERO" character varying(45) DEFAULT ''::character varying,
    "ID_CLIENT" integer DEFAULT 1,
    "PREVISIONNELLE" boolean DEFAULT false,
    "DATE" date,
    "ID_MOUVEMENT" integer DEFAULT 1,
    "ID_MODE_REGLEMENT" integer DEFAULT 1,
    "COMPTE_SERVICE_AUTO" boolean DEFAULT false,
    "AFFACTURAGE" boolean DEFAULT false,
    "POURCENT_ACOMPTE" real DEFAULT 0,
    "T_SERVICE" bigint DEFAULT 0,
    "ID_REFERENCE_CLIENT" integer DEFAULT 1,
    "CONTROLE_TECHNIQUE" boolean DEFAULT false,
    "ID_MOIS_CCIP" integer DEFAULT 1,
    "INFOS" character varying(2048) DEFAULT ''::text,
    "DATE_ENVOI_AFFACTURAGE" date,
    "ID_COMMERCIAL" integer DEFAULT 1,
    "ID_ADRESSE" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "PORT_HT" bigint DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "REF_CLIENT" character varying(256) DEFAULT ''::character varying NOT NULL,
    "DATE_REGLEMENT" timestamp without time zone,
    "ID_DEVIS" integer DEFAULT 1,
    "RETOUR_NATEXIS" boolean DEFAULT false,
    "T_TVA" bigint DEFAULT 0,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ENVOYE_EN_AFFACTURAGE" boolean DEFAULT false,
    "ID" integer NOT NULL,
    "ID_CONTACT" integer DEFAULT 1,
    "TYPE_INTERVENTION" character varying(2048) DEFAULT ''::text,
    "T_HA" bigint DEFAULT 0,
    "MODIFICATION_DATE" timestamp without time zone,
    "CREATION_DATE" timestamp without time zone,
    "ID_AVOIR_CLIENT" integer DEFAULT 1,
    "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 "OpenConcerto48"."SAISIE_VENTE_FACTURE" OWNER TO openconcerto;

--
-- TOC entry 1396 (class 1259 OID 6919635)
-- Name: SAISIE_VENTE_FACTURE_ELEMENT; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."SAISIE_VENTE_FACTURE_ELEMENT" (
    "T_PV_TTC" numeric(16,2) DEFAULT 0 NOT NULL,
    "MONTANT_REVISABLE" boolean DEFAULT false,
    "ARCHIVE" integer DEFAULT 0,
    "NOM" character varying(2048) DEFAULT ''::text,
    "ID_TICKET_CAISSE" integer DEFAULT 1,
    "PV_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "ID_METRIQUE_3" integer DEFAULT 1,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "T_PV_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "NOM_MISSION" character varying(256) DEFAULT ''::character varying,
    "T_POIDS" real DEFAULT 0,
    "ORDRE" numeric(16,8),
    "TARIF_Q18_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "QTE" integer DEFAULT 0,
    "REFERENTIEL_INSPECTION" character varying(2048) DEFAULT ''::text,
    "CODE_MISSION" character varying(45) DEFAULT ''::character varying,
    "VALEUR_METRIQUE_1" real DEFAULT 0,
    "ID_STYLE" integer DEFAULT 1,
    "Q18" boolean DEFAULT false,
    "PRIX_METRIQUE_HA_3" numeric(16,6) DEFAULT 0 NOT NULL,
    "ID_CONTACT" integer DEFAULT 1,
    "DATE_FIN" timestamp without time zone,
    "POIDS" real DEFAULT 0,
    "VALEUR_METRIQUE_3" real DEFAULT 0,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_METRIQUE_1" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "PRIX_METRIQUE_VT_2" numeric(16,6) DEFAULT 0 NOT NULL,
    "ID_SAISIE_VENTE_FACTURE" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "LIVREE" boolean DEFAULT false,
    "VALEUR_METRIQUE_2" real DEFAULT 0,
    "DATE" date,
    "SERVICE" boolean DEFAULT false,
    "ID_TAXE" integer DEFAULT 1,
    "INFOS_OBJET_INSPECTE" character varying(2048) DEFAULT ''::text,
    "T_PA_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "POURCENT_REMISE" numeric(12,8) DEFAULT 0,
    "PRIX_METRIQUE_HA_2" numeric(16,6) DEFAULT 0 NOT NULL,
    "PRIX_METRIQUE_VT_3" numeric(16,6) DEFAULT 0 NOT NULL,
    "ID" integer NOT NULL,
    "MONTANT_INITIAL" numeric(16,6) DEFAULT 0 NOT NULL,
    "QTE_LIVREE" integer DEFAULT 0,
    "ACOMPTE" boolean DEFAULT false,
    "LOCAL_OBJET_INSPECTE" character varying(2048) DEFAULT ''::text,
    "REPARTITION_POURCENT" numeric(6,2) DEFAULT 0 NOT NULL,
    "PRIX_METRIQUE_VT_1" numeric(16,6) DEFAULT 0 NOT NULL,
    "PRIX_METRIQUE_HA_1" numeric(16,6) DEFAULT 0 NOT NULL,
    "ACTIVITE" character varying(45) DEFAULT ''::character varying,
    "ID_METRIQUE_2" integer DEFAULT 1,
    "POURCENT_CCIP" character varying(256) DEFAULT ''::character varying NOT NULL,
    "POURCENT_ACOMPTE" numeric(6,2) DEFAULT 100 NOT NULL,
    "POURCENT_SERVICE" character varying(2048) DEFAULT ''::text,
    "OBJET_INSPECTE" character varying(2048) DEFAULT ''::text,
    "INDICE_0" bigint DEFAULT 0,
    "SOUS_ACTIVITE" character varying(45) DEFAULT ''::character varying,
    "CODE" character varying(45) DEFAULT ''::character varying,
    "PA_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "INDICE_N" bigint DEFAULT 0,
    "SITUATION_ADMIN" character varying(2048) DEFAULT ''::text,
    "ID_MODE_VENTE_ARTICLE" 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 "OpenConcerto48"."SAISIE_VENTE_FACTURE_ELEMENT" OWNER TO openconcerto;

--
-- TOC entry 1397 (class 1259 OID 6919721)
-- Name: SAISIE_VENTE_FACTURE_ELEMENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25122 (class 0 OID 0)
-- Dependencies: 1397
-- Name: SAISIE_VENTE_FACTURE_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1398 (class 1259 OID 6919723)
-- Name: SAISIE_VENTE_FACTURE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25123 (class 0 OID 0)
-- Dependencies: 1398
-- Name: SAISIE_VENTE_FACTURE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1399 (class 1259 OID 6919725)
-- Name: SALARIE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 1400 (class 1259 OID 6919748)
-- Name: SALARIE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25124 (class 0 OID 0)
-- Dependencies: 1400
-- Name: SALARIE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1401 (class 1259 OID 6919750)
-- Name: SEPA_DIRECT_DEBIT_MESSAGE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."SEPA_DIRECT_DEBIT_MESSAGE" OWNER TO openconcerto;

--
-- TOC entry 1402 (class 1259 OID 6919760)
-- Name: SEPA_DIRECT_DEBIT_MESSAGE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25125 (class 0 OID 0)
-- Dependencies: 1402
-- Name: SEPA_DIRECT_DEBIT_MESSAGE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1403 (class 1259 OID 6919762)
-- Name: SEPA_MANDATE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."SEPA_MANDATE" OWNER TO openconcerto;

--
-- TOC entry 1404 (class 1259 OID 6919770)
-- Name: SEPA_MANDATE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25126 (class 0 OID 0)
-- Dependencies: 1404
-- Name: SEPA_MANDATE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1405 (class 1259 OID 6919772)
-- Name: SITUATION_FAMILIALE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 1406 (class 1259 OID 6919780)
-- Name: SITUATION_FAMILIALE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25127 (class 0 OID 0)
-- Dependencies: 1406
-- Name: SITUATION_FAMILIALE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1407 (class 1259 OID 6919782)
-- Name: STOCK; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."STOCK" (
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "CREATION_DATE" timestamp without time zone,
    "ID" integer NOT NULL,
    "MODIFICATION_DATE" timestamp without time zone,
    "QTE_REEL" real DEFAULT 0,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ORDRE" numeric(16,8),
    "QTE_TH" real DEFAULT 0,
    "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 "OpenConcerto48"."STOCK" OWNER TO openconcerto;

--
-- TOC entry 1408 (class 1259 OID 6919795)
-- Name: STOCK_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25128 (class 0 OID 0)
-- Dependencies: 1408
-- Name: STOCK_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1409 (class 1259 OID 6919797)
-- Name: STYLE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 1410 (class 1259 OID 6919806)
-- Name: STYLE_ID_STYLE_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25129 (class 0 OID 0)
-- Dependencies: 1410
-- Name: STYLE_ID_STYLE_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1411 (class 1259 OID 6919808)
-- Name: TARIF; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."TARIF" OWNER TO openconcerto;

--
-- TOC entry 1412 (class 1259 OID 6919816)
-- Name: TARIF_ARTICLE_CLIENT; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."TARIF_ARTICLE_CLIENT" OWNER TO openconcerto;

--
-- TOC entry 1413 (class 1259 OID 6919823)
-- Name: TARIF_ARTICLE_CLIENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25130 (class 0 OID 0)
-- Dependencies: 1413
-- Name: TARIF_ARTICLE_CLIENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1414 (class 1259 OID 6919825)
-- Name: TARIF_FAMILLE_ARTICLE_CLIENT; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."TARIF_FAMILLE_ARTICLE_CLIENT" OWNER TO openconcerto;

--
-- TOC entry 1415 (class 1259 OID 6919832)
-- Name: TARIF_FAMILLE_ARTICLE_CLIENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25131 (class 0 OID 0)
-- Dependencies: 1415
-- Name: TARIF_FAMILLE_ARTICLE_CLIENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1416 (class 1259 OID 6919834)
-- Name: TARIF_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25132 (class 0 OID 0)
-- Dependencies: 1416
-- Name: TARIF_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1417 (class 1259 OID 6919836)
-- Name: TARIF_PROMOTION; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."TARIF_PROMOTION" OWNER TO openconcerto;

--
-- TOC entry 1418 (class 1259 OID 6919841)
-- Name: TARIF_PROMOTION_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25133 (class 0 OID 0)
-- Dependencies: 1418
-- Name: TARIF_PROMOTION_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1419 (class 1259 OID 6919843)
-- Name: TARIF_QUANTITE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."TARIF_QUANTITE" OWNER TO openconcerto;

--
-- TOC entry 1420 (class 1259 OID 6919850)
-- Name: TARIF_QUANTITE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25134 (class 0 OID 0)
-- Dependencies: 1420
-- Name: TARIF_QUANTITE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1421 (class 1259 OID 6919852)
-- Name: TAXE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."TAXE" (
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "TAUX" real DEFAULT 0,
    "ID_COMPTE_PCE_COLLECTE" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ORDRE" numeric(16,8),
    "ID_COMPTE_PCE_DED" integer DEFAULT 1,
    "CODE" character varying(2048) DEFAULT ''::text,
    "CREATION_DATE" timestamp without time zone,
    "NOM" character varying(2048) DEFAULT ''::text,
    "ARCHIVE" integer DEFAULT 0,
    "ID_TAXE" integer NOT NULL,
    "ID_COMPTE_PCE" integer DEFAULT 1,
    "ID_USER_COMMON_MODIFY" 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 "OpenConcerto48"."TAXE" OWNER TO openconcerto;

--
-- TOC entry 1422 (class 1259 OID 6919873)
-- Name: TAXE_CATEGORIE_COMPTABLE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."TAXE_CATEGORIE_COMPTABLE" OWNER TO openconcerto;

--
-- TOC entry 1423 (class 1259 OID 6919881)
-- Name: TAXE_CATEGORIE_COMPTABLE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25135 (class 0 OID 0)
-- Dependencies: 1423
-- Name: TAXE_CATEGORIE_COMPTABLE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1424 (class 1259 OID 6919883)
-- Name: TAXE_COMPLEMENTAIRE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."TAXE_COMPLEMENTAIRE" OWNER TO openconcerto;

--
-- TOC entry 1425 (class 1259 OID 6919893)
-- Name: TAXE_COMPLEMENTAIRE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25136 (class 0 OID 0)
-- Dependencies: 1425
-- Name: TAXE_COMPLEMENTAIRE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1426 (class 1259 OID 6919895)
-- Name: TAXE_ID_TAXE_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25137 (class 0 OID 0)
-- Dependencies: 1426
-- Name: TAXE_ID_TAXE_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1461 (class 1259 OID 6940374)
-- Name: TAXE_INTERFEL; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."TAXE_INTERFEL" OWNER TO openconcerto;

--
-- TOC entry 1460 (class 1259 OID 6940372)
-- Name: TAXE_INTERFEL_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25138 (class 0 OID 0)
-- Dependencies: 1460
-- Name: TAXE_INTERFEL_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1427 (class 1259 OID 6919897)
-- Name: TICKET_CAISSE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."TICKET_CAISSE" (
    "ID_CAISSE" integer DEFAULT 1,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0,
    "NOM" character varying(2048) DEFAULT ''::text,
    "DATE" timestamp without time zone,
    "ID" integer NOT NULL,
    "ID_COMMERCIAL" integer DEFAULT 1,
    "TOTAL_HT" bigint DEFAULT 0,
    "ID_CLIENT" integer DEFAULT 1,
    "TOTAL_TVA" bigint DEFAULT 0,
    "NUMERO" character varying(2048) DEFAULT ''::text,
    "TOTAL_TTC" bigint DEFAULT 0,
    "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 "OpenConcerto48"."TICKET_CAISSE" OWNER TO openconcerto;

--
-- TOC entry 1428 (class 1259 OID 6919916)
-- Name: TICKET_CAISSE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25139 (class 0 OID 0)
-- Dependencies: 1428
-- Name: TICKET_CAISSE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1429 (class 1259 OID 6919918)
-- Name: TITRE_PERSONNEL; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 1430 (class 1259 OID 6919928)
-- Name: TITRE_PERSONNEL_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25140 (class 0 OID 0)
-- Dependencies: 1430
-- Name: TITRE_PERSONNEL_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1431 (class 1259 OID 6919930)
-- Name: TRANSFERT_STOCK; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."TRANSFERT_STOCK" OWNER TO openconcerto;

--
-- TOC entry 1432 (class 1259 OID 6919944)
-- Name: TRANSFERT_STOCK_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25141 (class 0 OID 0)
-- Dependencies: 1432
-- Name: TRANSFERT_STOCK_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1433 (class 1259 OID 6919946)
-- Name: TR_BON_DE_LIVRAISON; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."TR_BON_DE_LIVRAISON" OWNER TO openconcerto;

--
-- TOC entry 1434 (class 1259 OID 6919953)
-- Name: TR_BON_DE_LIVRAISON_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25142 (class 0 OID 0)
-- Dependencies: 1434
-- Name: TR_BON_DE_LIVRAISON_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1435 (class 1259 OID 6919955)
-- Name: TR_BON_RECEPTION; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."TR_BON_RECEPTION" OWNER TO openconcerto;

--
-- TOC entry 1436 (class 1259 OID 6919963)
-- Name: TR_BON_RECEPTION_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25143 (class 0 OID 0)
-- Dependencies: 1436
-- Name: TR_BON_RECEPTION_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1437 (class 1259 OID 6919965)
-- Name: TR_COMMANDE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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_BON_RECEPTION" integer DEFAULT 1,
    "ID_SAISIE_ACHAT" integer DEFAULT 1,
    "ID_FACTURE_FOURNISSEUR" integer DEFAULT 1
);


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

--
-- TOC entry 1438 (class 1259 OID 6919974)
-- Name: TR_COMMANDE_CLIENT; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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_BON_DE_LIVRAISON" integer DEFAULT 1,
    "ID_COMMANDE" integer DEFAULT 1
);


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

--
-- TOC entry 1439 (class 1259 OID 6919983)
-- Name: TR_COMMANDE_CLIENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25144 (class 0 OID 0)
-- Dependencies: 1439
-- Name: TR_COMMANDE_CLIENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1440 (class 1259 OID 6919985)
-- Name: TR_COMMANDE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25145 (class 0 OID 0)
-- Dependencies: 1440
-- Name: TR_COMMANDE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1441 (class 1259 OID 6919987)
-- Name: TR_DEVIS; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."TR_DEVIS" OWNER TO openconcerto;

--
-- TOC entry 1442 (class 1259 OID 6919997)
-- Name: TR_DEVIS_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25146 (class 0 OID 0)
-- Dependencies: 1442
-- Name: TR_DEVIS_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1443 (class 1259 OID 6919999)
-- Name: TR_SAISIE_ACHAT; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."TR_SAISIE_ACHAT" OWNER TO openconcerto;

--
-- TOC entry 1444 (class 1259 OID 6920006)
-- Name: TR_SAISIE_ACHAT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25147 (class 0 OID 0)
-- Dependencies: 1444
-- Name: TR_SAISIE_ACHAT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1445 (class 1259 OID 6920008)
-- Name: TR_SAISIE_VENTE_FACTURE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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_BON_DE_LIVRAISON" integer DEFAULT 1,
    "ID_COMMANDE" integer DEFAULT 1
);


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

--
-- TOC entry 1446 (class 1259 OID 6920017)
-- Name: TR_SAISIE_VENTE_FACTURE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25148 (class 0 OID 0)
-- Dependencies: 1446
-- Name: TR_SAISIE_VENTE_FACTURE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1447 (class 1259 OID 6920019)
-- Name: TYPE_COMPTE_PCG; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 1448 (class 1259 OID 6920027)
-- Name: TYPE_COMPTE_PCG_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25149 (class 0 OID 0)
-- Dependencies: 1448
-- Name: TYPE_COMPTE_PCG_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1449 (class 1259 OID 6920029)
-- Name: TYPE_LETTRE_RELANCE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 1450 (class 1259 OID 6920040)
-- Name: TYPE_LETTRE_RELANCE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25150 (class 0 OID 0)
-- Dependencies: 1450
-- Name: TYPE_LETTRE_RELANCE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1451 (class 1259 OID 6920042)
-- Name: TYPE_REGLEMENT; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 1452 (class 1259 OID 6920057)
-- Name: TYPE_REGLEMENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25151 (class 0 OID 0)
-- Dependencies: 1452
-- Name: TYPE_REGLEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1453 (class 1259 OID 6920059)
-- Name: UNITE_VENTE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."UNITE_VENTE" OWNER TO openconcerto;

--
-- TOC entry 1454 (class 1259 OID 6920071)
-- Name: UNITE_VENTE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25152 (class 0 OID 0)
-- Dependencies: 1454
-- Name: UNITE_VENTE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1455 (class 1259 OID 6920073)
-- Name: VARIABLE_SALARIE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."VARIABLE_SALARIE" (
    "HEURE_200" real DEFAULT 0,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID" integer NOT NULL,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "HEURE_125" real DEFAULT 0,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ORDRE" numeric(16,8),
    "CONGES_PRIS" real DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0,
    "HEURE_TRAV" real DEFAULT 0,
    "HEURE_ABS" real DEFAULT 0,
    "HEURE_150" real DEFAULT 0,
    "HEURE_110" real DEFAULT 0,
    "CREATION_DATE" timestamp without time zone,
    "CONGES_PRIS_DEFAULT_VAL" real DEFAULT 0,
    "HEURE_200_DEFAULT_VAL" real DEFAULT 0,
    "HEURE_150_DEFAULT_VAL" real DEFAULT 0,
    "HEURE_110_DEFAULT_VAL" real DEFAULT 0,
    "HEURE_ABS_DEFAULT_VAL" real DEFAULT 0,
    "HEURE_125_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,
    "IJSS_BRUT_CUMUL_VAL" real DEFAULT 0,
    "HEURE_125_CUMUL_VAL" real DEFAULT 0,
    "CONGES_PRIS_CUMUL_VAL" real DEFAULT 0,
    "IJSS_NET_CUMUL_VAL" real DEFAULT 0,
    "HEURE_110_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,
    "HEURE_200_CUMUL_VAL" real DEFAULT 0,
    "FRAIS_PRO_CUMUL_VAL" real DEFAULT 0,
    "RBT_TRANSPORT_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 "OpenConcerto48"."VARIABLE_SALARIE" OWNER TO openconcerto;

--
-- TOC entry 1456 (class 1259 OID 6920126)
-- Name: VARIABLE_SALARIE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25153 (class 0 OID 0)
-- Dependencies: 1456
-- Name: VARIABLE_SALARIE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1457 (class 1259 OID 6920128)
-- Name: VILLE; Type: TABLE; Schema: OpenConcerto48; Owner: openconcerto
--

CREATE TABLE "OpenConcerto48"."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 "OpenConcerto48"."VILLE" OWNER TO openconcerto;

--
-- TOC entry 1458 (class 1259 OID 6920141)
-- Name: VILLE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto48; Owner: openconcerto
--

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


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

--
-- TOC entry 25154 (class 0 OID 0)
-- Dependencies: 1458
-- Name: VILLE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto48; Owner: openconcerto
--

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


--
-- TOC entry 1459 (class 1259 OID 6920143)
-- Name: FWK_SCHEMA_METADATA; Type: TABLE; Schema: public; Owner: openconcerto
--

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


ALTER TABLE public."FWK_SCHEMA_METADATA" OWNER TO openconcerto;

--
-- TOC entry 7017 (class 2604 OID 6920148)
-- Name: ACCES_SOCIETE ID; Type: DEFAULT; Schema: Common; Owner: openconcerto
--

ALTER TABLE ONLY "Common"."ACCES_SOCIETE" ALTER COLUMN "ID" SET DEFAULT nextval('"Common"."ACCES_SOCIETE_ID_seq"'::regclass);


--
-- TOC entry 7022 (class 2604 OID 6920149)
-- Name: ADRESSE_COMMON ID; Type: DEFAULT; Schema: Common; Owner: openconcerto
--

ALTER TABLE ONLY "Common"."ADRESSE_COMMON" ALTER COLUMN "ID" SET DEFAULT nextval('"Common"."ADRESSE_COMMON_ID_seq"'::regclass);


--
-- TOC entry 7030 (class 2604 OID 6920150)
-- Name: AYANT_DROIT_TYPE ID; Type: DEFAULT; Schema: Common; Owner: openconcerto
--

ALTER TABLE ONLY "Common"."AYANT_DROIT_TYPE" ALTER COLUMN "ID" SET DEFAULT nextval('"Common"."AYANT_DROIT_TYPE_ID_seq"'::regclass);


--
-- TOC entry 7035 (class 2604 OID 6920151)
-- Name: CAISSE_COTISATION ID; Type: DEFAULT; Schema: Common; Owner: openconcerto
--

ALTER TABLE ONLY "Common"."CAISSE_COTISATION" ALTER COLUMN "ID" SET DEFAULT nextval('"Common"."CAISSE_COTISATION_ID_seq"'::regclass);


--
-- TOC entry 7048 (class 2604 OID 6920152)
-- Name: CAISSE_COTISATION_RENSEIGNEMENT ID; Type: DEFAULT; Schema: Common; Owner: openconcerto
--

ALTER TABLE ONLY "Common"."CAISSE_COTISATION_RENSEIGNEMENT" ALTER COLUMN "ID" SET DEFAULT nextval('"Common"."CAISSE_COTISATION_RENSEIGNEMENT_ID_seq"'::regclass);


--
-- TOC entry 7063 (class 2604 OID 6920153)
-- Name: CAISSE_MODE_PAIEMENT ID; Type: DEFAULT; Schema: Common; Owner: openconcerto
--

ALTER TABLE ONLY "Common"."CAISSE_MODE_PAIEMENT" ALTER COLUMN "ID" SET DEFAULT nextval('"Common"."CAISSE_MODE_PAIEMENT_ID_seq"'::regclass);


--
-- TOC entry 7068 (class 2604 OID 6920154)
-- Name: CODE_AMENAGEMENT_PARTIEL ID; Type: DEFAULT; Schema: Common; Owner: openconcerto
--

ALTER TABLE ONLY "Common"."CODE_AMENAGEMENT_PARTIEL" ALTER COLUMN "ID" SET DEFAULT nextval('"Common"."CODE_AMENAGEMENT_PARTIEL_ID_seq"'::regclass);


--
-- TOC entry 7072 (class 2604 OID 6920155)
-- Name: CODE_BASE_ASSUJETTIE ID; Type: DEFAULT; Schema: Common; Owner: openconcerto
--

ALTER TABLE ONLY "Common"."CODE_BASE_ASSUJETTIE" ALTER COLUMN "ID" SET DEFAULT nextval('"Common"."CODE_BASE_ASSUJETTIE_ID_seq"'::regclass);


--
-- TOC entry 7077 (class 2604 OID 6920156)
-- Name: CODE_CAISSE_CONGES_PAYES ID; Type: DEFAULT; Schema: Common; Owner: openconcerto
--

ALTER TABLE ONLY "Common"."CODE_CAISSE_CONGES_PAYES" ALTER COLUMN "ID" SET DEFAULT nextval('"Common"."CODE_CAISSE_CONGES_PAYES_ID_seq"'::regclass);


--
-- TOC entry 7081 (class 2604 OID 6920157)
-- Name: CODE_CAISSE_TYPE_RUBRIQUE ID; Type: DEFAULT; Schema: Common; Owner: openconcerto
--

ALTER TABLE ONLY "Common"."CODE_CAISSE_TYPE_RUBRIQUE" ALTER COLUMN "ID" SET DEFAULT nextval('"Common"."CODE_CAISSE_TYPE_RUBRIQUE_ID_seq"'::regclass);


--
-- TOC entry 7087 (class 2604 OID 6920158)
-- Name: CODE_COTISATION_ETABLISSEMENT ID; Type: DEFAULT; Schema: Common; Owner: openconcerto
--

ALTER TABLE ONLY "Common"."CODE_COTISATION_ETABLISSEMENT" ALTER COLUMN "ID" SET DEFAULT nextval('"Common"."CODE_COTISATION_ETABLISSEMENT_ID_seq"'::regclass);


--
-- TOC entry 7092 (class 2604 OID 6920159)
-- Name: CODE_COTISATION_INDIVIDUELLE ID; Type: DEFAULT; Schema: Common; Owner: openconcerto
--

ALTER TABLE ONLY "Common"."CODE_COTISATION_INDIVIDUELLE" ALTER COLUMN "ID" SET DEFAULT nextval('"Common"."CODE_COTISATION_INDIVIDUELLE_ID_seq"'::regclass);


--
-- TOC entry 7097 (class 2604 OID 6920160)
-- Name: CODE_PENIBILITE ID; Type: DEFAULT; Schema: Common; Owner: openconcerto
--

ALTER TABLE ONLY "Common"."CODE_PENIBILITE" ALTER COLUMN "ID" SET DEFAULT nextval('"Common"."CODE_PENIBILITE_ID_seq"'::regclass);


--
-- TOC entry 7102 (class 2604 OID 6920161)
-- Name: CODE_SUSPENSION ID; Type: DEFAULT; Schema: Common; Owner: openconcerto
--

ALTER TABLE ONLY "Common"."CODE_SUSPENSION" ALTER COLUMN "ID" SET DEFAULT nextval('"Common"."CODE_SUSPENSION_ID_seq"'::regclass);


--
-- TOC entry 7106 (class 2604 OID 6920162)
-- Name: CODE_TYPE_RUBRIQUE_BRUT ID; Type: DEFAULT; Schema: Common; Owner: openconcerto
--

ALTER TABLE ONLY "Common"."CODE_TYPE_RUBRIQUE_BRUT" ALTER COLUMN "ID" SET DEFAULT nextval('"Common"."CODE_TYPE_RUBRIQUE_BRUT_ID_seq"'::regclass);


--
-- TOC entry 7114 (class 2604 OID 6920163)
-- Name: COMPTE_PCE_DEFAULT ID; Type: DEFAULT; Schema: Common; Owner: openconcerto
--

ALTER TABLE ONLY "Common"."COMPTE_PCE_DEFAULT" ALTER COLUMN "ID" SET DEFAULT nextval('"Common"."COMPTE_PCE_DEFAULT_ID_seq"'::regclass);


--
-- TOC entry 7121 (class 2604 OID 6920164)
-- Name: CONNEXION ID; Type: DEFAULT; Schema: Common; Owner: openconcerto
--

ALTER TABLE ONLY "Common"."CONNEXION" ALTER COLUMN "ID" SET DEFAULT nextval('"Common"."CONNEXION_ID_seq"'::regclass);


--
-- TOC entry 7123 (class 2604 OID 6920165)
-- Name: CONTRAT_DETACHE_EXPATRIE ID; Type: DEFAULT; Schema: Common; Owner: openconcerto
--

ALTER TABLE ONLY "Common"."CONTRAT_DETACHE_EXPATRIE" ALTER COLUMN "ID" SET DEFAULT nextval('"Common"."CONTRAT_DETACHE_EXPATRIE_ID_seq"'::regclass);


--
-- TOC entry 7128 (class 2604 OID 6920166)
