Backlog Courrier

--

-- PostgreSQL database dump

--

-- Dumped from database version 11.7 (Ubuntu 11.7-0ubuntu0.19.10.1)

-- Dumped by pg_dump version 11.7 (Ubuntu 11.7-0ubuntu0.19.10.1)

SET statement_timeout = 0;

SET lock_timeout = 0;

SET idle_in_transaction_session_timeout = 0;

SET client_encoding = 'UTF8';

SET standard_conforming_strings = on;

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

SET check_function_bodies = false;

SET xmloption = content;

SET client_min_messages = warning;

SET row_security = off;

--

-- Name: maarch; Type: SCHEMA; Schema: -; Owner: postgres

--

CREATE SCHEMA maarch;

ALTER SCHEMA maarch OWNER TO postgres;

--

-- Name: SCHEMA maarch; Type: COMMENT; Schema: -; Owner: postgres

--

COMMENT ON SCHEMA maarch IS 'standard public schema';

--

-- Name: order_alphanum(text); Type: FUNCTION; Schema: maarch; Owner: postgres

--

CREATE FUNCTION maarch.order_alphanum(text) RETURNS text

    LANGUAGE sql

    AS $_$

  SELECT regexp_replace(regexp_replace(regexp_replace(regexp_replace($1,

    E'(^|\\D)(\\d{1,3}($|\\D))', E'\\1000\\2', 'g'),

      E'(^|\\D)(\\d{4,6}($|\\D))', E'\\1000\\2', 'g'),

        E'(^|\\D)(\\d{7}($|\\D))', E'\\100\\2', 'g'),

          E'(^|\\D)(\\d{8}($|\\D))', E'\\10\\2', 'g');

$_$;

ALTER FUNCTION maarch.order_alphanum(text) OWNER TO postgres;

SET default_tablespace = '';

SET default_with_oids = false;

--

-- Name: acknowledgement_receipts; Type: TABLE; Schema: maarch; Owner: postgres

--

CREATE TABLE maarch.acknowledgement_receipts (

    id integer NOT NULL,

    res_id integer NOT NULL,

    type character varying(16) NOT NULL,

    format character varying(8) NOT NULL,

    user_id integer NOT NULL,

    contact_address_id integer NOT NULL,

    creation_date timestamp without time zone NOT NULL,

    send_date timestamp without time zone,

    docserver_id character varying(128) NOT NULL,

    path character varying(256) NOT NULL,

    filename character varying(256) NOT NULL,

    fingerprint character varying(256) NOT NULL

);

ALTER TABLE maarch.acknowledgement_receipts OWNER TO postgres;

--

-- Name: acknowledgement_receipts_id_seq; Type: SEQUENCE; Schema: maarch; Owner: postgres

--

CREATE SEQUENCE maarch.acknowledgement_receipts_id_seq

    AS integer

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

ALTER TABLE maarch.acknowledgement_receipts_id_seq OWNER TO postgres;

--

-- Name: acknowledgement_receipts_id_seq; Type: SEQUENCE OWNED BY; Schema: maarch; Owner: postgres

--

ALTER SEQUENCE maarch.acknowledgement_receipts_id_seq OWNED BY maarch.acknowledgement_receipts.id;

--

-- Name: actions; Type: TABLE; Schema: maarch; Owner: postgres

--

CREATE TABLE maarch.actions (

    id integer NOT NULL,

    keyword character varying(32) DEFAULT ''::bpchar NOT NULL,

    label_action character varying(255),

    id_status character varying(10),

    is_system character(1) DEFAULT 'N'::bpchar NOT NULL,

    enabled character(1) DEFAULT 'Y'::bpchar NOT NULL,

    action_page character varying(255),

    component character varying(128),

    history character(1) DEFAULT 'N'::bpchar NOT NULL,

    origin character varying(255) DEFAULT 'apps'::bpchar NOT NULL,

    create_id character(1) DEFAULT 'N'::bpchar NOT NULL,

    category_id character varying(255)

);

ALTER TABLE maarch.actions OWNER TO postgres;

--

-- Name: actions_categories; Type: TABLE; Schema: maarch; Owner: postgres

--

CREATE TABLE maarch.actions_categories (

    action_id bigint NOT NULL,

    category_id character varying(255) NOT NULL

);

ALTER TABLE maarch.actions_categories OWNER TO postgres;

--

-- Name: actions_groupbaskets; Type: TABLE; Schema: maarch; Owner: postgres

--

