-- Name: COLUMN product_document.ir_attachment_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_document.ir_attachment_id IS 'Related attachment';


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

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


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

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


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

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


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

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


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

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


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

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


--
-- Name: COLUMN product_document.attached_on_sale; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_document.attached_on_sale IS 'Sale : Visible at';


--
-- Name: COLUMN product_document.attached_on_mrp; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_document.attached_on_mrp IS 'MRP : Visible at';


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

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


ALTER SEQUENCE public.product_document_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.product_document_id_seq OWNED BY public.product_document.id;


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

CREATE TABLE public.product_document_sale_pdf_form_field_rel (
    product_document_id integer NOT NULL,
    sale_pdf_form_field_id integer NOT NULL
);


ALTER TABLE public.product_document_sale_pdf_form_field_rel OWNER TO odoo;

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

COMMENT ON TABLE public.product_document_sale_pdf_form_field_rel IS 'RELATION BETWEEN product_document AND sale_pdf_form_field';


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

CREATE TABLE public.product_label_layout (
    id integer NOT NULL,
    custom_quantity integer NOT NULL,
    pricelist_id integer,
    create_uid integer,
    write_uid integer,
    print_format character varying NOT NULL,
    extra_html text,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    move_quantity character varying NOT NULL
);


ALTER TABLE public.product_label_layout OWNER TO odoo;

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

COMMENT ON TABLE public.product_label_layout IS 'Choose the sheet layout to print the labels';


--
-- Name: COLUMN product_label_layout.custom_quantity; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_label_layout.custom_quantity IS 'Quantity';


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

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


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

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


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

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


--
-- Name: COLUMN product_label_layout.print_format; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_label_layout.print_format IS 'Format';


--
-- Name: COLUMN product_label_layout.extra_html; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_label_layout.extra_html IS 'Extra Content';


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

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


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

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


--
-- Name: COLUMN product_label_layout.move_quantity; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_label_layout.move_quantity IS 'Quantity to print';


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

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


ALTER SEQUENCE public.product_label_layout_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.product_label_layout_id_seq OWNED BY public.product_label_layout.id;


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

CREATE TABLE public.product_label_layout_product_product_rel (
    product_label_layout_id integer NOT NULL,
    product_product_id integer NOT NULL
);


ALTER TABLE public.product_label_layout_product_product_rel OWNER TO odoo;

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

COMMENT ON TABLE public.product_label_layout_product_product_rel IS 'RELATION BETWEEN product_label_layout AND product_product';


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

CREATE TABLE public.product_label_layout_product_template_rel (
    product_label_layout_id integer NOT NULL,
    product_template_id integer NOT NULL
);


ALTER TABLE public.product_label_layout_product_template_rel OWNER TO odoo;

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

COMMENT ON TABLE public.product_label_layout_product_template_rel IS 'RELATION BETWEEN product_label_layout AND product_template';


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

CREATE TABLE public.product_label_layout_stock_move_rel (
    product_label_layout_id integer NOT NULL,
    stock_move_id integer NOT NULL
);


ALTER TABLE public.product_label_layout_stock_move_rel OWNER TO odoo;

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

COMMENT ON TABLE public.product_label_layout_stock_move_rel IS 'RELATION BETWEEN product_label_layout AND stock_move';


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

CREATE TABLE public.product_optional_rel (
    src_id integer NOT NULL,
    dest_id integer NOT NULL
);


ALTER TABLE public.product_optional_rel OWNER TO odoo;

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

COMMENT ON TABLE public.product_optional_rel IS 'RELATION BETWEEN product_template AND product_template';


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

CREATE TABLE public.product_packaging (
    id integer NOT NULL,
    sequence integer,
    product_id integer NOT NULL,
    company_id integer,
    create_uid integer,
    write_uid integer,
    name character varying NOT NULL,
    barcode character varying,
    qty numeric,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    sales boolean,
    package_type_id integer,
    purchase boolean,
    CONSTRAINT product_packaging_positive_qty CHECK ((qty > (0)::numeric))
);


ALTER TABLE public.product_packaging OWNER TO odoo;

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

COMMENT ON TABLE public.product_packaging IS 'Product Packaging';


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

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


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

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


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

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


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

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


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

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


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

COMMENT ON COLUMN public.product_packaging.name IS 'Product Packaging';


--
-- Name: COLUMN product_packaging.barcode; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_packaging.barcode IS 'Barcode';


--
-- Name: COLUMN product_packaging.qty; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_packaging.qty IS 'Contained Quantity';


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

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


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

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


--
-- Name: COLUMN product_packaging.sales; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_packaging.sales IS 'Sales';


--
-- Name: COLUMN product_packaging.package_type_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_packaging.package_type_id IS 'Package Type';


--
-- Name: COLUMN product_packaging.purchase; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_packaging.purchase IS 'Purchase';


--
-- Name: CONSTRAINT product_packaging_positive_qty ON product_packaging; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT product_packaging_positive_qty ON public.product_packaging IS 'CHECK(qty > 0)';


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

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


ALTER SEQUENCE public.product_packaging_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.product_packaging_id_seq OWNED BY public.product_packaging.id;


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

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


ALTER TABLE public.product_pricelist OWNER TO odoo;

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

COMMENT ON TABLE public.product_pricelist IS 'Pricelist';


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

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


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

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


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

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


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

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


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

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


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

COMMENT ON COLUMN public.product_pricelist.name IS 'Pricelist Name';


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

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


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

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


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

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


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

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


ALTER SEQUENCE public.product_pricelist_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.product_pricelist_id_seq OWNED BY public.product_pricelist.id;


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

CREATE TABLE public.product_pricelist_item (
    id integer NOT NULL,
    pricelist_id integer NOT NULL,
    company_id integer,
    currency_id integer,
    categ_id integer,
    product_tmpl_id integer,
    product_id integer,
    base_pricelist_id integer,
    create_uid integer,
    write_uid integer,
    applied_on character varying NOT NULL,
    display_applied_on character varying NOT NULL,
    base character varying NOT NULL,
    compute_price character varying NOT NULL,
    min_quantity numeric,
    fixed_price numeric,
    price_discount numeric,
    price_round numeric,
    price_surcharge numeric,
    price_markup numeric,
    price_min_margin numeric,
    price_max_margin numeric,
    date_start timestamp without time zone,
    date_end timestamp without time zone,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    percent_price double precision
);


ALTER TABLE public.product_pricelist_item OWNER TO odoo;

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

COMMENT ON TABLE public.product_pricelist_item IS 'Pricelist Rule';


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

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


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

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


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

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


--
-- Name: COLUMN product_pricelist_item.categ_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist_item.categ_id IS 'Category';


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

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


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

COMMENT ON COLUMN public.product_pricelist_item.product_id IS 'Variant';


--
-- Name: COLUMN product_pricelist_item.base_pricelist_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist_item.base_pricelist_id IS 'Other Pricelist';


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

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


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

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


--
-- Name: COLUMN product_pricelist_item.applied_on; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist_item.applied_on IS 'Apply On';


--
-- Name: COLUMN product_pricelist_item.display_applied_on; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist_item.display_applied_on IS 'Display Applied On';


--
-- Name: COLUMN product_pricelist_item.base; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist_item.base IS 'Based on';


--
-- Name: COLUMN product_pricelist_item.compute_price; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist_item.compute_price IS 'Compute Price';


--
-- Name: COLUMN product_pricelist_item.min_quantity; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist_item.min_quantity IS 'Min. Quantity';


--
-- Name: COLUMN product_pricelist_item.fixed_price; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist_item.fixed_price IS 'Fixed Price';


--
-- Name: COLUMN product_pricelist_item.price_discount; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist_item.price_discount IS 'Price Discount';


--
-- Name: COLUMN product_pricelist_item.price_round; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist_item.price_round IS 'Price Rounding';


--
-- Name: COLUMN product_pricelist_item.price_surcharge; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist_item.price_surcharge IS 'Extra Fee';


--
-- Name: COLUMN product_pricelist_item.price_markup; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist_item.price_markup IS 'Markup';


--
-- Name: COLUMN product_pricelist_item.price_min_margin; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist_item.price_min_margin IS 'Min. Price Margin';


--
-- Name: COLUMN product_pricelist_item.price_max_margin; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist_item.price_max_margin IS 'Max. Price Margin';


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

COMMENT ON COLUMN public.product_pricelist_item.date_start IS 'Start Date';


--
-- Name: COLUMN product_pricelist_item.date_end; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist_item.date_end IS 'End Date';


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

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


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

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


--
-- Name: COLUMN product_pricelist_item.percent_price; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_pricelist_item.percent_price IS 'Percentage Price';


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

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


ALTER SEQUENCE public.product_pricelist_item_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.product_pricelist_item_id_seq OWNED BY public.product_pricelist_item.id;


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

CREATE TABLE public.product_product (
    id integer NOT NULL,
    product_tmpl_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    default_code character varying,
    barcode character varying,
    combination_indices character varying,
    standard_price jsonb,
    volume numeric,
    weight numeric,
    active boolean,
    can_image_variant_1024_be_zoomed boolean,
    write_date timestamp without time zone,
    create_date timestamp without time zone,
    lot_properties_definition jsonb
);


ALTER TABLE public.product_product OWNER TO odoo;

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

COMMENT ON TABLE public.product_product IS 'Product Variant';


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

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


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

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


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

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


--
-- Name: COLUMN product_product.default_code; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_product.default_code IS 'Internal Reference';


--
-- Name: COLUMN product_product.barcode; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_product.barcode IS 'Barcode';


--
-- Name: COLUMN product_product.combination_indices; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_product.combination_indices IS 'Combination Indices';


--
-- Name: COLUMN product_product.standard_price; Type: COMMENT; Schema: public; Owner: odoo
--

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


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

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


--
-- Name: COLUMN product_product.weight; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_product.weight IS 'Weight';


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

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


--
-- Name: COLUMN product_product.can_image_variant_1024_be_zoomed; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_product.can_image_variant_1024_be_zoomed IS 'Can Variant Image 1024 be zoomed';


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

COMMENT ON COLUMN public.product_product.write_date IS 'Write Date';


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

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


--
-- Name: COLUMN product_product.lot_properties_definition; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_product.lot_properties_definition IS 'Lot Properties';


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

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


ALTER SEQUENCE public.product_product_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.product_product_id_seq OWNED BY public.product_product.id;


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

CREATE TABLE public.product_product_stock_track_confirmation_rel (
    stock_track_confirmation_id integer NOT NULL,
    product_product_id integer NOT NULL
);


ALTER TABLE public.product_product_stock_track_confirmation_rel OWNER TO odoo;

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

COMMENT ON TABLE public.product_product_stock_track_confirmation_rel IS 'RELATION BETWEEN stock_track_confirmation AND product_product';


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

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


ALTER TABLE public.product_removal OWNER TO odoo;

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

COMMENT ON TABLE public.product_removal IS 'Removal Strategy';


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

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


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

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


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

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


--
-- Name: COLUMN product_removal.method; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_removal.method IS 'Method';


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

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


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

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


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

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


ALTER SEQUENCE public.product_removal_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.product_removal_id_seq OWNED BY public.product_removal.id;


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

CREATE TABLE public.product_replenish (
    id integer NOT NULL,
    route_id integer,
    product_id integer NOT NULL,
    product_tmpl_id integer NOT NULL,
    product_uom_id integer NOT NULL,
    warehouse_id integer NOT NULL,
    company_id integer,
    create_uid integer,
    write_uid integer,
    product_has_variants boolean NOT NULL,
    date_planned timestamp without time zone NOT NULL,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    quantity double precision NOT NULL,
    bom_id integer,
    supplier_id integer
);


ALTER TABLE public.product_replenish OWNER TO odoo;

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

COMMENT ON TABLE public.product_replenish IS 'Product Replenish';


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

COMMENT ON COLUMN public.product_replenish.route_id IS 'Preferred Route';


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

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


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

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


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

COMMENT ON COLUMN public.product_replenish.product_uom_id IS 'Unity of measure';


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

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


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

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


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

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


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

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


--
-- Name: COLUMN product_replenish.product_has_variants; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_replenish.product_has_variants IS 'Has variants';


--
-- Name: COLUMN product_replenish.date_planned; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_replenish.date_planned IS 'Scheduled Date';


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

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


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

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


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

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


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

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


--
-- Name: COLUMN product_replenish.supplier_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_replenish.supplier_id IS 'Vendor';


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

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


ALTER SEQUENCE public.product_replenish_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.product_replenish_id_seq OWNED BY public.product_replenish.id;


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

CREATE TABLE public.product_supplier_taxes_rel (
    prod_id integer NOT NULL,
    tax_id integer NOT NULL
);


ALTER TABLE public.product_supplier_taxes_rel OWNER TO odoo;

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

COMMENT ON TABLE public.product_supplier_taxes_rel IS 'RELATION BETWEEN product_template AND account_tax';


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

