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

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


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

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


ALTER TABLE public.res_users_log_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.res_users_log_id_seq OWNED BY public.res_users_log.id;


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

CREATE TABLE public.res_users_settings (
    id integer NOT NULL,
    user_id integer NOT NULL,
    voice_active_duration integer,
    create_uid integer,
    write_uid integer,
    push_to_talk_key character varying,
    is_discuss_sidebar_category_channel_open boolean,
    is_discuss_sidebar_category_chat_open boolean,
    use_push_to_talk boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    is_discuss_sidebar_category_livechat_open boolean
);


ALTER TABLE public.res_users_settings OWNER TO odoo;

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

COMMENT ON TABLE public.res_users_settings IS 'User Settings';


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

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


--
-- Name: COLUMN res_users_settings.voice_active_duration; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_users_settings.voice_active_duration IS 'Duration of voice activity in ms';


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

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


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

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


--
-- Name: COLUMN res_users_settings.push_to_talk_key; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_users_settings.push_to_talk_key IS 'Push-To-Talk shortcut';


--
-- Name: COLUMN res_users_settings.is_discuss_sidebar_category_channel_open; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_users_settings.is_discuss_sidebar_category_channel_open IS 'Is discuss sidebar category channel open?';


--
-- Name: COLUMN res_users_settings.is_discuss_sidebar_category_chat_open; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_users_settings.is_discuss_sidebar_category_chat_open IS 'Is discuss sidebar category chat open?';


--
-- Name: COLUMN res_users_settings.use_push_to_talk; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_users_settings.use_push_to_talk IS 'Use the push to talk feature';


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

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


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

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


--
-- Name: COLUMN res_users_settings.is_discuss_sidebar_category_livechat_open; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_users_settings.is_discuss_sidebar_category_livechat_open IS 'Is category livechat open';


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

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


ALTER TABLE public.res_users_settings_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.res_users_settings_id_seq OWNED BY public.res_users_settings.id;


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