CREATE TABLE maarch.actions_groupbaskets (

    id_action bigint NOT NULL,

    where_clause text,

    group_id character varying(32) NOT NULL,

    basket_id character varying(32) NOT NULL,

    used_in_basketlist character(1) DEFAULT 'Y'::bpchar NOT NULL,

    used_in_action_page character(1) DEFAULT 'Y'::bpchar NOT NULL,

    default_action_list character(1) DEFAULT 'N'::bpchar NOT NULL

);

ALTER TABLE maarch.actions_groupbaskets OWNER TO postgres;

--

-- Name: actions_id_seq; Type: SEQUENCE; Schema: maarch; Owner: postgres

--

CREATE SEQUENCE maarch.actions_id_seq

    AS integer

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

ALTER TABLE maarch.actions_id_seq OWNER TO postgres;

--

-- Name: actions_id_seq; Type: SEQUENCE OWNED BY; Schema: maarch; Owner: postgres

--

ALTER SEQUENCE maarch.actions_id_seq OWNED BY maarch.actions.id;

--

-- Name: adr_attachments; Type: TABLE; Schema: maarch; Owner: postgres

--

CREATE TABLE maarch.adr_attachments (

    id integer NOT NULL,

    res_id bigint NOT NULL,

    type character varying(32) NOT NULL,

    docserver_id character varying(32) NOT NULL,

    path character varying(255) NOT NULL,

    filename character varying(255) NOT NULL,

    fingerprint character varying(255) DEFAULT NULL::character varying

);

ALTER TABLE maarch.adr_attachments OWNER TO postgres;

--

-- Name: adr_attachments_id_seq; Type: SEQUENCE; Schema: maarch; Owner: postgres

--

CREATE SEQUENCE maarch.adr_attachments_id_seq

    AS integer

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

ALTER TABLE maarch.adr_attachments_id_seq OWNER TO postgres;

--

-- Name: adr_attachments_id_seq; Type: SEQUENCE OWNED BY; Schema: maarch; Owner: postgres

--

ALTER SEQUENCE maarch.adr_attachments_id_seq OWNED BY maarch.adr_attachments.id;

--

-- Name: adr_attachments_version; Type: TABLE; Schema: maarch; Owner: postgres

--

CREATE TABLE maarch.adr_attachments_version (

    id integer NOT NULL,

    res_id bigint NOT NULL,

    type character varying(32) NOT NULL,

    docserver_id character varying(32) NOT NULL,

    path character varying(255) NOT NULL,

    filename character varying(255) NOT NULL,

    fingerprint character varying(255) DEFAULT NULL::character varying

);

ALTER TABLE maarch.adr_attachments_version OWNER TO postgres;

--

-- Name: adr_attachments_version_id_seq; Type: SEQUENCE; Schema: maarch; Owner: postgres

--

CREATE SEQUENCE maarch.adr_attachments_version_id_seq

    AS integer

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

ALTER TABLE maarch.adr_attachments_version_id_seq OWNER TO postgres;

--

-- Name: adr_attachments_version_id_seq; Type: SEQUENCE OWNED BY; Schema: maarch; Owner: postgres

--

ALTER SEQUENCE maarch.adr_attachments_version_id_seq OWNED BY maarch.adr_attachments_version.id;

--

-- Name: adr_letterbox; Type: TABLE; Schema: maarch; Owner: postgres

--

CREATE TABLE maarch.adr_letterbox (

    id integer NOT NULL,

    res_id bigint NOT NULL,

    type character varying(32) NOT NULL,

    docserver_id character varying(32) NOT NULL,

    path character varying(255) NOT NULL,

    filename character varying(255) NOT NULL,

    fingerprint character varying(255) DEFAULT NULL::character varying

);

ALTER TABLE maarch.adr_letterbox OWNER TO postgres;

--

-- Name: adr_letterbox_id_seq; Type: SEQUENCE; Schema: maarch; Owner: postgres

--

CREATE SEQUENCE maarch.adr_letterbox_id_seq

    AS integer

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

ALTER TABLE maarch.adr_letterbox_id_seq OWNER TO postgres;

--

-- Name: adr_letterbox_id_seq; Type: SEQUENCE OWNED BY; Schema: maarch; Owner: postgres

--

ALTER SEQUENCE maarch.adr_letterbox_id_seq OWNED BY maarch.adr_letterbox.id;

--

-- Name: basket_persistent_mode; Type: TABLE; Schema: maarch; Owner: postgres

--

CREATE TABLE maarch.basket_persistent_mode (

    res_id bigint,

    user_id character varying(128),

    is_persistent character varying(1)

);