CREATE TABLE public.product_supplierinfo (
    id integer NOT NULL,
    partner_id integer NOT NULL,
    sequence integer,
    company_id integer,
    currency_id integer NOT NULL,
    product_id integer,
    product_tmpl_id integer,
    delay integer NOT NULL,
    create_uid integer,
    write_uid integer,
    product_name character varying,
    product_code character varying,
    date_start date,
    date_end date,
    min_qty numeric NOT NULL,
    price numeric NOT NULL,
    discount numeric,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.product_supplierinfo OWNER TO odoo;

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

COMMENT ON TABLE public.product_supplierinfo IS 'Supplier Pricelist';


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

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


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

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


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

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


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

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


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

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


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

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


--
-- Name: COLUMN product_supplierinfo.delay; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_supplierinfo.delay IS 'Delivery Lead Time';


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

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


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

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


--
-- Name: COLUMN product_supplierinfo.product_name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_supplierinfo.product_name IS 'Vendor Product Name';


--
-- Name: COLUMN product_supplierinfo.product_code; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_supplierinfo.product_code IS 'Vendor Product Code';


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

COMMENT ON COLUMN public.product_supplierinfo.date_start IS 'Start Date';


--
-- Name: COLUMN product_supplierinfo.date_end; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_supplierinfo.date_end IS 'End Date';


--
-- Name: COLUMN product_supplierinfo.min_qty; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_supplierinfo.min_qty IS 'Quantity';


--
-- Name: COLUMN product_supplierinfo.price; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_supplierinfo.price IS 'Price';


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

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


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

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


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

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


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

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


ALTER SEQUENCE public.product_supplierinfo_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.product_supplierinfo_id_seq OWNED BY public.product_supplierinfo.id;


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

CREATE TABLE public.product_supplierinfo_stock_replenishment_info_rel (
    stock_replenishment_info_id integer NOT NULL,
    product_supplierinfo_id integer NOT NULL
);


ALTER TABLE public.product_supplierinfo_stock_replenishment_info_rel OWNER TO odoo;

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

COMMENT ON TABLE public.product_supplierinfo_stock_replenishment_info_rel IS 'RELATION BETWEEN stock_replenishment_info AND product_supplierinfo';


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

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

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

COMMENT ON TABLE public.product_tag IS 'Product Tag';


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


ALTER SEQUENCE public.product_tag_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.product_tag_id_seq OWNED BY public.product_tag.id;


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

CREATE TABLE public.product_tag_product_product_rel (
    product_product_id integer NOT NULL,
    product_tag_id integer NOT NULL
);


ALTER TABLE public.product_tag_product_product_rel OWNER TO odoo;

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

COMMENT ON TABLE public.product_tag_product_product_rel IS 'RELATION BETWEEN product_product AND product_tag';


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

CREATE TABLE public.product_tag_product_template_rel (
    product_template_id integer NOT NULL,
    product_tag_id integer NOT NULL
);


ALTER TABLE public.product_tag_product_template_rel OWNER TO odoo;

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

COMMENT ON TABLE public.product_tag_product_template_rel IS 'RELATION BETWEEN product_template AND product_tag';


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

CREATE TABLE public.product_taxes_rel (
    prod_id integer NOT NULL,
    tax_id integer NOT NULL
);


ALTER TABLE public.product_taxes_rel OWNER TO odoo;

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

COMMENT ON TABLE public.product_taxes_rel IS 'RELATION BETWEEN product_template AND account_tax';


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

CREATE TABLE public.product_template (
    id integer NOT NULL,
    sequence integer,
    categ_id integer NOT NULL,
    uom_id integer NOT NULL,
    uom_po_id integer NOT NULL,
    company_id integer,
    color integer,
    create_uid integer,
    write_uid integer,
    type character varying NOT NULL,
    service_tracking character varying NOT NULL,
    default_code character varying,
    name jsonb NOT NULL,
    description jsonb,
    description_purchase jsonb,
    description_sale jsonb,
    product_properties jsonb,
    list_price numeric,
    volume numeric,
    weight numeric,
    sale_ok boolean,
    purchase_ok boolean,
    active boolean,
    can_image_1024_be_zoomed boolean,
    has_configurable_attributes boolean,
    is_favorite boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    property_account_income_id jsonb,
    property_account_expense_id jsonb,
    service_type character varying,
    sale_line_warn character varying NOT NULL,
    expense_policy character varying,
    invoice_policy character varying,
    sale_line_warn_msg text,
    project_id jsonb,
    project_template_id jsonb,
    sale_delay integer,
    tracking character varying NOT NULL,
    responsible_id jsonb,
    property_stock_production jsonb,
    property_stock_inventory jsonb,
    description_picking jsonb,
    description_pickingout jsonb,
    description_pickingin jsonb,
    is_storable boolean,
    lot_valuated boolean,
    create_repair boolean,
    purchase_method character varying,
    purchase_line_warn character varying NOT NULL,
    purchase_line_warn_msg text,
    property_account_creditor_price_difference jsonb,
    service_to_purchase jsonb
);


ALTER TABLE public.product_template OWNER TO odoo;

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

COMMENT ON TABLE public.product_template IS 'Product';


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

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


--
-- Name: COLUMN product_template.categ_id; Type: COMMENT; Schema: public; Owner: odoo
--

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


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

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


--
-- Name: COLUMN product_template.uom_po_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.uom_po_id IS 'Purchase Unit';


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

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


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

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


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

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


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

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


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

COMMENT ON COLUMN public.product_template.type IS 'Product Type';


--
-- Name: COLUMN product_template.service_tracking; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.service_tracking IS 'Create on Order';


--
-- Name: COLUMN product_template.default_code; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.default_code IS 'Internal Reference';


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

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


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

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


--
-- Name: COLUMN product_template.description_purchase; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.description_purchase IS 'Purchase Description';


--
-- Name: COLUMN product_template.description_sale; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.description_sale IS 'Sales Description';


--
-- Name: COLUMN product_template.product_properties; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.product_properties IS 'Properties';


--
-- Name: COLUMN product_template.list_price; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.list_price IS 'Sales Price';


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

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


--
-- Name: COLUMN product_template.weight; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.weight IS 'Weight';


--
-- Name: COLUMN product_template.sale_ok; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.sale_ok IS 'Sales';


--
-- Name: COLUMN product_template.purchase_ok; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.purchase_ok IS 'Purchase';


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

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


--
-- Name: COLUMN product_template.can_image_1024_be_zoomed; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.can_image_1024_be_zoomed IS 'Can Image 1024 be zoomed';


--
-- Name: COLUMN product_template.has_configurable_attributes; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.has_configurable_attributes IS 'Is a configurable product';


--
-- Name: COLUMN product_template.is_favorite; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.is_favorite IS 'Favorite';


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

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


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

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


--
-- Name: COLUMN product_template.property_account_income_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.property_account_income_id IS 'Income Account';


--
-- Name: COLUMN product_template.property_account_expense_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.property_account_expense_id IS 'Expense Account';


--
-- Name: COLUMN product_template.service_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.service_type IS 'Track Service';


--
-- Name: COLUMN product_template.sale_line_warn; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.sale_line_warn IS 'Sales Order Line';


--
-- Name: COLUMN product_template.expense_policy; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.expense_policy IS 'Re-Invoice Costs';


--
-- Name: COLUMN product_template.invoice_policy; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.invoice_policy IS 'Invoicing Policy';


--
-- Name: COLUMN product_template.sale_line_warn_msg; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.sale_line_warn_msg IS 'Message for Sales Order Line';


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

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


--
-- Name: COLUMN product_template.project_template_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.project_template_id IS 'Project Template';


--
-- Name: COLUMN product_template.sale_delay; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.sale_delay IS 'Customer Lead Time';


--
-- Name: COLUMN product_template.tracking; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.tracking IS 'Tracking';


--
-- Name: COLUMN product_template.responsible_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.responsible_id IS 'Responsible';


--
-- Name: COLUMN product_template.property_stock_production; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.property_stock_production IS 'Production Location';


--
-- Name: COLUMN product_template.property_stock_inventory; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.property_stock_inventory IS 'Inventory Location';


--
-- Name: COLUMN product_template.description_picking; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.description_picking IS 'Description on Picking';


--
-- Name: COLUMN product_template.description_pickingout; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.description_pickingout IS 'Description on Delivery Orders';


--
-- Name: COLUMN product_template.description_pickingin; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.description_pickingin IS 'Description on Receptions';


--
-- Name: COLUMN product_template.is_storable; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.is_storable IS 'Track Inventory';


--
-- Name: COLUMN product_template.lot_valuated; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.lot_valuated IS 'Valuation by Lot/Serial number';


--
-- Name: COLUMN product_template.create_repair; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.create_repair IS 'Create Repair';


--
-- Name: COLUMN product_template.purchase_method; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.purchase_method IS 'Control Policy';


--
-- Name: COLUMN product_template.purchase_line_warn; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.purchase_line_warn IS 'Purchase Order Line Warning';


--
-- Name: COLUMN product_template.purchase_line_warn_msg; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.purchase_line_warn_msg IS 'Message for Purchase Order Line';


--
-- Name: COLUMN product_template.property_account_creditor_price_difference; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.property_account_creditor_price_difference IS 'Price Difference Account';


--
-- Name: COLUMN product_template.service_to_purchase; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template.service_to_purchase IS 'Subcontract Service';


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

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


ALTER TABLE public.product_template_attribute_exclusion OWNER TO odoo;

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

COMMENT ON TABLE public.product_template_attribute_exclusion IS 'Product Template Attribute Exclusion';


--
-- Name: COLUMN product_template_attribute_exclusion.product_template_attribute_value_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template_attribute_exclusion.product_template_attribute_value_id IS 'Attribute Value';


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

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


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

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


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

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


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

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


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

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


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

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


ALTER SEQUENCE public.product_template_attribute_exclusion_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.product_template_attribute_exclusion_id_seq OWNED BY public.product_template_attribute_exclusion.id;


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

CREATE TABLE public.product_template_attribute_line (
    id integer NOT NULL,
    product_tmpl_id integer NOT NULL,
    sequence integer,
    attribute_id integer NOT NULL,
    value_count integer,
    create_uid integer,
    write_uid integer,
    active boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.product_template_attribute_line OWNER TO odoo;

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

COMMENT ON TABLE public.product_template_attribute_line IS 'Product Template Attribute Line';


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

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


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

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


--
-- Name: COLUMN product_template_attribute_line.attribute_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template_attribute_line.attribute_id IS 'Attribute';


--
-- Name: COLUMN product_template_attribute_line.value_count; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template_attribute_line.value_count IS 'Value Count';


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

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


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

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


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

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


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

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


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

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


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

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


ALTER SEQUENCE public.product_template_attribute_line_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.product_template_attribute_line_id_seq OWNED BY public.product_template_attribute_line.id;


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

CREATE TABLE public.product_template_attribute_value (
    id integer NOT NULL,
    product_attribute_value_id integer NOT NULL,
    attribute_line_id integer NOT NULL,
    product_tmpl_id integer,
    attribute_id integer,
    color integer,
    create_uid integer,
    write_uid integer,
    price_extra numeric,
    ptav_active boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.product_template_attribute_value OWNER TO odoo;

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

COMMENT ON TABLE public.product_template_attribute_value IS 'Product Template Attribute Value';


--
-- Name: COLUMN product_template_attribute_value.product_attribute_value_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template_attribute_value.product_attribute_value_id IS 'Attribute Value';


--
-- Name: COLUMN product_template_attribute_value.attribute_line_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template_attribute_value.attribute_line_id IS 'Attribute Line';


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

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


--
-- Name: COLUMN product_template_attribute_value.attribute_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template_attribute_value.attribute_id IS 'Attribute';


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

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


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

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


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

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


--
-- Name: COLUMN product_template_attribute_value.price_extra; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template_attribute_value.price_extra IS 'Extra Price';


--
-- Name: COLUMN product_template_attribute_value.ptav_active; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.product_template_attribute_value.ptav_active IS 'Active';


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

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


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

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


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

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


ALTER SEQUENCE public.product_template_attribute_value_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.product_template_attribute_value_id_seq OWNED BY public.product_template_attribute_value.id;


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

CREATE TABLE public.product_template_attribute_value_purchase_order_line_rel (
    purchase_order_line_id integer NOT NULL,
    product_template_attribute_value_id integer NOT NULL
);


ALTER TABLE public.product_template_attribute_value_purchase_order_line_rel OWNER TO odoo;

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

COMMENT ON TABLE public.product_template_attribute_value_purchase_order_line_rel IS 'RELATION BETWEEN purchase_order_line AND product_template_attribute_value';


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

CREATE TABLE public.product_template_attribute_value_sale_order_line_rel (
    sale_order_line_id integer NOT NULL,
    product_template_attribute_value_id integer NOT NULL
);


ALTER TABLE public.product_template_attribute_value_sale_order_line_rel OWNER TO odoo;

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

COMMENT ON TABLE public.product_template_attribute_value_sale_order_line_rel IS 'RELATION BETWEEN sale_order_line AND product_template_attribute_value';


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

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


ALTER SEQUENCE public.product_template_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.product_template_id_seq OWNED BY public.product_template.id;


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

CREATE TABLE public.product_variant_combination (
    product_product_id integer NOT NULL,
    product_template_attribute_value_id integer NOT NULL
);


ALTER TABLE public.product_variant_combination OWNER TO odoo;

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

COMMENT ON TABLE public.product_variant_combination IS 'RELATION BETWEEN product_product AND product_template_attribute_value';


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

CREATE TABLE public.project_collaborator (
    id integer NOT NULL,
    project_id integer NOT NULL,
    partner_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    limited_access boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.project_collaborator OWNER TO odoo;

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

COMMENT ON TABLE public.project_collaborator IS 'Collaborators in project shared';


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

COMMENT ON COLUMN public.project_collaborator.project_id IS 'Project Shared';


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

COMMENT ON COLUMN public.project_collaborator.partner_id IS 'Collaborator';


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

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


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

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


--
-- Name: COLUMN project_collaborator.limited_access; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_collaborator.limited_access IS 'Limited Access';


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

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


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

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


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

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


ALTER SEQUENCE public.project_collaborator_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.project_collaborator_id_seq OWNED BY public.project_collaborator.id;


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

CREATE TABLE public.project_favorite_user_rel (
    project_id integer NOT NULL,
    user_id integer NOT NULL
);


ALTER TABLE public.project_favorite_user_rel OWNER TO odoo;

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

COMMENT ON TABLE public.project_favorite_user_rel IS 'RELATION BETWEEN project_project AND res_users';


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

CREATE TABLE public.project_milestone (
    id integer NOT NULL,
    project_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    name character varying NOT NULL,
    deadline date,
    reached_date date,
    is_reached boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    sale_line_id integer,
    quantity_percentage double precision
);


ALTER TABLE public.project_milestone OWNER TO odoo;

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

COMMENT ON TABLE public.project_milestone IS 'Project Milestone';


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

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


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

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


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

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


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

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


--
-- Name: COLUMN project_milestone.deadline; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_milestone.deadline IS 'Deadline';


--
-- Name: COLUMN project_milestone.reached_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_milestone.reached_date IS 'Reached Date';


--
-- Name: COLUMN project_milestone.is_reached; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_milestone.is_reached IS 'Reached';


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

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


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

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


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

COMMENT ON COLUMN public.project_milestone.sale_line_id IS 'Sales Order Item';


--
-- Name: COLUMN project_milestone.quantity_percentage; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_milestone.quantity_percentage IS 'Quantity (%)';


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

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


ALTER SEQUENCE public.project_milestone_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.project_milestone_id_seq OWNED BY public.project_milestone.id;


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

CREATE TABLE public.project_project (
    id integer NOT NULL,
    account_id integer,
    alias_id integer NOT NULL,
    sequence integer,
    partner_id integer,
    company_id integer,
    color integer,
    user_id integer,
    stage_id integer,
    last_update_id integer,
    create_uid integer,
    write_uid integer,
    access_token character varying,
    privacy_visibility character varying NOT NULL,
    rating_status character varying NOT NULL,
    rating_status_period character varying NOT NULL,
    last_update_status character varying NOT NULL,
    date_start date,
    date date,
    name jsonb NOT NULL,
    label_tasks jsonb,
    task_properties_definition jsonb,
    description text,
    active boolean,
    allow_task_dependencies boolean,
    allow_milestones boolean,
    rating_active boolean,
    rating_request_deadline timestamp without time zone,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    sale_line_id integer,
    reinvoiced_sale_order_id integer,
    allow_billable boolean,
    CONSTRAINT project_project_project_date_greater CHECK ((date >= date_start))
);


ALTER TABLE public.project_project OWNER TO odoo;

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

COMMENT ON TABLE public.project_project IS 'Project';


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

COMMENT ON COLUMN public.project_project.account_id IS 'Project Account';


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

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


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

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


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

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


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

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


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

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


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

COMMENT ON COLUMN public.project_project.user_id IS 'Project Manager';


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

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


--
-- Name: COLUMN project_project.last_update_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_project.last_update_id IS 'Last Update';


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

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


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

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


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

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


--
-- Name: COLUMN project_project.privacy_visibility; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_project.privacy_visibility IS 'Visibility';


--
-- Name: COLUMN project_project.rating_status; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_project.rating_status IS 'Customer Ratings Status';


--
-- Name: COLUMN project_project.rating_status_period; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_project.rating_status_period IS 'Rating Frequency';


--
-- Name: COLUMN project_project.last_update_status; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_project.last_update_status IS 'Last Update Status';


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

COMMENT ON COLUMN public.project_project.date_start IS 'Start Date';


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

COMMENT ON COLUMN public.project_project.date IS 'Expiration Date';


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

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


--
-- Name: COLUMN project_project.label_tasks; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_project.label_tasks IS 'Use Tasks as';


--
-- Name: COLUMN project_project.task_properties_definition; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_project.task_properties_definition IS 'Task Properties';


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

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


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

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


--
-- Name: COLUMN project_project.allow_task_dependencies; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_project.allow_task_dependencies IS 'Task Dependencies';


--
-- Name: COLUMN project_project.allow_milestones; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_project.allow_milestones IS 'Milestones';


--
-- Name: COLUMN project_project.rating_active; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_project.rating_active IS 'Customer Ratings';


--
-- Name: COLUMN project_project.rating_request_deadline; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_project.rating_request_deadline IS 'Rating Request Deadline';


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

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


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

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


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

COMMENT ON COLUMN public.project_project.sale_line_id IS 'Sales Order Item';


--
-- Name: COLUMN project_project.reinvoiced_sale_order_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_project.reinvoiced_sale_order_id IS 'Sales Order';


--
-- Name: COLUMN project_project.allow_billable; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_project.allow_billable IS 'Billable';


--
-- Name: CONSTRAINT project_project_project_date_greater ON project_project; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT project_project_project_date_greater ON public.project_project IS 'check(date >= date_start)';


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

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


ALTER SEQUENCE public.project_project_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.project_project_id_seq OWNED BY public.project_project.id;


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

CREATE TABLE public.project_project_project_tags_rel (
    project_project_id integer NOT NULL,
    project_tags_id integer NOT NULL
);


ALTER TABLE public.project_project_project_tags_rel OWNER TO odoo;

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

COMMENT ON TABLE public.project_project_project_tags_rel IS 'RELATION BETWEEN project_project AND project_tags';


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

CREATE TABLE public.project_project_project_task_type_delete_wizard_rel (
    project_task_type_delete_wizard_id integer NOT NULL,
    project_project_id integer NOT NULL
);


ALTER TABLE public.project_project_project_task_type_delete_wizard_rel OWNER TO odoo;

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

COMMENT ON TABLE public.project_project_project_task_type_delete_wizard_rel IS 'RELATION BETWEEN project_task_type_delete_wizard AND project_project';


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

CREATE TABLE public.project_project_stage (
    id integer NOT NULL,
    sequence integer,
    mail_template_id integer,
    company_id integer,
    create_uid integer,
    write_uid integer,
    name jsonb NOT NULL,
    active boolean,
    fold boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    sms_template_id integer
);


ALTER TABLE public.project_project_stage OWNER TO odoo;

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

COMMENT ON TABLE public.project_project_stage IS 'Project Stage';


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

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


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

COMMENT ON COLUMN public.project_project_stage.mail_template_id IS 'Email Template';


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

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


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

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


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

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


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

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


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

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


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

COMMENT ON COLUMN public.project_project_stage.fold IS 'Folded in Kanban';


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

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


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

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


--
-- Name: COLUMN project_project_stage.sms_template_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_project_stage.sms_template_id IS 'SMS Template';


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

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


ALTER TABLE public.project_project_stage_delete_wizard OWNER TO odoo;

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

COMMENT ON TABLE public.project_project_stage_delete_wizard IS 'Project Stage Delete Wizard';


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

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


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

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


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

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


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

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


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

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


ALTER SEQUENCE public.project_project_stage_delete_wizard_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.project_project_stage_delete_wizard_id_seq OWNED BY public.project_project_stage_delete_wizard.id;


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

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


ALTER SEQUENCE public.project_project_stage_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.project_project_stage_id_seq OWNED BY public.project_project_stage.id;


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

CREATE TABLE public.project_project_stage_project_project_stage_delete_wizard_rel (
    project_project_stage_delete_wizard_id integer NOT NULL,
    project_project_stage_id integer NOT NULL
);


ALTER TABLE public.project_project_stage_project_project_stage_delete_wizard_rel OWNER TO odoo;

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

COMMENT ON TABLE public.project_project_stage_project_project_stage_delete_wizard_rel IS 'RELATION BETWEEN project_project_stage_delete_wizard AND project_project_stage';


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

CREATE TABLE public.project_share_collaborator_wizard (
    id integer NOT NULL,
    parent_wizard_id integer,
    partner_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    access_mode character varying NOT NULL,
    send_invitation boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.project_share_collaborator_wizard OWNER TO odoo;

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

COMMENT ON TABLE public.project_share_collaborator_wizard IS 'Project Sharing Collaborator Wizard';


--
-- Name: COLUMN project_share_collaborator_wizard.parent_wizard_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_share_collaborator_wizard.parent_wizard_id IS 'Parent Wizard';


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

COMMENT ON COLUMN public.project_share_collaborator_wizard.partner_id IS 'Collaborator';


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

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


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

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


--
-- Name: COLUMN project_share_collaborator_wizard.access_mode; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_share_collaborator_wizard.access_mode IS 'Access Mode';


--
-- Name: COLUMN project_share_collaborator_wizard.send_invitation; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_share_collaborator_wizard.send_invitation IS 'Send Invitation';


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

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


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

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


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

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


ALTER SEQUENCE public.project_share_collaborator_wizard_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.project_share_collaborator_wizard_id_seq OWNED BY public.project_share_collaborator_wizard.id;


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

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


ALTER TABLE public.project_share_wizard OWNER TO odoo;

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

COMMENT ON TABLE public.project_share_wizard IS 'Project Sharing';


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


ALTER SEQUENCE public.project_share_wizard_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.project_share_wizard_id_seq OWNED BY public.project_share_wizard.id;


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

CREATE TABLE public.project_share_wizard_res_partner_rel (
    project_share_wizard_id integer NOT NULL,
    res_partner_id integer NOT NULL
);


ALTER TABLE public.project_share_wizard_res_partner_rel OWNER TO odoo;

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

COMMENT ON TABLE public.project_share_wizard_res_partner_rel IS 'RELATION BETWEEN project_share_wizard AND res_partner';


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

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


ALTER TABLE public.project_tags OWNER TO odoo;

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

COMMENT ON TABLE public.project_tags IS 'Project Tags';


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

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


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

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


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

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


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

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


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

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


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

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


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

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


ALTER SEQUENCE public.project_tags_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.project_tags_id_seq OWNED BY public.project_tags.id;


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

CREATE TABLE public.project_tags_project_task_rel (
    project_task_id integer NOT NULL,
    project_tags_id integer NOT NULL
);


ALTER TABLE public.project_tags_project_task_rel OWNER TO odoo;

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

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


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

CREATE TABLE public.project_task (
    id integer NOT NULL,
    sequence integer,
    stage_id integer,
    project_id integer,
    partner_id integer,
    company_id integer,
    color integer,
    displayed_image_id integer,
    parent_id integer,
    milestone_id integer,
    recurrence_id integer,
    create_uid integer,
    write_uid integer,
    email_cc character varying,
    access_token character varying,
    name character varying NOT NULL,
    priority character varying,
    state character varying NOT NULL,
    html_field_history jsonb,
    task_properties jsonb,
    description text,
    working_hours_open numeric,
    working_hours_close numeric,
    active boolean,
    display_in_project boolean,
    recurring_task boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    date_end timestamp without time zone,
    date_assign timestamp without time zone,
    date_deadline timestamp without time zone,
    date_last_stage_update timestamp without time zone,
    rating_last_value double precision,
    allocated_hours double precision,
    working_days_open double precision,
    working_days_close double precision,
    sale_order_id integer,
    sale_line_id integer,
    CONSTRAINT project_task_private_task_has_no_parent CHECK ((NOT ((project_id IS NULL) AND (parent_id IS NOT NULL)))),
    CONSTRAINT project_task_recurring_task_has_no_parent CHECK ((NOT ((recurring_task IS TRUE) AND (parent_id IS NOT NULL))))
);


ALTER TABLE public.project_task OWNER TO odoo;

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

COMMENT ON TABLE public.project_task IS 'Task';


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

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


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

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


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

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


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

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


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

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


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

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


--
-- Name: COLUMN project_task.displayed_image_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task.displayed_image_id IS 'Cover Image';


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

COMMENT ON COLUMN public.project_task.parent_id IS 'Parent Task';


--
-- Name: COLUMN project_task.milestone_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task.milestone_id IS 'Milestone';


--
-- Name: COLUMN project_task.recurrence_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task.recurrence_id IS 'Recurrence';


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

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


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

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


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

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


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

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


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

COMMENT ON COLUMN public.project_task.name IS 'Title';


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

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


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

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


--
-- Name: COLUMN project_task.html_field_history; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task.html_field_history IS 'History data';


--
-- Name: COLUMN project_task.task_properties; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task.task_properties IS 'Properties';


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

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


--
-- Name: COLUMN project_task.working_hours_open; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task.working_hours_open IS 'Working Hours to Assign';


--
-- Name: COLUMN project_task.working_hours_close; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task.working_hours_close IS 'Working Hours to Close';


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

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


--
-- Name: COLUMN project_task.display_in_project; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task.display_in_project IS 'Display In Project';


--
-- Name: COLUMN project_task.recurring_task; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task.recurring_task IS 'Recurrent';


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

COMMENT ON COLUMN public.project_task.create_date IS 'Created On';


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

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


--
-- Name: COLUMN project_task.date_end; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task.date_end IS 'Ending Date';


--
-- Name: COLUMN project_task.date_assign; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task.date_assign IS 'Assigning Date';


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

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


--
-- Name: COLUMN project_task.date_last_stage_update; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task.date_last_stage_update IS 'Last Stage Update';


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

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


--
-- Name: COLUMN project_task.allocated_hours; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task.allocated_hours IS 'Allocated Time';


--
-- Name: COLUMN project_task.working_days_open; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task.working_days_open IS 'Working Days to Assign';


--
-- Name: COLUMN project_task.working_days_close; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task.working_days_close IS 'Working Days to Close';


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

COMMENT ON COLUMN public.project_task.sale_order_id IS 'Sales Order';


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

COMMENT ON COLUMN public.project_task.sale_line_id IS 'Sales Order Item';


--
-- Name: CONSTRAINT project_task_private_task_has_no_parent ON project_task; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT project_task_private_task_has_no_parent ON public.project_task IS 'CHECK (NOT (project_id IS NULL AND parent_id IS NOT NULL))';


--
-- Name: CONSTRAINT project_task_recurring_task_has_no_parent ON project_task; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT project_task_recurring_task_has_no_parent ON public.project_task IS 'CHECK (NOT (recurring_task IS TRUE AND parent_id IS NOT NULL))';


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

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


ALTER SEQUENCE public.project_task_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.project_task_id_seq OWNED BY public.project_task.id;


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

CREATE TABLE public.project_task_recurrence (
    id integer NOT NULL,
    repeat_interval integer,
    create_uid integer,
    write_uid integer,
    repeat_unit character varying,
    repeat_type character varying,
    repeat_until date,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.project_task_recurrence OWNER TO odoo;

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

COMMENT ON TABLE public.project_task_recurrence IS 'Task Recurrence';


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


ALTER SEQUENCE public.project_task_recurrence_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.project_task_recurrence_id_seq OWNED BY public.project_task_recurrence.id;


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

CREATE TABLE public.project_task_type (
    id integer NOT NULL,
    sequence integer,
    mail_template_id integer,
    rating_template_id integer,
    user_id integer,
    create_uid integer,
    write_uid integer,
    name jsonb NOT NULL,
    active boolean,
    fold boolean,
    auto_validation_state boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    sms_template_id integer
);


ALTER TABLE public.project_task_type OWNER TO odoo;

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

COMMENT ON TABLE public.project_task_type IS 'Task Stage';


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

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


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

COMMENT ON COLUMN public.project_task_type.mail_template_id IS 'Email Template';


--
-- Name: COLUMN project_task_type.rating_template_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task_type.rating_template_id IS 'Rating Email Template';


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

COMMENT ON COLUMN public.project_task_type.user_id IS 'Stage Owner';


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

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


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

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


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

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


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

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


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

COMMENT ON COLUMN public.project_task_type.fold IS 'Folded in Kanban';


--
-- Name: COLUMN project_task_type.auto_validation_state; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task_type.auto_validation_state IS 'Automatic Kanban Status';


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

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


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

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


--
-- Name: COLUMN project_task_type.sms_template_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task_type.sms_template_id IS 'SMS Template';


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

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


ALTER TABLE public.project_task_type_delete_wizard OWNER TO odoo;

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

COMMENT ON TABLE public.project_task_type_delete_wizard IS 'Project Task Stage Delete Wizard';


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

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


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

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


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

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


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

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


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

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


ALTER SEQUENCE public.project_task_type_delete_wizard_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.project_task_type_delete_wizard_id_seq OWNED BY public.project_task_type_delete_wizard.id;


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

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


ALTER SEQUENCE public.project_task_type_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.project_task_type_id_seq OWNED BY public.project_task_type.id;


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

CREATE TABLE public.project_task_type_project_task_type_delete_wizard_rel (
    project_task_type_delete_wizard_id integer NOT NULL,
    project_task_type_id integer NOT NULL
);


ALTER TABLE public.project_task_type_project_task_type_delete_wizard_rel OWNER TO odoo;

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

COMMENT ON TABLE public.project_task_type_project_task_type_delete_wizard_rel IS 'RELATION BETWEEN project_task_type_delete_wizard AND project_task_type';


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

CREATE TABLE public.project_task_type_rel (
    project_id integer NOT NULL,
    type_id integer NOT NULL
);


ALTER TABLE public.project_task_type_rel OWNER TO odoo;

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

COMMENT ON TABLE public.project_task_type_rel IS 'RELATION BETWEEN project_project AND project_task_type';


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

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


ALTER TABLE public.project_task_user_rel OWNER TO odoo;

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

COMMENT ON TABLE public.project_task_user_rel IS 'Personal Task Stage';


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

COMMENT ON COLUMN public.project_task_user_rel.task_id IS 'Task';


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

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


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

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


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

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


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

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


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

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


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

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


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

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


ALTER SEQUENCE public.project_task_user_rel_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.project_task_user_rel_id_seq OWNED BY public.project_task_user_rel.id;


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

CREATE TABLE public.project_update (
    id integer NOT NULL,
    progress integer,
    user_id integer NOT NULL,
    project_id integer NOT NULL,
    task_count integer,
    closed_task_count integer,
    create_uid integer,
    write_uid integer,
    email_cc character varying,
    name character varying NOT NULL,
    status character varying NOT NULL,
    date date,
    description text,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.project_update OWNER TO odoo;

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

COMMENT ON TABLE public.project_update IS 'Project Update';


--
-- Name: COLUMN project_update.progress; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_update.progress IS 'Progress';


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

COMMENT ON COLUMN public.project_update.user_id IS 'Author';


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

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


--
-- Name: COLUMN project_update.task_count; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_update.task_count IS 'Task Count';


--
-- Name: COLUMN project_update.closed_task_count; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_update.closed_task_count IS 'Closed Task Count';


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

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


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

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


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

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


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

COMMENT ON COLUMN public.project_update.name IS 'Title';


--
-- Name: COLUMN project_update.status; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_update.status IS 'Status';


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

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


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

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


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

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


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

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


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

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


ALTER SEQUENCE public.project_update_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.project_update_id_seq OWNED BY public.project_update.id;


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

CREATE TABLE public.purchase_order (
    id integer NOT NULL,
    partner_id integer NOT NULL,
    dest_address_id integer,
    currency_id integer NOT NULL,
    invoice_count integer,
    fiscal_position_id integer,
    payment_term_id integer,
    incoterm_id integer,
    user_id integer,
    company_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    access_token character varying,
    name character varying NOT NULL,
    priority character varying,
    origin character varying,
    partner_ref character varying,
    state character varying,
    invoice_status character varying,
    notes text,
    amount_untaxed numeric,
    amount_tax numeric,
    amount_total numeric,
    amount_total_cc numeric,
    currency_rate numeric,
    mail_reminder_confirmed boolean,
    mail_reception_confirmed boolean,
    mail_reception_declined boolean,
    date_order timestamp without time zone NOT NULL,
    date_approve timestamp without time zone,
    date_planned timestamp without time zone,
    date_calendar_start timestamp without time zone,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    project_id integer,
    picking_type_id integer NOT NULL,
    group_id integer,
    incoterm_location character varying,
    receipt_status character varying,
    effective_date timestamp without time zone
);


ALTER TABLE public.purchase_order OWNER TO odoo;

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

COMMENT ON TABLE public.purchase_order IS 'Purchase Order';


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

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


--
-- Name: COLUMN purchase_order.dest_address_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.purchase_order.dest_address_id IS 'Dropship Address';


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

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


--
-- Name: COLUMN purchase_order.invoice_count; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.purchase_order.invoice_count IS 'Bill Count';


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

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


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

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


--
-- Name: COLUMN purchase_order.incoterm_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.purchase_order.incoterm_id IS 'Incoterm';


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

COMMENT ON COLUMN public.purchase_order.user_id IS 'Buyer';


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

COMMENT ON COLUMN public.purchase_order.invoice_status IS 'Billing Status';


--
-- Name: COLUMN purchase_order.notes; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.purchase_order.notes IS 'Terms and Conditions';


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

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


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

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


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

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


--
-- Name: COLUMN purchase_order.amount_total_cc; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.purchase_order.amount_total_cc IS 'Company Total';


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

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


--
-- Name: COLUMN purchase_order.mail_reminder_confirmed; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.purchase_order.mail_reminder_confirmed IS 'Reminder Confirmed';


--
-- Name: COLUMN purchase_order.mail_reception_confirmed; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.purchase_order.mail_reception_confirmed IS 'Reception Confirmed';


--
-- Name: COLUMN purchase_order.mail_reception_declined; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.purchase_order.mail_reception_declined IS 'Reception Declined';


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

COMMENT ON COLUMN public.purchase_order.date_order IS 'Order Deadline';


--
-- Name: COLUMN purchase_order.date_approve; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.purchase_order.date_approve IS 'Confirmation Date';


--
-- Name: COLUMN purchase_order.date_planned; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.purchase_order.date_planned IS 'Expected Arrival';


--
-- Name: COLUMN purchase_order.date_calendar_start; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.purchase_order.date_calendar_start IS 'Date Calendar Start';


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

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


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

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


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

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


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

COMMENT ON COLUMN public.purchase_order.picking_type_id IS 'Deliver To';


--
-- Name: COLUMN purchase_order.group_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.purchase_order.group_id IS 'Procurement Group';


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

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


--
-- Name: COLUMN purchase_order.receipt_status; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.purchase_order.receipt_status IS 'Receipt Status';


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

COMMENT ON COLUMN public.purchase_order.effective_date IS 'Arrival';


--
-- Name: purchase_bill_union; Type: VIEW; Schema: public; Owner: odoo
--

CREATE VIEW public.purchase_bill_union AS
 SELECT account_move.id,
    account_move.name,
    account_move.ref AS reference,
    account_move.partner_id,
    account_move.date,
    account_move.amount_untaxed AS amount,
    account_move.currency_id,
    account_move.company_id,
    account_move.id AS vendor_bill_id,
    NULL::integer AS purchase_order_id
   FROM public.account_move
  WHERE (((account_move.move_type)::text = 'in_invoice'::text) AND ((account_move.state)::text = 'posted'::text))
UNION
 SELECT (- purchase_order.id) AS id,
    purchase_order.name,
    purchase_order.partner_ref AS reference,
    purchase_order.partner_id,
    (purchase_order.date_order)::date AS date,
    purchase_order.amount_untaxed AS amount,
    purchase_order.currency_id,
    purchase_order.company_id,
    NULL::integer AS vendor_bill_id,
    purchase_order.id AS purchase_order_id
   FROM public.purchase_order
  WHERE (((purchase_order.state)::text = ANY ((ARRAY['purchase'::character varying, 'done'::character varying])::text[])) AND ((purchase_order.invoice_status)::text = ANY ((ARRAY['to invoice'::character varying, 'no'::character varying])::text[])));


ALTER VIEW public.purchase_bill_union OWNER TO odoo;

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

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


ALTER SEQUENCE public.purchase_order_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.purchase_order_id_seq OWNED BY public.purchase_order.id;


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

CREATE TABLE public.purchase_order_line (
    id integer NOT NULL,
    sequence integer,
    product_uom integer,
    product_id integer,
    order_id integer NOT NULL,
    company_id integer,
    partner_id integer,
    currency_id integer,
    product_packaging_id integer,
    create_uid integer,
    write_uid integer,
    state character varying,
    qty_received_method character varying,
    display_type character varying,
    analytic_distribution jsonb,
    name text NOT NULL,
    product_qty numeric NOT NULL,
    discount numeric,
    price_unit numeric NOT NULL,
    price_subtotal numeric,
    price_total numeric,
    qty_invoiced numeric,
    qty_received numeric,
    qty_received_manual numeric,
    qty_to_invoice numeric,
    is_downpayment boolean,
    date_planned timestamp without time zone,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    product_uom_qty double precision,
    price_tax double precision,
    product_packaging_qty double precision,
    orderpoint_id integer,
    location_final_id integer,
    group_id integer,
    product_description_variants character varying,
    propagate_cancel boolean,
    sale_order_id integer,
    sale_line_id integer,
    CONSTRAINT purchase_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) AND (date_planned IS NOT NULL)))),
    CONSTRAINT purchase_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)::double precision) AND (product_uom IS NULL) AND (date_planned IS NULL))))
);


