-- Name: COLUMN mail_channel.livechat_channel_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_channel.livechat_channel_id IS 'Channel';


--
-- Name: COLUMN mail_channel.livechat_operator_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_channel.livechat_operator_id IS 'Operator';


--
-- Name: COLUMN mail_channel.chatbot_current_step_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_channel.chatbot_current_step_id IS 'Chatbot Current Step';


--
-- Name: COLUMN mail_channel.country_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_channel.country_id IS 'Country';


--
-- Name: COLUMN mail_channel.anonymous_name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_channel.anonymous_name IS 'Anonymous Name';


--
-- Name: COLUMN mail_channel.livechat_active; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_channel.livechat_active IS 'Is livechat ongoing?';


--
-- Name: COLUMN mail_channel.rating_last_value; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_channel.rating_last_value IS 'Rating Last Value';


--
-- Name: COLUMN mail_channel.livechat_visitor_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_channel.livechat_visitor_id IS 'Visitor';


--
-- Name: CONSTRAINT mail_channel_channel_type_not_null ON mail_channel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT mail_channel_channel_type_not_null ON public.mail_channel IS 'CHECK(channel_type IS NOT NULL)';


--
-- Name: CONSTRAINT mail_channel_group_public_id_check ON mail_channel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT mail_channel_group_public_id_check ON public.mail_channel IS 'CHECK (channel_type = ''channel'' OR group_public_id IS NULL)';


--
-- Name: CONSTRAINT mail_channel_livechat_operator_id ON mail_channel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT mail_channel_livechat_operator_id ON public.mail_channel IS 'CHECK((channel_type = ''livechat'' and livechat_operator_id is not null) or (channel_type != ''livechat''))';


--
-- Name: mail_channel_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.mail_channel_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.mail_channel_id_seq OWNER TO odoo;

--
-- Name: mail_channel_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.mail_channel_id_seq OWNED BY public.mail_channel.id;


--
-- Name: mail_channel_member; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mail_channel_member (
    id integer NOT NULL,
    partner_id integer,
    guest_id integer,
    channel_id integer NOT NULL,
    fetched_message_id integer,
    seen_message_id integer,
    rtc_inviting_session_id integer,
    create_uid integer,
    write_uid integer,
    custom_channel_name character varying,
    fold_state character varying,
    is_minimized boolean,
    is_pinned boolean,
    last_interest_dt timestamp without time zone,
    last_seen_dt timestamp without time zone,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    CONSTRAINT mail_channel_member_partner_or_guest_exists CHECK ((((partner_id IS NOT NULL) AND (guest_id IS NULL)) OR ((partner_id IS NULL) AND (guest_id IS NOT NULL))))
);


ALTER TABLE public.mail_channel_member OWNER TO odoo;

--
-- Name: TABLE mail_channel_member; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.mail_channel_member IS 'Listeners of a Channel';


--
-- Name: COLUMN mail_channel_member.partner_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_channel_member.partner_id IS 'Recipient';


--
-- Name: COLUMN mail_channel_member.guest_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_channel_member.guest_id IS 'Guest';


--
-- Name: COLUMN mail_channel_member.channel_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_channel_member.channel_id IS 'Channel';


--
-- Name: COLUMN mail_channel_member.fetched_message_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_channel_member.fetched_message_id IS 'Last Fetched';


--
-- Name: COLUMN mail_channel_member.seen_message_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_channel_member.seen_message_id IS 'Last Seen';


--
-- Name: COLUMN mail_channel_member.rtc_inviting_session_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_channel_member.rtc_inviting_session_id IS 'Ringing session';


--
-- Name: COLUMN mail_channel_member.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_channel_member.create_uid IS 'Created by';


--
-- Name: COLUMN mail_channel_member.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_channel_member.write_uid IS 'Last Updated by';


--
-- Name: COLUMN mail_channel_member.custom_channel_name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_channel_member.custom_channel_name IS 'Custom channel name';


--
-- Name: COLUMN mail_channel_member.fold_state; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_channel_member.fold_state IS 'Conversation Fold State';


--
-- Name: COLUMN mail_channel_member.is_minimized; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_channel_member.is_minimized IS 'Conversation is minimized';


--
-- Name: COLUMN mail_channel_member.is_pinned; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_channel_member.is_pinned IS 'Is pinned on the interface';


--
-- Name: COLUMN mail_channel_member.last_interest_dt; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_channel_member.last_interest_dt IS 'Last Interest';


--
-- Name: COLUMN mail_channel_member.last_seen_dt; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_channel_member.last_seen_dt IS 'Last seen date';


--
-- Name: COLUMN mail_channel_member.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_channel_member.create_date IS 'Created on';


--
-- Name: COLUMN mail_channel_member.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_channel_member.write_date IS 'Last Updated on';


--
-- Name: CONSTRAINT mail_channel_member_partner_or_guest_exists ON mail_channel_member; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT mail_channel_member_partner_or_guest_exists ON public.mail_channel_member IS 'CHECK((partner_id IS NOT NULL AND guest_id IS NULL) OR (partner_id IS NULL AND guest_id IS NOT NULL))';


--
-- Name: mail_channel_member_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.mail_channel_member_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.mail_channel_member_id_seq OWNER TO odoo;

--
-- Name: mail_channel_member_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.mail_channel_member_id_seq OWNED BY public.mail_channel_member.id;


--
-- Name: mail_channel_res_groups_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mail_channel_res_groups_rel (
    mail_channel_id integer NOT NULL,
    res_groups_id integer NOT NULL
);


ALTER TABLE public.mail_channel_res_groups_rel OWNER TO odoo;

--
-- Name: TABLE mail_channel_res_groups_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.mail_channel_res_groups_rel IS 'RELATION BETWEEN mail_channel AND res_groups';


--
-- Name: mail_channel_rtc_session; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mail_channel_rtc_session (
    id integer NOT NULL,
    channel_member_id integer NOT NULL,
    channel_id integer,
    create_uid integer,
    write_uid integer,
    is_screen_sharing_on boolean,
    is_camera_on boolean,
    is_muted boolean,
    is_deaf boolean,
    write_date timestamp without time zone,
    create_date timestamp without time zone
);


ALTER TABLE public.mail_channel_rtc_session OWNER TO odoo;

--
-- Name: TABLE mail_channel_rtc_session; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.mail_channel_rtc_session IS 'Mail RTC session';


--
-- Name: COLUMN mail_channel_rtc_session.channel_member_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_channel_rtc_session.channel_member_id IS 'Channel Member';


--
-- Name: COLUMN mail_channel_rtc_session.channel_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_channel_rtc_session.channel_id IS 'Channel';


--
-- Name: COLUMN mail_channel_rtc_session.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_channel_rtc_session.create_uid IS 'Created by';


--
-- Name: COLUMN mail_channel_rtc_session.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_channel_rtc_session.write_uid IS 'Last Updated by';


--
-- Name: COLUMN mail_channel_rtc_session.is_screen_sharing_on; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_channel_rtc_session.is_screen_sharing_on IS 'Is sharing the screen';


--
-- Name: COLUMN mail_channel_rtc_session.is_camera_on; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_channel_rtc_session.is_camera_on IS 'Is sending user video';


--
-- Name: COLUMN mail_channel_rtc_session.is_muted; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_channel_rtc_session.is_muted IS 'Is microphone muted';


--
-- Name: COLUMN mail_channel_rtc_session.is_deaf; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_channel_rtc_session.is_deaf IS 'Has disabled incoming sound';


--
-- Name: COLUMN mail_channel_rtc_session.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_channel_rtc_session.write_date IS 'Last Updated On';


--
-- Name: COLUMN mail_channel_rtc_session.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_channel_rtc_session.create_date IS 'Created on';


--
-- Name: mail_channel_rtc_session_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.mail_channel_rtc_session_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.mail_channel_rtc_session_id_seq OWNER TO odoo;

--
-- Name: mail_channel_rtc_session_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.mail_channel_rtc_session_id_seq OWNED BY public.mail_channel_rtc_session.id;


--
-- Name: mail_compose_message; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mail_compose_message (
    id integer NOT NULL,
    template_id integer,
    parent_id integer,
    author_id integer,
    res_id integer,
    subtype_id integer,
    mail_activity_type_id integer,
    mail_server_id integer,
    create_uid integer,
    write_uid integer,
    lang character varying,
    subject character varying,
    email_layout_xmlid character varying,
    email_from character varying,
    composition_mode character varying,
    model character varying,
    record_name character varying,
    message_type character varying NOT NULL,
    reply_to character varying,
    body text,
    active_domain text,
    email_add_signature boolean,
    use_active_domain boolean,
    is_log boolean,
    notify boolean,
    reply_to_force_new boolean,
    auto_delete boolean,
    auto_delete_message boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    mass_mailing_id integer,
    campaign_id integer,
    mass_mailing_name character varying
);


ALTER TABLE public.mail_compose_message OWNER TO odoo;

--
-- Name: TABLE mail_compose_message; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.mail_compose_message IS 'Email composition wizard';


--
-- Name: COLUMN mail_compose_message.template_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_compose_message.template_id IS 'Use template';


--
-- Name: COLUMN mail_compose_message.parent_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_compose_message.parent_id IS 'Parent Message';


--
-- Name: COLUMN mail_compose_message.author_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_compose_message.author_id IS 'Author';


--
-- Name: COLUMN mail_compose_message.res_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_compose_message.res_id IS 'Related Document ID';


--
-- Name: COLUMN mail_compose_message.subtype_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_compose_message.subtype_id IS 'Subtype';


--
-- Name: COLUMN mail_compose_message.mail_activity_type_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_compose_message.mail_activity_type_id IS 'Mail Activity Type';


--
-- Name: COLUMN mail_compose_message.mail_server_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_compose_message.mail_server_id IS 'Outgoing mail server';


--
-- Name: COLUMN mail_compose_message.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_compose_message.create_uid IS 'Created by';


--
-- Name: COLUMN mail_compose_message.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_compose_message.write_uid IS 'Last Updated by';


--
-- Name: COLUMN mail_compose_message.lang; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_compose_message.lang IS 'Language';


--
-- Name: COLUMN mail_compose_message.subject; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_compose_message.subject IS 'Subject';


--
-- Name: COLUMN mail_compose_message.email_layout_xmlid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_compose_message.email_layout_xmlid IS 'Email Notification Layout';


--
-- Name: COLUMN mail_compose_message.email_from; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_compose_message.email_from IS 'From';


--
-- Name: COLUMN mail_compose_message.composition_mode; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_compose_message.composition_mode IS 'Composition mode';


--
-- Name: COLUMN mail_compose_message.model; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_compose_message.model IS 'Related Document Model';


--
-- Name: COLUMN mail_compose_message.record_name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_compose_message.record_name IS 'Message Record Name';


--
-- Name: COLUMN mail_compose_message.message_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_compose_message.message_type IS 'Type';


--
-- Name: COLUMN mail_compose_message.reply_to; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_compose_message.reply_to IS 'Reply To';


--
-- Name: COLUMN mail_compose_message.body; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_compose_message.body IS 'Contents';


--
-- Name: COLUMN mail_compose_message.active_domain; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_compose_message.active_domain IS 'Active domain';


--
-- Name: COLUMN mail_compose_message.email_add_signature; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_compose_message.email_add_signature IS 'Email Add Signature';


--
-- Name: COLUMN mail_compose_message.use_active_domain; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_compose_message.use_active_domain IS 'Use active domain';


--
-- Name: COLUMN mail_compose_message.is_log; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_compose_message.is_log IS 'Log as Internal Note';


--
-- Name: COLUMN mail_compose_message.notify; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_compose_message.notify IS 'Notify followers';


--
-- Name: COLUMN mail_compose_message.reply_to_force_new; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_compose_message.reply_to_force_new IS 'Considers answers as new thread';


--
-- Name: COLUMN mail_compose_message.auto_delete; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_compose_message.auto_delete IS 'Delete Emails';


--
-- Name: COLUMN mail_compose_message.auto_delete_message; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_compose_message.auto_delete_message IS 'Delete Message Copy';


--
-- Name: COLUMN mail_compose_message.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_compose_message.create_date IS 'Created on';


--
-- Name: COLUMN mail_compose_message.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_compose_message.write_date IS 'Last Updated on';


--
-- Name: COLUMN mail_compose_message.mass_mailing_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_compose_message.mass_mailing_id IS 'Mass Mailing';


--
-- Name: COLUMN mail_compose_message.campaign_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_compose_message.campaign_id IS 'Mass Mailing Campaign';


--
-- Name: COLUMN mail_compose_message.mass_mailing_name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_compose_message.mass_mailing_name IS 'Mass Mailing Name';


--
-- Name: mail_compose_message_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.mail_compose_message_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.mail_compose_message_id_seq OWNER TO odoo;

--
-- Name: mail_compose_message_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.mail_compose_message_id_seq OWNED BY public.mail_compose_message.id;


--
-- Name: mail_compose_message_ir_attachments_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mail_compose_message_ir_attachments_rel (
    wizard_id integer NOT NULL,
    attachment_id integer NOT NULL
);


ALTER TABLE public.mail_compose_message_ir_attachments_rel OWNER TO odoo;

--
-- Name: TABLE mail_compose_message_ir_attachments_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.mail_compose_message_ir_attachments_rel IS 'RELATION BETWEEN mail_compose_message AND ir_attachment';


--
-- Name: mail_compose_message_mailing_list_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mail_compose_message_mailing_list_rel (
    mail_compose_message_id integer NOT NULL,
    mailing_list_id integer NOT NULL
);


ALTER TABLE public.mail_compose_message_mailing_list_rel OWNER TO odoo;

--
-- Name: TABLE mail_compose_message_mailing_list_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.mail_compose_message_mailing_list_rel IS 'RELATION BETWEEN mail_compose_message AND mailing_list';


--
-- Name: mail_compose_message_res_partner_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mail_compose_message_res_partner_rel (
    wizard_id integer NOT NULL,
    partner_id integer NOT NULL
);


ALTER TABLE public.mail_compose_message_res_partner_rel OWNER TO odoo;

--
-- Name: TABLE mail_compose_message_res_partner_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.mail_compose_message_res_partner_rel IS 'RELATION BETWEEN mail_compose_message AND res_partner';


--
-- Name: mail_followers; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mail_followers (
    id integer NOT NULL,
    res_id integer,
    partner_id integer NOT NULL,
    res_model character varying NOT NULL
);


ALTER TABLE public.mail_followers OWNER TO odoo;

--
-- Name: TABLE mail_followers; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.mail_followers IS 'Document Followers';


--
-- Name: COLUMN mail_followers.res_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_followers.res_id IS 'Related Document ID';


--
-- Name: COLUMN mail_followers.partner_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_followers.partner_id IS 'Related Partner';


--
-- Name: COLUMN mail_followers.res_model; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_followers.res_model IS 'Related Document Model Name';


--
-- Name: mail_followers_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.mail_followers_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.mail_followers_id_seq OWNER TO odoo;

--
-- Name: mail_followers_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.mail_followers_id_seq OWNED BY public.mail_followers.id;


--
-- Name: mail_followers_mail_message_subtype_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mail_followers_mail_message_subtype_rel (
    mail_followers_id integer NOT NULL,
    mail_message_subtype_id integer NOT NULL
);


ALTER TABLE public.mail_followers_mail_message_subtype_rel OWNER TO odoo;

--
-- Name: TABLE mail_followers_mail_message_subtype_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.mail_followers_mail_message_subtype_rel IS 'RELATION BETWEEN mail_followers AND mail_message_subtype';