ALTER TABLE maarch.basket_persistent_mode OWNER TO postgres;

--

-- Name: baskets; Type: TABLE; Schema: maarch; Owner: postgres

--

CREATE TABLE maarch.baskets (

    id integer NOT NULL,

    coll_id character varying(32) NOT NULL,

    basket_id character varying(32) NOT NULL,

    basket_name character varying(255) NOT NULL,

    basket_desc character varying(255) NOT NULL,

    basket_clause text NOT NULL,

    is_visible character(1) DEFAULT 'Y'::bpchar NOT NULL,

    enabled character(1) DEFAULT 'Y'::bpchar NOT NULL,

    basket_order integer,

    color character varying(16),

    basket_res_order character varying(255) DEFAULT 'res_id desc'::character varying NOT NULL,

    flag_notif character varying(1)

);

ALTER TABLE maarch.baskets OWNER TO postgres;

--

-- Name: baskets_id_seq; Type: SEQUENCE; Schema: maarch; Owner: postgres

--

CREATE SEQUENCE maarch.baskets_id_seq

    AS integer

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

ALTER TABLE maarch.baskets_id_seq OWNER TO postgres;

--

-- Name: baskets_id_seq; Type: SEQUENCE OWNED BY; Schema: maarch; Owner: postgres

--

ALTER SEQUENCE maarch.baskets_id_seq OWNED BY maarch.baskets.id;

--

-- Name: case_id_seq; Type: SEQUENCE; Schema: maarch; Owner: postgres

--

CREATE SEQUENCE maarch.case_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

ALTER TABLE maarch.case_id_seq OWNER TO postgres;

--

-- Name: cases; Type: TABLE; Schema: maarch; Owner: postgres

--

CREATE TABLE maarch.cases (

    case_id integer DEFAULT nextval('maarch.case_id_seq'::regclass) NOT NULL,

    case_label character varying(255) DEFAULT ''::bpchar NOT NULL,

    case_description character varying(255),

    case_type character varying(32),

    case_closing_date timestamp without time zone,

    case_last_update_date timestamp without time zone NOT NULL,

    case_creation_date timestamp without time zone NOT NULL,

    case_typist character varying(128) DEFAULT ''::bpchar NOT NULL,

    case_parent integer,

    case_custom_t1 character varying(255),

    case_custom_t2 character varying(255),

    case_custom_t3 character varying(255),

    case_custom_t4 character varying(255)

);

ALTER TABLE maarch.cases OWNER TO postgres;

--

-- Name: cases_res; Type: TABLE; Schema: maarch; Owner: postgres

--

CREATE TABLE maarch.cases_res (

    case_id integer NOT NULL,

    res_id integer NOT NULL

);

ALTER TABLE maarch.cases_res OWNER TO postgres;

--

-- Name: configurations; Type: TABLE; Schema: maarch; Owner: postgres

--

CREATE TABLE maarch.configurations (

    id integer NOT NULL,

    service character varying(64) NOT NULL,

    value json DEFAULT '{}'::json NOT NULL

);

ALTER TABLE maarch.configurations OWNER TO postgres;

--

-- Name: configurations_id_seq; Type: SEQUENCE; Schema: maarch; Owner: postgres

--

CREATE SEQUENCE maarch.configurations_id_seq

    AS integer

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

ALTER TABLE maarch.configurations_id_seq OWNER TO postgres;

--

-- Name: configurations_id_seq; Type: SEQUENCE OWNED BY; Schema: maarch; Owner: postgres

--

ALTER SEQUENCE maarch.configurations_id_seq OWNED BY maarch.configurations.id;

--

-- Name: contact_addresses_id_seq; Type: SEQUENCE; Schema: maarch; Owner: postgres

--

CREATE SEQUENCE maarch.contact_addresses_id_seq

    START WITH 100

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

ALTER TABLE maarch.contact_addresses_id_seq OWNER TO postgres;

--

-- Name: contact_addresses; Type: TABLE; Schema: maarch; Owner: postgres

--