ALTER TABLE public.purchase_order_line OWNER TO odoo;

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

COMMENT ON TABLE public.purchase_order_line IS 'Purchase Order Line';


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


--
-- Name: COLUMN purchase_order_line.qty_received_method; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.purchase_order_line.qty_received_method IS 'Received Qty Method';


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

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


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

COMMENT ON COLUMN public.purchase_order_line.analytic_distribution IS 'Analytic Distribution';


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

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


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

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


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

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


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

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


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

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


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

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


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

COMMENT ON COLUMN public.purchase_order_line.qty_invoiced IS 'Billed Qty';


--
-- Name: COLUMN purchase_order_line.qty_received; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.purchase_order_line.qty_received IS 'Received Qty';


--
-- Name: COLUMN purchase_order_line.qty_received_manual; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.purchase_order_line.qty_received_manual IS 'Manual Received Qty';


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

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


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

COMMENT ON COLUMN public.purchase_order_line.is_downpayment IS 'Is Downpayment';


--
-- Name: COLUMN purchase_order_line.date_planned; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.purchase_order_line.date_planned IS 'Expected Arrival';


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

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


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

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


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

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


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

COMMENT ON COLUMN public.purchase_order_line.price_tax IS 'Tax';


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

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


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

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


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

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


--
-- Name: COLUMN purchase_order_line.group_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.purchase_order_line.group_id IS 'Procurement group that generated this line';


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

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


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

