--
--


-- Started on 2024-01-29 14:45:35

SELECT pg_catalog.set_config('search_path', '', false);

--
-- TOC entry 10 (class 2615 OID 6907935)
-- Name: Common; Type: SCHEMA; Schema: -; Owner: openconcerto
--

CREATE SCHEMA "Common";


ALTER SCHEMA "Common" OWNER TO openconcerto;

--
-- TOC entry 24517 (class 0 OID 0)
-- Dependencies: 10
-- Name: SCHEMA "Common"; Type: COMMENT; Schema: -; Owner: openconcerto
--

COMMENT ON SCHEMA "Common" IS 'Standard public schema';


--
-- TOC entry 11 (class 2615 OID 6907936)
-- Name: Default; Type: SCHEMA; Schema: -; Owner: openconcerto
--

CREATE SCHEMA "Default";


ALTER SCHEMA "Default" OWNER TO openconcerto;

--
-- TOC entry 24519 (class 0 OID 0)
-- Dependencies: 11
-- Name: SCHEMA "Default"; Type: COMMENT; Schema: -; Owner: openconcerto
--

COMMENT ON SCHEMA "Default" IS 'Standard public schema';


--
-- TOC entry 8 (class 2615 OID 6907937)
-- Name: OpenConcerto42; Type: SCHEMA; Schema: -; Owner: openconcerto
--

CREATE SCHEMA "OpenConcerto42";


ALTER SCHEMA "OpenConcerto42" OWNER TO openconcerto;

--
-- TOC entry 9 (class 2615 OID 6907938)
-- Name: OpenConcerto48; Type: SCHEMA; Schema: -; Owner: openconcerto
--

CREATE SCHEMA "OpenConcerto48";


ALTER SCHEMA "OpenConcerto48" OWNER TO openconcerto;

--
-- TOC entry 6 (class 2615 OID 2200)
-- Name: public; Type: SCHEMA; Schema: -; Owner: postgres
--

-- *not* creating schema, since initdb creates it


ALTER SCHEMA public OWNER TO postgres;

--
-- TOC entry 1484 (class 1255 OID 6907939)
-- Name: plpgsql_call_handler(); Type: FUNCTION; Schema: Common; Owner: openconcerto
--

CREATE FUNCTION "Common".plpgsql_call_handler() RETURNS language_handler
    LANGUAGE c
    AS '$libdir/plpgsql', 'plpgsql_call_handler';


ALTER FUNCTION "Common".plpgsql_call_handler() OWNER TO openconcerto;

--
-- TOC entry 1485 (class 1255 OID 6907940)
-- Name: plpgsql_validator(oid); Type: FUNCTION; Schema: Common; Owner: openconcerto
--

CREATE FUNCTION "Common".plpgsql_validator(oid) RETURNS void
    LANGUAGE c
    AS '$libdir/plpgsql', 'plpgsql_validator';


ALTER FUNCTION "Common".plpgsql_validator(oid) OWNER TO openconcerto;

--
-- TOC entry 1486 (class 1255 OID 6907941)
-- Name: next_ordret(); Type: FUNCTION; Schema: Default; Owner: openconcerto
--

CREATE FUNCTION "Default".next_ordret() RETURNS numeric
    LANGUAGE sql
    AS $$ UPDATE ordreT_generator set tmpVal = currentVal, currentVal = currentVal + inc ;SELECT tmpVal from ordreT_generator; $$;


ALTER FUNCTION "Default".next_ordret() OWNER TO openconcerto;

--
-- TOC entry 1487 (class 1255 OID 6907942)
-- Name: reset_ordret(); Type: FUNCTION; Schema: Default; Owner: openconcerto
--

CREATE FUNCTION "Default".reset_ordret() RETURNS numeric
    LANGUAGE sql
    AS $$ update ordreT_generator set currentVal = minVal ;select currentVal from ordreT_generator; $$;


ALTER FUNCTION "Default".reset_ordret() OWNER TO openconcerto;


--
-- TOC entry 200 (class 1259 OID 6907943)
-- Name: ACCES_SOCIETE; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."ACCES_SOCIETE" (
    "ID" integer NOT NULL,
    "ID_USER_COMMON" integer DEFAULT 1,
    "ID_SOCIETE_COMMON" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8) DEFAULT 0
);


ALTER TABLE "Common"."ACCES_SOCIETE" OWNER TO openconcerto;

--
-- TOC entry 201 (class 1259 OID 6907950)
-- Name: ACCES_SOCIETE_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."ACCES_SOCIETE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."ACCES_SOCIETE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24522 (class 0 OID 0)
-- Dependencies: 201
-- Name: ACCES_SOCIETE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."ACCES_SOCIETE_ID_seq" OWNED BY "Common"."ACCES_SOCIETE"."ID";


--
-- TOC entry 202 (class 1259 OID 6907952)
-- Name: ADRESSE_COMMON; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."ADRESSE_COMMON" (
    "ID" integer NOT NULL,
    "RUE" character varying(2048) DEFAULT ''::text NOT NULL,
    "CODE_POSTAL" character varying(256) DEFAULT ''::character varying NOT NULL,
    "PAYS" character varying(256) DEFAULT ''::character varying NOT NULL,
    "VILLE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "CEDEX" integer,
    "HAS_CEDEX" boolean DEFAULT false
);


ALTER TABLE "Common"."ADRESSE_COMMON" OWNER TO openconcerto;

--
-- TOC entry 203 (class 1259 OID 6907965)
-- Name: ADRESSE_COMMON_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."ADRESSE_COMMON_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."ADRESSE_COMMON_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24523 (class 0 OID 0)
-- Dependencies: 203
-- Name: ADRESSE_COMMON_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."ADRESSE_COMMON_ID_seq" OWNED BY "Common"."ADRESSE_COMMON"."ID";


