-- 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 SEQUENCE 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,
    currency_id integer,
    company_id integer,
    create_uid integer,
    write_uid integer,
    advance_payment_method character varying NOT NULL,
    fixed_amount numeric,
    deduct_down_payments boolean,
    consolidated_billing boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    amount double precision,
    date_start_invoice_timesheet date,
    date_end_invoice_timesheet date,
    invoicing_timesheet_enabled boolean
);


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

COMMENT ON COLUMN public.sale_advance_payment_inv.consolidated_billing IS 'Consolidated Billing';


--
-- 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';


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

COMMENT ON COLUMN public.sale_advance_payment_inv.date_start_invoice_timesheet IS 'Start Date';


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

COMMENT ON COLUMN public.sale_advance_payment_inv.date_end_invoice_timesheet IS 'End Date';


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

COMMENT ON COLUMN public.sale_advance_payment_inv.invoicing_timesheet_enabled IS 'Invoicing Timesheet Enabled';


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

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

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

COMMENT ON TABLE public.sale_mass_cancel_orders IS 'Cancel multiple quotations';


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

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


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

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


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

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


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

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


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

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


ALTER SEQUENCE public.sale_mass_cancel_orders_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.sale_mass_cancel_orders_id_seq OWNED BY public.sale_mass_cancel_orders.id;