COMMENT ON COLUMN public.purchase_order_line.propagate_cancel IS 'Propagate cancellation';


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

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


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

COMMENT ON COLUMN public.purchase_order_line.sale_line_id IS 'Origin Sale Item';


--
-- Name: CONSTRAINT purchase_order_line_accountable_required_fields ON purchase_order_line; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT purchase_order_line_accountable_required_fields ON public.purchase_order_line IS 'CHECK(display_type IS NOT NULL OR is_downpayment OR (product_id IS NOT NULL AND product_uom IS NOT NULL AND date_planned IS NOT NULL))';


--
-- Name: CONSTRAINT purchase_order_line_non_accountable_null_fields ON purchase_order_line; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT purchase_order_line_non_accountable_null_fields ON public.purchase_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 date_planned is NULL))';


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

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


ALTER SEQUENCE public.purchase_order_line_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.purchase_order_line_id_seq OWNED BY public.purchase_order_line.id;


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

CREATE TABLE public.purchase_order_stock_picking_rel (
    purchase_order_id integer NOT NULL,
    stock_picking_id integer NOT NULL
);


ALTER TABLE public.purchase_order_stock_picking_rel OWNER TO odoo;

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

COMMENT ON TABLE public.purchase_order_stock_picking_rel IS 'RELATION BETWEEN purchase_order AND stock_picking';


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

