-- 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.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: 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 SEQUENCE 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_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 SEQUENCE 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 SEQUENCE 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 SEQUENCE 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 SEQUENCE 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_message_translation; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mail_message_translation (
    id integer NOT NULL,
    message_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    source_lang character varying NOT NULL,
    target_lang character varying NOT NULL,
    body text NOT NULL,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.mail_message_translation OWNER TO odoo;

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

COMMENT ON TABLE public.mail_message_translation IS 'Message Translation';


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

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


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

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


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

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


--
-- Name: COLUMN mail_message_translation.source_lang; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_message_translation.source_lang IS 'Source Language';


--
-- Name: COLUMN mail_message_translation.target_lang; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_message_translation.target_lang IS 'Target Language';


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

COMMENT ON COLUMN public.mail_message_translation.body IS 'Translation Body';


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

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


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

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


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

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


ALTER SEQUENCE public.mail_message_translation_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.mail_message_translation_id_seq OWNED BY public.mail_message_translation.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_int 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_int; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_notification.sms_id_int IS 'SMS ID';


--
-- 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 SEQUENCE 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_push; Type: TABLE; Schema: public; Owner: odoo
--

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


ALTER TABLE public.mail_push OWNER TO odoo;

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

COMMENT ON TABLE public.mail_push IS 'Push Notifications';


--
-- Name: COLUMN mail_push.mail_push_device_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_push.mail_push_device_id IS 'devices';


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

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


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

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


--
-- Name: COLUMN mail_push.payload; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_push.payload IS 'Payload';


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

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


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

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


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

CREATE TABLE public.mail_push_device (
    id integer NOT NULL,
    partner_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    endpoint character varying NOT NULL,
    keys character varying NOT NULL,
    expiration_time timestamp without time zone,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.mail_push_device OWNER TO odoo;

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

COMMENT ON TABLE public.mail_push_device IS 'Push Notification Device';


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

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


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

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


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

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


--
-- Name: COLUMN mail_push_device.endpoint; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_push_device.endpoint IS 'Browser endpoint';


--
-- Name: COLUMN mail_push_device.keys; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_push_device.keys IS 'Browser keys';


--
-- Name: COLUMN mail_push_device.expiration_time; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_push_device.expiration_time IS 'Expiration Token Date';


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

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


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

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


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

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


ALTER SEQUENCE public.mail_push_device_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.mail_push_device_id_seq OWNED BY public.mail_push_device.id;


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

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


ALTER SEQUENCE public.mail_push_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.mail_push_id_seq OWNED BY public.mail_push.id;


--
-- 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 SEQUENCE 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,
    notification_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.notification_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_resend_partner.notification_id IS 'Notification';


--
-- 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 SEQUENCE 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_scheduled_message; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mail_scheduled_message (
    id integer NOT NULL,
    res_id integer NOT NULL,
    author_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    subject character varying,
    model character varying NOT NULL,
    body text,
    notification_parameters text,
    is_note boolean,
    scheduled_date timestamp without time zone NOT NULL,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.mail_scheduled_message OWNER TO odoo;

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

COMMENT ON TABLE public.mail_scheduled_message IS 'Scheduled Message';


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

COMMENT ON COLUMN public.mail_scheduled_message.res_id IS 'Related Document Id';


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

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


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

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


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

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


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

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


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

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


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

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


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

COMMENT ON COLUMN public.mail_scheduled_message.notification_parameters IS 'Notification parameters';


--
-- Name: COLUMN mail_scheduled_message.is_note; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_scheduled_message.is_note IS 'Is a note';


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

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


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

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


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

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


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

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


ALTER SEQUENCE public.mail_scheduled_message_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.mail_scheduled_message_id_seq OWNED BY public.mail_scheduled_message.id;


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

CREATE TABLE public.mail_scheduled_message_res_partner_rel (
    mail_scheduled_message_id integer NOT NULL,
    res_partner_id integer NOT NULL
);


ALTER TABLE public.mail_scheduled_message_res_partner_rel OWNER TO odoo;

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

COMMENT ON TABLE public.mail_scheduled_message_res_partner_rel IS 'RELATION BETWEEN mail_scheduled_message AND res_partner';


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

CREATE TABLE public.mail_template (
    id integer NOT NULL,
    model_id integer,
    user_id 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,
    email_layout_xmlid character varying,
    scheduled_date character varying,
    name jsonb,
    description jsonb,
    subject jsonb,
    body_html 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.user_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_template.user_id IS 'User';


--
-- 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.email_layout_xmlid; Type: COMMENT; Schema: public; Owner: odoo
--

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


--
-- 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.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 SEQUENCE 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_ir_actions_report_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.mail_template_ir_actions_report_rel (
    mail_template_id integer NOT NULL,
    ir_actions_report_id integer NOT NULL
);


ALTER TABLE public.mail_template_ir_actions_report_rel OWNER TO odoo;

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

COMMENT ON TABLE public.mail_template_ir_actions_report_rel IS 'RELATION BETWEEN mail_template AND ir_act_report_xml';


--
-- 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,
    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.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 SEQUENCE 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 SEQUENCE 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_id integer,
    old_value_integer integer,
    new_value_integer integer,
    currency_id integer,
    mail_message_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    old_value_char character varying,
    new_value_char character varying,
    field_info jsonb,
    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,
    new_value_float 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_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_tracking_value.field_id 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.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.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.field_info; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_tracking_value.field_info IS 'Removed field information';


--
-- 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.new_value_float; Type: COMMENT; Schema: public; Owner: odoo
--

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


--
-- 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 SEQUENCE 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,
    notify 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.notify; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mail_wizard_invite.notify IS 'Notify Recipients';


--
-- 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 SEQUENCE 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: maintenance_equipment; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.maintenance_equipment (
    id integer NOT NULL,
    company_id integer,
    maintenance_team_id integer,
    technician_user_id integer,
    maintenance_count integer,
    maintenance_open_count integer,
    expected_mtbf integer,
    owner_user_id integer,
    category_id integer,
    partner_id integer,
    color integer,
    create_uid integer,
    write_uid integer,
    partner_ref character varying,
    location character varying,
    model character varying,
    serial_no character varying,
    effective_date date NOT NULL,
    assign_date date,
    warranty_date date,
    scrap_date date,
    name jsonb NOT NULL,
    equipment_properties jsonb,
    note text,
    active boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    cost double precision,
    employee_id integer,
    department_id integer,
    equipment_assign_to character varying NOT NULL
);


ALTER TABLE public.maintenance_equipment OWNER TO odoo;

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

COMMENT ON TABLE public.maintenance_equipment IS 'Maintenance Equipment';


--
-- Name: COLUMN maintenance_equipment.company_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_equipment.company_id IS 'Company';


--
-- Name: COLUMN maintenance_equipment.maintenance_team_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_equipment.maintenance_team_id IS 'Maintenance Team';


--
-- Name: COLUMN maintenance_equipment.technician_user_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_equipment.technician_user_id IS 'Technician';


--
-- Name: COLUMN maintenance_equipment.maintenance_count; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_equipment.maintenance_count IS 'Maintenance Count';


--
-- Name: COLUMN maintenance_equipment.maintenance_open_count; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_equipment.maintenance_open_count IS 'Current Maintenance';


--
-- Name: COLUMN maintenance_equipment.expected_mtbf; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_equipment.expected_mtbf IS 'Expected MTBF';


--
-- Name: COLUMN maintenance_equipment.owner_user_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_equipment.owner_user_id IS 'Owner';


--
-- Name: COLUMN maintenance_equipment.category_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_equipment.category_id IS 'Equipment Category';


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

COMMENT ON COLUMN public.maintenance_equipment.partner_id IS 'Vendor';


--
-- Name: COLUMN maintenance_equipment.color; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_equipment.color IS 'Color Index';


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

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


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

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


--
-- Name: COLUMN maintenance_equipment.partner_ref; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_equipment.partner_ref IS 'Vendor Reference';


--
-- Name: COLUMN maintenance_equipment.location; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_equipment.location IS 'Location';


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

COMMENT ON COLUMN public.maintenance_equipment.model IS 'Model';


--
-- Name: COLUMN maintenance_equipment.serial_no; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_equipment.serial_no IS 'Serial Number';


--
-- Name: COLUMN maintenance_equipment.effective_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_equipment.effective_date IS 'Effective Date';


--
-- Name: COLUMN maintenance_equipment.assign_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_equipment.assign_date IS 'Assigned Date';


--
-- Name: COLUMN maintenance_equipment.warranty_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_equipment.warranty_date IS 'Warranty Expiration Date';


--
-- Name: COLUMN maintenance_equipment.scrap_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_equipment.scrap_date IS 'Scrap Date';


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

COMMENT ON COLUMN public.maintenance_equipment.name IS 'Equipment Name';


--
-- Name: COLUMN maintenance_equipment.equipment_properties; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_equipment.equipment_properties IS 'Properties';


--
-- Name: COLUMN maintenance_equipment.note; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_equipment.note IS 'Note';


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

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


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

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


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

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


--
-- Name: COLUMN maintenance_equipment.cost; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_equipment.cost IS 'Cost';


--
-- Name: COLUMN maintenance_equipment.employee_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_equipment.employee_id IS 'Assigned Employee';


--
-- Name: COLUMN maintenance_equipment.department_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_equipment.department_id IS 'Assigned Department';


--
-- Name: COLUMN maintenance_equipment.equipment_assign_to; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_equipment.equipment_assign_to IS 'Used By';


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

CREATE TABLE public.maintenance_equipment_category (
    id integer NOT NULL,
    alias_id integer NOT NULL,
    company_id integer,
    technician_user_id integer,
    color integer,
    create_uid integer,
    write_uid integer,
    name jsonb NOT NULL,
    note jsonb,
    equipment_properties_definition jsonb,
    fold boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.maintenance_equipment_category OWNER TO odoo;

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

COMMENT ON TABLE public.maintenance_equipment_category IS 'Maintenance Equipment Category';


--
-- Name: COLUMN maintenance_equipment_category.alias_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_equipment_category.alias_id IS 'Alias';


--
-- Name: COLUMN maintenance_equipment_category.company_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_equipment_category.company_id IS 'Company';


--
-- Name: COLUMN maintenance_equipment_category.technician_user_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_equipment_category.technician_user_id IS 'Responsible';


--
-- Name: COLUMN maintenance_equipment_category.color; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_equipment_category.color IS 'Color Index';


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

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


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

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


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

COMMENT ON COLUMN public.maintenance_equipment_category.name IS 'Category Name';


--
-- Name: COLUMN maintenance_equipment_category.note; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_equipment_category.note IS 'Comments';


--
-- Name: COLUMN maintenance_equipment_category.equipment_properties_definition; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_equipment_category.equipment_properties_definition IS 'Equipment Properties';


--
-- Name: COLUMN maintenance_equipment_category.fold; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_equipment_category.fold IS 'Folded in Maintenance Pipe';


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

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


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

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


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

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


ALTER SEQUENCE public.maintenance_equipment_category_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.maintenance_equipment_category_id_seq OWNED BY public.maintenance_equipment_category.id;


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

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


ALTER SEQUENCE public.maintenance_equipment_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.maintenance_equipment_id_seq OWNED BY public.maintenance_equipment.id;


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

CREATE TABLE public.maintenance_request (
    id integer NOT NULL,
    company_id integer NOT NULL,
    owner_user_id integer,
    category_id integer,
    equipment_id integer,
    user_id integer,
    stage_id integer,
    color integer,
    maintenance_team_id integer NOT NULL,
    repeat_interval integer,
    create_uid integer,
    write_uid integer,
    email_cc character varying,
    name character varying NOT NULL,
    priority character varying,
    kanban_state character varying NOT NULL,
    maintenance_type character varying,
    instruction_type character varying,
    instruction_google_slide character varying,
    repeat_unit character varying,
    repeat_type character varying,
    request_date date,
    close_date date,
    repeat_until date,
    description text,
    instruction_text text,
    archive boolean,
    recurring_maintenance boolean,
    schedule_date timestamp without time zone,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    duration double precision,
    employee_id integer
);


ALTER TABLE public.maintenance_request OWNER TO odoo;

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

COMMENT ON TABLE public.maintenance_request IS 'Maintenance Request';


--
-- Name: COLUMN maintenance_request.company_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_request.company_id IS 'Company';


--
-- Name: COLUMN maintenance_request.owner_user_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_request.owner_user_id IS 'Created by User';


--
-- Name: COLUMN maintenance_request.category_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_request.category_id IS 'Category';


--
-- Name: COLUMN maintenance_request.equipment_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_request.equipment_id IS 'Equipment';


--
-- Name: COLUMN maintenance_request.user_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_request.user_id IS 'Technician';


--
-- Name: COLUMN maintenance_request.stage_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_request.stage_id IS 'Stage';


--
-- Name: COLUMN maintenance_request.color; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_request.color IS 'Color Index';


--
-- Name: COLUMN maintenance_request.maintenance_team_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_request.maintenance_team_id IS 'Team';


--
-- Name: COLUMN maintenance_request.repeat_interval; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_request.repeat_interval IS 'Repeat Every';


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

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


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

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


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

COMMENT ON COLUMN public.maintenance_request.email_cc IS 'Email cc';


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

COMMENT ON COLUMN public.maintenance_request.name IS 'Subjects';


--
-- Name: COLUMN maintenance_request.priority; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_request.priority IS 'Priority';


--
-- Name: COLUMN maintenance_request.kanban_state; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_request.kanban_state IS 'Kanban State';


--
-- Name: COLUMN maintenance_request.maintenance_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_request.maintenance_type IS 'Maintenance Type';


--
-- Name: COLUMN maintenance_request.instruction_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_request.instruction_type IS 'Instruction';


--
-- Name: COLUMN maintenance_request.instruction_google_slide; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_request.instruction_google_slide IS 'Google Slide';


--
-- Name: COLUMN maintenance_request.repeat_unit; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_request.repeat_unit IS 'Repeat Unit';


--
-- Name: COLUMN maintenance_request.repeat_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_request.repeat_type IS 'Until';


--
-- Name: COLUMN maintenance_request.request_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_request.request_date IS 'Request Date';


--
-- Name: COLUMN maintenance_request.close_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_request.close_date IS 'Close Date';


--
-- Name: COLUMN maintenance_request.repeat_until; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_request.repeat_until IS 'End Date';


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

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


--
-- Name: COLUMN maintenance_request.instruction_text; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_request.instruction_text IS 'Text';


--
-- Name: COLUMN maintenance_request.archive; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_request.archive IS 'Archive';


--
-- Name: COLUMN maintenance_request.recurring_maintenance; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_request.recurring_maintenance IS 'Recurrent';


--
-- Name: COLUMN maintenance_request.schedule_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_request.schedule_date IS 'Scheduled Date';


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

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


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

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


--
-- Name: COLUMN maintenance_request.duration; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_request.duration IS 'Duration';


--
-- Name: COLUMN maintenance_request.employee_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_request.employee_id IS 'Employee';


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

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


ALTER SEQUENCE public.maintenance_request_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.maintenance_request_id_seq OWNED BY public.maintenance_request.id;


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

CREATE TABLE public.maintenance_stage (
    id integer NOT NULL,
    sequence integer,
    create_uid integer,
    write_uid integer,
    name jsonb NOT NULL,
    fold boolean,
    done boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.maintenance_stage OWNER TO odoo;

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

COMMENT ON TABLE public.maintenance_stage IS 'Maintenance Stage';


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

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


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

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


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

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


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

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


--
-- Name: COLUMN maintenance_stage.fold; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_stage.fold IS 'Folded in Maintenance Pipe';


--
-- Name: COLUMN maintenance_stage.done; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_stage.done IS 'Request Done';


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

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


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

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


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

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


ALTER SEQUENCE public.maintenance_stage_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.maintenance_stage_id_seq OWNED BY public.maintenance_stage.id;


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

CREATE TABLE public.maintenance_team (
    id integer NOT NULL,
    company_id integer,
    color integer,
    create_uid integer,
    write_uid integer,
    name jsonb NOT NULL,
    active boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.maintenance_team OWNER TO odoo;

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

COMMENT ON TABLE public.maintenance_team IS 'Maintenance Teams';


--
-- Name: COLUMN maintenance_team.company_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_team.company_id IS 'Company';


--
-- Name: COLUMN maintenance_team.color; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.maintenance_team.color IS 'Color Index';


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

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


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

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


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

COMMENT ON COLUMN public.maintenance_team.name IS 'Team Name';


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

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


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

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


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

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


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

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


ALTER SEQUENCE public.maintenance_team_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.maintenance_team_id_seq OWNED BY public.maintenance_team.id;


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

CREATE TABLE public.maintenance_team_users_rel (
    maintenance_team_id integer NOT NULL,
    res_users_id integer NOT NULL
);


ALTER TABLE public.maintenance_team_users_rel OWNER TO odoo;

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

COMMENT ON TABLE public.maintenance_team_users_rel IS 'RELATION BETWEEN maintenance_team AND res_users';


--
-- 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: module_country; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.module_country (
    module_id integer NOT NULL,
    country_id integer NOT NULL
);


ALTER TABLE public.module_country OWNER TO odoo;

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

COMMENT ON TABLE public.module_country IS 'RELATION BETWEEN ir_module_module AND res_country';


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

CREATE TABLE public.mrp_account_wip_accounting (
    id integer NOT NULL,
    journal_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    reference character varying,
    date date,
    reversal_date date NOT NULL,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.mrp_account_wip_accounting OWNER TO odoo;

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

COMMENT ON TABLE public.mrp_account_wip_accounting IS 'Wizard to post Manufacturing WIP account move';


--
-- Name: COLUMN mrp_account_wip_accounting.journal_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_account_wip_accounting.journal_id IS 'Journal';


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

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


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

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


--
-- Name: COLUMN mrp_account_wip_accounting.reference; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_account_wip_accounting.reference IS 'Reference';


--
-- Name: COLUMN mrp_account_wip_accounting.date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_account_wip_accounting.date IS 'Date';


--
-- Name: COLUMN mrp_account_wip_accounting.reversal_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_account_wip_accounting.reversal_date IS 'Reversal Date';


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

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


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

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


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

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


ALTER SEQUENCE public.mrp_account_wip_accounting_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.mrp_account_wip_accounting_id_seq OWNED BY public.mrp_account_wip_accounting.id;


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

CREATE TABLE public.mrp_account_wip_accounting_line (
    id integer NOT NULL,
    account_id integer,
    currency_id integer,
    wip_accounting_id integer,
    create_uid integer,
    write_uid integer,
    label character varying,
    debit numeric,
    credit numeric,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    CONSTRAINT mrp_account_wip_accounting_line_check_debit_credit CHECK (((debit = (0)::numeric) OR (credit = (0)::numeric)))
);


ALTER TABLE public.mrp_account_wip_accounting_line OWNER TO odoo;

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

COMMENT ON TABLE public.mrp_account_wip_accounting_line IS 'Account move line to be created when posting WIP account move';


--
-- Name: COLUMN mrp_account_wip_accounting_line.account_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_account_wip_accounting_line.account_id IS 'Account';


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

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


--
-- Name: COLUMN mrp_account_wip_accounting_line.wip_accounting_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_account_wip_accounting_line.wip_accounting_id IS 'WIP accounting wizard';


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

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


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

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


--
-- Name: COLUMN mrp_account_wip_accounting_line.label; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_account_wip_accounting_line.label IS 'Label';


--
-- Name: COLUMN mrp_account_wip_accounting_line.debit; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_account_wip_accounting_line.debit IS 'Debit';


--
-- Name: COLUMN mrp_account_wip_accounting_line.credit; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_account_wip_accounting_line.credit IS 'Credit';


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

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


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

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


--
-- Name: CONSTRAINT mrp_account_wip_accounting_line_check_debit_credit ON mrp_account_wip_accounting_line; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT mrp_account_wip_accounting_line_check_debit_credit ON public.mrp_account_wip_accounting_line IS 'CHECK ( debit = 0 OR credit = 0 )';


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

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


ALTER SEQUENCE public.mrp_account_wip_accounting_line_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.mrp_account_wip_accounting_line_id_seq OWNED BY public.mrp_account_wip_accounting_line.id;


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

CREATE TABLE public.mrp_account_wip_accounting_mrp_production_rel (
    mrp_account_wip_accounting_id integer NOT NULL,
    mrp_production_id integer NOT NULL
);


ALTER TABLE public.mrp_account_wip_accounting_mrp_production_rel OWNER TO odoo;

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

COMMENT ON TABLE public.mrp_account_wip_accounting_mrp_production_rel IS 'RELATION BETWEEN mrp_account_wip_accounting AND mrp_production';


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

CREATE TABLE public.mrp_batch_produce (
    id integer NOT NULL,
    production_id integer,
    lot_qty integer,
    create_uid integer,
    write_uid integer,
    lot_name character varying,
    component_separator character varying NOT NULL,
    lots_separator character varying NOT NULL,
    lots_quantity_separator character varying NOT NULL,
    production_text text,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.mrp_batch_produce OWNER TO odoo;

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

COMMENT ON TABLE public.mrp_batch_produce IS 'Produce a batch of production order';


--
-- Name: COLUMN mrp_batch_produce.production_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_batch_produce.production_id IS 'Production';


--
-- Name: COLUMN mrp_batch_produce.lot_qty; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_batch_produce.lot_qty IS 'Number of SN';


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

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


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

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


--
-- Name: COLUMN mrp_batch_produce.lot_name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_batch_produce.lot_name IS 'First Lot/SN';


--
-- Name: COLUMN mrp_batch_produce.component_separator; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_batch_produce.component_separator IS 'Component separator';


--
-- Name: COLUMN mrp_batch_produce.lots_separator; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_batch_produce.lots_separator IS 'Lot separator';


--
-- Name: COLUMN mrp_batch_produce.lots_quantity_separator; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_batch_produce.lots_quantity_separator IS 'Lot quantity separator';


--
-- Name: COLUMN mrp_batch_produce.production_text; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_batch_produce.production_text IS 'Batch Production';


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

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


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

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


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

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


ALTER SEQUENCE public.mrp_batch_produce_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.mrp_batch_produce_id_seq OWNED BY public.mrp_batch_produce.id;


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

CREATE TABLE public.mrp_bom (
    id integer NOT NULL,
    product_tmpl_id integer NOT NULL,
    product_id integer,
    product_uom_id integer NOT NULL,
    sequence integer,
    picking_type_id integer,
    company_id integer,
    produce_delay integer,
    days_to_prepare_mo integer,
    create_uid integer,
    write_uid integer,
    code character varying,
    type character varying NOT NULL,
    ready_to_produce character varying NOT NULL,
    consumption character varying NOT NULL,
    product_qty numeric NOT NULL,
    active boolean,
    allow_operation_dependencies boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    project_id integer,
    CONSTRAINT mrp_bom_qty_positive CHECK ((product_qty > (0)::numeric))
);


ALTER TABLE public.mrp_bom OWNER TO odoo;

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

COMMENT ON TABLE public.mrp_bom IS 'Bill of Material';


--
-- Name: COLUMN mrp_bom.product_tmpl_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_bom.product_tmpl_id IS 'Product';


--
-- Name: COLUMN mrp_bom.product_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_bom.product_id IS 'Product Variant';


--
-- Name: COLUMN mrp_bom.product_uom_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_bom.product_uom_id IS 'Unit of Measure';


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

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


--
-- Name: COLUMN mrp_bom.picking_type_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_bom.picking_type_id IS 'Operation Type';


--
-- Name: COLUMN mrp_bom.company_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_bom.company_id IS 'Company';


--
-- Name: COLUMN mrp_bom.produce_delay; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_bom.produce_delay IS 'Manufacturing Lead Time';


--
-- Name: COLUMN mrp_bom.days_to_prepare_mo; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_bom.days_to_prepare_mo IS 'Days to prepare Manufacturing Order';


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

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


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

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


--
-- Name: COLUMN mrp_bom.code; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_bom.code IS 'Reference';


--
-- Name: COLUMN mrp_bom.type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_bom.type IS 'BoM Type';


--
-- Name: COLUMN mrp_bom.ready_to_produce; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_bom.ready_to_produce IS 'Manufacturing Readiness';


--
-- Name: COLUMN mrp_bom.consumption; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_bom.consumption IS 'Flexible Consumption';


--
-- Name: COLUMN mrp_bom.product_qty; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_bom.product_qty IS 'Quantity';


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

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


--
-- Name: COLUMN mrp_bom.allow_operation_dependencies; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_bom.allow_operation_dependencies IS 'Operation Dependencies';


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

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


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

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


--
-- Name: COLUMN mrp_bom.project_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_bom.project_id IS 'Project';


--
-- Name: CONSTRAINT mrp_bom_qty_positive ON mrp_bom; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT mrp_bom_qty_positive ON public.mrp_bom IS 'check (product_qty > 0)';


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

CREATE TABLE public.mrp_bom_byproduct (
    id integer NOT NULL,
    product_id integer NOT NULL,
    company_id integer,
    product_uom_id integer NOT NULL,
    bom_id integer,
    operation_id integer,
    sequence integer,
    create_uid integer,
    write_uid integer,
    product_qty numeric NOT NULL,
    cost_share numeric,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.mrp_bom_byproduct OWNER TO odoo;

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

COMMENT ON TABLE public.mrp_bom_byproduct IS 'Byproduct';


--
-- Name: COLUMN mrp_bom_byproduct.product_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_bom_byproduct.product_id IS 'By-product';


--
-- Name: COLUMN mrp_bom_byproduct.company_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_bom_byproduct.company_id IS 'Company';


--
-- Name: COLUMN mrp_bom_byproduct.product_uom_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_bom_byproduct.product_uom_id IS 'Unit of Measure';


--
-- Name: COLUMN mrp_bom_byproduct.bom_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_bom_byproduct.bom_id IS 'BoM';


--
-- Name: COLUMN mrp_bom_byproduct.operation_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_bom_byproduct.operation_id IS 'Produced in Operation';


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

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


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

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


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

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


--
-- Name: COLUMN mrp_bom_byproduct.product_qty; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_bom_byproduct.product_qty IS 'Quantity';


--
-- Name: COLUMN mrp_bom_byproduct.cost_share; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_bom_byproduct.cost_share IS 'Cost Share (%)';


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

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


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

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


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

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


ALTER SEQUENCE public.mrp_bom_byproduct_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.mrp_bom_byproduct_id_seq OWNED BY public.mrp_bom_byproduct.id;


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

CREATE TABLE public.mrp_bom_byproduct_product_template_attribute_value_rel (
    mrp_bom_byproduct_id integer NOT NULL,
    product_template_attribute_value_id integer NOT NULL
);


ALTER TABLE public.mrp_bom_byproduct_product_template_attribute_value_rel OWNER TO odoo;

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

COMMENT ON TABLE public.mrp_bom_byproduct_product_template_attribute_value_rel IS 'RELATION BETWEEN mrp_bom_byproduct AND product_template_attribute_value';


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

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


ALTER SEQUENCE public.mrp_bom_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.mrp_bom_id_seq OWNED BY public.mrp_bom.id;


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

CREATE TABLE public.mrp_bom_line (
    id integer NOT NULL,
    product_id integer NOT NULL,
    product_tmpl_id integer,
    company_id integer,
    product_uom_id integer NOT NULL,
    sequence integer,
    bom_id integer NOT NULL,
    operation_id integer,
    create_uid integer,
    write_uid integer,
    product_qty numeric NOT NULL,
    manual_consumption boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    cost_share numeric,
    CONSTRAINT mrp_bom_line_bom_qty_zero CHECK ((product_qty >= (0)::numeric))
);


ALTER TABLE public.mrp_bom_line OWNER TO odoo;

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

COMMENT ON TABLE public.mrp_bom_line IS 'Bill of Material Line';


--
-- Name: COLUMN mrp_bom_line.product_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_bom_line.product_id IS 'Component';


--
-- Name: COLUMN mrp_bom_line.product_tmpl_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_bom_line.product_tmpl_id IS 'Product Template';


--
-- Name: COLUMN mrp_bom_line.company_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_bom_line.company_id IS 'Company';


--
-- Name: COLUMN mrp_bom_line.product_uom_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_bom_line.product_uom_id IS 'Product Unit of Measure';


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

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


--
-- Name: COLUMN mrp_bom_line.bom_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_bom_line.bom_id IS 'Parent BoM';


--
-- Name: COLUMN mrp_bom_line.operation_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_bom_line.operation_id IS 'Consumed in Operation';


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

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


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

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


--
-- Name: COLUMN mrp_bom_line.product_qty; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_bom_line.product_qty IS 'Quantity';


--
-- Name: COLUMN mrp_bom_line.manual_consumption; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_bom_line.manual_consumption IS 'Highlight Consumption';


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

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


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

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


--
-- Name: COLUMN mrp_bom_line.cost_share; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_bom_line.cost_share IS 'Cost Share (%)';


--
-- Name: CONSTRAINT mrp_bom_line_bom_qty_zero ON mrp_bom_line; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT mrp_bom_line_bom_qty_zero ON public.mrp_bom_line IS 'CHECK (product_qty>=0)';


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

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


ALTER SEQUENCE public.mrp_bom_line_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.mrp_bom_line_id_seq OWNED BY public.mrp_bom_line.id;


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

CREATE TABLE public.mrp_bom_line_product_template_attribute_value_rel (
    mrp_bom_line_id integer NOT NULL,
    product_template_attribute_value_id integer NOT NULL
);


ALTER TABLE public.mrp_bom_line_product_template_attribute_value_rel OWNER TO odoo;

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

COMMENT ON TABLE public.mrp_bom_line_product_template_attribute_value_rel IS 'RELATION BETWEEN mrp_bom_line AND product_template_attribute_value';


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

CREATE TABLE public.mrp_consumption_warning (
    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.mrp_consumption_warning OWNER TO odoo;

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

COMMENT ON TABLE public.mrp_consumption_warning IS 'Wizard in case of consumption in warning/strict and more component has been used for a MO (related to the bom)';


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

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


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

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


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

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


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

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


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

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


ALTER SEQUENCE public.mrp_consumption_warning_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.mrp_consumption_warning_id_seq OWNED BY public.mrp_consumption_warning.id;


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

CREATE TABLE public.mrp_consumption_warning_line (
    id integer NOT NULL,
    mrp_consumption_warning_id integer NOT NULL,
    mrp_production_id integer NOT NULL,
    product_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    product_consumed_qty_uom double precision,
    product_expected_qty_uom double precision
);


ALTER TABLE public.mrp_consumption_warning_line OWNER TO odoo;

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

COMMENT ON TABLE public.mrp_consumption_warning_line IS 'Line of issue consumption';


--
-- Name: COLUMN mrp_consumption_warning_line.mrp_consumption_warning_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_consumption_warning_line.mrp_consumption_warning_id IS 'Parent Wizard';


--
-- Name: COLUMN mrp_consumption_warning_line.mrp_production_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_consumption_warning_line.mrp_production_id IS 'Manufacturing Order';


--
-- Name: COLUMN mrp_consumption_warning_line.product_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_consumption_warning_line.product_id IS 'Product';


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

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


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

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


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

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


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

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


--
-- Name: COLUMN mrp_consumption_warning_line.product_consumed_qty_uom; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_consumption_warning_line.product_consumed_qty_uom IS 'Consumed';


--
-- Name: COLUMN mrp_consumption_warning_line.product_expected_qty_uom; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_consumption_warning_line.product_expected_qty_uom IS 'To Consume';


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

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


ALTER SEQUENCE public.mrp_consumption_warning_line_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.mrp_consumption_warning_line_id_seq OWNED BY public.mrp_consumption_warning_line.id;


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

CREATE TABLE public.mrp_consumption_warning_mrp_production_rel (
    mrp_consumption_warning_id integer NOT NULL,
    mrp_production_id integer NOT NULL
);


ALTER TABLE public.mrp_consumption_warning_mrp_production_rel OWNER TO odoo;

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

COMMENT ON TABLE public.mrp_consumption_warning_mrp_production_rel IS 'RELATION BETWEEN mrp_consumption_warning AND mrp_production';


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

CREATE TABLE public.mrp_production (
    id integer NOT NULL,
    backorder_sequence integer,
    product_id integer NOT NULL,
    product_uom_id integer NOT NULL,
    lot_producing_id integer,
    picking_type_id integer NOT NULL,
    location_src_id integer NOT NULL,
    location_dest_id integer NOT NULL,
    location_final_id integer,
    bom_id integer,
    user_id integer,
    company_id integer NOT NULL,
    procurement_group_id integer,
    orderpoint_id integer,
    production_location_id integer,
    create_uid integer,
    write_uid integer,
    name character varying,
    priority character varying,
    origin character varying,
    state character varying,
    reservation_state character varying,
    product_description_variants character varying,
    consumption character varying NOT NULL,
    product_qty numeric NOT NULL,
    qty_producing numeric,
    propagate_cancel boolean,
    is_locked boolean,
    is_planned boolean,
    allow_workorder_dependencies boolean,
    is_outdated_bom boolean,
    date_deadline timestamp without time zone,
    date_start timestamp without time zone NOT NULL,
    date_finished timestamp without time zone,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    product_uom_qty double precision,
    extra_cost double precision,
    project_id integer,
    sale_line_id integer,
    CONSTRAINT mrp_production_qty_positive CHECK ((product_qty > (0)::numeric))
);


ALTER TABLE public.mrp_production OWNER TO odoo;

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

COMMENT ON TABLE public.mrp_production IS 'Manufacturing Order';


--
-- Name: COLUMN mrp_production.backorder_sequence; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_production.backorder_sequence IS 'Backorder Sequence';


--
-- Name: COLUMN mrp_production.product_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_production.product_id IS 'Product';


--
-- Name: COLUMN mrp_production.product_uom_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_production.product_uom_id IS 'Product Unit of Measure';


--
-- Name: COLUMN mrp_production.lot_producing_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_production.lot_producing_id IS 'Lot/Serial Number';


--
-- Name: COLUMN mrp_production.picking_type_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_production.picking_type_id IS 'Operation Type';


--
-- Name: COLUMN mrp_production.location_src_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_production.location_src_id IS 'Components Location';


--
-- Name: COLUMN mrp_production.location_dest_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_production.location_dest_id IS 'Finished Products Location';


--
-- Name: COLUMN mrp_production.location_final_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_production.location_final_id IS 'Final Location from procurement';


--
-- Name: COLUMN mrp_production.bom_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_production.bom_id IS 'Bill of Material';


--
-- Name: COLUMN mrp_production.user_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_production.user_id IS 'Responsible';


--
-- Name: COLUMN mrp_production.company_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_production.company_id IS 'Company';


--
-- Name: COLUMN mrp_production.procurement_group_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_production.procurement_group_id IS 'Procurement Group';


--
-- Name: COLUMN mrp_production.orderpoint_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_production.orderpoint_id IS 'Orderpoint';


--
-- Name: COLUMN mrp_production.production_location_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_production.production_location_id IS 'Production Location';


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

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


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

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


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

COMMENT ON COLUMN public.mrp_production.name IS 'Reference';


--
-- Name: COLUMN mrp_production.priority; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_production.priority IS 'Priority';


--
-- Name: COLUMN mrp_production.origin; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_production.origin IS 'Source';


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

COMMENT ON COLUMN public.mrp_production.state IS 'State';


--
-- Name: COLUMN mrp_production.reservation_state; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_production.reservation_state IS 'MO Readiness';


--
-- Name: COLUMN mrp_production.product_description_variants; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_production.product_description_variants IS 'Custom Description';


--
-- Name: COLUMN mrp_production.consumption; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_production.consumption IS 'Consumption';


--
-- Name: COLUMN mrp_production.product_qty; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_production.product_qty IS 'Quantity To Produce';


--
-- Name: COLUMN mrp_production.qty_producing; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_production.qty_producing IS 'Quantity Producing';


--
-- Name: COLUMN mrp_production.propagate_cancel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_production.propagate_cancel IS 'Propagate cancel and split';


--
-- Name: COLUMN mrp_production.is_locked; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_production.is_locked IS 'Is Locked';


--
-- Name: COLUMN mrp_production.is_planned; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_production.is_planned IS 'Its Operations are Planned';


--
-- Name: COLUMN mrp_production.allow_workorder_dependencies; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_production.allow_workorder_dependencies IS 'Allow Work Order Dependencies';


--
-- Name: COLUMN mrp_production.is_outdated_bom; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_production.is_outdated_bom IS 'Outdated BoM';


--
-- Name: COLUMN mrp_production.date_deadline; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_production.date_deadline IS 'Deadline';


--
-- Name: COLUMN mrp_production.date_start; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_production.date_start IS 'Start';


--
-- Name: COLUMN mrp_production.date_finished; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_production.date_finished IS 'End';


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

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


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

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


--
-- Name: COLUMN mrp_production.product_uom_qty; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_production.product_uom_qty IS 'Total Quantity';


--
-- Name: COLUMN mrp_production.extra_cost; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_production.extra_cost IS 'Extra Unit Cost';


--
-- Name: COLUMN mrp_production.project_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_production.project_id IS 'Project';


--
-- Name: COLUMN mrp_production.sale_line_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_production.sale_line_id IS 'Origin sale order line';


--
-- Name: CONSTRAINT mrp_production_qty_positive ON mrp_production; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT mrp_production_qty_positive ON public.mrp_production IS 'check (product_qty > 0)';


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

CREATE TABLE public.mrp_production_backorder (
    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.mrp_production_backorder OWNER TO odoo;

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

COMMENT ON TABLE public.mrp_production_backorder IS 'Wizard to mark as done or create back order';


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

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


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

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


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

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


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

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


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

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


ALTER SEQUENCE public.mrp_production_backorder_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.mrp_production_backorder_id_seq OWNED BY public.mrp_production_backorder.id;


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

CREATE TABLE public.mrp_production_backorder_line (
    id integer NOT NULL,
    mrp_production_backorder_id integer NOT NULL,
    mrp_production_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    to_backorder boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.mrp_production_backorder_line OWNER TO odoo;

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

COMMENT ON TABLE public.mrp_production_backorder_line IS 'Backorder Confirmation Line';


--
-- Name: COLUMN mrp_production_backorder_line.mrp_production_backorder_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_production_backorder_line.mrp_production_backorder_id IS 'MO Backorder';


--
-- Name: COLUMN mrp_production_backorder_line.mrp_production_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_production_backorder_line.mrp_production_id IS 'Manufacturing Order';


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

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


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

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


--
-- Name: COLUMN mrp_production_backorder_line.to_backorder; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_production_backorder_line.to_backorder IS 'To Backorder';


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

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


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

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


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

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


ALTER SEQUENCE public.mrp_production_backorder_line_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.mrp_production_backorder_line_id_seq OWNED BY public.mrp_production_backorder_line.id;


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

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


ALTER SEQUENCE public.mrp_production_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.mrp_production_id_seq OWNED BY public.mrp_production.id;


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

CREATE TABLE public.mrp_production_mrp_production_backorder_rel (
    mrp_production_backorder_id integer NOT NULL,
    mrp_production_id integer NOT NULL
);


ALTER TABLE public.mrp_production_mrp_production_backorder_rel OWNER TO odoo;

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

COMMENT ON TABLE public.mrp_production_mrp_production_backorder_rel IS 'RELATION BETWEEN mrp_production_backorder AND mrp_production';


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

CREATE TABLE public.mrp_production_picking_label_type_rel (
    picking_label_type_id integer NOT NULL,
    mrp_production_id integer NOT NULL
);


ALTER TABLE public.mrp_production_picking_label_type_rel OWNER TO odoo;

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

COMMENT ON TABLE public.mrp_production_picking_label_type_rel IS 'RELATION BETWEEN picking_label_type AND mrp_production';


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

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


ALTER TABLE public.mrp_production_split OWNER TO odoo;

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

COMMENT ON TABLE public.mrp_production_split IS 'Wizard to Split a Production';


--
-- Name: COLUMN mrp_production_split.production_split_multi_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_production_split.production_split_multi_id IS 'Split Productions';


--
-- Name: COLUMN mrp_production_split.production_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_production_split.production_id IS 'Manufacturing Order';


--
-- Name: COLUMN mrp_production_split.counter; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_production_split.counter IS 'Split #';


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

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


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

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


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

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


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

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


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

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


ALTER SEQUENCE public.mrp_production_split_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.mrp_production_split_id_seq OWNED BY public.mrp_production_split.id;


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

CREATE TABLE public.mrp_production_split_line (
    id integer NOT NULL,
    mrp_production_split_id integer NOT NULL,
    user_id integer,
    create_uid integer,
    write_uid integer,
    quantity numeric NOT NULL,
    date timestamp without time zone,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.mrp_production_split_line OWNER TO odoo;

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

COMMENT ON TABLE public.mrp_production_split_line IS 'Split Production Detail';


--
-- Name: COLUMN mrp_production_split_line.mrp_production_split_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_production_split_line.mrp_production_split_id IS 'Split Production';


--
-- Name: COLUMN mrp_production_split_line.user_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_production_split_line.user_id IS 'Responsible';


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

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


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

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


--
-- Name: COLUMN mrp_production_split_line.quantity; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_production_split_line.quantity IS 'Quantity To Produce';


--
-- Name: COLUMN mrp_production_split_line.date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_production_split_line.date IS 'Schedule Date';


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

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


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

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


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

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


ALTER SEQUENCE public.mrp_production_split_line_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.mrp_production_split_line_id_seq OWNED BY public.mrp_production_split_line.id;


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

CREATE TABLE public.mrp_production_split_multi (
    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.mrp_production_split_multi OWNER TO odoo;

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

COMMENT ON TABLE public.mrp_production_split_multi IS 'Wizard to Split Multiple Productions';


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

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


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

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


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

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


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

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


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

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


ALTER SEQUENCE public.mrp_production_split_multi_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.mrp_production_split_multi_id_seq OWNED BY public.mrp_production_split_multi.id;


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

CREATE TABLE public.mrp_routing_workcenter (
    id integer NOT NULL,
    workcenter_id integer NOT NULL,
    sequence integer,
    bom_id integer NOT NULL,
    time_mode_batch integer,
    create_uid integer,
    write_uid integer,
    name character varying NOT NULL,
    worksheet_type character varying,
    worksheet_google_slide character varying,
    time_mode character varying,
    note text,
    active boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    time_cycle_manual double precision
);


ALTER TABLE public.mrp_routing_workcenter OWNER TO odoo;

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

COMMENT ON TABLE public.mrp_routing_workcenter IS 'Work Center Usage';


--
-- Name: COLUMN mrp_routing_workcenter.workcenter_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_routing_workcenter.workcenter_id IS 'Work Center';


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

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


--
-- Name: COLUMN mrp_routing_workcenter.bom_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_routing_workcenter.bom_id IS 'Bill of Material';


--
-- Name: COLUMN mrp_routing_workcenter.time_mode_batch; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_routing_workcenter.time_mode_batch IS 'Based on';


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

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


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

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


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

COMMENT ON COLUMN public.mrp_routing_workcenter.name IS 'Operation';


--
-- Name: COLUMN mrp_routing_workcenter.worksheet_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_routing_workcenter.worksheet_type IS 'Worksheet';


--
-- Name: COLUMN mrp_routing_workcenter.worksheet_google_slide; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_routing_workcenter.worksheet_google_slide IS 'Google Slide';


--
-- Name: COLUMN mrp_routing_workcenter.time_mode; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_routing_workcenter.time_mode IS 'Duration Computation';


--
-- Name: COLUMN mrp_routing_workcenter.note; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_routing_workcenter.note IS 'Description';


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

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


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

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


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

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


--
-- Name: COLUMN mrp_routing_workcenter.time_cycle_manual; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_routing_workcenter.time_cycle_manual IS 'Manual Duration';


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

CREATE TABLE public.mrp_routing_workcenter_dependencies_rel (
    operation_id integer NOT NULL,
    blocked_by_id integer NOT NULL
);


ALTER TABLE public.mrp_routing_workcenter_dependencies_rel OWNER TO odoo;

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

COMMENT ON TABLE public.mrp_routing_workcenter_dependencies_rel IS 'RELATION BETWEEN mrp_routing_workcenter AND mrp_routing_workcenter';


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

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


ALTER SEQUENCE public.mrp_routing_workcenter_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.mrp_routing_workcenter_id_seq OWNED BY public.mrp_routing_workcenter.id;


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

CREATE TABLE public.mrp_routing_workcenter_product_template_attribute_value_rel (
    mrp_routing_workcenter_id integer NOT NULL,
    product_template_attribute_value_id integer NOT NULL
);


ALTER TABLE public.mrp_routing_workcenter_product_template_attribute_value_rel OWNER TO odoo;

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

COMMENT ON TABLE public.mrp_routing_workcenter_product_template_attribute_value_rel IS 'RELATION BETWEEN mrp_routing_workcenter AND product_template_attribute_value';


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

CREATE TABLE public.mrp_unbuild (
    id integer NOT NULL,
    product_id integer NOT NULL,
    company_id integer NOT NULL,
    product_uom_id integer NOT NULL,
    bom_id integer,
    mo_id integer,
    lot_id integer,
    location_id integer NOT NULL,
    location_dest_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    name character varying,
    state character varying,
    product_qty numeric NOT NULL,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    CONSTRAINT mrp_unbuild_qty_positive CHECK ((product_qty > (0)::numeric))
);


ALTER TABLE public.mrp_unbuild OWNER TO odoo;

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

COMMENT ON TABLE public.mrp_unbuild IS 'Unbuild Order';


--
-- Name: COLUMN mrp_unbuild.product_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_unbuild.product_id IS 'Product';


--
-- Name: COLUMN mrp_unbuild.company_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_unbuild.company_id IS 'Company';


--
-- Name: COLUMN mrp_unbuild.product_uom_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_unbuild.product_uom_id IS 'Unit of Measure';


--
-- Name: COLUMN mrp_unbuild.bom_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_unbuild.bom_id IS 'Bill of Material';


--
-- Name: COLUMN mrp_unbuild.mo_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_unbuild.mo_id IS 'Manufacturing Order';


--
-- Name: COLUMN mrp_unbuild.lot_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_unbuild.lot_id IS 'Lot/Serial Number';


--
-- Name: COLUMN mrp_unbuild.location_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_unbuild.location_id IS 'Source Location';


--
-- Name: COLUMN mrp_unbuild.location_dest_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_unbuild.location_dest_id IS 'Destination Location';


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

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


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

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


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

COMMENT ON COLUMN public.mrp_unbuild.name IS 'Reference';


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

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


--
-- Name: COLUMN mrp_unbuild.product_qty; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_unbuild.product_qty IS 'Quantity';


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

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


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

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


--
-- Name: CONSTRAINT mrp_unbuild_qty_positive ON mrp_unbuild; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT mrp_unbuild_qty_positive ON public.mrp_unbuild IS 'check (product_qty > 0)';


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

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


ALTER SEQUENCE public.mrp_unbuild_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.mrp_unbuild_id_seq OWNED BY public.mrp_unbuild.id;


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

CREATE TABLE public.mrp_workcenter (
    id integer NOT NULL,
    resource_id integer NOT NULL,
    company_id integer,
    resource_calendar_id integer,
    sequence integer NOT NULL,
    color integer,
    create_uid integer,
    write_uid integer,
    name character varying,
    code character varying,
    working_state character varying,
    note text,
    active boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    time_efficiency double precision,
    default_capacity double precision,
    costs_hour double precision,
    time_start double precision,
    time_stop double precision,
    oee_target double precision,
    expense_account_id integer,
    analytic_distribution jsonb
);


ALTER TABLE public.mrp_workcenter OWNER TO odoo;

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

COMMENT ON TABLE public.mrp_workcenter IS 'Work Center';


--
-- Name: COLUMN mrp_workcenter.resource_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workcenter.resource_id IS 'Resource';


--
-- Name: COLUMN mrp_workcenter.company_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workcenter.company_id IS 'Company';


--
-- Name: COLUMN mrp_workcenter.resource_calendar_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workcenter.resource_calendar_id IS 'Working Hours';


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

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


--
-- Name: COLUMN mrp_workcenter.color; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workcenter.color IS 'Color';


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

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


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

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


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

COMMENT ON COLUMN public.mrp_workcenter.name IS 'Work Center';


--
-- Name: COLUMN mrp_workcenter.code; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workcenter.code IS 'Code';


--
-- Name: COLUMN mrp_workcenter.working_state; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workcenter.working_state IS 'Workcenter Status';


--
-- Name: COLUMN mrp_workcenter.note; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workcenter.note IS 'Description';


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

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


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

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


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

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


--
-- Name: COLUMN mrp_workcenter.time_efficiency; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workcenter.time_efficiency IS 'Time Efficiency';


--
-- Name: COLUMN mrp_workcenter.default_capacity; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workcenter.default_capacity IS 'Capacity';


--
-- Name: COLUMN mrp_workcenter.costs_hour; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workcenter.costs_hour IS 'Cost per hour';


--
-- Name: COLUMN mrp_workcenter.time_start; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workcenter.time_start IS 'Setup Time';


--
-- Name: COLUMN mrp_workcenter.time_stop; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workcenter.time_stop IS 'Cleanup Time';


--
-- Name: COLUMN mrp_workcenter.oee_target; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workcenter.oee_target IS 'OEE Target';


--
-- Name: COLUMN mrp_workcenter.expense_account_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workcenter.expense_account_id IS 'Expense Account';


--
-- Name: COLUMN mrp_workcenter.analytic_distribution; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workcenter.analytic_distribution IS 'Analytic Distribution';


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

CREATE TABLE public.mrp_workcenter_alternative_rel (
    workcenter_id integer NOT NULL,
    alternative_workcenter_id integer NOT NULL
);


ALTER TABLE public.mrp_workcenter_alternative_rel OWNER TO odoo;

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

COMMENT ON TABLE public.mrp_workcenter_alternative_rel IS 'RELATION BETWEEN mrp_workcenter AND mrp_workcenter';


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

CREATE TABLE public.mrp_workcenter_capacity (
    id integer NOT NULL,
    workcenter_id integer NOT NULL,
    product_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    capacity double precision,
    time_start double precision,
    time_stop double precision,
    CONSTRAINT mrp_workcenter_capacity_positive_capacity CHECK ((capacity > (0)::double precision))
);


ALTER TABLE public.mrp_workcenter_capacity OWNER TO odoo;

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

COMMENT ON TABLE public.mrp_workcenter_capacity IS 'Work Center Capacity';


--
-- Name: COLUMN mrp_workcenter_capacity.workcenter_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workcenter_capacity.workcenter_id IS 'Work Center';


--
-- Name: COLUMN mrp_workcenter_capacity.product_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workcenter_capacity.product_id IS 'Product';


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

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


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

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


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

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


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

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


--
-- Name: COLUMN mrp_workcenter_capacity.capacity; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workcenter_capacity.capacity IS 'Capacity';


--
-- Name: COLUMN mrp_workcenter_capacity.time_start; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workcenter_capacity.time_start IS 'Setup Time (minutes)';


--
-- Name: COLUMN mrp_workcenter_capacity.time_stop; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workcenter_capacity.time_stop IS 'Cleanup Time (minutes)';


--
-- Name: CONSTRAINT mrp_workcenter_capacity_positive_capacity ON mrp_workcenter_capacity; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT mrp_workcenter_capacity_positive_capacity ON public.mrp_workcenter_capacity IS 'CHECK(capacity > 0)';


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

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


ALTER SEQUENCE public.mrp_workcenter_capacity_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.mrp_workcenter_capacity_id_seq OWNED BY public.mrp_workcenter_capacity.id;


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

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


ALTER SEQUENCE public.mrp_workcenter_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.mrp_workcenter_id_seq OWNED BY public.mrp_workcenter.id;


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

CREATE TABLE public.mrp_workcenter_mrp_workcenter_tag_rel (
    mrp_workcenter_id integer NOT NULL,
    mrp_workcenter_tag_id integer NOT NULL
);


ALTER TABLE public.mrp_workcenter_mrp_workcenter_tag_rel OWNER TO odoo;

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

COMMENT ON TABLE public.mrp_workcenter_mrp_workcenter_tag_rel IS 'RELATION BETWEEN mrp_workcenter AND mrp_workcenter_tag';


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

CREATE TABLE public.mrp_workcenter_productivity (
    id integer NOT NULL,
    workcenter_id integer NOT NULL,
    company_id integer NOT NULL,
    workorder_id integer,
    user_id integer,
    loss_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    loss_type character varying,
    description text,
    date_start timestamp without time zone NOT NULL,
    date_end timestamp without time zone,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    duration double precision,
    account_move_line_id integer
);


ALTER TABLE public.mrp_workcenter_productivity OWNER TO odoo;

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

COMMENT ON TABLE public.mrp_workcenter_productivity IS 'Workcenter Productivity Log';


--
-- Name: COLUMN mrp_workcenter_productivity.workcenter_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workcenter_productivity.workcenter_id IS 'Work Center';


--
-- Name: COLUMN mrp_workcenter_productivity.company_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workcenter_productivity.company_id IS 'Company';


--
-- Name: COLUMN mrp_workcenter_productivity.workorder_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workcenter_productivity.workorder_id IS 'Work Order';


--
-- Name: COLUMN mrp_workcenter_productivity.user_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workcenter_productivity.user_id IS 'User';


--
-- Name: COLUMN mrp_workcenter_productivity.loss_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workcenter_productivity.loss_id IS 'Loss Reason';


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

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


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

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


--
-- Name: COLUMN mrp_workcenter_productivity.loss_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workcenter_productivity.loss_type IS 'Effectiveness';


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

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


--
-- Name: COLUMN mrp_workcenter_productivity.date_start; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workcenter_productivity.date_start IS 'Start Date';


--
-- Name: COLUMN mrp_workcenter_productivity.date_end; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workcenter_productivity.date_end IS 'End Date';


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

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


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

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


--
-- Name: COLUMN mrp_workcenter_productivity.duration; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workcenter_productivity.duration IS 'Duration';


--
-- Name: COLUMN mrp_workcenter_productivity.account_move_line_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workcenter_productivity.account_move_line_id IS 'Account Move Line';


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

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


ALTER SEQUENCE public.mrp_workcenter_productivity_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.mrp_workcenter_productivity_id_seq OWNED BY public.mrp_workcenter_productivity.id;


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

CREATE TABLE public.mrp_workcenter_productivity_loss (
    id integer NOT NULL,
    sequence integer,
    loss_id integer,
    create_uid integer,
    write_uid integer,
    loss_type character varying,
    name jsonb NOT NULL,
    manual boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.mrp_workcenter_productivity_loss OWNER TO odoo;

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

COMMENT ON TABLE public.mrp_workcenter_productivity_loss IS 'Workcenter Productivity Losses';


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

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


--
-- Name: COLUMN mrp_workcenter_productivity_loss.loss_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workcenter_productivity_loss.loss_id IS 'Category';


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

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


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

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


--
-- Name: COLUMN mrp_workcenter_productivity_loss.loss_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workcenter_productivity_loss.loss_type IS 'Effectiveness Category';


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

COMMENT ON COLUMN public.mrp_workcenter_productivity_loss.name IS 'Blocking Reason';


--
-- Name: COLUMN mrp_workcenter_productivity_loss.manual; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workcenter_productivity_loss.manual IS 'Is a Blocking Reason';


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

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


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

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


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

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


ALTER SEQUENCE public.mrp_workcenter_productivity_loss_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.mrp_workcenter_productivity_loss_id_seq OWNED BY public.mrp_workcenter_productivity_loss.id;


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

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


ALTER TABLE public.mrp_workcenter_productivity_loss_type OWNER TO odoo;

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

COMMENT ON TABLE public.mrp_workcenter_productivity_loss_type IS 'MRP Workorder productivity losses';


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

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


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

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


--
-- Name: COLUMN mrp_workcenter_productivity_loss_type.loss_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workcenter_productivity_loss_type.loss_type IS 'Category';


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

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


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

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


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

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


ALTER SEQUENCE public.mrp_workcenter_productivity_loss_type_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.mrp_workcenter_productivity_loss_type_id_seq OWNED BY public.mrp_workcenter_productivity_loss_type.id;


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

CREATE TABLE public.mrp_workcenter_tag (
    id integer NOT NULL,
    color integer,
    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.mrp_workcenter_tag OWNER TO odoo;

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

COMMENT ON TABLE public.mrp_workcenter_tag IS 'Add tag for the workcenter';


--
-- Name: COLUMN mrp_workcenter_tag.color; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workcenter_tag.color IS 'Color Index';


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

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


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

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


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

COMMENT ON COLUMN public.mrp_workcenter_tag.name IS 'Tag Name';


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

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


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

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


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

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


ALTER SEQUENCE public.mrp_workcenter_tag_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.mrp_workcenter_tag_id_seq OWNED BY public.mrp_workcenter_tag.id;


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

CREATE TABLE public.mrp_workorder (
    id integer NOT NULL,
    sequence integer,
    workcenter_id integer NOT NULL,
    product_id integer,
    product_uom_id integer NOT NULL,
    production_id integer NOT NULL,
    leave_id integer,
    duration_percent integer,
    operation_id integer,
    create_uid integer,
    write_uid integer,
    name character varying NOT NULL,
    barcode character varying,
    production_availability character varying,
    state character varying,
    qty_produced numeric,
    duration_expected numeric,
    qty_reported_from_previous_wo numeric,
    date_start timestamp without time zone,
    date_finished timestamp without time zone,
    production_date timestamp without time zone,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    duration double precision,
    duration_unit double precision,
    costs_hour double precision
);


ALTER TABLE public.mrp_workorder OWNER TO odoo;

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

COMMENT ON TABLE public.mrp_workorder IS 'Work Order';


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

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


--
-- Name: COLUMN mrp_workorder.workcenter_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workorder.workcenter_id IS 'Work Center';


--
-- Name: COLUMN mrp_workorder.product_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workorder.product_id IS 'Product';


--
-- Name: COLUMN mrp_workorder.product_uom_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workorder.product_uom_id IS 'Unit of Measure';


--
-- Name: COLUMN mrp_workorder.production_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workorder.production_id IS 'Manufacturing Order';


--
-- Name: COLUMN mrp_workorder.leave_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workorder.leave_id IS 'Leave';


--
-- Name: COLUMN mrp_workorder.duration_percent; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workorder.duration_percent IS 'Duration Deviation (%)';


--
-- Name: COLUMN mrp_workorder.operation_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workorder.operation_id IS 'Operation';


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

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


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

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


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

COMMENT ON COLUMN public.mrp_workorder.name IS 'Work Order';


--
-- Name: COLUMN mrp_workorder.barcode; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workorder.barcode IS 'Barcode';


--
-- Name: COLUMN mrp_workorder.production_availability; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workorder.production_availability IS 'Stock Availability';


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

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


--
-- Name: COLUMN mrp_workorder.qty_produced; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workorder.qty_produced IS 'Quantity';


--
-- Name: COLUMN mrp_workorder.duration_expected; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workorder.duration_expected IS 'Expected Duration';


--
-- Name: COLUMN mrp_workorder.qty_reported_from_previous_wo; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workorder.qty_reported_from_previous_wo IS 'Carried Quantity';


--
-- Name: COLUMN mrp_workorder.date_start; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workorder.date_start IS 'Start';


--
-- Name: COLUMN mrp_workorder.date_finished; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workorder.date_finished IS 'End';


--
-- Name: COLUMN mrp_workorder.production_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workorder.production_date IS 'Production Date';


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

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


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

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


--
-- Name: COLUMN mrp_workorder.duration; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workorder.duration IS 'Real Duration';


--
-- Name: COLUMN mrp_workorder.duration_unit; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workorder.duration_unit IS 'Duration Per Unit';


--
-- Name: COLUMN mrp_workorder.costs_hour; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.mrp_workorder.costs_hour IS 'Cost per hour';


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

CREATE TABLE public.mrp_workorder_dependencies_rel (
    workorder_id integer NOT NULL,
    blocked_by_id integer NOT NULL
);


ALTER TABLE public.mrp_workorder_dependencies_rel OWNER TO odoo;

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

COMMENT ON TABLE public.mrp_workorder_dependencies_rel IS 'RELATION BETWEEN mrp_workorder AND mrp_workorder';


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

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


ALTER SEQUENCE public.mrp_workorder_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.mrp_workorder_id_seq OWNED BY public.mrp_workorder.id;


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

CREATE TABLE public.mrp_workorder_mo_analytic_rel (
    mrp_workorder_id integer NOT NULL,
    account_analytic_line_id integer NOT NULL
);


ALTER TABLE public.mrp_workorder_mo_analytic_rel OWNER TO odoo;

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

COMMENT ON TABLE public.mrp_workorder_mo_analytic_rel IS 'RELATION BETWEEN mrp_workorder AND account_analytic_line';


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

CREATE TABLE public.mrp_workorder_wc_analytic_rel (
    mrp_workorder_id integer NOT NULL,
    account_analytic_line_id integer NOT NULL
);


ALTER TABLE public.mrp_workorder_wc_analytic_rel OWNER TO odoo;

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

COMMENT ON TABLE public.mrp_workorder_wc_analytic_rel IS 'RELATION BETWEEN mrp_workorder AND account_analytic_line';


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

CREATE TABLE public.onboarding_onboarding (
    id integer NOT NULL,
    sequence integer,
    create_uid integer,
    write_uid integer,
    route_name character varying NOT NULL,
    text_completed character varying,
    panel_close_action_name character varying,
    name jsonb,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.onboarding_onboarding OWNER TO odoo;

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

COMMENT ON TABLE public.onboarding_onboarding IS 'Onboarding';


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

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


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

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


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

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


--
-- Name: COLUMN onboarding_onboarding.route_name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.onboarding_onboarding.route_name IS 'One word name';


--
-- Name: COLUMN onboarding_onboarding.text_completed; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.onboarding_onboarding.text_completed IS 'Message at completion';


--
-- Name: COLUMN onboarding_onboarding.panel_close_action_name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.onboarding_onboarding.panel_close_action_name IS 'Closing action';


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

COMMENT ON COLUMN public.onboarding_onboarding.name IS 'Name of the onboarding';


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

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


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

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


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

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


ALTER SEQUENCE public.onboarding_onboarding_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.onboarding_onboarding_id_seq OWNED BY public.onboarding_onboarding.id;


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

CREATE TABLE public.onboarding_onboarding_onboarding_onboarding_step_rel (
    onboarding_onboarding_id integer NOT NULL,
    onboarding_onboarding_step_id integer NOT NULL
);


ALTER TABLE public.onboarding_onboarding_onboarding_onboarding_step_rel OWNER TO odoo;

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

COMMENT ON TABLE public.onboarding_onboarding_onboarding_onboarding_step_rel IS 'RELATION BETWEEN onboarding_onboarding AND onboarding_onboarding_step';


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

CREATE TABLE public.onboarding_onboarding_step (
    id integer NOT NULL,
    sequence integer,
    create_uid integer,
    write_uid integer,
    done_icon character varying,
    step_image_filename character varying,
    panel_step_open_action_name character varying,
    title jsonb,
    description jsonb,
    button_text jsonb NOT NULL,
    done_text jsonb,
    step_image_alt jsonb,
    is_per_company boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.onboarding_onboarding_step OWNER TO odoo;

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

COMMENT ON TABLE public.onboarding_onboarding_step IS 'Onboarding Step';


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

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


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

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


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

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


--
-- Name: COLUMN onboarding_onboarding_step.done_icon; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.onboarding_onboarding_step.done_icon IS 'Font Awesome Icon when completed';


--
-- Name: COLUMN onboarding_onboarding_step.step_image_filename; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.onboarding_onboarding_step.step_image_filename IS 'Step Image Filename';


--
-- Name: COLUMN onboarding_onboarding_step.panel_step_open_action_name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.onboarding_onboarding_step.panel_step_open_action_name IS 'Opening action';


--
-- Name: COLUMN onboarding_onboarding_step.title; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.onboarding_onboarding_step.title IS 'Title';


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

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


--
-- Name: COLUMN onboarding_onboarding_step.button_text; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.onboarding_onboarding_step.button_text IS 'Button text';


--
-- Name: COLUMN onboarding_onboarding_step.done_text; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.onboarding_onboarding_step.done_text IS 'Text to show when step is completed';


--
-- Name: COLUMN onboarding_onboarding_step.step_image_alt; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.onboarding_onboarding_step.step_image_alt IS 'Alt Text for the Step Image';


--
-- Name: COLUMN onboarding_onboarding_step.is_per_company; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.onboarding_onboarding_step.is_per_company IS 'Is per company';


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

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


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

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


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

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


ALTER SEQUENCE public.onboarding_onboarding_step_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.onboarding_onboarding_step_id_seq OWNED BY public.onboarding_onboarding_step.id;


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

CREATE TABLE public.onboarding_progress (
    id integer NOT NULL,
    company_id integer,
    onboarding_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    onboarding_state character varying,
    is_onboarding_closed boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.onboarding_progress OWNER TO odoo;

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

COMMENT ON TABLE public.onboarding_progress IS 'Onboarding Progress Tracker';


--
-- Name: COLUMN onboarding_progress.company_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.onboarding_progress.company_id IS 'Company';


--
-- Name: COLUMN onboarding_progress.onboarding_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.onboarding_progress.onboarding_id IS 'Related onboarding tracked';


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

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


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

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


--
-- Name: COLUMN onboarding_progress.onboarding_state; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.onboarding_progress.onboarding_state IS 'Onboarding progress';


--
-- Name: COLUMN onboarding_progress.is_onboarding_closed; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.onboarding_progress.is_onboarding_closed IS 'Was panel closed?';


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

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


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

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


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

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


ALTER SEQUENCE public.onboarding_progress_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.onboarding_progress_id_seq OWNED BY public.onboarding_progress.id;


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

CREATE TABLE public.onboarding_progress_onboarding_progress_step_rel (
    onboarding_progress_id integer NOT NULL,
    onboarding_progress_step_id integer NOT NULL
);


ALTER TABLE public.onboarding_progress_onboarding_progress_step_rel OWNER TO odoo;

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

COMMENT ON TABLE public.onboarding_progress_onboarding_progress_step_rel IS 'RELATION BETWEEN onboarding_progress AND onboarding_progress_step';


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

CREATE TABLE public.onboarding_progress_step (
    id integer NOT NULL,
    step_id integer NOT NULL,
    company_id integer,
    create_uid integer,
    write_uid integer,
    step_state character varying,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.onboarding_progress_step OWNER TO odoo;

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

COMMENT ON TABLE public.onboarding_progress_step IS 'Onboarding Progress Step Tracker';


--
-- Name: COLUMN onboarding_progress_step.step_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.onboarding_progress_step.step_id IS 'Onboarding Step';


--
-- Name: COLUMN onboarding_progress_step.company_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.onboarding_progress_step.company_id IS 'Company';


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

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


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

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


--
-- Name: COLUMN onboarding_progress_step.step_state; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.onboarding_progress_step.step_state IS 'Onboarding Step Progress';


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

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


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

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


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

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


ALTER SEQUENCE public.onboarding_progress_step_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.onboarding_progress_step_id_seq OWNED BY public.onboarding_progress_step.id;


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

CREATE TABLE public.payment_capture_wizard (
    id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    amount_to_capture numeric,
    void_remaining_amount boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.payment_capture_wizard OWNER TO odoo;

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

COMMENT ON TABLE public.payment_capture_wizard IS 'Payment Capture Wizard';


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

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


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

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


--
-- Name: COLUMN payment_capture_wizard.amount_to_capture; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_capture_wizard.amount_to_capture IS 'Amount To Capture';


--
-- Name: COLUMN payment_capture_wizard.void_remaining_amount; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_capture_wizard.void_remaining_amount IS 'Void Remaining Amount';


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

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


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

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


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

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


ALTER SEQUENCE public.payment_capture_wizard_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.payment_capture_wizard_id_seq OWNED BY public.payment_capture_wizard.id;


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

CREATE TABLE public.payment_capture_wizard_payment_transaction_rel (
    payment_capture_wizard_id integer NOT NULL,
    payment_transaction_id integer NOT NULL
);


ALTER TABLE public.payment_capture_wizard_payment_transaction_rel OWNER TO odoo;

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

COMMENT ON TABLE public.payment_capture_wizard_payment_transaction_rel IS 'RELATION BETWEEN payment_capture_wizard AND payment_transaction';


--
-- 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_currency_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.payment_currency_rel (
    payment_provider_id integer NOT NULL,
    currency_id integer NOT NULL
);


ALTER TABLE public.payment_currency_rel OWNER TO odoo;

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

COMMENT ON TABLE public.payment_currency_rel IS 'RELATION BETWEEN payment_provider AND res_currency';


--
-- 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,
    amount numeric NOT NULL,
    amount_max numeric,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    discount_date date,
    open_installments jsonb,
    has_eligible_epd boolean,
    amount_paid numeric
);


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.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: COLUMN payment_link_wizard.discount_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_link_wizard.discount_date IS 'Discount Date';


--
-- Name: COLUMN payment_link_wizard.open_installments; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_link_wizard.open_installments IS 'Open Installments';


--
-- Name: COLUMN payment_link_wizard.has_eligible_epd; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_link_wizard.has_eligible_epd IS 'Has Eligible Epd';


--
-- Name: COLUMN payment_link_wizard.amount_paid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_link_wizard.amount_paid IS 'Already Paid';


--
-- 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 SEQUENCE 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_method; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.payment_method (
    id integer NOT NULL,
    sequence integer,
    primary_payment_method_id integer,
    create_uid integer,
    write_uid integer,
    code character varying NOT NULL,
    support_refund character varying NOT NULL,
    name jsonb NOT NULL,
    active boolean,
    support_tokenization boolean,
    support_express_checkout boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.payment_method OWNER TO odoo;

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

COMMENT ON TABLE public.payment_method IS 'Payment Method';


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

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


--
-- Name: COLUMN payment_method.primary_payment_method_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_method.primary_payment_method_id IS 'Primary Payment Method';


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

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


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

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


--
-- Name: COLUMN payment_method.code; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_method.code IS 'Code';


--
-- Name: COLUMN payment_method.support_refund; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_method.support_refund IS 'Refund';


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

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


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

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


--
-- Name: COLUMN payment_method.support_tokenization; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_method.support_tokenization IS 'Tokenization';


--
-- Name: COLUMN payment_method.support_express_checkout; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_method.support_express_checkout IS 'Express Checkout';


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

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


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

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


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

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


ALTER SEQUENCE public.payment_method_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.payment_method_id_seq OWNED BY public.payment_method.id;


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

CREATE TABLE public.payment_method_payment_provider_rel (
    payment_method_id integer NOT NULL,
    payment_provider_id integer NOT NULL
);


ALTER TABLE public.payment_method_payment_provider_rel OWNER TO odoo;

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

COMMENT ON TABLE public.payment_method_payment_provider_rel IS 'RELATION BETWEEN payment_method AND payment_provider';


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

CREATE TABLE public.payment_method_res_country_rel (
    payment_method_id integer NOT NULL,
    res_country_id integer NOT NULL
);


ALTER TABLE public.payment_method_res_country_rel OWNER TO odoo;

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

COMMENT ON TABLE public.payment_method_res_country_rel IS 'RELATION BETWEEN payment_method AND res_country';


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

CREATE TABLE public.payment_method_res_currency_rel (
    payment_method_id integer NOT NULL,
    res_currency_id integer NOT NULL
);


ALTER TABLE public.payment_method_res_currency_rel OWNER TO odoo;

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

COMMENT ON TABLE public.payment_method_res_currency_rel IS 'RELATION BETWEEN payment_method AND res_currency';


--
-- 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,
    name jsonb NOT NULL,
    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,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    so_reference_type character varying
);


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.name; Type: COMMENT; Schema: public; Owner: odoo
--

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


--
-- 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 'Cancelled 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.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.so_reference_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_provider.so_reference_type IS 'Communication';


--
-- 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 SEQUENCE 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_email_account 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_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.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 SEQUENCE 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 SEQUENCE 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,
    company_id integer,
    payment_method_id integer NOT NULL,
    partner_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    payment_details character varying,
    provider_ref character varying NOT NULL,
    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.company_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_token.company_id IS 'Company';


--
-- Name: COLUMN payment_token.payment_method_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_token.payment_method_id IS 'Payment Method';


--
-- 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.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.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 SEQUENCE 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,
    payment_method_id integer NOT NULL,
    currency_id integer NOT NULL,
    token_id integer,
    source_transaction_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,
    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,
    is_post_processed boolean,
    tokenize boolean,
    last_state_change timestamp without time zone,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    payment_id integer
);


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.payment_method_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.payment_transaction.payment_method_id IS 'Payment Method';


--
-- 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.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.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.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.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: 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 SEQUENCE 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: peppol_registration; Type: TABLE; Schema: public; Owner: odoo
--

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


ALTER TABLE public.peppol_registration OWNER TO odoo;

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

COMMENT ON TABLE public.peppol_registration IS 'Peppol Registration';


--
-- Name: COLUMN peppol_registration.company_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.peppol_registration.company_id IS 'Company';


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

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


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

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


--
-- Name: COLUMN peppol_registration.smp_registration; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.peppol_registration.smp_registration IS 'Register as a receiver';


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

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


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

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


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

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


ALTER SEQUENCE public.peppol_registration_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.peppol_registration_id_seq OWNED BY public.peppol_registration.id;


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

CREATE TABLE public.phone_blacklist (
    id integer NOT NULL,
    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.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 SEQUENCE 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 SEQUENCE 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 SEQUENCE 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: picking_type_favorite_user_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.picking_type_favorite_user_rel (
    picking_type_id integer NOT NULL,
    user_id integer NOT NULL
);


ALTER TABLE public.picking_type_favorite_user_rel OWNER TO odoo;

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

COMMENT ON TABLE public.picking_type_favorite_user_rel IS 'RELATION BETWEEN stock_picking_type AND res_users';


--
-- 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 SEQUENCE 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 SEQUENCE 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 SEQUENCE 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 SEQUENCE 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 SEQUENCE 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 SEQUENCE 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,
    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 SEQUENCE 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,
    active boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    CONSTRAINT product_attribute_check_multi_checkbox_no_variant CHECK ((((display_type)::text <> 'multi'::text) OR ((create_variant)::text = 'no_variant'::text)))
);


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 'Variant Creation';


--
-- 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.active; Type: COMMENT; Schema: public; Owner: odoo
--

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


--
-- 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: CONSTRAINT product_attribute_check_multi_checkbox_no_variant ON product_attribute; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT product_attribute_check_multi_checkbox_no_variant ON public.product_attribute IS 'CHECK(display_type != ''multi'' OR create_variant = ''no_variant'')';


--
-- 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
);


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 SEQUENCE 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 SEQUENCE 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,
    active boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    default_extra_price double precision
);


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 'Free text';


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

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


--
-- 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: COLUMN product_attribute_value.default_extra_price; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_attribute_value.default_extra_price IS 'Default Extra Price';


--
-- 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 SEQUENCE 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,
    product_properties_definition jsonb,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    property_account_income_categ_id jsonb,
    property_account_expense_categ_id jsonb,
    property_account_downpayment_categ_id jsonb,
    removal_strategy_id integer,
    packaging_reserve_method character varying,
    property_valuation jsonb,
    property_cost_method jsonb,
    property_stock_journal jsonb,
    property_stock_account_input_categ_id jsonb,
    property_stock_account_output_categ_id jsonb,
    property_stock_valuation_account_id jsonb,
    property_stock_account_production_cost_id jsonb,
    property_account_creditor_price_difference_categ jsonb
);


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.product_properties_definition; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_category.product_properties_definition IS 'Product Properties';


--
-- 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.property_account_income_categ_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_category.property_account_income_categ_id IS 'Income Account';


--
-- Name: COLUMN product_category.property_account_expense_categ_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_category.property_account_expense_categ_id IS 'Expense Account';


--
-- Name: COLUMN product_category.property_account_downpayment_categ_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_category.property_account_downpayment_categ_id IS 'Downpayment Account';


--
-- 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: COLUMN product_category.property_valuation; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_category.property_valuation IS 'Inventory Valuation';


--
-- Name: COLUMN product_category.property_cost_method; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_category.property_cost_method IS 'Costing Method';


--
-- Name: COLUMN product_category.property_stock_journal; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_category.property_stock_journal IS 'Stock Journal';


--
-- Name: COLUMN product_category.property_stock_account_input_categ_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_category.property_stock_account_input_categ_id IS 'Stock Input Account';


--
-- Name: COLUMN product_category.property_stock_account_output_categ_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_category.property_stock_account_output_categ_id IS 'Stock Output Account';


--
-- Name: COLUMN product_category.property_stock_valuation_account_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_category.property_stock_valuation_account_id IS 'Stock Valuation Account';


--
-- Name: COLUMN product_category.property_stock_account_production_cost_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_category.property_stock_account_production_cost_id IS 'Production Account';


--
-- Name: COLUMN product_category.property_account_creditor_price_difference_categ; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_category.property_account_creditor_price_difference_categ IS 'Price Difference Account';


--
-- 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 SEQUENCE 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_combo; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.product_combo (
    id integer NOT NULL,
    sequence integer,
    company_id integer,
    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.product_combo OWNER TO odoo;

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

COMMENT ON TABLE public.product_combo IS 'Product Combo';


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

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


--
-- Name: COLUMN product_combo.company_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_combo.company_id IS 'Company';


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

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


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

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


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

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


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

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


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

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


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

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


ALTER SEQUENCE public.product_combo_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.product_combo_id_seq OWNED BY public.product_combo.id;


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

CREATE TABLE public.product_combo_item (
    id integer NOT NULL,
    company_id integer,
    combo_id integer NOT NULL,
    product_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    extra_price numeric,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.product_combo_item OWNER TO odoo;

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

COMMENT ON TABLE public.product_combo_item IS 'Product Combo Item';


--
-- Name: COLUMN product_combo_item.company_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_combo_item.company_id IS 'Company';


--
-- Name: COLUMN product_combo_item.combo_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_combo_item.combo_id IS 'Combo';


--
-- Name: COLUMN product_combo_item.product_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_combo_item.product_id IS 'Product';


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

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


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

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


--
-- Name: COLUMN product_combo_item.extra_price; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_combo_item.extra_price IS 'Extra Price';


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

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


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

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


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

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


ALTER SEQUENCE public.product_combo_item_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.product_combo_item_id_seq OWNED BY public.product_combo_item.id;


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

CREATE TABLE public.product_combo_product_template_rel (
    product_template_id integer NOT NULL,
    product_combo_id integer NOT NULL
);


ALTER TABLE public.product_combo_product_template_rel OWNER TO odoo;

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

COMMENT ON TABLE public.product_combo_product_template_rel IS 'RELATION BETWEEN product_template AND product_combo';


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

CREATE TABLE public.product_document (
    id integer NOT NULL,
    ir_attachment_id integer NOT NULL,
    sequence integer,
    create_uid integer,
    write_uid integer,
    active boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    attached_on_sale character varying NOT NULL,
    attached_on_mrp character varying NOT NULL
);


ALTER TABLE public.product_document OWNER TO odoo;

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

COMMENT ON TABLE public.product_document IS 'Product Document';


--