--
-- 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,
    company_id integer NOT NULL,
    partner_id integer NOT NULL,
    journal_id integer,
    partner_invoice_id integer NOT NULL,
    partner_shipping_id integer NOT NULL,
    fiscal_position_id integer,
    payment_term_id integer,
    pricelist_id integer,
    currency_id integer,
    user_id integer,
    team_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,
    locked boolean,
    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,
    prepayment_percent double precision,
    pending_email_template_id integer,
    sale_order_template_id integer,
    customizable_pdf_form_fields jsonb,
    project_id integer,
    incoterm integer,
    warehouse_id integer,
    procurement_group_id integer,
    incoterm_location character varying,
    picking_policy character varying NOT NULL,
    delivery_status character varying,
    effective_date timestamp without time zone,
    x_ot character varying,
    x_planta character varying,
    x_albaran character varying,
    x_marca character varying,
    x_n_serie character varying,
    x_contacto_nombre character varying,
    x_contacto_email character varying,
    x_estado_importado character varying,
    repair_order_id integer,
    CONSTRAINT sale_order_date_order_conditional_required CHECK (((((state)::text = 'sale'::text) AND (date_order IS NOT NULL)) OR ((state)::text <> 'sale'::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.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.journal_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order.journal_id IS 'Invoicing Journal';


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

COMMENT ON COLUMN public.sale_order.locked IS 'Locked';


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

COMMENT ON COLUMN public.sale_order.prepayment_percent IS 'Prepayment percentage';


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

COMMENT ON COLUMN public.sale_order.pending_email_template_id IS 'Pending Email Template';


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

COMMENT ON COLUMN public.sale_order.customizable_pdf_form_fields IS 'Customizable PDF Form Fields';


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

COMMENT ON COLUMN public.sale_order.x_ot IS 'OT';


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

COMMENT ON COLUMN public.sale_order.x_planta IS 'Planta';


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

COMMENT ON COLUMN public.sale_order.x_albaran IS 'Albarán';


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

COMMENT ON COLUMN public.sale_order.x_marca IS 'Marca';


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

COMMENT ON COLUMN public.sale_order.x_n_serie IS 'Nº Serie';


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

COMMENT ON COLUMN public.sale_order.x_contacto_nombre IS 'Nombre Contacto';


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

COMMENT ON COLUMN public.sale_order.x_contacto_email IS 'Email Contacto';


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

COMMENT ON COLUMN public.sale_order.x_estado_importado IS 'Estado Importado';


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

COMMENT ON COLUMN public.sale_order.repair_order_id IS 'Orden de Trabajo';


--
-- 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 = ''sale'' AND date_order IS NOT NULL) OR state != ''sale'')';


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

CREATE TABLE public.sale_order_discount (
    id integer NOT NULL,
    sale_order_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    discount_type character varying,
    discount_amount numeric,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    discount_percentage double precision
);


ALTER TABLE public.sale_order_discount OWNER TO odoo;

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

COMMENT ON TABLE public.sale_order_discount IS 'Discount Wizard';


--
-- Name: COLUMN sale_order_discount.sale_order_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_discount.sale_order_id IS 'Sale Order';


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

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


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

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


--
-- Name: COLUMN sale_order_discount.discount_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_discount.discount_type IS 'Discount Type';


--
-- Name: COLUMN sale_order_discount.discount_amount; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_discount.discount_amount IS 'Amount';


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

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


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

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


--
-- Name: COLUMN sale_order_discount.discount_percentage; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_discount.discount_percentage IS 'Percentage';


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

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


ALTER SEQUENCE public.sale_order_discount_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.sale_order_discount_id_seq OWNED BY public.sale_order_discount.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 SEQUENCE 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,
    linked_line_id integer,
    combo_item_id integer,
    product_packaging_id integer,
    create_uid integer,
    write_uid integer,
    state character varying,
    display_type character varying,
    virtual_id character varying,
    linked_virtual_id 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_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,
    technical_price_unit double precision,
    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,
    warehouse_id integer,
    has_displayed_warning_upsell boolean,
    remaining_hours double precision,
    CONSTRAINT sale_order_line_accountable_required_fields CHECK (((display_type IS NOT NULL) OR is_downpayment 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.linked_line_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.linked_line_id IS 'Linked Order Line';


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

COMMENT ON COLUMN public.sale_order_line.combo_item_id IS 'Combo Item';


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

COMMENT ON COLUMN public.sale_order_line.virtual_id IS 'Virtual';


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

COMMENT ON COLUMN public.sale_order_line.linked_virtual_id IS 'Linked Virtual';


--
-- 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 Distribution';


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

COMMENT ON COLUMN public.sale_order_line.technical_price_unit IS 'Technical Price Unit';


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

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


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

COMMENT ON COLUMN public.sale_order_line.has_displayed_warning_upsell IS 'Has Displayed Warning Upsell';


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

COMMENT ON COLUMN public.sale_order_line.remaining_hours IS 'Time Remaining on SO';


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

CREATE TABLE public.sale_order_line_product_document_rel (
    sale_order_line_id integer CONSTRAINT sale_order_line_product_document_re_sale_order_line_id_not_null NOT NULL,
    product_document_id integer CONSTRAINT sale_order_line_product_document_r_product_document_id_not_null NOT NULL
);


ALTER TABLE public.sale_order_line_product_document_rel OWNER TO odoo;

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

COMMENT ON TABLE public.sale_order_line_product_document_rel IS 'RELATION BETWEEN sale_order_line AND product_document';


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

CREATE TABLE public.sale_order_mass_cancel_wizard_rel (
    sale_mass_cancel_orders_id integer CONSTRAINT sale_order_mass_cancel_wiza_sale_mass_cancel_orders_id_not_null NOT NULL,
    sale_order_id integer NOT NULL
);


ALTER TABLE public.sale_order_mass_cancel_wizard_rel OWNER TO odoo;

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

COMMENT ON TABLE public.sale_order_mass_cancel_wizard_rel IS 'RELATION BETWEEN sale_mass_cancel_orders AND sale_order';


--
-- 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 SEQUENCE 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,
    sequence integer,
    mail_template_id integer,
    number_of_days integer,
    create_uid integer,
    write_uid integer,
    name character varying NOT NULL,
    note jsonb,
    journal_id jsonb,
    active boolean,
    require_signature boolean,
    require_payment boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    prepayment_percent double precision
);


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

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


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

COMMENT ON COLUMN public.sale_order_template.journal_id IS 'Invoicing Journal';


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

COMMENT ON COLUMN public.sale_order_template.prepayment_percent IS 'Prepayment percentage';


--
-- 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 SEQUENCE 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,
    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 SEQUENCE 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 SEQUENCE 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_email_account character varying,
    manual_name character varying,
    journal_name character varying,
    acc_number character varying,
    manual_post_msg text,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


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

CREATE TABLE public.sale_pdf_form_field (
    id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    name character varying NOT NULL,
    document_type character varying NOT NULL,
    path character varying,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.sale_pdf_form_field OWNER TO odoo;

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

COMMENT ON TABLE public.sale_pdf_form_field IS 'Form fields of inside quotation documents.';


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

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


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

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


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

COMMENT ON COLUMN public.sale_pdf_form_field.name IS 'Form Field Name';


--
-- Name: COLUMN sale_pdf_form_field.document_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_pdf_form_field.document_type IS 'Document Type';


--
-- Name: COLUMN sale_pdf_form_field.path; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_pdf_form_field.path IS 'Path';


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

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


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

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


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

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


ALTER SEQUENCE public.sale_pdf_form_field_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.sale_pdf_form_field_id_seq OWNED BY public.sale_pdf_form_field.id;


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

CREATE TABLE public.scheduled_message_attachment_rel (
    scheduled_message_id integer NOT NULL,
    attachment_id integer NOT NULL
);


ALTER TABLE public.scheduled_message_attachment_rel OWNER TO odoo;

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

COMMENT ON TABLE public.scheduled_message_attachment_rel IS 'RELATION BETWEEN mail_scheduled_message AND ir_attachment';


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

CREATE TABLE public.sms_account_code (
    id integer NOT NULL,
    account_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    verification_code character varying NOT NULL,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.sms_account_code OWNER TO odoo;

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

COMMENT ON TABLE public.sms_account_code IS 'SMS Account Verification Code Wizard';


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

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


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

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


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

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


--
-- Name: COLUMN sms_account_code.verification_code; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sms_account_code.verification_code IS 'Verification Code';


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

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


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

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


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

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


ALTER SEQUENCE public.sms_account_code_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.sms_account_code_id_seq OWNED BY public.sms_account_code.id;


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

CREATE TABLE public.sms_account_phone (
    id integer NOT NULL,
    account_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    phone_number character varying NOT NULL,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.sms_account_phone OWNER TO odoo;

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

COMMENT ON TABLE public.sms_account_phone IS 'SMS Account Registration Phone Number Wizard';


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

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


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

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


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

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


--
-- Name: COLUMN sms_account_phone.phone_number; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sms_account_phone.phone_number IS 'Phone Number';


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

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


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

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


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

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


ALTER SEQUENCE public.sms_account_phone_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.sms_account_phone_id_seq OWNED BY public.sms_account_phone.id;


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

CREATE TABLE public.sms_account_sender (
    id integer NOT NULL,
    account_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    sender_name character varying,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.sms_account_sender OWNER TO odoo;

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

COMMENT ON TABLE public.sms_account_sender IS 'SMS Account Sender Name Wizard';


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

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


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

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


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

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


--
-- Name: COLUMN sms_account_sender.sender_name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sms_account_sender.sender_name IS 'Sender Name';


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

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


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

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


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

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


ALTER SEQUENCE public.sms_account_sender_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.sms_account_sender_id_seq OWNED BY public.sms_account_sender.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 SEQUENCE 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 SEQUENCE 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 SEQUENCE 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,
    uuid character varying,
    number character varying,
    state character varying NOT NULL,
    failure_type character varying,
    body text,
    to_delete boolean,
    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.uuid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sms_sms.uuid IS 'UUID';


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

COMMENT ON COLUMN public.sms_sms.to_delete IS 'Marked for deletion';


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

CREATE TABLE public.sms_tracker (
    id integer NOT NULL,
    mail_notification_id integer,
    create_uid integer,
    write_uid integer,
    sms_uuid character varying NOT NULL,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.sms_tracker OWNER TO odoo;

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

COMMENT ON TABLE public.sms_tracker IS 'Link SMS to mailing/sms tracking models';


--
-- Name: COLUMN sms_tracker.mail_notification_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sms_tracker.mail_notification_id IS 'Mail Notification';


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

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


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

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


--
-- Name: COLUMN sms_tracker.sms_uuid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sms_tracker.sms_uuid IS 'SMS uuid';


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

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


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

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


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

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


ALTER SEQUENCE public.sms_tracker_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.sms_tracker_id_seq OWNED BY public.sms_tracker.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 SEQUENCE 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 SEQUENCE 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 SEQUENCE 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,
    company_id integer,
    create_uid integer,
    write_uid integer,
    sample_dashboard_file_path character varying,
    name jsonb NOT NULL,
    is_published boolean,
    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.company_id; Type: COMMENT; Schema: public; Owner: odoo
--

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


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

COMMENT ON COLUMN public.spreadsheet_dashboard.sample_dashboard_file_path IS 'Sample Dashboard File Path';


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

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


--
-- Name: COLUMN spreadsheet_dashboard.is_published; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.spreadsheet_dashboard.is_published IS 'Is Published';


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

CREATE TABLE public.spreadsheet_dashboard_share (
    id integer NOT NULL,
    dashboard_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    access_token character varying NOT NULL,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.spreadsheet_dashboard_share OWNER TO odoo;

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

COMMENT ON TABLE public.spreadsheet_dashboard_share IS 'Copy of a shared dashboard';


--
-- Name: COLUMN spreadsheet_dashboard_share.dashboard_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.spreadsheet_dashboard_share.dashboard_id IS 'Dashboard';


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

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


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

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


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

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


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

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


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

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


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

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


ALTER SEQUENCE public.spreadsheet_dashboard_share_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.spreadsheet_dashboard_share_id_seq OWNED BY public.spreadsheet_dashboard_share.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 SEQUENCE 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 SEQUENCE 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 SEQUENCE 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_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,
    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 Reason';


--
-- 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 SEQUENCE 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 CONSTRAINT stock_inventory_adjustment__stock_inventory_adjustment_not_null NOT NULL,
    stock_quant_id integer CONSTRAINT stock_inventory_adjustment_name_stock_q_stock_quant_id_not_null 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 SEQUENCE 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 CONSTRAINT stock_inventory_conflict_st_stock_inventory_conflict_i_not_null NOT NULL,
    stock_quant_id integer CONSTRAINT stock_inventory_conflict_stock_quant_re_stock_quant_id_not_null 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 SEQUENCE 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 CONSTRAINT stock_inventory_warning_sto_stock_inventory_warning_id_not_null 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 SEQUENCE 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,
    product_id integer NOT NULL,
    product_uom_id integer,
    company_id integer,
    location_id integer,
    create_uid integer,
    write_uid integer,
    name character varying NOT NULL,
    ref character varying,
    lot_properties jsonb,
    note text,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    standard_price jsonb
);


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

COMMENT ON COLUMN public.stock_lot.location_id IS 'Location';


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

COMMENT ON COLUMN public.stock_lot.lot_properties IS 'Properties';


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

COMMENT ON COLUMN public.stock_lot.standard_price IS 'Cost';


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

CREATE TABLE public.stock_move_created_purchase_line_rel (
    created_purchase_line_id integer CONSTRAINT stock_move_created_purchase_l_created_purchase_line_id_not_null NOT NULL,
    move_id integer NOT NULL
);


ALTER TABLE public.stock_move_created_purchase_line_rel OWNER TO odoo;

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

COMMENT ON TABLE public.stock_move_created_purchase_line_rel IS 'RELATION BETWEEN purchase_order_line AND stock_move';


--
-- 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 SEQUENCE 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,
    lot_name character varying,
    state character varying,
    reference character varying,
    description_picking text,
    quantity numeric,
    quantity_product_uom numeric,
    picked boolean,
    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.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.quantity; Type: COMMENT; Schema: public; Owner: odoo
--

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


--
-- Name: COLUMN stock_move_line.quantity_product_uom; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move_line.quantity_product_uom IS 'Quantity in Product UoM';


--
-- Name: COLUMN stock_move_line.picked; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move_line.picked IS 'Picked';


--
-- 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 SEQUENCE 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 SEQUENCE 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 CONSTRAINT stock_orderpoint_snooze_sto_stock_orderpoint_snooze_id_not_null NOT NULL,
    stock_warehouse_orderpoint_id integer CONSTRAINT stock_orderpoint_snooze_sto_stock_warehouse_orderpoint_not_null 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 SEQUENCE 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 SEQUENCE 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,
    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,
    height double precision,
    width double precision,
    packaging_length double precision,
    base_weight double precision,
    max_weight double precision,
    CONSTRAINT stock_package_type_positive_height CHECK ((height >= (0.0)::double precision)),
    CONSTRAINT stock_package_type_positive_length CHECK ((packaging_length >= (0.0)::double precision)),
    CONSTRAINT stock_package_type_positive_max_weight CHECK ((max_weight >= (0.0)::double precision)),
    CONSTRAINT stock_package_type_positive_width CHECK ((width >= (0.0)::double precision))
);


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.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.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.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.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.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.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 SEQUENCE 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 CONSTRAINT stock_package_type_stock_putaway_stock_putaway_rule_id_not_null NOT NULL,
    stock_package_type_id integer CONSTRAINT stock_package_type_stock_putaway_stock_package_type_id_not_null 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,
    backorder_id integer,
    return_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,
    picking_properties jsonb,
    note text,
    has_deadline_issue boolean,
    printed boolean,
    is_locked 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,
    project_id integer,
    sale_id integer,
    repair_order_id integer,
    tipo_albaran character varying,
    legacy_reference character varying
);


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

COMMENT ON COLUMN public.stock_picking.backorder_id IS 'Back Order of';


--
-- Name: COLUMN stock_picking.return_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking.return_id IS 'Return 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.picking_properties; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking.picking_properties IS 'Properties';


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

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


--
-- Name: COLUMN stock_picking.repair_order_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking.repair_order_id IS 'OT Relacionada';


--
-- Name: COLUMN stock_picking.tipo_albaran; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking.tipo_albaran IS 'Tipo de Albarán';


--
-- Name: COLUMN stock_picking.legacy_reference; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking.legacy_reference IS 'Referencia Histórica';


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

CREATE TABLE public.stock_picking_backorder_rel (
    stock_backorder_confirmation_id integer CONSTRAINT stock_picking_backorder_rel_stock_backorder_confirmati_not_null 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 SEQUENCE 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_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 NOT NULL,
    default_location_dest_id integer NOT NULL,
    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,
    product_label_format character varying,
    lot_label_format character varying,
    package_label_to_print character varying,
    barcode character varying,
    create_backorder character varying NOT NULL,
    move_type character varying NOT NULL,
    name jsonb NOT NULL,
    picking_properties_definition jsonb,
    show_entire_packs boolean,
    active boolean,
    use_create_lots boolean,
    use_existing_lots boolean,
    print_label boolean,
    show_operations boolean,
    auto_show_reception_report boolean,
    auto_print_delivery_slip boolean,
    auto_print_return_slip boolean,
    auto_print_product_labels boolean,
    auto_print_lot_labels boolean,
    auto_print_reception_report boolean,
    auto_print_reception_report_labels boolean,
    auto_print_packages boolean,
    auto_print_package_label boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    analytic_costs boolean,
    default_product_location_src_id integer,
    default_product_location_dest_id integer,
    default_remove_location_dest_id integer,
    default_recycle_location_dest_id integer,
    repair_properties_definition jsonb,
    is_repairable boolean
);


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

COMMENT ON COLUMN public.stock_picking_type.product_label_format IS 'Product Label Format to auto-print';


--
-- Name: COLUMN stock_picking_type.lot_label_format; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking_type.lot_label_format IS 'Lot Label Format to auto-print';


--
-- Name: COLUMN stock_picking_type.package_label_to_print; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking_type.package_label_to_print IS 'Package Label to Print';


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

COMMENT ON COLUMN public.stock_picking_type.move_type IS 'Shipping Policy';


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

COMMENT ON COLUMN public.stock_picking_type.picking_properties_definition IS 'Picking Properties';


--
-- 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 'Generate Shipping Labels';


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

COMMENT ON COLUMN public.stock_picking_type.auto_print_delivery_slip IS 'Auto Print Delivery Slip';


--
-- Name: COLUMN stock_picking_type.auto_print_return_slip; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking_type.auto_print_return_slip IS 'Auto Print Return Slip';


--
-- Name: COLUMN stock_picking_type.auto_print_product_labels; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking_type.auto_print_product_labels IS 'Auto Print Product Labels';


--
-- Name: COLUMN stock_picking_type.auto_print_lot_labels; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking_type.auto_print_lot_labels IS 'Auto Print Lot/SN Labels';


--
-- Name: COLUMN stock_picking_type.auto_print_reception_report; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking_type.auto_print_reception_report IS 'Auto Print Reception Report';


--
-- Name: COLUMN stock_picking_type.auto_print_reception_report_labels; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking_type.auto_print_reception_report_labels IS 'Auto Print Reception Report Labels';


--
-- Name: COLUMN stock_picking_type.auto_print_packages; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking_type.auto_print_packages IS 'Auto Print Packages';


--
-- Name: COLUMN stock_picking_type.auto_print_package_label; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking_type.auto_print_package_label IS 'Auto Print Package Label';


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

COMMENT ON COLUMN public.stock_picking_type.analytic_costs IS 'Analytic Costs';


--
-- Name: COLUMN stock_picking_type.default_product_location_src_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking_type.default_product_location_src_id IS 'Product Source Location';


--
-- Name: COLUMN stock_picking_type.default_product_location_dest_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking_type.default_product_location_dest_id IS 'Product Destination Location';


--
-- Name: COLUMN stock_picking_type.default_remove_location_dest_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking_type.default_remove_location_dest_id IS 'Remove Destination Location';


--
-- Name: COLUMN stock_picking_type.default_recycle_location_dest_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking_type.default_recycle_location_dest_id IS 'Recycle Destination Location';


--
-- Name: COLUMN stock_picking_type.repair_properties_definition; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking_type.repair_properties_definition IS 'Repair Properties';


--
-- Name: COLUMN stock_picking_type.is_repairable; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_picking_type.is_repairable IS 'Create Repair Orders from Returns';


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

COMMENT ON COLUMN public.stock_putaway_rule.sublocation IS 'Sublocation';


--
-- 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 SEQUENCE 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 SEQUENCE 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,
    shipping_weight double precision
);


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

COMMENT ON COLUMN public.stock_quant_package.shipping_weight IS 'Shipping Weight';


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

CREATE TABLE public.stock_quant_relocate (
    id integer NOT NULL,
    dest_location_id integer,
    dest_package_id integer,
    create_uid integer,
    write_uid integer,
    message text,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.stock_quant_relocate OWNER TO odoo;

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

COMMENT ON TABLE public.stock_quant_relocate IS 'Stock Quantity Relocation';


--
-- Name: COLUMN stock_quant_relocate.dest_location_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_quant_relocate.dest_location_id IS 'Dest Location';


--
-- Name: COLUMN stock_quant_relocate.dest_package_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_quant_relocate.dest_package_id IS 'Dest Package';


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

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


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

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


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

COMMENT ON COLUMN public.stock_quant_relocate.message IS 'Reason for relocation';


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

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


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

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


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

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


ALTER SEQUENCE public.stock_quant_relocate_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.stock_quant_relocate_id_seq OWNED BY public.stock_quant_relocate.id;


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

CREATE TABLE public.stock_quant_stock_quant_relocate_rel (
    stock_quant_relocate_id integer CONSTRAINT stock_quant_stock_quant_reloca_stock_quant_relocate_id_not_null NOT NULL,
    stock_quant_id integer NOT NULL
);


ALTER TABLE public.stock_quant_stock_quant_relocate_rel OWNER TO odoo;

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

COMMENT ON TABLE public.stock_quant_stock_quant_relocate_rel IS 'RELATION BETWEEN stock_quant_relocate AND stock_quant';


--
-- 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 CONSTRAINT stock_quant_stock_request_count_stock_request_count_id_not_null 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 CONSTRAINT stock_quant_stock_track_con_stock_track_confirmation_i_not_null NOT NULL,
    stock_quant_id integer CONSTRAINT stock_quant_stock_track_confirmation_re_stock_quant_id_not_null 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 SEQUENCE 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 SEQUENCE 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 SEQUENCE 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 SEQUENCE 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,
    create_uid integer,
    write_uid integer,
    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.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.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 SEQUENCE 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 SEQUENCE 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 SEQUENCE 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 CONSTRAINT stock_route_stock_rules_report_r_stock_rules_report_id_not_null 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,
    push_domain character varying,
    name jsonb NOT NULL,
    active boolean,
    location_dest_from_rule 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.push_domain; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_rule.push_domain IS 'Push Applicability';


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

COMMENT ON COLUMN public.stock_rule.location_dest_from_rule IS 'Destination location origin from rule';


--
-- 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 SEQUENCE 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 SEQUENCE 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 CONSTRAINT stock_rules_report_stock_warehou_stock_rules_report_id_not_null NOT NULL,
    stock_warehouse_id integer CONSTRAINT stock_rules_report_stock_warehouse__stock_warehouse_id_not_null 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_scrap; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.stock_scrap (
    id integer NOT NULL,
    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,
    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,
    should_replenish boolean,
    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.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.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.should_replenish; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_scrap.should_replenish IS 'Replenish Quantities';


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

CREATE TABLE public.stock_scrap_reason_tag (
    id integer NOT NULL,
    sequence integer,
    create_uid integer,
    write_uid integer,
    color character varying,
    name jsonb NOT NULL,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.stock_scrap_reason_tag OWNER TO odoo;

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

COMMENT ON TABLE public.stock_scrap_reason_tag IS 'Scrap Reason Tag';


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

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


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

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


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

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


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

COMMENT ON COLUMN public.stock_scrap_reason_tag.color IS 'Color';


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

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


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

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


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

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


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

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


ALTER SEQUENCE public.stock_scrap_reason_tag_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.stock_scrap_reason_tag_id_seq OWNED BY public.stock_scrap_reason_tag.id;


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

CREATE TABLE public.stock_scrap_stock_scrap_reason_tag_rel (
    stock_scrap_id integer NOT NULL,
    stock_scrap_reason_tag_id integer CONSTRAINT stock_scrap_stock_scrap_reas_stock_scrap_reason_tag_id_not_null NOT NULL
);


ALTER TABLE public.stock_scrap_stock_scrap_reason_tag_rel OWNER TO odoo;

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

COMMENT ON TABLE public.stock_scrap_stock_scrap_reason_tag_rel IS 'RELATION BETWEEN stock_scrap AND stock_scrap_reason_tag';


--
-- 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 SEQUENCE 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 SEQUENCE 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 SEQUENCE 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 SEQUENCE 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 SEQUENCE 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,
    categ_id integer,
    stock_valuation_layer_id integer,
    stock_move_id integer,
    account_move_id integer,
    account_move_line_id integer,
    lot_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.categ_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_valuation_layer.categ_id IS 'Product Category';


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

COMMENT ON COLUMN public.stock_valuation_layer.lot_id IS 'Lot/Serial Number';


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

COMMENT ON COLUMN public.stock_valuation_layer_revaluation.lot_id IS 'Related lot/serial number';


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

CREATE TABLE public.stock_valuation_layer_stock_valuation_layer_revaluation_rel (
    stock_valuation_layer_revaluation_id integer CONSTRAINT stock_valuation_layer_stock_stock_valuation_layer_reva_not_null NOT NULL,
    stock_valuation_layer_id integer CONSTRAINT stock_valuation_layer_stock_v_stock_valuation_layer_id_not_null NOT NULL
);


ALTER TABLE public.stock_valuation_layer_stock_valuation_layer_revaluation_rel OWNER TO odoo;

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

COMMENT ON TABLE public.stock_valuation_layer_stock_valuation_layer_revaluation_rel IS 'RELATION BETWEEN stock_valuation_layer_revaluation AND stock_valuation_layer';


--
-- 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 SEQUENCE 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_manual numeric,
    active boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    supplier_id integer,
    vendor_id integer,
    product_supplier_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 '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_manual; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse_orderpoint.qty_to_order_manual IS 'To Order Manual';


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

COMMENT ON COLUMN public.stock_warehouse_orderpoint.product_supplier_id IS 'Product Supplier';


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

CREATE TABLE public.stock_warn_insufficient_qty_repair (
    id integer NOT NULL,
    product_id integer NOT NULL,
    location_id integer NOT NULL,
    repair_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_repair OWNER TO odoo;

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

COMMENT ON TABLE public.stock_warn_insufficient_qty_repair IS 'Warn Insufficient Repair Quantity';


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

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


--
-- Name: COLUMN stock_warn_insufficient_qty_repair.location_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warn_insufficient_qty_repair.location_id IS 'Location';


--
-- Name: COLUMN stock_warn_insufficient_qty_repair.repair_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warn_insufficient_qty_repair.repair_id IS 'Repair';


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

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


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

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


--
-- Name: COLUMN stock_warn_insufficient_qty_repair.product_uom_name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warn_insufficient_qty_repair.product_uom_name IS 'Unit of Measure';


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

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


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

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


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

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


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

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


ALTER SEQUENCE public.stock_warn_insufficient_qty_repair_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.stock_warn_insufficient_qty_repair_id_seq OWNED BY public.stock_warn_insufficient_qty_repair.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 SEQUENCE 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: task_dependencies_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.task_dependencies_rel (
    task_id integer NOT NULL,
    depends_on_id integer NOT NULL
);


ALTER TABLE public.task_dependencies_rel OWNER TO odoo;

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

COMMENT ON TABLE public.task_dependencies_rel IS 'RELATION BETWEEN project_task AND project_task';


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

CREATE TABLE public.team_favorite_user_rel (
    team_id integer NOT NULL,
    user_id integer NOT NULL
);


ALTER TABLE public.team_favorite_user_rel OWNER TO odoo;

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

COMMENT ON TABLE public.team_favorite_user_rel IS 'RELATION BETWEEN crm_team AND res_users';


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

CREATE TABLE public.template_attribute_value_stock_move_rel (
    move_id integer NOT NULL,
    template_attribute_value_id integer CONSTRAINT template_attribute_value_st_template_attribute_value_i_not_null NOT NULL
);


ALTER TABLE public.template_attribute_value_stock_move_rel OWNER TO odoo;

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

COMMENT ON TABLE public.template_attribute_value_stock_move_rel IS 'RELATION BETWEEN stock_move AND product_template_attribute_value';


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

CREATE TABLE public.theme_ir_asset (
    id integer NOT NULL,
    sequence integer NOT NULL,
    create_uid integer,
    write_uid integer,
    key character varying,
    name character varying NOT NULL,
    bundle character varying NOT NULL,
    directive character varying,
    path character varying NOT NULL,
    target character varying,
    active boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.theme_ir_asset OWNER TO odoo;

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

COMMENT ON TABLE public.theme_ir_asset IS 'Theme Asset';


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

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


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

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


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

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


--
-- Name: COLUMN theme_ir_asset.key; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.theme_ir_asset.key IS 'Key';


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

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


--
-- Name: COLUMN theme_ir_asset.bundle; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.theme_ir_asset.bundle IS 'Bundle';


--
-- Name: COLUMN theme_ir_asset.directive; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.theme_ir_asset.directive IS 'Directive';


--
-- Name: COLUMN theme_ir_asset.path; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.theme_ir_asset.path IS 'Path';


--
-- Name: COLUMN theme_ir_asset.target; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.theme_ir_asset.target IS 'Target';


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

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


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

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


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

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


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

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


ALTER SEQUENCE public.theme_ir_asset_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.theme_ir_asset_id_seq OWNED BY public.theme_ir_asset.id;


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

CREATE TABLE public.theme_ir_attachment (
    id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    name character varying NOT NULL,
    key character varying NOT NULL,
    url character varying,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.theme_ir_attachment OWNER TO odoo;

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

COMMENT ON TABLE public.theme_ir_attachment IS 'Theme Attachments';


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

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


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

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


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

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


--
-- Name: COLUMN theme_ir_attachment.key; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.theme_ir_attachment.key IS 'Key';


--
-- Name: COLUMN theme_ir_attachment.url; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.theme_ir_attachment.url IS 'Url';


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

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


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

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


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

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


ALTER SEQUENCE public.theme_ir_attachment_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.theme_ir_attachment_id_seq OWNED BY public.theme_ir_attachment.id;


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

CREATE TABLE public.theme_ir_ui_view (
    id integer NOT NULL,
    priority integer NOT NULL,
    create_uid integer,
    write_uid integer,
    name character varying NOT NULL,
    key character varying,
    type character varying,
    mode character varying,
    arch_fs character varying,
    inherit_id character varying,
    arch jsonb,
    active boolean,
    customize_show boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.theme_ir_ui_view OWNER TO odoo;

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

COMMENT ON TABLE public.theme_ir_ui_view IS 'Theme UI View';


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

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


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

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


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

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


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

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


--
-- Name: COLUMN theme_ir_ui_view.key; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.theme_ir_ui_view.key IS 'Key';


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

COMMENT ON COLUMN public.theme_ir_ui_view.type IS 'Type';


--
-- Name: COLUMN theme_ir_ui_view.mode; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.theme_ir_ui_view.mode IS 'Mode';


--
-- Name: COLUMN theme_ir_ui_view.arch_fs; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.theme_ir_ui_view.arch_fs IS 'Arch Fs';


--
-- Name: COLUMN theme_ir_ui_view.inherit_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.theme_ir_ui_view.inherit_id IS 'Inherit';


--
-- Name: COLUMN theme_ir_ui_view.arch; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.theme_ir_ui_view.arch IS 'Arch';


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

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


--
-- Name: COLUMN theme_ir_ui_view.customize_show; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.theme_ir_ui_view.customize_show IS 'Customize Show';


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

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


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

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


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

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


ALTER SEQUENCE public.theme_ir_ui_view_id_seq OWNER TO odoo;

--