CREATE TABLE maarch.contact_addresses (

    id bigint DEFAULT nextval('maarch.contact_addresses_id_seq'::regclass) NOT NULL,

    contact_id bigint NOT NULL,

    contact_purpose_id bigint DEFAULT 1,

    departement character varying(255),

    firstname character varying(255),

    lastname character varying(255),

    title character varying(255),

    function character varying(255),

    occupancy character varying(1024),

    address_num character varying(32),

    address_street character varying(255),

    address_complement character varying(255),

    address_town character varying(255),

    address_postal_code character varying(255),

    address_country character varying(255),

    phone character varying(20),

    email character varying(255),

    website character varying(255),

    salutation_header character varying(255),

    salutation_footer character varying(255),

    other_data character varying(255),

    user_id character varying(255) NOT NULL,

    entity_id character varying(32) NOT NULL,

    is_private character(1) DEFAULT 'N'::bpchar NOT NULL,

    enabled character varying(1) DEFAULT 'Y'::bpchar NOT NULL,

    external_id jsonb DEFAULT '{}'::jsonb,

    ban_id character varying(128)

);

ALTER TABLE maarch.contact_addresses OWNER TO postgres;

--

-- Name: contact_communication_id_seq; Type: SEQUENCE; Schema: maarch; Owner: postgres

--

CREATE SEQUENCE maarch.contact_communication_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

ALTER TABLE maarch.contact_communication_id_seq OWNER TO postgres;

--

-- Name: contact_communication; Type: TABLE; Schema: maarch; Owner: postgres

--

CREATE TABLE maarch.contact_communication (

    id bigint DEFAULT nextval('maarch.contact_communication_id_seq'::regclass) NOT NULL,

    contact_id bigint NOT NULL,

    type character varying(255) NOT NULL,

    value character varying(255) NOT NULL

);

ALTER TABLE maarch.contact_communication OWNER TO postgres;

--

-- Name: contact_id_seq; Type: SEQUENCE; Schema: maarch; Owner: postgres

--

CREATE SEQUENCE maarch.contact_id_seq

    START WITH 200

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

ALTER TABLE maarch.contact_id_seq OWNER TO postgres;

--

-- Name: contact_purposes_id_seq; Type: SEQUENCE; Schema: maarch; Owner: postgres

--

CREATE SEQUENCE maarch.contact_purposes_id_seq

    START WITH 100

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

ALTER TABLE maarch.contact_purposes_id_seq OWNER TO postgres;

--

-- Name: contact_purposes; Type: TABLE; Schema: maarch; Owner: postgres

--

CREATE TABLE maarch.contact_purposes (

    id bigint DEFAULT nextval('maarch.contact_purposes_id_seq'::regclass) NOT NULL,

    label character varying(255) NOT NULL

);

ALTER TABLE maarch.contact_purposes OWNER TO postgres;

--

-- Name: contact_types_id_seq; Type: SEQUENCE; Schema: maarch; Owner: postgres

--

CREATE SEQUENCE maarch.contact_types_id_seq

    START WITH 200

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

ALTER TABLE maarch.contact_types_id_seq OWNER TO postgres;

--

-- Name: contact_types; Type: TABLE; Schema: maarch; Owner: postgres

--

CREATE TABLE maarch.contact_types (

    id bigint DEFAULT nextval('maarch.contact_types_id_seq'::regclass) NOT NULL,

    label character varying(255) NOT NULL,

    can_add_contact character varying(1) DEFAULT 'Y'::character varying NOT NULL,

    contact_target character varying(50)

);

ALTER TABLE maarch.contact_types OWNER TO postgres;

--

-- Name: contact_v2_id_seq; Type: SEQUENCE; Schema: maarch; Owner: postgres

--

CREATE SEQUENCE maarch.contact_v2_id_seq

    START WITH 100

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

ALTER TABLE maarch.contact_v2_id_seq OWNER TO postgres;

--

-- Name: contacts; Type: TABLE; Schema: maarch; Owner: postgres

--

CREATE TABLE maarch.contacts (

    contact_id bigint DEFAULT nextval('maarch.contact_id_seq'::regclass) NOT NULL,

    lastname character varying(255),

    firstname character varying(255),

    society character varying(255),

    function character varying(255),

    address_num character varying(32),

    address_street character varying(255),

    address_complement character varying(255),

    address_town character varying(255),

    address_postal_code character varying(255),

    address_country character varying(255),

    email character varying(255),

    phone character varying(20),

    other_data text,

    is_corporate_person character(1) DEFAULT 'Y'::bpchar NOT NULL,

    user_id character varying(128),

    title character varying(255),

    business_id character varying(255),

    ref_identifier character varying(255),

    acc_number character varying(50),

    entity_id character varying(32),

    contact_type character varying(255) DEFAULT 'letter'::character varying NOT NULL,

    enabled character(1) DEFAULT 'Y'::bpchar NOT NULL,

    is_private character varying(1) DEFAULT 'N'::character varying NOT NULL

);

ALTER TABLE maarch.contacts OWNER TO postgres;