--
-- TOC entry 204 (class 1259 OID 6907967)
-- Name: AYANT_DROIT_TYPE; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."AYANT_DROIT_TYPE" (
    "ID" integer NOT NULL,
    "CODE" character varying(25) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(512) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "Common"."AYANT_DROIT_TYPE" OWNER TO openconcerto;

--
-- TOC entry 205 (class 1259 OID 6907977)
-- Name: AYANT_DROIT_TYPE_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."AYANT_DROIT_TYPE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."AYANT_DROIT_TYPE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24524 (class 0 OID 0)
-- Dependencies: 205
-- Name: AYANT_DROIT_TYPE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."AYANT_DROIT_TYPE_ID_seq" OWNED BY "Common"."AYANT_DROIT_TYPE"."ID";


--
-- TOC entry 206 (class 1259 OID 6907979)
-- Name: CAISSE_COTISATION; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."CAISSE_COTISATION" (
    "ID" integer NOT NULL,
    "NOM" character varying(128) DEFAULT ''::character varying NOT NULL,
    "ID_ADRESSE_COMMON" integer DEFAULT 1 NOT NULL,
    "TEL" character varying(32) DEFAULT ''::character varying NOT NULL,
    "MAIL" character varying(256) DEFAULT ''::character varying NOT NULL,
    "TEL_PORTABLE" character varying(32) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "NUMERO_COMPTE_PCE" character varying(128) DEFAULT ''::character varying NOT NULL,
    "NUMERO_COMPTE_PCE_CHARGES" character varying(128) DEFAULT ''::character varying NOT NULL,
    "ORG_PROTECTION_SOCIALE" boolean DEFAULT false NOT NULL,
    "URSSAF" boolean DEFAULT false NOT NULL,
    "DGFIP" boolean DEFAULT false
);


ALTER TABLE "Common"."CAISSE_COTISATION" OWNER TO openconcerto;

--
-- TOC entry 207 (class 1259 OID 6907997)
-- Name: CAISSE_COTISATION_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."CAISSE_COTISATION_ID_seq"
    START WITH 9
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."CAISSE_COTISATION_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24525 (class 0 OID 0)
-- Dependencies: 207
-- Name: CAISSE_COTISATION_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."CAISSE_COTISATION_ID_seq" OWNED BY "Common"."CAISSE_COTISATION"."ID";


--
-- TOC entry 208 (class 1259 OID 6907999)
-- Name: CAISSE_COTISATION_RENSEIGNEMENT; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."CAISSE_COTISATION_RENSEIGNEMENT" (
    "ID" integer NOT NULL,
    "IDENTIFIANT" character varying(256) DEFAULT ''::character varying NOT NULL,
    "SIRET" character varying(256) DEFAULT ''::character varying NOT NULL,
    "BIC" character varying(256) DEFAULT ''::character varying NOT NULL,
    "IBAN" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ENTITE_AFFECTATION" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ORGANISME_COMPLEMENTAIRE" boolean DEFAULT false NOT NULL,
    "PAIEMENT_TRIMESTRIEL" boolean DEFAULT false NOT NULL,
    "CODE_DELEGATAIRE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ID_CAISSE_MODE_PAIEMENT" integer DEFAULT 1,
    "ID_CAISSE_COTISATION" integer DEFAULT 1,
    "ID_SOCIETE_COMMON" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric,
    "JOUR_PAIEMENT" integer DEFAULT 0 NOT NULL
);


ALTER TABLE "Common"."CAISSE_COTISATION_RENSEIGNEMENT" OWNER TO openconcerto;

--
-- TOC entry 209 (class 1259 OID 6908019)
-- Name: CAISSE_COTISATION_RENSEIGNEMENT_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."CAISSE_COTISATION_RENSEIGNEMENT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."CAISSE_COTISATION_RENSEIGNEMENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24526 (class 0 OID 0)
-- Dependencies: 209
-- Name: CAISSE_COTISATION_RENSEIGNEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."CAISSE_COTISATION_RENSEIGNEMENT_ID_seq" OWNED BY "Common"."CAISSE_COTISATION_RENSEIGNEMENT"."ID";


--
-- TOC entry 210 (class 1259 OID 6908021)
-- Name: CAISSE_MODE_PAIEMENT; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."CAISSE_MODE_PAIEMENT" (
    "ID" integer NOT NULL,
    "CODE" character varying(25) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(512) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "Common"."CAISSE_MODE_PAIEMENT" OWNER TO openconcerto;

--
-- TOC entry 211 (class 1259 OID 6908031)
-- Name: CAISSE_MODE_PAIEMENT_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."CAISSE_MODE_PAIEMENT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."CAISSE_MODE_PAIEMENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24527 (class 0 OID 0)
-- Dependencies: 211
-- Name: CAISSE_MODE_PAIEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."CAISSE_MODE_PAIEMENT_ID_seq" OWNED BY "Common"."CAISSE_MODE_PAIEMENT"."ID";


--
-- TOC entry 212 (class 1259 OID 6908033)
-- Name: CODE_AMENAGEMENT_PARTIEL; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."CODE_AMENAGEMENT_PARTIEL" (
    "ID" integer NOT NULL,
    "CODE" character varying(25) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(512) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8)
);


ALTER TABLE "Common"."CODE_AMENAGEMENT_PARTIEL" OWNER TO openconcerto;

--
-- TOC entry 213 (class 1259 OID 6908042)
-- Name: CODE_AMENAGEMENT_PARTIEL_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

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


ALTER TABLE "Common"."CODE_AMENAGEMENT_PARTIEL_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24528 (class 0 OID 0)
-- Dependencies: 213
-- Name: CODE_AMENAGEMENT_PARTIEL_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."CODE_AMENAGEMENT_PARTIEL_ID_seq" OWNED BY "Common"."CODE_AMENAGEMENT_PARTIEL"."ID";


--
-- TOC entry 214 (class 1259 OID 6908044)
-- Name: CODE_BASE_ASSUJETTIE; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."CODE_BASE_ASSUJETTIE" (
    "ID" integer NOT NULL,
    "CODE" character varying(25) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(512) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "Common"."CODE_BASE_ASSUJETTIE" OWNER TO openconcerto;

--
-- TOC entry 215 (class 1259 OID 6908054)
-- Name: CODE_BASE_ASSUJETTIE_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."CODE_BASE_ASSUJETTIE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."CODE_BASE_ASSUJETTIE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24529 (class 0 OID 0)
-- Dependencies: 215
-- Name: CODE_BASE_ASSUJETTIE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."CODE_BASE_ASSUJETTIE_ID_seq" OWNED BY "Common"."CODE_BASE_ASSUJETTIE"."ID";


--
-- TOC entry 216 (class 1259 OID 6908056)
-- Name: CODE_CAISSE_CONGES_PAYES; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."CODE_CAISSE_CONGES_PAYES" (
    "ID" integer NOT NULL,
    "CODE" character varying(25) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(512) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8)
);


ALTER TABLE "Common"."CODE_CAISSE_CONGES_PAYES" OWNER TO openconcerto;

--
-- TOC entry 217 (class 1259 OID 6908065)
-- Name: CODE_CAISSE_CONGES_PAYES_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

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


ALTER TABLE "Common"."CODE_CAISSE_CONGES_PAYES_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24530 (class 0 OID 0)
-- Dependencies: 217
-- Name: CODE_CAISSE_CONGES_PAYES_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."CODE_CAISSE_CONGES_PAYES_ID_seq" OWNED BY "Common"."CODE_CAISSE_CONGES_PAYES"."ID";


--
-- TOC entry 218 (class 1259 OID 6908067)
-- Name: CODE_CAISSE_TYPE_RUBRIQUE; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."CODE_CAISSE_TYPE_RUBRIQUE" (
    "ID" integer NOT NULL,
    "CODE" character varying(25) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(512) DEFAULT ''::character varying NOT NULL,
    "CAISSE_COTISATION" character varying(512) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "Common"."CODE_CAISSE_TYPE_RUBRIQUE" OWNER TO openconcerto;

--
-- TOC entry 219 (class 1259 OID 6908078)
-- Name: CODE_CAISSE_TYPE_RUBRIQUE_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."CODE_CAISSE_TYPE_RUBRIQUE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."CODE_CAISSE_TYPE_RUBRIQUE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24531 (class 0 OID 0)
-- Dependencies: 219
-- Name: CODE_CAISSE_TYPE_RUBRIQUE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."CODE_CAISSE_TYPE_RUBRIQUE_ID_seq" OWNED BY "Common"."CODE_CAISSE_TYPE_RUBRIQUE"."ID";


--
-- TOC entry 220 (class 1259 OID 6908080)
-- Name: CODE_COTISATION_ETABLISSEMENT; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."CODE_COTISATION_ETABLISSEMENT" (
    "ID" integer NOT NULL,
    "CODE" character varying(25) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(512) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "Common"."CODE_COTISATION_ETABLISSEMENT" OWNER TO openconcerto;

--
-- TOC entry 221 (class 1259 OID 6908090)
-- Name: CODE_COTISATION_ETABLISSEMENT_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."CODE_COTISATION_ETABLISSEMENT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."CODE_COTISATION_ETABLISSEMENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24532 (class 0 OID 0)
-- Dependencies: 221
-- Name: CODE_COTISATION_ETABLISSEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."CODE_COTISATION_ETABLISSEMENT_ID_seq" OWNED BY "Common"."CODE_COTISATION_ETABLISSEMENT"."ID";


--
-- TOC entry 222 (class 1259 OID 6908092)
-- Name: CODE_COTISATION_INDIVIDUELLE; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."CODE_COTISATION_INDIVIDUELLE" (
    "ID" integer NOT NULL,
    "CODE" character varying(25) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(512) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "Common"."CODE_COTISATION_INDIVIDUELLE" OWNER TO openconcerto;

--
-- TOC entry 223 (class 1259 OID 6908102)
-- Name: CODE_COTISATION_INDIVIDUELLE_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."CODE_COTISATION_INDIVIDUELLE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."CODE_COTISATION_INDIVIDUELLE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24533 (class 0 OID 0)
-- Dependencies: 223
-- Name: CODE_COTISATION_INDIVIDUELLE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."CODE_COTISATION_INDIVIDUELLE_ID_seq" OWNED BY "Common"."CODE_COTISATION_INDIVIDUELLE"."ID";


--
-- TOC entry 224 (class 1259 OID 6908104)
-- Name: CODE_PENIBILITE; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."CODE_PENIBILITE" (
    "ID" integer NOT NULL,
    "CODE" character varying(25) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(512) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "Common"."CODE_PENIBILITE" OWNER TO openconcerto;

--
-- TOC entry 225 (class 1259 OID 6908114)
-- Name: CODE_PENIBILITE_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."CODE_PENIBILITE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."CODE_PENIBILITE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24534 (class 0 OID 0)
-- Dependencies: 225
-- Name: CODE_PENIBILITE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."CODE_PENIBILITE_ID_seq" OWNED BY "Common"."CODE_PENIBILITE"."ID";


--
-- TOC entry 226 (class 1259 OID 6908116)
-- Name: CODE_SUSPENSION; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."CODE_SUSPENSION" (
    "ID" integer NOT NULL,
    "CODE" character varying(25) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(512) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8)
);


ALTER TABLE "Common"."CODE_SUSPENSION" OWNER TO openconcerto;

--
-- TOC entry 227 (class 1259 OID 6908125)
-- Name: CODE_SUSPENSION_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

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


ALTER TABLE "Common"."CODE_SUSPENSION_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24535 (class 0 OID 0)
-- Dependencies: 227
-- Name: CODE_SUSPENSION_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."CODE_SUSPENSION_ID_seq" OWNED BY "Common"."CODE_SUSPENSION"."ID";


--
-- TOC entry 228 (class 1259 OID 6908127)
-- Name: CODE_TYPE_RUBRIQUE_BRUT; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."CODE_TYPE_RUBRIQUE_BRUT" (
    "ID" integer NOT NULL,
    "CODE" character varying(25) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(512) DEFAULT ''::character varying NOT NULL,
    "TYPE" character varying(512) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "Common"."CODE_TYPE_RUBRIQUE_BRUT" OWNER TO openconcerto;

--
-- TOC entry 229 (class 1259 OID 6908138)
-- Name: CODE_TYPE_RUBRIQUE_BRUT_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."CODE_TYPE_RUBRIQUE_BRUT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."CODE_TYPE_RUBRIQUE_BRUT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24536 (class 0 OID 0)
-- Dependencies: 229
-- Name: CODE_TYPE_RUBRIQUE_BRUT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."CODE_TYPE_RUBRIQUE_BRUT_ID_seq" OWNED BY "Common"."CODE_TYPE_RUBRIQUE_BRUT"."ID";


--
-- TOC entry 230 (class 1259 OID 6908140)
-- Name: COMPLETION; Type: TABLE; Schema: Common; Owner: openconcerto
--

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


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

--
-- TOC entry 231 (class 1259 OID 6908145)
-- Name: COMPTE_PCE_DEFAULT; Type: TABLE; Schema: Common; Owner: openconcerto
--

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


ALTER TABLE "Common"."COMPTE_PCE_DEFAULT" OWNER TO openconcerto;

--
-- TOC entry 232 (class 1259 OID 6908152)
-- Name: COMPTE_PCE_DEFAULT_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."COMPTE_PCE_DEFAULT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."COMPTE_PCE_DEFAULT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24537 (class 0 OID 0)
-- Dependencies: 232
-- Name: COMPTE_PCE_DEFAULT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."COMPTE_PCE_DEFAULT_ID_seq" OWNED BY "Common"."COMPTE_PCE_DEFAULT"."ID";


--
-- TOC entry 233 (class 1259 OID 6908154)
-- Name: CONNEXION; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."CONNEXION" (
    "LOGIN" character varying(45),
    "MDP" character varying(2048),
    "DATE" timestamp with time zone,
    "IP" character varying(2048),
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "ID" integer NOT NULL,
    "FAILED" boolean DEFAULT false
);


ALTER TABLE "Common"."CONNEXION" OWNER TO openconcerto;

--
-- TOC entry 234 (class 1259 OID 6908163)
-- Name: CONNEXION_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."CONNEXION_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."CONNEXION_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24538 (class 0 OID 0)
-- Dependencies: 234
-- Name: CONNEXION_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."CONNEXION_ID_seq" OWNED BY "Common"."CONNEXION"."ID";


--
-- TOC entry 235 (class 1259 OID 6908165)
-- Name: CONTRAT_DETACHE_EXPATRIE; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."CONTRAT_DETACHE_EXPATRIE" (
    "ID" integer NOT NULL,
    "CODE" character varying(25) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(512) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "Common"."CONTRAT_DETACHE_EXPATRIE" OWNER TO openconcerto;

--
-- TOC entry 236 (class 1259 OID 6908175)
-- Name: CONTRAT_DETACHE_EXPATRIE_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."CONTRAT_DETACHE_EXPATRIE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."CONTRAT_DETACHE_EXPATRIE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24539 (class 0 OID 0)
-- Dependencies: 236
-- Name: CONTRAT_DETACHE_EXPATRIE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."CONTRAT_DETACHE_EXPATRIE_ID_seq" OWNED BY "Common"."CONTRAT_DETACHE_EXPATRIE"."ID";


--
-- TOC entry 237 (class 1259 OID 6908177)
-- Name: CONTRAT_DISPOSITIF_POLITIQUE; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."CONTRAT_DISPOSITIF_POLITIQUE" (
    "ID" integer NOT NULL,
    "CODE" character varying(25) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(512) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "Common"."CONTRAT_DISPOSITIF_POLITIQUE" OWNER TO openconcerto;

--
-- TOC entry 238 (class 1259 OID 6908187)
-- Name: CONTRAT_DISPOSITIF_POLITIQUE_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."CONTRAT_DISPOSITIF_POLITIQUE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."CONTRAT_DISPOSITIF_POLITIQUE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24540 (class 0 OID 0)
-- Dependencies: 238
-- Name: CONTRAT_DISPOSITIF_POLITIQUE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."CONTRAT_DISPOSITIF_POLITIQUE_ID_seq" OWNED BY "Common"."CONTRAT_DISPOSITIF_POLITIQUE"."ID";


--
-- TOC entry 239 (class 1259 OID 6908189)
-- Name: CONTRAT_MODALITE_TEMPS; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."CONTRAT_MODALITE_TEMPS" (
    "ID" integer NOT NULL,
    "CODE" character varying(25) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(512) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "Common"."CONTRAT_MODALITE_TEMPS" OWNER TO openconcerto;

--
-- TOC entry 240 (class 1259 OID 6908199)
-- Name: CONTRAT_MODALITE_TEMPS_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."CONTRAT_MODALITE_TEMPS_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."CONTRAT_MODALITE_TEMPS_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24541 (class 0 OID 0)
-- Dependencies: 240
-- Name: CONTRAT_MODALITE_TEMPS_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."CONTRAT_MODALITE_TEMPS_ID_seq" OWNED BY "Common"."CONTRAT_MODALITE_TEMPS"."ID";


--
-- TOC entry 241 (class 1259 OID 6908201)
-- Name: CONTRAT_MOTIF_RECOURS; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."CONTRAT_MOTIF_RECOURS" (
    "ID" integer NOT NULL,
    "CODE" character varying(25) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(512) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "Common"."CONTRAT_MOTIF_RECOURS" OWNER TO openconcerto;

--
-- TOC entry 242 (class 1259 OID 6908211)
-- Name: CONTRAT_MOTIF_RECOURS_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."CONTRAT_MOTIF_RECOURS_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."CONTRAT_MOTIF_RECOURS_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24542 (class 0 OID 0)
-- Dependencies: 242
-- Name: CONTRAT_MOTIF_RECOURS_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."CONTRAT_MOTIF_RECOURS_ID_seq" OWNED BY "Common"."CONTRAT_MOTIF_RECOURS"."ID";


--
-- TOC entry 243 (class 1259 OID 6908213)
-- Name: CONTRAT_REGIME_MALADIE; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."CONTRAT_REGIME_MALADIE" (
    "ID" integer NOT NULL,
    "CODE" character varying(25) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(512) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "Common"."CONTRAT_REGIME_MALADIE" OWNER TO openconcerto;

--
-- TOC entry 244 (class 1259 OID 6908223)
-- Name: CONTRAT_REGIME_MALADIE_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."CONTRAT_REGIME_MALADIE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."CONTRAT_REGIME_MALADIE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24543 (class 0 OID 0)
-- Dependencies: 244
-- Name: CONTRAT_REGIME_MALADIE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."CONTRAT_REGIME_MALADIE_ID_seq" OWNED BY "Common"."CONTRAT_REGIME_MALADIE"."ID";


--
-- TOC entry 245 (class 1259 OID 6908225)
-- Name: CONTRAT_REGIME_VIEILLESSE; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."CONTRAT_REGIME_VIEILLESSE" (
    "ID" integer NOT NULL,
    "CODE" character varying(25) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(512) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "Common"."CONTRAT_REGIME_VIEILLESSE" OWNER TO openconcerto;

--
-- TOC entry 246 (class 1259 OID 6908235)
-- Name: CONTRAT_REGIME_VIEILLESSE_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."CONTRAT_REGIME_VIEILLESSE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."CONTRAT_REGIME_VIEILLESSE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24544 (class 0 OID 0)
-- Dependencies: 246
-- Name: CONTRAT_REGIME_VIEILLESSE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."CONTRAT_REGIME_VIEILLESSE_ID_seq" OWNED BY "Common"."CONTRAT_REGIME_VIEILLESSE"."ID";


--
-- TOC entry 247 (class 1259 OID 6908237)
-- Name: DEVISE; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."DEVISE" (
    "ID" integer NOT NULL,
    "CODE" character varying(128) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(128) DEFAULT ''::character varying NOT NULL,
    "LIBELLE" character varying(128) DEFAULT ''::character varying NOT NULL,
    "LIBELLE_CENT" character varying(128) DEFAULT ''::character varying NOT NULL,
    "TAUX" numeric(16,8) DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric,
    "TAUX_COMMERCIAL" numeric(16,8) DEFAULT 1 NOT NULL
);


ALTER TABLE "Common"."DEVISE" OWNER TO openconcerto;

--
-- TOC entry 248 (class 1259 OID 6908251)
-- Name: DEVISE_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."DEVISE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."DEVISE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24545 (class 0 OID 0)
-- Dependencies: 248
-- Name: DEVISE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."DEVISE_ID_seq" OWNED BY "Common"."DEVISE"."ID";


--
-- TOC entry 249 (class 1259 OID 6908253)
-- Name: DIPLOME_PREPARE; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."DIPLOME_PREPARE" (
    "ID" integer NOT NULL,
    "CODE" character varying(25) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(512) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8)
);


ALTER TABLE "Common"."DIPLOME_PREPARE" OWNER TO openconcerto;

--
-- TOC entry 250 (class 1259 OID 6908262)
-- Name: DIPLOME_PREPARE_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

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


ALTER TABLE "Common"."DIPLOME_PREPARE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24546 (class 0 OID 0)
-- Dependencies: 250
-- Name: DIPLOME_PREPARE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."DIPLOME_PREPARE_ID_seq" OWNED BY "Common"."DIPLOME_PREPARE"."ID";


--
-- TOC entry 251 (class 1259 OID 6908264)
-- Name: DSN_NATURE; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."DSN_NATURE" (
    "ID" integer NOT NULL,
    "CODE" character varying(25) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(512) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "Common"."DSN_NATURE" OWNER TO openconcerto;

--
-- TOC entry 252 (class 1259 OID 6908274)
-- Name: DSN_NATURE_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."DSN_NATURE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."DSN_NATURE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24547 (class 0 OID 0)
-- Dependencies: 252
-- Name: DSN_NATURE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."DSN_NATURE_ID_seq" OWNED BY "Common"."DSN_NATURE"."ID";


--
-- TOC entry 253 (class 1259 OID 6908276)
-- Name: DSN_REGIME_LOCAL; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."DSN_REGIME_LOCAL" (
    "ID" integer NOT NULL,
    "CODE" character varying(25) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(512) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "Common"."DSN_REGIME_LOCAL" OWNER TO openconcerto;

--
-- TOC entry 254 (class 1259 OID 6908286)
-- Name: DSN_REGIME_LOCAL_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."DSN_REGIME_LOCAL_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."DSN_REGIME_LOCAL_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24548 (class 0 OID 0)
-- Dependencies: 254
-- Name: DSN_REGIME_LOCAL_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."DSN_REGIME_LOCAL_ID_seq" OWNED BY "Common"."DSN_REGIME_LOCAL"."ID";


--
-- TOC entry 255 (class 1259 OID 6908288)
-- Name: DSN_TYPE; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."DSN_TYPE" (
    "ID" integer NOT NULL,
    "CODE" character varying(25) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(512) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "Common"."DSN_TYPE" OWNER TO openconcerto;

--
-- TOC entry 256 (class 1259 OID 6908298)
-- Name: DSN_TYPE_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."DSN_TYPE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."DSN_TYPE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24549 (class 0 OID 0)
-- Dependencies: 256
-- Name: DSN_TYPE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."DSN_TYPE_ID_seq" OWNED BY "Common"."DSN_TYPE"."ID";


--
-- TOC entry 257 (class 1259 OID 6908300)
-- Name: ECO_CONTRIBUTION; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."ECO_CONTRIBUTION" (
    "ID" integer NOT NULL,
    "CODE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(512) DEFAULT ''::character varying NOT NULL,
    "ID_FAMILLE_ECO_CONTRIBUTION" integer DEFAULT 1,
    "TAUX" numeric(16,2) DEFAULT 0 NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "Common"."ECO_CONTRIBUTION" OWNER TO openconcerto;

--
-- TOC entry 258 (class 1259 OID 6908312)
-- Name: ECO_CONTRIBUTION_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."ECO_CONTRIBUTION_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."ECO_CONTRIBUTION_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24550 (class 0 OID 0)
-- Dependencies: 258
-- Name: ECO_CONTRIBUTION_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."ECO_CONTRIBUTION_ID_seq" OWNED BY "Common"."ECO_CONTRIBUTION"."ID";


--
-- TOC entry 259 (class 1259 OID 6908314)
-- Name: EXERCICE_COMMON; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."EXERCICE_COMMON" (
    "ID" integer NOT NULL,
    "DATE_DEB" date,
    "DATE_FIN" date,
    "NUMERO" integer DEFAULT 1 NOT NULL,
    "CLOTURE" boolean DEFAULT false NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "DATE_CLOTURE" date,
    "ID_SOCIETE_COMMON" integer DEFAULT 1
);


ALTER TABLE "Common"."EXERCICE_COMMON" OWNER TO openconcerto;

--
-- TOC entry 260 (class 1259 OID 6908322)
-- Name: EXERCICE_COMMON_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."EXERCICE_COMMON_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."EXERCICE_COMMON_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24551 (class 0 OID 0)
-- Dependencies: 260
-- Name: EXERCICE_COMMON_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."EXERCICE_COMMON_ID_seq" OWNED BY "Common"."EXERCICE_COMMON"."ID";


--
-- TOC entry 261 (class 1259 OID 6908324)
-- Name: FAMILLE_ECO_CONTRIBUTION; Type: TABLE; Schema: Common; Owner: openconcerto
--

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


ALTER TABLE "Common"."FAMILLE_ECO_CONTRIBUTION" OWNER TO openconcerto;

--
-- TOC entry 262 (class 1259 OID 6908333)
-- Name: FAMILLE_ECO_CONTRIBUTION_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."FAMILLE_ECO_CONTRIBUTION_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."FAMILLE_ECO_CONTRIBUTION_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24552 (class 0 OID 0)
-- Dependencies: 262
-- Name: FAMILLE_ECO_CONTRIBUTION_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."FAMILLE_ECO_CONTRIBUTION_ID_seq" OWNED BY "Common"."FAMILLE_ECO_CONTRIBUTION"."ID";


--
-- TOC entry 263 (class 1259 OID 6908335)
-- Name: FWK_RIV_METADATA; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."FWK_RIV_METADATA" (
    "ID" integer NOT NULL,
    "ELEMENT_CODE" character varying(80),
    "COMPONENT_CODE" character varying(80),
    "ITEM" character varying(80) NOT NULL,
    "LABEL" character varying(256) DEFAULT ''::character varying NOT NULL,
    "COLUMN_TITLE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "DOCUMENTATION" character varying(8192) DEFAULT ''::character varying NOT NULL
);


ALTER TABLE "Common"."FWK_RIV_METADATA" OWNER TO openconcerto;

--
-- TOC entry 264 (class 1259 OID 6908344)
-- Name: FWK_RIV_METADATA_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."FWK_RIV_METADATA_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."FWK_RIV_METADATA_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24553 (class 0 OID 0)
-- Dependencies: 264
-- Name: FWK_RIV_METADATA_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."FWK_RIV_METADATA_ID_seq" OWNED BY "Common"."FWK_RIV_METADATA"."ID";


--
-- TOC entry 265 (class 1259 OID 6908346)
-- Name: FWK_SCHEMA_METADATA; Type: TABLE; Schema: Common; Owner: openconcerto
--

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


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

--
-- TOC entry 266 (class 1259 OID 6908351)
-- Name: FWK_UNDEFINED_IDS; Type: TABLE; Schema: Common; Owner: openconcerto
--

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


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

--
-- TOC entry 267 (class 1259 OID 6908355)
-- Name: IDCC; Type: TABLE; Schema: Common; Owner: openconcerto
--

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


ALTER TABLE "Common"."IDCC" OWNER TO openconcerto;

--
-- TOC entry 268 (class 1259 OID 6908366)
-- Name: IDCC_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

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


ALTER TABLE "Common"."IDCC_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24554 (class 0 OID 0)
-- Dependencies: 268
-- Name: IDCC_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."IDCC_ID_seq" OWNED BY "Common"."IDCC"."ID";


--
-- TOC entry 269 (class 1259 OID 6908368)
-- Name: IMPRESSION_RUBRIQUE; Type: TABLE; Schema: Common; Owner: openconcerto
--

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


ALTER TABLE "Common"."IMPRESSION_RUBRIQUE" OWNER TO openconcerto;

--
-- TOC entry 270 (class 1259 OID 6908374)
-- Name: IMPRESSION_RUBRIQUE_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."IMPRESSION_RUBRIQUE_ID_seq"
    START WITH 5
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."IMPRESSION_RUBRIQUE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24555 (class 0 OID 0)
-- Dependencies: 270
-- Name: IMPRESSION_RUBRIQUE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."IMPRESSION_RUBRIQUE_ID_seq" OWNED BY "Common"."IMPRESSION_RUBRIQUE"."ID";


--
-- TOC entry 271 (class 1259 OID 6908376)
-- Name: INDICE; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."INDICE" (
    "ANNEE" integer,
    "ID" integer NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0,
    "JANVIER" bigint DEFAULT 0,
    "FEVRIER" bigint DEFAULT 0,
    "MARS" bigint DEFAULT 0,
    "AVRIL" bigint DEFAULT 0,
    "MAI" bigint DEFAULT 0,
    "JUIN" bigint DEFAULT 0,
    "JUILLET" bigint DEFAULT 0,
    "AOUT" bigint DEFAULT 0,
    "SEPTEMBRE" bigint DEFAULT 0,
    "OCTOBRE" bigint DEFAULT 0,
    "NOVEMBRE" bigint DEFAULT 0,
    "DECEMBRE" bigint DEFAULT 0
);


ALTER TABLE "Common"."INDICE" OWNER TO openconcerto;

--
-- TOC entry 272 (class 1259 OID 6908393)
-- Name: INDICE_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."INDICE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."INDICE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24556 (class 0 OID 0)
-- Dependencies: 272
-- Name: INDICE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."INDICE_ID_seq" OWNED BY "Common"."INDICE"."ID";


--
-- TOC entry 273 (class 1259 OID 6908395)
-- Name: MOTIF_ARRET_TRAVAIL; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."MOTIF_ARRET_TRAVAIL" (
    "ID" integer NOT NULL,
    "CODE" character varying(25) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(512) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "Common"."MOTIF_ARRET_TRAVAIL" OWNER TO openconcerto;

--
-- TOC entry 274 (class 1259 OID 6908405)
-- Name: MOTIF_ARRET_TRAVAIL_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."MOTIF_ARRET_TRAVAIL_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."MOTIF_ARRET_TRAVAIL_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24557 (class 0 OID 0)
-- Dependencies: 274
-- Name: MOTIF_ARRET_TRAVAIL_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."MOTIF_ARRET_TRAVAIL_ID_seq" OWNED BY "Common"."MOTIF_ARRET_TRAVAIL"."ID";


--
-- TOC entry 275 (class 1259 OID 6908407)
-- Name: MOTIF_FIN_CONTRAT; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."MOTIF_FIN_CONTRAT" (
    "ID" integer NOT NULL,
    "CODE" character varying(25) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(512) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "Common"."MOTIF_FIN_CONTRAT" OWNER TO openconcerto;

--
-- TOC entry 276 (class 1259 OID 6908417)
-- Name: MOTIF_FIN_CONTRAT_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."MOTIF_FIN_CONTRAT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."MOTIF_FIN_CONTRAT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24558 (class 0 OID 0)
-- Dependencies: 276
-- Name: MOTIF_FIN_CONTRAT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."MOTIF_FIN_CONTRAT_ID_seq" OWNED BY "Common"."MOTIF_FIN_CONTRAT"."ID";


--
-- TOC entry 277 (class 1259 OID 6908419)
-- Name: MOTIF_NON_ASSUJETIS_TA; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."MOTIF_NON_ASSUJETIS_TA" (
    "ID" integer NOT NULL,
    "CODE" character varying(25) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(512) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8)
);


ALTER TABLE "Common"."MOTIF_NON_ASSUJETIS_TA" OWNER TO openconcerto;

--
-- TOC entry 278 (class 1259 OID 6908428)
-- Name: MOTIF_NON_ASSUJETIS_TA_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

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


ALTER TABLE "Common"."MOTIF_NON_ASSUJETIS_TA_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24559 (class 0 OID 0)
-- Dependencies: 278
-- Name: MOTIF_NON_ASSUJETIS_TA_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."MOTIF_NON_ASSUJETIS_TA_ID_seq" OWNED BY "Common"."MOTIF_NON_ASSUJETIS_TA"."ID";


--
-- TOC entry 279 (class 1259 OID 6908430)
-- Name: MOTIF_REPRISE_ARRET_TRAVAIL; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."MOTIF_REPRISE_ARRET_TRAVAIL" (
    "ID" integer NOT NULL,
    "CODE" character varying(25) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(512) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "Common"."MOTIF_REPRISE_ARRET_TRAVAIL" OWNER TO openconcerto;

--
-- TOC entry 280 (class 1259 OID 6908440)
-- Name: MOTIF_REPRISE_ARRET_TRAVAIL_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."MOTIF_REPRISE_ARRET_TRAVAIL_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."MOTIF_REPRISE_ARRET_TRAVAIL_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24560 (class 0 OID 0)
-- Dependencies: 280
-- Name: MOTIF_REPRISE_ARRET_TRAVAIL_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."MOTIF_REPRISE_ARRET_TRAVAIL_ID_seq" OWNED BY "Common"."MOTIF_REPRISE_ARRET_TRAVAIL"."ID";


--
-- TOC entry 281 (class 1259 OID 6908442)
-- Name: OBJET; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."OBJET" (
    "ID" integer NOT NULL,
    "CODE" character varying(45) DEFAULT ''::character varying,
    "NOM" character varying(2048) DEFAULT ''::text,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8) DEFAULT 0
);


ALTER TABLE "Common"."OBJET" OWNER TO openconcerto;

--
-- TOC entry 282 (class 1259 OID 6908452)
-- Name: OBJET_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."OBJET_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."OBJET_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24561 (class 0 OID 0)
-- Dependencies: 282
-- Name: OBJET_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."OBJET_ID_seq" OWNED BY "Common"."OBJET"."ID";


--
-- TOC entry 283 (class 1259 OID 6908454)
-- Name: PERIODE_VALIDITE; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."PERIODE_VALIDITE" (
    "ID" integer NOT NULL,
    "JANVIER" boolean DEFAULT true NOT NULL,
    "FEVRIER" boolean DEFAULT true NOT NULL,
    "MARS" boolean DEFAULT true NOT NULL,
    "AVRIL" boolean DEFAULT true NOT NULL,
    "MAI" boolean DEFAULT true NOT NULL,
    "JUIN" boolean DEFAULT true NOT NULL,
    "JUILLET" boolean DEFAULT true NOT NULL,
    "AOUT" boolean DEFAULT true NOT NULL,
    "SEPTEMBRE" boolean DEFAULT true NOT NULL,
    "OCTOBRE" boolean DEFAULT true NOT NULL,
    "NOVEMBRE" boolean DEFAULT true NOT NULL,
    "DECEMBRE" boolean DEFAULT true NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT 0
);


ALTER TABLE "Common"."PERIODE_VALIDITE" OWNER TO openconcerto;

--
-- TOC entry 284 (class 1259 OID 6908471)
-- Name: PERIODE_VALIDITE_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."PERIODE_VALIDITE_ID_seq"
    START WITH 95
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."PERIODE_VALIDITE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24562 (class 0 OID 0)
-- Dependencies: 284
-- Name: PERIODE_VALIDITE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."PERIODE_VALIDITE_ID_seq" OWNED BY "Common"."PERIODE_VALIDITE"."ID";


--
-- TOC entry 285 (class 1259 OID 6908473)
-- Name: PREF_NODE; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."PREF_NODE" (
    "ID" integer NOT NULL,
    "ID_PARENT" integer,
    "NAME" character varying(80) DEFAULT ''::character varying NOT NULL
);


ALTER TABLE "Common"."PREF_NODE" OWNER TO openconcerto;

--
-- TOC entry 286 (class 1259 OID 6908477)
-- Name: PREF_NODE_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."PREF_NODE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."PREF_NODE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24563 (class 0 OID 0)
-- Dependencies: 286
-- Name: PREF_NODE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."PREF_NODE_ID_seq" OWNED BY "Common"."PREF_NODE"."ID";


--
-- TOC entry 287 (class 1259 OID 6908479)
-- Name: PREF_VALUE; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."PREF_VALUE" (
    "ID_NODE" integer NOT NULL,
    "NAME" character varying(80) DEFAULT ''::character varying NOT NULL,
    "VALUE" character varying(8192) DEFAULT ''::character varying NOT NULL
);


ALTER TABLE "Common"."PREF_VALUE" OWNER TO openconcerto;

--
-- TOC entry 288 (class 1259 OID 6908487)
-- Name: PROFIL_PAYE; Type: TABLE; Schema: Common; Owner: openconcerto
--

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


ALTER TABLE "Common"."PROFIL_PAYE" OWNER TO openconcerto;

--
-- TOC entry 289 (class 1259 OID 6908493)
-- Name: PROFIL_PAYE_ELEMENT; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."PROFIL_PAYE_ELEMENT" (
    "ID" integer NOT NULL,
    "NOM" character varying(128) DEFAULT ''::character varying NOT NULL,
    "ID_PROFIL_PAYE" integer DEFAULT 1 NOT NULL,
    "SOURCE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "IDSOURCE" integer DEFAULT 1 NOT NULL,
    "POSITION" integer DEFAULT 0 NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT 0
);


ALTER TABLE "Common"."PROFIL_PAYE_ELEMENT" OWNER TO openconcerto;

--
-- TOC entry 290 (class 1259 OID 6908503)
-- Name: PROFIL_PAYE_ELEMENT_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."PROFIL_PAYE_ELEMENT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."PROFIL_PAYE_ELEMENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24564 (class 0 OID 0)
-- Dependencies: 290
-- Name: PROFIL_PAYE_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."PROFIL_PAYE_ELEMENT_ID_seq" OWNED BY "Common"."PROFIL_PAYE_ELEMENT"."ID";


--
-- TOC entry 291 (class 1259 OID 6908505)
-- Name: PROFIL_PAYE_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."PROFIL_PAYE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."PROFIL_PAYE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24565 (class 0 OID 0)
-- Dependencies: 291
-- Name: PROFIL_PAYE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."PROFIL_PAYE_ID_seq" OWNED BY "Common"."PROFIL_PAYE"."ID";


--
-- TOC entry 292 (class 1259 OID 6908507)
-- Name: RIGHT; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."RIGHT" (
    "ID" integer NOT NULL,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "CODE" character varying(128) DEFAULT ''::character varying,
    "NOM" character varying(256) DEFAULT ''::character varying,
    "DESCRIPTION" character varying(500) DEFAULT ''::character varying
);


ALTER TABLE "Common"."RIGHT" OWNER TO openconcerto;

--
-- TOC entry 293 (class 1259 OID 6908517)
-- Name: RIGHT_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."RIGHT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."RIGHT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24566 (class 0 OID 0)
-- Dependencies: 293
-- Name: RIGHT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."RIGHT_ID_seq" OWNED BY "Common"."RIGHT"."ID";


--
-- TOC entry 294 (class 1259 OID 6908519)
-- Name: RUBRIQUE_BRUT; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."RUBRIQUE_BRUT" (
    "ID" integer NOT NULL,
    "CODE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(128) DEFAULT ''::character varying NOT NULL,
    "BASE" character varying(2048) DEFAULT ''::text NOT NULL,
    "TAUX" character varying(2048) DEFAULT ''::text NOT NULL,
    "MONTANT" character varying(2048) DEFAULT ''::text NOT NULL,
    "ID_PERIODE_VALIDITE" integer DEFAULT 1 NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "ID_TYPE_RUBRIQUE_BRUT" integer DEFAULT 1 NOT NULL,
    "IMPOSABLE" boolean DEFAULT false NOT NULL,
    "PART_BRUT" boolean DEFAULT false NOT NULL,
    "PART_CP" boolean DEFAULT false NOT NULL,
    "ID_IMPRESSION_RUBRIQUE" integer DEFAULT 1 NOT NULL,
    "ID_CODE_CAISSE_TYPE_RUBRIQUE" integer DEFAULT 1,
    "ID_CODE_TYPE_RUBRIQUE_BRUT" integer DEFAULT 1,
    "COTISABLE" boolean DEFAULT true NOT NULL,
    "TAXABLE_CM" boolean DEFAULT true NOT NULL,
    "AVANTAGE_NATURE" boolean DEFAULT false NOT NULL,
    "CSG_NORMAL" boolean DEFAULT true NOT NULL,
    "CSG_REDUIT" boolean DEFAULT false NOT NULL,
    "PART_CSG_SANS_ABATTEMENT" boolean DEFAULT false NOT NULL,
    "HEURE_SUP_EXO" boolean DEFAULT false NOT NULL
);


ALTER TABLE "Common"."RUBRIQUE_BRUT" OWNER TO openconcerto;

--
-- TOC entry 295 (class 1259 OID 6908546)
-- Name: RUBRIQUE_BRUT_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."RUBRIQUE_BRUT_ID_seq"
    START WITH 42
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."RUBRIQUE_BRUT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24567 (class 0 OID 0)
-- Dependencies: 295
-- Name: RUBRIQUE_BRUT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."RUBRIQUE_BRUT_ID_seq" OWNED BY "Common"."RUBRIQUE_BRUT"."ID";


--
-- TOC entry 296 (class 1259 OID 6908548)
-- Name: RUBRIQUE_COMM; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."RUBRIQUE_COMM" (
    "ID" integer NOT NULL,
    "NOM" character varying(128) DEFAULT ''::character varying NOT NULL,
    "CODE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "NB_BASE" character varying(2048) DEFAULT ''::text NOT NULL,
    "TAUX_SAL" character varying(2048) DEFAULT ''::text NOT NULL,
    "TAUX_PAT" character varying(2048) DEFAULT ''::text NOT NULL,
    "MONTANT_SAL_AJ" character varying(2048) DEFAULT ''::text NOT NULL,
    "MONTANT_SAL_DED" character varying(2048) DEFAULT ''::text NOT NULL,
    "MONTANT_PAT" character varying(2048) DEFAULT ''::text NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ID_PERIODE_VALIDITE" integer DEFAULT 1 NOT NULL,
    "ID_IMPRESSION_RUBRIQUE" integer DEFAULT 1 NOT NULL,
    "NOM_VISIBLE" boolean DEFAULT true NOT NULL,
    "MONTANT" real DEFAULT 0 NOT NULL,
    "REDUCTION_GVT_COM" boolean DEFAULT false NOT NULL
);


ALTER TABLE "Common"."RUBRIQUE_COMM" OWNER TO openconcerto;

--
-- TOC entry 297 (class 1259 OID 6908569)
-- Name: RUBRIQUE_COMM_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."RUBRIQUE_COMM_ID_seq"
    START WITH 10
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."RUBRIQUE_COMM_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24568 (class 0 OID 0)
-- Dependencies: 297
-- Name: RUBRIQUE_COMM_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."RUBRIQUE_COMM_ID_seq" OWNED BY "Common"."RUBRIQUE_COMM"."ID";


--
-- TOC entry 298 (class 1259 OID 6908571)
-- Name: RUBRIQUE_COTISATION; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."RUBRIQUE_COTISATION" (
    "ID" integer NOT NULL,
    "CODE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(128) DEFAULT ''::character varying NOT NULL,
    "ID_CAISSE_COTISATION" integer DEFAULT 1 NOT NULL,
    "BASE" character varying(2048) DEFAULT ''::text NOT NULL,
    "TX_SAL" character varying(2048) DEFAULT ''::text NOT NULL,
    "TX_PAT" character varying(2048) DEFAULT ''::text NOT NULL,
    "IMPOSABLE" boolean DEFAULT false NOT NULL,
    "PART_CSG" boolean DEFAULT false NOT NULL,
    "BRUT" boolean DEFAULT false NOT NULL,
    "ID_PERIODE_VALIDITE" integer DEFAULT 1 NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "ID_IMPRESSION_RUBRIQUE" integer DEFAULT 1 NOT NULL,
    "PART_CSG_SANS_ABATTEMENT" boolean DEFAULT false NOT NULL,
    "PART_PAT_IMPOSABLE" boolean DEFAULT false NOT NULL,
    "REDUCTION_FILLON" boolean DEFAULT false NOT NULL,
    "ASSIETTE_PLAFONNEE" boolean DEFAULT false NOT NULL,
    "ID_CODE_CAISSE_TYPE_RUBRIQUE" integer DEFAULT 1,
    "ID_CODE_BASE_ASSUJETTIE" integer DEFAULT 1,
    "ID_TYPE_COMPOSANT_BASE_ASSUJETTIE" integer DEFAULT 1,
    "ID_CODE_COTISATION_INDIVIDUELLE" integer DEFAULT 1,
    "ID_CODE_COTISATION_ETABLISSEMENT" integer DEFAULT 1,
    "TAXABLE_CM" boolean DEFAULT false NOT NULL,
    "ALLEGEMENT_COTISATION" boolean DEFAULT false NOT NULL,
    "LIGNE_PAYE_SIMPLIFIEE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "NUMERO_COMPTE_PCE" character varying(128) DEFAULT ''::character varying NOT NULL,
    "NUMERO_COMPTE_PCE_CHARGES" character varying(128) DEFAULT ''::character varying NOT NULL,
    "COTISATION_FACULTATIVE" boolean DEFAULT false NOT NULL
);


ALTER TABLE "Common"."RUBRIQUE_COTISATION" OWNER TO openconcerto;

--
-- TOC entry 299 (class 1259 OID 6908604)
-- Name: RUBRIQUE_COTISATION_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."RUBRIQUE_COTISATION_ID_seq"
    START WITH 43
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."RUBRIQUE_COTISATION_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24569 (class 0 OID 0)
-- Dependencies: 299
-- Name: RUBRIQUE_COTISATION_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."RUBRIQUE_COTISATION_ID_seq" OWNED BY "Common"."RUBRIQUE_COTISATION"."ID";


--
-- TOC entry 300 (class 1259 OID 6908606)
-- Name: RUBRIQUE_NET; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."RUBRIQUE_NET" (
    "ID" integer NOT NULL,
    "CODE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(128) DEFAULT ''::character varying NOT NULL,
    "BASE" character varying(2048) DEFAULT ''::text NOT NULL,
    "TAUX" character varying(2048) DEFAULT ''::text NOT NULL,
    "MONTANT" character varying(2048) DEFAULT ''::text NOT NULL,
    "IMPOSABLE" boolean DEFAULT false NOT NULL,
    "FRAIS_PERS" boolean DEFAULT false NOT NULL,
    "BRUT" boolean DEFAULT false NOT NULL,
    "ID_PERIODE_VALIDITE" integer DEFAULT 1 NOT NULL,
    "ID_TYPE_RUBRIQUE_NET" integer DEFAULT 1 NOT NULL,
    "ID_IMPRESSION_RUBRIQUE" integer DEFAULT 1 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "NUMERO_COMPTE_PCE_CHARGES" character varying(128) DEFAULT ''::character varying NOT NULL,
    "ID_CODE_CAISSE_TYPE_RUBRIQUE" integer DEFAULT 1,
    "ID_CODE_TYPE_RUBRIQUE_BRUT" integer DEFAULT 1,
    "ID_CODE_COTISATION_INDIVIDUELLE" integer DEFAULT 1,
    "ID_TYPE_COMPOSANT_BASE_ASSUJETTIE" integer DEFAULT 1,
    "ID_CODE_BASE_ASSUJETTIE" integer DEFAULT 1,
    "ID_CAISSE_COTISATION" integer DEFAULT 1,
    "PAS" boolean DEFAULT false,
    "PAS_CDD" boolean DEFAULT false,
    "EX_NET_SOCIAL" boolean DEFAULT false NOT NULL
);


ALTER TABLE "Common"."RUBRIQUE_NET" OWNER TO openconcerto;

--
-- TOC entry 301 (class 1259 OID 6908634)
-- Name: RUBRIQUE_NET_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."RUBRIQUE_NET_ID_seq"
    START WITH 6
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."RUBRIQUE_NET_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24570 (class 0 OID 0)
-- Dependencies: 301
-- Name: RUBRIQUE_NET_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."RUBRIQUE_NET_ID_seq" OWNED BY "Common"."RUBRIQUE_NET"."ID";


--
-- TOC entry 302 (class 1259 OID 6908636)
-- Name: SERVICE; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."SERVICE" (
    "ID" integer NOT NULL,
    "CODE" character varying(45) DEFAULT ''::character varying,
    "NOM" character varying(2048) DEFAULT ''::text,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8) DEFAULT 0
);


ALTER TABLE "Common"."SERVICE" OWNER TO openconcerto;

--
-- TOC entry 303 (class 1259 OID 6908646)
-- Name: SERVICE_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."SERVICE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."SERVICE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24571 (class 0 OID 0)
-- Dependencies: 303
-- Name: SERVICE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."SERVICE_ID_seq" OWNED BY "Common"."SERVICE"."ID";


--
-- TOC entry 304 (class 1259 OID 6908648)
-- Name: SOCIETE_COMMON; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."SOCIETE_COMMON" (
    "ID" integer NOT NULL,
    "DATABASE_NAME" character varying(256) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(128) DEFAULT ''::character varying NOT NULL,
    "NUM_SIRET" character varying(256) DEFAULT ''::character varying NOT NULL,
    "NUM_NII" character varying(256) DEFAULT ''::character varying NOT NULL,
    "NUM_APE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ID_EXERCICE_COMMON" integer DEFAULT 1 NOT NULL,
    "NUM_TEL" character varying(256) DEFAULT ''::character varying NOT NULL,
    "NUM_FAX" character varying(256) DEFAULT ''::character varying NOT NULL,
    "MAIL" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ID_ADRESSE_COMMON" integer DEFAULT 1 NOT NULL,
    "TYPE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "NUMERO_URSSAF" character varying(256) DEFAULT ''::character varying NOT NULL,
    "RCS" character varying(256) DEFAULT ''::character varying NOT NULL,
    "CAPITAL" numeric(16,2) DEFAULT 0 NOT NULL,
    "ID_DEVISE" integer DEFAULT 1,
    "IBAN" character varying(256) DEFAULT ''::character varying NOT NULL,
    "BIC" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ORG_PROTECTION_SOCIAL_ID" character varying(256) DEFAULT ''::character varying NOT NULL,
    "SITE_WEB" character varying(128) DEFAULT ''::character varying NOT NULL,
    "SEPA_CREDITOR_ID" character varying(16) DEFAULT ''::character varying NOT NULL,
    "ASSUJETTISSEMENT_TA" boolean DEFAULT true NOT NULL,
    "ASSUJETTISSEMENT_CFP" boolean DEFAULT true NOT NULL,
    "ASSUJETTISSEMENT_CFP_CDD" boolean DEFAULT true NOT NULL,
    "ID_MOTIF_NON_ASSUJETIS_TA" integer DEFAULT 1,
    "ID_IDCC" integer
);


ALTER TABLE "Common"."SOCIETE_COMMON" OWNER TO openconcerto;

--
-- TOC entry 305 (class 1259 OID 6908680)
-- Name: SOCIETE_COMMON_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."SOCIETE_COMMON_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."SOCIETE_COMMON_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24572 (class 0 OID 0)
-- Dependencies: 305
-- Name: SOCIETE_COMMON_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."SOCIETE_COMMON_ID_seq" OWNED BY "Common"."SOCIETE_COMMON"."ID";


--
-- TOC entry 306 (class 1259 OID 6908682)
-- Name: STOCK; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."STOCK" (
    "ID" integer NOT NULL,
    "QTE_REEL" real DEFAULT 0 NOT NULL,
    "QTE_TH" real DEFAULT 0 NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT 0
);


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

--
-- TOC entry 307 (class 1259 OID 6908689)
-- Name: STOCK_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

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


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

--
-- TOC entry 24573 (class 0 OID 0)
-- Dependencies: 307
-- Name: STOCK_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

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


--
-- TOC entry 308 (class 1259 OID 6908691)
-- Name: TACHE_COMMON; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."TACHE_COMMON" (
    "ID" integer NOT NULL,
    "PRIORITE" integer DEFAULT 0 NOT NULL,
    "FAIT" boolean DEFAULT false NOT NULL,
    "NOM" character varying(2048) DEFAULT ''::text NOT NULL,
    "DATE_ENTREE" timestamp without time zone,
    "DATE_FAIT" timestamp without time zone,
    "DATE_EXP" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1 NOT NULL,
    "ID_USER_COMMON_TO" integer DEFAULT 1 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "COMMENT" character varying(2048),
    "ID_USER_COMMON_ASSIGN_BY" integer DEFAULT 1,
    "ID_SOCIETE_COMMON" integer DEFAULT 1,
    "TYPE" character varying(128) DEFAULT ''::character varying,
    "COOKIE" character varying(128) DEFAULT ''::character varying
);


ALTER TABLE "Common"."TACHE_COMMON" OWNER TO openconcerto;

--
-- TOC entry 309 (class 1259 OID 6908708)
-- Name: TACHE_COMMON_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."TACHE_COMMON_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."TACHE_COMMON_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24574 (class 0 OID 0)
-- Dependencies: 309
-- Name: TACHE_COMMON_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."TACHE_COMMON_ID_seq" OWNED BY "Common"."TACHE_COMMON"."ID";


--
-- TOC entry 310 (class 1259 OID 6908710)
-- Name: TACHE_LISTENER_COMMON; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."TACHE_LISTENER_COMMON" (
    "ID" integer NOT NULL,
    "ID_USER_COMMON" integer DEFAULT 1 NOT NULL,
    "ID_USER_COMMON_LISTENTO" integer DEFAULT 1 NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT 0
);


ALTER TABLE "Common"."TACHE_LISTENER_COMMON" OWNER TO openconcerto;

--
-- TOC entry 311 (class 1259 OID 6908717)
-- Name: TACHE_LISTENER_COMMON_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."TACHE_LISTENER_COMMON_ID_seq"
    START WITH 4
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."TACHE_LISTENER_COMMON_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24575 (class 0 OID 0)
-- Dependencies: 311
-- Name: TACHE_LISTENER_COMMON_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."TACHE_LISTENER_COMMON_ID_seq" OWNED BY "Common"."TACHE_LISTENER_COMMON"."ID";


--
-- TOC entry 312 (class 1259 OID 6908719)
-- Name: TACHE_RIGHTS; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."TACHE_RIGHTS" (
    "ID" integer NOT NULL,
    "ID_USER_COMMON" integer DEFAULT 1 NOT NULL,
    "ID_USER_COMMON_TO" integer DEFAULT 1 NOT NULL,
    "READ" boolean DEFAULT false NOT NULL,
    "MODIFY" boolean DEFAULT false NOT NULL,
    "ADD" boolean DEFAULT false NOT NULL,
    "VALIDATE" boolean DEFAULT false NOT NULL,
    "ARCHIVE" integer DEFAULT 0
);


ALTER TABLE "Common"."TACHE_RIGHTS" OWNER TO openconcerto;

--
-- TOC entry 313 (class 1259 OID 6908729)
-- Name: TACHE_RIGHTS_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."TACHE_RIGHTS_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."TACHE_RIGHTS_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24576 (class 0 OID 0)
-- Dependencies: 313
-- Name: TACHE_RIGHTS_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."TACHE_RIGHTS_ID_seq" OWNED BY "Common"."TACHE_RIGHTS"."ID";


--
-- TOC entry 314 (class 1259 OID 6908731)
-- Name: TYPE_COMPOSANT_BASE_ASSUJETTIE; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."TYPE_COMPOSANT_BASE_ASSUJETTIE" (
    "ID" integer NOT NULL,
    "CODE" character varying(25) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(512) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "Common"."TYPE_COMPOSANT_BASE_ASSUJETTIE" OWNER TO openconcerto;

--
-- TOC entry 315 (class 1259 OID 6908741)
-- Name: TYPE_COMPOSANT_BASE_ASSUJETTIE_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."TYPE_COMPOSANT_BASE_ASSUJETTIE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."TYPE_COMPOSANT_BASE_ASSUJETTIE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24577 (class 0 OID 0)
-- Dependencies: 315
-- Name: TYPE_COMPOSANT_BASE_ASSUJETTIE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."TYPE_COMPOSANT_BASE_ASSUJETTIE_ID_seq" OWNED BY "Common"."TYPE_COMPOSANT_BASE_ASSUJETTIE"."ID";


--
-- TOC entry 316 (class 1259 OID 6908743)
-- Name: TYPE_MODELE; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."TYPE_MODELE" (
    "ID" integer NOT NULL,
    "NOM" character varying(128) DEFAULT ''::character varying NOT NULL,
    "TABLE" character varying(128) DEFAULT ''::character varying NOT NULL,
    "DEFAULT_MODELE" character varying(128) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "Common"."TYPE_MODELE" OWNER TO openconcerto;

--
-- TOC entry 317 (class 1259 OID 6908751)
-- Name: TYPE_MODELE_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."TYPE_MODELE_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."TYPE_MODELE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24578 (class 0 OID 0)
-- Dependencies: 317
-- Name: TYPE_MODELE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."TYPE_MODELE_ID_seq" OWNED BY "Common"."TYPE_MODELE"."ID";


--
-- TOC entry 318 (class 1259 OID 6908753)
-- Name: TYPE_PREAVIS; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."TYPE_PREAVIS" (
    "ID" integer NOT NULL,
    "CODE" character varying(25) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(512) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


ALTER TABLE "Common"."TYPE_PREAVIS" OWNER TO openconcerto;

--
-- TOC entry 319 (class 1259 OID 6908763)
-- Name: TYPE_PREAVIS_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."TYPE_PREAVIS_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."TYPE_PREAVIS_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24579 (class 0 OID 0)
-- Dependencies: 319
-- Name: TYPE_PREAVIS_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."TYPE_PREAVIS_ID_seq" OWNED BY "Common"."TYPE_PREAVIS"."ID";


--
-- TOC entry 320 (class 1259 OID 6908765)
-- Name: TYPE_RUBRIQUE_BRUT; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."TYPE_RUBRIQUE_BRUT" (
    "ID" integer NOT NULL,
    "NOM" character varying(128) DEFAULT ''::character varying NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "ARCHIVE" integer DEFAULT 1 NOT NULL
);


ALTER TABLE "Common"."TYPE_RUBRIQUE_BRUT" OWNER TO openconcerto;

--
-- TOC entry 321 (class 1259 OID 6908771)
-- Name: TYPE_RUBRIQUE_BRUT_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."TYPE_RUBRIQUE_BRUT_ID_seq"
    START WITH 6
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."TYPE_RUBRIQUE_BRUT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24580 (class 0 OID 0)
-- Dependencies: 321
-- Name: TYPE_RUBRIQUE_BRUT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."TYPE_RUBRIQUE_BRUT_ID_seq" OWNED BY "Common"."TYPE_RUBRIQUE_BRUT"."ID";


--
-- TOC entry 322 (class 1259 OID 6908773)
-- Name: TYPE_RUBRIQUE_NET; Type: TABLE; Schema: Common; Owner: openconcerto
--

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


ALTER TABLE "Common"."TYPE_RUBRIQUE_NET" OWNER TO openconcerto;

--
-- TOC entry 323 (class 1259 OID 6908779)
-- Name: TYPE_RUBRIQUE_NET_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."TYPE_RUBRIQUE_NET_ID_seq"
    START WITH 5
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."TYPE_RUBRIQUE_NET_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24581 (class 0 OID 0)
-- Dependencies: 323
-- Name: TYPE_RUBRIQUE_NET_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."TYPE_RUBRIQUE_NET_ID_seq" OWNED BY "Common"."TYPE_RUBRIQUE_NET"."ID";


--
-- TOC entry 324 (class 1259 OID 6908781)
-- Name: TYPE_TAUX_PAS; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."TYPE_TAUX_PAS" (
    "ID" integer NOT NULL,
    "CODE" character varying(25) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(512) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8)
);


ALTER TABLE "Common"."TYPE_TAUX_PAS" OWNER TO openconcerto;

--
-- TOC entry 325 (class 1259 OID 6908790)
-- Name: TYPE_TAUX_PAS_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."TYPE_TAUX_PAS_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."TYPE_TAUX_PAS_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24582 (class 0 OID 0)
-- Dependencies: 325
-- Name: TYPE_TAUX_PAS_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."TYPE_TAUX_PAS_ID_seq" OWNED BY "Common"."TYPE_TAUX_PAS"."ID";


--
-- TOC entry 326 (class 1259 OID 6908792)
-- Name: USER_COMMON; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."USER_COMMON" (
    "ID" integer NOT NULL,
    "LOGIN" character varying(128) DEFAULT ''::character varying NOT NULL,
    "PASSWORD" character varying(128) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(128) DEFAULT ''::character varying NOT NULL,
    "PRENOM" character varying(128) DEFAULT ''::character varying NOT NULL,
    "SURNOM" character varying(128) DEFAULT ''::character varying NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "SUPERUSER" boolean DEFAULT false,
    "ADMIN" boolean DEFAULT false,
    "MAIL" character varying(2048) DEFAULT ''::text,
    "DISABLED" boolean DEFAULT false NOT NULL,
    "TEL" character varying(128) DEFAULT ''::character varying NOT NULL,
    "COLOR" integer DEFAULT 0 NOT NULL
);


ALTER TABLE "Common"."USER_COMMON" OWNER TO openconcerto;

--
-- TOC entry 327 (class 1259 OID 6908811)
-- Name: USER_COMMON_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."USER_COMMON_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."USER_COMMON_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24583 (class 0 OID 0)
-- Dependencies: 327
-- Name: USER_COMMON_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."USER_COMMON_ID_seq" OWNED BY "Common"."USER_COMMON"."ID";


--
-- TOC entry 328 (class 1259 OID 6908813)
-- Name: USER_RIGHT; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."USER_RIGHT" (
    "ORDRE" numeric(16,8),
    "ARCHIVE" integer DEFAULT 0,
    "ID_USER_COMMON" integer DEFAULT 1,
    "HAVE_RIGHT" boolean,
    "CODE" character varying(128) DEFAULT ''::character varying,
    "ID" integer NOT NULL,
    "NOM" character varying(256) DEFAULT ''::character varying,
    "DESCRIPTION" character varying(500) DEFAULT ''::character varying,
    "ID_RIGHT" integer DEFAULT 1,
    "OBJECT" character varying(256)
);


ALTER TABLE "Common"."USER_RIGHT" OWNER TO openconcerto;

--
-- TOC entry 329 (class 1259 OID 6908825)
-- Name: USER_RIGHT_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."USER_RIGHT_ID_seq"
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."USER_RIGHT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24584 (class 0 OID 0)
-- Dependencies: 329
-- Name: USER_RIGHT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."USER_RIGHT_ID_seq" OWNED BY "Common"."USER_RIGHT"."ID";


--
-- TOC entry 330 (class 1259 OID 6908827)
-- Name: VARIABLE_PAYE; Type: TABLE; Schema: Common; Owner: openconcerto
--

CREATE TABLE "Common"."VARIABLE_PAYE" (
    "ID" integer NOT NULL,
    "VALEUR" real DEFAULT 0 NOT NULL,
    "FORMULE" character varying(2048) DEFAULT ''::text NOT NULL,
    "NOM" character varying(128) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "CATEGORIE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "INFOS" character varying(2048) DEFAULT ''::text NOT NULL
);


ALTER TABLE "Common"."VARIABLE_PAYE" OWNER TO openconcerto;

--
-- TOC entry 331 (class 1259 OID 6908840)
-- Name: VARIABLE_PAYE_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "Common"."VARIABLE_PAYE_ID_seq"
    START WITH 51
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "Common"."VARIABLE_PAYE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 24585 (class 0 OID 0)
-- Dependencies: 331
-- Name: VARIABLE_PAYE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "Common"."VARIABLE_PAYE_ID_seq" OWNED BY "Common"."VARIABLE_PAYE"."ID";


--
-- TOC entry 332 (class 1259 OID 6908842)
-- Name: VILLE; Type: TABLE; Schema: Common; Owner: openconcerto
--

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


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

--
-- TOC entry 333 (class 1259 OID 6908853)
-- Name: VILLE_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

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


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

--
-- TOC entry 24586 (class 0 OID 0)
-- Dependencies: 333
-- Name: VILLE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

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


--
-- TOC entry 334 (class 1259 OID 6908855)
-- Name: ACOMPTE; Type: TABLE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 335 (class 1259 OID 6908864)
-- Name: ACOMPTE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24587 (class 0 OID 0)
-- Dependencies: 335
-- Name: ACOMPTE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 336 (class 1259 OID 6908866)
-- Name: ADRESSE; Type: TABLE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 337 (class 1259 OID 6908886)
-- Name: ADRESSE_ID_ADRESSE_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24588 (class 0 OID 0)
-- Dependencies: 337
-- Name: ADRESSE_ID_ADRESSE_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 338 (class 1259 OID 6908888)
-- Name: AGENCE; Type: TABLE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 339 (class 1259 OID 6908901)
-- Name: AGENCE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24589 (class 0 OID 0)
-- Dependencies: 339
-- Name: AGENCE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 340 (class 1259 OID 6908903)
-- Name: ARRET_CHOMAGE_INTEMPERIE; Type: TABLE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 341 (class 1259 OID 6908910)
-- Name: ARRET_CHOMAGE_INTEMPERIE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24590 (class 0 OID 0)
-- Dependencies: 341
-- Name: ARRET_CHOMAGE_INTEMPERIE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 342 (class 1259 OID 6908912)
-- Name: ARRET_TRAVAIL; Type: TABLE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 343 (class 1259 OID 6908925)
-- Name: ARRET_TRAVAIL_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24591 (class 0 OID 0)
-- Dependencies: 343
-- Name: ARRET_TRAVAIL_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 344 (class 1259 OID 6908927)
-- Name: ARTICLE; Type: TABLE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 345 (class 1259 OID 6909002)
-- Name: ARTICLE_CATEGORIE_COMPTABLE; Type: TABLE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 346 (class 1259 OID 6909012)
-- Name: ARTICLE_CATEGORIE_COMPTABLE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24592 (class 0 OID 0)
-- Dependencies: 346
-- Name: ARTICLE_CATEGORIE_COMPTABLE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 347 (class 1259 OID 6909014)
-- Name: ARTICLE_CODE_CLIENT; Type: TABLE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 348 (class 1259 OID 6909025)
-- Name: ARTICLE_CODE_CLIENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24593 (class 0 OID 0)
-- Dependencies: 348
-- Name: ARTICLE_CODE_CLIENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 349 (class 1259 OID 6909027)
-- Name: ARTICLE_DECLINAISON_COULEUR; Type: TABLE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 350 (class 1259 OID 6909032)
-- Name: ARTICLE_DECLINAISON_COULEUR_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24594 (class 0 OID 0)
-- Dependencies: 350
-- Name: ARTICLE_DECLINAISON_COULEUR_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 351 (class 1259 OID 6909034)
-- Name: ARTICLE_DECLINAISON_TAILLE; Type: TABLE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 352 (class 1259 OID 6909039)
-- Name: ARTICLE_DECLINAISON_TAILLE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24595 (class 0 OID 0)
-- Dependencies: 352
-- Name: ARTICLE_DECLINAISON_TAILLE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 353 (class 1259 OID 6909041)
-- Name: ARTICLE_DESIGNATION; Type: TABLE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 354 (class 1259 OID 6909052)
-- Name: ARTICLE_DESIGNATION_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24596 (class 0 OID 0)
-- Dependencies: 354
-- Name: ARTICLE_DESIGNATION_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."ARTICLE_DESIGNATION_ID_seq" OWNED BY "Default"."ARTICLE_DESIGNATION"."ID";


--
-- TOC entry 355 (class 1259 OID 6909054)
-- Name: ARTICLE_ELEMENT; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."ARTICLE_ELEMENT" (
    "ID" integer NOT NULL,
    "ID_ARTICLE" integer DEFAULT 1,
    "ID_ARTICLE_PARENT" integer DEFAULT 1,
    "QTE" integer DEFAULT 1 NOT NULL,
    "QTE_UNITAIRE" numeric(16,6) DEFAULT 1 NOT NULL,
    "ID_UNITE_VENTE" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


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

--
-- TOC entry 356 (class 1259 OID 6909064)
-- Name: ARTICLE_ELEMENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24597 (class 0 OID 0)
-- Dependencies: 356
-- Name: ARTICLE_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."ARTICLE_ELEMENT_ID_seq" OWNED BY "Default"."ARTICLE_ELEMENT"."ID";


--
-- TOC entry 357 (class 1259 OID 6909066)
-- Name: ARTICLE_FOURNISSEUR; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."ARTICLE_FOURNISSEUR" (
    "ID" integer NOT NULL,
    "CODE" character varying(45) DEFAULT ''::character varying NOT NULL,
    "CODE_BARRE" character varying(45) DEFAULT ''::character varying NOT NULL,
    "CODE_DOUANIER" character varying(45) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(2048) DEFAULT ''::character varying NOT NULL,
    "DESCRIPTIF" character varying(2048) DEFAULT ''::character varying NOT NULL,
    "INFOS" character varying(2048) DEFAULT ''::character varying NOT NULL,
    "PRIX_METRIQUE_HA_1" numeric(16,6) DEFAULT 0,
    "PRIX_METRIQUE_HA_2" numeric(16,8) DEFAULT 0,
    "PRIX_METRIQUE_HA_3" numeric(16,8) DEFAULT 0,
    "PRIX_METRIQUE_VT_1" numeric(16,8) DEFAULT 0,
    "PRIX_METRIQUE_VT_2" numeric(16,8) DEFAULT 0,
    "PRIX_METRIQUE_VT_3" numeric(16,8) DEFAULT 0,
    "ID_METRIQUE_1" integer DEFAULT 1,
    "ID_METRIQUE_2" integer DEFAULT 1,
    "ID_METRIQUE_3" integer DEFAULT 1,
    "PA_DEVISE" numeric(16,8) DEFAULT 0,
    "PV_U_DEVISE" numeric(16,8) DEFAULT 0,
    "PA_HT" numeric(16,8) DEFAULT 0,
    "PV_HT" numeric(16,8) DEFAULT 0,
    "PV_TTC" numeric(16,2) DEFAULT 0,
    "ID_TAXE" integer DEFAULT 1,
    "ID_FAMILLE_ARTICLE_FOURNISSEUR" integer DEFAULT 1,
    "ID_MODE_VENTE_ARTICLE" integer DEFAULT 1,
    "ID_FOURNISSEUR" integer DEFAULT 1,
    "ID_PAYS" integer DEFAULT 1,
    "ID_DEVISE" integer DEFAULT 1,
    "ID_DEVISE_HA" integer DEFAULT 1,
    "ID_UNITE_VENTE" integer DEFAULT 1,
    "ID_COMPTE_PCE" integer DEFAULT 1,
    "ID_COMPTE_PCE_ACHAT" integer DEFAULT 1,
    "ID_ARTICLE" integer DEFAULT 1,
    "POIDS" real DEFAULT 0,
    "VALEUR_METRIQUE_1" real DEFAULT 0,
    "VALEUR_METRIQUE_2" real DEFAULT 0,
    "VALEUR_METRIQUE_3" real DEFAULT 0,
    "SERVICE" boolean DEFAULT false NOT NULL,
    "OBSOLETE" boolean DEFAULT false NOT NULL,
    "GESTION_STOCK" boolean DEFAULT false NOT NULL,
    "QTE_ACHAT" integer DEFAULT 1 NOT NULL,
    "QTE_MIN" integer DEFAULT 1 NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric,
    "ID_FAMILLE_ARTICLE" integer DEFAULT 1,
    "QTE_UNITAIRE" numeric(16,6) DEFAULT 1 NOT NULL
);


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

--
-- TOC entry 358 (class 1259 OID 6909116)
-- Name: ARTICLE_FOURNISSEUR_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24598 (class 0 OID 0)
-- Dependencies: 358
-- Name: ARTICLE_FOURNISSEUR_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."ARTICLE_FOURNISSEUR_ID_seq" OWNED BY "Default"."ARTICLE_FOURNISSEUR"."ID";


--
-- TOC entry 359 (class 1259 OID 6909118)
-- Name: ARTICLE_FOURNISSEUR_SECONDAIRE; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."ARTICLE_FOURNISSEUR_SECONDAIRE" (
    "ID" integer NOT NULL,
    "ID_ARTICLE" integer DEFAULT 1,
    "ID_FOURNISSEUR" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8)
);


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

--
-- TOC entry 360 (class 1259 OID 6909124)
-- Name: ARTICLE_FOURNISSEUR_SECONDAIRE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24599 (class 0 OID 0)
-- Dependencies: 360
-- Name: ARTICLE_FOURNISSEUR_SECONDAIRE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."ARTICLE_FOURNISSEUR_SECONDAIRE_ID_seq" OWNED BY "Default"."ARTICLE_FOURNISSEUR_SECONDAIRE"."ID";


--
-- TOC entry 361 (class 1259 OID 6909126)
-- Name: ARTICLE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24600 (class 0 OID 0)
-- Dependencies: 361
-- Name: ARTICLE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."ARTICLE_ID_seq" OWNED BY "Default"."ARTICLE"."ID";


--
-- TOC entry 362 (class 1259 OID 6909128)
-- Name: ARTICLE_TARIF; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."ARTICLE_TARIF" (
    "ID" integer NOT NULL,
    "ID_DEVISE" integer DEFAULT 1,
    "ID_TAXE" integer DEFAULT 1,
    "ID_TARIF" integer DEFAULT 1,
    "ID_ARTICLE" integer DEFAULT 1,
    "PV_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "PV_TTC" numeric(16,2) DEFAULT 0 NOT NULL,
    "PRIX_METRIQUE_VT_1" numeric(16,6) DEFAULT 0 NOT NULL,
    "PRIX_METRIQUE_VT_2" numeric(16,6) DEFAULT 0 NOT NULL,
    "PRIX_METRIQUE_VT_3" numeric(16,6) DEFAULT 0 NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric,
    "POURCENT_REMISE" numeric(16,6) DEFAULT 0 NOT NULL,
    "QTE" integer DEFAULT 1 NOT NULL
);


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

--
-- TOC entry 363 (class 1259 OID 6909144)
-- Name: ARTICLE_TARIF_FOURNISSEUR; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."ARTICLE_TARIF_FOURNISSEUR" (
    "ID" integer NOT NULL,
    "ID_ARTICLE" integer DEFAULT 1,
    "ID_FOURNISSEUR" integer DEFAULT 1,
    "REF_FOURNISSEUR" character varying(500) DEFAULT ''::character varying NOT NULL,
    "TYPE_REAPPRO" character varying(256) DEFAULT ''::character varying NOT NULL,
    "CONDITIONS" character varying(1024) DEFAULT ''::character varying NOT NULL,
    "ACHETEUR" character varying(256) DEFAULT ''::character varying NOT NULL,
    "CODE_PAYS_ORIGINE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "PRIX_ACHAT_DEVISE_F" numeric(16,6) DEFAULT 0 NOT NULL,
    "PRIX_ACHAT" numeric(16,6) DEFAULT 0 NOT NULL,
    "QTE" integer DEFAULT 1 NOT NULL,
    "DATE_PRIX" timestamp without time zone,
    "DELAI_REAPPRO" integer DEFAULT 0 NOT NULL,
    "DELAI_TRANSPORT" integer DEFAULT 0 NOT NULL,
    "PRIORITE" integer DEFAULT 0 NOT NULL,
    "COEF_PRIX_MINI" numeric(16,2) DEFAULT 0 NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8)
);


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

--
-- TOC entry 364 (class 1259 OID 6909165)
-- Name: ARTICLE_TARIF_FOURNISSEUR_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24601 (class 0 OID 0)
-- Dependencies: 364
-- Name: ARTICLE_TARIF_FOURNISSEUR_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."ARTICLE_TARIF_FOURNISSEUR_ID_seq" OWNED BY "Default"."ARTICLE_TARIF_FOURNISSEUR"."ID";


--
-- TOC entry 365 (class 1259 OID 6909167)
-- Name: ARTICLE_TARIF_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24602 (class 0 OID 0)
-- Dependencies: 365
-- Name: ARTICLE_TARIF_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."ARTICLE_TARIF_ID_seq" OWNED BY "Default"."ARTICLE_TARIF"."ID";


--
-- TOC entry 366 (class 1259 OID 6909169)
-- Name: ARTICLE_TARIF_PROMOTION; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."ARTICLE_TARIF_PROMOTION" (
    "ID" integer NOT NULL,
    "ID_DEVISE" integer DEFAULT 1,
    "ID_TAXE" integer DEFAULT 1,
    "ID_TARIF_PROMOTION" integer DEFAULT 1,
    "ID_ARTICLE" integer DEFAULT 1,
    "QTE" integer DEFAULT 1 NOT NULL,
    "PV_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "PV_TTC" numeric(16,6) DEFAULT 0 NOT NULL,
    "PRIX_METRIQUE_VT_1" numeric(16,6) DEFAULT 0 NOT NULL,
    "PRIX_METRIQUE_VT_2" numeric(16,6) DEFAULT 0 NOT NULL,
    "PRIX_METRIQUE_VT_3" numeric(16,6) DEFAULT 0 NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8)
);


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

--
-- TOC entry 367 (class 1259 OID 6909183)
-- Name: ARTICLE_TARIF_PROMOTION_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24603 (class 0 OID 0)
-- Dependencies: 367
-- Name: ARTICLE_TARIF_PROMOTION_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."ARTICLE_TARIF_PROMOTION_ID_seq" OWNED BY "Default"."ARTICLE_TARIF_PROMOTION"."ID";


--
-- TOC entry 368 (class 1259 OID 6909185)
-- Name: ASSOCIATION_ANALYTIQUE; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."ASSOCIATION_ANALYTIQUE" (
    "ID" integer NOT NULL,
    "ID_ECRITURE" integer DEFAULT 1,
    "ID_SAISIE_KM_ELEMENT" integer DEFAULT 1,
    "ID_POSTE_ANALYTIQUE" integer DEFAULT 1,
    "POURCENT" numeric(16,8) DEFAULT 100,
    "MONTANT" bigint DEFAULT 0,
    "GESTION_AUTO" boolean DEFAULT false NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


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

--
-- TOC entry 369 (class 1259 OID 6909196)
-- Name: ASSOCIATION_ANALYTIQUE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24604 (class 0 OID 0)
-- Dependencies: 369
-- Name: ASSOCIATION_ANALYTIQUE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."ASSOCIATION_ANALYTIQUE_ID_seq" OWNED BY "Default"."ASSOCIATION_ANALYTIQUE"."ID";


--
-- TOC entry 370 (class 1259 OID 6909198)
-- Name: ASSOCIATION_COMPTE_ANALYTIQUE; Type: TABLE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 371 (class 1259 OID 6909207)
-- Name: ASSOCIATION_COMPTE_ANALYTIQUE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24605 (class 0 OID 0)
-- Dependencies: 371
-- Name: ASSOCIATION_COMPTE_ANALYTIQUE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."ASSOCIATION_COMPTE_ANALYTIQUE_ID_seq" OWNED BY "Default"."ASSOCIATION_COMPTE_ANALYTIQUE"."ID";


--
-- TOC entry 372 (class 1259 OID 6909209)
-- Name: ATTACHMENT; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."ATTACHMENT" (
    "ID" integer NOT NULL,
    "SOURCE_TABLE" character varying(128) DEFAULT ''::character varying NOT NULL,
    "SOURCE_ID" integer DEFAULT 0 NOT NULL,
    "NAME" character varying(256) DEFAULT ''::character varying NOT NULL,
    "MIMETYPE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "FILENAME" character varying(256) DEFAULT ''::character varying NOT NULL,
    "FILESIZE" bigint DEFAULT 0 NOT NULL,
    "STORAGE_PATH" character varying(256) DEFAULT ''::character varying NOT NULL,
    "STORAGE_FILENAME" character varying(256) DEFAULT ''::character varying NOT NULL,
    "DIRECTORY" character varying(256) DEFAULT ''::character varying NOT NULL,
    "THUMBNAIL" character varying(256) DEFAULT ''::character varying NOT NULL,
    "THUMBNAIL_WIDTH" integer DEFAULT 32 NOT NULL,
    "THUMBNAIL_HEIGHT" integer DEFAULT 32 NOT NULL,
    "TAG" character varying(128) DEFAULT ''::character varying NOT NULL,
    "VERSION" integer DEFAULT 0 NOT NULL,
    "HASH" character varying(32) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric,
    "ID_PARENT" integer DEFAULT 1,
    "ENCRYPTED" boolean DEFAULT false NOT NULL
);


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

--
-- TOC entry 373 (class 1259 OID 6909234)
-- Name: ATTACHMENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24606 (class 0 OID 0)
-- Dependencies: 373
-- Name: ATTACHMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."ATTACHMENT_ID_seq" OWNED BY "Default"."ATTACHMENT"."ID";


--
-- TOC entry 374 (class 1259 OID 6909236)
-- Name: AVOIR_CLIENT; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."AVOIR_CLIENT" (
    "ID" integer NOT NULL,
    "NOM" character varying(100) DEFAULT ''::character varying,
    "DATE" date,
    "MONTANT_TTC" bigint DEFAULT 0,
    "ID_TAXE" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID_CLIENT" integer DEFAULT 1,
    "MONTANT_HT" bigint DEFAULT 0,
    "MONTANT_TVA" bigint DEFAULT 0,
    "NUMERO" character varying(45) DEFAULT ''::character varying,
    "ID_SAISIE_VENTE_FACTURE" integer DEFAULT 1,
    "ID_MODE_REGLEMENT" integer DEFAULT 1,
    "PORT_HT" bigint DEFAULT 0,
    "REMISE_HT" bigint DEFAULT 0,
    "MONTANT_SERVICE" bigint DEFAULT 0,
    "ID_MOUVEMENT" integer DEFAULT 1,
    "SOLDE" boolean DEFAULT false,
    "A_DEDUIRE" boolean DEFAULT false,
    "ENVOYE_EN_AFFACTURAGE" boolean DEFAULT false,
    "DATE_ENVOI_AFFACTURAGE" date,
    "AFFACTURAGE" boolean DEFAULT false,
    "MONTANT_SOLDE" bigint DEFAULT 0,
    "MONTANT_RESTANT" bigint DEFAULT 0,
    "COMPTE_SERVICE_AUTO" boolean DEFAULT false,
    "ID_CONTACT" integer DEFAULT 1,
    "ID_COMPTE_PCE_SERVICE" integer DEFAULT 1,
    "MOTIF" character varying(256) DEFAULT ''::character varying NOT NULL,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "ID_ADRESSE" integer DEFAULT 1,
    "ID_COMMERCIAL" integer DEFAULT 1,
    "AFFACTURE" boolean DEFAULT false,
    "T_DEVISE" bigint DEFAULT 0,
    "T_POIDS" real DEFAULT 0,
    "ID_TARIF" integer DEFAULT 1,
    "ID_MODELE" integer DEFAULT 1,
    "INFOS" character varying(1024) DEFAULT ''::character varying NOT NULL,
    "ID_ADRESSE_LIVRAISON" integer DEFAULT 1,
    "POURCENT_REMISE" numeric(12,8),
    "MONTANT_REMISE" numeric(16,8),
    "ID_CLIENT_DEPARTEMENT" integer DEFAULT 1,
    "T_ECO_CONTRIBUTION" bigint DEFAULT 0,
    "ID_CATEGORIE_COMPTABLE" integer DEFAULT 1,
    "ID_TAXE_PORT" integer DEFAULT 1,
    "MONTANT_INTERFEL_HT" bigint DEFAULT 0 NOT NULL
);


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

--
-- TOC entry 375 (class 1259 OID 6909281)
-- Name: AVOIR_CLIENT_ELEMENT; Type: TABLE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 376 (class 1259 OID 6909363)
-- Name: AVOIR_CLIENT_ELEMENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24607 (class 0 OID 0)
-- Dependencies: 376
-- Name: AVOIR_CLIENT_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."AVOIR_CLIENT_ELEMENT_ID_seq" OWNED BY "Default"."AVOIR_CLIENT_ELEMENT"."ID";


--
-- TOC entry 377 (class 1259 OID 6909365)
-- Name: AVOIR_CLIENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24608 (class 0 OID 0)
-- Dependencies: 377
-- Name: AVOIR_CLIENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."AVOIR_CLIENT_ID_seq" OWNED BY "Default"."AVOIR_CLIENT"."ID";


--
-- TOC entry 378 (class 1259 OID 6909367)
-- Name: AVOIR_FOURNISSEUR; Type: TABLE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 379 (class 1259 OID 6909391)
-- Name: AVOIR_FOURNISSEUR_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24609 (class 0 OID 0)
-- Dependencies: 379
-- Name: AVOIR_FOURNISSEUR_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."AVOIR_FOURNISSEUR_ID_seq" OWNED BY "Default"."AVOIR_FOURNISSEUR"."ID";


--
-- TOC entry 380 (class 1259 OID 6909393)
-- Name: AXE_ANALYTIQUE; Type: TABLE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 381 (class 1259 OID 6909404)
-- Name: AXE_ANALYTIQUE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24610 (class 0 OID 0)
-- Dependencies: 381
-- Name: AXE_ANALYTIQUE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."AXE_ANALYTIQUE_ID_seq" OWNED BY "Default"."AXE_ANALYTIQUE"."ID";


--
-- TOC entry 382 (class 1259 OID 6909406)
-- Name: AYANT_DROIT; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."AYANT_DROIT" (
    "ID" integer NOT NULL,
    "NOM" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ID_SALARIE" integer DEFAULT 1,
    "ID_AYANT_DROIT_TYPE" integer DEFAULT 1,
    "REGIME_ALSACE" boolean DEFAULT false NOT NULL,
    "NIR" character varying(256) DEFAULT ''::character varying NOT NULL,
    "PRENOMS" character varying(256) DEFAULT ''::character varying NOT NULL,
    "CODE_ORGANISME_AFFILIATION" character varying(256) DEFAULT ''::character varying NOT NULL,
    "CODE_OPTION" character varying(256) DEFAULT ''::character varying NOT NULL,
    "NIR_OUVRANT_DROIT" character varying(256) DEFAULT ''::character varying NOT NULL,
    "DATE_DEBUT_RATTACHEMENT" timestamp without time zone,
    "DATE_FIN_RATTACHEMENT" timestamp without time zone,
    "DATE_NAISSANCE" timestamp without time zone,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


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

--
-- TOC entry 383 (class 1259 OID 6909423)
-- Name: AYANT_DROIT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24611 (class 0 OID 0)
-- Dependencies: 383
-- Name: AYANT_DROIT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."AYANT_DROIT_ID_seq" OWNED BY "Default"."AYANT_DROIT"."ID";


--
-- TOC entry 384 (class 1259 OID 6909425)
-- Name: BANQUE; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."BANQUE" (
    "ID" integer NOT NULL,
    "ID_JOURNAL" integer DEFAULT 1,
    "INFOS" character varying(2048) DEFAULT ''::character varying NOT NULL,
    "NUMERO_RUE" character varying(45) DEFAULT ''::character varying NOT NULL,
    "RUE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "IBAN" character varying(256) DEFAULT ''::character varying NOT NULL,
    "BIC" character varying(256) DEFAULT ''::character varying NOT NULL,
    "VOIE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "VILLE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "NOM" character varying(256) DEFAULT ''::character varying NOT NULL,
    "DOMICILIATION" character varying(256) DEFAULT ''::character varying NOT NULL,
    "CODE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "AFFACTURAGE" boolean DEFAULT false NOT NULL,
    "ID_COMPTE_PCE" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric,
    "ID_COMPTE_PCE_CB_ATTENTE" integer DEFAULT 1,
    "ID_JOURNAL_CB_ATTENTE" integer DEFAULT 1,
    "ID_COMPTE_PCE_FRAIS_CB" integer DEFAULT 1
);


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

--
-- TOC entry 385 (class 1259 OID 6909446)
-- Name: BANQUE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24612 (class 0 OID 0)
-- Dependencies: 385
-- Name: BANQUE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."BANQUE_ID_seq" OWNED BY "Default"."BANQUE"."ID";


--
-- TOC entry 386 (class 1259 OID 6909448)
-- Name: BON_DE_LIVRAISON; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."BON_DE_LIVRAISON" (
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID" integer NOT NULL,
    "DATE" date,
    "ID_SAISIE_VENTE_FACTURE" integer DEFAULT 1,
    "NUMERO" character varying(45) DEFAULT ''::character varying,
    "ID_CLIENT" integer DEFAULT 1,
    "INFOS" character varying(2048) DEFAULT ''::text,
    "TOTAL_HT" bigint DEFAULT 0,
    "TOTAL_TVA" bigint DEFAULT 0,
    "TOTAL_TTC" bigint DEFAULT 0,
    "TOTAL_POIDS" real DEFAULT 0,
    "ID_COMMANDE_CLIENT" integer DEFAULT 1,
    "NOM" character varying(45) DEFAULT ''::character varying,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "SOURCE" character varying(512) DEFAULT ''::character varying NOT NULL,
    "IDSOURCE" integer DEFAULT 1,
    "T_DEVISE" bigint DEFAULT 0,
    "T_POIDS" real DEFAULT 0,
    "ID_TARIF" integer DEFAULT 1,
    "ID_MODELE" integer DEFAULT 1,
    "DATE_LIVRAISON" date,
    "ID_ADRESSE" integer DEFAULT 1,
    "ID_ADRESSE_LIVRAISON" integer DEFAULT 1,
    "POURCENT_REMISE" numeric(12,8),
    "MONTANT_REMISE" numeric(16,8),
    "ID_CONTACT" integer DEFAULT 1,
    "ID_CLIENT_DEPARTEMENT" integer DEFAULT 1,
    "TOTAL_DEVISE" bigint DEFAULT 0 NOT NULL,
    "TOTAL_SERVICE" bigint DEFAULT 0 NOT NULL,
    "ID_TAXE_PORT" integer DEFAULT 1,
    "PORT_HT" bigint DEFAULT 0 NOT NULL,
    "REMISE_HT" bigint DEFAULT 0 NOT NULL,
    "CREATE_VIRTUAL_STOCK" boolean DEFAULT true NOT NULL,
    "T_ECO_CONTRIBUTION" bigint DEFAULT 0,
    "FRAIS_DOCUMENT_HT" bigint DEFAULT 0 NOT NULL,
    "ID_TAXE_FRAIS_DOCUMENT" integer DEFAULT 1,
    "ID_COMMERCIAL" integer DEFAULT 1,
    "ID_CATEGORIE_COMPTABLE" integer DEFAULT 1,
    "VERROU_FACTURATION" boolean DEFAULT false NOT NULL,
    "ID_LOT" integer DEFAULT 1,
    "T_ACOMPTE" bigint DEFAULT 0 NOT NULL,
    "MONTANT_INTERFEL_HT" bigint DEFAULT 0 NOT NULL
);


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

--
-- TOC entry 387 (class 1259 OID 6909491)
-- Name: BON_DE_LIVRAISON_ELEMENT; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."BON_DE_LIVRAISON_ELEMENT" (
    "ID_SAISIE_VENTE_FACTURE_ELEMENT" integer DEFAULT 1,
    "QTE_A_LIVRER" integer DEFAULT 0,
    "QTE_LIVREE" integer DEFAULT 0,
    "ID" integer NOT NULL,
    "CODE" character varying(45) DEFAULT ''::character varying,
    "NOM" character varying(2048) DEFAULT ''::text,
    "PV_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "QTE" integer DEFAULT 0,
    "ID_TAXE" integer DEFAULT 1,
    "POIDS" real DEFAULT 0,
    "ID_BON_DE_LIVRAISON" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "VALEUR_METRIQUE_1" real DEFAULT 0,
    "PRIX_METRIQUE_VT_1" numeric(16,6) DEFAULT 0 NOT NULL,
    "PRIX_METRIQUE_HA_1" numeric(16,6) DEFAULT 0 NOT NULL,
    "ID_METRIQUE_1" integer DEFAULT 1,
    "VALEUR_METRIQUE_2" real DEFAULT 0,
    "PRIX_METRIQUE_VT_2" numeric(16,6) DEFAULT 0 NOT NULL,
    "PRIX_METRIQUE_HA_2" numeric(16,6) DEFAULT 0 NOT NULL,
    "ID_METRIQUE_2" integer DEFAULT 1,
    "VALEUR_METRIQUE_3" real DEFAULT 0,
    "PRIX_METRIQUE_HA_3" numeric(16,6) DEFAULT 0 NOT NULL,
    "PRIX_METRIQUE_VT_3" numeric(16,6) DEFAULT 0 NOT NULL,
    "ID_METRIQUE_3" integer DEFAULT 1,
    "PA_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "T_POIDS" real DEFAULT 0,
    "T_PV_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "T_PA_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "T_PV_TTC" numeric(16,2) DEFAULT 0 NOT NULL,
    "SERVICE" boolean DEFAULT false,
    "ID_STYLE" integer DEFAULT 1,
    "T_POIDS_LIVREE" real DEFAULT 0,
    "ID_MODE_VENTE_ARTICLE" integer DEFAULT 1 NOT NULL,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "QTE_ACHAT" integer DEFAULT 1,
    "CODE_DOUANIER" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ID_PAYS" integer DEFAULT 1,
    "ID_DEVISE" integer DEFAULT 1,
    "PV_U_DEVISE" numeric(16,6) DEFAULT 0 NOT NULL,
    "POURCENT_REMISE" numeric(12,8) DEFAULT 0,
    "PV_T_DEVISE" numeric(16,6) DEFAULT 0 NOT NULL,
    "TAUX_DEVISE" numeric(16,8) DEFAULT 1,
    "DESCRIPTIF" character varying(2048) DEFAULT ''::character varying NOT NULL,
    "MARGE_HT" numeric(16,6) DEFAULT 0 NOT NULL,
    "QTE_UNITAIRE" numeric(16,6) DEFAULT 1,
    "ID_UNITE_VENTE" integer DEFAULT 2,
    "ID_ARTICLE" integer DEFAULT 1,
    "POIDS_COLIS_NET" numeric(16,8) DEFAULT 0,
    "T_POIDS_COLIS_NET" numeric(16,8) DEFAULT 0,
    "NB_COLIS" integer DEFAULT 0,
    "MONTANT_REMISE" numeric(16,8),
    "ID_FAMILLE_ARTICLE" integer DEFAULT 1,
    "NIVEAU" integer DEFAULT 1 NOT NULL,
    "ID_ECO_CONTRIBUTION" integer DEFAULT 1,
    "ECO_CONTRIBUTION" numeric(16,2) DEFAULT 0,
    "T_ECO_CONTRIBUTION" numeric(16,2) DEFAULT 0,
    "ID_COMMANDE_CLIENT_ELEMENT" integer DEFAULT 1,
    "ID_DEPOT_STOCK" integer DEFAULT 1,
    "ID_DEVIS_ELEMENT" integer DEFAULT 1,
    "LONGUEUR" numeric(16,8),
    "LARGEUR" numeric(16,8),
    "HAUTEUR" numeric(16,8),
    "TARE" numeric(16,8),
    "T_POIDS_BRUT" numeric(16,8) DEFAULT 0,
    "ID_ARTICLE_DECLINAISON_TAILLE" integer DEFAULT 1,
    "ID_ARTICLE_DECLINAISON_COULEUR" integer DEFAULT 1
);


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

--
-- TOC entry 388 (class 1259 OID 6909558)
-- Name: BON_DE_LIVRAISON_ELEMENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24613 (class 0 OID 0)
-- Dependencies: 388
-- Name: BON_DE_LIVRAISON_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."BON_DE_LIVRAISON_ELEMENT_ID_seq" OWNED BY "Default"."BON_DE_LIVRAISON_ELEMENT"."ID";


--
-- TOC entry 389 (class 1259 OID 6909560)
-- Name: BON_DE_LIVRAISON_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24614 (class 0 OID 0)
-- Dependencies: 389
-- Name: BON_DE_LIVRAISON_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."BON_DE_LIVRAISON_ID_seq" OWNED BY "Default"."BON_DE_LIVRAISON"."ID";


--
-- TOC entry 390 (class 1259 OID 6909562)
-- Name: BON_RECEPTION; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."BON_RECEPTION" (
    "ID" integer NOT NULL,
    "DATE" date,
    "NUMERO" character varying(45) DEFAULT ''::character varying,
    "ID_FOURNISSEUR" integer DEFAULT 1,
    "INFOS" character varying(2048) DEFAULT ''::text,
    "TOTAL_HT" bigint DEFAULT 0,
    "TOTAL_TTC" bigint DEFAULT 0,
    "TOTAL_TVA" bigint DEFAULT 0,
    "TOTAL_POIDS" real DEFAULT 0,
    "NOM" character varying(45) DEFAULT ''::character varying,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID_COMMANDE" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "ID_DEVISE" integer DEFAULT 1,
    "T_DEVISE" bigint DEFAULT 0,
    "CREATE_VIRTUAL_STOCK" boolean DEFAULT true NOT NULL,
    "T_ECO_CONTRIBUTION" bigint DEFAULT 0,
    "ID_TAXE_PORT" integer DEFAULT 1,
    "PORT_HT" bigint DEFAULT 0 NOT NULL,
    "REMISE_HT" bigint DEFAULT 0 NOT NULL,
    "ID_MODELE" integer DEFAULT 1
);


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

--
-- TOC entry 391 (class 1259 OID 6909588)
-- Name: BON_RECEPTION_ELEMENT; Type: TABLE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 392 (class 1259 OID 6909649)
-- Name: BON_RECEPTION_ELEMENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24615 (class 0 OID 0)
-- Dependencies: 392
-- Name: BON_RECEPTION_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."BON_RECEPTION_ELEMENT_ID_seq" OWNED BY "Default"."BON_RECEPTION_ELEMENT"."ID";


--
-- TOC entry 393 (class 1259 OID 6909651)
-- Name: BON_RECEPTION_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24616 (class 0 OID 0)
-- Dependencies: 393
-- Name: BON_RECEPTION_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."BON_RECEPTION_ID_seq" OWNED BY "Default"."BON_RECEPTION"."ID";


--
-- TOC entry 394 (class 1259 OID 6909653)
-- Name: CAISSE; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."CAISSE" (
    "NOM" character varying(2048) DEFAULT ''::text,
    "NUMERO" character varying(2048) DEFAULT ''::text,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "ID" integer NOT NULL,
    "ID_DERNIERE_CLOTURE" integer
);


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

--
-- TOC entry 395 (class 1259 OID 6909663)
-- Name: CAISSE_CLOTURE; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."CAISSE_CLOTURE" (
    "ID" integer NOT NULL,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_ENTREE_JOURNAL" integer,
    "PERIODE" character varying(32) DEFAULT ''::character varying NOT NULL,
    "DEBUT" date NOT NULL,
    "FIN" date NOT NULL,
    "TOTAL_TTC" numeric(16,6) DEFAULT 0 NOT NULL,
    "PREMIER_TICKET" character varying(64) DEFAULT NULL::character varying,
    "PREMIER_TICKET_HASH" character varying(128) DEFAULT NULL::character varying,
    "DERNIER_TICKET" character varying(64) DEFAULT NULL::character varying,
    "DERNIER_TICKET_HASH" character varying(128) DEFAULT NULL::character varying,
    "ARCHIVE" integer DEFAULT 0 NOT NULL
);


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

--
-- TOC entry 396 (class 1259 OID 6909675)
-- Name: CAISSE_CLOTURE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24617 (class 0 OID 0)
-- Dependencies: 396
-- Name: CAISSE_CLOTURE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."CAISSE_CLOTURE_ID_seq" OWNED BY "Default"."CAISSE_CLOTURE"."ID";


--
-- TOC entry 397 (class 1259 OID 6909677)
-- Name: CAISSE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24618 (class 0 OID 0)
-- Dependencies: 397
-- Name: CAISSE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."CAISSE_ID_seq" OWNED BY "Default"."CAISSE"."ID";


--
-- TOC entry 398 (class 1259 OID 6909679)
-- Name: CAISSE_JOURNAL; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."CAISSE_JOURNAL" (
    "ID" integer NOT NULL,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_CAISSE" integer DEFAULT 1,
    "DATE" timestamp without time zone,
    "ID_USER" integer DEFAULT 1,
    "EVT" character varying(128) DEFAULT ''::character varying NOT NULL,
    "CREATOR" character varying(128) DEFAULT ''::character varying NOT NULL,
    "CREATOR_VERSION" character varying(128) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "HOST_NAME" character varying(128),
    "HOST_USER" character varying(128)
);


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

--
-- TOC entry 399 (class 1259 OID 6909693)
-- Name: CAISSE_JOURNAL_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24619 (class 0 OID 0)
-- Dependencies: 399
-- Name: CAISSE_JOURNAL_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."CAISSE_JOURNAL_ID_seq" OWNED BY "Default"."CAISSE_JOURNAL"."ID";


--
-- TOC entry 400 (class 1259 OID 6909695)
-- Name: CALENDAR_ITEM; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."CALENDAR_ITEM" (
    "ID" integer NOT NULL,
    "START" timestamp without time zone,
    "END" timestamp without time zone,
    "DURATION_S" bigint DEFAULT 0 NOT NULL,
    "SUMMARY" character varying(1024) DEFAULT ''::character varying NOT NULL,
    "DESCRIPTION" character varying(8192) DEFAULT ''::character varying NOT NULL,
    "FLAGS" character varying(1024) DEFAULT ''::character varying NOT NULL,
    "STATUS" character varying(128) DEFAULT ''::character varying NOT NULL,
    "ID_CALENDAR_ITEM_GROUP" integer DEFAULT 1,
    "SOURCE_ID" bigint,
    "SOURCE_TABLE" character varying(256) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric,
    "UID" character varying(1024) DEFAULT ''::character varying NOT NULL,
    "LOCATION" character varying(4096) DEFAULT ''::character varying NOT NULL
);


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

--
-- TOC entry 401 (class 1259 OID 6909712)
-- Name: CALENDAR_ITEM_GROUP; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."CALENDAR_ITEM_GROUP" (
    "ID" integer NOT NULL,
    "NAME" character varying(1024) DEFAULT ''::character varying NOT NULL,
    "DESCRIPTION" character varying(8192) DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT NULL::numeric
);


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

--
-- TOC entry 402 (class 1259 OID 6909722)
-- Name: CALENDAR_ITEM_GROUP_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24620 (class 0 OID 0)
-- Dependencies: 402
-- Name: CALENDAR_ITEM_GROUP_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 403 (class 1259 OID 6909724)
-- Name: CALENDAR_ITEM_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24621 (class 0 OID 0)
-- Dependencies: 403
-- Name: CALENDAR_ITEM_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 404 (class 1259 OID 6909726)
-- Name: CATEGORIE_CLIENT; Type: TABLE; Schema: Default; Owner: openconcerto
--

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

--
-- TOC entry 405 (class 1259 OID 6909735)
-- Name: CATEGORIE_CLIENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24622 (class 0 OID 0)
-- Dependencies: 405
-- Name: CATEGORIE_CLIENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 406 (class 1259 OID 6909737)
-- Name: CATEGORIE_COMPTABLE; Type: TABLE; Schema: Default; Owner: openconcerto
--

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

--
-- TOC entry 407 (class 1259 OID 6909746)
-- Name: CATEGORIE_COMPTABLE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24623 (class 0 OID 0)
-- Dependencies: 407
-- Name: CATEGORIE_COMPTABLE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 408 (class 1259 OID 6909748)
-- Name: CHEQUE_AVOIR_CLIENT; Type: TABLE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 409 (class 1259 OID 6909766)
-- Name: CHEQUE_AVOIR_CLIENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24624 (class 0 OID 0)
-- Dependencies: 409
-- Name: CHEQUE_AVOIR_CLIENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 410 (class 1259 OID 6909768)
-- Name: CHEQUE_A_ENCAISSER; Type: TABLE; Schema: Default; Owner: openconcerto
--

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

--
-- TOC entry 411 (class 1259 OID 6909788)
-- Name: CHEQUE_A_ENCAISSER_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24625 (class 0 OID 0)
-- Dependencies: 411
-- Name: CHEQUE_A_ENCAISSER_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 412 (class 1259 OID 6909790)
-- Name: CHEQUE_FOURNISSEUR; Type: TABLE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 413 (class 1259 OID 6909808)
-- Name: CHEQUE_FOURNISSEUR_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24626 (class 0 OID 0)
-- Dependencies: 413
-- Name: CHEQUE_FOURNISSEUR_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 414 (class 1259 OID 6909810)
-- Name: CHIFFRAGE_COMMANDE_CLIENT; Type: TABLE; Schema: Default; Owner: openconcerto
--

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

--
-- TOC entry 415 (class 1259 OID 6909824)
-- Name: CHIFFRAGE_COMMANDE_CLIENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24627 (class 0 OID 0)
-- Dependencies: 415
-- Name: CHIFFRAGE_COMMANDE_CLIENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 416 (class 1259 OID 6909826)
-- Name: CLASSEMENT_CONVENTIONNEL; Type: TABLE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 417 (class 1259 OID 6909837)
-- Name: CLASSEMENT_CONVENTIONNEL_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24628 (class 0 OID 0)
-- Dependencies: 417
-- Name: CLASSEMENT_CONVENTIONNEL_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 418 (class 1259 OID 6909839)
-- Name: CLASSE_COMPTE; Type: TABLE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 419 (class 1259 OID 6909850)
-- Name: CLASSE_COMPTE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24629 (class 0 OID 0)
-- Dependencies: 419
-- Name: CLASSE_COMPTE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 420 (class 1259 OID 6909852)
-- Name: CLIENT; Type: TABLE; Schema: Default; Owner: openconcerto
--

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

--
-- TOC entry 421 (class 1259 OID 6909926)
-- Name: CLIENT_DEPARTEMENT; Type: TABLE; Schema: Default; Owner: openconcerto
--

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

--
-- TOC entry 422 (class 1259 OID 6909938)
-- Name: CLIENT_DEPARTEMENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24630 (class 0 OID 0)
-- Dependencies: 422
-- Name: CLIENT_DEPARTEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 423 (class 1259 OID 6909940)
-- Name: CLIENT_ID_CLIENT_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24631 (class 0 OID 0)
-- Dependencies: 423
-- Name: CLIENT_ID_CLIENT_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "Default"."CLIENT_ID_CLIENT_seq" OWNED BY "Default"."CLIENT"."ID";


--
-- TOC entry 424 (class 1259 OID 6909942)
-- Name: CODE_CARACT_ACTIVITE; Type: TABLE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 425 (class 1259 OID 6909950)
-- Name: CODE_CARACT_ACTIVITE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24632 (class 0 OID 0)
-- Dependencies: 425
-- Name: CODE_CARACT_ACTIVITE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 426 (class 1259 OID 6909952)
-- Name: CODE_CONTRAT_TRAVAIL; Type: TABLE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 427 (class 1259 OID 6909960)
-- Name: CODE_CONTRAT_TRAVAIL_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24633 (class 0 OID 0)
-- Dependencies: 427
-- Name: CODE_CONTRAT_TRAVAIL_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 428 (class 1259 OID 6909962)
-- Name: CODE_DROIT_CONTRAT; Type: TABLE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 429 (class 1259 OID 6909970)
-- Name: CODE_DROIT_CONTRAT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24634 (class 0 OID 0)
-- Dependencies: 429
-- Name: CODE_DROIT_CONTRAT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 430 (class 1259 OID 6909972)
-- Name: CODE_EMPLOI; Type: TABLE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 431 (class 1259 OID 6909980)
-- Name: CODE_EMPLOI_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24635 (class 0 OID 0)
-- Dependencies: 431
-- Name: CODE_EMPLOI_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 432 (class 1259 OID 6909982)
-- Name: CODE_FOURNISSEUR; Type: TABLE; Schema: Default; Owner: openconcerto
--

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

--
-- TOC entry 433 (class 1259 OID 6909990)
-- Name: CODE_FOURNISSEUR_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24636 (class 0 OID 0)
-- Dependencies: 433
-- Name: CODE_FOURNISSEUR_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 434 (class 1259 OID 6909992)
-- Name: CODE_PENIBILITE_CONTRAT_SALARIE; Type: TABLE; Schema: Default; Owner: openconcerto
--

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

--
-- TOC entry 435 (class 1259 OID 6909999)
-- Name: CODE_PENIBILITE_CONTRAT_SALARIE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24637 (class 0 OID 0)
-- Dependencies: 435
-- Name: CODE_PENIBILITE_CONTRAT_SALARIE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 436 (class 1259 OID 6910001)
-- Name: CODE_REGIME; Type: TABLE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 437 (class 1259 OID 6910009)
-- Name: CODE_REGIME_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24638 (class 0 OID 0)
-- Dependencies: 437
-- Name: CODE_REGIME_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 438 (class 1259 OID 6910011)
-- Name: CODE_STATUT_CATEGORIEL; Type: TABLE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 439 (class 1259 OID 6910019)
-- Name: CODE_STATUT_CATEGORIEL_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24639 (class 0 OID 0)
-- Dependencies: 439
-- Name: CODE_STATUT_CATEGORIEL_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 440 (class 1259 OID 6910021)
-- Name: CODE_STATUT_CAT_CONV; Type: TABLE; Schema: Default; Owner: openconcerto
--

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

--
-- TOC entry 441 (class 1259 OID 6910028)
-- Name: CODE_STATUT_CAT_CONV_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24640 (class 0 OID 0)
-- Dependencies: 441
-- Name: CODE_STATUT_CAT_CONV_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 442 (class 1259 OID 6910030)
-- Name: CODE_STATUT_PROF; Type: TABLE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 443 (class 1259 OID 6910038)
-- Name: CODE_STATUT_PROF_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24641 (class 0 OID 0)
-- Dependencies: 443
-- Name: CODE_STATUT_PROF_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 444 (class 1259 OID 6910040)
-- Name: COEFF_PRIME; Type: TABLE; Schema: Default; Owner: openconcerto
--

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

--
-- TOC entry 445 (class 1259 OID 6910049)
-- Name: COEFF_PRIME_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24642 (class 0 OID 0)
-- Dependencies: 445
-- Name: COEFF_PRIME_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 446 (class 1259 OID 6910051)
-- Name: COMMANDE; Type: TABLE; Schema: Default; Owner: openconcerto
--

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

--
-- TOC entry 447 (class 1259 OID 6910083)
-- Name: COMMANDE_CLIENT; Type: TABLE; Schema: Default; Owner: openconcerto
--

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

--
-- TOC entry 448 (class 1259 OID 6910125)
-- Name: COMMANDE_CLIENT_ELEMENT; Type: TABLE; Schema: Default; Owner: openconcerto
--

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

--
-- TOC entry 449 (class 1259 OID 6910189)
-- Name: COMMANDE_CLIENT_ELEMENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24643 (class 0 OID 0)
-- Dependencies: 449
-- Name: COMMANDE_CLIENT_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 450 (class 1259 OID 6910191)
-- Name: COMMANDE_CLIENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24644 (class 0 OID 0)
-- Dependencies: 450
-- Name: COMMANDE_CLIENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 451 (class 1259 OID 6910193)
-- Name: COMMANDE_ELEMENT; Type: TABLE; Schema: Default; Owner: openconcerto
--

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

--
-- TOC entry 452 (class 1259 OID 6910255)
-- Name: COMMANDE_ELEMENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24645 (class 0 OID 0)
-- Dependencies: 452
-- Name: COMMANDE_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 453 (class 1259 OID 6910257)
-- Name: COMMANDE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24646 (class 0 OID 0)
-- Dependencies: 453
-- Name: COMMANDE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 454 (class 1259 OID 6910259)
-- Name: COMMERCIAL; Type: TABLE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 455 (class 1259 OID 6910279)
-- Name: COMMERCIAL_ID_COMMERCIAL_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24647 (class 0 OID 0)
-- Dependencies: 455
-- Name: COMMERCIAL_ID_COMMERCIAL_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 456 (class 1259 OID 6910281)
-- Name: COMPLETION; Type: TABLE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 457 (class 1259 OID 6910286)
-- Name: COMPTE_CLIENT_TRANSACTION; Type: TABLE; Schema: Default; Owner: openconcerto
--

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

--
-- TOC entry 458 (class 1259 OID 6910295)
-- Name: COMPTE_CLIENT_TRANSACTION_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24648 (class 0 OID 0)
-- Dependencies: 458
-- Name: COMPTE_CLIENT_TRANSACTION_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 459 (class 1259 OID 6910297)
-- Name: COMPTE_PCE; Type: TABLE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 460 (class 1259 OID 6910314)
-- Name: COMPTE_PCE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24649 (class 0 OID 0)
-- Dependencies: 460
-- Name: COMPTE_PCE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 461 (class 1259 OID 6910316)
-- Name: COMPTE_PCG; Type: TABLE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 462 (class 1259 OID 6910332)
-- Name: COMPTE_PCG_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24650 (class 0 OID 0)
-- Dependencies: 462
-- Name: COMPTE_PCG_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 463 (class 1259 OID 6910334)
-- Name: CONTACT; Type: TABLE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 464 (class 1259 OID 6910356)
-- Name: CONTACT_ADMINISTRATIF; Type: TABLE; Schema: Default; Owner: openconcerto
--

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

--
-- TOC entry 465 (class 1259 OID 6910375)
-- Name: CONTACT_ADMINISTRATIF_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24651 (class 0 OID 0)
-- Dependencies: 465
-- Name: CONTACT_ADMINISTRATIF_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 466 (class 1259 OID 6910377)
-- Name: CONTACT_FOURNISSEUR; Type: TABLE; Schema: Default; Owner: openconcerto
--

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

--
-- TOC entry 467 (class 1259 OID 6910396)
-- Name: CONTACT_FOURNISSEUR_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24652 (class 0 OID 0)
-- Dependencies: 467
-- Name: CONTACT_FOURNISSEUR_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 468 (class 1259 OID 6910398)
-- Name: CONTACT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24653 (class 0 OID 0)
-- Dependencies: 468
-- Name: CONTACT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 469 (class 1259 OID 6910400)
-- Name: CONTACT_SALARIE; Type: TABLE; Schema: Default; Owner: openconcerto
--

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

--
-- TOC entry 470 (class 1259 OID 6910418)
-- Name: CONTACT_SALARIE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24654 (class 0 OID 0)
-- Dependencies: 470
-- Name: CONTACT_SALARIE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 471 (class 1259 OID 6910420)
-- Name: CONTRAT_PREVOYANCE; Type: TABLE; Schema: Default; Owner: openconcerto
--

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

--
-- TOC entry 472 (class 1259 OID 6910434)
-- Name: CONTRAT_PREVOYANCE_AYANT_DROIT; Type: TABLE; Schema: Default; Owner: openconcerto
--

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

--
-- TOC entry 473 (class 1259 OID 6910441)
-- Name: CONTRAT_PREVOYANCE_AYANT_DROIT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24655 (class 0 OID 0)
-- Dependencies: 473
-- Name: CONTRAT_PREVOYANCE_AYANT_DROIT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 474 (class 1259 OID 6910443)
-- Name: CONTRAT_PREVOYANCE_CONTRAT_SALARIE; Type: TABLE; Schema: Default; Owner: openconcerto
--

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

--
-- TOC entry 475 (class 1259 OID 6910455)
-- Name: CONTRAT_PREVOYANCE_CONTRAT_SALARIE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24656 (class 0 OID 0)
-- Dependencies: 475
-- Name: CONTRAT_PREVOYANCE_CONTRAT_SALARIE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 476 (class 1259 OID 6910457)
-- Name: CONTRAT_PREVOYANCE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24657 (class 0 OID 0)
-- Dependencies: 476
-- Name: CONTRAT_PREVOYANCE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 477 (class 1259 OID 6910459)
-- Name: CONTRAT_PREVOYANCE_RUBRIQUE; Type: TABLE; Schema: Default; Owner: openconcerto
--

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

--
-- TOC entry 478 (class 1259 OID 6910466)
-- Name: CONTRAT_PREVOYANCE_RUBRIQUE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24658 (class 0 OID 0)
-- Dependencies: 478
-- Name: CONTRAT_PREVOYANCE_RUBRIQUE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 479 (class 1259 OID 6910468)
-- Name: CONTRAT_PREVOYANCE_RUBRIQUE_NET; Type: TABLE; Schema: Default; Owner: openconcerto
--

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

--
-- TOC entry 480 (class 1259 OID 6910475)
-- Name: CONTRAT_PREVOYANCE_RUBRIQUE_NET_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24659 (class 0 OID 0)
-- Dependencies: 480
-- Name: CONTRAT_PREVOYANCE_RUBRIQUE_NET_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 481 (class 1259 OID 6910477)
-- Name: CONTRAT_SALARIE; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."CONTRAT_SALARIE" (
    "ID" integer NOT NULL,
    "NATURE" character varying(2048) DEFAULT ''::text,
    "ID_CODE_EMPLOI" integer DEFAULT 1,
    "ID_CODE_CONTRAT_TRAVAIL" integer DEFAULT 1,
    "ID_CODE_DROIT_CONTRAT" integer DEFAULT 1,
    "ID_CODE_CARACT_ACTIVITE" integer DEFAULT 1,
    "ID_CODE_STATUT_PROF" integer DEFAULT 1,
    "ID_CODE_STATUT_CATEGORIEL" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "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 "Default"."CONTRAT_SALARIE" OWNER TO openconcerto;

--
-- TOC entry 482 (class 1259 OID 6910514)
-- Name: CONTRAT_SALARIE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24660 (class 0 OID 0)
-- Dependencies: 482
-- Name: CONTRAT_SALARIE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 483 (class 1259 OID 6910516)
-- Name: COURRIER_CLIENT; Type: TABLE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 484 (class 1259 OID 6910532)
-- Name: COURRIER_CLIENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24661 (class 0 OID 0)
-- Dependencies: 484
-- Name: COURRIER_CLIENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 485 (class 1259 OID 6910534)
-- Name: COUT_REVIENT; Type: TABLE; Schema: Default; Owner: openconcerto
--

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

--
-- TOC entry 486 (class 1259 OID 6910541)
-- Name: COUT_REVIENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24662 (class 0 OID 0)
-- Dependencies: 486
-- Name: COUT_REVIENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 487 (class 1259 OID 6910543)
-- Name: CUMULS_CONGES; Type: TABLE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 488 (class 1259 OID 6910551)
-- Name: CUMULS_CONGES_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24663 (class 0 OID 0)
-- Dependencies: 488
-- Name: CUMULS_CONGES_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 489 (class 1259 OID 6910553)
-- Name: CUMULS_PAYE; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."CUMULS_PAYE" (
    "ID" integer NOT NULL,
    "SAL_BRUT_C" numeric(16,2) DEFAULT 0,
    "COT_PAT_C" numeric(16,2) DEFAULT 0,
    "COT_SAL_C" numeric(16,2) DEFAULT 0,
    "NET_IMP_C" numeric(16,2) DEFAULT 0,
    "NET_A_PAYER_C" numeric(16,2) DEFAULT 0,
    "CSG_C" numeric(16,2) DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "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 "Default"."CUMULS_PAYE" OWNER TO openconcerto;

--
-- TOC entry 490 (class 1259 OID 6910574)
-- Name: CUMULS_PAYE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24664 (class 0 OID 0)
-- Dependencies: 490
-- Name: CUMULS_PAYE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 491 (class 1259 OID 6910576)
-- Name: DECLARATION_DSN; Type: TABLE; Schema: Default; Owner: openconcerto
--

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

--
-- TOC entry 492 (class 1259 OID 6910600)
-- Name: DECLARATION_DSN_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24665 (class 0 OID 0)
-- Dependencies: 492
-- Name: DECLARATION_DSN_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 493 (class 1259 OID 6910602)
-- Name: DEMANDE_ACHAT_ELEMENT; Type: TABLE; Schema: Default; Owner: openconcerto
--

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

--
-- TOC entry 494 (class 1259 OID 6910635)
-- Name: DEMANDE_ACHAT_ELEMENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24666 (class 0 OID 0)
-- Dependencies: 494
-- Name: DEMANDE_ACHAT_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 495 (class 1259 OID 6910637)
-- Name: DEMANDE_PRIX; Type: TABLE; Schema: Default; Owner: openconcerto
--

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

--
-- TOC entry 496 (class 1259 OID 6910653)
-- Name: DEMANDE_PRIX_ELEMENT; Type: TABLE; Schema: Default; Owner: openconcerto
--

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

--
-- TOC entry 497 (class 1259 OID 6910709)
-- Name: DEMANDE_PRIX_ELEMENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24667 (class 0 OID 0)
-- Dependencies: 497
-- Name: DEMANDE_PRIX_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 498 (class 1259 OID 6910711)
-- Name: DEMANDE_PRIX_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24668 (class 0 OID 0)
-- Dependencies: 498
-- Name: DEMANDE_PRIX_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 499 (class 1259 OID 6910713)
-- Name: DEPARTEMENT; Type: TABLE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 500 (class 1259 OID 6910723)
-- Name: DEPARTEMENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24669 (class 0 OID 0)
-- Dependencies: 500
-- Name: DEPARTEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 501 (class 1259 OID 6910725)
-- Name: DEPOT_CHEQUE; Type: TABLE; Schema: Default; Owner: openconcerto
--

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

--
-- TOC entry 502 (class 1259 OID 6910737)
-- Name: DEPOT_CHEQUE_ELEMENT; Type: TABLE; Schema: Default; Owner: openconcerto
--

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

--
-- TOC entry 503 (class 1259 OID 6910753)
-- Name: DEPOT_CHEQUE_ELEMENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24670 (class 0 OID 0)
-- Dependencies: 503
-- Name: DEPOT_CHEQUE_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 504 (class 1259 OID 6910755)
-- Name: DEPOT_CHEQUE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24671 (class 0 OID 0)
-- Dependencies: 504
-- Name: DEPOT_CHEQUE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 505 (class 1259 OID 6910757)
-- Name: DEPOT_STOCK; Type: TABLE; Schema: Default; Owner: openconcerto
--

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

--
-- TOC entry 506 (class 1259 OID 6910768)
-- Name: DEPOT_STOCK_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24672 (class 0 OID 0)
-- Dependencies: 506
-- Name: DEPOT_STOCK_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 507 (class 1259 OID 6910770)
-- Name: DEVIS; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."DEVIS" (
    "ID_DEVIS" integer NOT NULL,
    "NUMERO" character varying(2048) DEFAULT ''::text,
    "DATE" date,
    "OBJET" character varying(100) DEFAULT ''::character varying,
    "ID_COMMERCIAL" integer DEFAULT 1,
    "ID_CLIENT" integer DEFAULT 1,
    "T_HT" bigint DEFAULT 0,
    "T_TVA" bigint DEFAULT 0,
    "T_TTC" bigint DEFAULT 0,
    "PORT_HT" bigint DEFAULT 0,
    "REMISE_HT" bigint DEFAULT 0,
    "T_SERVICE" bigint DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "INFOS" character varying(2048) DEFAULT ''::text,
    "ID_ETAT_DEVIS" integer DEFAULT 1,
    "DATE_ENVOI" timestamp without time zone,
    "T_POIDS" real DEFAULT 0,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "ID_ADRESSE" 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 "Default"."DEVIS" OWNER TO openconcerto;

--
-- TOC entry 508 (class 1259 OID 6910807)
-- Name: DEVISE_HISTORIQUE; Type: TABLE; Schema: Default; Owner: openconcerto
--

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

--
-- TOC entry 509 (class 1259 OID 6910816)
-- Name: DEVISE_HISTORIQUE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24673 (class 0 OID 0)
-- Dependencies: 509
-- Name: DEVISE_HISTORIQUE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 510 (class 1259 OID 6910818)
-- Name: DEVIS_ELEMENT; Type: TABLE; Schema: Default; Owner: openconcerto
--

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

--
-- TOC entry 511 (class 1259 OID 6910882)
-- Name: DEVIS_ELEMENT_ID_DEVIS_ELEMENT_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24674 (class 0 OID 0)
-- Dependencies: 511
-- Name: DEVIS_ELEMENT_ID_DEVIS_ELEMENT_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 512 (class 1259 OID 6910884)
-- Name: DEVIS_ID_DEVIS_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24675 (class 0 OID 0)
-- Dependencies: 512
-- Name: DEVIS_ID_DEVIS_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 513 (class 1259 OID 6910886)
-- Name: ECHANTILLON_ELEMENT; Type: TABLE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 514 (class 1259 OID 6910900)
-- Name: ECHANTILLON_ELEMENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24676 (class 0 OID 0)
-- Dependencies: 514
-- Name: ECHANTILLON_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 515 (class 1259 OID 6910902)
-- Name: ECHEANCE_CLIENT; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."ECHEANCE_CLIENT" (
    "ID" integer NOT NULL,
    "MONTANT" bigint DEFAULT 0,
    "DATE" date,
    "NOMBRE_RELANCE" integer DEFAULT 0,
    "ID_MOUVEMENT" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID_CLIENT" integer DEFAULT 1,
    "REGLE" boolean DEFAULT false,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "INFOS" character varying(2048) DEFAULT ''::text,
    "RETOUR_NATEXIS" boolean DEFAULT false,
    "REG_COMPTA" boolean DEFAULT false,
    "DATE_LAST_RELANCE" date,
    "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 "Default"."ECHEANCE_CLIENT" OWNER TO openconcerto;

--
-- TOC entry 516 (class 1259 OID 6910928)
-- Name: ECHEANCE_CLIENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24677 (class 0 OID 0)
-- Dependencies: 516
-- Name: ECHEANCE_CLIENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 517 (class 1259 OID 6910930)
-- Name: ECHEANCE_FOURNISSEUR; Type: TABLE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 518 (class 1259 OID 6910942)
-- Name: ECHEANCE_FOURNISSEUR_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24678 (class 0 OID 0)
-- Dependencies: 518
-- Name: ECHEANCE_FOURNISSEUR_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 519 (class 1259 OID 6910944)
-- Name: ECRITURE; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."ECRITURE" (
    "ID" integer NOT NULL,
    "NOM" character varying(2048) DEFAULT ''::text,
    "ID_MOUVEMENT" integer DEFAULT 1,
    "ID_COMPTE_PCE" integer DEFAULT 1,
    "DATE" date,
    "DEBIT" bigint DEFAULT 0,
    "CREDIT" bigint DEFAULT 0,
    "ID_JOURNAL" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "VALIDE" boolean DEFAULT false,
    "ORDRE" numeric(16,8),
    "POINTEE" character varying(45) DEFAULT ''::character varying,
    "DATE_POINTEE" date,
    "DATE_VALIDE" date,
    "IDUSER_CREATE" integer DEFAULT 1,
    "IDUSER_VALIDE" integer DEFAULT 1,
    "IDUSER_DELETE" integer DEFAULT 1,
    "LETTRAGE" character varying(256) DEFAULT ''::character varying,
    "DATE_LETTRAGE" date,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "JOURNAL_NOM" character varying(2048) DEFAULT ''::text,
    "JOURNAL_CODE" character varying(2048) DEFAULT ''::text,
    "COMPTE_NOM" character varying(2048) DEFAULT ''::text,
    "COMPTE_NUMERO" character varying(2048) DEFAULT ''::text,
    "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 "Default"."ECRITURE" OWNER TO openconcerto;

--
-- TOC entry 520 (class 1259 OID 6910974)
-- Name: ECRITURE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24679 (class 0 OID 0)
-- Dependencies: 520
-- Name: ECRITURE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 521 (class 1259 OID 6910976)
-- Name: EMPLOYEUR_MULTIPLE; Type: TABLE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 522 (class 1259 OID 6910983)
-- Name: EMPLOYEUR_MULTIPLE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24680 (class 0 OID 0)
-- Dependencies: 522
-- Name: EMPLOYEUR_MULTIPLE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 523 (class 1259 OID 6910985)
-- Name: ENCAISSER_MONTANT; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."ENCAISSER_MONTANT" (
    "ID" integer NOT NULL,
    "DATE" date,
    "MONTANT" bigint DEFAULT 0,
    "ID_ECHEANCE_CLIENT" integer DEFAULT 1,
    "ID_MODE_REGLEMENT" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "NOM" character varying(200),
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "ID_CLIENT" integer DEFAULT 1,
    "ID_MOUVEMENT" integer DEFAULT 1,
    "ID_TICKET_CAISSE" integer DEFAULT 1,
    "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 "Default"."ENCAISSER_MONTANT" OWNER TO openconcerto;

--
-- TOC entry 524 (class 1259 OID 6911002)
-- Name: ENCAISSER_MONTANT_ELEMENT; Type: TABLE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 525 (class 1259 OID 6911012)
-- Name: ENCAISSER_MONTANT_ELEMENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24681 (class 0 OID 0)
-- Dependencies: 525
-- Name: ENCAISSER_MONTANT_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 526 (class 1259 OID 6911014)
-- Name: ENCAISSER_MONTANT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24682 (class 0 OID 0)
-- Dependencies: 526
-- Name: ENCAISSER_MONTANT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 527 (class 1259 OID 6911016)
-- Name: ETAT_CIVIL; Type: TABLE; Schema: Default; Owner: openconcerto
--

CREATE TABLE "Default"."ETAT_CIVIL" (
    "ID" integer NOT NULL,
    "ID_ADRESSE" integer DEFAULT 1,
    "DATE_NAISSANCE" date,
    "NUMERO_SS" character varying(45) DEFAULT ''::character varying,
    "NB_ENFANTS" integer DEFAULT 0,
    "COMMUNE_NAISSANCE" character varying(45) DEFAULT ''::character varying,
    "ID_DEPARTEMENT_NAISSANCE" integer DEFAULT 1,
    "ID_PAYS_NAISSANCE" integer DEFAULT 1,
    "TELEPHONE" character varying(45) DEFAULT ''::character varying,
    "MAIL" character varying(45) DEFAULT ''::character varying,
    "PORTABLE" character varying(45) DEFAULT ''::character varying,
    "NB_PERS_A_CHARGE" integer DEFAULT 0,
    "ID_SITUATION_FAMILIALE" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "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 "Default"."ETAT_CIVIL" OWNER TO openconcerto;

--
-- TOC entry 528 (class 1259 OID 6911046)
-- Name: ETAT_CIVIL_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24683 (class 0 OID 0)
-- Dependencies: 528
-- Name: ETAT_CIVIL_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 529 (class 1259 OID 6911048)
-- Name: ETAT_DEMANDE_ACHAT_ELEMENT; Type: TABLE; Schema: Default; Owner: openconcerto
--

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

--
-- TOC entry 530 (class 1259 OID 6911053)
-- Name: ETAT_DEMANDE_ACHAT_ELEMENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24684 (class 0 OID 0)
-- Dependencies: 530
-- Name: ETAT_DEMANDE_ACHAT_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 531 (class 1259 OID 6911055)
-- Name: ETAT_DEMANDE_PRIX; Type: TABLE; Schema: Default; Owner: openconcerto
--

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

--
-- TOC entry 532 (class 1259 OID 6911060)
-- Name: ETAT_DEMANDE_PRIX_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24685 (class 0 OID 0)
-- Dependencies: 532
-- Name: ETAT_DEMANDE_PRIX_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 533 (class 1259 OID 6911062)
-- Name: ETAT_DEVIS; Type: TABLE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 534 (class 1259 OID 6911070)
-- Name: ETAT_DEVIS_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


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

--
-- TOC entry 24686 (class 0 OID 0)
-- Dependencies: 534
-- Name: ETAT_DEVIS_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

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


--
-- TOC entry 535 (class 1259 OID 6911072)