CREATE TABLE public.res_users_settings_volumes (
    id integer NOT NULL,
    user_setting_id integer NOT NULL,
    partner_id integer,
    guest_id integer,
    create_uid integer,
    write_uid integer,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    volume double precision,
    CONSTRAINT res_users_settings_volumes_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.res_users_settings_volumes OWNER TO odoo;

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

COMMENT ON TABLE public.res_users_settings_volumes IS 'User Settings Volumes';


--
-- Name: COLUMN res_users_settings_volumes.user_setting_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_users_settings_volumes.user_setting_id IS 'User Setting';


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

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


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

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


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

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


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

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


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

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


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

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


--
-- Name: COLUMN res_users_settings_volumes.volume; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_users_settings_volumes.volume IS 'Volume';


--
-- Name: CONSTRAINT res_users_settings_volumes_partner_or_guest_exists ON res_users_settings_volumes; Type: COMMENT; Schema: public; Owner: odoo
--

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


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

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


ALTER TABLE public.res_users_settings_volumes_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.res_users_settings_volumes_id_seq OWNED BY public.res_users_settings_volumes.id;


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

CREATE TABLE public.reset_view_arch_wizard (
    id integer NOT NULL,
    view_id integer,
    compare_view_id integer,
    create_uid integer,
    write_uid integer,
    reset_mode character varying NOT NULL,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.reset_view_arch_wizard OWNER TO odoo;

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

COMMENT ON TABLE public.reset_view_arch_wizard IS 'Reset View Architecture Wizard';


--
-- Name: COLUMN reset_view_arch_wizard.view_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.reset_view_arch_wizard.view_id IS 'View';


--
-- Name: COLUMN reset_view_arch_wizard.compare_view_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.reset_view_arch_wizard.compare_view_id IS 'Compare To View';


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

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


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

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


--
-- Name: COLUMN reset_view_arch_wizard.reset_mode; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.reset_view_arch_wizard.reset_mode IS 'Reset Mode';


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

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


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

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


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

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


ALTER TABLE public.reset_view_arch_wizard_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.reset_view_arch_wizard_id_seq OWNED BY public.reset_view_arch_wizard.id;


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

CREATE TABLE public.resource_calendar (
    id integer NOT NULL,
    company_id integer,
    create_uid integer,
    write_uid integer,
    name character varying NOT NULL,
    tz character varying NOT NULL,
    active boolean,
    two_weeks_calendar boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    hours_per_day double precision
);


ALTER TABLE public.resource_calendar OWNER TO odoo;

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

COMMENT ON TABLE public.resource_calendar IS 'Resource Working Time';


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

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


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

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


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

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


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

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


--
-- Name: COLUMN resource_calendar.tz; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.resource_calendar.tz IS 'Timezone';


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

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


--
-- Name: COLUMN resource_calendar.two_weeks_calendar; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.resource_calendar.two_weeks_calendar IS 'Calendar in 2 weeks mode';


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

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


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

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


--
-- Name: COLUMN resource_calendar.hours_per_day; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.resource_calendar.hours_per_day IS 'Average Hour per Day';


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

CREATE TABLE public.resource_calendar_attendance (
    id integer NOT NULL,
    calendar_id integer NOT NULL,
    resource_id integer,
    sequence integer,
    create_uid integer,
    write_uid integer,
    name character varying NOT NULL,
    dayofweek character varying NOT NULL,
    day_period character varying NOT NULL,
    week_type character varying,
    display_type character varying,
    date_from date,
    date_to date,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    hour_from double precision NOT NULL,
    hour_to double precision NOT NULL
);


ALTER TABLE public.resource_calendar_attendance OWNER TO odoo;

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

COMMENT ON TABLE public.resource_calendar_attendance IS 'Work Detail';


--
-- Name: COLUMN resource_calendar_attendance.calendar_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.resource_calendar_attendance.calendar_id IS 'Resource''s Calendar';


--
-- Name: COLUMN resource_calendar_attendance.resource_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.resource_calendar_attendance.resource_id IS 'Resource';


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

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


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

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


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

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


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

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


--
-- Name: COLUMN resource_calendar_attendance.dayofweek; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.resource_calendar_attendance.dayofweek IS 'Day of Week';


--
-- Name: COLUMN resource_calendar_attendance.day_period; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.resource_calendar_attendance.day_period IS 'Day Period';


--
-- Name: COLUMN resource_calendar_attendance.week_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.resource_calendar_attendance.week_type IS 'Week Number';


--
-- Name: COLUMN resource_calendar_attendance.display_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.resource_calendar_attendance.display_type IS 'Display Type';


--
-- Name: COLUMN resource_calendar_attendance.date_from; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.resource_calendar_attendance.date_from IS 'Starting Date';


--
-- Name: COLUMN resource_calendar_attendance.date_to; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.resource_calendar_attendance.date_to IS 'End Date';


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

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


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

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


--
-- Name: COLUMN resource_calendar_attendance.hour_from; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.resource_calendar_attendance.hour_from IS 'Work from';


--
-- Name: COLUMN resource_calendar_attendance.hour_to; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.resource_calendar_attendance.hour_to IS 'Work to';


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

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


ALTER TABLE public.resource_calendar_attendance_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.resource_calendar_attendance_id_seq OWNED BY public.resource_calendar_attendance.id;


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

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


ALTER TABLE public.resource_calendar_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.resource_calendar_id_seq OWNED BY public.resource_calendar.id;


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

CREATE TABLE public.resource_calendar_leaves (
    id integer NOT NULL,
    company_id integer,
    calendar_id integer,
    resource_id integer,
    create_uid integer,
    write_uid integer,
    name character varying,
    time_type character varying,
    date_from timestamp without time zone NOT NULL,
    date_to timestamp without time zone NOT NULL,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.resource_calendar_leaves OWNER TO odoo;

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

COMMENT ON TABLE public.resource_calendar_leaves IS 'Resource Time Off Detail';


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

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


--
-- Name: COLUMN resource_calendar_leaves.calendar_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.resource_calendar_leaves.calendar_id IS 'Working Hours';


--
-- Name: COLUMN resource_calendar_leaves.resource_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.resource_calendar_leaves.resource_id IS 'Resource';


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

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


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

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


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

COMMENT ON COLUMN public.resource_calendar_leaves.name IS 'Reason';


--
-- Name: COLUMN resource_calendar_leaves.time_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.resource_calendar_leaves.time_type IS 'Time Type';


--
-- Name: COLUMN resource_calendar_leaves.date_from; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.resource_calendar_leaves.date_from IS 'Start Date';


--
-- Name: COLUMN resource_calendar_leaves.date_to; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.resource_calendar_leaves.date_to IS 'End Date';


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

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


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

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


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

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


ALTER TABLE public.resource_calendar_leaves_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.resource_calendar_leaves_id_seq OWNED BY public.resource_calendar_leaves.id;


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

CREATE TABLE public.resource_resource (
    id integer NOT NULL,
    company_id integer,
    user_id integer,
    calendar_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    name character varying NOT NULL,
    resource_type character varying NOT NULL,
    tz character varying NOT NULL,
    active boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    time_efficiency double precision NOT NULL,
    CONSTRAINT resource_resource_check_time_efficiency CHECK ((time_efficiency > (0)::double precision))
);


ALTER TABLE public.resource_resource OWNER TO odoo;

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

COMMENT ON TABLE public.resource_resource IS 'Resources';


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

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


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

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


--
-- Name: COLUMN resource_resource.calendar_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.resource_resource.calendar_id IS 'Working Time';


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

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


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

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


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

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


--
-- Name: COLUMN resource_resource.resource_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.resource_resource.resource_type IS 'Type';


--
-- Name: COLUMN resource_resource.tz; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.resource_resource.tz IS 'Timezone';


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

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


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

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


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

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


--
-- Name: COLUMN resource_resource.time_efficiency; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.resource_resource.time_efficiency IS 'Efficiency Factor';


--
-- Name: CONSTRAINT resource_resource_check_time_efficiency ON resource_resource; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT resource_resource_check_time_efficiency ON public.resource_resource IS 'CHECK(time_efficiency>0)';


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

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


ALTER TABLE public.resource_resource_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.resource_resource_id_seq OWNED BY public.resource_resource.id;


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

CREATE TABLE public.rule_group_rel (
    rule_group_id integer NOT NULL,
    group_id integer NOT NULL
);


ALTER TABLE public.rule_group_rel OWNER TO odoo;

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

COMMENT ON TABLE public.rule_group_rel IS 'RELATION BETWEEN ir_rule AND res_groups';


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

CREATE TABLE public.sale_advance_payment_inv (
    id integer NOT NULL,
    product_id integer,
    currency_id integer,
    company_id integer,
    deposit_account_id integer,
    create_uid integer,
    write_uid integer,
    advance_payment_method character varying NOT NULL,
    fixed_amount numeric,
    deduct_down_payments boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    amount double precision
);


ALTER TABLE public.sale_advance_payment_inv OWNER TO odoo;

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

COMMENT ON TABLE public.sale_advance_payment_inv IS 'Sales Advance Payment Invoice';


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

COMMENT ON COLUMN public.sale_advance_payment_inv.product_id IS 'Down Payment Product';


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

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


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

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


--
-- Name: COLUMN sale_advance_payment_inv.deposit_account_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_advance_payment_inv.deposit_account_id IS 'Income Account';


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

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


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

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


--
-- Name: COLUMN sale_advance_payment_inv.advance_payment_method; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_advance_payment_inv.advance_payment_method IS 'Create Invoice';


--
-- Name: COLUMN sale_advance_payment_inv.fixed_amount; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_advance_payment_inv.fixed_amount IS 'Down Payment Amount (Fixed)';


--
-- Name: COLUMN sale_advance_payment_inv.deduct_down_payments; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_advance_payment_inv.deduct_down_payments IS 'Deduct down payments';


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

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


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

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


--
-- Name: COLUMN sale_advance_payment_inv.amount; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_advance_payment_inv.amount IS 'Down Payment Amount';


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

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


ALTER TABLE public.sale_advance_payment_inv_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.sale_advance_payment_inv_id_seq OWNED BY public.sale_advance_payment_inv.id;


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

CREATE TABLE public.sale_advance_payment_inv_sale_order_rel (
    sale_advance_payment_inv_id integer NOT NULL,
    sale_order_id integer NOT NULL
);


ALTER TABLE public.sale_advance_payment_inv_sale_order_rel OWNER TO odoo;

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

COMMENT ON TABLE public.sale_advance_payment_inv_sale_order_rel IS 'RELATION BETWEEN sale_advance_payment_inv AND sale_order';


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

CREATE TABLE public.sale_order (
    id integer NOT NULL,
    campaign_id integer,
    source_id integer,
    medium_id integer,
    message_main_attachment_id integer,
    company_id integer NOT NULL,
    partner_id integer NOT NULL,
    partner_invoice_id integer NOT NULL,
    partner_shipping_id integer NOT NULL,
    fiscal_position_id integer,
    payment_term_id integer,
    pricelist_id integer NOT NULL,
    currency_id integer,
    user_id integer,
    team_id integer,
    analytic_account_id integer,
    create_uid integer,
    write_uid integer,
    access_token character varying,
    name character varying NOT NULL,
    state character varying,
    client_order_ref character varying,
    origin character varying,
    reference character varying,
    signed_by character varying,
    invoice_status character varying,
    validity_date date,
    note text,
    currency_rate numeric,
    amount_untaxed numeric,
    amount_tax numeric,
    amount_total numeric,
    require_signature boolean,
    require_payment boolean,
    create_date timestamp without time zone,
    commitment_date timestamp without time zone,
    date_order timestamp without time zone NOT NULL,
    signed_on timestamp without time zone,
    write_date timestamp without time zone,
    sale_order_template_id integer,
    project_id integer,
    opportunity_id integer,
    incoterm integer,
    warehouse_id integer NOT NULL,
    procurement_group_id integer,
    incoterm_location character varying,
    picking_policy character varying NOT NULL,
    delivery_status character varying,
    effective_date timestamp without time zone,
    CONSTRAINT sale_order_date_order_conditional_required CHECK (((((state)::text = ANY ((ARRAY['sale'::character varying, 'done'::character varying])::text[])) AND (date_order IS NOT NULL)) OR ((state)::text <> ALL ((ARRAY['sale'::character varying, 'done'::character varying])::text[]))))
);


ALTER TABLE public.sale_order OWNER TO odoo;

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

COMMENT ON TABLE public.sale_order IS 'Sales Order';


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

COMMENT ON COLUMN public.sale_order.campaign_id IS 'Campaign';


--
-- Name: COLUMN sale_order.source_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order.source_id IS 'Source';


--
-- Name: COLUMN sale_order.medium_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order.medium_id IS 'Medium';


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

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


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

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


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

COMMENT ON COLUMN public.sale_order.partner_id IS 'Customer';


--
-- Name: COLUMN sale_order.partner_invoice_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order.partner_invoice_id IS 'Invoice Address';


--
-- Name: COLUMN sale_order.partner_shipping_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order.partner_shipping_id IS 'Delivery Address';


--
-- Name: COLUMN sale_order.fiscal_position_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order.fiscal_position_id IS 'Fiscal Position';


--
-- Name: COLUMN sale_order.payment_term_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order.payment_term_id IS 'Payment Terms';


--
-- Name: COLUMN sale_order.pricelist_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order.pricelist_id IS 'Pricelist';


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

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


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

COMMENT ON COLUMN public.sale_order.user_id IS 'Salesperson';


--
-- Name: COLUMN sale_order.team_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order.team_id IS 'Sales Team';


--
-- Name: COLUMN sale_order.analytic_account_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order.analytic_account_id IS 'Analytic Account';


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

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


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

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


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

COMMENT ON COLUMN public.sale_order.access_token IS 'Security Token';


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

COMMENT ON COLUMN public.sale_order.name IS 'Order Reference';


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

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


--
-- Name: COLUMN sale_order.client_order_ref; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order.client_order_ref IS 'Customer Reference';


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

COMMENT ON COLUMN public.sale_order.origin IS 'Source Document';


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

COMMENT ON COLUMN public.sale_order.reference IS 'Payment Ref.';


--
-- Name: COLUMN sale_order.signed_by; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order.signed_by IS 'Signed By';


--
-- Name: COLUMN sale_order.invoice_status; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order.invoice_status IS 'Invoice Status';


--
-- Name: COLUMN sale_order.validity_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order.validity_date IS 'Expiration';


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

COMMENT ON COLUMN public.sale_order.note IS 'Terms and conditions';


--
-- Name: COLUMN sale_order.currency_rate; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order.currency_rate IS 'Currency Rate';


--
-- Name: COLUMN sale_order.amount_untaxed; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order.amount_untaxed IS 'Untaxed Amount';


--
-- Name: COLUMN sale_order.amount_tax; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order.amount_tax IS 'Taxes';


--
-- Name: COLUMN sale_order.amount_total; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order.amount_total IS 'Total';


--
-- Name: COLUMN sale_order.require_signature; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order.require_signature IS 'Online Signature';


--
-- Name: COLUMN sale_order.require_payment; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order.require_payment IS 'Online Payment';


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

COMMENT ON COLUMN public.sale_order.create_date IS 'Creation Date';


--
-- Name: COLUMN sale_order.commitment_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order.commitment_date IS 'Delivery Date';


--
-- Name: COLUMN sale_order.date_order; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order.date_order IS 'Order Date';


--
-- Name: COLUMN sale_order.signed_on; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order.signed_on IS 'Signed On';


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

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


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

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


--
-- Name: COLUMN sale_order.opportunity_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order.opportunity_id IS 'Opportunity';


--
-- Name: COLUMN sale_order.incoterm; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order.incoterm IS 'Incoterm';


--
-- Name: COLUMN sale_order.warehouse_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order.warehouse_id IS 'Warehouse';


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

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


--
-- Name: COLUMN sale_order.incoterm_location; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order.incoterm_location IS 'Incoterm Location';


--
-- Name: COLUMN sale_order.picking_policy; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order.picking_policy IS 'Shipping Policy';


--
-- Name: COLUMN sale_order.delivery_status; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order.delivery_status IS 'Delivery Status';


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

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


--
-- Name: CONSTRAINT sale_order_date_order_conditional_required ON sale_order; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT sale_order_date_order_conditional_required ON public.sale_order IS 'CHECK((state IN (''sale'', ''done'') AND date_order IS NOT NULL) OR state NOT IN (''sale'', ''done''))';


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

CREATE TABLE public.sale_order_cancel (
    id integer NOT NULL,
    template_id integer,
    author_id integer,
    order_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    lang character varying,
    subject character varying,
    email_from character varying,
    body text,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.sale_order_cancel OWNER TO odoo;

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

COMMENT ON TABLE public.sale_order_cancel IS 'Sales Order Cancel';


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

COMMENT ON COLUMN public.sale_order_cancel.template_id IS 'Mail Template';


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

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


--
-- Name: COLUMN sale_order_cancel.order_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_cancel.order_id IS 'Sale Order';


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


ALTER TABLE public.sale_order_cancel_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.sale_order_cancel_id_seq OWNED BY public.sale_order_cancel.id;


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

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


ALTER TABLE public.sale_order_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.sale_order_id_seq OWNED BY public.sale_order.id;


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

CREATE TABLE public.sale_order_line (
    id integer NOT NULL,
    order_id integer NOT NULL,
    sequence integer,
    company_id integer,
    currency_id integer,
    order_partner_id integer,
    salesman_id integer,
    product_id integer,
    product_uom integer,
    product_packaging_id integer,
    create_uid integer,
    write_uid integer,
    state character varying,
    display_type character varying,
    qty_delivered_method character varying,
    invoice_status character varying,
    analytic_distribution jsonb,
    name text NOT NULL,
    product_uom_qty numeric NOT NULL,
    price_unit numeric NOT NULL,
    discount numeric,
    price_reduce numeric,
    price_subtotal numeric,
    price_total numeric,
    price_reduce_taxexcl numeric,
    price_reduce_taxinc numeric,
    qty_delivered numeric,
    qty_invoiced numeric,
    qty_to_invoice numeric,
    untaxed_amount_invoiced numeric,
    untaxed_amount_to_invoice numeric,
    is_downpayment boolean,
    is_expense boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    price_tax double precision,
    product_packaging_qty double precision,
    customer_lead double precision NOT NULL,
    is_service boolean,
    project_id integer,
    task_id integer,
    route_id integer,
    CONSTRAINT sale_order_line_accountable_required_fields CHECK (((display_type IS NOT NULL) OR ((product_id IS NOT NULL) AND (product_uom IS NOT NULL)))),
    CONSTRAINT sale_order_line_non_accountable_null_fields CHECK (((display_type IS NULL) OR ((product_id IS NULL) AND (price_unit = (0)::numeric) AND (product_uom_qty = (0)::numeric) AND (product_uom IS NULL) AND (customer_lead = (0)::double precision))))
);


ALTER TABLE public.sale_order_line OWNER TO odoo;

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

COMMENT ON TABLE public.sale_order_line IS 'Sales Order Line';


--
-- Name: COLUMN sale_order_line.order_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.order_id IS 'Order Reference';


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

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


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

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


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

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


--
-- Name: COLUMN sale_order_line.order_partner_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.order_partner_id IS 'Customer';


--
-- Name: COLUMN sale_order_line.salesman_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.salesman_id IS 'Salesperson';


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

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


--
-- Name: COLUMN sale_order_line.product_uom; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.product_uom IS 'Unit of Measure';


--
-- Name: COLUMN sale_order_line.product_packaging_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.product_packaging_id IS 'Packaging';


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

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


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

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


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

COMMENT ON COLUMN public.sale_order_line.state IS 'Order Status';


--
-- Name: COLUMN sale_order_line.display_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.display_type IS 'Display Type';


--
-- Name: COLUMN sale_order_line.qty_delivered_method; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.qty_delivered_method IS 'Method to update delivered qty';


--
-- Name: COLUMN sale_order_line.invoice_status; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.invoice_status IS 'Invoice Status';


--
-- Name: COLUMN sale_order_line.analytic_distribution; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.analytic_distribution IS 'Analytic';


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

COMMENT ON COLUMN public.sale_order_line.name IS 'Description';


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

COMMENT ON COLUMN public.sale_order_line.product_uom_qty IS 'Quantity';


--
-- Name: COLUMN sale_order_line.price_unit; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.price_unit IS 'Unit Price';


--
-- Name: COLUMN sale_order_line.discount; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.discount IS 'Discount (%)';


--
-- Name: COLUMN sale_order_line.price_reduce; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.price_reduce IS 'Price Reduce';


--
-- Name: COLUMN sale_order_line.price_subtotal; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.price_subtotal IS 'Subtotal';


--
-- Name: COLUMN sale_order_line.price_total; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.price_total IS 'Total';


--
-- Name: COLUMN sale_order_line.price_reduce_taxexcl; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.price_reduce_taxexcl IS 'Price Reduce Tax excl';


--
-- Name: COLUMN sale_order_line.price_reduce_taxinc; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.price_reduce_taxinc IS 'Price Reduce Tax incl';


--
-- Name: COLUMN sale_order_line.qty_delivered; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.qty_delivered IS 'Delivery Quantity';


--
-- Name: COLUMN sale_order_line.qty_invoiced; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.qty_invoiced IS 'Invoiced Quantity';


--
-- Name: COLUMN sale_order_line.qty_to_invoice; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.qty_to_invoice IS 'Quantity To Invoice';


--
-- Name: COLUMN sale_order_line.untaxed_amount_invoiced; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.untaxed_amount_invoiced IS 'Untaxed Invoiced Amount';


--
-- Name: COLUMN sale_order_line.untaxed_amount_to_invoice; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.untaxed_amount_to_invoice IS 'Untaxed Amount To Invoice';


--
-- Name: COLUMN sale_order_line.is_downpayment; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.is_downpayment IS 'Is a down payment';


--
-- Name: COLUMN sale_order_line.is_expense; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.is_expense IS 'Is expense';


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

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


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

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


--
-- Name: COLUMN sale_order_line.price_tax; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.price_tax IS 'Total Tax';


--
-- Name: COLUMN sale_order_line.product_packaging_qty; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.product_packaging_qty IS 'Packaging Quantity';


--
-- Name: COLUMN sale_order_line.customer_lead; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.customer_lead IS 'Lead Time';


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

COMMENT ON COLUMN public.sale_order_line.project_id IS 'Generated Project';


--
-- Name: COLUMN sale_order_line.task_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.task_id IS 'Generated Task';


--
-- Name: COLUMN sale_order_line.route_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.route_id IS 'Route';


--
-- Name: CONSTRAINT sale_order_line_accountable_required_fields ON sale_order_line; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT sale_order_line_accountable_required_fields ON public.sale_order_line IS 'CHECK(display_type IS NOT NULL OR (product_id IS NOT NULL AND product_uom IS NOT NULL))';


--
-- Name: CONSTRAINT sale_order_line_non_accountable_null_fields ON sale_order_line; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT sale_order_line_non_accountable_null_fields ON public.sale_order_line IS 'CHECK(display_type IS NULL OR (product_id IS NULL AND price_unit = 0 AND product_uom_qty = 0 AND product_uom IS NULL AND customer_lead = 0))';


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

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


ALTER TABLE public.sale_order_line_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.sale_order_line_id_seq OWNED BY public.sale_order_line.id;


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

CREATE TABLE public.sale_order_line_invoice_rel (
    invoice_line_id integer NOT NULL,
    order_line_id integer NOT NULL
);


ALTER TABLE public.sale_order_line_invoice_rel OWNER TO odoo;

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

COMMENT ON TABLE public.sale_order_line_invoice_rel IS 'RELATION BETWEEN account_move_line AND sale_order_line';


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

CREATE TABLE public.sale_order_option (
    id integer NOT NULL,
    order_id integer,
    product_id integer NOT NULL,
    line_id integer,
    sequence integer,
    uom_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    name text NOT NULL,
    quantity numeric NOT NULL,
    price_unit numeric NOT NULL,
    discount numeric,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.sale_order_option OWNER TO odoo;

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

COMMENT ON TABLE public.sale_order_option IS 'Sale Options';


--
-- Name: COLUMN sale_order_option.order_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_option.order_id IS 'Sales Order Reference';


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

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


--
-- Name: COLUMN sale_order_option.line_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_option.line_id IS 'Line';


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

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


--
-- Name: COLUMN sale_order_option.uom_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_option.uom_id IS 'Unit of Measure';


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

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


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

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


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

COMMENT ON COLUMN public.sale_order_option.name IS 'Description';


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

COMMENT ON COLUMN public.sale_order_option.quantity IS 'Quantity';


--
-- Name: COLUMN sale_order_option.price_unit; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_option.price_unit IS 'Unit Price';


--
-- Name: COLUMN sale_order_option.discount; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_option.discount IS 'Discount (%)';


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

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


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

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


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

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


ALTER TABLE public.sale_order_option_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.sale_order_option_id_seq OWNED BY public.sale_order_option.id;


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

CREATE TABLE public.sale_order_tag_rel (
    order_id integer NOT NULL,
    tag_id integer NOT NULL
);


ALTER TABLE public.sale_order_tag_rel OWNER TO odoo;

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

COMMENT ON TABLE public.sale_order_tag_rel IS 'RELATION BETWEEN sale_order AND crm_tag';


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

CREATE TABLE public.sale_order_template (
    id integer NOT NULL,
    company_id integer,
    mail_template_id integer,
    number_of_days integer,
    create_uid integer,
    write_uid integer,
    name character varying NOT NULL,
    note jsonb,
    active boolean,
    require_signature boolean,
    require_payment boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.sale_order_template OWNER TO odoo;

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

COMMENT ON TABLE public.sale_order_template IS 'Quotation Template';


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

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


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

COMMENT ON COLUMN public.sale_order_template.mail_template_id IS 'Confirmation Mail';


--
-- Name: COLUMN sale_order_template.number_of_days; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_template.number_of_days IS 'Quotation Duration';


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

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


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

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


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

COMMENT ON COLUMN public.sale_order_template.name IS 'Quotation Template';


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

COMMENT ON COLUMN public.sale_order_template.note IS 'Terms and conditions';


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

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


--
-- Name: COLUMN sale_order_template.require_signature; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_template.require_signature IS 'Online Signature';


--
-- Name: COLUMN sale_order_template.require_payment; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_template.require_payment IS 'Online Payment';


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

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


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

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


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

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


ALTER TABLE public.sale_order_template_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.sale_order_template_id_seq OWNED BY public.sale_order_template.id;


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

CREATE TABLE public.sale_order_template_line (
    id integer NOT NULL,
    sale_order_template_id integer NOT NULL,
    sequence integer,
    company_id integer,
    product_id integer,
    product_uom_id integer,
    create_uid integer,
    write_uid integer,
    display_type character varying,
    name jsonb NOT NULL,
    product_uom_qty numeric NOT NULL,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    CONSTRAINT sale_order_template_line_accountable_product_id_required CHECK (((display_type IS NOT NULL) OR ((product_id IS NOT NULL) AND (product_uom_id IS NOT NULL)))),
    CONSTRAINT sale_order_template_line_non_accountable_fields_null CHECK (((display_type IS NULL) OR ((product_id IS NULL) AND (product_uom_qty = (0)::numeric) AND (product_uom_id IS NULL))))
);


ALTER TABLE public.sale_order_template_line OWNER TO odoo;

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

COMMENT ON TABLE public.sale_order_template_line IS 'Quotation Template Line';


--
-- Name: COLUMN sale_order_template_line.sale_order_template_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_template_line.sale_order_template_id IS 'Quotation Template Reference';


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

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


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

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


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

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


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

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


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

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


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

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


--
-- Name: COLUMN sale_order_template_line.display_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_template_line.display_type IS 'Display Type';


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

COMMENT ON COLUMN public.sale_order_template_line.name IS 'Description';


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

COMMENT ON COLUMN public.sale_order_template_line.product_uom_qty IS 'Quantity';


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

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


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

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


--
-- Name: CONSTRAINT sale_order_template_line_accountable_product_id_required ON sale_order_template_line; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT sale_order_template_line_accountable_product_id_required ON public.sale_order_template_line IS 'CHECK(display_type IS NOT NULL OR (product_id IS NOT NULL AND product_uom_id IS NOT NULL))';


--
-- Name: CONSTRAINT sale_order_template_line_non_accountable_fields_null ON sale_order_template_line; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT sale_order_template_line_non_accountable_fields_null ON public.sale_order_template_line IS 'CHECK(display_type IS NULL OR (product_id IS NULL AND product_uom_qty = 0 AND product_uom_id IS NULL))';


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

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


ALTER TABLE public.sale_order_template_line_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.sale_order_template_line_id_seq OWNED BY public.sale_order_template_line.id;


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

CREATE TABLE public.sale_order_template_option (
    id integer NOT NULL,
    sale_order_template_id integer NOT NULL,
    company_id integer,
    product_id integer NOT NULL,
    uom_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    name jsonb NOT NULL,
    quantity numeric NOT NULL,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.sale_order_template_option OWNER TO odoo;

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

COMMENT ON TABLE public.sale_order_template_option IS 'Quotation Template Option';


--
-- Name: COLUMN sale_order_template_option.sale_order_template_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_template_option.sale_order_template_id IS 'Quotation Template Reference';


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

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


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

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


--
-- Name: COLUMN sale_order_template_option.uom_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_template_option.uom_id IS 'Unit of Measure';


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

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


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

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


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

COMMENT ON COLUMN public.sale_order_template_option.name IS 'Description';


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

COMMENT ON COLUMN public.sale_order_template_option.quantity IS 'Quantity';


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

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


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

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


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

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


ALTER TABLE public.sale_order_template_option_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.sale_order_template_option_id_seq OWNED BY public.sale_order_template_option.id;


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

CREATE TABLE public.sale_order_transaction_rel (
    transaction_id integer NOT NULL,
    sale_order_id integer NOT NULL
);


ALTER TABLE public.sale_order_transaction_rel OWNER TO odoo;

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

COMMENT ON TABLE public.sale_order_transaction_rel IS 'RELATION BETWEEN payment_transaction AND sale_order';


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

CREATE TABLE public.sale_payment_provider_onboarding_wizard (
    id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    payment_method character varying,
    paypal_user_type character varying,
    paypal_email_account character varying,
    paypal_seller_account character varying,
    paypal_pdt_token character varying,
    manual_name character varying,
    journal_name character varying,
    acc_number character varying,
    manual_post_msg text,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.sale_payment_provider_onboarding_wizard OWNER TO odoo;

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

COMMENT ON TABLE public.sale_payment_provider_onboarding_wizard IS 'Sale Payment provider onboarding wizard';


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

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


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

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


--
-- Name: COLUMN sale_payment_provider_onboarding_wizard.payment_method; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_payment_provider_onboarding_wizard.payment_method IS 'Payment Method';


--
-- Name: COLUMN sale_payment_provider_onboarding_wizard.paypal_user_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_payment_provider_onboarding_wizard.paypal_user_type IS 'Paypal User Type';


--
-- Name: COLUMN sale_payment_provider_onboarding_wizard.paypal_email_account; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_payment_provider_onboarding_wizard.paypal_email_account IS 'Email';


--
-- Name: COLUMN sale_payment_provider_onboarding_wizard.paypal_seller_account; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_payment_provider_onboarding_wizard.paypal_seller_account IS 'Merchant Account ID';


--
-- Name: COLUMN sale_payment_provider_onboarding_wizard.paypal_pdt_token; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_payment_provider_onboarding_wizard.paypal_pdt_token IS 'PDT Identity Token';


--
-- Name: COLUMN sale_payment_provider_onboarding_wizard.manual_name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_payment_provider_onboarding_wizard.manual_name IS 'Method';


--
-- Name: COLUMN sale_payment_provider_onboarding_wizard.journal_name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_payment_provider_onboarding_wizard.journal_name IS 'Bank Name';


--
-- Name: COLUMN sale_payment_provider_onboarding_wizard.acc_number; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_payment_provider_onboarding_wizard.acc_number IS 'Account Number';


--
-- Name: COLUMN sale_payment_provider_onboarding_wizard.manual_post_msg; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_payment_provider_onboarding_wizard.manual_post_msg IS 'Payment Instructions';


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

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


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

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


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

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


ALTER TABLE public.sale_payment_provider_onboarding_wizard_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.sale_payment_provider_onboarding_wizard_id_seq OWNED BY public.sale_payment_provider_onboarding_wizard.id;


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

CREATE TABLE public.sms_composer (
    id integer NOT NULL,
    res_id integer,
    template_id integer,
    create_uid integer,
    write_uid integer,
    composition_mode character varying NOT NULL,
    res_model character varying,
    res_ids character varying,
    recipient_single_number_itf character varying,
    number_field_name character varying,
    numbers character varying,
    body text NOT NULL,
    mass_keep_log boolean,
    mass_force_send boolean,
    mass_use_blacklist boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.sms_composer OWNER TO odoo;

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

COMMENT ON TABLE public.sms_composer IS 'Send SMS Wizard';


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

COMMENT ON COLUMN public.sms_composer.res_id IS 'Document ID';


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

COMMENT ON COLUMN public.sms_composer.template_id IS 'Use Template';


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

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


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

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


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

COMMENT ON COLUMN public.sms_composer.composition_mode IS 'Composition Mode';


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

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


--
-- Name: COLUMN sms_composer.res_ids; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sms_composer.res_ids IS 'Document IDs';


--
-- Name: COLUMN sms_composer.recipient_single_number_itf; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sms_composer.recipient_single_number_itf IS 'Recipient Number';


--
-- Name: COLUMN sms_composer.number_field_name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sms_composer.number_field_name IS 'Number Field';


--
-- Name: COLUMN sms_composer.numbers; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sms_composer.numbers IS 'Recipients (Numbers)';


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

COMMENT ON COLUMN public.sms_composer.body IS 'Message';


--
-- Name: COLUMN sms_composer.mass_keep_log; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sms_composer.mass_keep_log IS 'Keep a note on document';


--
-- Name: COLUMN sms_composer.mass_force_send; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sms_composer.mass_force_send IS 'Send directly';


--
-- Name: COLUMN sms_composer.mass_use_blacklist; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sms_composer.mass_use_blacklist IS 'Use blacklist';


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

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


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

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


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

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


ALTER TABLE public.sms_composer_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.sms_composer_id_seq OWNED BY public.sms_composer.id;


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

CREATE TABLE public.sms_resend (
    id integer NOT NULL,
    mail_message_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.sms_resend OWNER TO odoo;

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

COMMENT ON TABLE public.sms_resend IS 'SMS Resend';


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

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


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

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


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

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


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

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


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

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


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

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


ALTER TABLE public.sms_resend_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.sms_resend_id_seq OWNED BY public.sms_resend.id;


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

CREATE TABLE public.sms_resend_recipient (
    id integer NOT NULL,
    sms_resend_id integer NOT NULL,
    notification_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    partner_name character varying,
    sms_number character varying,
    resend boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.sms_resend_recipient OWNER TO odoo;

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

COMMENT ON TABLE public.sms_resend_recipient IS 'Resend Notification';


--
-- Name: COLUMN sms_resend_recipient.sms_resend_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sms_resend_recipient.sms_resend_id IS 'Sms Resend';


--
-- Name: COLUMN sms_resend_recipient.notification_id; Type: COMMENT; Schema: public; Owner: odoo
--

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


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

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


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

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


--
-- Name: COLUMN sms_resend_recipient.partner_name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sms_resend_recipient.partner_name IS 'Recipient Name';


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

COMMENT ON COLUMN public.sms_resend_recipient.sms_number IS 'Phone Number';


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

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


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

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


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

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


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

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


ALTER TABLE public.sms_resend_recipient_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.sms_resend_recipient_id_seq OWNED BY public.sms_resend_recipient.id;


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

CREATE TABLE public.sms_sms (
    id integer NOT NULL,
    partner_id integer,
    mail_message_id integer,
    create_uid integer,
    write_uid integer,
    number character varying,
    state character varying NOT NULL,
    failure_type character varying,
    body text,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.sms_sms OWNER TO odoo;

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

COMMENT ON TABLE public.sms_sms IS 'Outgoing SMS';


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

COMMENT ON COLUMN public.sms_sms.partner_id IS 'Customer';


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

COMMENT ON COLUMN public.sms_sms.mail_message_id IS 'Mail Message';


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

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


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

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


--
-- Name: COLUMN sms_sms.number; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sms_sms.number IS 'Number';


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

COMMENT ON COLUMN public.sms_sms.state IS 'SMS Status';


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

COMMENT ON COLUMN public.sms_sms.failure_type IS 'Failure Type';


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

COMMENT ON COLUMN public.sms_sms.body IS 'Body';


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

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


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

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


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

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


ALTER TABLE public.sms_sms_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.sms_sms_id_seq OWNED BY public.sms_sms.id;


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

CREATE TABLE public.sms_template (
    id integer NOT NULL,
    model_id integer NOT NULL,
    sidebar_action_id integer,
    create_uid integer,
    write_uid integer,
    template_fs character varying,
    lang character varying,
    model character varying,
    name jsonb,
    body jsonb NOT NULL,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.sms_template OWNER TO odoo;

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

COMMENT ON TABLE public.sms_template IS 'SMS Templates';


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

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


--
-- Name: COLUMN sms_template.sidebar_action_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sms_template.sidebar_action_id IS 'Sidebar action';


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

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


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

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


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

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


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

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


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

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


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

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


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

COMMENT ON COLUMN public.sms_template.body IS 'Body';


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

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


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

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


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

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


ALTER TABLE public.sms_template_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.sms_template_id_seq OWNED BY public.sms_template.id;


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

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


ALTER TABLE public.sms_template_preview OWNER TO odoo;

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

COMMENT ON TABLE public.sms_template_preview IS 'SMS Template Preview';


--
-- Name: COLUMN sms_template_preview.sms_template_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sms_template_preview.sms_template_id IS 'Sms Template';


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

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


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

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


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

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


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

COMMENT ON COLUMN public.sms_template_preview.resource_ref IS 'Record reference';


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

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


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

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


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

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


ALTER TABLE public.sms_template_preview_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.sms_template_preview_id_seq OWNED BY public.sms_template_preview.id;


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

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

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

COMMENT ON TABLE public.sms_template_reset IS 'SMS Template Reset';


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

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


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

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


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

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


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

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


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

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


ALTER TABLE public.sms_template_reset_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.sms_template_reset_id_seq OWNED BY public.sms_template_reset.id;


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

CREATE TABLE public.sms_template_sms_template_reset_rel (
    sms_template_reset_id integer NOT NULL,
    sms_template_id integer NOT NULL
);


ALTER TABLE public.sms_template_sms_template_reset_rel OWNER TO odoo;

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

COMMENT ON TABLE public.sms_template_sms_template_reset_rel IS 'RELATION BETWEEN sms_template_reset AND sms_template';


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

CREATE TABLE public.snailmail_confirm_invoice (
    id integer NOT NULL,
    invoice_send_id integer,
    create_uid integer,
    write_uid integer,
    model_name character varying,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.snailmail_confirm_invoice OWNER TO odoo;

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

COMMENT ON TABLE public.snailmail_confirm_invoice IS 'Snailmail Confirm Invoice';


--
-- Name: COLUMN snailmail_confirm_invoice.invoice_send_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.snailmail_confirm_invoice.invoice_send_id IS 'Invoice Send';


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

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


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

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


--
-- Name: COLUMN snailmail_confirm_invoice.model_name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.snailmail_confirm_invoice.model_name IS 'Model Name';


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

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


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

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


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

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


ALTER TABLE public.snailmail_confirm_invoice_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.snailmail_confirm_invoice_id_seq OWNED BY public.snailmail_confirm_invoice.id;


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

CREATE TABLE public.snailmail_letter (
    id integer NOT NULL,
    user_id integer,
    res_id integer NOT NULL,
    partner_id integer NOT NULL,
    company_id integer NOT NULL,
    report_template integer,
    attachment_id integer,
    message_id integer,
    state_id integer,
    country_id integer,
    create_uid integer,
    write_uid integer,
    model character varying NOT NULL,
    state character varying NOT NULL,
    error_code character varying,
    street character varying,
    street2 character varying,
    zip character varying,
    city character varying,
    info_msg text,
    color boolean,
    cover boolean,
    duplex boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.snailmail_letter OWNER TO odoo;

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

COMMENT ON TABLE public.snailmail_letter IS 'Snailmail Letter';


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

COMMENT ON COLUMN public.snailmail_letter.user_id IS 'Sent by';


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

COMMENT ON COLUMN public.snailmail_letter.res_id IS 'Document ID';


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

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


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

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


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

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


--
-- Name: COLUMN snailmail_letter.attachment_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.snailmail_letter.attachment_id IS 'Attachment';


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

COMMENT ON COLUMN public.snailmail_letter.message_id IS 'Snailmail Status Message';


--
-- Name: COLUMN snailmail_letter.state_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.snailmail_letter.state_id IS 'State';


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

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


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

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


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

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


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

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


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

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


--
-- Name: COLUMN snailmail_letter.error_code; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.snailmail_letter.error_code IS 'Error';


--
-- Name: COLUMN snailmail_letter.street; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.snailmail_letter.street IS 'Street';


--
-- Name: COLUMN snailmail_letter.street2; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.snailmail_letter.street2 IS 'Street2';


--
-- Name: COLUMN snailmail_letter.zip; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.snailmail_letter.zip IS 'Zip';


--
-- Name: COLUMN snailmail_letter.city; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.snailmail_letter.city IS 'City';


--
-- Name: COLUMN snailmail_letter.info_msg; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.snailmail_letter.info_msg IS 'Information';


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

COMMENT ON COLUMN public.snailmail_letter.color IS 'Color';


--
-- Name: COLUMN snailmail_letter.cover; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.snailmail_letter.cover IS 'Cover Page';


--
-- Name: COLUMN snailmail_letter.duplex; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.snailmail_letter.duplex IS 'Both side';


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

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


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

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


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

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


ALTER TABLE public.snailmail_letter_format_error OWNER TO odoo;

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

COMMENT ON TABLE public.snailmail_letter_format_error IS 'Format Error Sending a Snailmail Letter';


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

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


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

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


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

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


--
-- Name: COLUMN snailmail_letter_format_error.snailmail_cover; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.snailmail_letter_format_error.snailmail_cover IS 'Add a Cover Page';


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

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


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

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


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

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


ALTER TABLE public.snailmail_letter_format_error_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.snailmail_letter_format_error_id_seq OWNED BY public.snailmail_letter_format_error.id;


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

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


ALTER TABLE public.snailmail_letter_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.snailmail_letter_id_seq OWNED BY public.snailmail_letter.id;


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

CREATE TABLE public.snailmail_letter_missing_required_fields (
    id integer NOT NULL,
    partner_id integer,
    letter_id integer,
    state_id integer,
    country_id integer,
    create_uid integer,
    write_uid integer,
    street character varying,
    street2 character varying,
    zip character varying,
    city character varying,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.snailmail_letter_missing_required_fields OWNER TO odoo;

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

COMMENT ON TABLE public.snailmail_letter_missing_required_fields IS 'Update address of partner';


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

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


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

COMMENT ON COLUMN public.snailmail_letter_missing_required_fields.letter_id IS 'Letter';


--
-- Name: COLUMN snailmail_letter_missing_required_fields.state_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.snailmail_letter_missing_required_fields.state_id IS 'State';


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

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


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

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


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

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


--
-- Name: COLUMN snailmail_letter_missing_required_fields.street; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.snailmail_letter_missing_required_fields.street IS 'Street';


--
-- Name: COLUMN snailmail_letter_missing_required_fields.street2; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.snailmail_letter_missing_required_fields.street2 IS 'Street2';


--
-- Name: COLUMN snailmail_letter_missing_required_fields.zip; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.snailmail_letter_missing_required_fields.zip IS 'Zip';


--
-- Name: COLUMN snailmail_letter_missing_required_fields.city; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.snailmail_letter_missing_required_fields.city IS 'City';


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

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


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

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


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

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


ALTER TABLE public.snailmail_letter_missing_required_fields_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.snailmail_letter_missing_required_fields_id_seq OWNED BY public.snailmail_letter_missing_required_fields.id;


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

CREATE TABLE public.spreadsheet_dashboard (
    id integer NOT NULL,
    dashboard_group_id integer NOT NULL,
    sequence 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.spreadsheet_dashboard OWNER TO odoo;

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

COMMENT ON TABLE public.spreadsheet_dashboard IS 'Spreadsheet Dashboard';


--
-- Name: COLUMN spreadsheet_dashboard.dashboard_group_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.spreadsheet_dashboard.dashboard_group_id IS 'Dashboard Group';


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

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


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

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


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

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


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

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


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

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


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

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


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

CREATE TABLE public.spreadsheet_dashboard_group (
    id integer NOT NULL,
    sequence 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.spreadsheet_dashboard_group OWNER TO odoo;

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

COMMENT ON TABLE public.spreadsheet_dashboard_group IS 'Group of dashboards';


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

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


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

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


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

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


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

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


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

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


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

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


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

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


ALTER TABLE public.spreadsheet_dashboard_group_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.spreadsheet_dashboard_group_id_seq OWNED BY public.spreadsheet_dashboard_group.id;


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

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


ALTER TABLE public.spreadsheet_dashboard_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.spreadsheet_dashboard_id_seq OWNED BY public.spreadsheet_dashboard.id;


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

CREATE TABLE public.stock_assign_serial (
    id integer NOT NULL,
    move_id integer,
    next_serial_count integer NOT NULL,
    create_uid integer,
    write_uid integer,
    next_serial_number character varying NOT NULL,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.stock_assign_serial OWNER TO odoo;

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

COMMENT ON TABLE public.stock_assign_serial IS 'Stock Assign Serial Numbers';


--
-- Name: COLUMN stock_assign_serial.move_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_assign_serial.move_id IS 'Move';


--
-- Name: COLUMN stock_assign_serial.next_serial_count; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_assign_serial.next_serial_count IS 'Number of SN';


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

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


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

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


--
-- Name: COLUMN stock_assign_serial.next_serial_number; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_assign_serial.next_serial_number IS 'First SN';


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

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


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

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


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

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


ALTER TABLE public.stock_assign_serial_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.stock_assign_serial_id_seq OWNED BY public.stock_assign_serial.id;


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

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


ALTER TABLE public.stock_backorder_confirmation OWNER TO odoo;

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

COMMENT ON TABLE public.stock_backorder_confirmation IS 'Backorder Confirmation';


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

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


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

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


--
-- Name: COLUMN stock_backorder_confirmation.show_transfers; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_backorder_confirmation.show_transfers IS 'Show Transfers';


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

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


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

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


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

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


ALTER TABLE public.stock_backorder_confirmation_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.stock_backorder_confirmation_id_seq OWNED BY public.stock_backorder_confirmation.id;


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

CREATE TABLE public.stock_backorder_confirmation_line (
    id integer NOT NULL,
    backorder_confirmation_id integer,
    picking_id integer,
    create_uid integer,
    write_uid integer,
    to_backorder boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.stock_backorder_confirmation_line OWNER TO odoo;

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

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


--
-- Name: COLUMN stock_backorder_confirmation_line.backorder_confirmation_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_backorder_confirmation_line.backorder_confirmation_id IS 'Immediate Transfer';


--
-- Name: COLUMN stock_backorder_confirmation_line.picking_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_backorder_confirmation_line.picking_id IS 'Transfer';


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

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


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

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


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

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


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

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


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

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


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

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


ALTER TABLE public.stock_backorder_confirmation_line_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.stock_backorder_confirmation_line_id_seq OWNED BY public.stock_backorder_confirmation_line.id;


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

CREATE TABLE public.stock_change_product_qty (
    id integer NOT NULL,
    product_id integer NOT NULL,
    product_tmpl_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    new_quantity numeric NOT NULL,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.stock_change_product_qty OWNER TO odoo;

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

COMMENT ON TABLE public.stock_change_product_qty IS 'Change Product Quantity';


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

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


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

COMMENT ON COLUMN public.stock_change_product_qty.product_tmpl_id IS 'Template';


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

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


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

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


--
-- Name: COLUMN stock_change_product_qty.new_quantity; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_change_product_qty.new_quantity IS 'New Quantity on Hand';


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

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


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

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


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

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


ALTER TABLE public.stock_change_product_qty_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.stock_change_product_qty_id_seq OWNED BY public.stock_change_product_qty.id;


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

CREATE TABLE public.stock_conflict_quant_rel (
    stock_inventory_conflict_id integer NOT NULL,
    stock_quant_id integer NOT NULL
);


ALTER TABLE public.stock_conflict_quant_rel OWNER TO odoo;

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

COMMENT ON TABLE public.stock_conflict_quant_rel IS 'RELATION BETWEEN stock_inventory_conflict AND stock_quant';


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

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


ALTER TABLE public.stock_immediate_transfer OWNER TO odoo;

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

COMMENT ON TABLE public.stock_immediate_transfer IS 'Immediate Transfer';


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

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


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

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


--
-- Name: COLUMN stock_immediate_transfer.show_transfers; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_immediate_transfer.show_transfers IS 'Show Transfers';


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

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


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

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


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

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


ALTER TABLE public.stock_immediate_transfer_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.stock_immediate_transfer_id_seq OWNED BY public.stock_immediate_transfer.id;


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

CREATE TABLE public.stock_immediate_transfer_line (
    id integer NOT NULL,
    immediate_transfer_id integer NOT NULL,
    picking_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    to_immediate boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.stock_immediate_transfer_line OWNER TO odoo;

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

COMMENT ON TABLE public.stock_immediate_transfer_line IS 'Immediate Transfer Line';


--
-- Name: COLUMN stock_immediate_transfer_line.immediate_transfer_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_immediate_transfer_line.immediate_transfer_id IS 'Immediate Transfer';


--
-- Name: COLUMN stock_immediate_transfer_line.picking_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_immediate_transfer_line.picking_id IS 'Transfer';


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

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


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

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


--
-- Name: COLUMN stock_immediate_transfer_line.to_immediate; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_immediate_transfer_line.to_immediate IS 'To Process';


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

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


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

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


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

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


ALTER TABLE public.stock_immediate_transfer_line_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.stock_immediate_transfer_line_id_seq OWNED BY public.stock_immediate_transfer_line.id;


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

CREATE TABLE public.stock_inventory_adjustment_name (
    id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    inventory_adjustment_name character varying,
    show_info boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.stock_inventory_adjustment_name OWNER TO odoo;

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

COMMENT ON TABLE public.stock_inventory_adjustment_name IS 'Inventory Adjustment Reference / Reason';


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

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


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

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


--
-- Name: COLUMN stock_inventory_adjustment_name.inventory_adjustment_name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_inventory_adjustment_name.inventory_adjustment_name IS 'Inventory Adjustment Name';


--
-- Name: COLUMN stock_inventory_adjustment_name.show_info; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_inventory_adjustment_name.show_info IS 'Show warning';


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

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


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

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


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

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


ALTER TABLE public.stock_inventory_adjustment_name_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.stock_inventory_adjustment_name_id_seq OWNED BY public.stock_inventory_adjustment_name.id;


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

CREATE TABLE public.stock_inventory_adjustment_name_stock_quant_rel (
    stock_inventory_adjustment_name_id integer NOT NULL,
    stock_quant_id integer NOT NULL
);


ALTER TABLE public.stock_inventory_adjustment_name_stock_quant_rel OWNER TO odoo;

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

COMMENT ON TABLE public.stock_inventory_adjustment_name_stock_quant_rel IS 'RELATION BETWEEN stock_inventory_adjustment_name AND stock_quant';


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

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

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

COMMENT ON TABLE public.stock_inventory_conflict IS 'Conflict in Inventory';


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

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


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

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


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

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


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

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


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

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


ALTER TABLE public.stock_inventory_conflict_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.stock_inventory_conflict_id_seq OWNED BY public.stock_inventory_conflict.id;


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

CREATE TABLE public.stock_inventory_conflict_stock_quant_rel (
    stock_inventory_conflict_id integer NOT NULL,
    stock_quant_id integer NOT NULL
);


ALTER TABLE public.stock_inventory_conflict_stock_quant_rel OWNER TO odoo;

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

COMMENT ON TABLE public.stock_inventory_conflict_stock_quant_rel IS 'RELATION BETWEEN stock_inventory_conflict AND stock_quant';


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

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

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

COMMENT ON TABLE public.stock_inventory_warning IS 'Inventory Adjustment Warning';


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

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


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

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


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

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


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

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


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

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


ALTER TABLE public.stock_inventory_warning_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.stock_inventory_warning_id_seq OWNED BY public.stock_inventory_warning.id;


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

CREATE TABLE public.stock_inventory_warning_stock_quant_rel (
    stock_inventory_warning_id integer NOT NULL,
    stock_quant_id integer NOT NULL
);


ALTER TABLE public.stock_inventory_warning_stock_quant_rel OWNER TO odoo;

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

COMMENT ON TABLE public.stock_inventory_warning_stock_quant_rel IS 'RELATION BETWEEN stock_inventory_warning AND stock_quant';


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

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


ALTER TABLE public.stock_location_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.stock_location_id_seq OWNED BY public.stock_location.id;


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

CREATE TABLE public.stock_lot (
    id integer NOT NULL,
    message_main_attachment_id integer,
    product_id integer NOT NULL,
    product_uom_id integer,
    company_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    name character varying NOT NULL,
    ref character varying,
    note text,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.stock_lot OWNER TO odoo;

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

COMMENT ON TABLE public.stock_lot IS 'Lot/Serial';


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

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


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

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


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

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


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

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


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

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


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

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


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

COMMENT ON COLUMN public.stock_lot.name IS 'Lot/Serial Number';


--
-- Name: COLUMN stock_lot.ref; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_lot.ref IS 'Internal Reference';


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

COMMENT ON COLUMN public.stock_lot.note IS 'Description';


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

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


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

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


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

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


ALTER TABLE public.stock_lot_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.stock_lot_id_seq OWNED BY public.stock_lot.id;


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

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


ALTER TABLE public.stock_move_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.stock_move_id_seq OWNED BY public.stock_move.id;


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

CREATE TABLE public.stock_move_line (
    id integer NOT NULL,
    picking_id integer,
    move_id integer,
    company_id integer NOT NULL,
    product_id integer,
    product_uom_id integer NOT NULL,
    package_id integer,
    package_level_id integer,
    lot_id integer,
    result_package_id integer,
    owner_id integer,
    location_id integer NOT NULL,
    location_dest_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    product_category_name character varying,
    lot_name character varying,
    state character varying,
    reference character varying,
    description_picking text,
    reserved_qty numeric,
    reserved_uom_qty numeric NOT NULL,
    qty_done numeric,
    date timestamp without time zone NOT NULL,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.stock_move_line OWNER TO odoo;

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

COMMENT ON TABLE public.stock_move_line IS 'Product Moves (Stock Move Line)';


--
-- Name: COLUMN stock_move_line.picking_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move_line.picking_id IS 'Transfer';


--
-- Name: COLUMN stock_move_line.move_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move_line.move_id IS 'Stock Operation';


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

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


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

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


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

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


--
-- Name: COLUMN stock_move_line.package_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move_line.package_id IS 'Source Package';


--
-- Name: COLUMN stock_move_line.package_level_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move_line.package_level_id IS 'Package Level';


--
-- Name: COLUMN stock_move_line.lot_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move_line.lot_id IS 'Lot/Serial Number';


--
-- Name: COLUMN stock_move_line.result_package_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move_line.result_package_id IS 'Destination Package';


--
-- Name: COLUMN stock_move_line.owner_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move_line.owner_id IS 'From Owner';


--
-- Name: COLUMN stock_move_line.location_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move_line.location_id IS 'From';


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

COMMENT ON COLUMN public.stock_move_line.location_dest_id IS 'To';


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

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


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

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


--
-- Name: COLUMN stock_move_line.product_category_name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move_line.product_category_name IS 'Product Category';


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

COMMENT ON COLUMN public.stock_move_line.lot_name IS 'Lot/Serial Number Name';


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

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


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

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


--
-- Name: COLUMN stock_move_line.description_picking; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move_line.description_picking IS 'Description picking';


--
-- Name: COLUMN stock_move_line.reserved_qty; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move_line.reserved_qty IS 'Real Reserved Quantity';


--
-- Name: COLUMN stock_move_line.reserved_uom_qty; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move_line.reserved_uom_qty IS 'Reserved';


--
-- Name: COLUMN stock_move_line.qty_done; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move_line.qty_done IS 'Done';


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

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


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

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


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

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


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

CREATE TABLE public.stock_move_line_consume_rel (
    consume_line_id integer NOT NULL,
    produce_line_id integer NOT NULL
);


ALTER TABLE public.stock_move_line_consume_rel OWNER TO odoo;

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

COMMENT ON TABLE public.stock_move_line_consume_rel IS 'RELATION BETWEEN stock_move_line AND stock_move_line';


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

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


ALTER TABLE public.stock_move_line_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.stock_move_line_id_seq OWNED BY public.stock_move_line.id;


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

CREATE TABLE public.stock_move_move_rel (
    move_orig_id integer NOT NULL,
    move_dest_id integer NOT NULL
);


ALTER TABLE public.stock_move_move_rel OWNER TO odoo;

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

COMMENT ON TABLE public.stock_move_move_rel IS 'RELATION BETWEEN stock_move AND stock_move';


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

CREATE TABLE public.stock_orderpoint_snooze (
    id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    predefined_date character varying,
    snoozed_until date,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.stock_orderpoint_snooze OWNER TO odoo;

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

COMMENT ON TABLE public.stock_orderpoint_snooze IS 'Snooze Orderpoint';


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

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


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

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


--
-- Name: COLUMN stock_orderpoint_snooze.predefined_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_orderpoint_snooze.predefined_date IS 'Snooze for';


--
-- Name: COLUMN stock_orderpoint_snooze.snoozed_until; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_orderpoint_snooze.snoozed_until IS 'Snooze Date';


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

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


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

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


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

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


ALTER TABLE public.stock_orderpoint_snooze_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.stock_orderpoint_snooze_id_seq OWNED BY public.stock_orderpoint_snooze.id;


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

CREATE TABLE public.stock_orderpoint_snooze_stock_warehouse_orderpoint_rel (
    stock_orderpoint_snooze_id integer NOT NULL,
    stock_warehouse_orderpoint_id integer NOT NULL
);


ALTER TABLE public.stock_orderpoint_snooze_stock_warehouse_orderpoint_rel OWNER TO odoo;

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

COMMENT ON TABLE public.stock_orderpoint_snooze_stock_warehouse_orderpoint_rel IS 'RELATION BETWEEN stock_orderpoint_snooze AND stock_warehouse_orderpoint';


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

CREATE TABLE public.stock_package_destination (
    id integer NOT NULL,
    picking_id integer NOT NULL,
    location_dest_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.stock_package_destination OWNER TO odoo;

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

COMMENT ON TABLE public.stock_package_destination IS 'Stock Package Destination';


--
-- Name: COLUMN stock_package_destination.picking_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_package_destination.picking_id IS 'Picking';


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

COMMENT ON COLUMN public.stock_package_destination.location_dest_id IS 'Destination location';


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

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


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

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


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

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


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

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


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

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


ALTER TABLE public.stock_package_destination_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.stock_package_destination_id_seq OWNED BY public.stock_package_destination.id;


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

CREATE TABLE public.stock_package_level (
    id integer NOT NULL,
    package_id integer NOT NULL,
    picking_id integer,
    location_dest_id integer,
    company_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.stock_package_level OWNER TO odoo;

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

COMMENT ON TABLE public.stock_package_level IS 'Stock Package Level';


--
-- Name: COLUMN stock_package_level.package_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_package_level.package_id IS 'Package';


--
-- Name: COLUMN stock_package_level.picking_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_package_level.picking_id IS 'Picking';


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

COMMENT ON COLUMN public.stock_package_level.location_dest_id IS 'To';


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

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


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

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


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

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


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

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


--
-- Name: COLUMN stock_package_level.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_package_level.write_date IS 'Last Updated on';


--
-- Name: stock_package_level_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.stock_package_level_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.stock_package_level_id_seq OWNER TO odoo;

--
-- Name: stock_package_level_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.stock_package_level_id_seq OWNED BY public.stock_package_level.id;


--
-- Name: stock_package_type; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.stock_package_type (
    id integer NOT NULL,
    sequence integer,
    height integer,
    width integer,
    packaging_length integer,
    company_id integer,
    create_uid integer,
    write_uid integer,
    name character varying NOT NULL,
    barcode character varying,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    base_weight double precision,
    max_weight double precision,
    CONSTRAINT stock_package_type_positive_height CHECK ((height >= 0)),
    CONSTRAINT stock_package_type_positive_length CHECK ((packaging_length >= 0)),
    CONSTRAINT stock_package_type_positive_max_weight CHECK ((max_weight >= (0.0)::double precision)),
    CONSTRAINT stock_package_type_positive_width CHECK ((width >= 0))
);


ALTER TABLE public.stock_package_type OWNER TO odoo;

--
-- Name: TABLE stock_package_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.stock_package_type IS 'Stock package type';


--
-- Name: COLUMN stock_package_type.sequence; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_package_type.sequence IS 'Sequence';


--
-- Name: COLUMN stock_package_type.height; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_package_type.height IS 'Height';


--
-- Name: COLUMN stock_package_type.width; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_package_type.width IS 'Width';


--
-- Name: COLUMN stock_package_type.packaging_length; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_package_type.packaging_length IS 'Length';


--
-- Name: COLUMN stock_package_type.company_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_package_type.company_id IS 'Company';


--
-- Name: COLUMN stock_package_type.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_package_type.create_uid IS 'Created by';


--
-- Name: COLUMN stock_package_type.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_package_type.write_uid IS 'Last Updated by';


--
-- Name: COLUMN stock_package_type.name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_package_type.name IS 'Package Type';


--
-- Name: COLUMN stock_package_type.barcode; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_package_type.barcode IS 'Barcode';


--
-- Name: COLUMN stock_package_type.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_package_type.create_date IS 'Created on';


--
-- Name: COLUMN stock_package_type.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_package_type.write_date IS 'Last Updated on';


--
-- Name: COLUMN stock_package_type.base_weight; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_package_type.base_weight IS 'Weight';


--
-- Name: COLUMN stock_package_type.max_weight; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_package_type.max_weight IS 'Max Weight';


--
-- Name: CONSTRAINT stock_package_type_positive_height ON stock_package_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT stock_package_type_positive_height ON public.stock_package_type IS 'CHECK(height>=0)';


--
-- Name: CONSTRAINT stock_package_type_positive_length ON stock_package_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT stock_package_type_positive_length ON public.stock_package_type IS 'CHECK(packaging_length>=0)';


--
-- Name: CONSTRAINT stock_package_type_positive_max_weight ON stock_package_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT stock_package_type_positive_max_weight ON public.stock_package_type IS 'CHECK(max_weight>=0.0)';


--
-- Name: CONSTRAINT stock_package_type_positive_width ON stock_package_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT stock_package_type_positive_width ON public.stock_package_type IS 'CHECK(width>=0)';


--
-- Name: stock_package_type_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.stock_package_type_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.stock_package_type_id_seq OWNER TO odoo;

--
-- Name: stock_package_type_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.stock_package_type_id_seq OWNED BY public.stock_package_type.id;


--
-- Name: stock_package_type_stock_putaway_rule_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.stock_package_type_stock_putaway_rule_rel (
    stock_putaway_rule_id integer NOT NULL,
    stock_package_type_id integer NOT NULL
);


ALTER TABLE public.stock_package_type_stock_putaway_rule_rel OWNER TO odoo;

--
-- Name: TABLE stock_package_type_stock_putaway_rule_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.stock_package_type_stock_putaway_rule_rel IS 'RELATION BETWEEN stock_putaway_rule AND stock_package_type';


--
-- Name: stock_picking; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.stock_picking (
    id integer NOT NULL,
    message_main_attachment_id integer,
    backorder_id integer,
    group_id integer,
    location_id integer NOT NULL,
    location_dest_id integer NOT NULL,
    picking_type_id integer NOT NULL,
    partner_id integer,
    company_id integer,
    user_id integer,
    owner_id integer,
    create_uid integer,
    write_uid integer,
    name character varying,
    origin character varying,
    move_type character varying NOT NULL,
    state character varying,
    priority character varying,
    note text,
    has_deadline_issue boolean,
    printed boolean,
    is_locked boolean,
    immediate_transfer boolean,
    scheduled_date timestamp without time zone,
    date_deadline timestamp without time zone,
    date timestamp without time zone,
    date_done timestamp without time zone,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    sale_id integer
);


ALTER TABLE public.stock_picking OWNER TO odoo;

--
-- Name: TABLE stock_picking; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.stock_picking IS 'Transfer';


--
-- Name: COLUMN stock_picking.message_main_attachment_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking.message_main_attachment_id IS 'Main Attachment';


--
-- Name: COLUMN stock_picking.backorder_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking.backorder_id IS 'Back Order of';


--
-- Name: COLUMN stock_picking.group_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking.group_id IS 'Procurement Group';


--
-- Name: COLUMN stock_picking.location_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking.location_id IS 'Source Location';


--
-- Name: COLUMN stock_picking.location_dest_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking.location_dest_id IS 'Destination Location';


--
-- Name: COLUMN stock_picking.picking_type_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking.picking_type_id IS 'Operation Type';


--
-- Name: COLUMN stock_picking.partner_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking.partner_id IS 'Contact';


--
-- Name: COLUMN stock_picking.company_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking.company_id IS 'Company';


--
-- Name: COLUMN stock_picking.user_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking.user_id IS 'Responsible';


--
-- Name: COLUMN stock_picking.owner_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking.owner_id IS 'Assign Owner';


--
-- Name: COLUMN stock_picking.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking.create_uid IS 'Created by';


--
-- Name: COLUMN stock_picking.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking.write_uid IS 'Last Updated by';


--
-- Name: COLUMN stock_picking.name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking.name IS 'Reference';


--
-- Name: COLUMN stock_picking.origin; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking.origin IS 'Source Document';


--
-- Name: COLUMN stock_picking.move_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking.move_type IS 'Shipping Policy';


--
-- Name: COLUMN stock_picking.state; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking.state IS 'Status';


--
-- Name: COLUMN stock_picking.priority; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking.priority IS 'Priority';


--
-- Name: COLUMN stock_picking.note; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking.note IS 'Notes';


--
-- Name: COLUMN stock_picking.has_deadline_issue; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking.has_deadline_issue IS 'Is late';


--
-- Name: COLUMN stock_picking.printed; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking.printed IS 'Printed';


--
-- Name: COLUMN stock_picking.is_locked; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking.is_locked IS 'Is Locked';


--
-- Name: COLUMN stock_picking.immediate_transfer; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking.immediate_transfer IS 'Immediate Transfer';


--
-- Name: COLUMN stock_picking.scheduled_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking.scheduled_date IS 'Scheduled Date';


--
-- Name: COLUMN stock_picking.date_deadline; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking.date_deadline IS 'Deadline';


--
-- Name: COLUMN stock_picking.date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking.date IS 'Creation Date';


--
-- Name: COLUMN stock_picking.date_done; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking.date_done IS 'Date of Transfer';


--
-- Name: COLUMN stock_picking.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking.create_date IS 'Created on';


--
-- Name: COLUMN stock_picking.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking.write_date IS 'Last Updated on';


--
-- Name: stock_picking_backorder_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.stock_picking_backorder_rel (
    stock_backorder_confirmation_id integer NOT NULL,
    stock_picking_id integer NOT NULL
);


ALTER TABLE public.stock_picking_backorder_rel OWNER TO odoo;

--
-- Name: TABLE stock_picking_backorder_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.stock_picking_backorder_rel IS 'RELATION BETWEEN stock_backorder_confirmation AND stock_picking';


--
-- Name: stock_picking_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.stock_picking_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.stock_picking_id_seq OWNER TO odoo;

--
-- Name: stock_picking_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.stock_picking_id_seq OWNED BY public.stock_picking.id;


--
-- Name: stock_picking_sms_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.stock_picking_sms_rel (
    confirm_stock_sms_id integer NOT NULL,
    stock_picking_id integer NOT NULL
);


ALTER TABLE public.stock_picking_sms_rel OWNER TO odoo;

--
-- Name: TABLE stock_picking_sms_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.stock_picking_sms_rel IS 'RELATION BETWEEN confirm_stock_sms AND stock_picking';


--
-- Name: stock_picking_transfer_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.stock_picking_transfer_rel (
    stock_immediate_transfer_id integer NOT NULL,
    stock_picking_id integer NOT NULL
);


ALTER TABLE public.stock_picking_transfer_rel OWNER TO odoo;

--
-- Name: TABLE stock_picking_transfer_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.stock_picking_transfer_rel IS 'RELATION BETWEEN stock_immediate_transfer AND stock_picking';


--
-- Name: stock_picking_type; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.stock_picking_type (
    id integer NOT NULL,
    color integer,
    sequence integer,
    sequence_id integer,
    default_location_src_id integer,
    default_location_dest_id integer,
    return_picking_type_id integer,
    warehouse_id integer,
    reservation_days_before integer,
    reservation_days_before_priority integer,
    company_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    sequence_code character varying NOT NULL,
    code character varying NOT NULL,
    reservation_method character varying NOT NULL,
    barcode character varying,
    create_backorder character varying NOT NULL,
    name jsonb NOT NULL,
    show_entire_packs boolean,
    active boolean,
    use_create_lots boolean,
    use_existing_lots boolean,
    print_label boolean,
    show_operations boolean,
    show_reserved boolean,
    auto_show_reception_report boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.stock_picking_type OWNER TO odoo;

--
-- Name: TABLE stock_picking_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.stock_picking_type IS 'Picking Type';


--
-- Name: COLUMN stock_picking_type.color; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking_type.color IS 'Color';


--
-- Name: COLUMN stock_picking_type.sequence; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking_type.sequence IS 'Sequence';


--
-- Name: COLUMN stock_picking_type.sequence_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking_type.sequence_id IS 'Reference Sequence';


--
-- Name: COLUMN stock_picking_type.default_location_src_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking_type.default_location_src_id IS 'Default Source Location';


--
-- Name: COLUMN stock_picking_type.default_location_dest_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking_type.default_location_dest_id IS 'Default Destination Location';


--
-- Name: COLUMN stock_picking_type.return_picking_type_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking_type.return_picking_type_id IS 'Operation Type for Returns';


--
-- Name: COLUMN stock_picking_type.warehouse_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking_type.warehouse_id IS 'Warehouse';


--
-- Name: COLUMN stock_picking_type.reservation_days_before; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking_type.reservation_days_before IS 'Days';


--
-- Name: COLUMN stock_picking_type.reservation_days_before_priority; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking_type.reservation_days_before_priority IS 'Days when starred';


--
-- Name: COLUMN stock_picking_type.company_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking_type.company_id IS 'Company';


--
-- Name: COLUMN stock_picking_type.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking_type.create_uid IS 'Created by';


--
-- Name: COLUMN stock_picking_type.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking_type.write_uid IS 'Last Updated by';


--
-- Name: COLUMN stock_picking_type.sequence_code; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking_type.sequence_code IS 'Sequence Prefix';


--
-- Name: COLUMN stock_picking_type.code; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking_type.code IS 'Type of Operation';


--
-- Name: COLUMN stock_picking_type.reservation_method; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking_type.reservation_method IS 'Reservation Method';


--
-- Name: COLUMN stock_picking_type.barcode; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking_type.barcode IS 'Barcode';


--
-- Name: COLUMN stock_picking_type.create_backorder; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking_type.create_backorder IS 'Create Backorder';


--
-- Name: COLUMN stock_picking_type.name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking_type.name IS 'Operation Type';


--
-- Name: COLUMN stock_picking_type.show_entire_packs; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking_type.show_entire_packs IS 'Move Entire Packages';


--
-- Name: COLUMN stock_picking_type.active; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking_type.active IS 'Active';


--
-- Name: COLUMN stock_picking_type.use_create_lots; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking_type.use_create_lots IS 'Create New Lots/Serial Numbers';


--
-- Name: COLUMN stock_picking_type.use_existing_lots; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking_type.use_existing_lots IS 'Use Existing Lots/Serial Numbers';


--
-- Name: COLUMN stock_picking_type.print_label; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking_type.print_label IS 'Print Label';


--
-- Name: COLUMN stock_picking_type.show_operations; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking_type.show_operations IS 'Show Detailed Operations';


--
-- Name: COLUMN stock_picking_type.show_reserved; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking_type.show_reserved IS 'Pre-fill Detailed Operations';


--
-- Name: COLUMN stock_picking_type.auto_show_reception_report; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking_type.auto_show_reception_report IS 'Show Reception Report at Validation';


--
-- Name: COLUMN stock_picking_type.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking_type.create_date IS 'Created on';


--
-- Name: COLUMN stock_picking_type.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking_type.write_date IS 'Last Updated on';


--
-- Name: stock_picking_type_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.stock_picking_type_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.stock_picking_type_id_seq OWNER TO odoo;

--
-- Name: stock_picking_type_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.stock_picking_type_id_seq OWNED BY public.stock_picking_type.id;


--
-- Name: stock_putaway_rule; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.stock_putaway_rule (
    id integer NOT NULL,
    product_id integer,
    category_id integer,
    location_in_id integer NOT NULL,
    location_out_id integer NOT NULL,
    sequence integer,
    company_id integer NOT NULL,
    storage_category_id integer,
    create_uid integer,
    write_uid integer,
    active boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.stock_putaway_rule OWNER TO odoo;

--
-- Name: TABLE stock_putaway_rule; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.stock_putaway_rule IS 'Putaway Rule';


--
-- Name: COLUMN stock_putaway_rule.product_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_putaway_rule.product_id IS 'Product';


--
-- Name: COLUMN stock_putaway_rule.category_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_putaway_rule.category_id IS 'Product Category';


--
-- Name: COLUMN stock_putaway_rule.location_in_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_putaway_rule.location_in_id IS 'When product arrives in';


--
-- Name: COLUMN stock_putaway_rule.location_out_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_putaway_rule.location_out_id IS 'Store to sublocation';


--
-- Name: COLUMN stock_putaway_rule.sequence; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_putaway_rule.sequence IS 'Priority';


--
-- Name: COLUMN stock_putaway_rule.company_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_putaway_rule.company_id IS 'Company';


--
-- Name: COLUMN stock_putaway_rule.storage_category_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_putaway_rule.storage_category_id IS 'Storage Category';


--
-- Name: COLUMN stock_putaway_rule.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_putaway_rule.create_uid IS 'Created by';


--
-- Name: COLUMN stock_putaway_rule.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_putaway_rule.write_uid IS 'Last Updated by';


--
-- Name: COLUMN stock_putaway_rule.active; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_putaway_rule.active IS 'Active';


--
-- Name: COLUMN stock_putaway_rule.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_putaway_rule.create_date IS 'Created on';


--
-- Name: COLUMN stock_putaway_rule.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_putaway_rule.write_date IS 'Last Updated on';


--
-- Name: stock_putaway_rule_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.stock_putaway_rule_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.stock_putaway_rule_id_seq OWNER TO odoo;

--
-- Name: stock_putaway_rule_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.stock_putaway_rule_id_seq OWNED BY public.stock_putaway_rule.id;


--
-- Name: stock_quant_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.stock_quant_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.stock_quant_id_seq OWNER TO odoo;

--
-- Name: stock_quant_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.stock_quant_id_seq OWNED BY public.stock_quant.id;


--
-- Name: stock_quant_package; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.stock_quant_package (
    id integer NOT NULL,
    package_type_id integer,
    location_id integer,
    company_id integer,
    create_uid integer,
    write_uid integer,
    name character varying NOT NULL,
    package_use character varying NOT NULL,
    pack_date date,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.stock_quant_package OWNER TO odoo;

--
-- Name: TABLE stock_quant_package; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.stock_quant_package IS 'Packages';


--
-- Name: COLUMN stock_quant_package.package_type_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_quant_package.package_type_id IS 'Package Type';


--
-- Name: COLUMN stock_quant_package.location_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_quant_package.location_id IS 'Location';


--
-- Name: COLUMN stock_quant_package.company_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_quant_package.company_id IS 'Company';


--
-- Name: COLUMN stock_quant_package.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_quant_package.create_uid IS 'Created by';


--
-- Name: COLUMN stock_quant_package.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_quant_package.write_uid IS 'Last Updated by';


--
-- Name: COLUMN stock_quant_package.name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_quant_package.name IS 'Package Reference';


--
-- Name: COLUMN stock_quant_package.package_use; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_quant_package.package_use IS 'Package Use';


--
-- Name: COLUMN stock_quant_package.pack_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_quant_package.pack_date IS 'Pack Date';


--
-- Name: COLUMN stock_quant_package.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_quant_package.create_date IS 'Created on';


--
-- Name: COLUMN stock_quant_package.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_quant_package.write_date IS 'Last Updated on';


--
-- Name: stock_quant_package_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.stock_quant_package_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.stock_quant_package_id_seq OWNER TO odoo;

--
-- Name: stock_quant_package_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.stock_quant_package_id_seq OWNED BY public.stock_quant_package.id;


--
-- Name: stock_quant_stock_request_count_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.stock_quant_stock_request_count_rel (
    stock_request_count_id integer NOT NULL,
    stock_quant_id integer NOT NULL
);


ALTER TABLE public.stock_quant_stock_request_count_rel OWNER TO odoo;

--
-- Name: TABLE stock_quant_stock_request_count_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.stock_quant_stock_request_count_rel IS 'RELATION BETWEEN stock_request_count AND stock_quant';


--
-- Name: stock_quant_stock_track_confirmation_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.stock_quant_stock_track_confirmation_rel (
    stock_track_confirmation_id integer NOT NULL,
    stock_quant_id integer NOT NULL
);


ALTER TABLE public.stock_quant_stock_track_confirmation_rel OWNER TO odoo;

--
-- Name: TABLE stock_quant_stock_track_confirmation_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.stock_quant_stock_track_confirmation_rel IS 'RELATION BETWEEN stock_track_confirmation AND stock_quant';


--
-- Name: stock_quantity_history; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.stock_quantity_history (
    id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    inventory_datetime timestamp without time zone,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.stock_quantity_history OWNER TO odoo;

--
-- Name: TABLE stock_quantity_history; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.stock_quantity_history IS 'Stock Quantity History';


--
-- Name: COLUMN stock_quantity_history.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_quantity_history.create_uid IS 'Created by';


--
-- Name: COLUMN stock_quantity_history.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_quantity_history.write_uid IS 'Last Updated by';


--
-- Name: COLUMN stock_quantity_history.inventory_datetime; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_quantity_history.inventory_datetime IS 'Inventory at Date';


--
-- Name: COLUMN stock_quantity_history.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_quantity_history.create_date IS 'Created on';


--
-- Name: COLUMN stock_quantity_history.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_quantity_history.write_date IS 'Last Updated on';


--
-- Name: stock_quantity_history_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.stock_quantity_history_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.stock_quantity_history_id_seq OWNER TO odoo;

--
-- Name: stock_quantity_history_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.stock_quantity_history_id_seq OWNED BY public.stock_quantity_history.id;


--
-- Name: stock_replenishment_info; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.stock_replenishment_info (
    id integer NOT NULL,
    orderpoint_id integer,
    create_uid integer,
    write_uid integer,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.stock_replenishment_info OWNER TO odoo;

--
-- Name: TABLE stock_replenishment_info; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.stock_replenishment_info IS 'Stock supplier replenishment information';


--
-- Name: COLUMN stock_replenishment_info.orderpoint_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_replenishment_info.orderpoint_id IS 'Orderpoint';


--
-- Name: COLUMN stock_replenishment_info.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_replenishment_info.create_uid IS 'Created by';


--
-- Name: COLUMN stock_replenishment_info.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_replenishment_info.write_uid IS 'Last Updated by';


--
-- Name: COLUMN stock_replenishment_info.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_replenishment_info.create_date IS 'Created on';


--
-- Name: COLUMN stock_replenishment_info.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_replenishment_info.write_date IS 'Last Updated on';


--
-- Name: stock_replenishment_info_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.stock_replenishment_info_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.stock_replenishment_info_id_seq OWNER TO odoo;

--
-- Name: stock_replenishment_info_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.stock_replenishment_info_id_seq OWNED BY public.stock_replenishment_info.id;


--
-- Name: stock_replenishment_option; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.stock_replenishment_option (
    id integer NOT NULL,
    route_id integer,
    product_id integer,
    replenishment_info_id integer,
    create_uid integer,
    write_uid integer,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.stock_replenishment_option OWNER TO odoo;

--
-- Name: TABLE stock_replenishment_option; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.stock_replenishment_option IS 'Stock warehouse replenishment option';


--
-- Name: COLUMN stock_replenishment_option.route_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_replenishment_option.route_id IS 'Route';


--
-- Name: COLUMN stock_replenishment_option.product_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_replenishment_option.product_id IS 'Product';


--
-- Name: COLUMN stock_replenishment_option.replenishment_info_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_replenishment_option.replenishment_info_id IS 'Replenishment Info';


--
-- Name: COLUMN stock_replenishment_option.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_replenishment_option.create_uid IS 'Created by';


--
-- Name: COLUMN stock_replenishment_option.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_replenishment_option.write_uid IS 'Last Updated by';


--
-- Name: COLUMN stock_replenishment_option.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_replenishment_option.create_date IS 'Created on';


--
-- Name: COLUMN stock_replenishment_option.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_replenishment_option.write_date IS 'Last Updated on';


--
-- Name: stock_replenishment_option_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.stock_replenishment_option_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.stock_replenishment_option_id_seq OWNER TO odoo;

--
-- Name: stock_replenishment_option_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.stock_replenishment_option_id_seq OWNED BY public.stock_replenishment_option.id;


--
-- Name: stock_request_count; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.stock_request_count (
    id integer NOT NULL,
    user_id integer,
    create_uid integer,
    write_uid integer,
    set_count character varying,
    inventory_date date NOT NULL,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    accounting_date date
);


ALTER TABLE public.stock_request_count OWNER TO odoo;

--
-- Name: TABLE stock_request_count; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.stock_request_count IS 'Stock Request an Inventory Count';


--
-- Name: COLUMN stock_request_count.user_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_request_count.user_id IS 'User';


--
-- Name: COLUMN stock_request_count.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_request_count.create_uid IS 'Created by';


--
-- Name: COLUMN stock_request_count.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_request_count.write_uid IS 'Last Updated by';


--
-- Name: COLUMN stock_request_count.set_count; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_request_count.set_count IS 'Count';


--
-- Name: COLUMN stock_request_count.inventory_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_request_count.inventory_date IS 'Inventory Date';


--
-- Name: COLUMN stock_request_count.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_request_count.create_date IS 'Created on';


--
-- Name: COLUMN stock_request_count.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_request_count.write_date IS 'Last Updated on';


--
-- Name: COLUMN stock_request_count.accounting_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_request_count.accounting_date IS 'Accounting Date';


--
-- Name: stock_request_count_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.stock_request_count_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.stock_request_count_id_seq OWNER TO odoo;

--
-- Name: stock_request_count_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.stock_request_count_id_seq OWNED BY public.stock_request_count.id;


--
-- Name: stock_return_picking; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.stock_return_picking (
    id integer NOT NULL,
    picking_id integer,
    original_location_id integer,
    parent_location_id integer,
    location_id integer,
    create_uid integer,
    write_uid integer,
    move_dest_exists boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.stock_return_picking OWNER TO odoo;

--
-- Name: TABLE stock_return_picking; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.stock_return_picking IS 'Return Picking';


--
-- Name: COLUMN stock_return_picking.picking_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_return_picking.picking_id IS 'Picking';


--
-- Name: COLUMN stock_return_picking.original_location_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_return_picking.original_location_id IS 'Original Location';


--
-- Name: COLUMN stock_return_picking.parent_location_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_return_picking.parent_location_id IS 'Parent Location';


--
-- Name: COLUMN stock_return_picking.location_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_return_picking.location_id IS 'Return Location';


--
-- Name: COLUMN stock_return_picking.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_return_picking.create_uid IS 'Created by';


--
-- Name: COLUMN stock_return_picking.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_return_picking.write_uid IS 'Last Updated by';


--
-- Name: COLUMN stock_return_picking.move_dest_exists; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_return_picking.move_dest_exists IS 'Chained Move Exists';


--
-- Name: COLUMN stock_return_picking.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_return_picking.create_date IS 'Created on';


--
-- Name: COLUMN stock_return_picking.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_return_picking.write_date IS 'Last Updated on';


--
-- Name: stock_return_picking_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.stock_return_picking_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.stock_return_picking_id_seq OWNER TO odoo;

--
-- Name: stock_return_picking_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.stock_return_picking_id_seq OWNED BY public.stock_return_picking.id;


--
-- Name: stock_return_picking_line; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.stock_return_picking_line (
    id integer NOT NULL,
    product_id integer NOT NULL,
    wizard_id integer,
    move_id integer,
    create_uid integer,
    write_uid integer,
    quantity numeric NOT NULL,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    to_refund boolean
);


ALTER TABLE public.stock_return_picking_line OWNER TO odoo;

--
-- Name: TABLE stock_return_picking_line; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.stock_return_picking_line IS 'Return Picking Line';


--
-- Name: COLUMN stock_return_picking_line.product_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_return_picking_line.product_id IS 'Product';


--
-- Name: COLUMN stock_return_picking_line.wizard_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_return_picking_line.wizard_id IS 'Wizard';


--
-- Name: COLUMN stock_return_picking_line.move_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_return_picking_line.move_id IS 'Move';


--
-- Name: COLUMN stock_return_picking_line.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_return_picking_line.create_uid IS 'Created by';


--
-- Name: COLUMN stock_return_picking_line.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_return_picking_line.write_uid IS 'Last Updated by';


--
-- Name: COLUMN stock_return_picking_line.quantity; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_return_picking_line.quantity IS 'Quantity';


--
-- Name: COLUMN stock_return_picking_line.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_return_picking_line.create_date IS 'Created on';


--
-- Name: COLUMN stock_return_picking_line.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_return_picking_line.write_date IS 'Last Updated on';


--
-- Name: COLUMN stock_return_picking_line.to_refund; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_return_picking_line.to_refund IS 'Update quantities on SO/PO';


--
-- Name: stock_return_picking_line_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.stock_return_picking_line_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.stock_return_picking_line_id_seq OWNER TO odoo;

--
-- Name: stock_return_picking_line_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.stock_return_picking_line_id_seq OWNED BY public.stock_return_picking_line.id;


--
-- Name: stock_route; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.stock_route (
    id integer NOT NULL,
    sequence integer,
    supplied_wh_id integer,
    supplier_wh_id integer,
    company_id integer,
    create_uid integer,
    write_uid integer,
    name jsonb NOT NULL,
    active boolean,
    product_selectable boolean,
    product_categ_selectable boolean,
    warehouse_selectable boolean,
    packaging_selectable boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    sale_selectable boolean
);


ALTER TABLE public.stock_route OWNER TO odoo;

--
-- Name: TABLE stock_route; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.stock_route IS 'Inventory Routes';


--
-- Name: COLUMN stock_route.sequence; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_route.sequence IS 'Sequence';


--
-- Name: COLUMN stock_route.supplied_wh_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_route.supplied_wh_id IS 'Supplied Warehouse';


--
-- Name: COLUMN stock_route.supplier_wh_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_route.supplier_wh_id IS 'Supplying Warehouse';


--
-- Name: COLUMN stock_route.company_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_route.company_id IS 'Company';


--
-- Name: COLUMN stock_route.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_route.create_uid IS 'Created by';


--
-- Name: COLUMN stock_route.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_route.write_uid IS 'Last Updated by';


--
-- Name: COLUMN stock_route.name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_route.name IS 'Route';


--
-- Name: COLUMN stock_route.active; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_route.active IS 'Active';


--
-- Name: COLUMN stock_route.product_selectable; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_route.product_selectable IS 'Applicable on Product';


--
-- Name: COLUMN stock_route.product_categ_selectable; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_route.product_categ_selectable IS 'Applicable on Product Category';


--
-- Name: COLUMN stock_route.warehouse_selectable; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_route.warehouse_selectable IS 'Applicable on Warehouse';


--
-- Name: COLUMN stock_route.packaging_selectable; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_route.packaging_selectable IS 'Applicable on Packaging';


--
-- Name: COLUMN stock_route.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_route.create_date IS 'Created on';


--
-- Name: COLUMN stock_route.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_route.write_date IS 'Last Updated on';


--
-- Name: COLUMN stock_route.sale_selectable; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_route.sale_selectable IS 'Selectable on Sales Order Line';


--
-- Name: stock_route_categ; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.stock_route_categ (
    route_id integer NOT NULL,
    categ_id integer NOT NULL
);


ALTER TABLE public.stock_route_categ OWNER TO odoo;

--
-- Name: TABLE stock_route_categ; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.stock_route_categ IS 'RELATION BETWEEN stock_route AND product_category';


--
-- Name: stock_route_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.stock_route_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.stock_route_id_seq OWNER TO odoo;

--
-- Name: stock_route_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.stock_route_id_seq OWNED BY public.stock_route.id;


--
-- Name: stock_route_move; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.stock_route_move (
    move_id integer NOT NULL,
    route_id integer NOT NULL
);


ALTER TABLE public.stock_route_move OWNER TO odoo;

--
-- Name: TABLE stock_route_move; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.stock_route_move IS 'RELATION BETWEEN stock_move AND stock_route';


--
-- Name: stock_route_packaging; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.stock_route_packaging (
    route_id integer NOT NULL,
    packaging_id integer NOT NULL
);


ALTER TABLE public.stock_route_packaging OWNER TO odoo;

--
-- Name: TABLE stock_route_packaging; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.stock_route_packaging IS 'RELATION BETWEEN stock_route AND product_packaging';


--
-- Name: stock_route_product; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.stock_route_product (
    route_id integer NOT NULL,
    product_id integer NOT NULL
);


ALTER TABLE public.stock_route_product OWNER TO odoo;

--
-- Name: TABLE stock_route_product; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.stock_route_product IS 'RELATION BETWEEN stock_route AND product_template';


--
-- Name: stock_route_stock_rules_report_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.stock_route_stock_rules_report_rel (
    stock_rules_report_id integer NOT NULL,
    stock_route_id integer NOT NULL
);


ALTER TABLE public.stock_route_stock_rules_report_rel OWNER TO odoo;

--
-- Name: TABLE stock_route_stock_rules_report_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.stock_route_stock_rules_report_rel IS 'RELATION BETWEEN stock_rules_report AND stock_route';


--
-- Name: stock_route_warehouse; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.stock_route_warehouse (
    route_id integer NOT NULL,
    warehouse_id integer NOT NULL
);


ALTER TABLE public.stock_route_warehouse OWNER TO odoo;

--
-- Name: TABLE stock_route_warehouse; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.stock_route_warehouse IS 'RELATION BETWEEN stock_route AND stock_warehouse';


--
-- Name: stock_rule; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.stock_rule (
    id integer NOT NULL,
    group_id integer,
    sequence integer,
    company_id integer,
    location_dest_id integer NOT NULL,
    location_src_id integer,
    route_id integer NOT NULL,
    route_sequence integer,
    picking_type_id integer NOT NULL,
    delay integer,
    partner_address_id integer,
    warehouse_id integer,
    propagate_warehouse_id integer,
    create_uid integer,
    write_uid integer,
    group_propagation_option character varying,
    action character varying NOT NULL,
    procure_method character varying NOT NULL,
    auto character varying NOT NULL,
    name jsonb NOT NULL,
    active boolean,
    propagate_cancel boolean,
    propagate_carrier boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.stock_rule OWNER TO odoo;

--
-- Name: TABLE stock_rule; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.stock_rule IS 'Stock Rule';


--
-- Name: COLUMN stock_rule.group_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_rule.group_id IS 'Fixed Procurement Group';


--
-- Name: COLUMN stock_rule.sequence; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_rule.sequence IS 'Sequence';


--
-- Name: COLUMN stock_rule.company_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_rule.company_id IS 'Company';


--
-- Name: COLUMN stock_rule.location_dest_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_rule.location_dest_id IS 'Destination Location';


--
-- Name: COLUMN stock_rule.location_src_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_rule.location_src_id IS 'Source Location';


--
-- Name: COLUMN stock_rule.route_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_rule.route_id IS 'Route';


--
-- Name: COLUMN stock_rule.route_sequence; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_rule.route_sequence IS 'Route Sequence';


--
-- Name: COLUMN stock_rule.picking_type_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_rule.picking_type_id IS 'Operation Type';


--
-- Name: COLUMN stock_rule.delay; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_rule.delay IS 'Lead Time';


--
-- Name: COLUMN stock_rule.partner_address_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_rule.partner_address_id IS 'Partner Address';


--
-- Name: COLUMN stock_rule.warehouse_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_rule.warehouse_id IS 'Warehouse';


--
-- Name: COLUMN stock_rule.propagate_warehouse_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_rule.propagate_warehouse_id IS 'Warehouse to Propagate';


--
-- Name: COLUMN stock_rule.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_rule.create_uid IS 'Created by';


--
-- Name: COLUMN stock_rule.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_rule.write_uid IS 'Last Updated by';


--
-- Name: COLUMN stock_rule.group_propagation_option; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_rule.group_propagation_option IS 'Propagation of Procurement Group';


--
-- Name: COLUMN stock_rule.action; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_rule.action IS 'Action';


--
-- Name: COLUMN stock_rule.procure_method; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_rule.procure_method IS 'Supply Method';


--
-- Name: COLUMN stock_rule.auto; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_rule.auto IS 'Automatic Move';


--
-- Name: COLUMN stock_rule.name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_rule.name IS 'Name';


--
-- Name: COLUMN stock_rule.active; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_rule.active IS 'Active';


--
-- Name: COLUMN stock_rule.propagate_cancel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_rule.propagate_cancel IS 'Cancel Next Move';


--
-- Name: COLUMN stock_rule.propagate_carrier; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_rule.propagate_carrier IS 'Propagation of carrier';


--
-- Name: COLUMN stock_rule.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_rule.create_date IS 'Created on';


--
-- Name: COLUMN stock_rule.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_rule.write_date IS 'Last Updated on';


--
-- Name: stock_rule_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.stock_rule_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.stock_rule_id_seq OWNER TO odoo;

--
-- Name: stock_rule_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.stock_rule_id_seq OWNED BY public.stock_rule.id;


--
-- Name: stock_rules_report; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.stock_rules_report (
    id integer NOT NULL,
    product_id integer NOT NULL,
    product_tmpl_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    product_has_variants boolean NOT NULL,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.stock_rules_report OWNER TO odoo;

--
-- Name: TABLE stock_rules_report; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.stock_rules_report IS 'Stock Rules report';


--
-- Name: COLUMN stock_rules_report.product_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_rules_report.product_id IS 'Product';


--
-- Name: COLUMN stock_rules_report.product_tmpl_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_rules_report.product_tmpl_id IS 'Product Template';


--
-- Name: COLUMN stock_rules_report.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_rules_report.create_uid IS 'Created by';


--
-- Name: COLUMN stock_rules_report.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_rules_report.write_uid IS 'Last Updated by';


--
-- Name: COLUMN stock_rules_report.product_has_variants; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_rules_report.product_has_variants IS 'Has variants';


--
-- Name: COLUMN stock_rules_report.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_rules_report.create_date IS 'Created on';


--
-- Name: COLUMN stock_rules_report.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_rules_report.write_date IS 'Last Updated on';


--
-- Name: stock_rules_report_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.stock_rules_report_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.stock_rules_report_id_seq OWNER TO odoo;

--
-- Name: stock_rules_report_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.stock_rules_report_id_seq OWNED BY public.stock_rules_report.id;


--
-- Name: stock_rules_report_stock_warehouse_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.stock_rules_report_stock_warehouse_rel (
    stock_rules_report_id integer NOT NULL,
    stock_warehouse_id integer NOT NULL
);


ALTER TABLE public.stock_rules_report_stock_warehouse_rel OWNER TO odoo;

--
-- Name: TABLE stock_rules_report_stock_warehouse_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.stock_rules_report_stock_warehouse_rel IS 'RELATION BETWEEN stock_rules_report AND stock_warehouse';


--
-- Name: stock_scheduler_compute; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.stock_scheduler_compute (
    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.stock_scheduler_compute OWNER TO odoo;

--
-- Name: TABLE stock_scheduler_compute; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.stock_scheduler_compute IS 'Run Scheduler Manually';


--
-- Name: COLUMN stock_scheduler_compute.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_scheduler_compute.create_uid IS 'Created by';


--
-- Name: COLUMN stock_scheduler_compute.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_scheduler_compute.write_uid IS 'Last Updated by';


--
-- Name: COLUMN stock_scheduler_compute.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_scheduler_compute.create_date IS 'Created on';


--
-- Name: COLUMN stock_scheduler_compute.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_scheduler_compute.write_date IS 'Last Updated on';


--
-- Name: stock_scheduler_compute_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.stock_scheduler_compute_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.stock_scheduler_compute_id_seq OWNER TO odoo;

--
-- Name: stock_scheduler_compute_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.stock_scheduler_compute_id_seq OWNED BY public.stock_scheduler_compute.id;


--
-- Name: stock_scrap; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.stock_scrap (
    id integer NOT NULL,
    message_main_attachment_id integer,
    company_id integer NOT NULL,
    product_id integer NOT NULL,
    product_uom_id integer NOT NULL,
    lot_id integer,
    package_id integer,
    owner_id integer,
    move_id integer,
    picking_id integer,
    location_id integer NOT NULL,
    scrap_location_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    name character varying NOT NULL,
    origin character varying,
    state character varying,
    scrap_qty numeric NOT NULL,
    date_done timestamp without time zone,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.stock_scrap OWNER TO odoo;

--
-- Name: TABLE stock_scrap; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.stock_scrap IS 'Scrap';


--
-- Name: COLUMN stock_scrap.message_main_attachment_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_scrap.message_main_attachment_id IS 'Main Attachment';


--
-- Name: COLUMN stock_scrap.company_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_scrap.company_id IS 'Company';


--
-- Name: COLUMN stock_scrap.product_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_scrap.product_id IS 'Product';


--
-- Name: COLUMN stock_scrap.product_uom_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_scrap.product_uom_id IS 'Unit of Measure';


--
-- Name: COLUMN stock_scrap.lot_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_scrap.lot_id IS 'Lot/Serial';


--
-- Name: COLUMN stock_scrap.package_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_scrap.package_id IS 'Package';


--
-- Name: COLUMN stock_scrap.owner_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_scrap.owner_id IS 'Owner';


--
-- Name: COLUMN stock_scrap.move_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_scrap.move_id IS 'Scrap Move';


--
-- Name: COLUMN stock_scrap.picking_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_scrap.picking_id IS 'Picking';


--
-- Name: COLUMN stock_scrap.location_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_scrap.location_id IS 'Source Location';


--
-- Name: COLUMN stock_scrap.scrap_location_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_scrap.scrap_location_id IS 'Scrap Location';


--
-- Name: COLUMN stock_scrap.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_scrap.create_uid IS 'Created by';


--
-- Name: COLUMN stock_scrap.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_scrap.write_uid IS 'Last Updated by';


--
-- Name: COLUMN stock_scrap.name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_scrap.name IS 'Reference';


--
-- Name: COLUMN stock_scrap.origin; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_scrap.origin IS 'Source Document';


--
-- Name: COLUMN stock_scrap.state; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_scrap.state IS 'Status';


--
-- Name: COLUMN stock_scrap.scrap_qty; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_scrap.scrap_qty IS 'Quantity';


--
-- Name: COLUMN stock_scrap.date_done; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_scrap.date_done IS 'Date';


--
-- Name: COLUMN stock_scrap.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_scrap.create_date IS 'Created on';


--
-- Name: COLUMN stock_scrap.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_scrap.write_date IS 'Last Updated on';


--
-- Name: stock_scrap_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.stock_scrap_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.stock_scrap_id_seq OWNER TO odoo;

--
-- Name: stock_scrap_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.stock_scrap_id_seq OWNED BY public.stock_scrap.id;


--
-- Name: stock_storage_category; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.stock_storage_category (
    id integer NOT NULL,
    company_id integer,
    create_uid integer,
    write_uid integer,
    name character varying NOT NULL,
    allow_new_product character varying NOT NULL,
    max_weight numeric,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    CONSTRAINT stock_storage_category_positive_max_weight CHECK ((max_weight >= (0)::numeric))
);


ALTER TABLE public.stock_storage_category OWNER TO odoo;

--
-- Name: TABLE stock_storage_category; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.stock_storage_category IS 'Storage Category';


--
-- Name: COLUMN stock_storage_category.company_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_storage_category.company_id IS 'Company';


--
-- Name: COLUMN stock_storage_category.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_storage_category.create_uid IS 'Created by';


--
-- Name: COLUMN stock_storage_category.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_storage_category.write_uid IS 'Last Updated by';


--
-- Name: COLUMN stock_storage_category.name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_storage_category.name IS 'Storage Category';


--
-- Name: COLUMN stock_storage_category.allow_new_product; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_storage_category.allow_new_product IS 'Allow New Product';


--
-- Name: COLUMN stock_storage_category.max_weight; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_storage_category.max_weight IS 'Max Weight';


--
-- Name: COLUMN stock_storage_category.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_storage_category.create_date IS 'Created on';


--
-- Name: COLUMN stock_storage_category.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_storage_category.write_date IS 'Last Updated on';


--
-- Name: CONSTRAINT stock_storage_category_positive_max_weight ON stock_storage_category; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT stock_storage_category_positive_max_weight ON public.stock_storage_category IS 'CHECK(max_weight >= 0)';


--
-- Name: stock_storage_category_capacity; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.stock_storage_category_capacity (
    id integer NOT NULL,
    storage_category_id integer NOT NULL,
    product_id integer,
    package_type_id integer,
    create_uid integer,
    write_uid integer,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    quantity double precision NOT NULL,
    CONSTRAINT stock_storage_category_capacity_positive_quantity CHECK ((quantity > (0)::double precision))
);


ALTER TABLE public.stock_storage_category_capacity OWNER TO odoo;

--
-- Name: TABLE stock_storage_category_capacity; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.stock_storage_category_capacity IS 'Storage Category Capacity';


--
-- Name: COLUMN stock_storage_category_capacity.storage_category_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_storage_category_capacity.storage_category_id IS 'Storage Category';


--
-- Name: COLUMN stock_storage_category_capacity.product_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_storage_category_capacity.product_id IS 'Product';


--
-- Name: COLUMN stock_storage_category_capacity.package_type_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_storage_category_capacity.package_type_id IS 'Package Type';


--
-- Name: COLUMN stock_storage_category_capacity.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_storage_category_capacity.create_uid IS 'Created by';


--
-- Name: COLUMN stock_storage_category_capacity.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_storage_category_capacity.write_uid IS 'Last Updated by';


--
-- Name: COLUMN stock_storage_category_capacity.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_storage_category_capacity.create_date IS 'Created on';


--
-- Name: COLUMN stock_storage_category_capacity.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_storage_category_capacity.write_date IS 'Last Updated on';


--
-- Name: COLUMN stock_storage_category_capacity.quantity; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_storage_category_capacity.quantity IS 'Quantity';


--
-- Name: CONSTRAINT stock_storage_category_capacity_positive_quantity ON stock_storage_category_capacity; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT stock_storage_category_capacity_positive_quantity ON public.stock_storage_category_capacity IS 'CHECK(quantity > 0)';


--
-- Name: stock_storage_category_capacity_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.stock_storage_category_capacity_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.stock_storage_category_capacity_id_seq OWNER TO odoo;

--
-- Name: stock_storage_category_capacity_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.stock_storage_category_capacity_id_seq OWNED BY public.stock_storage_category_capacity.id;


--
-- Name: stock_storage_category_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.stock_storage_category_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.stock_storage_category_id_seq OWNER TO odoo;

--
-- Name: stock_storage_category_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.stock_storage_category_id_seq OWNED BY public.stock_storage_category.id;


--
-- Name: stock_traceability_report; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.stock_traceability_report (
    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.stock_traceability_report OWNER TO odoo;

--
-- Name: TABLE stock_traceability_report; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.stock_traceability_report IS 'Traceability Report';


--
-- Name: COLUMN stock_traceability_report.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_traceability_report.create_uid IS 'Created by';


--
-- Name: COLUMN stock_traceability_report.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_traceability_report.write_uid IS 'Last Updated by';


--
-- Name: COLUMN stock_traceability_report.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_traceability_report.create_date IS 'Created on';


--
-- Name: COLUMN stock_traceability_report.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_traceability_report.write_date IS 'Last Updated on';


--
-- Name: stock_traceability_report_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.stock_traceability_report_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.stock_traceability_report_id_seq OWNER TO odoo;

--
-- Name: stock_traceability_report_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.stock_traceability_report_id_seq OWNED BY public.stock_traceability_report.id;


--
-- Name: stock_track_confirmation; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.stock_track_confirmation (
    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.stock_track_confirmation OWNER TO odoo;

--
-- Name: TABLE stock_track_confirmation; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.stock_track_confirmation IS 'Stock Track Confirmation';


--
-- Name: COLUMN stock_track_confirmation.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_track_confirmation.create_uid IS 'Created by';


--
-- Name: COLUMN stock_track_confirmation.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_track_confirmation.write_uid IS 'Last Updated by';


--
-- Name: COLUMN stock_track_confirmation.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_track_confirmation.create_date IS 'Created on';


--
-- Name: COLUMN stock_track_confirmation.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_track_confirmation.write_date IS 'Last Updated on';


--
-- Name: stock_track_confirmation_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.stock_track_confirmation_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.stock_track_confirmation_id_seq OWNER TO odoo;

--
-- Name: stock_track_confirmation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.stock_track_confirmation_id_seq OWNED BY public.stock_track_confirmation.id;


--
-- Name: stock_track_line; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.stock_track_line (
    id integer NOT NULL,
    product_id integer,
    wizard_id integer,
    create_uid integer,
    write_uid integer,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.stock_track_line OWNER TO odoo;

--
-- Name: TABLE stock_track_line; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.stock_track_line IS 'Stock Track Line';


--
-- Name: COLUMN stock_track_line.product_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_track_line.product_id IS 'Product';


--
-- Name: COLUMN stock_track_line.wizard_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_track_line.wizard_id IS 'Wizard';


--
-- Name: COLUMN stock_track_line.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_track_line.create_uid IS 'Created by';


--
-- Name: COLUMN stock_track_line.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_track_line.write_uid IS 'Last Updated by';


--
-- Name: COLUMN stock_track_line.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_track_line.create_date IS 'Created on';


--
-- Name: COLUMN stock_track_line.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_track_line.write_date IS 'Last Updated on';


--
-- Name: stock_track_line_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.stock_track_line_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.stock_track_line_id_seq OWNER TO odoo;

--
-- Name: stock_track_line_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.stock_track_line_id_seq OWNED BY public.stock_track_line.id;


--
-- Name: stock_valuation_layer; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.stock_valuation_layer (
    id integer NOT NULL,
    company_id integer NOT NULL,
    product_id integer NOT NULL,
    stock_valuation_layer_id integer,
    stock_move_id integer,
    account_move_id integer,
    account_move_line_id integer,
    create_uid integer,
    write_uid integer,
    description character varying,
    quantity numeric,
    unit_cost numeric,
    value numeric,
    remaining_qty numeric,
    remaining_value numeric,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    price_diff_value double precision
);


ALTER TABLE public.stock_valuation_layer OWNER TO odoo;

--
-- Name: TABLE stock_valuation_layer; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.stock_valuation_layer IS 'Stock Valuation Layer';


--
-- Name: COLUMN stock_valuation_layer.company_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_valuation_layer.company_id IS 'Company';


--
-- Name: COLUMN stock_valuation_layer.product_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_valuation_layer.product_id IS 'Product';


--
-- Name: COLUMN stock_valuation_layer.stock_valuation_layer_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_valuation_layer.stock_valuation_layer_id IS 'Linked To';


--
-- Name: COLUMN stock_valuation_layer.stock_move_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_valuation_layer.stock_move_id IS 'Stock Move';


--
-- Name: COLUMN stock_valuation_layer.account_move_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_valuation_layer.account_move_id IS 'Journal Entry';


--
-- Name: COLUMN stock_valuation_layer.account_move_line_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_valuation_layer.account_move_line_id IS 'Invoice Line';


--
-- Name: COLUMN stock_valuation_layer.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_valuation_layer.create_uid IS 'Created by';


--
-- Name: COLUMN stock_valuation_layer.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_valuation_layer.write_uid IS 'Last Updated by';


--
-- Name: COLUMN stock_valuation_layer.description; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_valuation_layer.description IS 'Description';


--
-- Name: COLUMN stock_valuation_layer.quantity; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_valuation_layer.quantity IS 'Quantity';


--
-- Name: COLUMN stock_valuation_layer.unit_cost; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_valuation_layer.unit_cost IS 'Unit Value';


--
-- Name: COLUMN stock_valuation_layer.value; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_valuation_layer.value IS 'Total Value';


--
-- Name: COLUMN stock_valuation_layer.remaining_qty; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_valuation_layer.remaining_qty IS 'Remaining Qty';


--
-- Name: COLUMN stock_valuation_layer.remaining_value; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_valuation_layer.remaining_value IS 'Remaining Value';


--
-- Name: COLUMN stock_valuation_layer.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_valuation_layer.create_date IS 'Created on';


--
-- Name: COLUMN stock_valuation_layer.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_valuation_layer.write_date IS 'Last Updated on';


--
-- Name: COLUMN stock_valuation_layer.price_diff_value; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_valuation_layer.price_diff_value IS 'Invoice value correction with invoice currency';


--
-- Name: stock_valuation_layer_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.stock_valuation_layer_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.stock_valuation_layer_id_seq OWNER TO odoo;

--
-- Name: stock_valuation_layer_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.stock_valuation_layer_id_seq OWNED BY public.stock_valuation_layer.id;


--
-- Name: stock_valuation_layer_revaluation; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.stock_valuation_layer_revaluation (
    id integer NOT NULL,
    company_id integer NOT NULL,
    product_id integer NOT NULL,
    account_journal_id integer,
    account_id integer,
    create_uid integer,
    write_uid integer,
    reason character varying,
    date date,
    added_value numeric NOT NULL,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.stock_valuation_layer_revaluation OWNER TO odoo;

--
-- Name: TABLE stock_valuation_layer_revaluation; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.stock_valuation_layer_revaluation IS 'Wizard model to reavaluate a stock inventory for a product';


--
-- Name: COLUMN stock_valuation_layer_revaluation.company_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_valuation_layer_revaluation.company_id IS 'Company';


--
-- Name: COLUMN stock_valuation_layer_revaluation.product_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_valuation_layer_revaluation.product_id IS 'Related product';


--
-- Name: COLUMN stock_valuation_layer_revaluation.account_journal_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_valuation_layer_revaluation.account_journal_id IS 'Journal';


--
-- Name: COLUMN stock_valuation_layer_revaluation.account_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_valuation_layer_revaluation.account_id IS 'Counterpart Account';


--
-- Name: COLUMN stock_valuation_layer_revaluation.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_valuation_layer_revaluation.create_uid IS 'Created by';


--
-- Name: COLUMN stock_valuation_layer_revaluation.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_valuation_layer_revaluation.write_uid IS 'Last Updated by';


--
-- Name: COLUMN stock_valuation_layer_revaluation.reason; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_valuation_layer_revaluation.reason IS 'Reason';


--
-- Name: COLUMN stock_valuation_layer_revaluation.date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_valuation_layer_revaluation.date IS 'Accounting Date';


--
-- Name: COLUMN stock_valuation_layer_revaluation.added_value; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_valuation_layer_revaluation.added_value IS 'Added value';


--
-- Name: COLUMN stock_valuation_layer_revaluation.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_valuation_layer_revaluation.create_date IS 'Created on';


--
-- Name: COLUMN stock_valuation_layer_revaluation.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_valuation_layer_revaluation.write_date IS 'Last Updated on';


--
-- Name: stock_valuation_layer_revaluation_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.stock_valuation_layer_revaluation_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.stock_valuation_layer_revaluation_id_seq OWNER TO odoo;

--
-- Name: stock_valuation_layer_revaluation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.stock_valuation_layer_revaluation_id_seq OWNED BY public.stock_valuation_layer_revaluation.id;


--
-- Name: stock_warehouse_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.stock_warehouse_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.stock_warehouse_id_seq OWNER TO odoo;

--
-- Name: stock_warehouse_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.stock_warehouse_id_seq OWNED BY public.stock_warehouse.id;


--
-- Name: stock_warehouse_orderpoint; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.stock_warehouse_orderpoint (
    id integer NOT NULL,
    warehouse_id integer NOT NULL,
    location_id integer NOT NULL,
    product_id integer NOT NULL,
    product_category_id integer,
    group_id integer,
    company_id integer NOT NULL,
    route_id integer,
    create_uid integer,
    write_uid integer,
    name character varying NOT NULL,
    trigger character varying NOT NULL,
    snoozed_until date,
    product_min_qty numeric NOT NULL,
    product_max_qty numeric NOT NULL,
    qty_multiple numeric NOT NULL,
    qty_to_order numeric,
    active boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    supplier_id integer,
    vendor_id integer,
    purchase_visibility_days double precision,
    CONSTRAINT stock_warehouse_orderpoint_qty_multiple_check CHECK ((qty_multiple >= (0)::numeric))
);


ALTER TABLE public.stock_warehouse_orderpoint OWNER TO odoo;

--
-- Name: TABLE stock_warehouse_orderpoint; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.stock_warehouse_orderpoint IS 'Minimum Inventory Rule';


--
-- Name: COLUMN stock_warehouse_orderpoint.warehouse_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse_orderpoint.warehouse_id IS 'Warehouse';


--
-- Name: COLUMN stock_warehouse_orderpoint.location_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse_orderpoint.location_id IS 'Location';


--
-- Name: COLUMN stock_warehouse_orderpoint.product_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse_orderpoint.product_id IS 'Product';


--
-- Name: COLUMN stock_warehouse_orderpoint.product_category_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse_orderpoint.product_category_id IS 'Product Category';


--
-- Name: COLUMN stock_warehouse_orderpoint.group_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse_orderpoint.group_id IS 'Procurement Group';


--
-- Name: COLUMN stock_warehouse_orderpoint.company_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse_orderpoint.company_id IS 'Company';


--
-- Name: COLUMN stock_warehouse_orderpoint.route_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse_orderpoint.route_id IS 'Preferred Route';


--
-- Name: COLUMN stock_warehouse_orderpoint.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse_orderpoint.create_uid IS 'Created by';


--
-- Name: COLUMN stock_warehouse_orderpoint.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse_orderpoint.write_uid IS 'Last Updated by';


--
-- Name: COLUMN stock_warehouse_orderpoint.name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse_orderpoint.name IS 'Name';


--
-- Name: COLUMN stock_warehouse_orderpoint.trigger; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse_orderpoint.trigger IS 'Trigger';


--
-- Name: COLUMN stock_warehouse_orderpoint.snoozed_until; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse_orderpoint.snoozed_until IS 'Snoozed';


--
-- Name: COLUMN stock_warehouse_orderpoint.product_min_qty; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse_orderpoint.product_min_qty IS 'Min Quantity';


--
-- Name: COLUMN stock_warehouse_orderpoint.product_max_qty; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse_orderpoint.product_max_qty IS 'Max Quantity';


--
-- Name: COLUMN stock_warehouse_orderpoint.qty_multiple; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse_orderpoint.qty_multiple IS 'Multiple Quantity';


--
-- Name: COLUMN stock_warehouse_orderpoint.qty_to_order; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse_orderpoint.qty_to_order IS 'To Order';


--
-- Name: COLUMN stock_warehouse_orderpoint.active; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse_orderpoint.active IS 'Active';


--
-- Name: COLUMN stock_warehouse_orderpoint.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse_orderpoint.create_date IS 'Created on';


--
-- Name: COLUMN stock_warehouse_orderpoint.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse_orderpoint.write_date IS 'Last Updated on';


--
-- Name: COLUMN stock_warehouse_orderpoint.supplier_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse_orderpoint.supplier_id IS 'Product Supplier';


--
-- Name: COLUMN stock_warehouse_orderpoint.vendor_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse_orderpoint.vendor_id IS 'Vendor';


--
-- Name: COLUMN stock_warehouse_orderpoint.purchase_visibility_days; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse_orderpoint.purchase_visibility_days IS 'Purchase Visibility Days';


--
-- Name: CONSTRAINT stock_warehouse_orderpoint_qty_multiple_check ON stock_warehouse_orderpoint; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT stock_warehouse_orderpoint_qty_multiple_check ON public.stock_warehouse_orderpoint IS 'CHECK( qty_multiple >= 0 )';


--
-- Name: stock_warehouse_orderpoint_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.stock_warehouse_orderpoint_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.stock_warehouse_orderpoint_id_seq OWNER TO odoo;

--
-- Name: stock_warehouse_orderpoint_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.stock_warehouse_orderpoint_id_seq OWNED BY public.stock_warehouse_orderpoint.id;


--
-- Name: stock_warn_insufficient_qty_scrap; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.stock_warn_insufficient_qty_scrap (
    id integer NOT NULL,
    product_id integer NOT NULL,
    location_id integer NOT NULL,
    scrap_id integer,
    create_uid integer,
    write_uid integer,
    product_uom_name character varying NOT NULL,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    quantity double precision NOT NULL
);


ALTER TABLE public.stock_warn_insufficient_qty_scrap OWNER TO odoo;

--
-- Name: TABLE stock_warn_insufficient_qty_scrap; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.stock_warn_insufficient_qty_scrap IS 'Warn Insufficient Scrap Quantity';


--
-- Name: COLUMN stock_warn_insufficient_qty_scrap.product_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warn_insufficient_qty_scrap.product_id IS 'Product';


--
-- Name: COLUMN stock_warn_insufficient_qty_scrap.location_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warn_insufficient_qty_scrap.location_id IS 'Location';


--
-- Name: COLUMN stock_warn_insufficient_qty_scrap.scrap_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warn_insufficient_qty_scrap.scrap_id IS 'Scrap';


--
-- Name: COLUMN stock_warn_insufficient_qty_scrap.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warn_insufficient_qty_scrap.create_uid IS 'Created by';


--
-- Name: COLUMN stock_warn_insufficient_qty_scrap.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warn_insufficient_qty_scrap.write_uid IS 'Last Updated by';


--
-- Name: COLUMN stock_warn_insufficient_qty_scrap.product_uom_name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warn_insufficient_qty_scrap.product_uom_name IS 'Unit of Measure';


--
-- Name: COLUMN stock_warn_insufficient_qty_scrap.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warn_insufficient_qty_scrap.create_date IS 'Created on';


--
-- Name: COLUMN stock_warn_insufficient_qty_scrap.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warn_insufficient_qty_scrap.write_date IS 'Last Updated on';


--
-- Name: COLUMN stock_warn_insufficient_qty_scrap.quantity; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warn_insufficient_qty_scrap.quantity IS 'Quantity';


--
-- Name: stock_warn_insufficient_qty_scrap_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.stock_warn_insufficient_qty_scrap_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.stock_warn_insufficient_qty_scrap_id_seq OWNER TO odoo;

--
-- Name: stock_warn_insufficient_qty_scrap_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.stock_warn_insufficient_qty_scrap_id_seq OWNED BY public.stock_warn_insufficient_qty_scrap.id;


--
-- Name: stock_wh_resupply_table; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.stock_wh_resupply_table (
    supplied_wh_id integer NOT NULL,
    supplier_wh_id integer NOT NULL
);


ALTER TABLE public.stock_wh_resupply_table OWNER TO odoo;

--
-- Name: TABLE stock_wh_resupply_table; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.stock_wh_resupply_table IS 'RELATION BETWEEN stock_warehouse AND stock_warehouse';


--
-- Name: survey_invite; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.survey_invite (
    id integer NOT NULL,
    template_id integer,
    author_id integer,
    mail_server_id integer,
    survey_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    lang character varying,
    subject character varying,
    email_from character varying,
    existing_mode character varying NOT NULL,
    body text,
    emails text,
    deadline timestamp without time zone,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.survey_invite OWNER TO odoo;

--
-- Name: TABLE survey_invite; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.survey_invite IS 'Survey Invitation Wizard';


--
-- Name: COLUMN survey_invite.template_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_invite.template_id IS 'Mail Template';


--
-- Name: COLUMN survey_invite.author_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_invite.author_id IS 'Author';


--
-- Name: COLUMN survey_invite.mail_server_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_invite.mail_server_id IS 'Outgoing mail server';


--
-- Name: COLUMN survey_invite.survey_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_invite.survey_id IS 'Survey';


--
-- Name: COLUMN survey_invite.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_invite.create_uid IS 'Created by';


--
-- Name: COLUMN survey_invite.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_invite.write_uid IS 'Last Updated by';


--
-- Name: COLUMN survey_invite.lang; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_invite.lang IS 'Language';


--
-- Name: COLUMN survey_invite.subject; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_invite.subject IS 'Subject';


--
-- Name: COLUMN survey_invite.email_from; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_invite.email_from IS 'From';


--
-- Name: COLUMN survey_invite.existing_mode; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_invite.existing_mode IS 'Handle existing';


--
-- Name: COLUMN survey_invite.body; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_invite.body IS 'Contents';


--
-- Name: COLUMN survey_invite.emails; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_invite.emails IS 'Additional emails';


--
-- Name: COLUMN survey_invite.deadline; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_invite.deadline IS 'Answer deadline';


--
-- Name: COLUMN survey_invite.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_invite.create_date IS 'Created on';


--
-- Name: COLUMN survey_invite.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_invite.write_date IS 'Last Updated on';


--
-- Name: survey_invite_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.survey_invite_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.survey_invite_id_seq OWNER TO odoo;

--
-- Name: survey_invite_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.survey_invite_id_seq OWNED BY public.survey_invite.id;


--
-- Name: survey_invite_partner_ids; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.survey_invite_partner_ids (
    invite_id integer NOT NULL,
    partner_id integer NOT NULL
);


ALTER TABLE public.survey_invite_partner_ids OWNER TO odoo;

--
-- Name: TABLE survey_invite_partner_ids; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.survey_invite_partner_ids IS 'RELATION BETWEEN survey_invite AND res_partner';


--
-- Name: survey_mail_compose_message_ir_attachments_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.survey_mail_compose_message_ir_attachments_rel (
    wizard_id integer NOT NULL,
    attachment_id integer NOT NULL
);


ALTER TABLE public.survey_mail_compose_message_ir_attachments_rel OWNER TO odoo;

--
-- Name: TABLE survey_mail_compose_message_ir_attachments_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.survey_mail_compose_message_ir_attachments_rel IS 'RELATION BETWEEN survey_invite AND ir_attachment';


--
-- Name: survey_question; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.survey_question (
    id integer NOT NULL,
    survey_id integer,
    sequence integer,
    random_questions_count integer,
    page_id integer,
    time_limit integer,
    validation_length_min integer,
    validation_length_max integer,
    triggering_question_id integer,
    triggering_answer_id integer,
    create_uid integer,
    write_uid integer,
    question_type character varying,
    matrix_subtype character varying,
    answer_date date,
    validation_min_date date,
    validation_max_date date,
    title jsonb NOT NULL,
    description jsonb,
    question_placeholder jsonb,
    comments_message jsonb,
    validation_error_msg jsonb,
    constr_error_msg jsonb,
    is_page boolean,
    is_scored_question boolean,
    save_as_email boolean,
    save_as_nickname boolean,
    is_time_limited boolean,
    comments_allowed boolean,
    comment_count_as_answer boolean,
    validation_required boolean,
    validation_email boolean,
    constr_mandatory boolean,
    is_conditional boolean,
    answer_datetime timestamp without time zone,
    validation_min_datetime timestamp without time zone,
    validation_max_datetime timestamp without time zone,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    answer_numerical_box double precision,
    answer_score double precision,
    validation_min_float_value double precision,
    validation_max_float_value double precision,
    CONSTRAINT survey_question_positive_answer_score CHECK ((answer_score >= (0)::double precision)),
    CONSTRAINT survey_question_positive_len_max CHECK ((validation_length_max >= 0)),
    CONSTRAINT survey_question_positive_len_min CHECK ((validation_length_min >= 0)),
    CONSTRAINT survey_question_scored_date_have_answers CHECK (((is_scored_question <> true) OR ((question_type)::text <> 'date'::text) OR (answer_date IS NOT NULL))),
    CONSTRAINT survey_question_scored_datetime_have_answers CHECK (((is_scored_question <> true) OR ((question_type)::text <> 'datetime'::text) OR (answer_datetime IS NOT NULL))),
    CONSTRAINT survey_question_validation_date CHECK ((validation_min_date <= validation_max_date)),
    CONSTRAINT survey_question_validation_datetime CHECK ((validation_min_datetime <= validation_max_datetime)),
    CONSTRAINT survey_question_validation_float CHECK ((validation_min_float_value <= validation_max_float_value)),
    CONSTRAINT survey_question_validation_length CHECK ((validation_length_min <= validation_length_max))
);


ALTER TABLE public.survey_question OWNER TO odoo;

--
-- Name: TABLE survey_question; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.survey_question IS 'Survey Question';


--
-- Name: COLUMN survey_question.survey_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_question.survey_id IS 'Survey';


--
-- Name: COLUMN survey_question.sequence; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_question.sequence IS 'Sequence';


--
-- Name: COLUMN survey_question.random_questions_count; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_question.random_questions_count IS '# Questions Randomly Picked';


--
-- Name: COLUMN survey_question.page_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_question.page_id IS 'Page';


--
-- Name: COLUMN survey_question.time_limit; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_question.time_limit IS 'Time limit (seconds)';


--
-- Name: COLUMN survey_question.validation_length_min; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_question.validation_length_min IS 'Minimum Text Length';


--
-- Name: COLUMN survey_question.validation_length_max; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_question.validation_length_max IS 'Maximum Text Length';


--
-- Name: COLUMN survey_question.triggering_question_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_question.triggering_question_id IS 'Triggering Question';


--
-- Name: COLUMN survey_question.triggering_answer_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_question.triggering_answer_id IS 'Triggering Answer';


--
-- Name: COLUMN survey_question.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_question.create_uid IS 'Created by';


--
-- Name: COLUMN survey_question.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_question.write_uid IS 'Last Updated by';


--
-- Name: COLUMN survey_question.question_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_question.question_type IS 'Question Type';


--
-- Name: COLUMN survey_question.matrix_subtype; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_question.matrix_subtype IS 'Matrix Type';


--
-- Name: COLUMN survey_question.answer_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_question.answer_date IS 'Correct date answer';


--
-- Name: COLUMN survey_question.validation_min_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_question.validation_min_date IS 'Minimum Date';


--
-- Name: COLUMN survey_question.validation_max_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_question.validation_max_date IS 'Maximum Date';


--
-- Name: COLUMN survey_question.title; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_question.title IS 'Title';


--
-- Name: COLUMN survey_question.description; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_question.description IS 'Description';


--
-- Name: COLUMN survey_question.question_placeholder; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_question.question_placeholder IS 'Placeholder';


--
-- Name: COLUMN survey_question.comments_message; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_question.comments_message IS 'Comment Message';


--
-- Name: COLUMN survey_question.validation_error_msg; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_question.validation_error_msg IS 'Validation Error message';


--
-- Name: COLUMN survey_question.constr_error_msg; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_question.constr_error_msg IS 'Error message';


--
-- Name: COLUMN survey_question.is_page; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_question.is_page IS 'Is a page?';


--
-- Name: COLUMN survey_question.is_scored_question; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_question.is_scored_question IS 'Scored';


--
-- Name: COLUMN survey_question.save_as_email; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_question.save_as_email IS 'Save as user email';


--
-- Name: COLUMN survey_question.save_as_nickname; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_question.save_as_nickname IS 'Save as user nickname';


--
-- Name: COLUMN survey_question.is_time_limited; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_question.is_time_limited IS 'The question is limited in time';


--
-- Name: COLUMN survey_question.comments_allowed; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_question.comments_allowed IS 'Show Comments Field';


--
-- Name: COLUMN survey_question.comment_count_as_answer; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_question.comment_count_as_answer IS 'Comment is an answer';


--
-- Name: COLUMN survey_question.validation_required; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_question.validation_required IS 'Validate entry';


--
-- Name: COLUMN survey_question.validation_email; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_question.validation_email IS 'Input must be an email';


--
-- Name: COLUMN survey_question.constr_mandatory; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_question.constr_mandatory IS 'Mandatory Answer';


--
-- Name: COLUMN survey_question.is_conditional; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_question.is_conditional IS 'Conditional Display';


--
-- Name: COLUMN survey_question.answer_datetime; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_question.answer_datetime IS 'Correct datetime answer';


--
-- Name: COLUMN survey_question.validation_min_datetime; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_question.validation_min_datetime IS 'Minimum Datetime';


--
-- Name: COLUMN survey_question.validation_max_datetime; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_question.validation_max_datetime IS 'Maximum Datetime';


--
-- Name: COLUMN survey_question.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_question.create_date IS 'Created on';


--
-- Name: COLUMN survey_question.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_question.write_date IS 'Last Updated on';


--
-- Name: COLUMN survey_question.answer_numerical_box; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_question.answer_numerical_box IS 'Correct numerical answer';


--
-- Name: COLUMN survey_question.answer_score; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_question.answer_score IS 'Score';


--
-- Name: COLUMN survey_question.validation_min_float_value; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_question.validation_min_float_value IS 'Minimum value';


--
-- Name: COLUMN survey_question.validation_max_float_value; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_question.validation_max_float_value IS 'Maximum value';


--
-- Name: CONSTRAINT survey_question_positive_answer_score ON survey_question; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT survey_question_positive_answer_score ON public.survey_question IS 'CHECK (answer_score >= 0)';


--
-- Name: CONSTRAINT survey_question_positive_len_max ON survey_question; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT survey_question_positive_len_max ON public.survey_question IS 'CHECK (validation_length_max >= 0)';


--
-- Name: CONSTRAINT survey_question_positive_len_min ON survey_question; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT survey_question_positive_len_min ON public.survey_question IS 'CHECK (validation_length_min >= 0)';


--
-- Name: CONSTRAINT survey_question_scored_date_have_answers ON survey_question; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT survey_question_scored_date_have_answers ON public.survey_question IS 'CHECK (is_scored_question != True OR question_type != ''date'' OR answer_date is not null)';


--
-- Name: CONSTRAINT survey_question_scored_datetime_have_answers ON survey_question; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT survey_question_scored_datetime_have_answers ON public.survey_question IS 'CHECK (is_scored_question != True OR question_type != ''datetime'' OR answer_datetime is not null)';


--
-- Name: CONSTRAINT survey_question_validation_date ON survey_question; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT survey_question_validation_date ON public.survey_question IS 'CHECK (validation_min_date <= validation_max_date)';


--
-- Name: CONSTRAINT survey_question_validation_datetime ON survey_question; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT survey_question_validation_datetime ON public.survey_question IS 'CHECK (validation_min_datetime <= validation_max_datetime)';


--
-- Name: CONSTRAINT survey_question_validation_float ON survey_question; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT survey_question_validation_float ON public.survey_question IS 'CHECK (validation_min_float_value <= validation_max_float_value)';


--
-- Name: CONSTRAINT survey_question_validation_length ON survey_question; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT survey_question_validation_length ON public.survey_question IS 'CHECK (validation_length_min <= validation_length_max)';


--
-- Name: survey_question_answer; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.survey_question_answer (
    id integer NOT NULL,
    question_id integer,
    matrix_question_id integer,
    sequence integer,
    create_uid integer,
    write_uid integer,
    value_image_filename character varying,
    value jsonb NOT NULL,
    is_correct boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    answer_score double precision
);


ALTER TABLE public.survey_question_answer OWNER TO odoo;

--
-- Name: TABLE survey_question_answer; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.survey_question_answer IS 'Survey Label';


--
-- Name: COLUMN survey_question_answer.question_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_question_answer.question_id IS 'Question';


--
-- Name: COLUMN survey_question_answer.matrix_question_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_question_answer.matrix_question_id IS 'Question (as matrix row)';


--
-- Name: COLUMN survey_question_answer.sequence; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.survey_question_answer.sequence IS 'Label Sequence order';


--