--

-- Name: contacts_filling; Type: TABLE; Schema: maarch; Owner: postgres

--

CREATE TABLE maarch.contacts_filling (

    id integer NOT NULL,

    enable boolean NOT NULL,

    rating_columns text NOT NULL,

    first_threshold integer NOT NULL,

    second_threshold integer NOT NULL

);

ALTER TABLE maarch.contacts_filling OWNER TO postgres;

--

-- Name: contacts_filling_id_seq; Type: SEQUENCE; Schema: maarch; Owner: postgres

--

CREATE SEQUENCE maarch.contacts_filling_id_seq

    AS integer

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

ALTER TABLE maarch.contacts_filling_id_seq OWNER TO postgres;

--

-- Name: contacts_filling_id_seq; Type: SEQUENCE OWNED BY; Schema: maarch; Owner: postgres

--

ALTER SEQUENCE maarch.contacts_filling_id_seq OWNED BY maarch.contacts_filling.id;

--

-- Name: contacts_groups; Type: TABLE; Schema: maarch; Owner: postgres

--

CREATE TABLE maarch.contacts_groups (

    id integer NOT NULL,

    label character varying(32) NOT NULL,

    description character varying(255) NOT NULL,

    public boolean NOT NULL,

    owner integer NOT NULL,

    entity_owner character varying(32) NOT NULL

);

ALTER TABLE maarch.contacts_groups OWNER TO postgres;

--

-- Name: contacts_groups_id_seq; Type: SEQUENCE; Schema: maarch; Owner: postgres

--

CREATE SEQUENCE maarch.contacts_groups_id_seq

    AS integer

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

ALTER TABLE maarch.contacts_groups_id_seq OWNER TO postgres;

--

-- Name: contacts_groups_id_seq; Type: SEQUENCE OWNED BY; Schema: maarch; Owner: postgres

--

ALTER SEQUENCE maarch.contacts_groups_id_seq OWNED BY maarch.contacts_groups.id;

--

-- Name: contacts_groups_lists; Type: TABLE; Schema: maarch; Owner: postgres

--

CREATE TABLE maarch.contacts_groups_lists (

    id integer NOT NULL,

    contacts_groups_id integer NOT NULL,

    contact_addresses_id integer NOT NULL

);

ALTER TABLE maarch.contacts_groups_lists OWNER TO postgres;

--

-- Name: contacts_groups_lists_id_seq; Type: SEQUENCE; Schema: maarch; Owner: postgres

--

CREATE SEQUENCE maarch.contacts_groups_lists_id_seq

    AS integer

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

ALTER TABLE maarch.contacts_groups_lists_id_seq OWNER TO postgres;

--

-- Name: contacts_groups_lists_id_seq; Type: SEQUENCE OWNED BY; Schema: maarch; Owner: postgres

--

ALTER SEQUENCE maarch.contacts_groups_lists_id_seq OWNED BY maarch.contacts_groups_lists.id;

--

-- Name: contacts_res; Type: TABLE; Schema: maarch; Owner: postgres

--

CREATE TABLE maarch.contacts_res (

    coll_id character varying(32) NOT NULL,

    res_id bigint NOT NULL,

    contact_id character varying(128) NOT NULL,

    address_id bigint NOT NULL,

    mode character varying DEFAULT 'multi'::character varying NOT NULL

);

ALTER TABLE maarch.contacts_res OWNER TO postgres;

--

-- Name: contacts_v2; Type: TABLE; Schema: maarch; Owner: postgres

--

CREATE TABLE maarch.contacts_v2 (

    contact_id bigint DEFAULT nextval('maarch.contact_v2_id_seq'::regclass) NOT NULL,

    contact_type bigint NOT NULL,

    is_corporate_person character(1) DEFAULT 'Y'::bpchar,

    is_external_contact character(1) DEFAULT 'N'::bpchar,

    society character varying(255),

    society_short character varying(32),

    firstname character varying(255),

    lastname character varying(255),

    title character varying(255),

    function character varying(255),

    other_data text,

    user_id character varying(255) NOT NULL,

    entity_id character varying(32) NOT NULL,

    creation_date timestamp without time zone NOT NULL,

    update_date timestamp without time zone,

    enabled character varying(1) DEFAULT 'Y'::bpchar NOT NULL

);

ALTER TABLE maarch.contacts_v2 OWNER TO postgres;

--

-- Name: convert_stack; Type: TABLE; Schema: maarch; Owner: postgres

--