CREATE TABLE public.quotation_document (
    id integer NOT NULL,
    ir_attachment_id integer NOT NULL,
    sequence integer,
    create_uid integer,
    write_uid integer,
    document_type character varying NOT NULL,
    active boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.quotation_document OWNER TO odoo;

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

COMMENT ON TABLE public.quotation_document IS 'Quotation''s Headers & Footers';


--
-- Name: COLUMN quotation_document.ir_attachment_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.quotation_document.ir_attachment_id IS 'Related attachment';


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


ALTER SEQUENCE public.quotation_document_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.quotation_document_id_seq OWNED BY public.quotation_document.id;


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

CREATE TABLE public.quotation_document_sale_order_rel (
    sale_order_id integer NOT NULL,
    quotation_document_id integer NOT NULL
);


ALTER TABLE public.quotation_document_sale_order_rel OWNER TO odoo;

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

COMMENT ON TABLE public.quotation_document_sale_order_rel IS 'RELATION BETWEEN sale_order AND quotation_document';


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

CREATE TABLE public.quotation_document_sale_pdf_form_field_rel (
    quotation_document_id integer NOT NULL,
    sale_pdf_form_field_id integer NOT NULL
);


ALTER TABLE public.quotation_document_sale_pdf_form_field_rel OWNER TO odoo;

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

COMMENT ON TABLE public.quotation_document_sale_pdf_form_field_rel IS 'RELATION BETWEEN quotation_document AND sale_pdf_form_field';


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

CREATE TABLE public.rating_rating (
    id integer NOT NULL,
    res_model_id integer,
    res_id integer NOT NULL,
    parent_res_model_id integer,
    parent_res_id integer,
    rated_partner_id integer,
    partner_id integer,
    message_id integer,
    create_uid integer,
    write_uid integer,
    res_name character varying,
    res_model character varying,
    parent_res_name character varying,
    parent_res_model character varying,
    rating_text character varying,
    access_token character varying,
    feedback text,
    is_internal boolean,
    consumed boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    rating double precision,
    publisher_id integer,
    publisher_comment text,
    publisher_datetime timestamp without time zone,
    CONSTRAINT rating_rating_rating_range CHECK (((rating >= (0)::double precision) AND (rating <= (5)::double precision)))
);


ALTER TABLE public.rating_rating OWNER TO odoo;

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

COMMENT ON TABLE public.rating_rating IS 'Rating';


--
-- Name: COLUMN rating_rating.res_model_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.rating_rating.res_model_id IS 'Related Document Model';


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

COMMENT ON COLUMN public.rating_rating.res_id IS 'Document';


--
-- Name: COLUMN rating_rating.parent_res_model_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.rating_rating.parent_res_model_id IS 'Parent Related Document Model';


--
-- Name: COLUMN rating_rating.parent_res_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.rating_rating.parent_res_id IS 'Parent Document';


--
-- Name: COLUMN rating_rating.rated_partner_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.rating_rating.rated_partner_id IS 'Rated Operator';


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

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


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

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


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

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


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

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


--
-- Name: COLUMN rating_rating.res_name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.rating_rating.res_name IS 'Resource name';


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

COMMENT ON COLUMN public.rating_rating.res_model IS 'Document Model';


--
-- Name: COLUMN rating_rating.parent_res_name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.rating_rating.parent_res_name IS 'Parent Document Name';


--
-- Name: COLUMN rating_rating.parent_res_model; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.rating_rating.parent_res_model IS 'Parent Document Model';


--
-- Name: COLUMN rating_rating.rating_text; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.rating_rating.rating_text IS 'Rating';


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

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


--
-- Name: COLUMN rating_rating.feedback; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.rating_rating.feedback IS 'Comment';


--
-- Name: COLUMN rating_rating.is_internal; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.rating_rating.is_internal IS 'Visible Internally Only';


--
-- Name: COLUMN rating_rating.consumed; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.rating_rating.consumed IS 'Filled Rating';


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

COMMENT ON COLUMN public.rating_rating.create_date IS 'Submitted on';


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

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


--
-- Name: COLUMN rating_rating.rating; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.rating_rating.rating IS 'Rating Value';


--
-- Name: COLUMN rating_rating.publisher_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.rating_rating.publisher_id IS 'Commented by';


--
-- Name: COLUMN rating_rating.publisher_comment; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.rating_rating.publisher_comment IS 'Publisher comment';


--
-- Name: COLUMN rating_rating.publisher_datetime; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.rating_rating.publisher_datetime IS 'Commented on';


--
-- Name: CONSTRAINT rating_rating_rating_range ON rating_rating; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT rating_rating_rating_range ON public.rating_rating IS 'check(rating >= 0 and rating <= 5)';


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

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


ALTER SEQUENCE public.rating_rating_id_seq OWNER TO odoo;

--
-- Name: rating_rating_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.rating_rating_id_seq OWNED BY public.rating_rating.id;


--
-- Name: rel_badge_auth_users; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.rel_badge_auth_users (
    gamification_badge_id integer NOT NULL,
    res_users_id integer NOT NULL
);


ALTER TABLE public.rel_badge_auth_users OWNER TO odoo;

--
-- Name: TABLE rel_badge_auth_users; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.rel_badge_auth_users IS 'RELATION BETWEEN gamification_badge AND res_users';


--
-- Name: rel_modules_langexport; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.rel_modules_langexport (
    wiz_id integer NOT NULL,
    module_id integer NOT NULL
);


ALTER TABLE public.rel_modules_langexport OWNER TO odoo;

--
-- Name: TABLE rel_modules_langexport; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.rel_modules_langexport IS 'RELATION BETWEEN base_language_export AND ir_module_module';


--
-- Name: rel_server_actions; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.rel_server_actions (
    server_id integer NOT NULL,
    action_id integer NOT NULL
);


ALTER TABLE public.rel_server_actions OWNER TO odoo;

--
-- Name: TABLE rel_server_actions; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.rel_server_actions IS 'RELATION BETWEEN ir_act_server AND ir_act_server';


--
-- Name: repair_order; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.repair_order (
    id integer NOT NULL,
    company_id integer NOT NULL,
    partner_id integer,
    user_id integer,
    move_id integer,
    product_id integer,
    product_uom integer,
    lot_id integer,
    picking_type_id integer NOT NULL,
    procurement_group_id integer,
    location_id integer NOT NULL,
    product_location_src_id integer NOT NULL,
    product_location_dest_id integer NOT NULL,
    location_dest_id integer NOT NULL,
    parts_location_id integer NOT NULL,
    recycle_location_id integer NOT NULL,
    sale_order_id integer,
    sale_order_line_id integer,
    picking_id integer,
    create_uid integer,
    write_uid integer,
    name character varying NOT NULL,
    state character varying,
    priority character varying,
    repair_properties jsonb,
    internal_notes text,
    product_qty numeric,
    under_warranty boolean,
    is_parts_available boolean,
    is_parts_late boolean,
    schedule_date timestamp without time zone NOT NULL,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.repair_order OWNER TO odoo;

--
-- Name: TABLE repair_order; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.repair_order IS 'Repair Order';


--
-- Name: COLUMN repair_order.company_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_order.company_id IS 'Company';


--
-- Name: COLUMN repair_order.partner_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_order.partner_id IS 'Customer';


--
-- Name: COLUMN repair_order.user_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_order.user_id IS 'Responsible';


--
-- Name: COLUMN repair_order.move_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_order.move_id IS 'Inventory Move';


--
-- Name: COLUMN repair_order.product_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_order.product_id IS 'Product to Repair';


--
-- Name: COLUMN repair_order.product_uom; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_order.product_uom IS 'Product Unit of Measure';


--
-- Name: COLUMN repair_order.lot_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_order.lot_id IS 'Lot/Serial';


--
-- Name: COLUMN repair_order.picking_type_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_order.picking_type_id IS 'Operation Type';


--
-- Name: COLUMN repair_order.procurement_group_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_order.procurement_group_id IS 'Procurement Group';


--
-- Name: COLUMN repair_order.location_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_order.location_id IS 'Component Source Location';


--
-- Name: COLUMN repair_order.product_location_src_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_order.product_location_src_id IS 'Product Source Location';


--
-- Name: COLUMN repair_order.product_location_dest_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_order.product_location_dest_id IS 'Product Destination Location';


--
-- Name: COLUMN repair_order.location_dest_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_order.location_dest_id IS 'Added Parts Destination Location';


--
-- Name: COLUMN repair_order.parts_location_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_order.parts_location_id IS 'Removed Parts Destination Location';


--
-- Name: COLUMN repair_order.recycle_location_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_order.recycle_location_id IS 'Recycled Parts Destination Location';


--
-- Name: COLUMN repair_order.sale_order_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_order.sale_order_id IS 'Sale Order';


--
-- Name: COLUMN repair_order.sale_order_line_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_order.sale_order_line_id IS 'Sale Order Line';


--
-- Name: COLUMN repair_order.picking_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_order.picking_id IS 'Return';


--
-- Name: COLUMN repair_order.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_order.create_uid IS 'Created by';


--
-- Name: COLUMN repair_order.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_order.write_uid IS 'Last Updated by';


--
-- Name: COLUMN repair_order.name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_order.name IS 'Repair Reference';


--
-- Name: COLUMN repair_order.state; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_order.state IS 'Status';


--
-- Name: COLUMN repair_order.priority; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_order.priority IS 'Priority';


--
-- Name: COLUMN repair_order.repair_properties; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_order.repair_properties IS 'Properties';


--
-- Name: COLUMN repair_order.internal_notes; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_order.internal_notes IS 'Internal Notes';


--
-- Name: COLUMN repair_order.product_qty; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_order.product_qty IS 'Product Quantity';


--
-- Name: COLUMN repair_order.under_warranty; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_order.under_warranty IS 'Under Warranty';


--
-- Name: COLUMN repair_order.is_parts_available; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_order.is_parts_available IS 'All Parts are available';


--
-- Name: COLUMN repair_order.is_parts_late; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_order.is_parts_late IS 'Any Part is late';


--
-- Name: COLUMN repair_order.schedule_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_order.schedule_date IS 'Scheduled Date';


--
-- Name: COLUMN repair_order.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_order.create_date IS 'Created on';


--
-- Name: COLUMN repair_order.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_order.write_date IS 'Last Updated on';


--
-- Name: repair_order_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.repair_order_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.repair_order_id_seq OWNER TO odoo;

--
-- Name: repair_order_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.repair_order_id_seq OWNED BY public.repair_order.id;


--
-- Name: repair_order_repair_tags_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.repair_order_repair_tags_rel (
    repair_order_id integer NOT NULL,
    repair_tags_id integer NOT NULL
);


ALTER TABLE public.repair_order_repair_tags_rel OWNER TO odoo;

--
-- Name: TABLE repair_order_repair_tags_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.repair_order_repair_tags_rel IS 'RELATION BETWEEN repair_order AND repair_tags';


--
-- Name: repair_tags; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.repair_tags (
    id integer NOT NULL,
    color integer,
    create_uid integer,
    write_uid integer,
    name character varying NOT NULL,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.repair_tags OWNER TO odoo;

--
-- Name: TABLE repair_tags; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.repair_tags IS 'Repair Tags';


--
-- Name: COLUMN repair_tags.color; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_tags.color IS 'Color Index';


--
-- Name: COLUMN repair_tags.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_tags.create_uid IS 'Created by';


--
-- Name: COLUMN repair_tags.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_tags.write_uid IS 'Last Updated by';


--
-- Name: COLUMN repair_tags.name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_tags.name IS 'Tag Name';


--
-- Name: COLUMN repair_tags.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_tags.create_date IS 'Created on';


--
-- Name: COLUMN repair_tags.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_tags.write_date IS 'Last Updated on';


--
-- Name: repair_tags_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.repair_tags_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.repair_tags_id_seq OWNER TO odoo;

--
-- Name: repair_tags_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.repair_tags_id_seq OWNED BY public.repair_tags.id;


--
-- Name: report_layout; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.report_layout (
    id integer NOT NULL,
    view_id integer NOT NULL,
    sequence integer,
    create_uid integer,
    write_uid integer,
    image character varying,
    pdf character varying,
    name character varying,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.report_layout OWNER TO odoo;

--
-- Name: TABLE report_layout; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.report_layout IS 'Report Layout';


--
-- Name: COLUMN report_layout.view_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.report_layout.view_id IS 'Document Template';


--
-- Name: COLUMN report_layout.sequence; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.report_layout.sequence IS 'Sequence';


--
-- Name: COLUMN report_layout.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.report_layout.create_uid IS 'Created by';


--
-- Name: COLUMN report_layout.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.report_layout.write_uid IS 'Last Updated by';


--
-- Name: COLUMN report_layout.image; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.report_layout.image IS 'Preview image src';


--
-- Name: COLUMN report_layout.pdf; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.report_layout.pdf IS 'Preview pdf src';


--
-- Name: COLUMN report_layout.name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.report_layout.name IS 'Name';


--
-- Name: COLUMN report_layout.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.report_layout.create_date IS 'Created on';


--
-- Name: COLUMN report_layout.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.report_layout.write_date IS 'Last Updated on';


--
-- Name: report_layout_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.report_layout_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.report_layout_id_seq OWNER TO odoo;

--
-- Name: report_layout_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.report_layout_id_seq OWNED BY public.report_layout.id;


--
-- Name: report_paperformat; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.report_paperformat (
    id integer NOT NULL,
    page_height integer,
    page_width integer,
    header_spacing integer,
    dpi integer NOT NULL,
    create_uid integer,
    write_uid integer,
    name character varying NOT NULL,
    format character varying,
    orientation character varying,
    "default" boolean,
    header_line boolean,
    disable_shrinking boolean,
    css_margins boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    margin_top double precision,
    margin_bottom double precision,
    margin_left double precision,
    margin_right double precision
);


ALTER TABLE public.report_paperformat OWNER TO odoo;

--
-- Name: TABLE report_paperformat; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.report_paperformat IS 'Paper Format Config';


--
-- Name: COLUMN report_paperformat.page_height; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.report_paperformat.page_height IS 'Page height (mm)';


--
-- Name: COLUMN report_paperformat.page_width; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.report_paperformat.page_width IS 'Page width (mm)';


--
-- Name: COLUMN report_paperformat.header_spacing; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.report_paperformat.header_spacing IS 'Header spacing';


--
-- Name: COLUMN report_paperformat.dpi; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.report_paperformat.dpi IS 'Output DPI';


--
-- Name: COLUMN report_paperformat.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.report_paperformat.create_uid IS 'Created by';


--
-- Name: COLUMN report_paperformat.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.report_paperformat.write_uid IS 'Last Updated by';


--
-- Name: COLUMN report_paperformat.name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.report_paperformat.name IS 'Name';


--
-- Name: COLUMN report_paperformat.format; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.report_paperformat.format IS 'Paper size';


--
-- Name: COLUMN report_paperformat.orientation; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.report_paperformat.orientation IS 'Orientation';


--
-- Name: COLUMN report_paperformat."default"; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.report_paperformat."default" IS 'Default paper format?';


--
-- Name: COLUMN report_paperformat.header_line; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.report_paperformat.header_line IS 'Display a header line';


--
-- Name: COLUMN report_paperformat.disable_shrinking; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.report_paperformat.disable_shrinking IS 'Disable smart shrinking';


--
-- Name: COLUMN report_paperformat.css_margins; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.report_paperformat.css_margins IS 'Use css margins';


--
-- Name: COLUMN report_paperformat.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.report_paperformat.create_date IS 'Created on';


--
-- Name: COLUMN report_paperformat.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.report_paperformat.write_date IS 'Last Updated on';


--
-- Name: COLUMN report_paperformat.margin_top; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.report_paperformat.margin_top IS 'Top Margin (mm)';


--
-- Name: COLUMN report_paperformat.margin_bottom; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.report_paperformat.margin_bottom IS 'Bottom Margin (mm)';


--
-- Name: COLUMN report_paperformat.margin_left; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.report_paperformat.margin_left IS 'Left Margin (mm)';


--
-- Name: COLUMN report_paperformat.margin_right; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.report_paperformat.margin_right IS 'Right Margin (mm)';


--
-- Name: report_paperformat_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.report_paperformat_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.report_paperformat_id_seq OWNER TO odoo;

--
-- Name: report_paperformat_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.report_paperformat_id_seq OWNED BY public.report_paperformat.id;


--
-- Name: report_project_task_user; Type: VIEW; Schema: public; Owner: odoo
--

CREATE VIEW public.report_project_task_user AS
SELECT
    NULL::integer AS nbr,
    NULL::integer AS id,
    NULL::integer AS task_id,
    NULL::boolean AS active,
    NULL::timestamp without time zone AS create_date,
    NULL::timestamp without time zone AS date_assign,
    NULL::timestamp without time zone AS date_end,
    NULL::timestamp without time zone AS date_last_stage_update,
    NULL::timestamp without time zone AS date_deadline,
    NULL::integer AS project_id,
    NULL::character varying AS priority,
    NULL::character varying AS name,
    NULL::integer AS company_id,
    NULL::integer AS partner_id,
    NULL::integer AS parent_id,
    NULL::integer AS stage_id,
    NULL::character varying AS state,
    NULL::integer AS milestone_id,
    NULL::boolean AS is_closed,
    NULL::boolean AS has_late_and_unreached_milestone,
    NULL::text AS description,
    NULL::double precision AS rating_last_value,
    NULL::double precision AS rating_avg,
    NULL::double precision AS working_days_close,
    NULL::double precision AS working_days_open,
    NULL::numeric AS working_hours_open,
    NULL::numeric AS working_hours_close,
    NULL::numeric AS delay_endings_days,
    NULL::bigint AS dependent_ids_count,
    NULL::integer AS sale_line_id,
    NULL::integer AS sale_order_id;


ALTER VIEW public.report_project_task_user OWNER TO odoo;

--
-- Name: stock_location; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.stock_location (
    id integer NOT NULL,
    location_id integer,
    posx integer,
    posy integer,
    posz integer,
    company_id integer,
    removal_strategy_id integer,
    cyclic_inventory_frequency integer,
    warehouse_id integer,
    storage_category_id integer,
    create_uid integer,
    write_uid integer,
    name character varying NOT NULL,
    complete_name character varying,
    usage character varying NOT NULL,
    parent_path character varying,
    barcode character varying,
    last_inventory_date date,
    next_inventory_date date,
    comment text,
    active boolean,
    scrap_location boolean,
    replenish_location boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    valuation_in_account_id integer,
    valuation_out_account_id integer,
    CONSTRAINT stock_location_inventory_freq_nonneg CHECK ((cyclic_inventory_frequency >= 0))
);


ALTER TABLE public.stock_location OWNER TO odoo;

--
-- Name: TABLE stock_location; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.stock_location IS 'Inventory Locations';


--
-- Name: COLUMN stock_location.location_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_location.location_id IS 'Parent Location';


--
-- Name: COLUMN stock_location.posx; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_location.posx IS 'Corridor (X)';


--
-- Name: COLUMN stock_location.posy; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_location.posy IS 'Shelves (Y)';


--
-- Name: COLUMN stock_location.posz; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_location.posz IS 'Height (Z)';


--
-- Name: COLUMN stock_location.company_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_location.company_id IS 'Company';


--
-- Name: COLUMN stock_location.removal_strategy_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_location.removal_strategy_id IS 'Removal Strategy';


--
-- Name: COLUMN stock_location.cyclic_inventory_frequency; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_location.cyclic_inventory_frequency IS 'Inventory Frequency';


--
-- Name: COLUMN stock_location.warehouse_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_location.warehouse_id IS 'Warehouse';


--
-- Name: COLUMN stock_location.storage_category_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_location.storage_category_id IS 'Storage Category';


--
-- Name: COLUMN stock_location.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_location.create_uid IS 'Created by';


--
-- Name: COLUMN stock_location.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_location.write_uid IS 'Last Updated by';


--
-- Name: COLUMN stock_location.name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_location.name IS 'Location Name';


--
-- Name: COLUMN stock_location.complete_name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_location.complete_name IS 'Full Location Name';


--
-- Name: COLUMN stock_location.usage; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_location.usage IS 'Location Type';


--
-- Name: COLUMN stock_location.parent_path; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_location.parent_path IS 'Parent Path';


--
-- Name: COLUMN stock_location.barcode; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_location.barcode IS 'Barcode';


--
-- Name: COLUMN stock_location.last_inventory_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_location.last_inventory_date IS 'Last Inventory';


--
-- Name: COLUMN stock_location.next_inventory_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_location.next_inventory_date IS 'Next Expected';


--
-- Name: COLUMN stock_location.comment; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_location.comment IS 'Additional Information';


--
-- Name: COLUMN stock_location.active; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_location.active IS 'Active';


--
-- Name: COLUMN stock_location.scrap_location; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_location.scrap_location IS 'Is a Scrap Location?';


--
-- Name: COLUMN stock_location.replenish_location; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_location.replenish_location IS 'Replenish Location';


--
-- Name: COLUMN stock_location.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_location.create_date IS 'Created on';


--
-- Name: COLUMN stock_location.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_location.write_date IS 'Last Updated on';


--
-- Name: COLUMN stock_location.valuation_in_account_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_location.valuation_in_account_id IS 'Stock Valuation Account (Incoming)';


--
-- Name: COLUMN stock_location.valuation_out_account_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_location.valuation_out_account_id IS 'Stock Valuation Account (Outgoing)';


--
-- Name: CONSTRAINT stock_location_inventory_freq_nonneg ON stock_location; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT stock_location_inventory_freq_nonneg ON public.stock_location IS 'check(cyclic_inventory_frequency >= 0)';


--
-- Name: stock_move; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.stock_move (
    id integer NOT NULL,
    sequence integer,
    company_id integer NOT NULL,
    product_id integer NOT NULL,
    product_uom integer NOT NULL,
    location_id integer NOT NULL,
    location_dest_id integer NOT NULL,
    location_final_id integer,
    partner_id integer,
    picking_id integer,
    scrap_id integer,
    group_id integer,
    rule_id integer,
    picking_type_id integer,
    origin_returned_move_id integer,
    restrict_partner_id integer,
    warehouse_id integer,
    package_level_id integer,
    next_serial_count integer,
    orderpoint_id integer,
    product_packaging_id integer,
    create_uid integer,
    write_uid integer,
    name character varying NOT NULL,
    priority character varying,
    state character varying,
    origin character varying,
    procure_method character varying NOT NULL,
    reference character varying,
    next_serial character varying,
    reservation_date date,
    description_picking text,
    product_qty numeric,
    product_uom_qty numeric NOT NULL,
    quantity numeric,
    picked boolean,
    scrapped boolean,
    propagate_cancel boolean,
    is_inventory boolean,
    additional boolean,
    date timestamp without time zone NOT NULL,
    date_deadline timestamp without time zone,
    delay_alert_date timestamp without time zone,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    price_unit double precision,
    to_refund boolean,
    sale_line_id integer,
    repair_id integer,
    repair_line_type character varying,
    is_done boolean DEFAULT true,
    unit_factor double precision DEFAULT 1,
    manual_consumption boolean DEFAULT false,
    created_production_id integer,
    production_id integer,
    raw_material_production_id integer,
    unbuild_id integer,
    consume_unbuild_id integer,
    operation_id integer,
    workorder_id integer,
    bom_line_id integer,
    byproduct_id integer,
    order_finished_lot_id integer,
    cost_share numeric,
    purchase_line_id integer
);


ALTER TABLE public.stock_move OWNER TO odoo;

--
-- Name: TABLE stock_move; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.stock_move IS 'Stock Move';


--
-- Name: COLUMN stock_move.sequence; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.sequence IS 'Sequence';


--
-- Name: COLUMN stock_move.company_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.company_id IS 'Company';


--
-- Name: COLUMN stock_move.product_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.product_id IS 'Product';


--
-- Name: COLUMN stock_move.product_uom; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.product_uom IS 'UoM';


--
-- Name: COLUMN stock_move.location_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.location_id IS 'Source Location';


--
-- Name: COLUMN stock_move.location_dest_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.location_dest_id IS 'Intermediate Location';


--
-- Name: COLUMN stock_move.location_final_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.location_final_id IS 'Final Location';


--
-- Name: COLUMN stock_move.partner_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.partner_id IS 'Destination Address ';


--
-- Name: COLUMN stock_move.picking_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.picking_id IS 'Transfer';


--
-- Name: COLUMN stock_move.scrap_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.scrap_id IS 'Scrap operation';


--
-- Name: COLUMN stock_move.group_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.group_id IS 'Procurement Group';


--
-- Name: COLUMN stock_move.rule_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.rule_id IS 'Stock Rule';


--
-- Name: COLUMN stock_move.picking_type_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.picking_type_id IS 'Operation Type';


--
-- Name: COLUMN stock_move.origin_returned_move_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.origin_returned_move_id IS 'Origin return move';


--
-- Name: COLUMN stock_move.restrict_partner_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.restrict_partner_id IS 'Owner ';


--
-- Name: COLUMN stock_move.warehouse_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.warehouse_id IS 'Warehouse';


--
-- Name: COLUMN stock_move.package_level_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.package_level_id IS 'Package Level';


--
-- Name: COLUMN stock_move.next_serial_count; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.next_serial_count IS 'Number of SN/Lots';


--
-- Name: COLUMN stock_move.orderpoint_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.orderpoint_id IS 'Original Reordering Rule';


--
-- Name: COLUMN stock_move.product_packaging_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.product_packaging_id IS 'Packaging';


--
-- Name: COLUMN stock_move.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.create_uid IS 'Created by';


--
-- Name: COLUMN stock_move.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.write_uid IS 'Last Updated by';


--
-- Name: COLUMN stock_move.name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.name IS 'Description';


--
-- Name: COLUMN stock_move.priority; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.priority IS 'Priority';


--
-- Name: COLUMN stock_move.state; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.state IS 'Status';


--
-- Name: COLUMN stock_move.origin; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.origin IS 'Source Document';


--
-- Name: COLUMN stock_move.procure_method; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.procure_method IS 'Supply Method';


--
-- Name: COLUMN stock_move.reference; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.reference IS 'Reference';


--
-- Name: COLUMN stock_move.next_serial; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.next_serial IS 'First SN/Lot';


--
-- Name: COLUMN stock_move.reservation_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.reservation_date IS 'Date to Reserve';


--
-- Name: COLUMN stock_move.description_picking; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.description_picking IS 'Description of Picking';


--
-- Name: COLUMN stock_move.product_qty; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.product_qty IS 'Real Quantity';


--
-- Name: COLUMN stock_move.product_uom_qty; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.product_uom_qty IS 'Demand';


--
-- Name: COLUMN stock_move.quantity; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.quantity IS 'Quantity';


--
-- Name: COLUMN stock_move.picked; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.picked IS 'Picked';


--
-- Name: COLUMN stock_move.scrapped; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.scrapped IS 'Scrapped';


--
-- Name: COLUMN stock_move.propagate_cancel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.propagate_cancel IS 'Propagate cancel and split';


--
-- Name: COLUMN stock_move.is_inventory; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.is_inventory IS 'Inventory';


--
-- Name: COLUMN stock_move.additional; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.additional IS 'Whether the move was added after the picking''s confirmation';


--
-- Name: COLUMN stock_move.date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.date IS 'Date Scheduled';


--
-- Name: COLUMN stock_move.date_deadline; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.date_deadline IS 'Deadline';


--
-- Name: COLUMN stock_move.delay_alert_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.delay_alert_date IS 'Delay Alert Date';


--
-- Name: COLUMN stock_move.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.create_date IS 'Created on';


--
-- Name: COLUMN stock_move.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.write_date IS 'Last Updated on';


--
-- Name: COLUMN stock_move.price_unit; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.price_unit IS 'Unit Price';


--
-- Name: COLUMN stock_move.to_refund; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.to_refund IS 'Update quantities on SO/PO';


--
-- Name: COLUMN stock_move.sale_line_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.sale_line_id IS 'Sale Line';


--
-- Name: COLUMN stock_move.repair_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.repair_id IS 'Repair';


--
-- Name: COLUMN stock_move.repair_line_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.repair_line_type IS 'Type';


--
-- Name: COLUMN stock_move.created_production_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.created_production_id IS 'Created Production Order';


--
-- Name: COLUMN stock_move.production_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.production_id IS 'Production Order for finished products';


--
-- Name: COLUMN stock_move.raw_material_production_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.raw_material_production_id IS 'Production Order for components';


--
-- Name: COLUMN stock_move.unbuild_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.unbuild_id IS 'Disassembly Order';


--
-- Name: COLUMN stock_move.consume_unbuild_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.consume_unbuild_id IS 'Consumed Disassembly Order';


--
-- Name: COLUMN stock_move.operation_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.operation_id IS 'Operation To Consume';


--
-- Name: COLUMN stock_move.workorder_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.workorder_id IS 'Work Order To Consume';


--
-- Name: COLUMN stock_move.bom_line_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.bom_line_id IS 'BoM Line';


--
-- Name: COLUMN stock_move.byproduct_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.byproduct_id IS 'By-products';


--
-- Name: COLUMN stock_move.order_finished_lot_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.order_finished_lot_id IS 'Finished Lot/Serial Number';


--
-- Name: COLUMN stock_move.cost_share; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.cost_share IS 'Cost Share (%)';


--
-- Name: COLUMN stock_move.purchase_line_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.purchase_line_id IS 'Purchase Order Line';


--
-- Name: stock_quant; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.stock_quant (
    id integer NOT NULL,
    product_id integer NOT NULL,
    company_id integer,
    location_id integer NOT NULL,
    storage_category_id integer,
    lot_id integer,
    package_id integer,
    owner_id integer,
    user_id integer,
    create_uid integer,
    write_uid integer,
    inventory_date date,
    quantity numeric,
    reserved_quantity numeric NOT NULL,
    inventory_quantity numeric,
    inventory_diff_quantity numeric,
    inventory_quantity_set boolean,
    in_date timestamp without time zone NOT NULL,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    accounting_date date
);


ALTER TABLE public.stock_quant OWNER TO odoo;

--
-- Name: TABLE stock_quant; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.stock_quant IS 'Quants';


--
-- Name: COLUMN stock_quant.product_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_quant.product_id IS 'Product';


--
-- Name: COLUMN stock_quant.company_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_quant.company_id IS 'Company';


--
-- Name: COLUMN stock_quant.location_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_quant.location_id IS 'Location';


--
-- Name: COLUMN stock_quant.storage_category_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_quant.storage_category_id IS 'Storage Category';


--
-- Name: COLUMN stock_quant.lot_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_quant.lot_id IS 'Lot/Serial Number';


--
-- Name: COLUMN stock_quant.package_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_quant.package_id IS 'Package';


--
-- Name: COLUMN stock_quant.owner_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_quant.owner_id IS 'Owner';


--
-- Name: COLUMN stock_quant.user_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_quant.user_id IS 'Assigned To';


--
-- Name: COLUMN stock_quant.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_quant.create_uid IS 'Created by';


--
-- Name: COLUMN stock_quant.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_quant.write_uid IS 'Last Updated by';


--
-- Name: COLUMN stock_quant.inventory_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_quant.inventory_date IS 'Scheduled Date';


--
-- Name: COLUMN stock_quant.quantity; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_quant.quantity IS 'Quantity';


--
-- Name: COLUMN stock_quant.reserved_quantity; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_quant.reserved_quantity IS 'Reserved Quantity';


--
-- Name: COLUMN stock_quant.inventory_quantity; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_quant.inventory_quantity IS 'Counted Quantity';


--
-- Name: COLUMN stock_quant.inventory_diff_quantity; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_quant.inventory_diff_quantity IS 'Difference';


--
-- Name: COLUMN stock_quant.inventory_quantity_set; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_quant.inventory_quantity_set IS 'Inventory Quantity Set';


--
-- Name: COLUMN stock_quant.in_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_quant.in_date IS 'Incoming Date';


--
-- Name: COLUMN stock_quant.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_quant.create_date IS 'Created on';


--
-- Name: COLUMN stock_quant.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_quant.write_date IS 'Last Updated on';


--
-- Name: COLUMN stock_quant.accounting_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_quant.accounting_date IS 'Accounting Date';


--
-- Name: stock_warehouse; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.stock_warehouse (
    id integer NOT NULL,
    company_id integer NOT NULL,
    partner_id integer,
    view_location_id integer NOT NULL,
    lot_stock_id integer NOT NULL,
    wh_input_stock_loc_id integer,
    wh_qc_stock_loc_id integer,
    wh_output_stock_loc_id integer,
    wh_pack_stock_loc_id integer,
    mto_pull_id integer,
    pick_type_id integer,
    pack_type_id integer,
    out_type_id integer,
    in_type_id integer,
    int_type_id integer,
    qc_type_id integer,
    store_type_id integer,
    xdock_type_id integer,
    crossdock_route_id integer,
    reception_route_id integer,
    delivery_route_id integer,
    sequence integer,
    create_uid integer,
    write_uid integer,
    name character varying NOT NULL,
    code character varying(5) NOT NULL,
    reception_steps character varying NOT NULL,
    delivery_steps character varying NOT NULL,
    active boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    repair_type_id integer,
    repair_mto_pull_id integer,
    manufacture_pull_id integer,
    manufacture_mto_pull_id integer,
    pbm_mto_pull_id integer,
    sam_rule_id integer,
    manu_type_id integer,
    pbm_type_id integer,
    sam_type_id integer,
    pbm_route_id integer,
    pbm_loc_id integer,
    sam_loc_id integer,
    manufacture_steps character varying NOT NULL,
    manufacture_to_resupply boolean,
    buy_pull_id integer,
    buy_to_resupply boolean
);


ALTER TABLE public.stock_warehouse OWNER TO odoo;

--
-- Name: TABLE stock_warehouse; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.stock_warehouse IS 'Warehouse';


--
-- Name: COLUMN stock_warehouse.company_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse.company_id IS 'Company';


--
-- Name: COLUMN stock_warehouse.partner_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse.partner_id IS 'Address';


--
-- Name: COLUMN stock_warehouse.view_location_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse.view_location_id IS 'View Location';


--
-- Name: COLUMN stock_warehouse.lot_stock_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse.lot_stock_id IS 'Location Stock';


--
-- Name: COLUMN stock_warehouse.wh_input_stock_loc_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse.wh_input_stock_loc_id IS 'Input Location';


--
-- Name: COLUMN stock_warehouse.wh_qc_stock_loc_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse.wh_qc_stock_loc_id IS 'Quality Control Location';


--
-- Name: COLUMN stock_warehouse.wh_output_stock_loc_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse.wh_output_stock_loc_id IS 'Output Location';


--
-- Name: COLUMN stock_warehouse.wh_pack_stock_loc_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse.wh_pack_stock_loc_id IS 'Packing Location';


--
-- Name: COLUMN stock_warehouse.mto_pull_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse.mto_pull_id IS 'MTO rule';


--
-- Name: COLUMN stock_warehouse.pick_type_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse.pick_type_id IS 'Pick Type';


--
-- Name: COLUMN stock_warehouse.pack_type_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse.pack_type_id IS 'Pack Type';


--
-- Name: COLUMN stock_warehouse.out_type_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse.out_type_id IS 'Out Type';


--
-- Name: COLUMN stock_warehouse.in_type_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse.in_type_id IS 'In Type';


--
-- Name: COLUMN stock_warehouse.int_type_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse.int_type_id IS 'Internal Type';


--
-- Name: COLUMN stock_warehouse.qc_type_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse.qc_type_id IS 'Quality Control Type';


--
-- Name: COLUMN stock_warehouse.store_type_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse.store_type_id IS 'Storage Type';


--
-- Name: COLUMN stock_warehouse.xdock_type_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse.xdock_type_id IS 'Cross Dock Type';


--
-- Name: COLUMN stock_warehouse.crossdock_route_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse.crossdock_route_id IS 'Crossdock Route';


--
-- Name: COLUMN stock_warehouse.reception_route_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse.reception_route_id IS 'Receipt Route';


--
-- Name: COLUMN stock_warehouse.delivery_route_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse.delivery_route_id IS 'Delivery Route';


--
-- Name: COLUMN stock_warehouse.sequence; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse.sequence IS 'Sequence';


--
-- Name: COLUMN stock_warehouse.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse.create_uid IS 'Created by';


--
-- Name: COLUMN stock_warehouse.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse.write_uid IS 'Last Updated by';


--
-- Name: COLUMN stock_warehouse.name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse.name IS 'Warehouse';


--
-- Name: COLUMN stock_warehouse.code; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse.code IS 'Short Name';


--
-- Name: COLUMN stock_warehouse.reception_steps; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse.reception_steps IS 'Incoming Shipments';


--
-- Name: COLUMN stock_warehouse.delivery_steps; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse.delivery_steps IS 'Outgoing Shipments';


--
-- Name: COLUMN stock_warehouse.active; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse.active IS 'Active';


--
-- Name: COLUMN stock_warehouse.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse.create_date IS 'Created on';


--
-- Name: COLUMN stock_warehouse.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse.write_date IS 'Last Updated on';


--
-- Name: COLUMN stock_warehouse.repair_type_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse.repair_type_id IS 'Repair Operation Type';


--
-- Name: COLUMN stock_warehouse.repair_mto_pull_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse.repair_mto_pull_id IS 'Repair MTO Rule';


--
-- Name: COLUMN stock_warehouse.manufacture_pull_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse.manufacture_pull_id IS 'Manufacture Rule';


--
-- Name: COLUMN stock_warehouse.manufacture_mto_pull_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse.manufacture_mto_pull_id IS 'Manufacture MTO Rule';


--
-- Name: COLUMN stock_warehouse.pbm_mto_pull_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse.pbm_mto_pull_id IS 'Picking Before Manufacturing MTO Rule';


--
-- Name: COLUMN stock_warehouse.sam_rule_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse.sam_rule_id IS 'Stock After Manufacturing Rule';


--
-- Name: COLUMN stock_warehouse.manu_type_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse.manu_type_id IS 'Manufacturing Operation Type';


--
-- Name: COLUMN stock_warehouse.pbm_type_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse.pbm_type_id IS 'Picking Before Manufacturing Operation Type';


--
-- Name: COLUMN stock_warehouse.sam_type_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse.sam_type_id IS 'Stock After Manufacturing Operation Type';


--
-- Name: COLUMN stock_warehouse.pbm_route_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse.pbm_route_id IS 'Picking Before Manufacturing Route';


--
-- Name: COLUMN stock_warehouse.pbm_loc_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse.pbm_loc_id IS 'Picking before Manufacturing Location';


--
-- Name: COLUMN stock_warehouse.sam_loc_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse.sam_loc_id IS 'Stock after Manufacturing Location';


--
-- Name: COLUMN stock_warehouse.manufacture_steps; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse.manufacture_steps IS 'Manufacture';


--
-- Name: COLUMN stock_warehouse.manufacture_to_resupply; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse.manufacture_to_resupply IS 'Manufacture to Resupply';


--
-- Name: COLUMN stock_warehouse.buy_pull_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse.buy_pull_id IS 'Buy rule';


--
-- Name: COLUMN stock_warehouse.buy_to_resupply; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse.buy_to_resupply IS 'Buy to Resupply';


--
-- Name: report_stock_quantity; Type: VIEW; Schema: public; Owner: odoo
--

CREATE VIEW public.report_stock_quantity AS
 WITH warehouse_cte AS (
         SELECT sl.id AS sl_id,
            w.id AS w_id
           FROM (public.stock_location sl
             LEFT JOIN public.stock_warehouse w ON (((sl.parent_path)::text ~~ concat('%/', w.view_location_id, '/%'))))
        ), existing_sm(id, product_id, tmpl_id, product_qty, quantity, date, state, company_id, whs_id, whd_id) AS (
         SELECT m.id,
            m.product_id,
            pt.id,
            m.product_qty,
            m.quantity,
            m.date,
            m.state,
            m.company_id,
            source.w_id,
            dest.w_id
           FROM ((((public.stock_move m
             LEFT JOIN warehouse_cte source ON ((source.sl_id = m.location_id)))
             LEFT JOIN warehouse_cte dest ON ((dest.sl_id =
                CASE
                    WHEN ((m.state)::text <> 'done'::text) THEN COALESCE(m.location_final_id, m.location_dest_id)
                    ELSE m.location_dest_id
                END)))
             LEFT JOIN public.product_product pp ON ((pp.id = m.product_id)))
             LEFT JOIN public.product_template pt ON ((pt.id = pp.product_tmpl_id)))
          WHERE ((pt.is_storable = true) AND ((source.w_id IS NOT NULL) OR (dest.w_id IS NOT NULL)) AND ((source.w_id IS NULL) OR (dest.w_id IS NULL) OR (source.w_id <> dest.w_id)) AND (m.product_qty <> (0)::numeric) AND ((m.state)::text <> ALL ((ARRAY['draft'::character varying, 'cancel'::character varying])::text[])) AND (((m.state)::text = ANY ((ARRAY['draft'::character varying, 'waiting'::character varying, 'confirmed'::character varying, 'partially_available'::character varying, 'assigned'::character varying])::text[])) OR (m.date >= (((now() AT TIME ZONE 'utc'::text))::date - '3 mons'::interval))))
        ), all_sm(id, product_id, tmpl_id, product_qty, quantity, date, state, company_id, whs_id, whd_id) AS (
         SELECT sm.id,
            sm.product_id,
            sm.tmpl_id,
                CASE
                    WHEN (is_duplicated.is_duplicated = 0) THEN sm.product_qty
                    WHEN ((sm.whs_id IS NOT NULL) AND (sm.whd_id IS NOT NULL) AND (sm.whs_id <> sm.whd_id)) THEN sm.product_qty
                    ELSE (0)::numeric
                END AS "case",
                CASE
                    WHEN (is_duplicated.is_duplicated = 0) THEN sm.quantity
                    WHEN ((sm.whs_id IS NOT NULL) AND (sm.whd_id IS NOT NULL) AND (sm.whs_id <> sm.whd_id)) THEN sm.quantity
                    ELSE (0)::numeric
                END AS "case",
            sm.date,
            sm.state,
            sm.company_id,
                CASE
                    WHEN (is_duplicated.is_duplicated = 0) THEN sm.whs_id
                    ELSE NULL::integer
                END AS "case",
                CASE
                    WHEN ((is_duplicated.is_duplicated = 0) AND (NOT ((sm.whs_id IS NOT NULL) AND (sm.whd_id IS NOT NULL) AND (sm.whs_id <> sm.whd_id)))) THEN sm.whd_id
                    WHEN ((is_duplicated.is_duplicated = 1) AND ((sm.whs_id IS NOT NULL) AND (sm.whd_id IS NOT NULL) AND (sm.whs_id <> sm.whd_id))) THEN sm.whd_id
                    ELSE NULL::integer
                END AS "case"
           FROM generate_series(0, 1, 1) is_duplicated(is_duplicated),
            existing_sm sm
        )
 SELECT min(id) AS id,
    product_id,
    product_tmpl_id,
    state,
    date,
    sum(product_qty) AS product_qty,
    company_id,
    warehouse_id
   FROM ( SELECT m.id,
            m.product_id,
            m.tmpl_id AS product_tmpl_id,
                CASE
                    WHEN ((m.whs_id IS NOT NULL) AND (m.whd_id IS NULL)) THEN 'out'::text
                    WHEN ((m.whd_id IS NOT NULL) AND (m.whs_id IS NULL)) THEN 'in'::text
                    ELSE NULL::text
                END AS state,
            (m.date)::date AS date,
                CASE
                    WHEN ((m.whs_id IS NOT NULL) AND (m.whd_id IS NULL)) THEN (- m.product_qty)
                    WHEN ((m.whd_id IS NOT NULL) AND (m.whs_id IS NULL)) THEN m.product_qty
                    ELSE NULL::numeric
                END AS product_qty,
            m.company_id,
                CASE
                    WHEN ((m.whs_id IS NOT NULL) AND (m.whd_id IS NULL)) THEN m.whs_id
                    WHEN ((m.whd_id IS NOT NULL) AND (m.whs_id IS NULL)) THEN m.whd_id
                    ELSE NULL::integer
                END AS warehouse_id
           FROM all_sm m
          WHERE ((m.product_qty <> (0)::numeric) AND ((m.state)::text <> 'done'::text))
        UNION ALL
         SELECT (- q.id) AS id,
            q.product_id,
            pp.product_tmpl_id,
            'forecast'::text AS state,
            (date.date)::date AS date,
            q.quantity AS product_qty,
            q.company_id,
            wh.id AS warehouse_id
           FROM generate_series((((now() AT TIME ZONE 'utc'::text))::date - '3 mons'::interval), (((now() AT TIME ZONE 'utc'::text))::date + '3 mons'::interval), '1 day'::interval) date(date),
            (((public.stock_quant q
             LEFT JOIN public.stock_location l ON ((l.id = q.location_id)))
             LEFT JOIN public.stock_warehouse wh ON (((l.parent_path)::text ~~ concat('%/', wh.view_location_id, '/%'))))
             LEFT JOIN public.product_product pp ON ((pp.id = q.product_id)))
          WHERE ((((l.usage)::text = 'internal'::text) AND (wh.id IS NOT NULL)) OR ((l.usage)::text = 'transit'::text))
        UNION ALL
         SELECT m.id,
            m.product_id,
            m.tmpl_id AS product_tmpl_id,
            'forecast'::text AS state,
            (generate_series(
                CASE
                    WHEN ((m.state)::text = 'done'::text) THEN (((now() AT TIME ZONE 'utc'::text))::date - '3 mons'::interval)
                    ELSE GREATEST(((m.date)::date)::timestamp without time zone, (((now() AT TIME ZONE 'utc'::text))::date - '3 mons'::interval))
                END,
                CASE
                    WHEN ((m.state)::text <> 'done'::text) THEN (((now() AT TIME ZONE 'utc'::text))::date + '3 mons'::interval)
                    ELSE ((m.date)::date - '1 day'::interval)
                END, '1 day'::interval))::date AS date,
                CASE
                    WHEN ((m.whs_id IS NOT NULL) AND (m.whd_id IS NULL) AND ((m.state)::text = 'done'::text)) THEN m.quantity
                    WHEN ((m.whd_id IS NOT NULL) AND (m.whs_id IS NULL) AND ((m.state)::text = 'done'::text)) THEN (- m.quantity)
                    WHEN ((m.whs_id IS NOT NULL) AND (m.whd_id IS NULL)) THEN (- m.product_qty)
                    WHEN ((m.whd_id IS NOT NULL) AND (m.whs_id IS NULL)) THEN m.product_qty
                    ELSE NULL::numeric
                END AS product_qty,
            m.company_id,
                CASE
                    WHEN ((m.whs_id IS NOT NULL) AND (m.whd_id IS NULL)) THEN m.whs_id
                    WHEN ((m.whd_id IS NOT NULL) AND (m.whs_id IS NULL)) THEN m.whd_id
                    ELSE NULL::integer
                END AS warehouse_id
           FROM all_sm m
          WHERE (m.product_qty <> (0)::numeric)) forecast_qty
  GROUP BY product_id, product_tmpl_id, state, date, company_id, warehouse_id;


ALTER VIEW public.report_stock_quantity OWNER TO odoo;

--
-- Name: res_bank; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.res_bank (
    id integer NOT NULL,
    state integer,
    country integer,
    create_uid integer,
    write_uid integer,
    name character varying NOT NULL,
    street character varying,
    street2 character varying,
    zip character varying,
    city character varying,
    email character varying,
    phone character varying,
    bic character varying,
    active boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.res_bank OWNER TO odoo;

--
-- Name: TABLE res_bank; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.res_bank IS 'Bank';


--
-- Name: COLUMN res_bank.state; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_bank.state IS 'Fed. State';


--
-- Name: COLUMN res_bank.country; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_bank.country IS 'Country';


--
-- Name: COLUMN res_bank.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_bank.create_uid IS 'Created by';


--
-- Name: COLUMN res_bank.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_bank.write_uid IS 'Last Updated by';


--
-- Name: COLUMN res_bank.name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_bank.name IS 'Name';


--
-- Name: COLUMN res_bank.street; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_bank.street IS 'Street';


--
-- Name: COLUMN res_bank.street2; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_bank.street2 IS 'Street2';


--
-- Name: COLUMN res_bank.zip; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_bank.zip IS 'Zip';


--
-- Name: COLUMN res_bank.city; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_bank.city IS 'City';


--
-- Name: COLUMN res_bank.email; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_bank.email IS 'Email';


--
-- Name: COLUMN res_bank.phone; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_bank.phone IS 'Phone';


--
-- Name: COLUMN res_bank.bic; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_bank.bic IS 'Bank Identifier Code';


--
-- Name: COLUMN res_bank.active; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_bank.active IS 'Active';


--
-- Name: COLUMN res_bank.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_bank.create_date IS 'Created on';


--
-- Name: COLUMN res_bank.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_bank.write_date IS 'Last Updated on';


--
-- Name: res_bank_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.res_bank_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.res_bank_id_seq OWNER TO odoo;

--
-- Name: res_bank_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.res_bank_id_seq OWNED BY public.res_bank.id;


--
-- Name: res_company; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.res_company (
    id integer NOT NULL,
    name character varying NOT NULL,
    partner_id integer NOT NULL,
    currency_id integer NOT NULL,
    sequence integer,
    create_date timestamp without time zone,
    parent_path character varying,
    parent_id integer,
    paperformat_id integer,
    external_report_layout_id integer,
    create_uid integer,
    write_uid integer,
    email character varying,
    phone character varying,
    mobile character varying,
    font character varying,
    primary_color character varying,
    secondary_color character varying,
    layout_background character varying NOT NULL,
    report_header jsonb,
    report_footer jsonb,
    company_details jsonb,
    active boolean,
    uses_default_logo boolean,
    write_date timestamp without time zone,
    logo_web bytea,
    resource_calendar_id integer,
    alias_domain_id integer,
    alias_domain_name character varying,
    email_primary_color character varying,
    email_secondary_color character varying,
    partner_gid integer,
    iap_enrich_auto_done boolean,
    snailmail_color boolean,
    snailmail_cover boolean,
    snailmail_duplex boolean,
    payment_onboarding_payment_method character varying,
    fiscalyear_last_day integer NOT NULL,
    transfer_account_id integer,
    default_cash_difference_income_account_id integer,
    default_cash_difference_expense_account_id integer,
    account_journal_suspense_account_id integer,
    account_journal_early_pay_discount_gain_account_id integer,
    account_journal_early_pay_discount_loss_account_id integer,
    account_sale_tax_id integer,
    account_purchase_tax_id integer,
    currency_exchange_journal_id integer,
    income_currency_exchange_account_id integer,
    expense_currency_exchange_account_id integer,
    incoterm_id integer,
    batch_payment_sequence_id integer,
    account_opening_move_id integer,
    account_default_pos_receivable_account_id integer,
    expense_accrual_account_id integer,
    revenue_accrual_account_id integer,
    automatic_entry_default_journal_id integer,
    account_fiscal_country_id integer,
    tax_cash_basis_journal_id integer,
    account_cash_basis_base_account_id integer,
    account_discount_income_allocation_id integer,
    account_discount_expense_allocation_id integer,
    fiscalyear_last_month character varying NOT NULL,
    chart_template character varying,
    bank_account_code_prefix character varying,
    cash_account_code_prefix character varying,
    transfer_account_code_prefix character varying,
    tax_calculation_rounding_method character varying,
    terms_type character varying,
    quick_edit_mode character varying,
    account_price_include character varying NOT NULL,
    fiscalyear_lock_date date,
    tax_lock_date date,
    sale_lock_date date,
    purchase_lock_date date,
    hard_lock_date date,
    account_opening_date date NOT NULL,
    invoice_terms jsonb,
    invoice_terms_html jsonb,
    expects_chart_of_accounts boolean,
    anglo_saxon_accounting boolean,
    qr_code boolean,
    display_invoice_amount_total_words boolean,
    display_invoice_tax_company_currency boolean,
    account_use_credit_limit boolean,
    tax_exigibility boolean,
    account_storno boolean,
    check_account_audit_trail boolean,
    autopost_bills boolean,
    vat_check_vies boolean,
    peppol_purchase_journal_id integer,
    account_peppol_contact_email character varying,
    account_peppol_migration_key character varying,
    account_peppol_phone_number character varying,
    account_peppol_proxy_state character varying NOT NULL,
    l10n_es_simplified_invoice_limit double precision,
    quotation_validity_days integer,
    sale_discount_product_id integer,
    sale_onboarding_payment_method character varying,
    portal_confirmation_sign boolean,
    portal_confirmation_pay boolean,
    prepayment_percent double precision,
    sale_order_template_id integer,
    social_twitter character varying,
    social_facebook character varying,
    social_github character varying,
    social_linkedin character varying,
    social_youtube character varying,
    social_instagram character varying,
    social_tiktok character varying,
    nomenclature_id integer,
    internal_transit_location_id integer,
    stock_mail_confirmation_template_id integer,
    annual_inventory_day integer,
    annual_inventory_month character varying,
    stock_move_email_validation boolean,
    account_production_wip_account_id integer,
    account_production_wip_overhead_account_id integer,
    stock_sms_confirmation_template_id integer,
    stock_move_sms_validation boolean,
    has_received_warning_stock_sms boolean,
    security_lead double precision NOT NULL,
    hr_presence_control_email_amount integer,
    hr_presence_control_ip_list character varying,
    employee_properties_definition jsonb,
    hr_presence_control_login boolean,
    hr_presence_control_email boolean,
    hr_presence_control_ip boolean,
    hr_presence_control_attendance boolean,
    manufacturing_lead double precision NOT NULL,
    po_lock character varying,
    po_double_validation character varying,
    po_double_validation_amount numeric,
    po_lead double precision NOT NULL,
    days_to_purchase double precision,
    CONSTRAINT res_company_check_quotation_validity_days CHECK ((quotation_validity_days >= 0))
);


ALTER TABLE public.res_company OWNER TO odoo;

--
-- Name: COLUMN res_company.parent_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.parent_id IS 'Parent Company';


--
-- Name: COLUMN res_company.paperformat_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.paperformat_id IS 'Paper format';


--
-- Name: COLUMN res_company.external_report_layout_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.external_report_layout_id IS 'Document Template';


--
-- Name: COLUMN res_company.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.create_uid IS 'Created by';


--
-- Name: COLUMN res_company.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.write_uid IS 'Last Updated by';


--
-- Name: COLUMN res_company.email; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.email IS 'Email';


--
-- Name: COLUMN res_company.phone; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.phone IS 'Phone';


--
-- Name: COLUMN res_company.mobile; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.mobile IS 'Mobile';


--
-- Name: COLUMN res_company.font; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.font IS 'Font';


--
-- Name: COLUMN res_company.primary_color; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.primary_color IS 'Primary Color';


--
-- Name: COLUMN res_company.secondary_color; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.secondary_color IS 'Secondary Color';


--
-- Name: COLUMN res_company.layout_background; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.layout_background IS 'Layout Background';


--
-- Name: COLUMN res_company.report_header; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.report_header IS 'Company Tagline';


--
-- Name: COLUMN res_company.report_footer; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.report_footer IS 'Report Footer';


--
-- Name: COLUMN res_company.company_details; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.company_details IS 'Company Details';


--
-- Name: COLUMN res_company.active; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.active IS 'Active';


--
-- Name: COLUMN res_company.uses_default_logo; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.uses_default_logo IS 'Uses Default Logo';


--
-- Name: COLUMN res_company.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.write_date IS 'Last Updated on';


--
-- Name: COLUMN res_company.logo_web; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.logo_web IS 'Logo Web';


--
-- Name: COLUMN res_company.resource_calendar_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.resource_calendar_id IS 'Default Working Hours';


--
-- Name: COLUMN res_company.alias_domain_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.alias_domain_id IS 'Email Domain';


--
-- Name: COLUMN res_company.alias_domain_name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.alias_domain_name IS 'Alias Domain Name';


--
-- Name: COLUMN res_company.email_primary_color; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.email_primary_color IS 'Email Header Color';


--
-- Name: COLUMN res_company.email_secondary_color; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.email_secondary_color IS 'Email Button Color';


--
-- Name: COLUMN res_company.partner_gid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.partner_gid IS 'Company database ID';


--
-- Name: COLUMN res_company.iap_enrich_auto_done; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.iap_enrich_auto_done IS 'Enrich Done';


--
-- Name: COLUMN res_company.snailmail_color; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.snailmail_color IS 'Snailmail Color';


--
-- Name: COLUMN res_company.snailmail_cover; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.snailmail_cover IS 'Add a Cover Page';


--
-- Name: COLUMN res_company.snailmail_duplex; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.snailmail_duplex IS 'Both sides';


--
-- Name: COLUMN res_company.payment_onboarding_payment_method; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.payment_onboarding_payment_method IS 'Selected onboarding payment method';


--
-- Name: COLUMN res_company.fiscalyear_last_day; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.fiscalyear_last_day IS 'Fiscalyear Last Day';


--
-- Name: COLUMN res_company.transfer_account_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.transfer_account_id IS 'Inter-Banks Transfer Account';


--
-- Name: COLUMN res_company.default_cash_difference_income_account_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.default_cash_difference_income_account_id IS 'Cash Difference Income';


--
-- Name: COLUMN res_company.default_cash_difference_expense_account_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.default_cash_difference_expense_account_id IS 'Cash Difference Expense';


--
-- Name: COLUMN res_company.account_journal_suspense_account_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.account_journal_suspense_account_id IS 'Journal Suspense Account';


--
-- Name: COLUMN res_company.account_journal_early_pay_discount_gain_account_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.account_journal_early_pay_discount_gain_account_id IS 'Cash Discount Write-Off Gain Account';


--
-- Name: COLUMN res_company.account_journal_early_pay_discount_loss_account_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.account_journal_early_pay_discount_loss_account_id IS 'Cash Discount Write-Off Loss Account';


--
-- Name: COLUMN res_company.account_sale_tax_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.account_sale_tax_id IS 'Default Sale Tax';


--
-- Name: COLUMN res_company.account_purchase_tax_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.account_purchase_tax_id IS 'Default Purchase Tax';


--
-- Name: COLUMN res_company.currency_exchange_journal_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.currency_exchange_journal_id IS 'Exchange Gain or Loss Journal';


--
-- Name: COLUMN res_company.income_currency_exchange_account_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.income_currency_exchange_account_id IS 'Gain Exchange Rate Account';


--
-- Name: COLUMN res_company.expense_currency_exchange_account_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.expense_currency_exchange_account_id IS 'Loss Exchange Rate Account';


--
-- Name: COLUMN res_company.incoterm_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.incoterm_id IS 'Default incoterm';


--
-- Name: COLUMN res_company.batch_payment_sequence_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.batch_payment_sequence_id IS 'Batch Payment Sequence';


--
-- Name: COLUMN res_company.account_opening_move_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.account_opening_move_id IS 'Opening Journal Entry';


--
-- Name: COLUMN res_company.account_default_pos_receivable_account_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.account_default_pos_receivable_account_id IS 'Default PoS Receivable Account';


--
-- Name: COLUMN res_company.expense_accrual_account_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.expense_accrual_account_id IS 'Expense Accrual Account';


--
-- Name: COLUMN res_company.revenue_accrual_account_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.revenue_accrual_account_id IS 'Revenue Accrual Account';


--
-- Name: COLUMN res_company.automatic_entry_default_journal_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.automatic_entry_default_journal_id IS 'Automatic Entry Default Journal';


--
-- Name: COLUMN res_company.account_fiscal_country_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.account_fiscal_country_id IS 'Fiscal Country';


--
-- Name: COLUMN res_company.tax_cash_basis_journal_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.tax_cash_basis_journal_id IS 'Cash Basis Journal';


--
-- Name: COLUMN res_company.account_cash_basis_base_account_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.account_cash_basis_base_account_id IS 'Base Tax Received Account';


--
-- Name: COLUMN res_company.account_discount_income_allocation_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.account_discount_income_allocation_id IS 'Separate account for income discount';


--
-- Name: COLUMN res_company.account_discount_expense_allocation_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.account_discount_expense_allocation_id IS 'Separate account for expense discount';


--
-- Name: COLUMN res_company.fiscalyear_last_month; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.fiscalyear_last_month IS 'Fiscalyear Last Month';


--
-- Name: COLUMN res_company.chart_template; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.chart_template IS 'Chart Template';


--
-- Name: COLUMN res_company.bank_account_code_prefix; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.bank_account_code_prefix IS 'Prefix of the bank accounts';


--
-- Name: COLUMN res_company.cash_account_code_prefix; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.cash_account_code_prefix IS 'Prefix of the cash accounts';


--
-- Name: COLUMN res_company.transfer_account_code_prefix; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.transfer_account_code_prefix IS 'Prefix of the transfer accounts';


--
-- Name: COLUMN res_company.tax_calculation_rounding_method; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.tax_calculation_rounding_method IS 'Tax Calculation Rounding Method';


--
-- Name: COLUMN res_company.terms_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.terms_type IS 'Terms & Conditions format';


--
-- Name: COLUMN res_company.quick_edit_mode; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.quick_edit_mode IS 'Quick encoding';


--
-- Name: COLUMN res_company.account_price_include; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.account_price_include IS 'Default Sales Price Include';


--
-- Name: COLUMN res_company.fiscalyear_lock_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.fiscalyear_lock_date IS 'Global Lock Date';


--
-- Name: COLUMN res_company.tax_lock_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.tax_lock_date IS 'Tax Return Lock Date';


--
-- Name: COLUMN res_company.sale_lock_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.sale_lock_date IS 'Sales Lock Date';


--
-- Name: COLUMN res_company.purchase_lock_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.purchase_lock_date IS 'Purchase Lock date';


--
-- Name: COLUMN res_company.hard_lock_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.hard_lock_date IS 'Hard Lock Date';


--
-- Name: COLUMN res_company.account_opening_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.account_opening_date IS 'Opening Entry';


--
-- Name: COLUMN res_company.invoice_terms; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.invoice_terms IS 'Default Terms and Conditions';


--
-- Name: COLUMN res_company.invoice_terms_html; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.invoice_terms_html IS 'Default Terms and Conditions as a Web page';


--
-- Name: COLUMN res_company.expects_chart_of_accounts; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.expects_chart_of_accounts IS 'Expects a Chart of Accounts';


--
-- Name: COLUMN res_company.anglo_saxon_accounting; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.anglo_saxon_accounting IS 'Use anglo-saxon accounting';


--
-- Name: COLUMN res_company.qr_code; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.qr_code IS 'Display QR-code on invoices';


--
-- Name: COLUMN res_company.display_invoice_amount_total_words; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.display_invoice_amount_total_words IS 'Total amount of invoice in letters';


--
-- Name: COLUMN res_company.display_invoice_tax_company_currency; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.display_invoice_tax_company_currency IS 'Taxes in company currency';


--
-- Name: COLUMN res_company.account_use_credit_limit; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.account_use_credit_limit IS 'Sales Credit Limit';


--
-- Name: COLUMN res_company.tax_exigibility; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.tax_exigibility IS 'Use Cash Basis';


--
-- Name: COLUMN res_company.account_storno; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.account_storno IS 'Storno accounting';


--
-- Name: COLUMN res_company.check_account_audit_trail; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.check_account_audit_trail IS 'Audit Trail';


--
-- Name: COLUMN res_company.autopost_bills; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.autopost_bills IS 'Auto-validate bills';


--
-- Name: COLUMN res_company.vat_check_vies; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.vat_check_vies IS 'Verify VAT Numbers';


--
-- Name: COLUMN res_company.peppol_purchase_journal_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.peppol_purchase_journal_id IS 'PEPPOL Purchase Journal';


--
-- Name: COLUMN res_company.account_peppol_contact_email; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.account_peppol_contact_email IS 'Primary contact email';


--
-- Name: COLUMN res_company.account_peppol_migration_key; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.account_peppol_migration_key IS 'Migration Key';


--
-- Name: COLUMN res_company.account_peppol_phone_number; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.account_peppol_phone_number IS 'Mobile number';


--
-- Name: COLUMN res_company.account_peppol_proxy_state; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.account_peppol_proxy_state IS 'PEPPOL status';


--
-- Name: COLUMN res_company.l10n_es_simplified_invoice_limit; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.l10n_es_simplified_invoice_limit IS 'Simplified Invoice limit amount';


--
-- Name: COLUMN res_company.quotation_validity_days; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.quotation_validity_days IS 'Default Quotation Validity';


--
-- Name: COLUMN res_company.sale_discount_product_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.sale_discount_product_id IS 'Discount Product';


--
-- Name: COLUMN res_company.sale_onboarding_payment_method; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.sale_onboarding_payment_method IS 'Sale onboarding selected payment method';


--
-- Name: COLUMN res_company.portal_confirmation_sign; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.portal_confirmation_sign IS 'Online Signature';


--
-- Name: COLUMN res_company.portal_confirmation_pay; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.portal_confirmation_pay IS 'Online Payment';


--
-- Name: COLUMN res_company.prepayment_percent; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.prepayment_percent IS 'Prepayment percentage';


--
-- Name: COLUMN res_company.sale_order_template_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.sale_order_template_id IS 'Default Sale Template';


--
-- Name: COLUMN res_company.social_twitter; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.social_twitter IS 'X Account';


--
-- Name: COLUMN res_company.social_facebook; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.social_facebook IS 'Facebook Account';


--
-- Name: COLUMN res_company.social_github; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.social_github IS 'GitHub Account';


--
-- Name: COLUMN res_company.social_linkedin; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.social_linkedin IS 'LinkedIn Account';


--
-- Name: COLUMN res_company.social_youtube; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.social_youtube IS 'Youtube Account';


--
-- Name: COLUMN res_company.social_instagram; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.social_instagram IS 'Instagram Account';


--
-- Name: COLUMN res_company.social_tiktok; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.social_tiktok IS 'TikTok Account';


--
-- Name: COLUMN res_company.nomenclature_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.nomenclature_id IS 'Nomenclature';


--
-- Name: COLUMN res_company.internal_transit_location_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.internal_transit_location_id IS 'Internal Transit Location';


--
-- Name: COLUMN res_company.stock_mail_confirmation_template_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.stock_mail_confirmation_template_id IS 'Email Template confirmation picking';


--
-- Name: COLUMN res_company.annual_inventory_day; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.annual_inventory_day IS 'Day of the month';


--
-- Name: COLUMN res_company.annual_inventory_month; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.annual_inventory_month IS 'Annual Inventory Month';


--
-- Name: COLUMN res_company.stock_move_email_validation; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.stock_move_email_validation IS 'Email Confirmation picking';


--
-- Name: COLUMN res_company.account_production_wip_account_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.account_production_wip_account_id IS 'Production WIP Account';


--
-- Name: COLUMN res_company.account_production_wip_overhead_account_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.account_production_wip_overhead_account_id IS 'Production WIP Overhead Account';


--
-- Name: COLUMN res_company.stock_sms_confirmation_template_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.stock_sms_confirmation_template_id IS 'SMS Template';


--
-- Name: COLUMN res_company.stock_move_sms_validation; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.stock_move_sms_validation IS 'SMS Confirmation';


--
-- Name: COLUMN res_company.has_received_warning_stock_sms; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.has_received_warning_stock_sms IS 'Has Received Warning Stock Sms';


--
-- Name: COLUMN res_company.security_lead; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.security_lead IS 'Sales Safety Days';


--
-- Name: COLUMN res_company.hr_presence_control_email_amount; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.hr_presence_control_email_amount IS '# emails to send';


--
-- Name: COLUMN res_company.hr_presence_control_ip_list; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.hr_presence_control_ip_list IS 'Valid IP addresses';


--
-- Name: COLUMN res_company.employee_properties_definition; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.employee_properties_definition IS 'Employee Properties';


--
-- Name: COLUMN res_company.hr_presence_control_login; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.hr_presence_control_login IS 'Based on user status in system';


--
-- Name: COLUMN res_company.hr_presence_control_email; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.hr_presence_control_email IS 'Based on number of emails sent';


--
-- Name: COLUMN res_company.hr_presence_control_ip; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.hr_presence_control_ip IS 'Based on IP Address';


--
-- Name: COLUMN res_company.hr_presence_control_attendance; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.hr_presence_control_attendance IS 'Based on attendances';


--
-- Name: COLUMN res_company.manufacturing_lead; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.manufacturing_lead IS 'Manufacturing Lead Time';


--
-- Name: COLUMN res_company.po_lock; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.po_lock IS 'Purchase Order Modification';


--
-- Name: COLUMN res_company.po_double_validation; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.po_double_validation IS 'Levels of Approvals';


--
-- Name: COLUMN res_company.po_double_validation_amount; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.po_double_validation_amount IS 'Double validation amount';


--
-- Name: COLUMN res_company.po_lead; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.po_lead IS 'Purchase Lead Time';


--
-- Name: COLUMN res_company.days_to_purchase; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.days_to_purchase IS 'Days to Purchase';


--
-- Name: CONSTRAINT res_company_check_quotation_validity_days ON res_company; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT res_company_check_quotation_validity_days ON public.res_company IS 'CHECK(quotation_validity_days >= 0)';


--
-- Name: res_company_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.res_company_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.res_company_id_seq OWNER TO odoo;

--
-- Name: res_company_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.res_company_id_seq OWNED BY public.res_company.id;


--
-- Name: res_company_users_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.res_company_users_rel (
    cid integer NOT NULL,
    user_id integer NOT NULL
);


ALTER TABLE public.res_company_users_rel OWNER TO odoo;

--
-- Name: TABLE res_company_users_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.res_company_users_rel IS 'RELATION BETWEEN res_company AND res_users';


--
-- Name: res_config; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.res_config (
    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.res_config OWNER TO odoo;

--
-- Name: TABLE res_config; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.res_config IS 'Config';


--
-- Name: COLUMN res_config.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config.create_uid IS 'Created by';


--
-- Name: COLUMN res_config.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config.write_uid IS 'Last Updated by';


--
-- Name: COLUMN res_config.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config.create_date IS 'Created on';


--
-- Name: COLUMN res_config.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config.write_date IS 'Last Updated on';


--
-- Name: res_config_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.res_config_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.res_config_id_seq OWNER TO odoo;

--
-- Name: res_config_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.res_config_id_seq OWNED BY public.res_config.id;


--
-- Name: res_config_settings; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.res_config_settings (
    id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    web_app_name character varying,
    company_id integer NOT NULL,
    user_default_rights boolean,
    module_base_import boolean,
    module_google_calendar boolean,
    module_microsoft_calendar boolean,
    module_mail_plugin boolean,
    module_auth_oauth boolean,
    module_auth_ldap boolean,
    module_account_inter_company_rules boolean,
    module_voip boolean,
    module_web_unsplash boolean,
    module_sms boolean,
    module_partner_autocomplete boolean,
    module_base_geolocalize boolean,
    module_google_recaptcha boolean,
    module_website_cf_turnstile boolean,
    group_multi_currency boolean,
    show_effect boolean,
    module_product_images boolean,
    profiling_enabled_until timestamp without time zone,
    unsplash_access_key character varying,
    unsplash_app_id character varying,
    tenor_gif_limit integer,
    twilio_account_sid character varying,
    twilio_account_token character varying,
    sfu_server_url character varying,
    sfu_server_key character varying,
    tenor_api_key character varying,
    tenor_content_filter character varying,
    google_translate_api_key character varying,
    external_email_server_default boolean,
    module_google_gmail boolean,
    module_microsoft_outlook boolean,
    restrict_template_rendering boolean,
    use_twilio_rtc_servers boolean,
    group_analytic_accounting boolean,
    auth_signup_template_user_id integer,
    auth_signup_uninvited character varying,
    auth_signup_reset_password boolean,
    google_gmail_client_identifier character varying,
    google_gmail_client_secret character varying,
    product_weight_in_lbs character varying,
    product_volume_volume_in_cubic_feet character varying,
    group_uom boolean,
    group_product_variant boolean,
    module_loyalty boolean,
    group_stock_packaging boolean,
    group_product_pricelist boolean,
    digest_id integer,
    digest_emails boolean,
    chart_template character varying,
    module_account_accountant boolean,
    group_warning_account boolean,
    group_cash_rounding boolean,
    group_show_sale_receipts boolean,
    group_show_purchase_receipts boolean,
    module_account_budget boolean,
    module_account_payment boolean,
    module_account_reports boolean,
    module_account_check_printing boolean,
    module_account_batch_payment boolean,
    module_account_iso20022 boolean,
    module_account_sepa_direct_debit boolean,
    module_account_bank_statement_import_qif boolean,
    module_account_bank_statement_import_ofx boolean,
    module_account_bank_statement_import_csv boolean,
    module_account_bank_statement_import_camt boolean,
    module_currency_rate_live boolean,
    module_account_intrastat boolean,
    module_product_margin boolean,
    module_l10n_eu_oss boolean,
    module_account_extract boolean,
    module_account_invoice_extract boolean,
    module_account_bank_statement_extract boolean,
    module_snailmail_account boolean,
    module_account_peppol boolean,
    use_invoice_terms boolean,
    group_sale_delivery_address boolean,
    pay_invoices_online boolean,
    invoice_mail_template_id integer,
    default_invoice_policy character varying,
    group_auto_done_setting boolean,
    group_discount_per_so_line boolean,
    group_proforma_sales boolean,
    group_warning_sale boolean,
    automatic_invoice boolean,
    module_delivery boolean,
    module_delivery_bpost boolean,
    module_delivery_dhl boolean,
    module_delivery_easypost boolean,
    module_delivery_fedex boolean,
    module_delivery_sendcloud boolean,
    module_delivery_shiprocket boolean,
    module_delivery_ups boolean,
    module_delivery_usps boolean,
    module_delivery_starshipit boolean,
    module_product_email_template boolean,
    module_sale_amazon boolean,
    module_sale_loyalty boolean,
    module_sale_margin boolean,
    module_sale_product_matrix boolean,
    module_sale_pdf_quote_builder boolean,
    module_sale_commission boolean,
    group_sale_order_template boolean,
    module_hr_timesheet boolean,
    group_project_rating boolean,
    group_project_stages boolean,
    group_project_recurring_tasks boolean,
    group_project_task_dependencies boolean,
    group_project_milestone boolean,
    crm_auto_assignment_interval_number integer,
    crm_auto_assignment_action character varying,
    crm_auto_assignment_interval_type character varying,
    lead_enrich_auto character varying,
    predictive_lead_scoring_start_date_str character varying,
    predictive_lead_scoring_fields_str character varying,
    group_use_lead boolean,
    group_use_recurring_revenues boolean,
    is_membership_multi boolean,
    crm_use_auto_assignment boolean,
    module_crm_iap_mine boolean,
    module_crm_iap_enrich boolean,
    module_website_crm_iap_reveal boolean,
    lead_mining_in_pipeline boolean,
    crm_auto_assignment_run_datetime timestamp without time zone,
    barcode_separator character varying,
    module_product_expiry boolean,
    group_stock_production_lot boolean,
    group_stock_lot_print_gs1 boolean,
    group_lot_on_delivery_slip boolean,
    group_stock_tracking_lot boolean,
    group_stock_tracking_owner boolean,
    group_stock_adv_location boolean,
    group_warning_stock boolean,
    group_stock_sign_delivery boolean,
    module_stock_picking_batch boolean,
    module_stock_barcode boolean,
    module_stock_barcode_barcodelookup boolean,
    module_stock_sms boolean,
    module_quality_control boolean,
    module_quality_control_worksheet boolean,
    group_stock_multi_locations boolean,
    group_stock_reception_report boolean,
    module_stock_dropshipping boolean,
    module_stock_fleet boolean,
    module_stock_landed_costs boolean,
    group_lot_on_invoice boolean,
    group_stock_accounting_automatic boolean,
    default_picking_policy character varying NOT NULL,
    use_security_lead boolean,
    module_hr_presence boolean,
    module_hr_skills boolean,
    module_hr_homeworking boolean,
    hr_employee_self_edit boolean,
    use_manufacturing_lead boolean,
    group_mrp_byproducts boolean,
    module_mrp_mps boolean,
    module_mrp_plm boolean,
    module_mrp_subcontracting boolean,
    group_mrp_routings boolean,
    group_unlocked_by_default boolean,
    group_mrp_reception_report boolean,
    group_mrp_workorder_dependencies boolean,
    default_purchase_method character varying,
    lock_confirmed_po boolean,
    po_order_approval boolean,
    group_warning_purchase boolean,
    module_account_3way_match boolean,
    module_purchase_requisition boolean,
    module_purchase_product_matrix boolean,
    use_po_lead boolean,
    group_send_reminder boolean,
    is_installed_sale boolean,
    module_maintenance_worksheet boolean
);


ALTER TABLE public.res_config_settings OWNER TO odoo;

--
-- Name: TABLE res_config_settings; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.res_config_settings IS 'Config Settings';


--
-- Name: COLUMN res_config_settings.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.create_uid IS 'Created by';


--
-- Name: COLUMN res_config_settings.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.write_uid IS 'Last Updated by';


--
-- Name: COLUMN res_config_settings.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.create_date IS 'Created on';


--
-- Name: COLUMN res_config_settings.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.write_date IS 'Last Updated on';


--
-- Name: COLUMN res_config_settings.web_app_name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.web_app_name IS 'Web App Name';


--
-- Name: COLUMN res_config_settings.company_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.company_id IS 'Company';


--
-- Name: COLUMN res_config_settings.user_default_rights; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.user_default_rights IS 'Default Access Rights';


--
-- Name: COLUMN res_config_settings.module_base_import; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_base_import IS 'Allow users to import data from CSV/XLS/XLSX/ODS files';


--
-- Name: COLUMN res_config_settings.module_google_calendar; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_google_calendar IS 'Allow the users to synchronize their calendar  with Google Calendar';


--
-- Name: COLUMN res_config_settings.module_microsoft_calendar; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_microsoft_calendar IS 'Allow the users to synchronize their calendar with Outlook Calendar';


--
-- Name: COLUMN res_config_settings.module_mail_plugin; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_mail_plugin IS 'Allow integration with the mail plugins';


--
-- Name: COLUMN res_config_settings.module_auth_oauth; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_auth_oauth IS 'Use external authentication providers (OAuth)';


--
-- Name: COLUMN res_config_settings.module_auth_ldap; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_auth_ldap IS 'LDAP Authentication';


--
-- Name: COLUMN res_config_settings.module_account_inter_company_rules; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_account_inter_company_rules IS 'Manage Inter Company';


--
-- Name: COLUMN res_config_settings.module_voip; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_voip IS 'VoIP';


--
-- Name: COLUMN res_config_settings.module_web_unsplash; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_web_unsplash IS 'Unsplash Image Library';


--
-- Name: COLUMN res_config_settings.module_sms; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_sms IS 'SMS';


--
-- Name: COLUMN res_config_settings.module_partner_autocomplete; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_partner_autocomplete IS 'Partner Autocomplete';


--
-- Name: COLUMN res_config_settings.module_base_geolocalize; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_base_geolocalize IS 'GeoLocalize';


--
-- Name: COLUMN res_config_settings.module_google_recaptcha; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_google_recaptcha IS 'reCAPTCHA';


--
-- Name: COLUMN res_config_settings.module_website_cf_turnstile; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_website_cf_turnstile IS 'Cloudflare Turnstile';


--
-- Name: COLUMN res_config_settings.group_multi_currency; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.group_multi_currency IS 'Multi-Currencies';


--
-- Name: COLUMN res_config_settings.show_effect; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.show_effect IS 'Show Effect';


--
-- Name: COLUMN res_config_settings.module_product_images; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_product_images IS 'Get product pictures using barcode';


--
-- Name: COLUMN res_config_settings.profiling_enabled_until; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.profiling_enabled_until IS 'Profiling enabled until';


--
-- Name: COLUMN res_config_settings.unsplash_access_key; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.unsplash_access_key IS 'Access Key';


--
-- Name: COLUMN res_config_settings.unsplash_app_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.unsplash_app_id IS 'Application ID';


--
-- Name: COLUMN res_config_settings.tenor_gif_limit; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.tenor_gif_limit IS 'Tenor Gif Limit';


--
-- Name: COLUMN res_config_settings.twilio_account_sid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.twilio_account_sid IS 'Twilio Account SID';


--
-- Name: COLUMN res_config_settings.twilio_account_token; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.twilio_account_token IS 'Twilio Account Auth Token';


--
-- Name: COLUMN res_config_settings.sfu_server_url; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.sfu_server_url IS 'SFU Server URL';


--
-- Name: COLUMN res_config_settings.sfu_server_key; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.sfu_server_key IS 'SFU Server key';


--
-- Name: COLUMN res_config_settings.tenor_api_key; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.tenor_api_key IS 'Tenor API key';


--
-- Name: COLUMN res_config_settings.tenor_content_filter; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.tenor_content_filter IS 'Tenor content filter';


--
-- Name: COLUMN res_config_settings.google_translate_api_key; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.google_translate_api_key IS 'Message Translation API Key';


--
-- Name: COLUMN res_config_settings.external_email_server_default; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.external_email_server_default IS 'Use Custom Email Servers';


--
-- Name: COLUMN res_config_settings.module_google_gmail; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_google_gmail IS 'Support Gmail Authentication';


--
-- Name: COLUMN res_config_settings.module_microsoft_outlook; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_microsoft_outlook IS 'Support Outlook Authentication';


--
-- Name: COLUMN res_config_settings.restrict_template_rendering; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.restrict_template_rendering IS 'Restrict Template Rendering';


--
-- Name: COLUMN res_config_settings.use_twilio_rtc_servers; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.use_twilio_rtc_servers IS 'Use Twilio ICE servers';


--
-- Name: COLUMN res_config_settings.group_analytic_accounting; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.group_analytic_accounting IS 'Analytic Accounting';


--
-- Name: COLUMN res_config_settings.auth_signup_template_user_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.auth_signup_template_user_id IS 'Template user for new users created through signup';


--
-- Name: COLUMN res_config_settings.auth_signup_uninvited; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.auth_signup_uninvited IS 'Customer Account';


--
-- Name: COLUMN res_config_settings.auth_signup_reset_password; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.auth_signup_reset_password IS 'Enable password reset from Login page';


--
-- Name: COLUMN res_config_settings.google_gmail_client_identifier; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.google_gmail_client_identifier IS 'Gmail Client Id';


--
-- Name: COLUMN res_config_settings.google_gmail_client_secret; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.google_gmail_client_secret IS 'Gmail Client Secret';


--
-- Name: COLUMN res_config_settings.product_weight_in_lbs; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.product_weight_in_lbs IS 'Weight unit of measure';


--
-- Name: COLUMN res_config_settings.product_volume_volume_in_cubic_feet; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.product_volume_volume_in_cubic_feet IS 'Volume unit of measure';


--
-- Name: COLUMN res_config_settings.group_uom; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.group_uom IS 'Units of Measure';


--
-- Name: COLUMN res_config_settings.group_product_variant; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.group_product_variant IS 'Variants';


--
-- Name: COLUMN res_config_settings.module_loyalty; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_loyalty IS 'Promotions, Coupons, Gift Card & Loyalty Program';


--
-- Name: COLUMN res_config_settings.group_stock_packaging; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.group_stock_packaging IS 'Product Packagings';


--
-- Name: COLUMN res_config_settings.group_product_pricelist; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.group_product_pricelist IS 'Pricelists';


--
-- Name: COLUMN res_config_settings.digest_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.digest_id IS 'Digest Email';


--
-- Name: COLUMN res_config_settings.digest_emails; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.digest_emails IS 'Digest Emails';


--
-- Name: COLUMN res_config_settings.chart_template; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.chart_template IS 'Chart Template';


--
-- Name: COLUMN res_config_settings.module_account_accountant; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_account_accountant IS 'Accounting';


--
-- Name: COLUMN res_config_settings.group_warning_account; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.group_warning_account IS 'Warnings in Invoices';


--
-- Name: COLUMN res_config_settings.group_cash_rounding; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.group_cash_rounding IS 'Cash Rounding';


--
-- Name: COLUMN res_config_settings.group_show_sale_receipts; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.group_show_sale_receipts IS 'Sale Receipt';


--
-- Name: COLUMN res_config_settings.group_show_purchase_receipts; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.group_show_purchase_receipts IS 'Purchase Receipt';


--
-- Name: COLUMN res_config_settings.module_account_budget; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_account_budget IS 'Budget Management';


--
-- Name: COLUMN res_config_settings.module_account_payment; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_account_payment IS 'Invoice Online Payment';


--
-- Name: COLUMN res_config_settings.module_account_reports; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_account_reports IS 'Dynamic Reports';


--
-- Name: COLUMN res_config_settings.module_account_check_printing; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_account_check_printing IS 'Allow check printing and deposits';


--
-- Name: COLUMN res_config_settings.module_account_batch_payment; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_account_batch_payment IS 'Use batch payments';


--
-- Name: COLUMN res_config_settings.module_account_iso20022; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_account_iso20022 IS 'SEPA Credit Transfer / ISO20022';


--
-- Name: COLUMN res_config_settings.module_account_sepa_direct_debit; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_account_sepa_direct_debit IS 'Use SEPA Direct Debit';


--
-- Name: COLUMN res_config_settings.module_account_bank_statement_import_qif; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_account_bank_statement_import_qif IS 'Import .qif files';


--
-- Name: COLUMN res_config_settings.module_account_bank_statement_import_ofx; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_account_bank_statement_import_ofx IS 'Import in .ofx format';


--
-- Name: COLUMN res_config_settings.module_account_bank_statement_import_csv; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_account_bank_statement_import_csv IS 'Import in .csv, .xls, and .xlsx format';


--
-- Name: COLUMN res_config_settings.module_account_bank_statement_import_camt; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_account_bank_statement_import_camt IS 'Import in CAMT.053 format';


--