--
-- Name: mail_gateway_allowed; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mail_gateway_allowed (
    id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    email character varying,
    email_normalized character varying,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.mail_gateway_allowed OWNER TO odoo;

--
-- Name: TABLE mail_gateway_allowed; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.mail_gateway_allowed IS 'Mail Gateway Allowed';


--
-- Name: COLUMN mail_gateway_allowed.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_gateway_allowed.create_uid IS 'Created by';


--
-- Name: COLUMN mail_gateway_allowed.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_gateway_allowed.write_uid IS 'Last Updated by';


--
-- Name: COLUMN mail_gateway_allowed.email; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_gateway_allowed.email IS 'Email Address';


--
-- Name: COLUMN mail_gateway_allowed.email_normalized; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_gateway_allowed.email_normalized IS 'Normalized Email';


--
-- Name: COLUMN mail_gateway_allowed.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_gateway_allowed.create_date IS 'Created on';


--
-- Name: COLUMN mail_gateway_allowed.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_gateway_allowed.write_date IS 'Last Updated on';


--
-- Name: mail_gateway_allowed_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.mail_gateway_allowed_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.mail_gateway_allowed_id_seq OWNER TO odoo;

--
-- Name: mail_gateway_allowed_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.mail_gateway_allowed_id_seq OWNED BY public.mail_gateway_allowed.id;


--
-- Name: mail_guest; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mail_guest (
    id integer NOT NULL,
    country_id integer,
    create_uid integer,
    write_uid integer,
    name character varying NOT NULL,
    access_token character varying NOT NULL,
    lang character varying,
    timezone character varying,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.mail_guest OWNER TO odoo;

--
-- Name: TABLE mail_guest; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.mail_guest IS 'Guest';


--
-- Name: COLUMN mail_guest.country_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_guest.country_id IS 'Country';


--
-- Name: COLUMN mail_guest.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_guest.create_uid IS 'Created by';


--
-- Name: COLUMN mail_guest.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_guest.write_uid IS 'Last Updated by';


--
-- Name: COLUMN mail_guest.name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_guest.name IS 'Name';


--
-- Name: COLUMN mail_guest.access_token; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_guest.access_token IS 'Access Token';


--
-- Name: COLUMN mail_guest.lang; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_guest.lang IS 'Language';


--
-- Name: COLUMN mail_guest.timezone; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_guest.timezone IS 'Timezone';


--
-- Name: COLUMN mail_guest.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_guest.create_date IS 'Created on';


--
-- Name: COLUMN mail_guest.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_guest.write_date IS 'Last Updated on';


--
-- Name: mail_guest_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.mail_guest_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.mail_guest_id_seq OWNER TO odoo;

--
-- Name: mail_guest_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.mail_guest_id_seq OWNED BY public.mail_guest.id;


--
-- Name: mail_ice_server; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mail_ice_server (
    id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    server_type character varying NOT NULL,
    uri character varying NOT NULL,
    username character varying,
    credential character varying,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.mail_ice_server OWNER TO odoo;

--
-- Name: TABLE mail_ice_server; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.mail_ice_server IS 'ICE server';


--
-- Name: COLUMN mail_ice_server.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_ice_server.create_uid IS 'Created by';


--
-- Name: COLUMN mail_ice_server.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_ice_server.write_uid IS 'Last Updated by';


--
-- Name: COLUMN mail_ice_server.server_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_ice_server.server_type IS 'Type';


--
-- Name: COLUMN mail_ice_server.uri; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_ice_server.uri IS 'URI';


--
-- Name: COLUMN mail_ice_server.username; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_ice_server.username IS 'Username';


--
-- Name: COLUMN mail_ice_server.credential; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_ice_server.credential IS 'Credential';


--
-- Name: COLUMN mail_ice_server.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_ice_server.create_date IS 'Created on';


--
-- Name: COLUMN mail_ice_server.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_ice_server.write_date IS 'Last Updated on';


--
-- Name: mail_ice_server_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.mail_ice_server_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.mail_ice_server_id_seq OWNER TO odoo;

--
-- Name: mail_ice_server_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.mail_ice_server_id_seq OWNED BY public.mail_ice_server.id;


--
-- Name: mail_link_preview; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mail_link_preview (
    id integer NOT NULL,
    message_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    source_url character varying NOT NULL,
    og_type character varying,
    og_title character varying,
    og_image character varying,
    og_mimetype character varying,
    image_mimetype character varying,
    og_description text,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.mail_link_preview OWNER TO odoo;

--
-- Name: TABLE mail_link_preview; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.mail_link_preview IS 'Store link preview data';


--
-- Name: COLUMN mail_link_preview.message_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_link_preview.message_id IS 'Message';


--
-- Name: COLUMN mail_link_preview.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_link_preview.create_uid IS 'Created by';


--
-- Name: COLUMN mail_link_preview.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_link_preview.write_uid IS 'Last Updated by';


--
-- Name: COLUMN mail_link_preview.source_url; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_link_preview.source_url IS 'URL';


--
-- Name: COLUMN mail_link_preview.og_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_link_preview.og_type IS 'Type';


--
-- Name: COLUMN mail_link_preview.og_title; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_link_preview.og_title IS 'Title';


--
-- Name: COLUMN mail_link_preview.og_image; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_link_preview.og_image IS 'Image';


--
-- Name: COLUMN mail_link_preview.og_mimetype; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_link_preview.og_mimetype IS 'MIME type';


--
-- Name: COLUMN mail_link_preview.image_mimetype; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_link_preview.image_mimetype IS 'Image MIME type';


--
-- Name: COLUMN mail_link_preview.og_description; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_link_preview.og_description IS 'Description';


--
-- Name: COLUMN mail_link_preview.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_link_preview.create_date IS 'Create Date';


--
-- Name: COLUMN mail_link_preview.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_link_preview.write_date IS 'Last Updated on';


--
-- Name: mail_link_preview_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.mail_link_preview_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.mail_link_preview_id_seq OWNER TO odoo;

--
-- Name: mail_link_preview_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.mail_link_preview_id_seq OWNED BY public.mail_link_preview.id;


--
-- Name: mail_mail; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mail_mail (
    id integer NOT NULL,
    mail_message_id integer NOT NULL,
    fetchmail_server_id integer,
    create_uid integer,
    write_uid integer,
    email_cc character varying,
    state character varying,
    failure_type character varying,
    body_html text,
    "references" text,
    headers text,
    email_to text,
    failure_reason text,
    is_notification boolean,
    auto_delete boolean,
    to_delete boolean,
    scheduled_date timestamp without time zone,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    mailing_id integer
);


ALTER TABLE public.mail_mail OWNER TO odoo;

--
-- Name: TABLE mail_mail; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.mail_mail IS 'Outgoing Mails';


--
-- Name: COLUMN mail_mail.mail_message_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_mail.mail_message_id IS 'Message';


--
-- Name: COLUMN mail_mail.fetchmail_server_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_mail.fetchmail_server_id IS 'Inbound Mail Server';


--
-- Name: COLUMN mail_mail.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_mail.create_uid IS 'Created by';


--
-- Name: COLUMN mail_mail.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_mail.write_uid IS 'Last Updated by';


--
-- Name: COLUMN mail_mail.email_cc; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_mail.email_cc IS 'Cc';


--
-- Name: COLUMN mail_mail.state; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_mail.state IS 'Status';


--
-- Name: COLUMN mail_mail.failure_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_mail.failure_type IS 'Failure type';


--
-- Name: COLUMN mail_mail.body_html; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_mail.body_html IS 'Text Contents';


--
-- Name: COLUMN mail_mail."references"; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_mail."references" IS 'References';


--
-- Name: COLUMN mail_mail.headers; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_mail.headers IS 'Headers';


--
-- Name: COLUMN mail_mail.email_to; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_mail.email_to IS 'To';


--
-- Name: COLUMN mail_mail.failure_reason; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_mail.failure_reason IS 'Failure Reason';


--
-- Name: COLUMN mail_mail.is_notification; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_mail.is_notification IS 'Notification Email';


--
-- Name: COLUMN mail_mail.auto_delete; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_mail.auto_delete IS 'Auto Delete';


--
-- Name: COLUMN mail_mail.to_delete; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_mail.to_delete IS 'To Delete';


--
-- Name: COLUMN mail_mail.scheduled_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_mail.scheduled_date IS 'Scheduled Send Date';


--
-- Name: COLUMN mail_mail.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_mail.create_date IS 'Created on';


--
-- Name: COLUMN mail_mail.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_mail.write_date IS 'Last Updated on';


--
-- Name: COLUMN mail_mail.mailing_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_mail.mailing_id IS 'Mass Mailing';


--
-- Name: mail_mail_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.mail_mail_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.mail_mail_id_seq OWNER TO odoo;

--
-- Name: mail_mail_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.mail_mail_id_seq OWNED BY public.mail_mail.id;


--
-- Name: mail_mail_res_partner_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mail_mail_res_partner_rel (
    mail_mail_id integer NOT NULL,
    res_partner_id integer NOT NULL
);


ALTER TABLE public.mail_mail_res_partner_rel OWNER TO odoo;

--
-- Name: TABLE mail_mail_res_partner_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.mail_mail_res_partner_rel IS 'RELATION BETWEEN mail_mail AND res_partner';


--
-- Name: mail_mass_mailing_list_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mail_mass_mailing_list_rel (
    mailing_list_id integer NOT NULL,
    mailing_mailing_id integer NOT NULL
);


ALTER TABLE public.mail_mass_mailing_list_rel OWNER TO odoo;

--
-- Name: TABLE mail_mass_mailing_list_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.mail_mass_mailing_list_rel IS 'RELATION BETWEEN mailing_list AND mailing_mailing';


--
-- Name: mail_message_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.mail_message_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.mail_message_id_seq OWNER TO odoo;

--
-- Name: mail_message_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.mail_message_id_seq OWNED BY public.mail_message.id;


--
-- Name: mail_message_reaction; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mail_message_reaction (
    id integer NOT NULL,
    message_id integer NOT NULL,
    partner_id integer,
    guest_id integer,
    content character varying NOT NULL,
    CONSTRAINT mail_message_reaction_partner_or_guest_exists CHECK ((((partner_id IS NOT NULL) AND (guest_id IS NULL)) OR ((partner_id IS NULL) AND (guest_id IS NOT NULL))))
);


ALTER TABLE public.mail_message_reaction OWNER TO odoo;

--
-- Name: TABLE mail_message_reaction; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.mail_message_reaction IS 'Message Reaction';


--
-- Name: COLUMN mail_message_reaction.message_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_message_reaction.message_id IS 'Message';


--
-- Name: COLUMN mail_message_reaction.partner_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_message_reaction.partner_id IS 'Reacting Partner';


--
-- Name: COLUMN mail_message_reaction.guest_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_message_reaction.guest_id IS 'Reacting Guest';


--
-- Name: COLUMN mail_message_reaction.content; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_message_reaction.content IS 'Content';


--
-- Name: CONSTRAINT mail_message_reaction_partner_or_guest_exists ON mail_message_reaction; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT mail_message_reaction_partner_or_guest_exists ON public.mail_message_reaction IS 'CHECK((partner_id IS NOT NULL AND guest_id IS NULL) OR (partner_id IS NULL AND guest_id IS NOT NULL))';


--
-- Name: mail_message_reaction_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.mail_message_reaction_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.mail_message_reaction_id_seq OWNER TO odoo;

--
-- Name: mail_message_reaction_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.mail_message_reaction_id_seq OWNED BY public.mail_message_reaction.id;


--
-- Name: mail_message_res_partner_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mail_message_res_partner_rel (
    mail_message_id integer NOT NULL,
    res_partner_id integer NOT NULL
);


ALTER TABLE public.mail_message_res_partner_rel OWNER TO odoo;

--
-- Name: TABLE mail_message_res_partner_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.mail_message_res_partner_rel IS 'RELATION BETWEEN mail_message AND res_partner';


--
-- Name: mail_message_res_partner_starred_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mail_message_res_partner_starred_rel (
    mail_message_id integer NOT NULL,
    res_partner_id integer NOT NULL
);


ALTER TABLE public.mail_message_res_partner_starred_rel OWNER TO odoo;

--
-- Name: TABLE mail_message_res_partner_starred_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.mail_message_res_partner_starred_rel IS 'RELATION BETWEEN mail_message AND res_partner';


--
-- Name: mail_message_schedule; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mail_message_schedule (
    id integer NOT NULL,
    mail_message_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    notification_parameters text,
    scheduled_datetime timestamp without time zone NOT NULL,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.mail_message_schedule OWNER TO odoo;

--
-- Name: TABLE mail_message_schedule; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.mail_message_schedule IS 'Scheduled Messages';


--
-- Name: COLUMN mail_message_schedule.mail_message_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_message_schedule.mail_message_id IS 'Message';


--
-- Name: COLUMN mail_message_schedule.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_message_schedule.create_uid IS 'Created by';


--
-- Name: COLUMN mail_message_schedule.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_message_schedule.write_uid IS 'Last Updated by';


--
-- Name: COLUMN mail_message_schedule.notification_parameters; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_message_schedule.notification_parameters IS 'Notification Parameter';


--
-- Name: COLUMN mail_message_schedule.scheduled_datetime; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_message_schedule.scheduled_datetime IS 'Scheduled Send Date';


--
-- Name: COLUMN mail_message_schedule.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_message_schedule.create_date IS 'Created on';


--
-- Name: COLUMN mail_message_schedule.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_message_schedule.write_date IS 'Last Updated on';


--
-- Name: mail_message_schedule_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.mail_message_schedule_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.mail_message_schedule_id_seq OWNER TO odoo;

--
-- Name: mail_message_schedule_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.mail_message_schedule_id_seq OWNED BY public.mail_message_schedule.id;


--
-- Name: mail_message_subtype; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mail_message_subtype (
    id integer NOT NULL,
    parent_id integer,
    sequence integer,
    create_uid integer,
    write_uid integer,
    relation_field character varying,
    res_model character varying,
    name jsonb NOT NULL,
    description jsonb,
    internal boolean,
    "default" boolean,
    hidden boolean,
    track_recipients boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.mail_message_subtype OWNER TO odoo;

--
-- Name: TABLE mail_message_subtype; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.mail_message_subtype IS 'Message subtypes';


--
-- Name: COLUMN mail_message_subtype.parent_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_message_subtype.parent_id IS 'Parent';


--
-- Name: COLUMN mail_message_subtype.sequence; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_message_subtype.sequence IS 'Sequence';


--
-- Name: COLUMN mail_message_subtype.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_message_subtype.create_uid IS 'Created by';


--
-- Name: COLUMN mail_message_subtype.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_message_subtype.write_uid IS 'Last Updated by';


--
-- Name: COLUMN mail_message_subtype.relation_field; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_message_subtype.relation_field IS 'Relation field';


--
-- Name: COLUMN mail_message_subtype.res_model; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_message_subtype.res_model IS 'Model';


--
-- Name: COLUMN mail_message_subtype.name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_message_subtype.name IS 'Message Type';


--
-- Name: COLUMN mail_message_subtype.description; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_message_subtype.description IS 'Description';


--
-- Name: COLUMN mail_message_subtype.internal; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_message_subtype.internal IS 'Internal Only';


--
-- Name: COLUMN mail_message_subtype."default"; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_message_subtype."default" IS 'Default';


--
-- Name: COLUMN mail_message_subtype.hidden; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_message_subtype.hidden IS 'Hidden';


--
-- Name: COLUMN mail_message_subtype.track_recipients; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_message_subtype.track_recipients IS 'Track Recipients';


--
-- Name: COLUMN mail_message_subtype.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_message_subtype.create_date IS 'Created on';


--
-- Name: COLUMN mail_message_subtype.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_message_subtype.write_date IS 'Last Updated on';


--
-- Name: mail_message_subtype_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.mail_message_subtype_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.mail_message_subtype_id_seq OWNER TO odoo;

--
-- Name: mail_message_subtype_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.mail_message_subtype_id_seq OWNED BY public.mail_message_subtype.id;


--
-- Name: mail_notification; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mail_notification (
    id integer NOT NULL,
    author_id integer,
    mail_message_id integer NOT NULL,
    mail_mail_id integer,
    res_partner_id integer,
    notification_type character varying NOT NULL,
    notification_status character varying,
    failure_type character varying,
    failure_reason text,
    is_read boolean,
    read_date timestamp without time zone,
    sms_id integer,
    sms_number character varying,
    letter_id integer,
    CONSTRAINT mail_notification_notification_partner_required CHECK ((((notification_type)::text <> ALL ((ARRAY['email'::character varying, 'inbox'::character varying])::text[])) OR (res_partner_id IS NOT NULL)))
);


ALTER TABLE public.mail_notification OWNER TO odoo;

--
-- Name: TABLE mail_notification; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.mail_notification IS 'Message Notifications';


--
-- Name: COLUMN mail_notification.author_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_notification.author_id IS 'Author';


--
-- Name: COLUMN mail_notification.mail_message_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_notification.mail_message_id IS 'Message';


--
-- Name: COLUMN mail_notification.mail_mail_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_notification.mail_mail_id IS 'Mail';


--
-- Name: COLUMN mail_notification.res_partner_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_notification.res_partner_id IS 'Recipient';


--
-- Name: COLUMN mail_notification.notification_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_notification.notification_type IS 'Notification Type';


--
-- Name: COLUMN mail_notification.notification_status; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_notification.notification_status IS 'Status';


--
-- Name: COLUMN mail_notification.failure_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_notification.failure_type IS 'Failure type';


--
-- Name: COLUMN mail_notification.failure_reason; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_notification.failure_reason IS 'Failure reason';


--
-- Name: COLUMN mail_notification.is_read; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_notification.is_read IS 'Is Read';


--
-- Name: COLUMN mail_notification.read_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_notification.read_date IS 'Read Date';


--
-- Name: COLUMN mail_notification.sms_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_notification.sms_id IS 'SMS';


--
-- Name: COLUMN mail_notification.sms_number; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_notification.sms_number IS 'SMS Number';


--
-- Name: COLUMN mail_notification.letter_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_notification.letter_id IS 'Snailmail Letter';


--
-- Name: CONSTRAINT mail_notification_notification_partner_required ON mail_notification; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT mail_notification_notification_partner_required ON public.mail_notification IS 'CHECK(notification_type NOT IN (''email'', ''inbox'') OR res_partner_id IS NOT NULL)';


--
-- Name: mail_notification_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.mail_notification_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.mail_notification_id_seq OWNER TO odoo;

--
-- Name: mail_notification_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.mail_notification_id_seq OWNED BY public.mail_notification.id;


--
-- Name: mail_notification_mail_resend_message_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mail_notification_mail_resend_message_rel (
    mail_resend_message_id integer NOT NULL,
    mail_notification_id integer NOT NULL
);


ALTER TABLE public.mail_notification_mail_resend_message_rel OWNER TO odoo;

--
-- Name: TABLE mail_notification_mail_resend_message_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.mail_notification_mail_resend_message_rel IS 'RELATION BETWEEN mail_resend_message AND mail_notification';


--
-- Name: mail_resend_message; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mail_resend_message (
    id integer NOT NULL,
    mail_message_id integer,
    create_uid integer,
    write_uid integer,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.mail_resend_message OWNER TO odoo;

--
-- Name: TABLE mail_resend_message; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.mail_resend_message IS 'Email resend wizard';


--
-- Name: COLUMN mail_resend_message.mail_message_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_resend_message.mail_message_id IS 'Message';


--
-- Name: COLUMN mail_resend_message.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_resend_message.create_uid IS 'Created by';


--
-- Name: COLUMN mail_resend_message.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_resend_message.write_uid IS 'Last Updated by';


--
-- Name: COLUMN mail_resend_message.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_resend_message.create_date IS 'Created on';


--
-- Name: COLUMN mail_resend_message.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_resend_message.write_date IS 'Last Updated on';


--
-- Name: mail_resend_message_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.mail_resend_message_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.mail_resend_message_id_seq OWNER TO odoo;

--
-- Name: mail_resend_message_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.mail_resend_message_id_seq OWNED BY public.mail_resend_message.id;


--
-- Name: mail_resend_partner; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mail_resend_partner (
    id integer NOT NULL,
    partner_id integer NOT NULL,
    resend_wizard_id integer,
    create_uid integer,
    write_uid integer,
    message character varying,
    resend boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.mail_resend_partner OWNER TO odoo;

--
-- Name: TABLE mail_resend_partner; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.mail_resend_partner IS 'Partner with additional information for mail resend';


--
-- Name: COLUMN mail_resend_partner.partner_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_resend_partner.partner_id IS 'Partner';


--
-- Name: COLUMN mail_resend_partner.resend_wizard_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_resend_partner.resend_wizard_id IS 'Resend wizard';


--
-- Name: COLUMN mail_resend_partner.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_resend_partner.create_uid IS 'Created by';


--
-- Name: COLUMN mail_resend_partner.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_resend_partner.write_uid IS 'Last Updated by';


--
-- Name: COLUMN mail_resend_partner.message; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_resend_partner.message IS 'Error message';


--
-- Name: COLUMN mail_resend_partner.resend; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_resend_partner.resend IS 'Try Again';


--
-- Name: COLUMN mail_resend_partner.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_resend_partner.create_date IS 'Created on';


--
-- Name: COLUMN mail_resend_partner.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_resend_partner.write_date IS 'Last Updated on';


--
-- Name: mail_resend_partner_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.mail_resend_partner_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.mail_resend_partner_id_seq OWNER TO odoo;

--
-- Name: mail_resend_partner_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.mail_resend_partner_id_seq OWNED BY public.mail_resend_partner.id;


--
-- Name: mail_shortcode; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mail_shortcode (
    id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    source character varying NOT NULL,
    description character varying,
    substitution text NOT NULL,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.mail_shortcode OWNER TO odoo;

--
-- Name: TABLE mail_shortcode; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.mail_shortcode IS 'Canned Response / Shortcode';


--
-- Name: COLUMN mail_shortcode.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_shortcode.create_uid IS 'Created by';


--
-- Name: COLUMN mail_shortcode.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_shortcode.write_uid IS 'Last Updated by';


--
-- Name: COLUMN mail_shortcode.source; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_shortcode.source IS 'Shortcut';


--
-- Name: COLUMN mail_shortcode.description; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_shortcode.description IS 'Description';


--
-- Name: COLUMN mail_shortcode.substitution; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_shortcode.substitution IS 'Substitution';


--
-- Name: COLUMN mail_shortcode.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_shortcode.create_date IS 'Created on';


--
-- Name: COLUMN mail_shortcode.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_shortcode.write_date IS 'Last Updated on';


--
-- Name: mail_shortcode_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.mail_shortcode_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.mail_shortcode_id_seq OWNER TO odoo;

--
-- Name: mail_shortcode_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.mail_shortcode_id_seq OWNED BY public.mail_shortcode.id;


--
-- Name: mail_template; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mail_template (
    id integer NOT NULL,
    model_id integer,
    report_template integer,
    mail_server_id integer,
    ref_ir_act_window integer,
    create_uid integer,
    write_uid integer,
    template_fs character varying,
    lang character varying,
    model character varying,
    email_from character varying,
    email_to character varying,
    partner_to character varying,
    email_cc character varying,
    reply_to character varying,
    scheduled_date character varying,
    name jsonb,
    description jsonb,
    subject jsonb,
    body_html jsonb,
    report_name jsonb,
    active boolean,
    use_default_to boolean,
    auto_delete boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.mail_template OWNER TO odoo;

--
-- Name: TABLE mail_template; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.mail_template IS 'Email Templates';


--
-- Name: COLUMN mail_template.model_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_template.model_id IS 'Applies to';


--
-- Name: COLUMN mail_template.report_template; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_template.report_template IS 'Optional report to print and attach';


--
-- Name: COLUMN mail_template.mail_server_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_template.mail_server_id IS 'Outgoing Mail Server';


--
-- Name: COLUMN mail_template.ref_ir_act_window; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_template.ref_ir_act_window IS 'Sidebar action';


--
-- Name: COLUMN mail_template.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_template.create_uid IS 'Created by';


--
-- Name: COLUMN mail_template.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_template.write_uid IS 'Last Updated by';


--
-- Name: COLUMN mail_template.template_fs; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_template.template_fs IS 'Template Filename';


--
-- Name: COLUMN mail_template.lang; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_template.lang IS 'Language';


--
-- Name: COLUMN mail_template.model; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_template.model IS 'Related Document Model';


--
-- Name: COLUMN mail_template.email_from; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_template.email_from IS 'From';


--
-- Name: COLUMN mail_template.email_to; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_template.email_to IS 'To (Emails)';


--
-- Name: COLUMN mail_template.partner_to; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_template.partner_to IS 'To (Partners)';


--
-- Name: COLUMN mail_template.email_cc; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_template.email_cc IS 'Cc';


--
-- Name: COLUMN mail_template.reply_to; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_template.reply_to IS 'Reply To';


--
-- Name: COLUMN mail_template.scheduled_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_template.scheduled_date IS 'Scheduled Date';


--
-- Name: COLUMN mail_template.name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_template.name IS 'Name';


--
-- Name: COLUMN mail_template.description; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_template.description IS 'Template description';


--
-- Name: COLUMN mail_template.subject; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_template.subject IS 'Subject';


--
-- Name: COLUMN mail_template.body_html; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_template.body_html IS 'Body';


--
-- Name: COLUMN mail_template.report_name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_template.report_name IS 'Report Filename';


--
-- Name: COLUMN mail_template.active; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_template.active IS 'Active';


--
-- Name: COLUMN mail_template.use_default_to; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_template.use_default_to IS 'Default recipients';


--
-- Name: COLUMN mail_template.auto_delete; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_template.auto_delete IS 'Auto Delete';


--
-- Name: COLUMN mail_template.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_template.create_date IS 'Created on';


--
-- Name: COLUMN mail_template.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_template.write_date IS 'Last Updated on';


--
-- Name: mail_template_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.mail_template_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.mail_template_id_seq OWNER TO odoo;

--
-- Name: mail_template_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.mail_template_id_seq OWNED BY public.mail_template.id;


--
-- Name: mail_template_mail_template_reset_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mail_template_mail_template_reset_rel (
    mail_template_reset_id integer NOT NULL,
    mail_template_id integer NOT NULL
);


ALTER TABLE public.mail_template_mail_template_reset_rel OWNER TO odoo;

--
-- Name: TABLE mail_template_mail_template_reset_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.mail_template_mail_template_reset_rel IS 'RELATION BETWEEN mail_template_reset AND mail_template';


--
-- Name: mail_template_preview; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mail_template_preview (
    id integer NOT NULL,
    mail_template_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    resource_ref character varying,
    lang character varying,
    error_msg character varying,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.mail_template_preview OWNER TO odoo;

--
-- Name: TABLE mail_template_preview; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.mail_template_preview IS 'Email Template Preview';


--
-- Name: COLUMN mail_template_preview.mail_template_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_template_preview.mail_template_id IS 'Related Mail Template';


--
-- Name: COLUMN mail_template_preview.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_template_preview.create_uid IS 'Created by';


--
-- Name: COLUMN mail_template_preview.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_template_preview.write_uid IS 'Last Updated by';


--
-- Name: COLUMN mail_template_preview.resource_ref; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_template_preview.resource_ref IS 'Record';


--
-- Name: COLUMN mail_template_preview.lang; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_template_preview.lang IS 'Template Preview Language';


--
-- Name: COLUMN mail_template_preview.error_msg; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_template_preview.error_msg IS 'Error Message';


--
-- Name: COLUMN mail_template_preview.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_template_preview.create_date IS 'Created on';


--
-- Name: COLUMN mail_template_preview.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_template_preview.write_date IS 'Last Updated on';


--
-- Name: mail_template_preview_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.mail_template_preview_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.mail_template_preview_id_seq OWNER TO odoo;

--
-- Name: mail_template_preview_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.mail_template_preview_id_seq OWNED BY public.mail_template_preview.id;


--
-- Name: mail_template_reset; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mail_template_reset (
    id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.mail_template_reset OWNER TO odoo;

--
-- Name: TABLE mail_template_reset; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.mail_template_reset IS 'Mail Template Reset';


--
-- Name: COLUMN mail_template_reset.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_template_reset.create_uid IS 'Created by';


--
-- Name: COLUMN mail_template_reset.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_template_reset.write_uid IS 'Last Updated by';


--
-- Name: COLUMN mail_template_reset.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_template_reset.create_date IS 'Created on';


--
-- Name: COLUMN mail_template_reset.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_template_reset.write_date IS 'Last Updated on';


--
-- Name: mail_template_reset_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.mail_template_reset_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.mail_template_reset_id_seq OWNER TO odoo;

--
-- Name: mail_template_reset_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.mail_template_reset_id_seq OWNED BY public.mail_template_reset.id;


--
-- Name: mail_tracking_value; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mail_tracking_value (
    id integer NOT NULL,
    field integer NOT NULL,
    old_value_integer integer,
    new_value_integer integer,
    currency_id integer,
    mail_message_id integer NOT NULL,
    tracking_sequence integer,
    create_uid integer,
    write_uid integer,
    field_desc character varying NOT NULL,
    field_type character varying,
    old_value_char character varying,
    new_value_char character varying,
    old_value_text text,
    new_value_text text,
    old_value_datetime timestamp without time zone,
    new_value_datetime timestamp without time zone,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    old_value_float double precision,
    old_value_monetary double precision,
    new_value_float double precision,
    new_value_monetary double precision
);


ALTER TABLE public.mail_tracking_value OWNER TO odoo;

--
-- Name: TABLE mail_tracking_value; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.mail_tracking_value IS 'Mail Tracking Value';


--
-- Name: COLUMN mail_tracking_value.field; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_tracking_value.field IS 'Field';


--
-- Name: COLUMN mail_tracking_value.old_value_integer; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_tracking_value.old_value_integer IS 'Old Value Integer';


--
-- Name: COLUMN mail_tracking_value.new_value_integer; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_tracking_value.new_value_integer IS 'New Value Integer';


--
-- Name: COLUMN mail_tracking_value.currency_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_tracking_value.currency_id IS 'Currency';


--
-- Name: COLUMN mail_tracking_value.mail_message_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_tracking_value.mail_message_id IS 'Message ID';


--
-- Name: COLUMN mail_tracking_value.tracking_sequence; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_tracking_value.tracking_sequence IS 'Tracking field sequence';


--
-- Name: COLUMN mail_tracking_value.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_tracking_value.create_uid IS 'Created by';


--
-- Name: COLUMN mail_tracking_value.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_tracking_value.write_uid IS 'Last Updated by';


--
-- Name: COLUMN mail_tracking_value.field_desc; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_tracking_value.field_desc IS 'Field Description';


--
-- Name: COLUMN mail_tracking_value.field_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_tracking_value.field_type IS 'Field Type';


--
-- Name: COLUMN mail_tracking_value.old_value_char; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_tracking_value.old_value_char IS 'Old Value Char';


--
-- Name: COLUMN mail_tracking_value.new_value_char; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_tracking_value.new_value_char IS 'New Value Char';


--
-- Name: COLUMN mail_tracking_value.old_value_text; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_tracking_value.old_value_text IS 'Old Value Text';


--
-- Name: COLUMN mail_tracking_value.new_value_text; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_tracking_value.new_value_text IS 'New Value Text';


--
-- Name: COLUMN mail_tracking_value.old_value_datetime; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_tracking_value.old_value_datetime IS 'Old Value DateTime';


--
-- Name: COLUMN mail_tracking_value.new_value_datetime; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_tracking_value.new_value_datetime IS 'New Value Datetime';


--
-- Name: COLUMN mail_tracking_value.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_tracking_value.create_date IS 'Created on';


--
-- Name: COLUMN mail_tracking_value.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_tracking_value.write_date IS 'Last Updated on';


--
-- Name: COLUMN mail_tracking_value.old_value_float; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_tracking_value.old_value_float IS 'Old Value Float';


--
-- Name: COLUMN mail_tracking_value.old_value_monetary; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_tracking_value.old_value_monetary IS 'Old Value Monetary';


--
-- Name: COLUMN mail_tracking_value.new_value_float; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_tracking_value.new_value_float IS 'New Value Float';


--
-- Name: COLUMN mail_tracking_value.new_value_monetary; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_tracking_value.new_value_monetary IS 'New Value Monetary';


--
-- Name: mail_tracking_value_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.mail_tracking_value_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.mail_tracking_value_id_seq OWNER TO odoo;

--
-- Name: mail_tracking_value_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.mail_tracking_value_id_seq OWNED BY public.mail_tracking_value.id;


--
-- Name: mail_wizard_invite; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mail_wizard_invite (
    id integer NOT NULL,
    res_id integer,
    create_uid integer,
    write_uid integer,
    res_model character varying NOT NULL,
    message text,
    send_mail boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.mail_wizard_invite OWNER TO odoo;

--
-- Name: TABLE mail_wizard_invite; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.mail_wizard_invite IS 'Invite wizard';


--
-- Name: COLUMN mail_wizard_invite.res_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_wizard_invite.res_id IS 'Related Document ID';


--
-- Name: COLUMN mail_wizard_invite.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_wizard_invite.create_uid IS 'Created by';


--
-- Name: COLUMN mail_wizard_invite.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_wizard_invite.write_uid IS 'Last Updated by';


--
-- Name: COLUMN mail_wizard_invite.res_model; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_wizard_invite.res_model IS 'Related Document Model';


--
-- Name: COLUMN mail_wizard_invite.message; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_wizard_invite.message IS 'Message';


--
-- Name: COLUMN mail_wizard_invite.send_mail; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_wizard_invite.send_mail IS 'Send Email';


--
-- Name: COLUMN mail_wizard_invite.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_wizard_invite.create_date IS 'Created on';


--
-- Name: COLUMN mail_wizard_invite.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_wizard_invite.write_date IS 'Last Updated on';


--
-- Name: mail_wizard_invite_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.mail_wizard_invite_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.mail_wizard_invite_id_seq OWNER TO odoo;

--
-- Name: mail_wizard_invite_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.mail_wizard_invite_id_seq OWNED BY public.mail_wizard_invite.id;


--
-- Name: mail_wizard_invite_res_partner_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mail_wizard_invite_res_partner_rel (
    mail_wizard_invite_id integer NOT NULL,
    res_partner_id integer NOT NULL
);


ALTER TABLE public.mail_wizard_invite_res_partner_rel OWNER TO odoo;

--
-- Name: TABLE mail_wizard_invite_res_partner_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.mail_wizard_invite_res_partner_rel IS 'RELATION BETWEEN mail_wizard_invite AND res_partner';


--
-- Name: mailing_contact; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mailing_contact (
    id integer NOT NULL,
    message_main_attachment_id integer,
    message_bounce integer,
    title_id integer,
    country_id integer,
    create_uid integer,
    write_uid integer,
    email_normalized character varying,
    name character varying,
    company_name character varying,
    email character varying,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.mailing_contact OWNER TO odoo;

--
-- Name: TABLE mailing_contact; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.mailing_contact IS 'Mailing Contact';


--
-- Name: COLUMN mailing_contact.message_main_attachment_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_contact.message_main_attachment_id IS 'Main Attachment';


--
-- Name: COLUMN mailing_contact.message_bounce; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_contact.message_bounce IS 'Bounce';


--
-- Name: COLUMN mailing_contact.title_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_contact.title_id IS 'Title';


--
-- Name: COLUMN mailing_contact.country_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_contact.country_id IS 'Country';


--
-- Name: COLUMN mailing_contact.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_contact.create_uid IS 'Created by';


--
-- Name: COLUMN mailing_contact.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_contact.write_uid IS 'Last Updated by';


--
-- Name: COLUMN mailing_contact.email_normalized; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_contact.email_normalized IS 'Normalized Email';


--
-- Name: COLUMN mailing_contact.name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_contact.name IS 'Name';


--
-- Name: COLUMN mailing_contact.company_name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_contact.company_name IS 'Company Name';


--
-- Name: COLUMN mailing_contact.email; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_contact.email IS 'Email';


--
-- Name: COLUMN mailing_contact.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_contact.create_date IS 'Created on';


--
-- Name: COLUMN mailing_contact.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_contact.write_date IS 'Last Updated on';


--
-- Name: mailing_contact_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.mailing_contact_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.mailing_contact_id_seq OWNER TO odoo;

--
-- Name: mailing_contact_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.mailing_contact_id_seq OWNED BY public.mailing_contact.id;


--
-- Name: mailing_contact_import; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mailing_contact_import (
    id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    contact_list text,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.mailing_contact_import OWNER TO odoo;

--
-- Name: TABLE mailing_contact_import; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.mailing_contact_import IS 'Mailing Contact Import';


--
-- Name: COLUMN mailing_contact_import.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_contact_import.create_uid IS 'Created by';


--
-- Name: COLUMN mailing_contact_import.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_contact_import.write_uid IS 'Last Updated by';


--
-- Name: COLUMN mailing_contact_import.contact_list; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_contact_import.contact_list IS 'Contact List';


--
-- Name: COLUMN mailing_contact_import.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_contact_import.create_date IS 'Created on';


--
-- Name: COLUMN mailing_contact_import.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_contact_import.write_date IS 'Last Updated on';


--
-- Name: mailing_contact_import_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.mailing_contact_import_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.mailing_contact_import_id_seq OWNER TO odoo;

--
-- Name: mailing_contact_import_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.mailing_contact_import_id_seq OWNED BY public.mailing_contact_import.id;


--
-- Name: mailing_contact_import_mailing_list_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mailing_contact_import_mailing_list_rel (
    mailing_contact_import_id integer NOT NULL,
    mailing_list_id integer NOT NULL
);


ALTER TABLE public.mailing_contact_import_mailing_list_rel OWNER TO odoo;

--
-- Name: TABLE mailing_contact_import_mailing_list_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.mailing_contact_import_mailing_list_rel IS 'RELATION BETWEEN mailing_contact_import AND mailing_list';


--
-- Name: mailing_contact_list_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mailing_contact_list_rel (
    id integer NOT NULL,
    contact_id integer NOT NULL,
    list_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    opt_out boolean,
    unsubscription_date timestamp without time zone,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.mailing_contact_list_rel OWNER TO odoo;

--
-- Name: TABLE mailing_contact_list_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.mailing_contact_list_rel IS 'Mass Mailing Subscription Information';


--
-- Name: COLUMN mailing_contact_list_rel.contact_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_contact_list_rel.contact_id IS 'Contact';


--
-- Name: COLUMN mailing_contact_list_rel.list_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_contact_list_rel.list_id IS 'Mailing List';


--
-- Name: COLUMN mailing_contact_list_rel.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_contact_list_rel.create_uid IS 'Created by';


--
-- Name: COLUMN mailing_contact_list_rel.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_contact_list_rel.write_uid IS 'Last Updated by';


--
-- Name: COLUMN mailing_contact_list_rel.opt_out; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_contact_list_rel.opt_out IS 'Opt Out';


--
-- Name: COLUMN mailing_contact_list_rel.unsubscription_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_contact_list_rel.unsubscription_date IS 'Unsubscription Date';


--
-- Name: COLUMN mailing_contact_list_rel.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_contact_list_rel.create_date IS 'Created on';


--
-- Name: COLUMN mailing_contact_list_rel.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_contact_list_rel.write_date IS 'Last Updated on';


--
-- Name: mailing_contact_list_rel_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.mailing_contact_list_rel_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.mailing_contact_list_rel_id_seq OWNER TO odoo;

--
-- Name: mailing_contact_list_rel_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.mailing_contact_list_rel_id_seq OWNED BY public.mailing_contact_list_rel.id;


--
-- Name: mailing_contact_mailing_contact_to_list_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mailing_contact_mailing_contact_to_list_rel (
    mailing_contact_to_list_id integer NOT NULL,
    mailing_contact_id integer NOT NULL
);


ALTER TABLE public.mailing_contact_mailing_contact_to_list_rel OWNER TO odoo;

--
-- Name: TABLE mailing_contact_mailing_contact_to_list_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.mailing_contact_mailing_contact_to_list_rel IS 'RELATION BETWEEN mailing_contact_to_list AND mailing_contact';


--
-- Name: mailing_contact_res_partner_category_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mailing_contact_res_partner_category_rel (
    mailing_contact_id integer NOT NULL,
    res_partner_category_id integer NOT NULL
);


ALTER TABLE public.mailing_contact_res_partner_category_rel OWNER TO odoo;

--
-- Name: TABLE mailing_contact_res_partner_category_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.mailing_contact_res_partner_category_rel IS 'RELATION BETWEEN mailing_contact AND res_partner_category';


--
-- Name: mailing_contact_to_list; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mailing_contact_to_list (
    id integer NOT NULL,
    mailing_list_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.mailing_contact_to_list OWNER TO odoo;

--
-- Name: TABLE mailing_contact_to_list; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.mailing_contact_to_list IS 'Add Contacts to Mailing List';


--
-- Name: COLUMN mailing_contact_to_list.mailing_list_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_contact_to_list.mailing_list_id IS 'Mailing List';


--
-- Name: COLUMN mailing_contact_to_list.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_contact_to_list.create_uid IS 'Created by';


--
-- Name: COLUMN mailing_contact_to_list.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_contact_to_list.write_uid IS 'Last Updated by';


--
-- Name: COLUMN mailing_contact_to_list.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_contact_to_list.create_date IS 'Created on';


--
-- Name: COLUMN mailing_contact_to_list.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_contact_to_list.write_date IS 'Last Updated on';


--
-- Name: mailing_contact_to_list_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.mailing_contact_to_list_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.mailing_contact_to_list_id_seq OWNER TO odoo;

--
-- Name: mailing_contact_to_list_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.mailing_contact_to_list_id_seq OWNED BY public.mailing_contact_to_list.id;


--
-- Name: mailing_filter; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mailing_filter (
    id integer NOT NULL,
    create_uid integer,
    mailing_model_id integer NOT NULL,
    write_uid integer,
    name character varying NOT NULL,
    mailing_domain character varying NOT NULL,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.mailing_filter OWNER TO odoo;

--
-- Name: TABLE mailing_filter; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.mailing_filter IS 'Mailing Favorite Filters';


--
-- Name: COLUMN mailing_filter.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_filter.create_uid IS 'Saved by';


--
-- Name: COLUMN mailing_filter.mailing_model_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_filter.mailing_model_id IS 'Recipients Model';


--
-- Name: COLUMN mailing_filter.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_filter.write_uid IS 'Last Updated by';


--
-- Name: COLUMN mailing_filter.name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_filter.name IS 'Filter Name';


--
-- Name: COLUMN mailing_filter.mailing_domain; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_filter.mailing_domain IS 'Filter Domain';


--
-- Name: COLUMN mailing_filter.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_filter.create_date IS 'Created on';


--
-- Name: COLUMN mailing_filter.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_filter.write_date IS 'Last Updated on';


--
-- Name: mailing_filter_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.mailing_filter_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.mailing_filter_id_seq OWNER TO odoo;

--
-- Name: mailing_filter_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.mailing_filter_id_seq OWNED BY public.mailing_filter.id;


--
-- Name: mailing_list; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mailing_list (
    id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    name character varying NOT NULL,
    active boolean,
    is_public boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.mailing_list OWNER TO odoo;

--
-- Name: TABLE mailing_list; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.mailing_list IS 'Mailing List';


--
-- Name: COLUMN mailing_list.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_list.create_uid IS 'Created by';


--
-- Name: COLUMN mailing_list.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_list.write_uid IS 'Last Updated by';


--
-- Name: COLUMN mailing_list.name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_list.name IS 'Mailing List';


--
-- Name: COLUMN mailing_list.active; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_list.active IS 'Active';


--
-- Name: COLUMN mailing_list.is_public; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_list.is_public IS 'Show In Preferences';


--
-- Name: COLUMN mailing_list.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_list.create_date IS 'Created on';


--
-- Name: COLUMN mailing_list.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_list.write_date IS 'Last Updated on';


--
-- Name: mailing_list_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.mailing_list_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.mailing_list_id_seq OWNER TO odoo;

--
-- Name: mailing_list_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.mailing_list_id_seq OWNED BY public.mailing_list.id;


--
-- Name: mailing_list_mailing_list_merge_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mailing_list_mailing_list_merge_rel (
    mailing_list_merge_id integer NOT NULL,
    mailing_list_id integer NOT NULL
);


ALTER TABLE public.mailing_list_mailing_list_merge_rel OWNER TO odoo;

--
-- Name: TABLE mailing_list_mailing_list_merge_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.mailing_list_mailing_list_merge_rel IS 'RELATION BETWEEN mailing_list_merge AND mailing_list';


--
-- Name: mailing_list_merge; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mailing_list_merge (
    id integer NOT NULL,
    dest_list_id integer,
    create_uid integer,
    write_uid integer,
    merge_options character varying NOT NULL,
    new_list_name character varying,
    archive_src_lists boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.mailing_list_merge OWNER TO odoo;

--
-- Name: TABLE mailing_list_merge; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.mailing_list_merge IS 'Merge Mass Mailing List';


--
-- Name: COLUMN mailing_list_merge.dest_list_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_list_merge.dest_list_id IS 'Destination Mailing List';


--
-- Name: COLUMN mailing_list_merge.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_list_merge.create_uid IS 'Created by';


--
-- Name: COLUMN mailing_list_merge.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_list_merge.write_uid IS 'Last Updated by';


--
-- Name: COLUMN mailing_list_merge.merge_options; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_list_merge.merge_options IS 'Merge Option';


--
-- Name: COLUMN mailing_list_merge.new_list_name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_list_merge.new_list_name IS 'New Mailing List Name';


--
-- Name: COLUMN mailing_list_merge.archive_src_lists; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_list_merge.archive_src_lists IS 'Archive source mailing lists';


--
-- Name: COLUMN mailing_list_merge.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_list_merge.create_date IS 'Created on';


--
-- Name: COLUMN mailing_list_merge.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_list_merge.write_date IS 'Last Updated on';


--
-- Name: mailing_list_merge_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.mailing_list_merge_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.mailing_list_merge_id_seq OWNER TO odoo;

--
-- Name: mailing_list_merge_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.mailing_list_merge_id_seq OWNED BY public.mailing_list_merge.id;


--
-- Name: mailing_mailing; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mailing_mailing (
    id integer NOT NULL,
    source_id integer NOT NULL,
    message_main_attachment_id integer,
    campaign_id integer,
    medium_id integer,
    color integer,
    user_id integer,
    mailing_model_id integer NOT NULL,
    mail_server_id integer,
    mailing_filter_id integer,
    ab_testing_pc integer,
    create_uid integer,
    write_uid integer,
    lang character varying,
    subject character varying NOT NULL,
    preview character varying,
    email_from character varying NOT NULL,
    schedule_type character varying NOT NULL,
    state character varying NOT NULL,
    mailing_type character varying NOT NULL,
    reply_to_mode character varying,
    reply_to character varying,
    mailing_domain character varying,
    body_arch text,
    body_html text,
    active boolean,
    favorite boolean,
    keep_archives boolean,
    ab_testing_completed boolean,
    ab_testing_enabled boolean,
    kpi_mail_required boolean,
    favorite_date timestamp without time zone,
    sent_date timestamp without time zone,
    schedule_date timestamp without time zone,
    calendar_date timestamp without time zone,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    CONSTRAINT mailing_mailing_percentage_valid CHECK (((ab_testing_pc >= 0) AND (ab_testing_pc <= 100)))
);


ALTER TABLE public.mailing_mailing OWNER TO odoo;

--
-- Name: TABLE mailing_mailing; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.mailing_mailing IS 'Mass Mailing';


--
-- Name: COLUMN mailing_mailing.source_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_mailing.source_id IS 'Source';


--
-- Name: COLUMN mailing_mailing.message_main_attachment_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_mailing.message_main_attachment_id IS 'Main Attachment';


--
-- Name: COLUMN mailing_mailing.campaign_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_mailing.campaign_id IS 'UTM Campaign';


--
-- Name: COLUMN mailing_mailing.medium_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_mailing.medium_id IS 'Medium';


--
-- Name: COLUMN mailing_mailing.color; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_mailing.color IS 'Color Index';


--
-- Name: COLUMN mailing_mailing.user_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_mailing.user_id IS 'Responsible';


--
-- Name: COLUMN mailing_mailing.mailing_model_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_mailing.mailing_model_id IS 'Recipients Model';


--
-- Name: COLUMN mailing_mailing.mail_server_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_mailing.mail_server_id IS 'Mail Server';


--
-- Name: COLUMN mailing_mailing.mailing_filter_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_mailing.mailing_filter_id IS 'Favorite Filter';


--
-- Name: COLUMN mailing_mailing.ab_testing_pc; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_mailing.ab_testing_pc IS 'A/B Testing percentage';


--
-- Name: COLUMN mailing_mailing.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_mailing.create_uid IS 'Created by';


--
-- Name: COLUMN mailing_mailing.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_mailing.write_uid IS 'Last Updated by';


--
-- Name: COLUMN mailing_mailing.lang; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_mailing.lang IS 'Language';


--
-- Name: COLUMN mailing_mailing.subject; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_mailing.subject IS 'Subject';


--
-- Name: COLUMN mailing_mailing.preview; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_mailing.preview IS 'Preview';


--
-- Name: COLUMN mailing_mailing.email_from; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_mailing.email_from IS 'Send From';


--
-- Name: COLUMN mailing_mailing.schedule_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_mailing.schedule_type IS 'Schedule';


--
-- Name: COLUMN mailing_mailing.state; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_mailing.state IS 'Status';


--
-- Name: COLUMN mailing_mailing.mailing_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_mailing.mailing_type IS 'Mailing Type';


--
-- Name: COLUMN mailing_mailing.reply_to_mode; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_mailing.reply_to_mode IS 'Reply-To Mode';


--
-- Name: COLUMN mailing_mailing.reply_to; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_mailing.reply_to IS 'Reply To';


--
-- Name: COLUMN mailing_mailing.mailing_domain; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_mailing.mailing_domain IS 'Domain';


--
-- Name: COLUMN mailing_mailing.body_arch; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_mailing.body_arch IS 'Body';


--
-- Name: COLUMN mailing_mailing.body_html; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_mailing.body_html IS 'Body converted to be sent by mail';


--
-- Name: COLUMN mailing_mailing.active; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_mailing.active IS 'Active';


--
-- Name: COLUMN mailing_mailing.favorite; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_mailing.favorite IS 'Favorite';


--
-- Name: COLUMN mailing_mailing.keep_archives; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_mailing.keep_archives IS 'Keep Archives';


--
-- Name: COLUMN mailing_mailing.ab_testing_completed; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_mailing.ab_testing_completed IS 'A/B Testing Campaign Finished';


--
-- Name: COLUMN mailing_mailing.ab_testing_enabled; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_mailing.ab_testing_enabled IS 'Allow A/B Testing';


--
-- Name: COLUMN mailing_mailing.kpi_mail_required; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_mailing.kpi_mail_required IS 'KPI mail required';


--
-- Name: COLUMN mailing_mailing.favorite_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_mailing.favorite_date IS 'Favorite Date';


--
-- Name: COLUMN mailing_mailing.sent_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_mailing.sent_date IS 'Sent Date';


--
-- Name: COLUMN mailing_mailing.schedule_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_mailing.schedule_date IS 'Scheduled for';


--
-- Name: COLUMN mailing_mailing.calendar_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_mailing.calendar_date IS 'Calendar Date';


--
-- Name: COLUMN mailing_mailing.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_mailing.create_date IS 'Created on';


--
-- Name: COLUMN mailing_mailing.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_mailing.write_date IS 'Last Updated on';


--
-- Name: CONSTRAINT mailing_mailing_percentage_valid ON mailing_mailing; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT mailing_mailing_percentage_valid ON public.mailing_mailing IS 'CHECK(ab_testing_pc >= 0 AND ab_testing_pc <= 100)';


--
-- Name: mailing_mailing_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.mailing_mailing_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.mailing_mailing_id_seq OWNER TO odoo;

--
-- Name: mailing_mailing_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.mailing_mailing_id_seq OWNED BY public.mailing_mailing.id;


--
-- Name: mailing_mailing_schedule_date; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mailing_mailing_schedule_date (
    id integer NOT NULL,
    mass_mailing_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    schedule_date timestamp without time zone,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.mailing_mailing_schedule_date OWNER TO odoo;

--
-- Name: TABLE mailing_mailing_schedule_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.mailing_mailing_schedule_date IS 'schedule a mailing';


--
-- Name: COLUMN mailing_mailing_schedule_date.mass_mailing_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_mailing_schedule_date.mass_mailing_id IS 'Mass Mailing';


--
-- Name: COLUMN mailing_mailing_schedule_date.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_mailing_schedule_date.create_uid IS 'Created by';


--
-- Name: COLUMN mailing_mailing_schedule_date.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_mailing_schedule_date.write_uid IS 'Last Updated by';


--
-- Name: COLUMN mailing_mailing_schedule_date.schedule_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_mailing_schedule_date.schedule_date IS 'Scheduled for';


--
-- Name: COLUMN mailing_mailing_schedule_date.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_mailing_schedule_date.create_date IS 'Created on';


--
-- Name: COLUMN mailing_mailing_schedule_date.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_mailing_schedule_date.write_date IS 'Last Updated on';


--
-- Name: mailing_mailing_schedule_date_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.mailing_mailing_schedule_date_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.mailing_mailing_schedule_date_id_seq OWNER TO odoo;

--
-- Name: mailing_mailing_schedule_date_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.mailing_mailing_schedule_date_id_seq OWNED BY public.mailing_mailing_schedule_date.id;


--
-- Name: mailing_mailing_test; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mailing_mailing_test (
    id integer NOT NULL,
    mass_mailing_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    email_to text NOT NULL,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.mailing_mailing_test OWNER TO odoo;

--
-- Name: TABLE mailing_mailing_test; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.mailing_mailing_test IS 'Sample Mail Wizard';


--
-- Name: COLUMN mailing_mailing_test.mass_mailing_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_mailing_test.mass_mailing_id IS 'Mailing';


--
-- Name: COLUMN mailing_mailing_test.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_mailing_test.create_uid IS 'Created by';


--
-- Name: COLUMN mailing_mailing_test.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_mailing_test.write_uid IS 'Last Updated by';


--
-- Name: COLUMN mailing_mailing_test.email_to; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_mailing_test.email_to IS 'Recipients';


--
-- Name: COLUMN mailing_mailing_test.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_mailing_test.create_date IS 'Created on';


--
-- Name: COLUMN mailing_mailing_test.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_mailing_test.write_date IS 'Last Updated on';


--
-- Name: mailing_mailing_test_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.mailing_mailing_test_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.mailing_mailing_test_id_seq OWNER TO odoo;

--
-- Name: mailing_mailing_test_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.mailing_mailing_test_id_seq OWNED BY public.mailing_mailing_test.id;


--
-- Name: mailing_trace; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mailing_trace (
    id integer NOT NULL,
    mail_mail_id integer,
    mail_mail_id_int integer,
    res_id integer,
    mass_mailing_id integer,
    campaign_id integer,
    create_uid integer,
    write_uid integer,
    trace_type character varying NOT NULL,
    email character varying,
    message_id character varying,
    model character varying NOT NULL,
    trace_status character varying,
    failure_type character varying,
    sent_datetime timestamp without time zone,
    open_datetime timestamp without time zone,
    reply_datetime timestamp without time zone,
    links_click_datetime timestamp without time zone,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    CONSTRAINT mailing_trace_check_res_id_is_set CHECK (((res_id IS NOT NULL) AND (res_id <> 0)))
);


ALTER TABLE public.mailing_trace OWNER TO odoo;

--
-- Name: TABLE mailing_trace; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.mailing_trace IS 'Mailing Statistics';


--
-- Name: COLUMN mailing_trace.mail_mail_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_trace.mail_mail_id IS 'Mail';


--
-- Name: COLUMN mailing_trace.mail_mail_id_int; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_trace.mail_mail_id_int IS 'Mail ID (tech)';


--
-- Name: COLUMN mailing_trace.res_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_trace.res_id IS 'Document ID';


--
-- Name: COLUMN mailing_trace.mass_mailing_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_trace.mass_mailing_id IS 'Mailing';


--
-- Name: COLUMN mailing_trace.campaign_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_trace.campaign_id IS 'Campaign';


--
-- Name: COLUMN mailing_trace.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_trace.create_uid IS 'Created by';


--
-- Name: COLUMN mailing_trace.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_trace.write_uid IS 'Last Updated by';


--
-- Name: COLUMN mailing_trace.trace_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_trace.trace_type IS 'Type';


--
-- Name: COLUMN mailing_trace.email; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_trace.email IS 'Email';


--
-- Name: COLUMN mailing_trace.message_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_trace.message_id IS 'Message-ID';


--
-- Name: COLUMN mailing_trace.model; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_trace.model IS 'Document model';


--
-- Name: COLUMN mailing_trace.trace_status; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_trace.trace_status IS 'Status';


--
-- Name: COLUMN mailing_trace.failure_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_trace.failure_type IS 'Failure type';


--
-- Name: COLUMN mailing_trace.sent_datetime; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_trace.sent_datetime IS 'Sent On';


--
-- Name: COLUMN mailing_trace.open_datetime; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_trace.open_datetime IS 'Opened On';


--
-- Name: COLUMN mailing_trace.reply_datetime; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_trace.reply_datetime IS 'Replied On';


--
-- Name: COLUMN mailing_trace.links_click_datetime; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_trace.links_click_datetime IS 'Clicked On';


--
-- Name: COLUMN mailing_trace.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_trace.create_date IS 'Created on';


--
-- Name: COLUMN mailing_trace.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mailing_trace.write_date IS 'Last Updated on';


--
-- Name: CONSTRAINT mailing_trace_check_res_id_is_set ON mailing_trace; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT mailing_trace_check_res_id_is_set ON public.mailing_trace IS 'CHECK(res_id IS NOT NULL AND res_id !=0 )';


--
-- Name: mailing_trace_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.mailing_trace_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.mailing_trace_id_seq OWNER TO odoo;

--
-- Name: mailing_trace_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.mailing_trace_id_seq OWNED BY public.mailing_trace.id;


--
-- Name: utm_campaign; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.utm_campaign (
    id integer NOT NULL,
    user_id integer NOT NULL,
    stage_id integer NOT NULL,
    color integer,
    create_uid integer,
    write_uid integer,
    name character varying NOT NULL,
    title jsonb NOT NULL,
    is_auto_campaign boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    company_id integer,
    ab_testing_total_pc integer,
    ab_testing_winner_selection character varying,
    ab_testing_completed boolean,
    ab_testing_schedule_datetime timestamp without time zone
);


ALTER TABLE public.utm_campaign OWNER TO odoo;

--
-- Name: TABLE utm_campaign; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.utm_campaign IS 'UTM Campaign';


--
-- Name: COLUMN utm_campaign.user_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.utm_campaign.user_id IS 'Responsible';


--
-- Name: COLUMN utm_campaign.stage_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.utm_campaign.stage_id IS 'Stage';


--
-- Name: COLUMN utm_campaign.color; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.utm_campaign.color IS 'Color Index';


--
-- Name: COLUMN utm_campaign.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.utm_campaign.create_uid IS 'Created by';


--
-- Name: COLUMN utm_campaign.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.utm_campaign.write_uid IS 'Last Updated by';


--
-- Name: COLUMN utm_campaign.name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.utm_campaign.name IS 'Campaign Identifier';


--
-- Name: COLUMN utm_campaign.title; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.utm_campaign.title IS 'Campaign Name';


--
-- Name: COLUMN utm_campaign.is_auto_campaign; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.utm_campaign.is_auto_campaign IS 'Automatically Generated Campaign';


--
-- Name: COLUMN utm_campaign.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.utm_campaign.create_date IS 'Created on';


--
-- Name: COLUMN utm_campaign.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.utm_campaign.write_date IS 'Last Updated on';


--
-- Name: COLUMN utm_campaign.company_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.utm_campaign.company_id IS 'Company';


--
-- Name: COLUMN utm_campaign.ab_testing_total_pc; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.utm_campaign.ab_testing_total_pc IS 'Total A/B test percentage';


--
-- Name: COLUMN utm_campaign.ab_testing_winner_selection; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.utm_campaign.ab_testing_winner_selection IS 'Winner Selection';


--
-- Name: COLUMN utm_campaign.ab_testing_completed; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.utm_campaign.ab_testing_completed IS 'A/B Testing Campaign Finished';


--
-- Name: COLUMN utm_campaign.ab_testing_schedule_datetime; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.utm_campaign.ab_testing_schedule_datetime IS 'Send Final On';


--
-- Name: utm_source; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.utm_source (
    id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    name character varying NOT NULL,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.utm_source OWNER TO odoo;

--
-- Name: TABLE utm_source; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.utm_source IS 'UTM Source';


--
-- Name: COLUMN utm_source.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.utm_source.create_uid IS 'Created by';


--
-- Name: COLUMN utm_source.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.utm_source.write_uid IS 'Last Updated by';


--
-- Name: COLUMN utm_source.name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.utm_source.name IS 'Source Name';


--
-- Name: COLUMN utm_source.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.utm_source.create_date IS 'Created on';


--
-- Name: COLUMN utm_source.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.utm_source.write_date IS 'Last Updated on';


--
-- Name: mailing_trace_report; Type: VIEW; Schema: public; Owner: odoo
--

CREATE VIEW public.mailing_trace_report AS
 SELECT min(trace.id) AS id,
    utm_source.name,
    mailing.mailing_type,
    utm_campaign.name AS campaign,
    trace.create_date AS scheduled_date,
    mailing.state,
    mailing.email_from,
    count(trace.id) AS scheduled,
    count(trace.sent_datetime) AS sent,
    (count(trace.id) - count(trace.trace_status) FILTER (WHERE ((trace.trace_status)::text = ANY ((ARRAY['error'::character varying, 'bounce'::character varying, 'cancel'::character varying])::text[])))) AS delivered,
    count(trace.trace_status) FILTER (WHERE ((trace.trace_status)::text = 'error'::text)) AS error,
    count(trace.trace_status) FILTER (WHERE ((trace.trace_status)::text = 'bounce'::text)) AS bounced,
    count(trace.trace_status) FILTER (WHERE ((trace.trace_status)::text = 'cancel'::text)) AS canceled,
    count(trace.trace_status) FILTER (WHERE ((trace.trace_status)::text = 'open'::text)) AS opened,
    count(trace.trace_status) FILTER (WHERE ((trace.trace_status)::text = 'reply'::text)) AS replied,
    count(trace.links_click_datetime) AS clicked
   FROM (((public.mailing_trace trace
     LEFT JOIN public.mailing_mailing mailing ON ((trace.mass_mailing_id = mailing.id)))
     LEFT JOIN public.utm_campaign utm_campaign ON ((mailing.campaign_id = utm_campaign.id)))
     LEFT JOIN public.utm_source utm_source ON ((mailing.source_id = utm_source.id)))
  GROUP BY trace.create_date, utm_source.name, utm_campaign.name, mailing.mailing_type, mailing.state, mailing.email_from;


ALTER TABLE public.mailing_trace_report OWNER TO odoo;

--
-- Name: mass_mailing_ir_attachments_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mass_mailing_ir_attachments_rel (
    mass_mailing_id integer NOT NULL,
    attachment_id integer NOT NULL
);


ALTER TABLE public.mass_mailing_ir_attachments_rel OWNER TO odoo;

--
-- Name: TABLE mass_mailing_ir_attachments_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.mass_mailing_ir_attachments_rel IS 'RELATION BETWEEN mailing_mailing AND ir_attachment';


--
-- Name: meeting_category_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.meeting_category_rel (
    event_id integer NOT NULL,
    type_id integer NOT NULL
);


ALTER TABLE public.meeting_category_rel OWNER TO odoo;

--
-- Name: TABLE meeting_category_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.meeting_category_rel IS 'RELATION BETWEEN calendar_event AND calendar_event_type';


--
-- Name: merge_opportunity_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.merge_opportunity_rel (
    merge_id integer NOT NULL,
    opportunity_id integer NOT NULL
);


ALTER TABLE public.merge_opportunity_rel OWNER TO odoo;

--
-- Name: TABLE merge_opportunity_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.merge_opportunity_rel IS 'RELATION BETWEEN crm_merge_opportunity AND crm_lead';


--
-- Name: message_attachment_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.message_attachment_rel (
    message_id integer NOT NULL,
    attachment_id integer NOT NULL
);


ALTER TABLE public.message_attachment_rel OWNER TO odoo;

--
-- Name: TABLE message_attachment_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.message_attachment_rel IS 'RELATION BETWEEN mail_message AND ir_attachment';


--
-- Name: note_note; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.note_note (
    id integer NOT NULL,
    message_main_attachment_id integer,
    company_id integer,
    user_id integer,
    sequence integer,
    color integer,
    create_uid integer,
    write_uid integer,
    date_done date,
    name text,
    memo text,
    open boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.note_note OWNER TO odoo;

--
-- Name: TABLE note_note; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.note_note IS 'Note';


--
-- Name: COLUMN note_note.message_main_attachment_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.note_note.message_main_attachment_id IS 'Main Attachment';


--
-- Name: COLUMN note_note.company_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.note_note.company_id IS 'Company';


--
-- Name: COLUMN note_note.user_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.note_note.user_id IS 'Owner';


--
-- Name: COLUMN note_note.sequence; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.note_note.sequence IS 'Sequence';


--
-- Name: COLUMN note_note.color; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.note_note.color IS 'Color Index';


--
-- Name: COLUMN note_note.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.note_note.create_uid IS 'Created by';


--
-- Name: COLUMN note_note.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.note_note.write_uid IS 'Last Updated by';


--
-- Name: COLUMN note_note.date_done; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.note_note.date_done IS 'Date done';


--
-- Name: COLUMN note_note.name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.note_note.name IS 'Note Summary';


--
-- Name: COLUMN note_note.memo; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.note_note.memo IS 'Note Content';


--
-- Name: COLUMN note_note.open; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.note_note.open IS 'Active';


--
-- Name: COLUMN note_note.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.note_note.create_date IS 'Created on';


--
-- Name: COLUMN note_note.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.note_note.write_date IS 'Last Updated on';


--
-- Name: note_note_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.note_note_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.note_note_id_seq OWNER TO odoo;

--
-- Name: note_note_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.note_note_id_seq OWNED BY public.note_note.id;


--
-- Name: note_stage; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.note_stage (
    id integer NOT NULL,
    sequence integer,
    user_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    name jsonb NOT NULL,
    fold boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.note_stage OWNER TO odoo;

--
-- Name: TABLE note_stage; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.note_stage IS 'Note Stage';


--
-- Name: COLUMN note_stage.sequence; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.note_stage.sequence IS 'Sequence';


--
-- Name: COLUMN note_stage.user_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.note_stage.user_id IS 'Owner';


--
-- Name: COLUMN note_stage.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.note_stage.create_uid IS 'Created by';


--
-- Name: COLUMN note_stage.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.note_stage.write_uid IS 'Last Updated by';


--
-- Name: COLUMN note_stage.name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.note_stage.name IS 'Stage Name';


--
-- Name: COLUMN note_stage.fold; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.note_stage.fold IS 'Folded by Default';


--
-- Name: COLUMN note_stage.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.note_stage.create_date IS 'Created on';


--
-- Name: COLUMN note_stage.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.note_stage.write_date IS 'Last Updated on';


--
-- Name: note_stage_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.note_stage_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.note_stage_id_seq OWNER TO odoo;

--
-- Name: note_stage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.note_stage_id_seq OWNED BY public.note_stage.id;


--
-- Name: note_stage_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.note_stage_rel (
    note_id integer NOT NULL,
    stage_id integer NOT NULL
);


ALTER TABLE public.note_stage_rel OWNER TO odoo;

--
-- Name: TABLE note_stage_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.note_stage_rel IS 'RELATION BETWEEN note_note AND note_stage';


--
-- Name: note_tag; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.note_tag (
    id integer NOT NULL,
    color integer,
    create_uid integer,
    write_uid integer,
    name jsonb NOT NULL,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.note_tag OWNER TO odoo;

--
-- Name: TABLE note_tag; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.note_tag IS 'Note Tag';


--
-- Name: COLUMN note_tag.color; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.note_tag.color IS 'Color Index';


--
-- Name: COLUMN note_tag.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.note_tag.create_uid IS 'Created by';


--
-- Name: COLUMN note_tag.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.note_tag.write_uid IS 'Last Updated by';


--
-- Name: COLUMN note_tag.name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.note_tag.name IS 'Tag Name';


--
-- Name: COLUMN note_tag.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.note_tag.create_date IS 'Created on';


--
-- Name: COLUMN note_tag.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.note_tag.write_date IS 'Last Updated on';


--
-- Name: note_tag_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.note_tag_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.note_tag_id_seq OWNER TO odoo;

--
-- Name: note_tag_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.note_tag_id_seq OWNED BY public.note_tag.id;


--
-- Name: note_tags_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.note_tags_rel (
    note_id integer NOT NULL,
    tag_id integer NOT NULL
);


ALTER TABLE public.note_tags_rel OWNER TO odoo;

--
-- Name: TABLE note_tags_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.note_tags_rel IS 'RELATION BETWEEN note_note AND note_tag';


--
-- Name: payment_country_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.payment_country_rel (
    payment_id integer NOT NULL,
    country_id integer NOT NULL
);


ALTER TABLE public.payment_country_rel OWNER TO odoo;

--
-- Name: TABLE payment_country_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.payment_country_rel IS 'RELATION BETWEEN payment_provider AND res_country';


--
-- Name: payment_icon; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.payment_icon (
    id integer NOT NULL,
    sequence integer,
    create_uid integer,
    write_uid integer,
    name character varying,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.payment_icon OWNER TO odoo;

--
-- Name: TABLE payment_icon; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.payment_icon IS 'Payment Icon';


--
-- Name: COLUMN payment_icon.sequence; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_icon.sequence IS 'Sequence';


--
-- Name: COLUMN payment_icon.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_icon.create_uid IS 'Created by';


--
-- Name: COLUMN payment_icon.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_icon.write_uid IS 'Last Updated by';


--
-- Name: COLUMN payment_icon.name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_icon.name IS 'Name';


--
-- Name: COLUMN payment_icon.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_icon.create_date IS 'Created on';


--
-- Name: COLUMN payment_icon.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_icon.write_date IS 'Last Updated on';


--
-- Name: payment_icon_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.payment_icon_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.payment_icon_id_seq OWNER TO odoo;

--
-- Name: payment_icon_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.payment_icon_id_seq OWNED BY public.payment_icon.id;


--
-- Name: payment_icon_payment_provider_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.payment_icon_payment_provider_rel (
    payment_provider_id integer NOT NULL,
    payment_icon_id integer NOT NULL
);


ALTER TABLE public.payment_icon_payment_provider_rel OWNER TO odoo;

--
-- Name: TABLE payment_icon_payment_provider_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.payment_icon_payment_provider_rel IS 'RELATION BETWEEN payment_provider AND payment_icon';


--
-- Name: payment_link_wizard; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.payment_link_wizard (
    id integer NOT NULL,
    res_id integer NOT NULL,
    currency_id integer,
    partner_id integer,
    create_uid integer,
    write_uid integer,
    res_model character varying NOT NULL,
    description character varying,
    payment_provider_selection character varying NOT NULL,
    amount numeric NOT NULL,
    amount_max numeric,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.payment_link_wizard OWNER TO odoo;

--
-- Name: TABLE payment_link_wizard; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.payment_link_wizard IS 'Generate Payment Link';


--
-- Name: COLUMN payment_link_wizard.res_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_link_wizard.res_id IS 'Related Document ID';


--
-- Name: COLUMN payment_link_wizard.currency_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_link_wizard.currency_id IS 'Currency';


--
-- Name: COLUMN payment_link_wizard.partner_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_link_wizard.partner_id IS 'Partner';


--
-- Name: COLUMN payment_link_wizard.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_link_wizard.create_uid IS 'Created by';


--
-- Name: COLUMN payment_link_wizard.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_link_wizard.write_uid IS 'Last Updated by';


--
-- Name: COLUMN payment_link_wizard.res_model; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_link_wizard.res_model IS 'Related Document Model';


--
-- Name: COLUMN payment_link_wizard.description; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_link_wizard.description IS 'Payment Ref';


--
-- Name: COLUMN payment_link_wizard.payment_provider_selection; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_link_wizard.payment_provider_selection IS 'Allow Payment Provider';


--
-- Name: COLUMN payment_link_wizard.amount; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_link_wizard.amount IS 'Amount';


--
-- Name: COLUMN payment_link_wizard.amount_max; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_link_wizard.amount_max IS 'Amount Max';


--
-- Name: COLUMN payment_link_wizard.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_link_wizard.create_date IS 'Created on';


--
-- Name: COLUMN payment_link_wizard.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_link_wizard.write_date IS 'Last Updated on';


--
-- Name: payment_link_wizard_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.payment_link_wizard_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.payment_link_wizard_id_seq OWNER TO odoo;

--
-- Name: payment_link_wizard_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.payment_link_wizard_id_seq OWNED BY public.payment_link_wizard.id;


--
-- Name: payment_provider; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.payment_provider (
    id integer NOT NULL,
    sequence integer,
    company_id integer NOT NULL,
    redirect_form_view_id integer,
    inline_form_view_id integer,
    token_inline_form_view_id integer,
    express_checkout_form_view_id integer,
    color integer,
    module_id integer,
    create_uid integer,
    write_uid integer,
    code character varying NOT NULL,
    state character varying NOT NULL,
    module_state character varying,
    name jsonb NOT NULL,
    display_as jsonb,
    pre_msg jsonb,
    pending_msg jsonb,
    auth_msg jsonb,
    done_msg jsonb,
    cancel_msg jsonb,
    maximum_amount numeric,
    is_published boolean,
    allow_tokenization boolean,
    capture_manually boolean,
    allow_express_checkout boolean,
    fees_active boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    fees_dom_fixed double precision,
    fees_dom_var double precision,
    fees_int_fixed double precision,
    fees_int_var double precision,
    so_reference_type character varying,
    website_id integer
);


ALTER TABLE public.payment_provider OWNER TO odoo;

--
-- Name: TABLE payment_provider; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.payment_provider IS 'Payment Provider';


--
-- Name: COLUMN payment_provider.sequence; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_provider.sequence IS 'Sequence';


--
-- Name: COLUMN payment_provider.company_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_provider.company_id IS 'Company';


--
-- Name: COLUMN payment_provider.redirect_form_view_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_provider.redirect_form_view_id IS 'Redirect Form Template';


--
-- Name: COLUMN payment_provider.inline_form_view_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_provider.inline_form_view_id IS 'Inline Form Template';


--
-- Name: COLUMN payment_provider.token_inline_form_view_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_provider.token_inline_form_view_id IS 'Token Inline Form Template';


--
-- Name: COLUMN payment_provider.express_checkout_form_view_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_provider.express_checkout_form_view_id IS 'Express Checkout Form Template';


--
-- Name: COLUMN payment_provider.color; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_provider.color IS 'Color';


--
-- Name: COLUMN payment_provider.module_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_provider.module_id IS 'Corresponding Module';


--
-- Name: COLUMN payment_provider.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_provider.create_uid IS 'Created by';


--
-- Name: COLUMN payment_provider.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_provider.write_uid IS 'Last Updated by';


--
-- Name: COLUMN payment_provider.code; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_provider.code IS 'Code';


--
-- Name: COLUMN payment_provider.state; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_provider.state IS 'State';


--
-- Name: COLUMN payment_provider.module_state; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_provider.module_state IS 'Installation State';


--
-- Name: COLUMN payment_provider.name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_provider.name IS 'Name';


--
-- Name: COLUMN payment_provider.display_as; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_provider.display_as IS 'Displayed as';


--
-- Name: COLUMN payment_provider.pre_msg; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_provider.pre_msg IS 'Help Message';


--
-- Name: COLUMN payment_provider.pending_msg; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_provider.pending_msg IS 'Pending Message';


--
-- Name: COLUMN payment_provider.auth_msg; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_provider.auth_msg IS 'Authorize Message';


--
-- Name: COLUMN payment_provider.done_msg; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_provider.done_msg IS 'Done Message';


--
-- Name: COLUMN payment_provider.cancel_msg; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_provider.cancel_msg IS 'Canceled Message';


--
-- Name: COLUMN payment_provider.maximum_amount; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_provider.maximum_amount IS 'Maximum Amount';


--
-- Name: COLUMN payment_provider.is_published; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_provider.is_published IS 'Published';


--
-- Name: COLUMN payment_provider.allow_tokenization; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_provider.allow_tokenization IS 'Allow Saving Payment Methods';


--
-- Name: COLUMN payment_provider.capture_manually; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_provider.capture_manually IS 'Capture Amount Manually';


--
-- Name: COLUMN payment_provider.allow_express_checkout; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_provider.allow_express_checkout IS 'Allow Express Checkout';


--
-- Name: COLUMN payment_provider.fees_active; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_provider.fees_active IS 'Add Extra Fees';


--
-- Name: COLUMN payment_provider.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_provider.create_date IS 'Created on';


--
-- Name: COLUMN payment_provider.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_provider.write_date IS 'Last Updated on';


--
-- Name: COLUMN payment_provider.fees_dom_fixed; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_provider.fees_dom_fixed IS 'Fixed domestic fees';


--
-- Name: COLUMN payment_provider.fees_dom_var; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_provider.fees_dom_var IS 'Variable domestic fees (in percents)';


--
-- Name: COLUMN payment_provider.fees_int_fixed; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_provider.fees_int_fixed IS 'Fixed international fees';


--
-- Name: COLUMN payment_provider.fees_int_var; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_provider.fees_int_var IS 'Variable international fees (in percents)';


--
-- Name: COLUMN payment_provider.so_reference_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_provider.so_reference_type IS 'Communication';


--
-- Name: COLUMN payment_provider.website_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_provider.website_id IS 'Website';


--
-- Name: payment_provider_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.payment_provider_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.payment_provider_id_seq OWNER TO odoo;

--
-- Name: payment_provider_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.payment_provider_id_seq OWNED BY public.payment_provider.id;


--
-- Name: payment_provider_onboarding_wizard; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.payment_provider_onboarding_wizard (
    id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    payment_method character varying,
    paypal_user_type character varying,
    paypal_email_account character varying,
    paypal_seller_account character varying,
    paypal_pdt_token character varying,
    manual_name character varying,
    journal_name character varying,
    acc_number character varying,
    manual_post_msg text,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.payment_provider_onboarding_wizard OWNER TO odoo;

--
-- Name: TABLE payment_provider_onboarding_wizard; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.payment_provider_onboarding_wizard IS 'Payment provider onboarding wizard';


--
-- Name: COLUMN payment_provider_onboarding_wizard.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_provider_onboarding_wizard.create_uid IS 'Created by';


--
-- Name: COLUMN payment_provider_onboarding_wizard.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_provider_onboarding_wizard.write_uid IS 'Last Updated by';


--
-- Name: COLUMN payment_provider_onboarding_wizard.payment_method; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_provider_onboarding_wizard.payment_method IS 'Payment Method';


--
-- Name: COLUMN payment_provider_onboarding_wizard.paypal_user_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_provider_onboarding_wizard.paypal_user_type IS 'Paypal User Type';


--
-- Name: COLUMN payment_provider_onboarding_wizard.paypal_email_account; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_provider_onboarding_wizard.paypal_email_account IS 'Email';


--
-- Name: COLUMN payment_provider_onboarding_wizard.paypal_seller_account; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_provider_onboarding_wizard.paypal_seller_account IS 'Merchant Account ID';


--
-- Name: COLUMN payment_provider_onboarding_wizard.paypal_pdt_token; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_provider_onboarding_wizard.paypal_pdt_token IS 'PDT Identity Token';


--
-- Name: COLUMN payment_provider_onboarding_wizard.manual_name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_provider_onboarding_wizard.manual_name IS 'Method';


--
-- Name: COLUMN payment_provider_onboarding_wizard.journal_name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_provider_onboarding_wizard.journal_name IS 'Bank Name';


--
-- Name: COLUMN payment_provider_onboarding_wizard.acc_number; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_provider_onboarding_wizard.acc_number IS 'Account Number';


--
-- Name: COLUMN payment_provider_onboarding_wizard.manual_post_msg; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_provider_onboarding_wizard.manual_post_msg IS 'Payment Instructions';


--
-- Name: COLUMN payment_provider_onboarding_wizard.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_provider_onboarding_wizard.create_date IS 'Created on';


--
-- Name: COLUMN payment_provider_onboarding_wizard.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_provider_onboarding_wizard.write_date IS 'Last Updated on';


--
-- Name: payment_provider_onboarding_wizard_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.payment_provider_onboarding_wizard_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.payment_provider_onboarding_wizard_id_seq OWNER TO odoo;

--
-- Name: payment_provider_onboarding_wizard_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.payment_provider_onboarding_wizard_id_seq OWNED BY public.payment_provider_onboarding_wizard.id;


--
-- Name: payment_refund_wizard; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.payment_refund_wizard (
    id integer NOT NULL,
    payment_id integer,
    create_uid integer,
    write_uid integer,
    amount_to_refund numeric,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.payment_refund_wizard OWNER TO odoo;

--
-- Name: TABLE payment_refund_wizard; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.payment_refund_wizard IS 'Payment Refund Wizard';


--
-- Name: COLUMN payment_refund_wizard.payment_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_refund_wizard.payment_id IS 'Payment';


--
-- Name: COLUMN payment_refund_wizard.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_refund_wizard.create_uid IS 'Created by';


--
-- Name: COLUMN payment_refund_wizard.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_refund_wizard.write_uid IS 'Last Updated by';


--
-- Name: COLUMN payment_refund_wizard.amount_to_refund; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_refund_wizard.amount_to_refund IS 'Refund Amount';


--
-- Name: COLUMN payment_refund_wizard.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_refund_wizard.create_date IS 'Created on';


--
-- Name: COLUMN payment_refund_wizard.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_refund_wizard.write_date IS 'Last Updated on';


--
-- Name: payment_refund_wizard_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.payment_refund_wizard_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.payment_refund_wizard_id_seq OWNER TO odoo;

--
-- Name: payment_refund_wizard_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.payment_refund_wizard_id_seq OWNED BY public.payment_refund_wizard.id;


--
-- Name: payment_token; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.payment_token (
    id integer NOT NULL,
    provider_id integer NOT NULL,
    partner_id integer NOT NULL,
    company_id integer,
    create_uid integer,
    write_uid integer,
    payment_details character varying,
    provider_ref character varying NOT NULL,
    verified boolean,
    active boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.payment_token OWNER TO odoo;

--
-- Name: TABLE payment_token; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.payment_token IS 'Payment Token';


--
-- Name: COLUMN payment_token.provider_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_token.provider_id IS 'Provider';


--
-- Name: COLUMN payment_token.partner_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_token.partner_id IS 'Partner';


--
-- Name: COLUMN payment_token.company_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_token.company_id IS 'Company';


--
-- Name: COLUMN payment_token.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_token.create_uid IS 'Created by';


--
-- Name: COLUMN payment_token.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_token.write_uid IS 'Last Updated by';


--
-- Name: COLUMN payment_token.payment_details; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_token.payment_details IS 'Payment Details';


--
-- Name: COLUMN payment_token.provider_ref; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_token.provider_ref IS 'Provider Reference';


--
-- Name: COLUMN payment_token.verified; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_token.verified IS 'Verified';


--
-- Name: COLUMN payment_token.active; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_token.active IS 'Active';


--
-- Name: COLUMN payment_token.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_token.create_date IS 'Created on';


--
-- Name: COLUMN payment_token.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_token.write_date IS 'Last Updated on';


--
-- Name: payment_token_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.payment_token_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.payment_token_id_seq OWNER TO odoo;

--
-- Name: payment_token_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.payment_token_id_seq OWNED BY public.payment_token.id;


--
-- Name: payment_transaction; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.payment_transaction (
    id integer NOT NULL,
    provider_id integer NOT NULL,
    company_id integer,
    currency_id integer NOT NULL,
    token_id integer,
    source_transaction_id integer,
    callback_model_id integer,
    callback_res_id integer,
    partner_id integer NOT NULL,
    partner_state_id integer,
    partner_country_id integer,
    create_uid integer,
    write_uid integer,
    reference character varying NOT NULL,
    provider_reference character varying,
    state character varying NOT NULL,
    operation character varying,
    landing_route character varying,
    callback_method character varying,
    callback_hash character varying,
    partner_name character varying,
    partner_lang character varying,
    partner_email character varying,
    partner_address character varying,
    partner_zip character varying,
    partner_city character varying,
    partner_phone character varying,
    state_message text,
    amount numeric NOT NULL,
    fees numeric,
    is_post_processed boolean,
    tokenize boolean,
    callback_is_done boolean,
    last_state_change timestamp without time zone,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    payment_id integer,
    is_donation boolean
);


ALTER TABLE public.payment_transaction OWNER TO odoo;

--
-- Name: TABLE payment_transaction; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.payment_transaction IS 'Payment Transaction';


--
-- Name: COLUMN payment_transaction.provider_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_transaction.provider_id IS 'Provider';


--
-- Name: COLUMN payment_transaction.company_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_transaction.company_id IS 'Company';


--
-- Name: COLUMN payment_transaction.currency_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_transaction.currency_id IS 'Currency';


--
-- Name: COLUMN payment_transaction.token_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_transaction.token_id IS 'Payment Token';


--
-- Name: COLUMN payment_transaction.source_transaction_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_transaction.source_transaction_id IS 'Source Transaction';


--
-- Name: COLUMN payment_transaction.callback_model_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_transaction.callback_model_id IS 'Callback Document Model';


--
-- Name: COLUMN payment_transaction.callback_res_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_transaction.callback_res_id IS 'Callback Record ID';


--
-- Name: COLUMN payment_transaction.partner_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_transaction.partner_id IS 'Customer';


--
-- Name: COLUMN payment_transaction.partner_state_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_transaction.partner_state_id IS 'State';


--
-- Name: COLUMN payment_transaction.partner_country_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_transaction.partner_country_id IS 'Country';


--
-- Name: COLUMN payment_transaction.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_transaction.create_uid IS 'Created by';


--
-- Name: COLUMN payment_transaction.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_transaction.write_uid IS 'Last Updated by';


--
-- Name: COLUMN payment_transaction.reference; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_transaction.reference IS 'Reference';


--
-- Name: COLUMN payment_transaction.provider_reference; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_transaction.provider_reference IS 'Provider Reference';


--
-- Name: COLUMN payment_transaction.state; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_transaction.state IS 'Status';


--
-- Name: COLUMN payment_transaction.operation; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_transaction.operation IS 'Operation';


--
-- Name: COLUMN payment_transaction.landing_route; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_transaction.landing_route IS 'Landing Route';


--
-- Name: COLUMN payment_transaction.callback_method; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_transaction.callback_method IS 'Callback Method';


--
-- Name: COLUMN payment_transaction.callback_hash; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_transaction.callback_hash IS 'Callback Hash';


--
-- Name: COLUMN payment_transaction.partner_name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_transaction.partner_name IS 'Partner Name';


--
-- Name: COLUMN payment_transaction.partner_lang; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_transaction.partner_lang IS 'Language';


--
-- Name: COLUMN payment_transaction.partner_email; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_transaction.partner_email IS 'Email';


--
-- Name: COLUMN payment_transaction.partner_address; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_transaction.partner_address IS 'Address';


--
-- Name: COLUMN payment_transaction.partner_zip; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_transaction.partner_zip IS 'Zip';


--
-- Name: COLUMN payment_transaction.partner_city; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_transaction.partner_city IS 'City';


--
-- Name: COLUMN payment_transaction.partner_phone; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_transaction.partner_phone IS 'Phone';


--
-- Name: COLUMN payment_transaction.state_message; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_transaction.state_message IS 'Message';


--
-- Name: COLUMN payment_transaction.amount; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_transaction.amount IS 'Amount';


--
-- Name: COLUMN payment_transaction.fees; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_transaction.fees IS 'Fees';


--
-- Name: COLUMN payment_transaction.is_post_processed; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_transaction.is_post_processed IS 'Is Post-processed';


--
-- Name: COLUMN payment_transaction.tokenize; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_transaction.tokenize IS 'Create Token';


--
-- Name: COLUMN payment_transaction.callback_is_done; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_transaction.callback_is_done IS 'Callback Done';


--
-- Name: COLUMN payment_transaction.last_state_change; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_transaction.last_state_change IS 'Last State Change Date';


--
-- Name: COLUMN payment_transaction.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_transaction.create_date IS 'Created on';


--
-- Name: COLUMN payment_transaction.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_transaction.write_date IS 'Last Updated on';


--
-- Name: COLUMN payment_transaction.payment_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_transaction.payment_id IS 'Payment';


--
-- Name: COLUMN payment_transaction.is_donation; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_transaction.is_donation IS 'Is donation';


--
-- Name: payment_transaction_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.payment_transaction_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.payment_transaction_id_seq OWNER TO odoo;

--
-- Name: payment_transaction_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.payment_transaction_id_seq OWNED BY public.payment_transaction.id;


--
-- Name: phone_blacklist; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.phone_blacklist (
    id integer NOT NULL,
    message_main_attachment_id integer,
    create_uid integer,
    write_uid integer,
    number character varying NOT NULL,
    active boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.phone_blacklist OWNER TO odoo;

--
-- Name: TABLE phone_blacklist; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.phone_blacklist IS 'Phone Blacklist';


--
-- Name: COLUMN phone_blacklist.message_main_attachment_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.phone_blacklist.message_main_attachment_id IS 'Main Attachment';


--
-- Name: COLUMN phone_blacklist.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.phone_blacklist.create_uid IS 'Created by';


--
-- Name: COLUMN phone_blacklist.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.phone_blacklist.write_uid IS 'Last Updated by';


--
-- Name: COLUMN phone_blacklist.number; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.phone_blacklist.number IS 'Phone Number';


--
-- Name: COLUMN phone_blacklist.active; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.phone_blacklist.active IS 'Active';


--
-- Name: COLUMN phone_blacklist.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.phone_blacklist.create_date IS 'Created on';


--
-- Name: COLUMN phone_blacklist.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.phone_blacklist.write_date IS 'Last Updated on';


--
-- Name: phone_blacklist_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.phone_blacklist_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.phone_blacklist_id_seq OWNER TO odoo;

--
-- Name: phone_blacklist_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.phone_blacklist_id_seq OWNED BY public.phone_blacklist.id;


--
-- Name: phone_blacklist_remove; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.phone_blacklist_remove (
    id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    phone character varying NOT NULL,
    reason character varying,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.phone_blacklist_remove OWNER TO odoo;

--
-- Name: TABLE phone_blacklist_remove; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.phone_blacklist_remove IS 'Remove phone from blacklist';


--
-- Name: COLUMN phone_blacklist_remove.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.phone_blacklist_remove.create_uid IS 'Created by';


--
-- Name: COLUMN phone_blacklist_remove.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.phone_blacklist_remove.write_uid IS 'Last Updated by';


--
-- Name: COLUMN phone_blacklist_remove.phone; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.phone_blacklist_remove.phone IS 'Phone Number';


--
-- Name: COLUMN phone_blacklist_remove.reason; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.phone_blacklist_remove.reason IS 'Reason';


--
-- Name: COLUMN phone_blacklist_remove.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.phone_blacklist_remove.create_date IS 'Created on';


--
-- Name: COLUMN phone_blacklist_remove.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.phone_blacklist_remove.write_date IS 'Last Updated on';


--
-- Name: phone_blacklist_remove_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.phone_blacklist_remove_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.phone_blacklist_remove_id_seq OWNER TO odoo;

--
-- Name: phone_blacklist_remove_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.phone_blacklist_remove_id_seq OWNED BY public.phone_blacklist_remove.id;


--
-- Name: picking_label_type; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.picking_label_type (
    id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    label_type character varying NOT NULL,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.picking_label_type OWNER TO odoo;

--
-- Name: TABLE picking_label_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.picking_label_type IS 'Choose whether to print product or lot/sn labels';


--
-- Name: COLUMN picking_label_type.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.picking_label_type.create_uid IS 'Created by';


--
-- Name: COLUMN picking_label_type.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.picking_label_type.write_uid IS 'Last Updated by';


--
-- Name: COLUMN picking_label_type.label_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.picking_label_type.label_type IS 'Labels to print';


--
-- Name: COLUMN picking_label_type.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.picking_label_type.create_date IS 'Created on';


--
-- Name: COLUMN picking_label_type.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.picking_label_type.write_date IS 'Last Updated on';


--
-- Name: picking_label_type_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.picking_label_type_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.picking_label_type_id_seq OWNER TO odoo;

--
-- Name: picking_label_type_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.picking_label_type_id_seq OWNED BY public.picking_label_type.id;


--
-- Name: picking_label_type_stock_picking_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.picking_label_type_stock_picking_rel (
    picking_label_type_id integer NOT NULL,
    stock_picking_id integer NOT NULL
);


ALTER TABLE public.picking_label_type_stock_picking_rel OWNER TO odoo;

--
-- Name: TABLE picking_label_type_stock_picking_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.picking_label_type_stock_picking_rel IS 'RELATION BETWEEN picking_label_type AND stock_picking';


--
-- Name: portal_share; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.portal_share (
    id integer NOT NULL,
    res_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    res_model character varying NOT NULL,
    note text,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.portal_share OWNER TO odoo;

--
-- Name: TABLE portal_share; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.portal_share IS 'Portal Sharing';


--
-- Name: COLUMN portal_share.res_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.portal_share.res_id IS 'Related Document ID';


--
-- Name: COLUMN portal_share.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.portal_share.create_uid IS 'Created by';


--
-- Name: COLUMN portal_share.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.portal_share.write_uid IS 'Last Updated by';


--
-- Name: COLUMN portal_share.res_model; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.portal_share.res_model IS 'Related Document Model';


--
-- Name: COLUMN portal_share.note; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.portal_share.note IS 'Note';


--
-- Name: COLUMN portal_share.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.portal_share.create_date IS 'Created on';


--
-- Name: COLUMN portal_share.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.portal_share.write_date IS 'Last Updated on';


--
-- Name: portal_share_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.portal_share_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.portal_share_id_seq OWNER TO odoo;

--
-- Name: portal_share_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.portal_share_id_seq OWNED BY public.portal_share.id;


--
-- Name: portal_share_res_partner_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.portal_share_res_partner_rel (
    portal_share_id integer NOT NULL,
    res_partner_id integer NOT NULL
);


ALTER TABLE public.portal_share_res_partner_rel OWNER TO odoo;

--
-- Name: TABLE portal_share_res_partner_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.portal_share_res_partner_rel IS 'RELATION BETWEEN portal_share AND res_partner';


--
-- Name: portal_wizard; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.portal_wizard (
    id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    welcome_message text,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.portal_wizard OWNER TO odoo;

--
-- Name: TABLE portal_wizard; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.portal_wizard IS 'Grant Portal Access';


--
-- Name: COLUMN portal_wizard.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.portal_wizard.create_uid IS 'Created by';


--
-- Name: COLUMN portal_wizard.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.portal_wizard.write_uid IS 'Last Updated by';


--
-- Name: COLUMN portal_wizard.welcome_message; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.portal_wizard.welcome_message IS 'Invitation Message';


--
-- Name: COLUMN portal_wizard.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.portal_wizard.create_date IS 'Created on';


--
-- Name: COLUMN portal_wizard.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.portal_wizard.write_date IS 'Last Updated on';


--
-- Name: portal_wizard_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.portal_wizard_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.portal_wizard_id_seq OWNER TO odoo;

--
-- Name: portal_wizard_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.portal_wizard_id_seq OWNED BY public.portal_wizard.id;


--
-- Name: portal_wizard_res_partner_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.portal_wizard_res_partner_rel (
    portal_wizard_id integer NOT NULL,
    res_partner_id integer NOT NULL
);


ALTER TABLE public.portal_wizard_res_partner_rel OWNER TO odoo;

--
-- Name: TABLE portal_wizard_res_partner_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.portal_wizard_res_partner_rel IS 'RELATION BETWEEN portal_wizard AND res_partner';


--
-- Name: portal_wizard_user; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.portal_wizard_user (
    id integer NOT NULL,
    wizard_id integer NOT NULL,
    partner_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    email character varying,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.portal_wizard_user OWNER TO odoo;

--
-- Name: TABLE portal_wizard_user; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.portal_wizard_user IS 'Portal User Config';


--
-- Name: COLUMN portal_wizard_user.wizard_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.portal_wizard_user.wizard_id IS 'Wizard';


--
-- Name: COLUMN portal_wizard_user.partner_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.portal_wizard_user.partner_id IS 'Contact';


--
-- Name: COLUMN portal_wizard_user.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.portal_wizard_user.create_uid IS 'Created by';


--
-- Name: COLUMN portal_wizard_user.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.portal_wizard_user.write_uid IS 'Last Updated by';


--
-- Name: COLUMN portal_wizard_user.email; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.portal_wizard_user.email IS 'Email';


--
-- Name: COLUMN portal_wizard_user.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.portal_wizard_user.create_date IS 'Created on';


--
-- Name: COLUMN portal_wizard_user.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.portal_wizard_user.write_date IS 'Last Updated on';


--
-- Name: portal_wizard_user_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.portal_wizard_user_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.portal_wizard_user_id_seq OWNER TO odoo;

--
-- Name: portal_wizard_user_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.portal_wizard_user_id_seq OWNED BY public.portal_wizard_user.id;


--
-- Name: privacy_log; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.privacy_log (
    id integer NOT NULL,
    user_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    anonymized_name character varying NOT NULL,
    anonymized_email character varying NOT NULL,
    execution_details text,
    records_description text,
    additional_note text,
    date timestamp without time zone NOT NULL,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.privacy_log OWNER TO odoo;

--
-- Name: TABLE privacy_log; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.privacy_log IS 'Privacy Log';


--
-- Name: COLUMN privacy_log.user_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.privacy_log.user_id IS 'Handled By';


--
-- Name: COLUMN privacy_log.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.privacy_log.create_uid IS 'Created by';


--
-- Name: COLUMN privacy_log.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.privacy_log.write_uid IS 'Last Updated by';


--
-- Name: COLUMN privacy_log.anonymized_name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.privacy_log.anonymized_name IS 'Anonymized Name';


--
-- Name: COLUMN privacy_log.anonymized_email; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.privacy_log.anonymized_email IS 'Anonymized Email';


--
-- Name: COLUMN privacy_log.execution_details; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.privacy_log.execution_details IS 'Execution Details';


--
-- Name: COLUMN privacy_log.records_description; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.privacy_log.records_description IS 'Found Records';


--
-- Name: COLUMN privacy_log.additional_note; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.privacy_log.additional_note IS 'Additional Note';


--
-- Name: COLUMN privacy_log.date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.privacy_log.date IS 'Date';


--
-- Name: COLUMN privacy_log.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.privacy_log.create_date IS 'Created on';


--
-- Name: COLUMN privacy_log.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.privacy_log.write_date IS 'Last Updated on';


--
-- Name: privacy_log_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.privacy_log_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.privacy_log_id_seq OWNER TO odoo;

--
-- Name: privacy_log_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.privacy_log_id_seq OWNED BY public.privacy_log.id;


--
-- Name: privacy_lookup_wizard; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.privacy_lookup_wizard (
    id integer NOT NULL,
    log_id integer,
    create_uid integer,
    write_uid integer,
    name character varying NOT NULL,
    email character varying NOT NULL,
    execution_details text,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.privacy_lookup_wizard OWNER TO odoo;

--
-- Name: TABLE privacy_lookup_wizard; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.privacy_lookup_wizard IS 'Privacy Lookup Wizard';


--
-- Name: COLUMN privacy_lookup_wizard.log_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.privacy_lookup_wizard.log_id IS 'Log';


--
-- Name: COLUMN privacy_lookup_wizard.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.privacy_lookup_wizard.create_uid IS 'Created by';


--
-- Name: COLUMN privacy_lookup_wizard.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.privacy_lookup_wizard.write_uid IS 'Last Updated by';


--
-- Name: COLUMN privacy_lookup_wizard.name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.privacy_lookup_wizard.name IS 'Name';


--
-- Name: COLUMN privacy_lookup_wizard.email; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.privacy_lookup_wizard.email IS 'Email';


--
-- Name: COLUMN privacy_lookup_wizard.execution_details; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.privacy_lookup_wizard.execution_details IS 'Execution Details';


--
-- Name: COLUMN privacy_lookup_wizard.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.privacy_lookup_wizard.create_date IS 'Created on';


--
-- Name: COLUMN privacy_lookup_wizard.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.privacy_lookup_wizard.write_date IS 'Last Updated on';


--
-- Name: privacy_lookup_wizard_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.privacy_lookup_wizard_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.privacy_lookup_wizard_id_seq OWNER TO odoo;

--
-- Name: privacy_lookup_wizard_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.privacy_lookup_wizard_id_seq OWNED BY public.privacy_lookup_wizard.id;


--
-- Name: privacy_lookup_wizard_line; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.privacy_lookup_wizard_line (
    id integer NOT NULL,
    wizard_id integer,
    res_id integer NOT NULL,
    res_model_id integer,
    create_uid integer,
    write_uid integer,
    res_name character varying,
    res_model character varying,
    execution_details character varying,
    has_active boolean,
    is_active boolean,
    is_unlinked boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.privacy_lookup_wizard_line OWNER TO odoo;

--
-- Name: TABLE privacy_lookup_wizard_line; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.privacy_lookup_wizard_line IS 'Privacy Lookup Wizard Line';


--
-- Name: COLUMN privacy_lookup_wizard_line.wizard_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.privacy_lookup_wizard_line.wizard_id IS 'Wizard';


--
-- Name: COLUMN privacy_lookup_wizard_line.res_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.privacy_lookup_wizard_line.res_id IS 'Resource ID';


--
-- Name: COLUMN privacy_lookup_wizard_line.res_model_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.privacy_lookup_wizard_line.res_model_id IS 'Related Document Model';


--
-- Name: COLUMN privacy_lookup_wizard_line.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.privacy_lookup_wizard_line.create_uid IS 'Created by';


--
-- Name: COLUMN privacy_lookup_wizard_line.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.privacy_lookup_wizard_line.write_uid IS 'Last Updated by';


--
-- Name: COLUMN privacy_lookup_wizard_line.res_name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.privacy_lookup_wizard_line.res_name IS 'Resource name';


--
-- Name: COLUMN privacy_lookup_wizard_line.res_model; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.privacy_lookup_wizard_line.res_model IS 'Document Model';


--
-- Name: COLUMN privacy_lookup_wizard_line.execution_details; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.privacy_lookup_wizard_line.execution_details IS 'Execution Details';


--
-- Name: COLUMN privacy_lookup_wizard_line.has_active; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.privacy_lookup_wizard_line.has_active IS 'Has Active';


--
-- Name: COLUMN privacy_lookup_wizard_line.is_active; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.privacy_lookup_wizard_line.is_active IS 'Is Active';


--
-- Name: COLUMN privacy_lookup_wizard_line.is_unlinked; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.privacy_lookup_wizard_line.is_unlinked IS 'Is Unlinked';


--
-- Name: COLUMN privacy_lookup_wizard_line.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.privacy_lookup_wizard_line.create_date IS 'Created on';


--
-- Name: COLUMN privacy_lookup_wizard_line.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.privacy_lookup_wizard_line.write_date IS 'Last Updated on';


--
-- Name: privacy_lookup_wizard_line_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.privacy_lookup_wizard_line_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.privacy_lookup_wizard_line_id_seq OWNER TO odoo;

--
-- Name: privacy_lookup_wizard_line_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.privacy_lookup_wizard_line_id_seq OWNED BY public.privacy_lookup_wizard_line.id;


--
-- Name: procurement_group; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.procurement_group (
    id integer NOT NULL,
    partner_id integer,
    create_uid integer,
    write_uid integer,
    name character varying NOT NULL,
    move_type character varying NOT NULL,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    sale_id integer
);


ALTER TABLE public.procurement_group OWNER TO odoo;

--
-- Name: TABLE procurement_group; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.procurement_group IS 'Procurement Group';


--
-- Name: COLUMN procurement_group.partner_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.procurement_group.partner_id IS 'Partner';


--
-- Name: COLUMN procurement_group.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.procurement_group.create_uid IS 'Created by';


--
-- Name: COLUMN procurement_group.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.procurement_group.write_uid IS 'Last Updated by';


--
-- Name: COLUMN procurement_group.name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.procurement_group.name IS 'Reference';


--
-- Name: COLUMN procurement_group.move_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.procurement_group.move_type IS 'Delivery Type';


--
-- Name: COLUMN procurement_group.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.procurement_group.create_date IS 'Created on';


--
-- Name: COLUMN procurement_group.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.procurement_group.write_date IS 'Last Updated on';


--
-- Name: COLUMN procurement_group.sale_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.procurement_group.sale_id IS 'Sale Order';


--
-- Name: procurement_group_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.procurement_group_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.procurement_group_id_seq OWNER TO odoo;

--
-- Name: procurement_group_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.procurement_group_id_seq OWNED BY public.procurement_group.id;


--
-- Name: product_attr_exclusion_value_ids_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.product_attr_exclusion_value_ids_rel (
    product_template_attribute_exclusion_id integer NOT NULL,
    product_template_attribute_value_id integer NOT NULL
);


ALTER TABLE public.product_attr_exclusion_value_ids_rel OWNER TO odoo;

--
-- Name: TABLE product_attr_exclusion_value_ids_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.product_attr_exclusion_value_ids_rel IS 'RELATION BETWEEN product_template_attribute_exclusion AND product_template_attribute_value';


--
-- Name: product_attribute; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.product_attribute (
    id integer NOT NULL,
    sequence integer,
    create_uid integer,
    write_uid integer,
    create_variant character varying NOT NULL,
    display_type character varying NOT NULL,
    name jsonb NOT NULL,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.product_attribute OWNER TO odoo;

--
-- Name: TABLE product_attribute; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.product_attribute IS 'Product Attribute';


--
-- Name: COLUMN product_attribute.sequence; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_attribute.sequence IS 'Sequence';


--
-- Name: COLUMN product_attribute.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_attribute.create_uid IS 'Created by';


--
-- Name: COLUMN product_attribute.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_attribute.write_uid IS 'Last Updated by';


--
-- Name: COLUMN product_attribute.create_variant; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_attribute.create_variant IS 'Variants Creation Mode';


--
-- Name: COLUMN product_attribute.display_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_attribute.display_type IS 'Display Type';


--
-- Name: COLUMN product_attribute.name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_attribute.name IS 'Attribute';


--
-- Name: COLUMN product_attribute.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_attribute.create_date IS 'Created on';


--
-- Name: COLUMN product_attribute.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_attribute.write_date IS 'Last Updated on';


--
-- Name: product_attribute_custom_value; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.product_attribute_custom_value (
    id integer NOT NULL,
    custom_product_template_attribute_value_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    custom_value character varying,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    sale_order_line_id integer NOT NULL
);


ALTER TABLE public.product_attribute_custom_value OWNER TO odoo;

--
-- Name: TABLE product_attribute_custom_value; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.product_attribute_custom_value IS 'Product Attribute Custom Value';


--
-- Name: COLUMN product_attribute_custom_value.custom_product_template_attribute_value_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_attribute_custom_value.custom_product_template_attribute_value_id IS 'Attribute Value';


--
-- Name: COLUMN product_attribute_custom_value.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_attribute_custom_value.create_uid IS 'Created by';


--
-- Name: COLUMN product_attribute_custom_value.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_attribute_custom_value.write_uid IS 'Last Updated by';


--
-- Name: COLUMN product_attribute_custom_value.custom_value; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_attribute_custom_value.custom_value IS 'Custom Value';


--
-- Name: COLUMN product_attribute_custom_value.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_attribute_custom_value.create_date IS 'Created on';


--
-- Name: COLUMN product_attribute_custom_value.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_attribute_custom_value.write_date IS 'Last Updated on';


--
-- Name: COLUMN product_attribute_custom_value.sale_order_line_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_attribute_custom_value.sale_order_line_id IS 'Sales Order Line';


--
-- Name: product_attribute_custom_value_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.product_attribute_custom_value_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.product_attribute_custom_value_id_seq OWNER TO odoo;

--
-- Name: product_attribute_custom_value_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.product_attribute_custom_value_id_seq OWNED BY public.product_attribute_custom_value.id;


--
-- Name: product_attribute_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.product_attribute_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.product_attribute_id_seq OWNER TO odoo;

--
-- Name: product_attribute_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.product_attribute_id_seq OWNED BY public.product_attribute.id;


--
-- Name: product_attribute_product_template_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.product_attribute_product_template_rel (
    product_attribute_id integer NOT NULL,
    product_template_id integer NOT NULL
);


ALTER TABLE public.product_attribute_product_template_rel OWNER TO odoo;

--
-- Name: TABLE product_attribute_product_template_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.product_attribute_product_template_rel IS 'RELATION BETWEEN product_attribute AND product_template';


--
-- Name: product_attribute_value; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.product_attribute_value (
    id integer NOT NULL,
    sequence integer,
    attribute_id integer NOT NULL,
    color integer,
    create_uid integer,
    write_uid integer,
    html_color character varying,
    name jsonb NOT NULL,
    is_custom boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.product_attribute_value OWNER TO odoo;

--
-- Name: TABLE product_attribute_value; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.product_attribute_value IS 'Attribute Value';


--
-- Name: COLUMN product_attribute_value.sequence; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_attribute_value.sequence IS 'Sequence';


--
-- Name: COLUMN product_attribute_value.attribute_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_attribute_value.attribute_id IS 'Attribute';


--
-- Name: COLUMN product_attribute_value.color; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_attribute_value.color IS 'Color Index';


--
-- Name: COLUMN product_attribute_value.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_attribute_value.create_uid IS 'Created by';


--
-- Name: COLUMN product_attribute_value.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_attribute_value.write_uid IS 'Last Updated by';


--
-- Name: COLUMN product_attribute_value.html_color; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_attribute_value.html_color IS 'Color';


--
-- Name: COLUMN product_attribute_value.name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_attribute_value.name IS 'Value';


--
-- Name: COLUMN product_attribute_value.is_custom; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_attribute_value.is_custom IS 'Is custom value';


--
-- Name: COLUMN product_attribute_value.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_attribute_value.create_date IS 'Created on';


--
-- Name: COLUMN product_attribute_value.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_attribute_value.write_date IS 'Last Updated on';


--
-- Name: product_attribute_value_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.product_attribute_value_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.product_attribute_value_id_seq OWNER TO odoo;

--
-- Name: product_attribute_value_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.product_attribute_value_id_seq OWNED BY public.product_attribute_value.id;


--
-- Name: product_attribute_value_product_template_attribute_line_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.product_attribute_value_product_template_attribute_line_rel (
    product_attribute_value_id integer NOT NULL,
    product_template_attribute_line_id integer NOT NULL
);


ALTER TABLE public.product_attribute_value_product_template_attribute_line_rel OWNER TO odoo;

--
-- Name: TABLE product_attribute_value_product_template_attribute_line_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.product_attribute_value_product_template_attribute_line_rel IS 'RELATION BETWEEN product_attribute_value AND product_template_attribute_line';


--
-- Name: product_category; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.product_category (
    id integer NOT NULL,
    parent_id integer,
    create_uid integer,
    write_uid integer,
    name character varying NOT NULL,
    complete_name character varying,
    parent_path character varying,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    removal_strategy_id integer,
    packaging_reserve_method character varying
);


ALTER TABLE public.product_category OWNER TO odoo;

--
-- Name: TABLE product_category; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.product_category IS 'Product Category';


--
-- Name: COLUMN product_category.parent_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_category.parent_id IS 'Parent Category';


--
-- Name: COLUMN product_category.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_category.create_uid IS 'Created by';


--
-- Name: COLUMN product_category.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_category.write_uid IS 'Last Updated by';


--
-- Name: COLUMN product_category.name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_category.name IS 'Name';


--
-- Name: COLUMN product_category.complete_name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_category.complete_name IS 'Complete Name';


--
-- Name: COLUMN product_category.parent_path; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_category.parent_path IS 'Parent Path';


--
-- Name: COLUMN product_category.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_category.create_date IS 'Created on';


--
-- Name: COLUMN product_category.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_category.write_date IS 'Last Updated on';


--
-- Name: COLUMN product_category.removal_strategy_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_category.removal_strategy_id IS 'Force Removal Strategy';


--
-- Name: COLUMN product_category.packaging_reserve_method; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_category.packaging_reserve_method IS 'Reserve Packagings';


--
-- Name: product_category_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.product_category_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.product_category_id_seq OWNER TO odoo;

--
-- Name: product_category_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.product_category_id_seq OWNED BY public.product_category.id;


--
-- Name: product_label_layout; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.product_label_layout (
    id integer NOT NULL,
    custom_quantity integer NOT NULL,
    create_uid integer,
    write_uid integer,
    print_format character varying NOT NULL,
    extra_html text,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    picking_quantity character varying NOT NULL
);


ALTER TABLE public.product_label_layout OWNER TO odoo;

--
-- Name: TABLE product_label_layout; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.product_label_layout IS 'Choose the sheet layout to print the labels';


--
-- Name: COLUMN product_label_layout.custom_quantity; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_label_layout.custom_quantity IS 'Quantity';


--
-- Name: COLUMN product_label_layout.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_label_layout.create_uid IS 'Created by';


--
-- Name: COLUMN product_label_layout.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_label_layout.write_uid IS 'Last Updated by';


--
-- Name: COLUMN product_label_layout.print_format; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_label_layout.print_format IS 'Format';


--
-- Name: COLUMN product_label_layout.extra_html; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_label_layout.extra_html IS 'Extra Content';


--
-- Name: COLUMN product_label_layout.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_label_layout.create_date IS 'Created on';


--
-- Name: COLUMN product_label_layout.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_label_layout.write_date IS 'Last Updated on';


--
-- Name: COLUMN product_label_layout.picking_quantity; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_label_layout.picking_quantity IS 'Quantity to print';


--
-- Name: product_label_layout_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.product_label_layout_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.product_label_layout_id_seq OWNER TO odoo;

--
-- Name: product_label_layout_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.product_label_layout_id_seq OWNED BY public.product_label_layout.id;


--
-- Name: product_label_layout_product_product_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.product_label_layout_product_product_rel (
    product_label_layout_id integer NOT NULL,
    product_product_id integer NOT NULL
);


ALTER TABLE public.product_label_layout_product_product_rel OWNER TO odoo;

--
-- Name: TABLE product_label_layout_product_product_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.product_label_layout_product_product_rel IS 'RELATION BETWEEN product_label_layout AND product_product';


--
-- Name: product_label_layout_product_template_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.product_label_layout_product_template_rel (
    product_label_layout_id integer NOT NULL,
    product_template_id integer NOT NULL
);


ALTER TABLE public.product_label_layout_product_template_rel OWNER TO odoo;

--
-- Name: TABLE product_label_layout_product_template_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.product_label_layout_product_template_rel IS 'RELATION BETWEEN product_label_layout AND product_template';


--
-- Name: product_label_layout_stock_move_line_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.product_label_layout_stock_move_line_rel (
    product_label_layout_id integer NOT NULL,
    stock_move_line_id integer NOT NULL
);


ALTER TABLE public.product_label_layout_stock_move_line_rel OWNER TO odoo;

--
-- Name: TABLE product_label_layout_stock_move_line_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.product_label_layout_stock_move_line_rel IS 'RELATION BETWEEN product_label_layout AND stock_move_line';


--
-- Name: product_optional_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.product_optional_rel (
    src_id integer NOT NULL,
    dest_id integer NOT NULL
);


ALTER TABLE public.product_optional_rel OWNER TO odoo;

--
-- Name: TABLE product_optional_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.product_optional_rel IS 'RELATION BETWEEN product_template AND product_template';


--
-- Name: product_packaging; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.product_packaging (
    id integer NOT NULL,
    sequence integer,
    product_id integer,
    company_id integer,
    create_uid integer,
    write_uid integer,
    name character varying NOT NULL,
    barcode character varying,
    qty numeric,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    sales boolean,
    package_type_id integer,
    purchase boolean,
    CONSTRAINT product_packaging_positive_qty CHECK ((qty > (0)::numeric))
);


ALTER TABLE public.product_packaging OWNER TO odoo;

--
-- Name: TABLE product_packaging; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.product_packaging IS 'Product Packaging';


--
-- Name: COLUMN product_packaging.sequence; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_packaging.sequence IS 'Sequence';


--
-- Name: COLUMN product_packaging.product_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_packaging.product_id IS 'Product';


--
-- Name: COLUMN product_packaging.company_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_packaging.company_id IS 'Company';


--
-- Name: COLUMN product_packaging.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_packaging.create_uid IS 'Created by';


--
-- Name: COLUMN product_packaging.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_packaging.write_uid IS 'Last Updated by';


--
-- Name: COLUMN product_packaging.name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_packaging.name IS 'Product Packaging';


--
-- Name: COLUMN product_packaging.barcode; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_packaging.barcode IS 'Barcode';


--
-- Name: COLUMN product_packaging.qty; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_packaging.qty IS 'Contained Quantity';


--
-- Name: COLUMN product_packaging.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_packaging.create_date IS 'Created on';


--
-- Name: COLUMN product_packaging.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_packaging.write_date IS 'Last Updated on';


--
-- Name: COLUMN product_packaging.sales; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_packaging.sales IS 'Sales';


--
-- Name: COLUMN product_packaging.package_type_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_packaging.package_type_id IS 'Package Type';


--
-- Name: COLUMN product_packaging.purchase; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_packaging.purchase IS 'Purchase';


--
-- Name: CONSTRAINT product_packaging_positive_qty ON product_packaging; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT product_packaging_positive_qty ON public.product_packaging IS 'CHECK(qty > 0)';


--
-- Name: product_packaging_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.product_packaging_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.product_packaging_id_seq OWNER TO odoo;

--
-- Name: product_packaging_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.product_packaging_id_seq OWNED BY public.product_packaging.id;


--
-- Name: product_pricelist; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.product_pricelist (
    id integer NOT NULL,
    sequence integer,
    currency_id integer NOT NULL,
    company_id integer,
    create_uid integer,
    write_uid integer,
    discount_policy character varying NOT NULL,
    name jsonb NOT NULL,
    active boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.product_pricelist OWNER TO odoo;

--
-- Name: TABLE product_pricelist; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.product_pricelist IS 'Pricelist';


--
-- Name: COLUMN product_pricelist.sequence; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist.sequence IS 'Sequence';


--
-- Name: COLUMN product_pricelist.currency_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist.currency_id IS 'Currency';


--
-- Name: COLUMN product_pricelist.company_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist.company_id IS 'Company';


--
-- Name: COLUMN product_pricelist.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist.create_uid IS 'Created by';


--
-- Name: COLUMN product_pricelist.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist.write_uid IS 'Last Updated by';


--
-- Name: COLUMN product_pricelist.discount_policy; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist.discount_policy IS 'Discount Policy';


--
-- Name: COLUMN product_pricelist.name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist.name IS 'Pricelist Name';


--
-- Name: COLUMN product_pricelist.active; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist.active IS 'Active';


--
-- Name: COLUMN product_pricelist.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist.create_date IS 'Created on';


--
-- Name: COLUMN product_pricelist.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist.write_date IS 'Last Updated on';


--
-- Name: product_pricelist_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.product_pricelist_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.product_pricelist_id_seq OWNER TO odoo;

--
-- Name: product_pricelist_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.product_pricelist_id_seq OWNED BY public.product_pricelist.id;


--
-- Name: product_pricelist_item; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.product_pricelist_item (
    id integer NOT NULL,
    pricelist_id integer NOT NULL,
    company_id integer,
    currency_id integer,
    categ_id integer,
    product_tmpl_id integer,
    product_id integer,
    base_pricelist_id integer,
    create_uid integer,
    write_uid integer,
    applied_on character varying NOT NULL,
    base character varying NOT NULL,
    compute_price character varying NOT NULL,
    min_quantity numeric,
    fixed_price numeric,
    price_discount numeric,
    price_round numeric,
    price_surcharge numeric,
    price_min_margin numeric,
    price_max_margin numeric,
    active boolean,
    date_start timestamp without time zone,
    date_end timestamp without time zone,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    percent_price double precision
);


ALTER TABLE public.product_pricelist_item OWNER TO odoo;

--
-- Name: TABLE product_pricelist_item; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.product_pricelist_item IS 'Pricelist Rule';


--
-- Name: COLUMN product_pricelist_item.pricelist_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist_item.pricelist_id IS 'Pricelist';


--
-- Name: COLUMN product_pricelist_item.company_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist_item.company_id IS 'Company';


--
-- Name: COLUMN product_pricelist_item.currency_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist_item.currency_id IS 'Currency';


--
-- Name: COLUMN product_pricelist_item.categ_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist_item.categ_id IS 'Product Category';


--
-- Name: COLUMN product_pricelist_item.product_tmpl_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist_item.product_tmpl_id IS 'Product';


--
-- Name: COLUMN product_pricelist_item.product_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist_item.product_id IS 'Product Variant';


--
-- Name: COLUMN product_pricelist_item.base_pricelist_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist_item.base_pricelist_id IS 'Other Pricelist';


--
-- Name: COLUMN product_pricelist_item.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist_item.create_uid IS 'Created by';


--
-- Name: COLUMN product_pricelist_item.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist_item.write_uid IS 'Last Updated by';


--
-- Name: COLUMN product_pricelist_item.applied_on; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist_item.applied_on IS 'Apply On';


--
-- Name: COLUMN product_pricelist_item.base; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist_item.base IS 'Based on';


--
-- Name: COLUMN product_pricelist_item.compute_price; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist_item.compute_price IS 'Compute Price';


--
-- Name: COLUMN product_pricelist_item.min_quantity; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist_item.min_quantity IS 'Min. Quantity';


--
-- Name: COLUMN product_pricelist_item.fixed_price; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist_item.fixed_price IS 'Fixed Price';


--
-- Name: COLUMN product_pricelist_item.price_discount; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist_item.price_discount IS 'Price Discount';


--
-- Name: COLUMN product_pricelist_item.price_round; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist_item.price_round IS 'Price Rounding';


--
-- Name: COLUMN product_pricelist_item.price_surcharge; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist_item.price_surcharge IS 'Price Surcharge';


--
-- Name: COLUMN product_pricelist_item.price_min_margin; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist_item.price_min_margin IS 'Min. Price Margin';


--
-- Name: COLUMN product_pricelist_item.price_max_margin; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist_item.price_max_margin IS 'Max. Price Margin';


--
-- Name: COLUMN product_pricelist_item.active; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist_item.active IS 'Active';


--
-- Name: COLUMN product_pricelist_item.date_start; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist_item.date_start IS 'Start Date';


--
-- Name: COLUMN product_pricelist_item.date_end; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist_item.date_end IS 'End Date';


--
-- Name: COLUMN product_pricelist_item.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist_item.create_date IS 'Created on';


--
-- Name: COLUMN product_pricelist_item.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist_item.write_date IS 'Last Updated on';


--
-- Name: COLUMN product_pricelist_item.percent_price; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist_item.percent_price IS 'Percentage Price';


--
-- Name: product_pricelist_item_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.product_pricelist_item_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.product_pricelist_item_id_seq OWNER TO odoo;

--
-- Name: product_pricelist_item_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.product_pricelist_item_id_seq OWNED BY public.product_pricelist_item.id;


--
-- Name: product_product; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.product_product (
    id integer NOT NULL,
    message_main_attachment_id integer,
    product_tmpl_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    default_code character varying,
    barcode character varying,
    combination_indices character varying,
    volume numeric,
    weight numeric,
    active boolean,
    can_image_variant_1024_be_zoomed boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.product_product OWNER TO odoo;

--
-- Name: TABLE product_product; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.product_product IS 'Product Variant';


--
-- Name: COLUMN product_product.message_main_attachment_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_product.message_main_attachment_id IS 'Main Attachment';


--
-- Name: COLUMN product_product.product_tmpl_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_product.product_tmpl_id IS 'Product Template';


--
-- Name: COLUMN product_product.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_product.create_uid IS 'Created by';


--
-- Name: COLUMN product_product.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_product.write_uid IS 'Last Updated by';


--
-- Name: COLUMN product_product.default_code; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_product.default_code IS 'Internal Reference';


--
-- Name: COLUMN product_product.barcode; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_product.barcode IS 'Barcode';


--
-- Name: COLUMN product_product.combination_indices; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_product.combination_indices IS 'Combination Indices';


--
-- Name: COLUMN product_product.volume; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_product.volume IS 'Volume';


--
-- Name: COLUMN product_product.weight; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_product.weight IS 'Weight';


--
-- Name: COLUMN product_product.active; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_product.active IS 'Active';


--
-- Name: COLUMN product_product.can_image_variant_1024_be_zoomed; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_product.can_image_variant_1024_be_zoomed IS 'Can Variant Image 1024 be zoomed';


--
-- Name: COLUMN product_product.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_product.create_date IS 'Created on';


--
-- Name: COLUMN product_product.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_product.write_date IS 'Last Updated on';


--
-- Name: product_product_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.product_product_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.product_product_id_seq OWNER TO odoo;

--
-- Name: product_product_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.product_product_id_seq OWNED BY public.product_product.id;


--
-- Name: product_product_stock_track_confirmation_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.product_product_stock_track_confirmation_rel (
    stock_track_confirmation_id integer NOT NULL,
    product_product_id integer NOT NULL
);


ALTER TABLE public.product_product_stock_track_confirmation_rel OWNER TO odoo;

--
-- Name: TABLE product_product_stock_track_confirmation_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.product_product_stock_track_confirmation_rel IS 'RELATION BETWEEN stock_track_confirmation AND product_product';


--
-- Name: product_removal; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.product_removal (
    id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    name character varying NOT NULL,
    method character varying NOT NULL,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.product_removal OWNER TO odoo;

--
-- Name: TABLE product_removal; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.product_removal IS 'Removal Strategy';


--
-- Name: COLUMN product_removal.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_removal.create_uid IS 'Created by';


--
-- Name: COLUMN product_removal.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_removal.write_uid IS 'Last Updated by';


--
-- Name: COLUMN product_removal.name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_removal.name IS 'Name';


--
-- Name: COLUMN product_removal.method; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_removal.method IS 'Method';


--
-- Name: COLUMN product_removal.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_removal.create_date IS 'Created on';


--
-- Name: COLUMN product_removal.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_removal.write_date IS 'Last Updated on';


--
-- Name: product_removal_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.product_removal_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.product_removal_id_seq OWNER TO odoo;

--
-- Name: product_removal_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.product_removal_id_seq OWNED BY public.product_removal.id;


--
-- Name: product_replenish; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.product_replenish (
    id integer NOT NULL,
    product_id integer NOT NULL,
    product_tmpl_id integer NOT NULL,
    product_uom_id integer NOT NULL,
    warehouse_id integer NOT NULL,
    company_id integer,
    create_uid integer,
    write_uid integer,
    product_has_variants boolean NOT NULL,
    date_planned timestamp without time zone NOT NULL,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    quantity double precision NOT NULL
);


ALTER TABLE public.product_replenish OWNER TO odoo;

--
-- Name: TABLE product_replenish; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.product_replenish IS 'Product Replenish';


--
-- Name: COLUMN product_replenish.product_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_replenish.product_id IS 'Product';


--
-- Name: COLUMN product_replenish.product_tmpl_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_replenish.product_tmpl_id IS 'Product Template';


--
-- Name: COLUMN product_replenish.product_uom_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_replenish.product_uom_id IS 'Unit of measure';


--
-- Name: COLUMN product_replenish.warehouse_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_replenish.warehouse_id IS 'Warehouse';


--
-- Name: COLUMN product_replenish.company_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_replenish.company_id IS 'Company';


--
-- Name: COLUMN product_replenish.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_replenish.create_uid IS 'Created by';


--
-- Name: COLUMN product_replenish.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_replenish.write_uid IS 'Last Updated by';


--
-- Name: COLUMN product_replenish.product_has_variants; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_replenish.product_has_variants IS 'Has variants';


--
-- Name: COLUMN product_replenish.date_planned; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_replenish.date_planned IS 'Scheduled Date';


--
-- Name: COLUMN product_replenish.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_replenish.create_date IS 'Created on';


--
-- Name: COLUMN product_replenish.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_replenish.write_date IS 'Last Updated on';


--
-- Name: COLUMN product_replenish.quantity; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_replenish.quantity IS 'Quantity';


--
-- Name: product_replenish_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.product_replenish_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.product_replenish_id_seq OWNER TO odoo;

--
-- Name: product_replenish_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.product_replenish_id_seq OWNED BY public.product_replenish.id;


--
-- Name: product_replenish_stock_route_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.product_replenish_stock_route_rel (
    product_replenish_id integer NOT NULL,
    stock_route_id integer NOT NULL
);


ALTER TABLE public.product_replenish_stock_route_rel OWNER TO odoo;

--
-- Name: TABLE product_replenish_stock_route_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.product_replenish_stock_route_rel IS 'RELATION BETWEEN product_replenish AND stock_route';


--
-- Name: product_supplier_taxes_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.product_supplier_taxes_rel (
    prod_id integer NOT NULL,
    tax_id integer NOT NULL
);


ALTER TABLE public.product_supplier_taxes_rel OWNER TO odoo;

--
-- Name: TABLE product_supplier_taxes_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.product_supplier_taxes_rel IS 'RELATION BETWEEN product_template AND account_tax';


--
-- Name: product_supplierinfo; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.product_supplierinfo (
    id integer NOT NULL,
    partner_id integer NOT NULL,
    sequence integer,
    company_id integer,
    currency_id integer NOT NULL,
    product_id integer,
    product_tmpl_id integer,
    delay integer NOT NULL,
    create_uid integer,
    write_uid integer,
    product_name character varying,
    product_code character varying,
    date_start date,
    date_end date,
    min_qty numeric NOT NULL,
    price numeric NOT NULL,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.product_supplierinfo OWNER TO odoo;

--
-- Name: TABLE product_supplierinfo; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.product_supplierinfo IS 'Supplier Pricelist';


--
-- Name: COLUMN product_supplierinfo.partner_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_supplierinfo.partner_id IS 'Vendor';


--
-- Name: COLUMN product_supplierinfo.sequence; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_supplierinfo.sequence IS 'Sequence';


--
-- Name: COLUMN product_supplierinfo.company_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_supplierinfo.company_id IS 'Company';


--
-- Name: COLUMN product_supplierinfo.currency_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_supplierinfo.currency_id IS 'Currency';


--
-- Name: COLUMN product_supplierinfo.product_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_supplierinfo.product_id IS 'Product Variant';


--
-- Name: COLUMN product_supplierinfo.product_tmpl_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_supplierinfo.product_tmpl_id IS 'Product Template';


--
-- Name: COLUMN product_supplierinfo.delay; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_supplierinfo.delay IS 'Delivery Lead Time';


--
-- Name: COLUMN product_supplierinfo.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_supplierinfo.create_uid IS 'Created by';


--
-- Name: COLUMN product_supplierinfo.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_supplierinfo.write_uid IS 'Last Updated by';


--
-- Name: COLUMN product_supplierinfo.product_name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_supplierinfo.product_name IS 'Vendor Product Name';


--
-- Name: COLUMN product_supplierinfo.product_code; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_supplierinfo.product_code IS 'Vendor Product Code';


--
-- Name: COLUMN product_supplierinfo.date_start; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_supplierinfo.date_start IS 'Start Date';


--
-- Name: COLUMN product_supplierinfo.date_end; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_supplierinfo.date_end IS 'End Date';


--
-- Name: COLUMN product_supplierinfo.min_qty; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_supplierinfo.min_qty IS 'Quantity';


--
-- Name: COLUMN product_supplierinfo.price; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_supplierinfo.price IS 'Price';


--
-- Name: COLUMN product_supplierinfo.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_supplierinfo.create_date IS 'Created on';


--
-- Name: COLUMN product_supplierinfo.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_supplierinfo.write_date IS 'Last Updated on';


--
-- Name: product_supplierinfo_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.product_supplierinfo_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.product_supplierinfo_id_seq OWNER TO odoo;

--
-- Name: product_supplierinfo_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.product_supplierinfo_id_seq OWNED BY public.product_supplierinfo.id;


--
-- Name: product_supplierinfo_stock_replenishment_info_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.product_supplierinfo_stock_replenishment_info_rel (
    stock_replenishment_info_id integer NOT NULL,
    product_supplierinfo_id integer NOT NULL
);


ALTER TABLE public.product_supplierinfo_stock_replenishment_info_rel OWNER TO odoo;

--
-- Name: TABLE product_supplierinfo_stock_replenishment_info_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.product_supplierinfo_stock_replenishment_info_rel IS 'RELATION BETWEEN stock_replenishment_info AND product_supplierinfo';


--
-- Name: product_tag; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.product_tag (
    id integer NOT NULL,
    color integer,
    create_uid integer,
    write_uid integer,
    name jsonb NOT NULL,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.product_tag OWNER TO odoo;

--
-- Name: TABLE product_tag; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.product_tag IS 'Product Tag';


--
-- Name: COLUMN product_tag.color; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_tag.color IS 'Color';


--
-- Name: COLUMN product_tag.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_tag.create_uid IS 'Created by';


--
-- Name: COLUMN product_tag.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_tag.write_uid IS 'Last Updated by';


--
-- Name: COLUMN product_tag.name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_tag.name IS 'Tag Name';


--
-- Name: COLUMN product_tag.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_tag.create_date IS 'Created on';


--
-- Name: COLUMN product_tag.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_tag.write_date IS 'Last Updated on';


--
-- Name: product_tag_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.product_tag_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.product_tag_id_seq OWNER TO odoo;

--
-- Name: product_tag_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.product_tag_id_seq OWNED BY public.product_tag.id;


--
-- Name: product_tag_product_product_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.product_tag_product_product_rel (
    product_product_id integer NOT NULL,
    product_tag_id integer NOT NULL
);


ALTER TABLE public.product_tag_product_product_rel OWNER TO odoo;

--
-- Name: TABLE product_tag_product_product_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.product_tag_product_product_rel IS 'RELATION BETWEEN product_product AND product_tag';


--
-- Name: product_tag_product_template_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.product_tag_product_template_rel (
    product_template_id integer NOT NULL,
    product_tag_id integer NOT NULL
);


ALTER TABLE public.product_tag_product_template_rel OWNER TO odoo;

--
-- Name: TABLE product_tag_product_template_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.product_tag_product_template_rel IS 'RELATION BETWEEN product_template AND product_tag';


--
-- Name: product_taxes_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.product_taxes_rel (
    prod_id integer NOT NULL,
    tax_id integer NOT NULL
);


ALTER TABLE public.product_taxes_rel OWNER TO odoo;

--
-- Name: TABLE product_taxes_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.product_taxes_rel IS 'RELATION BETWEEN product_template AND account_tax';


--
-- Name: product_template; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.product_template (
    id integer NOT NULL,
    message_main_attachment_id integer,
    sequence integer,
    categ_id integer NOT NULL,
    uom_id integer NOT NULL,
    uom_po_id integer NOT NULL,
    company_id integer,
    color integer,
    create_uid integer,
    write_uid integer,
    detailed_type character varying NOT NULL,
    type character varying,
    default_code character varying,
    priority character varying,
    name jsonb NOT NULL,
    description jsonb,
    description_purchase jsonb,
    description_sale jsonb,
    list_price numeric,
    volume numeric,
    weight numeric,
    sale_ok boolean,
    purchase_ok boolean,
    active boolean,
    can_image_1024_be_zoomed boolean,
    has_configurable_attributes boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    service_type character varying,
    sale_line_warn character varying NOT NULL,
    expense_policy character varying,
    invoice_policy character varying,
    sale_line_warn_msg text,
    service_tracking character varying,
    tracking character varying NOT NULL,
    description_picking jsonb,
    description_pickingout jsonb,
    description_pickingin jsonb,
    sale_delay double precision,
    purchase_method character varying,
    purchase_line_warn character varying NOT NULL,
    purchase_line_warn_msg text,
    can_be_expensed boolean DEFAULT false
);


ALTER TABLE public.product_template OWNER TO odoo;

--
-- Name: TABLE product_template; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.product_template IS 'Product';


--
-- Name: COLUMN product_template.message_main_attachment_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.message_main_attachment_id IS 'Main Attachment';


--
-- Name: COLUMN product_template.sequence; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.sequence IS 'Sequence';


--
-- Name: COLUMN product_template.categ_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.categ_id IS 'Product Category';


--
-- Name: COLUMN product_template.uom_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.uom_id IS 'Unit of Measure';


--
-- Name: COLUMN product_template.uom_po_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.uom_po_id IS 'Purchase UoM';


--
-- Name: COLUMN product_template.company_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.company_id IS 'Company';


--
-- Name: COLUMN product_template.color; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.color IS 'Color Index';


--
-- Name: COLUMN product_template.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.create_uid IS 'Created by';


--
-- Name: COLUMN product_template.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.write_uid IS 'Last Updated by';


--
-- Name: COLUMN product_template.detailed_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.detailed_type IS 'Product Type';


--
-- Name: COLUMN product_template.type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.type IS 'Type';


--
-- Name: COLUMN product_template.default_code; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.default_code IS 'Internal Reference';


--
-- Name: COLUMN product_template.priority; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.priority IS 'Favorite';


--
-- Name: COLUMN product_template.name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.name IS 'Name';


--
-- Name: COLUMN product_template.description; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.description IS 'Description';


--
-- Name: COLUMN product_template.description_purchase; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.description_purchase IS 'Purchase Description';


--
-- Name: COLUMN product_template.description_sale; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.description_sale IS 'Sales Description';


--
-- Name: COLUMN product_template.list_price; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.list_price IS 'Sales Price';


--
-- Name: COLUMN product_template.volume; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.volume IS 'Volume';


--
-- Name: COLUMN product_template.weight; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.weight IS 'Weight';


--
-- Name: COLUMN product_template.sale_ok; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.sale_ok IS 'Can be Sold';


--
-- Name: COLUMN product_template.purchase_ok; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.purchase_ok IS 'Can be Purchased';


--
-- Name: COLUMN product_template.active; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.active IS 'Active';


--
-- Name: COLUMN product_template.can_image_1024_be_zoomed; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.can_image_1024_be_zoomed IS 'Can Image 1024 be zoomed';


--
-- Name: COLUMN product_template.has_configurable_attributes; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.has_configurable_attributes IS 'Is a configurable product';


--
-- Name: COLUMN product_template.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.create_date IS 'Created on';


--
-- Name: COLUMN product_template.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.write_date IS 'Last Updated on';


--
-- Name: COLUMN product_template.service_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.service_type IS 'Track Service';


--
-- Name: COLUMN product_template.sale_line_warn; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.sale_line_warn IS 'Sales Order Line';


--
-- Name: COLUMN product_template.expense_policy; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.expense_policy IS 'Re-Invoice Expenses';


--
-- Name: COLUMN product_template.invoice_policy; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.invoice_policy IS 'Invoicing Policy';


--
-- Name: COLUMN product_template.sale_line_warn_msg; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.sale_line_warn_msg IS 'Message for Sales Order Line';


--
-- Name: COLUMN product_template.service_tracking; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.service_tracking IS 'Create on Order';


--
-- Name: COLUMN product_template.tracking; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.tracking IS 'Tracking';


--
-- Name: COLUMN product_template.description_picking; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.description_picking IS 'Description on Picking';


--
-- Name: COLUMN product_template.description_pickingout; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.description_pickingout IS 'Description on Delivery Orders';


--
-- Name: COLUMN product_template.description_pickingin; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.description_pickingin IS 'Description on Receptions';


--
-- Name: COLUMN product_template.sale_delay; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.sale_delay IS 'Customer Lead Time';


--
-- Name: COLUMN product_template.purchase_method; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.purchase_method IS 'Control Policy';


--
-- Name: COLUMN product_template.purchase_line_warn; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.purchase_line_warn IS 'Purchase Order Line Warning';


--
-- Name: COLUMN product_template.purchase_line_warn_msg; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.purchase_line_warn_msg IS 'Message for Purchase Order Line';


--
-- Name: product_template_attribute_exclusion; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.product_template_attribute_exclusion (
    id integer NOT NULL,
    product_template_attribute_value_id integer,
    product_tmpl_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.product_template_attribute_exclusion OWNER TO odoo;

--
-- Name: TABLE product_template_attribute_exclusion; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.product_template_attribute_exclusion IS 'Product Template Attribute Exclusion';


--
-- Name: COLUMN product_template_attribute_exclusion.product_template_attribute_value_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template_attribute_exclusion.product_template_attribute_value_id IS 'Attribute Value';


--
-- Name: COLUMN product_template_attribute_exclusion.product_tmpl_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template_attribute_exclusion.product_tmpl_id IS 'Product Template';


--
-- Name: COLUMN product_template_attribute_exclusion.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template_attribute_exclusion.create_uid IS 'Created by';


--
-- Name: COLUMN product_template_attribute_exclusion.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template_attribute_exclusion.write_uid IS 'Last Updated by';


--
-- Name: COLUMN product_template_attribute_exclusion.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template_attribute_exclusion.create_date IS 'Created on';


--
-- Name: COLUMN product_template_attribute_exclusion.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template_attribute_exclusion.write_date IS 'Last Updated on';


--
-- Name: product_template_attribute_exclusion_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.product_template_attribute_exclusion_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.product_template_attribute_exclusion_id_seq OWNER TO odoo;

--
-- Name: product_template_attribute_exclusion_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.product_template_attribute_exclusion_id_seq OWNED BY public.product_template_attribute_exclusion.id;


--
-- Name: product_template_attribute_line; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.product_template_attribute_line (
    id integer NOT NULL,
    product_tmpl_id integer NOT NULL,
    attribute_id integer NOT NULL,
    value_count integer,
    create_uid integer,
    write_uid integer,
    active boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.product_template_attribute_line OWNER TO odoo;

--
-- Name: TABLE product_template_attribute_line; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.product_template_attribute_line IS 'Product Template Attribute Line';


--
-- Name: COLUMN product_template_attribute_line.product_tmpl_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template_attribute_line.product_tmpl_id IS 'Product Template';


--
-- Name: COLUMN product_template_attribute_line.attribute_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template_attribute_line.attribute_id IS 'Attribute';


--
-- Name: COLUMN product_template_attribute_line.value_count; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template_attribute_line.value_count IS 'Value Count';


--
-- Name: COLUMN product_template_attribute_line.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template_attribute_line.create_uid IS 'Created by';


--
-- Name: COLUMN product_template_attribute_line.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template_attribute_line.write_uid IS 'Last Updated by';


--
-- Name: COLUMN product_template_attribute_line.active; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template_attribute_line.active IS 'Active';


--
-- Name: COLUMN product_template_attribute_line.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template_attribute_line.create_date IS 'Created on';


--
-- Name: COLUMN product_template_attribute_line.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template_attribute_line.write_date IS 'Last Updated on';


--
-- Name: product_template_attribute_line_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.product_template_attribute_line_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.product_template_attribute_line_id_seq OWNER TO odoo;

--
-- Name: product_template_attribute_line_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.product_template_attribute_line_id_seq OWNED BY public.product_template_attribute_line.id;


--
-- Name: product_template_attribute_value; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.product_template_attribute_value (
    id integer NOT NULL,
    product_attribute_value_id integer NOT NULL,
    attribute_line_id integer NOT NULL,
    product_tmpl_id integer,
    attribute_id integer,
    color integer,
    create_uid integer,
    write_uid integer,
    price_extra numeric,
    ptav_active boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.product_template_attribute_value OWNER TO odoo;

--
-- Name: TABLE product_template_attribute_value; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.product_template_attribute_value IS 'Product Template Attribute Value';


--
-- Name: COLUMN product_template_attribute_value.product_attribute_value_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template_attribute_value.product_attribute_value_id IS 'Attribute Value';


--
-- Name: COLUMN product_template_attribute_value.attribute_line_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template_attribute_value.attribute_line_id IS 'Attribute Line';


--
-- Name: COLUMN product_template_attribute_value.product_tmpl_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template_attribute_value.product_tmpl_id IS 'Product Template';


--
-- Name: COLUMN product_template_attribute_value.attribute_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template_attribute_value.attribute_id IS 'Attribute';


--
-- Name: COLUMN product_template_attribute_value.color; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template_attribute_value.color IS 'Color';


--
-- Name: COLUMN product_template_attribute_value.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template_attribute_value.create_uid IS 'Created by';


--
-- Name: COLUMN product_template_attribute_value.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template_attribute_value.write_uid IS 'Last Updated by';


--
-- Name: COLUMN product_template_attribute_value.price_extra; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template_attribute_value.price_extra IS 'Value Price Extra';


--
-- Name: COLUMN product_template_attribute_value.ptav_active; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template_attribute_value.ptav_active IS 'Active';


--
-- Name: COLUMN product_template_attribute_value.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template_attribute_value.create_date IS 'Created on';


--
-- Name: COLUMN product_template_attribute_value.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template_attribute_value.write_date IS 'Last Updated on';


--
-- Name: product_template_attribute_value_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.product_template_attribute_value_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.product_template_attribute_value_id_seq OWNER TO odoo;

--
-- Name: product_template_attribute_value_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.product_template_attribute_value_id_seq OWNED BY public.product_template_attribute_value.id;


--
-- Name: product_template_attribute_value_sale_order_line_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.product_template_attribute_value_sale_order_line_rel (
    sale_order_line_id integer NOT NULL,
    product_template_attribute_value_id integer NOT NULL
);


ALTER TABLE public.product_template_attribute_value_sale_order_line_rel OWNER TO odoo;

--
-- Name: TABLE product_template_attribute_value_sale_order_line_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.product_template_attribute_value_sale_order_line_rel IS 'RELATION BETWEEN sale_order_line AND product_template_attribute_value';


--
-- Name: product_template_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.product_template_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.product_template_id_seq OWNER TO odoo;

--
-- Name: product_template_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.product_template_id_seq OWNED BY public.product_template.id;


--
-- Name: product_variant_combination; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.product_variant_combination (
    product_product_id integer NOT NULL,
    product_template_attribute_value_id integer NOT NULL
);


ALTER TABLE public.product_variant_combination OWNER TO odoo;

--
-- Name: TABLE product_variant_combination; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.product_variant_combination IS 'RELATION BETWEEN product_product AND product_template_attribute_value';


--
-- Name: project_collaborator; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.project_collaborator (
    id integer NOT NULL,
    project_id integer NOT NULL,
    partner_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.project_collaborator OWNER TO odoo;

--
-- Name: TABLE project_collaborator; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.project_collaborator IS 'Collaborators in project shared';


--
-- Name: COLUMN project_collaborator.project_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_collaborator.project_id IS 'Project Shared';


--
-- Name: COLUMN project_collaborator.partner_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_collaborator.partner_id IS 'Collaborator';


--
-- Name: COLUMN project_collaborator.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_collaborator.create_uid IS 'Created by';


--
-- Name: COLUMN project_collaborator.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_collaborator.write_uid IS 'Last Updated by';


--
-- Name: COLUMN project_collaborator.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_collaborator.create_date IS 'Created on';


--
-- Name: COLUMN project_collaborator.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_collaborator.write_date IS 'Last Updated on';


--
-- Name: project_collaborator_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.project_collaborator_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.project_collaborator_id_seq OWNER TO odoo;

--
-- Name: project_collaborator_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.project_collaborator_id_seq OWNED BY public.project_collaborator.id;


--
-- Name: project_favorite_user_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.project_favorite_user_rel (
    project_id integer NOT NULL,
    user_id integer NOT NULL
);


ALTER TABLE public.project_favorite_user_rel OWNER TO odoo;

--
-- Name: TABLE project_favorite_user_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.project_favorite_user_rel IS 'RELATION BETWEEN project_project AND res_users';


--
-- Name: project_milestone; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.project_milestone (
    id integer NOT NULL,
    message_main_attachment_id integer,
    project_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    name character varying NOT NULL,
    deadline date,
    reached_date date,
    is_reached boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    sale_line_id integer,
    quantity_percentage double precision
);


ALTER TABLE public.project_milestone OWNER TO odoo;

--
-- Name: TABLE project_milestone; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.project_milestone IS 'Project Milestone';


--
-- Name: COLUMN project_milestone.message_main_attachment_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_milestone.message_main_attachment_id IS 'Main Attachment';


--
-- Name: COLUMN project_milestone.project_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_milestone.project_id IS 'Project';


--
-- Name: COLUMN project_milestone.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_milestone.create_uid IS 'Created by';


--
-- Name: COLUMN project_milestone.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_milestone.write_uid IS 'Last Updated by';


--
-- Name: COLUMN project_milestone.name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_milestone.name IS 'Name';


--
-- Name: COLUMN project_milestone.deadline; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_milestone.deadline IS 'Deadline';


--
-- Name: COLUMN project_milestone.reached_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_milestone.reached_date IS 'Reached Date';


--
-- Name: COLUMN project_milestone.is_reached; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_milestone.is_reached IS 'Reached';


--
-- Name: COLUMN project_milestone.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_milestone.create_date IS 'Created on';


--
-- Name: COLUMN project_milestone.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_milestone.write_date IS 'Last Updated on';


--
-- Name: COLUMN project_milestone.sale_line_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_milestone.sale_line_id IS 'Sales Order Item';


--