CREATE TABLE maarch.convert_stack (

    coll_id character varying(32) NOT NULL,

    res_id bigint NOT NULL,

    convert_format character varying(32) DEFAULT 'pdf'::character varying NOT NULL,

    cnt_retry integer,

    status character(1) NOT NULL,

    work_batch bigint,

    regex character varying(32)

);

ALTER TABLE maarch.convert_stack OWNER TO postgres;

--

-- Name: difflist_types; Type: TABLE; Schema: maarch; Owner: postgres

--

CREATE TABLE maarch.difflist_types (

    difflist_type_id character varying(50) NOT NULL,

    difflist_type_label character varying(100) NOT NULL,

    difflist_type_roles text,

    allow_entities character varying(1) DEFAULT 'N'::bpchar NOT NULL,

    is_system character varying(1) DEFAULT 'N'::bpchar NOT NULL

);

ALTER TABLE maarch.difflist_types OWNER TO postgres;

--

-- Name: docserver_types; Type: TABLE; Schema: maarch; Owner: postgres

--

CREATE TABLE maarch.docserver_types (

    docserver_type_id character varying(32) NOT NULL,

    docserver_type_label character varying(255) DEFAULT NULL::character varying,

    enabled character(1) DEFAULT 'Y'::bpchar NOT NULL,

    fingerprint_mode character varying(32) DEFAULT NULL::character varying

);

ALTER TABLE maarch.docserver_types OWNER TO postgres;

--

-- Name: docservers; Type: TABLE; Schema: maarch; Owner: postgres

--

CREATE TABLE maarch.docservers (

    id integer NOT NULL,

    docserver_id character varying(32) DEFAULT '1'::character varying NOT NULL,

    docserver_type_id character varying(32) NOT NULL,

    device_label character varying(255) DEFAULT NULL::character varying,

    is_readonly character(1) DEFAULT 'N'::bpchar NOT NULL,

    size_limit_number bigint DEFAULT (0)::bigint NOT NULL,

    actual_size_number bigint DEFAULT (0)::bigint NOT NULL,

    path_template character varying(255) NOT NULL,

    creation_date timestamp without time zone NOT NULL,

    coll_id character varying(32) DEFAULT 'coll_1'::character varying NOT NULL

);

ALTER TABLE maarch.docservers OWNER TO postgres;

--

-- Name: docservers_id_seq; Type: SEQUENCE; Schema: maarch; Owner: postgres

--

CREATE SEQUENCE maarch.docservers_id_seq

    AS integer

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

ALTER TABLE maarch.docservers_id_seq OWNER TO postgres;

--

-- Name: docservers_id_seq; Type: SEQUENCE OWNED BY; Schema: maarch; Owner: postgres

--

ALTER SEQUENCE maarch.docservers_id_seq OWNED BY maarch.docservers.id;

--

-- Name: doctypes_type_id_seq; Type: SEQUENCE; Schema: maarch; Owner: postgres

--

CREATE SEQUENCE maarch.doctypes_type_id_seq

    START WITH 500

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

ALTER TABLE maarch.doctypes_type_id_seq OWNER TO postgres;

--

-- Name: doctypes; Type: TABLE; Schema: maarch; Owner: postgres

--

CREATE TABLE maarch.doctypes (

    coll_id character varying(32) DEFAULT ''::character varying NOT NULL,

    type_id integer DEFAULT nextval('maarch.doctypes_type_id_seq'::regclass) NOT NULL,

    description character varying(255) DEFAULT ''::character varying NOT NULL,

    enabled character(1) DEFAULT 'Y'::bpchar NOT NULL,

    doctypes_first_level_id integer,

    doctypes_second_level_id integer,

    retention_final_disposition character varying(255) DEFAULT NULL::character varying,

    retention_rule character varying(15) DEFAULT NULL::character varying,

    duration_current_use integer

);

ALTER TABLE maarch.doctypes OWNER TO postgres;

--

-- Name: doctypes_first_level_id_seq; Type: SEQUENCE; Schema: maarch; Owner: postgres

--

CREATE SEQUENCE maarch.doctypes_first_level_id_seq

    START WITH 200

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

ALTER TABLE maarch.doctypes_first_level_id_seq OWNER TO postgres;

--

-- Name: doctypes_first_level; Type: TABLE; Schema: maarch; Owner: postgres

--

CREATE TABLE maarch.doctypes_first_level (

    doctypes_first_level_id integer DEFAULT nextval('maarch.doctypes_first_level_id_seq'::regclass) NOT NULL,

    doctypes_first_level_label character varying(255) NOT NULL,

    css_style character varying(255),

    enabled character(1) DEFAULT 'Y'::bpchar NOT NULL

);

ALTER TABLE maarch.doctypes_first_level OWNER TO postgres;

--

-- Name: doctypes_indexes; Type: TABLE; Schema: maarch; Owner: postgres

--

CREATE TABLE maarch.doctypes_indexes (

    type_id bigint NOT NULL,

    coll_id character varying(32) NOT NULL,

    field_name character varying(255) NOT NULL,

    mandatory character(1) DEFAULT 'N'::bpchar NOT NULL

);

ALTER TABLE maarch.doctypes_indexes OWNER TO postgres;

--

-- Name: doctypes_second_level_id_seq; Type: SEQUENCE; Schema: maarch; Owner: postgres

--

CREATE SEQUENCE maarch.doctypes_second_level_id_seq

    START WITH 200

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

ALTER TABLE maarch.doctypes_second_level_id_seq OWNER TO postgres;

--

-- Name: doctypes_second_level; Type: TABLE; Schema: maarch; Owner: postgres

--

CREATE TABLE maarch.doctypes_second_level (

    doctypes_second_level_id integer DEFAULT nextval('maarch.doctypes_second_level_id_seq'::regclass) NOT NULL,

    doctypes_second_level_label character varying(255) NOT NULL,

    doctypes_first_level_id integer NOT NULL,

    css_style character varying(255),

    enabled character(1) DEFAULT 'Y'::bpchar NOT NULL

);

ALTER TABLE maarch.doctypes_second_level OWNER TO postgres;

--

-- Name: email_signatures_id_seq; Type: SEQUENCE; Schema: maarch; Owner: postgres

--

CREATE SEQUENCE maarch.email_signatures_id_seq

    START WITH 7

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

ALTER TABLE maarch.email_signatures_id_seq OWNER TO postgres;

--

-- Name: emails; Type: TABLE; Schema: maarch; Owner: postgres

--

CREATE TABLE maarch.emails (

    id integer NOT NULL,

    user_id integer NOT NULL,

    sender json DEFAULT '{}'::json NOT NULL,

    recipients json DEFAULT '[]'::json NOT NULL,

    cc json DEFAULT '[]'::json NOT NULL,

    cci json DEFAULT '[]'::json NOT NULL,

    object character varying(256),

    body text,

    document json,

    is_html boolean DEFAULT true NOT NULL,

    status character varying(16) NOT NULL,

    message_exchange_id text,

    creation_date timestamp without time zone NOT NULL,

    send_date timestamp without time zone

);

ALTER TABLE maarch.emails OWNER TO postgres;

--

-- Name: emails_id_seq; Type: SEQUENCE; Schema: maarch; Owner: postgres

--

CREATE SEQUENCE maarch.emails_id_seq

    AS integer

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

ALTER TABLE maarch.emails_id_seq OWNER TO postgres;

--

-- Name: emails_id_seq; Type: SEQUENCE OWNED BY; Schema: maarch; Owner: postgres

--

ALTER SEQUENCE maarch.emails_id_seq OWNED BY maarch.emails.id;

--

-- Name: entities; Type: TABLE; Schema: maarch; Owner: postgres

--

CREATE TABLE maarch.entities (

    id integer NOT NULL,

    entity_id character varying(32) NOT NULL,

    entity_label character varying(255),

    short_label character varying(50),

    entity_full_name text,

    enabled character(1) DEFAULT 'Y'::bpchar NOT NULL,

    adrs_1 character varying(255),

    adrs_2 character varying(255),

    adrs_3 character varying(255),

    zipcode character varying(32),

    city character varying(255),

    country character varying(255),

    email character varying(255),

    business_id character varying(32),

    parent_entity_id character varying(32),

    entity_type character varying(64),

    ldap_id character varying(255),

    archival_agency character varying(255),

    archival_agreement character varying(255),

    folder_import character varying(64)

);

ALTER TABLE maarch.entities OWNER TO postgres;

--

-- Name: entities_id_seq; Type: SEQUENCE; Schema: maarch; Owner: postgres

--

CREATE SEQUENCE maarch.entities_id_seq

    AS integer

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

ALTER TABLE maarch.entities_id_seq OWNER TO postgres;

--

-- Name: entities_id_seq; Type: SEQUENCE OWNED BY; Schema: maarch; Owner: postgres

--

ALTER SEQUENCE maarch.entities_id_seq OWNED BY maarch.entities.id;

--

-- Name: exports_templates; Type: TABLE; Schema: maarch; Owner: postgres

--

CREATE TABLE maarch.exports_templates (

    id integer NOT NULL,

    user_id integer NOT NULL,

    delimiter character varying(3),

    format character varying(3) NOT NULL,

    data json DEFAULT '[]'::json NOT NULL

);

ALTER TABLE maarch.exports_templates OWNER TO postgres;

--

-- Name: exports_templates_id_seq; Type: SEQUENCE; Schema: maarch; Owner: postgres

--

CREATE SEQUENCE maarch.exports_templates_id_seq

    AS integer

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

ALTER TABLE maarch.exports_templates_id_seq OWNER TO postgres;

--

-- Name: exports_templates_id_seq; Type: SEQUENCE OWNED BY; Schema: maarch; Owner: postgres

--

ALTER SEQUENCE maarch.exports_templates_id_seq OWNED BY maarch.exports_templates.id;

--

-- Name: folders_system_id_seq; Type: SEQUENCE; Schema: maarch; Owner: postgres

--

CREATE SEQUENCE maarch.folders_system_id_seq

    START WITH 10000

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

ALTER TABLE maarch.folders_system_id_seq OWNER TO postgres;

--

-- Name: folders; Type: TABLE; Schema: maarch; Owner: postgres

--

CREATE TABLE maarch.folders (

    folders_system_id bigint DEFAULT nextval('maarch.folders_system_id_seq'::regclass) NOT NULL,

    folder_id character varying(255) NOT NULL,

    foldertype_id integer,

    parent_id bigint DEFAULT (0)::bigint,

    folder_name character varying(255) DEFAULT NULL::character varying,

    subject character varying(255) DEFAULT NULL::character varying,

    description character varying(255) DEFAULT NULL::character varying,

    author character varying(255) DEFAULT NULL::character varying,

    typist character varying(255) DEFAULT NULL::character varying,

    status character varying(50) DEFAULT 'FOLDNEW'::character varying NOT NULL,

    folder_level smallint DEFAULT (1)::smallint,

    creation_date timestamp without time zone NOT NULL,

    destination character varying(50) DEFAULT NULL::character varying,

    dest_user character varying(128) DEFAULT NULL::character varying,

    folder_out_id bigint,

    video_status character varying(10) DEFAULT NULL::character varying,

    video_user character varying(128) DEFAULT NULL::character varying,

    is_frozen character(1) DEFAULT 'N'::bpchar NOT NULL,

    custom_t1 character varying(255) DEFAULT NULL::character varying,

    custom_n1 bigint,

    custom_f1 numeric,

    custom_d1 timestamp without time zone,

    custom_t2 character varying(255) DEFAULT NULL::character varying,

    custom_n2 bigint,

    custom_f2 numeric,

    custom_d2 timestamp without time zone,

    custom_t3 character varying(255) DEFAULT NULL::character varying,

    custom_n3 bigint,

    custom_f3 numeric,

    custom_d3 timestamp without time zone,

    custom_t4 character varying(255) DEFAULT NULL::character varying,

    custom_n4 bigint,

    custom_f4 numeric,

    custom_d4 timestamp without time zone,

    custom_t5 character varying(255) DEFAULT NULL::character varying,

    custom_n5 bigint,

    custom_f5 numeric,

    custom_d5 timestamp without time zone,

    custom_t6 character varying(255) DEFAULT NULL::character varying,

    custom_d6 timestamp without time zone,

    custom_t7 character varying(255) DEFAULT NULL::character varying,

    custom_d7 timestamp without time zone,

    custom_t8 character varying(255) DEFAULT NULL::character varying,

    custom_d8 timestamp without time zone,

    custom_t9 character varying(255) DEFAULT NULL::character varying,

    custom_d9 timestamp without time zone,

    custom_t10 character varying(255) DEFAULT NULL::character varying,

    custom_d10 timestamp without time zone,

    custom_t11 character varying(255) DEFAULT NULL::character varying,

    custom_d11 timestamp without time zone,

    custom_t12 character varying(255) DEFAULT NULL::character varying,

    custom_d12 timestamp without time zone,

    custom_t13 character varying(255) DEFAULT NULL::character varying,

    custom_d13 timestamp without time zone,

    custom_t14 character varying(255) DEFAULT NULL::character varying,

    custom_d14 timestamp without time zone,

    custom_t15 character varying(255) DEFAULT NULL::character varying,

    is_complete character(1) DEFAULT 'N'::bpchar,

    is_folder_out character(1) DEFAULT 'N'::bpchar,

    last_modified_date timestamp without time zone

);