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

COMMENT ON COLUMN public.repair_order.x_numero_serie IS 'Número de Serie';


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

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


--
-- Name: COLUMN repair_order.x_tipo_maquina; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_order.x_tipo_maquina IS 'Tipo/Modelo';


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

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


--
-- Name: COLUMN repair_order.x_voltios; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_order.x_voltios IS 'Voltios (V)';


--
-- Name: COLUMN repair_order.x_kva; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_order.x_kva IS 'Potencia (kVA)';


--
-- Name: COLUMN repair_order.x_rpm; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_order.x_rpm IS 'Velocidad (RPM)';


--
-- Name: COLUMN repair_order.x_amperios; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_order.x_amperios IS 'Amperios (A)';


--
-- Name: COLUMN repair_order.x_hz; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_order.x_hz IS 'Frecuencia (Hz)';


--
-- Name: COLUMN repair_order.x_numero_ot; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_order.x_numero_ot IS 'Nº OT';


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

COMMENT ON COLUMN public.repair_order.x_albaran IS 'Nº Albarán';


--
-- Name: COLUMN repair_order.x_albaran_nota; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_order.x_albaran_nota IS 'Nota Albarán';


--
-- Name: COLUMN repair_order.x_presupuesto; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_order.x_presupuesto IS 'Nº Presupuesto';


--
-- Name: COLUMN repair_order.x_numero_pedido; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_order.x_numero_pedido IS 'Nº Pedido Cliente';


--
-- Name: COLUMN repair_order.x_pedido_proveedor; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_order.x_pedido_proveedor IS 'Pedido a Proveedores';


--
-- Name: COLUMN repair_order.x_comentarios; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.repair_order.x_comentarios IS 'Comentarios';


--
-- 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,
    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.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,
    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.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,
    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,
    website_id integer,
    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.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: COLUMN res_company.website_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.website_id IS 'Website';


--
-- 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,
    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,
    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,
    recaptcha_public_key character varying,
    recaptcha_private_key character varying,
    recaptcha_min_score double precision,
    website_id integer,
    group_multi_website boolean,
    module_website_livechat boolean,
    module_marketing_automation 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';


--
-- Name: COLUMN res_config_settings.module_currency_rate_live; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_currency_rate_live IS 'Automatic Currency Rates';


--
-- Name: COLUMN res_config_settings.module_account_intrastat; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_account_intrastat IS 'Intrastat';


--
-- Name: COLUMN res_config_settings.module_product_margin; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_product_margin IS 'Allow Product Margin';


--
-- Name: COLUMN res_config_settings.module_l10n_eu_oss; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_l10n_eu_oss IS 'EU Intra-community Distance Selling';


--
-- Name: COLUMN res_config_settings.module_account_extract; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_account_extract IS 'Document Digitization';


--
-- Name: COLUMN res_config_settings.module_account_invoice_extract; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_account_invoice_extract IS 'Invoice Digitization';


--
-- Name: COLUMN res_config_settings.module_account_bank_statement_extract; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_account_bank_statement_extract IS 'Bank Statement Digitization';


--
-- Name: COLUMN res_config_settings.module_snailmail_account; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_snailmail_account IS 'Snailmail';


--
-- Name: COLUMN res_config_settings.module_account_peppol; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_account_peppol IS 'PEPPOL Invoicing';


--
-- Name: COLUMN res_config_settings.use_invoice_terms; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.use_invoice_terms IS 'Default Terms & Conditions';


--
-- Name: COLUMN res_config_settings.group_sale_delivery_address; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.group_sale_delivery_address IS 'Customer Addresses';


--
-- Name: COLUMN res_config_settings.pay_invoices_online; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.pay_invoices_online IS 'Pay Invoices Online';


--
-- Name: COLUMN res_config_settings.invoice_mail_template_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.invoice_mail_template_id IS 'Invoice Email Template';


--
-- Name: COLUMN res_config_settings.default_invoice_policy; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.default_invoice_policy IS 'Invoicing Policy';


--
-- Name: COLUMN res_config_settings.group_auto_done_setting; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.group_auto_done_setting IS 'Lock Confirmed Sales';


--
-- Name: COLUMN res_config_settings.group_discount_per_so_line; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.group_discount_per_so_line IS 'Discounts';


--
-- Name: COLUMN res_config_settings.group_proforma_sales; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.group_proforma_sales IS 'Pro-Forma Invoice';


--
-- Name: COLUMN res_config_settings.group_warning_sale; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.group_warning_sale IS 'Sale Order Warnings';


--
-- Name: COLUMN res_config_settings.automatic_invoice; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.automatic_invoice IS 'Automatic Invoice';


--
-- Name: COLUMN res_config_settings.module_delivery; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_delivery IS 'Delivery Methods';


--
-- Name: COLUMN res_config_settings.module_delivery_bpost; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_delivery_bpost IS 'bpost Connector';


--
-- Name: COLUMN res_config_settings.module_delivery_dhl; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_delivery_dhl IS 'DHL Express Connector';


--
-- Name: COLUMN res_config_settings.module_delivery_easypost; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_delivery_easypost IS 'Easypost Connector';


--
-- Name: COLUMN res_config_settings.module_delivery_fedex; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_delivery_fedex IS 'FedEx Connector';


--
-- Name: COLUMN res_config_settings.module_delivery_sendcloud; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_delivery_sendcloud IS 'Sendcloud Connector';


--
-- Name: COLUMN res_config_settings.module_delivery_shiprocket; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_delivery_shiprocket IS 'Shiprocket Connector';


--
-- Name: COLUMN res_config_settings.module_delivery_ups; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_delivery_ups IS 'UPS Connector';


--
-- Name: COLUMN res_config_settings.module_delivery_usps; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_delivery_usps IS 'USPS Connector';


--
-- Name: COLUMN res_config_settings.module_delivery_starshipit; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_delivery_starshipit IS 'Starshipit Connector';


--
-- Name: COLUMN res_config_settings.module_product_email_template; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_product_email_template IS 'Specific Email';


--
-- Name: COLUMN res_config_settings.module_sale_amazon; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_sale_amazon IS 'Amazon Sync';


--
-- Name: COLUMN res_config_settings.module_sale_loyalty; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_sale_loyalty IS 'Coupons & Loyalty';


--
-- Name: COLUMN res_config_settings.module_sale_margin; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_sale_margin IS 'Margins';


--
-- Name: COLUMN res_config_settings.module_sale_product_matrix; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_sale_product_matrix IS 'Sales Grid Entry';


--
-- Name: COLUMN res_config_settings.module_sale_pdf_quote_builder; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_sale_pdf_quote_builder IS 'PDF Quote builder';


--
-- Name: COLUMN res_config_settings.module_sale_commission; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_sale_commission IS 'Commissions';


--
-- Name: COLUMN res_config_settings.group_sale_order_template; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.group_sale_order_template IS 'Quotation Templates';


--
-- Name: COLUMN res_config_settings.module_hr_timesheet; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_hr_timesheet IS 'Task Logs';


--
-- Name: COLUMN res_config_settings.group_project_rating; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.group_project_rating IS 'Customer Ratings';


--
-- Name: COLUMN res_config_settings.group_project_stages; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.group_project_stages IS 'Project Stages';


--
-- Name: COLUMN res_config_settings.group_project_recurring_tasks; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.group_project_recurring_tasks IS 'Recurring Tasks';


--
-- Name: COLUMN res_config_settings.group_project_task_dependencies; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.group_project_task_dependencies IS 'Task Dependencies';


--
-- Name: COLUMN res_config_settings.group_project_milestone; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.group_project_milestone IS 'Milestones';


--
-- Name: COLUMN res_config_settings.barcode_separator; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.barcode_separator IS 'Separator';


--
-- Name: COLUMN res_config_settings.module_product_expiry; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_product_expiry IS 'Expiration Dates';


--
-- Name: COLUMN res_config_settings.group_stock_production_lot; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.group_stock_production_lot IS 'Lots & Serial Numbers';


--
-- Name: COLUMN res_config_settings.group_stock_lot_print_gs1; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.group_stock_lot_print_gs1 IS 'Print GS1 Barcodes for Lots & Serial Numbers';


--
-- Name: COLUMN res_config_settings.group_lot_on_delivery_slip; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.group_lot_on_delivery_slip IS 'Display Lots & Serial Numbers on Delivery Slips';


--
-- Name: COLUMN res_config_settings.group_stock_tracking_lot; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.group_stock_tracking_lot IS 'Packages';


--
-- Name: COLUMN res_config_settings.group_stock_tracking_owner; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.group_stock_tracking_owner IS 'Consignment';


--
-- Name: COLUMN res_config_settings.group_stock_adv_location; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.group_stock_adv_location IS 'Multi-Step Routes';


--
-- Name: COLUMN res_config_settings.group_warning_stock; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.group_warning_stock IS 'Warnings for Stock';


--
-- Name: COLUMN res_config_settings.group_stock_sign_delivery; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.group_stock_sign_delivery IS 'Signature';


--
-- Name: COLUMN res_config_settings.module_stock_picking_batch; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_stock_picking_batch IS 'Batch, Wave & Cluster Transfers';


--
-- Name: COLUMN res_config_settings.module_stock_barcode; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_stock_barcode IS 'Barcode Scanner';


--
-- Name: COLUMN res_config_settings.module_stock_barcode_barcodelookup; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_stock_barcode_barcodelookup IS 'Stock Barcode Database';


--
-- Name: COLUMN res_config_settings.module_stock_sms; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_stock_sms IS 'SMS Confirmation';


--
-- Name: COLUMN res_config_settings.module_quality_control; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_quality_control IS 'Quality';


--
-- Name: COLUMN res_config_settings.module_quality_control_worksheet; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_quality_control_worksheet IS 'Quality Worksheet';


--
-- Name: COLUMN res_config_settings.group_stock_multi_locations; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.group_stock_multi_locations IS 'Storage Locations';


--
-- Name: COLUMN res_config_settings.group_stock_reception_report; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.group_stock_reception_report IS 'Reception Report';


--
-- Name: COLUMN res_config_settings.module_stock_dropshipping; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_stock_dropshipping IS 'Dropshipping';


--
-- Name: COLUMN res_config_settings.module_stock_fleet; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_stock_fleet IS 'Dispatch Management System';


--
-- Name: COLUMN res_config_settings.module_stock_landed_costs; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_stock_landed_costs IS 'Landed Costs';


--
-- Name: COLUMN res_config_settings.group_lot_on_invoice; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.group_lot_on_invoice IS 'Display Lots & Serial Numbers on Invoices';


--
-- Name: COLUMN res_config_settings.group_stock_accounting_automatic; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.group_stock_accounting_automatic IS 'Automatic Stock Accounting';


--
-- Name: COLUMN res_config_settings.default_picking_policy; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.default_picking_policy IS 'Picking Policy';


--
-- Name: COLUMN res_config_settings.use_security_lead; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.use_security_lead IS 'Security Lead Time for Sales';


--
-- Name: COLUMN res_config_settings.module_hr_presence; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_hr_presence IS 'Advanced Presence Control';


--
-- Name: COLUMN res_config_settings.module_hr_skills; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_hr_skills IS 'Skills Management';


--
-- Name: COLUMN res_config_settings.module_hr_homeworking; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_hr_homeworking IS 'Remote Work';


--
-- Name: COLUMN res_config_settings.hr_employee_self_edit; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.hr_employee_self_edit IS 'Employee Editing';


--
-- Name: COLUMN res_config_settings.default_purchase_method; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.default_purchase_method IS 'Bill Control';


--
-- Name: COLUMN res_config_settings.lock_confirmed_po; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.lock_confirmed_po IS 'Lock Confirmed Orders';


--
-- Name: COLUMN res_config_settings.po_order_approval; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.po_order_approval IS 'Purchase Order Approval';


--
-- Name: COLUMN res_config_settings.group_warning_purchase; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.group_warning_purchase IS 'Purchase Warnings';


--
-- Name: COLUMN res_config_settings.module_account_3way_match; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_account_3way_match IS '3-way matching: purchases, receptions and bills';


--
-- Name: COLUMN res_config_settings.module_purchase_requisition; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_purchase_requisition IS 'Purchase Agreements';


--
-- Name: COLUMN res_config_settings.module_purchase_product_matrix; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_purchase_product_matrix IS 'Purchase Grid Entry';


--
-- Name: COLUMN res_config_settings.use_po_lead; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.use_po_lead IS 'Security Lead Time for Purchase';


--
-- Name: COLUMN res_config_settings.group_send_reminder; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.group_send_reminder IS 'Receipt Reminder';


--
-- Name: COLUMN res_config_settings.is_installed_sale; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.is_installed_sale IS 'Is the Sale Module Installed';


--
-- Name: COLUMN res_config_settings.module_maintenance_worksheet; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_maintenance_worksheet IS 'Custom Maintenance Worksheets';


--
-- Name: COLUMN res_config_settings.recaptcha_public_key; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.recaptcha_public_key IS 'Site Key';


--
-- Name: COLUMN res_config_settings.recaptcha_private_key; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.recaptcha_private_key IS 'Secret Key';


--
-- Name: COLUMN res_config_settings.recaptcha_min_score; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.recaptcha_min_score IS 'Minimum score';


--
-- Name: COLUMN res_config_settings.website_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.website_id IS 'website';


--
-- Name: COLUMN res_config_settings.group_multi_website; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.group_multi_website IS 'Multi-website';


--
-- Name: COLUMN res_config_settings.module_website_livechat; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_website_livechat IS 'Module Website Livechat';


--
-- Name: COLUMN res_config_settings.module_marketing_automation; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.module_marketing_automation IS 'Module Marketing Automation';


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

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


ALTER SEQUENCE public.res_config_settings_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.res_config_settings_id_seq OWNED BY public.res_config_settings.id;


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

CREATE TABLE public.res_country (
    id integer NOT NULL,
    address_view_id integer,
    currency_id integer,
    phone_code integer,
    create_uid integer,
    write_uid integer,
    code character varying(2) NOT NULL,
    name_position character varying,
    name jsonb NOT NULL,
    vat_label jsonb,
    address_format text,
    state_required boolean,
    zip_required boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.res_country OWNER TO odoo;

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

COMMENT ON TABLE public.res_country IS 'Country';


--
-- Name: COLUMN res_country.address_view_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_country.address_view_id IS 'Input View';


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

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


--
-- Name: COLUMN res_country.phone_code; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_country.phone_code IS 'Country Calling Code';


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

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


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

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


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

COMMENT ON COLUMN public.res_country.code IS 'Country Code';


--
-- Name: COLUMN res_country.name_position; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_country.name_position IS 'Customer Name Position';


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

COMMENT ON COLUMN public.res_country.name IS 'Country Name';


--
-- Name: COLUMN res_country.vat_label; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_country.vat_label IS 'Vat Label';


--
-- Name: COLUMN res_country.address_format; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_country.address_format IS 'Layout in Reports';


--
-- Name: COLUMN res_country.state_required; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_country.state_required IS 'State Required';


--
-- Name: COLUMN res_country.zip_required; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_country.zip_required IS 'Zip Required';


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

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


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

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


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

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

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

COMMENT ON TABLE public.res_country_group IS 'Country Group';


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

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


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

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


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

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


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

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


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

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


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

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


ALTER SEQUENCE public.res_country_group_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.res_country_group_id_seq OWNED BY public.res_country_group.id;


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

CREATE TABLE public.res_country_group_pricelist_rel (
    pricelist_id integer NOT NULL,
    res_country_group_id integer NOT NULL
);


ALTER TABLE public.res_country_group_pricelist_rel OWNER TO odoo;

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

COMMENT ON TABLE public.res_country_group_pricelist_rel IS 'RELATION BETWEEN product_pricelist AND res_country_group';


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

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


ALTER SEQUENCE public.res_country_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.res_country_id_seq OWNED BY public.res_country.id;


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

CREATE TABLE public.res_country_res_country_group_rel (
    res_country_id integer NOT NULL,
    res_country_group_id integer NOT NULL
);


ALTER TABLE public.res_country_res_country_group_rel OWNER TO odoo;

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

COMMENT ON TABLE public.res_country_res_country_group_rel IS 'RELATION BETWEEN res_country AND res_country_group';


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

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


ALTER TABLE public.res_country_state OWNER TO odoo;

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

COMMENT ON TABLE public.res_country_state IS 'Country state';


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

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


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

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


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

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


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

COMMENT ON COLUMN public.res_country_state.name IS 'State Name';


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

COMMENT ON COLUMN public.res_country_state.code IS 'State Code';


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

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


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

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


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

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


ALTER SEQUENCE public.res_country_state_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.res_country_state_id_seq OWNED BY public.res_country_state.id;


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

CREATE TABLE public.res_currency (
    id integer NOT NULL,
    name character varying NOT NULL,
    symbol character varying NOT NULL,
    iso_numeric integer,
    decimal_places integer,
    create_uid integer,
    write_uid integer,
    full_name character varying,
    "position" character varying,
    currency_unit_label jsonb,
    currency_subunit_label jsonb,
    rounding numeric,
    active boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    CONSTRAINT res_currency_rounding_gt_zero CHECK ((rounding > (0)::numeric))
);


ALTER TABLE public.res_currency OWNER TO odoo;

--
-- Name: COLUMN res_currency.iso_numeric; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_currency.iso_numeric IS 'Currency numeric code.';


--
-- Name: COLUMN res_currency.decimal_places; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_currency.decimal_places IS 'Decimal Places';


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

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


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

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


--
-- Name: COLUMN res_currency.full_name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_currency.full_name IS 'Name';


--
-- Name: COLUMN res_currency."position"; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_currency."position" IS 'Symbol Position';


--
-- Name: COLUMN res_currency.currency_unit_label; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_currency.currency_unit_label IS 'Currency Unit';


--
-- Name: COLUMN res_currency.currency_subunit_label; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_currency.currency_subunit_label IS 'Currency Subunit';


--
-- Name: COLUMN res_currency.rounding; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_currency.rounding IS 'Rounding Factor';


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

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


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

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


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

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


--
-- Name: CONSTRAINT res_currency_rounding_gt_zero ON res_currency; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT res_currency_rounding_gt_zero ON public.res_currency IS 'CHECK (rounding>0)';


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

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


ALTER SEQUENCE public.res_currency_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.res_currency_id_seq OWNED BY public.res_currency.id;


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

CREATE TABLE public.res_currency_rate (
    id integer NOT NULL,
    currency_id integer NOT NULL,
    company_id integer,
    create_uid integer,
    write_uid integer,
    name date NOT NULL,
    rate numeric,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    CONSTRAINT res_currency_rate_currency_rate_check CHECK ((rate > (0)::numeric))
);


ALTER TABLE public.res_currency_rate OWNER TO odoo;

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

COMMENT ON TABLE public.res_currency_rate IS 'Currency Rate';


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

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


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

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


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

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


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

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


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

COMMENT ON COLUMN public.res_currency_rate.name IS 'Date';


--
-- Name: COLUMN res_currency_rate.rate; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_currency_rate.rate IS 'Technical Rate';


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

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


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

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


--
-- Name: CONSTRAINT res_currency_rate_currency_rate_check ON res_currency_rate; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT res_currency_rate_currency_rate_check ON public.res_currency_rate IS 'CHECK (rate>0)';


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

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


ALTER SEQUENCE public.res_currency_rate_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.res_currency_rate_id_seq OWNED BY public.res_currency_rate.id;


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

CREATE TABLE public.res_device_log (
    id integer NOT NULL,
    user_id integer,
    create_uid integer,
    write_uid integer,
    session_identifier character varying NOT NULL,
    platform character varying,
    browser character varying,
    ip_address character varying,
    country character varying,
    city character varying,
    device_type character varying,
    revoked boolean,
    first_activity timestamp without time zone,
    last_activity timestamp without time zone,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.res_device_log OWNER TO odoo;

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

COMMENT ON TABLE public.res_device_log IS 'Device Log';


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

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


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

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


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

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


--
-- Name: COLUMN res_device_log.session_identifier; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_device_log.session_identifier IS 'Session Identifier';


--
-- Name: COLUMN res_device_log.platform; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_device_log.platform IS 'Platform';


--
-- Name: COLUMN res_device_log.browser; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_device_log.browser IS 'Browser';


--
-- Name: COLUMN res_device_log.ip_address; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_device_log.ip_address IS 'IP Address';


--
-- Name: COLUMN res_device_log.country; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_device_log.country IS 'Country';


--
-- Name: COLUMN res_device_log.city; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_device_log.city IS 'City';


--
-- Name: COLUMN res_device_log.device_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_device_log.device_type IS 'Device Type';


--
-- Name: COLUMN res_device_log.revoked; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_device_log.revoked IS 'Revoked';


--
-- Name: COLUMN res_device_log.first_activity; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_device_log.first_activity IS 'First Activity';


--
-- Name: COLUMN res_device_log.last_activity; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_device_log.last_activity IS 'Last Activity';


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

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


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

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


--
-- Name: res_device; Type: VIEW; Schema: public; Owner: odoo
--

CREATE VIEW public.res_device AS
 SELECT id,
    user_id,
    create_uid,
    write_uid,
    session_identifier,
    platform,
    browser,
    ip_address,
    country,
    city,
    device_type,
    revoked,
    first_activity,
    last_activity,
    create_date,
    write_date
   FROM public.res_device_log d
  WHERE ((NOT (EXISTS ( SELECT 1
           FROM public.res_device_log d2
          WHERE ((d2.user_id = d.user_id) AND ((d2.session_identifier)::text = (d.session_identifier)::text) AND (NOT ((d2.platform)::text IS DISTINCT FROM (d.platform)::text)) AND (NOT ((d2.browser)::text IS DISTINCT FROM (d.browser)::text)) AND ((d2.last_activity > d.last_activity) OR ((d2.last_activity = d.last_activity) AND (d2.id > d.id))) AND (d2.revoked = false))))) AND (revoked = false));


ALTER VIEW public.res_device OWNER TO odoo;

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

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


ALTER SEQUENCE public.res_device_log_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.res_device_log_id_seq OWNED BY public.res_device_log.id;


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

CREATE TABLE public.res_groups (
    id integer NOT NULL,
    name jsonb NOT NULL,
    category_id integer,
    color integer,
    create_uid integer,
    write_uid integer,
    comment jsonb,
    share boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    api_key_duration double precision,
    CONSTRAINT res_groups_check_api_key_duration CHECK ((api_key_duration >= (0)::double precision))
);


ALTER TABLE public.res_groups OWNER TO odoo;

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

COMMENT ON COLUMN public.res_groups.category_id IS 'Application';


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

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


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

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


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

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


--
-- Name: COLUMN res_groups.comment; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_groups.comment IS 'Comment';


--
-- Name: COLUMN res_groups.share; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_groups.share IS 'Share Group';


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

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


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

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


--
-- Name: COLUMN res_groups.api_key_duration; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_groups.api_key_duration IS 'API Keys maximum duration days';


--
-- Name: CONSTRAINT res_groups_check_api_key_duration ON res_groups; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT res_groups_check_api_key_duration ON public.res_groups IS 'CHECK(api_key_duration >= 0)';


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

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


ALTER SEQUENCE public.res_groups_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.res_groups_id_seq OWNED BY public.res_groups.id;


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

CREATE TABLE public.res_groups_implied_rel (
    gid integer NOT NULL,
    hid integer NOT NULL
);


ALTER TABLE public.res_groups_implied_rel OWNER TO odoo;

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

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


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

CREATE TABLE public.res_groups_report_rel (
    uid integer NOT NULL,
    gid integer NOT NULL
);


ALTER TABLE public.res_groups_report_rel OWNER TO odoo;

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

COMMENT ON TABLE public.res_groups_report_rel IS 'RELATION BETWEEN ir_act_report_xml AND res_groups';


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

CREATE TABLE public.res_groups_spreadsheet_dashboard_rel (
    spreadsheet_dashboard_id integer NOT NULL,
    res_groups_id integer NOT NULL
);


ALTER TABLE public.res_groups_spreadsheet_dashboard_rel OWNER TO odoo;

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

COMMENT ON TABLE public.res_groups_spreadsheet_dashboard_rel IS 'RELATION BETWEEN spreadsheet_dashboard AND res_groups';


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

CREATE TABLE public.res_groups_users_rel (
    gid integer NOT NULL,
    uid integer NOT NULL
);


ALTER TABLE public.res_groups_users_rel OWNER TO odoo;

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

COMMENT ON TABLE public.res_groups_users_rel IS 'RELATION BETWEEN res_groups AND res_users';


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

CREATE TABLE public.res_groups_website_menu_rel (
    website_menu_id integer NOT NULL,
    res_groups_id integer NOT NULL
);


ALTER TABLE public.res_groups_website_menu_rel OWNER TO odoo;

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

COMMENT ON TABLE public.res_groups_website_menu_rel IS 'RELATION BETWEEN website_menu AND res_groups';


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

CREATE TABLE public.res_lang (
    id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    name character varying NOT NULL,
    code character varying NOT NULL,
    iso_code character varying,
    url_code character varying NOT NULL,
    direction character varying NOT NULL,
    date_format character varying NOT NULL,
    time_format character varying NOT NULL,
    short_time_format character varying NOT NULL,
    week_start character varying NOT NULL,
    "grouping" character varying NOT NULL,
    decimal_point character varying NOT NULL,
    thousands_sep character varying,
    active boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.res_lang OWNER TO odoo;

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

COMMENT ON TABLE public.res_lang IS 'Languages';


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

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


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

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


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

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


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

COMMENT ON COLUMN public.res_lang.code IS 'Locale Code';


--
-- Name: COLUMN res_lang.iso_code; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_lang.iso_code IS 'ISO code';


--
-- Name: COLUMN res_lang.url_code; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_lang.url_code IS 'URL Code';


--
-- Name: COLUMN res_lang.direction; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_lang.direction IS 'Direction';


--
-- Name: COLUMN res_lang.date_format; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_lang.date_format IS 'Date Format';


--
-- Name: COLUMN res_lang.time_format; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_lang.time_format IS 'Time Format';


--
-- Name: COLUMN res_lang.short_time_format; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_lang.short_time_format IS 'Short Time Format';


--
-- Name: COLUMN res_lang.week_start; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_lang.week_start IS 'First Day of Week';


--
-- Name: COLUMN res_lang."grouping"; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_lang."grouping" IS 'Separator Format';


--
-- Name: COLUMN res_lang.decimal_point; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_lang.decimal_point IS 'Decimal Separator';


--
-- Name: COLUMN res_lang.thousands_sep; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_lang.thousands_sep IS 'Thousands Separator';


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

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


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

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


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

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


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

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


ALTER SEQUENCE public.res_lang_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.res_lang_id_seq OWNED BY public.res_lang.id;


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

CREATE TABLE public.res_lang_install_rel (
    language_wizard_id integer NOT NULL,
    lang_id integer NOT NULL
);


ALTER TABLE public.res_lang_install_rel OWNER TO odoo;

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

COMMENT ON TABLE public.res_lang_install_rel IS 'RELATION BETWEEN base_language_install AND res_lang';


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

CREATE TABLE public.res_partner (
    id integer NOT NULL,
    company_id integer,
    create_date timestamp without time zone,
    name character varying,
    title integer,
    parent_id integer,
    user_id integer,
    state_id integer,
    country_id integer,
    industry_id integer,
    color integer,
    commercial_partner_id integer,
    create_uid integer,
    write_uid integer,
    complete_name character varying,
    ref character varying,
    lang character varying,
    tz character varying,
    vat character varying,
    company_registry character varying,
    website character varying,
    function character varying,
    type character varying,
    street character varying,
    street2 character varying,
    zip character varying,
    city character varying,
    email character varying,
    phone character varying,
    mobile character varying,
    commercial_company_name character varying,
    company_name character varying,
    barcode jsonb,
    comment text,
    partner_latitude numeric,
    partner_longitude numeric,
    active boolean,
    employee boolean,
    is_company boolean,
    partner_share boolean,
    write_date timestamp without time zone,
    message_bounce integer,
    email_normalized character varying,
    signup_type character varying,
    specific_property_product_pricelist jsonb,
    partner_gid integer,
    additional_info character varying,
    phone_sanitized character varying,
    invoice_template_pdf_report_id integer,
    supplier_rank integer,
    customer_rank integer,
    invoice_warn character varying,
    autopost_bills character varying NOT NULL,
    credit_limit jsonb,
    property_account_payable_id jsonb,
    property_account_receivable_id jsonb,
    property_account_position_id jsonb,
    property_payment_term_id jsonb,
    property_supplier_payment_term_id jsonb,
    trust jsonb,
    ignore_abnormal_invoice_date jsonb,
    ignore_abnormal_invoice_amount jsonb,
    invoice_sending_method jsonb,
    invoice_edi_format_store jsonb,
    property_outbound_payment_method_line_id jsonb,
    property_inbound_payment_method_line_id jsonb,
    invoice_warn_msg text,
    debit_limit numeric,
    global_location_number character varying,
    peppol_endpoint character varying,
    peppol_eas character varying,
    vies_valid boolean,
    peppol_verification_state jsonb,
    sale_warn character varying,
    sale_warn_msg text,
    peppol_supported_documents jsonb,
    l10n_es_edi_facturae_ac_center_code character varying(10),
    l10n_es_edi_facturae_ac_physical_gln character varying(14),
    l10n_es_edi_facturae_ac_logical_operational_point character varying(14),
    calendar_last_notif_ack timestamp without time zone,
    picking_warn character varying,
    property_stock_customer jsonb,
    property_stock_supplier jsonb,
    picking_warn_msg text,
    buyer_id integer,
    purchase_warn character varying,
    property_purchase_currency_id jsonb,
    receipt_reminder_email jsonb,
    reminder_date_before_receipt jsonb,
    purchase_warn_msg text,
    website_id integer,
    is_published boolean,
    CONSTRAINT res_partner_check_name CHECK (((((type)::text = 'contact'::text) AND (name IS NOT NULL)) OR ((type)::text <> 'contact'::text)))
);


ALTER TABLE public.res_partner OWNER TO odoo;

--
-- Name: COLUMN res_partner.title; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.title IS 'Title';


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

COMMENT ON COLUMN public.res_partner.parent_id IS 'Related Company';


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

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


--
-- Name: COLUMN res_partner.state_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.state_id IS 'State';


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

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


--
-- Name: COLUMN res_partner.industry_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.industry_id IS 'Industry';


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

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


--
-- Name: COLUMN res_partner.commercial_partner_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.commercial_partner_id IS 'Commercial Entity';


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

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


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

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


--
-- Name: COLUMN res_partner.complete_name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.complete_name IS 'Complete Name';


--
-- Name: COLUMN res_partner.ref; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.ref IS 'Reference';


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

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


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

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


--
-- Name: COLUMN res_partner.vat; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.vat IS 'Tax ID';


--
-- Name: COLUMN res_partner.company_registry; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.company_registry IS 'Company ID';


--
-- Name: COLUMN res_partner.website; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.website IS 'Website Link';


--
-- Name: COLUMN res_partner.function; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.function IS 'Job Position';


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

COMMENT ON COLUMN public.res_partner.type IS 'Address Type';


--
-- Name: COLUMN res_partner.street; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.street IS 'Street';


--
-- Name: COLUMN res_partner.street2; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.street2 IS 'Street2';


--
-- Name: COLUMN res_partner.zip; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.zip IS 'Zip';


--
-- Name: COLUMN res_partner.city; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.city IS 'City';


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

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


--
-- Name: COLUMN res_partner.phone; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.phone IS 'Phone';


--
-- Name: COLUMN res_partner.mobile; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.mobile IS 'Mobile';


--
-- Name: COLUMN res_partner.commercial_company_name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.commercial_company_name IS 'Company Name Entity';


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

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


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

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


--
-- Name: COLUMN res_partner.comment; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.comment IS 'Notes';


--
-- Name: COLUMN res_partner.partner_latitude; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.partner_latitude IS 'Geo Latitude';


--
-- Name: COLUMN res_partner.partner_longitude; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.partner_longitude IS 'Geo Longitude';


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

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


--
-- Name: COLUMN res_partner.employee; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.employee IS 'Employee';


--
-- Name: COLUMN res_partner.is_company; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.is_company IS 'Is a Company';


--
-- Name: COLUMN res_partner.partner_share; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.partner_share IS 'Share Partner';


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

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


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

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


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

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


--
-- Name: COLUMN res_partner.signup_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.signup_type IS 'Signup Token Type';


--
-- Name: COLUMN res_partner.specific_property_product_pricelist; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.specific_property_product_pricelist IS 'Specific Property Product Pricelist';


--
-- Name: COLUMN res_partner.partner_gid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.partner_gid IS 'Company database ID';


--
-- Name: COLUMN res_partner.additional_info; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.additional_info IS 'Additional info';


--
-- Name: COLUMN res_partner.phone_sanitized; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.phone_sanitized IS 'Sanitized Number';


--
-- Name: COLUMN res_partner.invoice_template_pdf_report_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.invoice_template_pdf_report_id IS 'Invoice template';


--
-- Name: COLUMN res_partner.supplier_rank; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.supplier_rank IS 'Supplier Rank';


--
-- Name: COLUMN res_partner.customer_rank; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.customer_rank IS 'Customer Rank';


--
-- Name: COLUMN res_partner.invoice_warn; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.invoice_warn IS 'Invoice';


--
-- Name: COLUMN res_partner.autopost_bills; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.autopost_bills IS 'Auto-post bills';


--
-- Name: COLUMN res_partner.credit_limit; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.credit_limit IS 'Credit Limit';


--
-- Name: COLUMN res_partner.property_account_payable_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.property_account_payable_id IS 'Account Payable';


--
-- Name: COLUMN res_partner.property_account_receivable_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.property_account_receivable_id IS 'Account Receivable';


--
-- Name: COLUMN res_partner.property_account_position_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.property_account_position_id IS 'Fiscal Position';


--
-- Name: COLUMN res_partner.property_payment_term_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.property_payment_term_id IS 'Customer Payment Terms';


--
-- Name: COLUMN res_partner.property_supplier_payment_term_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.property_supplier_payment_term_id IS 'Vendor Payment Terms';


--
-- Name: COLUMN res_partner.trust; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.trust IS 'Degree of trust you have in this debtor';


--
-- Name: COLUMN res_partner.ignore_abnormal_invoice_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.ignore_abnormal_invoice_date IS 'Ignore Abnormal Invoice Date';


--
-- Name: COLUMN res_partner.ignore_abnormal_invoice_amount; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.ignore_abnormal_invoice_amount IS 'Ignore Abnormal Invoice Amount';


--
-- Name: COLUMN res_partner.invoice_sending_method; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.invoice_sending_method IS 'Invoice sending';


--
-- Name: COLUMN res_partner.invoice_edi_format_store; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.invoice_edi_format_store IS 'Invoice Edi Format Store';


--
-- Name: COLUMN res_partner.property_outbound_payment_method_line_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.property_outbound_payment_method_line_id IS 'Property Outbound Payment Method Line';


--
-- Name: COLUMN res_partner.property_inbound_payment_method_line_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.property_inbound_payment_method_line_id IS 'Property Inbound Payment Method Line';


--
-- Name: COLUMN res_partner.invoice_warn_msg; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.invoice_warn_msg IS 'Message for Invoice';


--
-- Name: COLUMN res_partner.debit_limit; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.debit_limit IS 'Payable Limit';


--
-- Name: COLUMN res_partner.global_location_number; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.global_location_number IS 'GLN';


--
-- Name: COLUMN res_partner.peppol_endpoint; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.peppol_endpoint IS 'Peppol Endpoint';


--
-- Name: COLUMN res_partner.peppol_eas; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.peppol_eas IS 'Peppol e-address (EAS)';


--
-- Name: COLUMN res_partner.vies_valid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.vies_valid IS 'Intra-Community Valid';


--
-- Name: COLUMN res_partner.peppol_verification_state; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.peppol_verification_state IS 'Peppol status';


--
-- Name: COLUMN res_partner.sale_warn; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.sale_warn IS 'Sales Warnings';


--
-- Name: COLUMN res_partner.sale_warn_msg; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.sale_warn_msg IS 'Message for Sales Order';


--
-- Name: COLUMN res_partner.peppol_supported_documents; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.peppol_supported_documents IS 'Supported Peppol Documents';


--
-- Name: COLUMN res_partner.l10n_es_edi_facturae_ac_center_code; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.l10n_es_edi_facturae_ac_center_code IS 'Code';


--
-- Name: COLUMN res_partner.l10n_es_edi_facturae_ac_physical_gln; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.l10n_es_edi_facturae_ac_physical_gln IS 'Physical GLN';


--
-- Name: COLUMN res_partner.l10n_es_edi_facturae_ac_logical_operational_point; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.l10n_es_edi_facturae_ac_logical_operational_point IS 'Logical Operational Point';


--
-- Name: COLUMN res_partner.calendar_last_notif_ack; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.calendar_last_notif_ack IS 'Last notification marked as read from base Calendar';


--
-- Name: COLUMN res_partner.picking_warn; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.picking_warn IS 'Stock Picking';


--
-- Name: COLUMN res_partner.property_stock_customer; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.property_stock_customer IS 'Customer Location';


--
-- Name: COLUMN res_partner.property_stock_supplier; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.property_stock_supplier IS 'Vendor Location';


--
-- Name: COLUMN res_partner.picking_warn_msg; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.picking_warn_msg IS 'Message for Stock Picking';


--
-- Name: COLUMN res_partner.buyer_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.buyer_id IS 'Buyer';


--
-- Name: COLUMN res_partner.purchase_warn; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.purchase_warn IS 'Purchase Order Warning';


--
-- Name: COLUMN res_partner.property_purchase_currency_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.property_purchase_currency_id IS 'Supplier Currency';


--
-- Name: COLUMN res_partner.receipt_reminder_email; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.receipt_reminder_email IS 'Receipt Reminder';


--
-- Name: COLUMN res_partner.reminder_date_before_receipt; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.reminder_date_before_receipt IS 'Days Before Receipt';


--
-- Name: COLUMN res_partner.purchase_warn_msg; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.purchase_warn_msg IS 'Message for Purchase Order';


--
-- Name: COLUMN res_partner.website_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.website_id IS 'Website';


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

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


--
-- Name: CONSTRAINT res_partner_check_name ON res_partner; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT res_partner_check_name ON public.res_partner IS 'CHECK( (type=''contact'' AND name IS NOT NULL) or (type!=''contact'') )';


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

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


ALTER TABLE public.res_partner_autocomplete_sync OWNER TO odoo;

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

COMMENT ON TABLE public.res_partner_autocomplete_sync IS 'Partner Autocomplete Sync';


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

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


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

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


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

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


--
-- Name: COLUMN res_partner_autocomplete_sync.synched; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner_autocomplete_sync.synched IS 'Is synched';


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

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


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

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


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

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


ALTER SEQUENCE public.res_partner_autocomplete_sync_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.res_partner_autocomplete_sync_id_seq OWNED BY public.res_partner_autocomplete_sync.id;


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

CREATE TABLE public.res_partner_bank (
    id integer NOT NULL,
    partner_id integer NOT NULL,
    bank_id integer,
    sequence integer,
    currency_id integer,
    company_id integer,
    create_uid integer,
    write_uid integer,
    acc_number character varying NOT NULL,
    sanitized_acc_number character varying,
    acc_holder_name character varying,
    active boolean,
    allow_out_payment boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    has_iban_warning boolean,
    has_money_transfer_warning boolean
);


ALTER TABLE public.res_partner_bank OWNER TO odoo;

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

COMMENT ON TABLE public.res_partner_bank IS 'Bank Accounts';


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

COMMENT ON COLUMN public.res_partner_bank.partner_id IS 'Account Holder';


--
-- Name: COLUMN res_partner_bank.bank_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner_bank.bank_id IS 'Bank';


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

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


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

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


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

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


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

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


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

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


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

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


--
-- Name: COLUMN res_partner_bank.sanitized_acc_number; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner_bank.sanitized_acc_number IS 'Sanitized Account Number';


--
-- Name: COLUMN res_partner_bank.acc_holder_name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner_bank.acc_holder_name IS 'Account Holder Name';


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

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


--
-- Name: COLUMN res_partner_bank.allow_out_payment; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner_bank.allow_out_payment IS 'Send Money';


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

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


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

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


--
-- Name: COLUMN res_partner_bank.has_iban_warning; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner_bank.has_iban_warning IS 'Has Iban Warning';


--
-- Name: COLUMN res_partner_bank.has_money_transfer_warning; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner_bank.has_money_transfer_warning IS 'Has Money Transfer Warning';


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

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


ALTER SEQUENCE public.res_partner_bank_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.res_partner_bank_id_seq OWNED BY public.res_partner_bank.id;


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

CREATE TABLE public.res_partner_category (
    id integer NOT NULL,
    color integer,
    parent_id integer,
    create_uid integer,
    write_uid integer,
    parent_path character varying,
    name jsonb NOT NULL,
    active boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.res_partner_category OWNER TO odoo;

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

COMMENT ON TABLE public.res_partner_category IS 'Partner Tags';


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

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


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

COMMENT ON COLUMN public.res_partner_category.parent_id IS 'Category';


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

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


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

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


--
-- Name: COLUMN res_partner_category.parent_path; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner_category.parent_path IS 'Parent Path';


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

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


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

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


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

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


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

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


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

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


ALTER SEQUENCE public.res_partner_category_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.res_partner_category_id_seq OWNED BY public.res_partner_category.id;


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

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


ALTER SEQUENCE public.res_partner_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.res_partner_id_seq OWNED BY public.res_partner.id;


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

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


ALTER TABLE public.res_partner_industry OWNER TO odoo;

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

COMMENT ON TABLE public.res_partner_industry IS 'Industry';


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

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


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

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


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

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


--
-- Name: COLUMN res_partner_industry.full_name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner_industry.full_name IS 'Full Name';


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

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


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

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


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

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


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

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


ALTER SEQUENCE public.res_partner_industry_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.res_partner_industry_id_seq OWNED BY public.res_partner_industry.id;


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

CREATE TABLE public.res_partner_res_partner_category_rel (
    category_id integer NOT NULL,
    partner_id integer NOT NULL
);


ALTER TABLE public.res_partner_res_partner_category_rel OWNER TO odoo;

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

COMMENT ON TABLE public.res_partner_res_partner_category_rel IS 'RELATION BETWEEN res_partner_category AND res_partner';


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

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


ALTER TABLE public.res_partner_title OWNER TO odoo;

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

COMMENT ON TABLE public.res_partner_title IS 'Partner Title';


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

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


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

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


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

COMMENT ON COLUMN public.res_partner_title.name IS 'Title';


--
-- Name: COLUMN res_partner_title.shortcut; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner_title.shortcut IS 'Abbreviation';


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

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


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

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


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

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


ALTER SEQUENCE public.res_partner_title_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.res_partner_title_id_seq OWNED BY public.res_partner_title.id;


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

CREATE TABLE public.res_users (
    id integer NOT NULL,
    company_id integer NOT NULL,
    partner_id integer NOT NULL,
    active boolean DEFAULT true,
    create_date timestamp without time zone,
    login character varying NOT NULL,
    password character varying,
    action_id integer,
    create_uid integer,
    write_uid integer,
    signature text,
    share boolean,
    write_date timestamp without time zone,
    totp_secret character varying,
    tour_enabled boolean,
    notification_type character varying NOT NULL,
    odoobot_state character varying,
    odoobot_failed boolean,
    sale_team_id integer,
    karma integer,
    rank_id integer,
    next_rank_id integer,
    property_warehouse_id jsonb,
    website_id integer,
    CONSTRAINT res_users_notification_type CHECK ((((notification_type)::text = 'email'::text) OR (NOT share)))
);


ALTER TABLE public.res_users OWNER TO odoo;

--
-- Name: COLUMN res_users.action_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_users.action_id IS 'Home Action';


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

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


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

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


--
-- Name: COLUMN res_users.signature; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_users.signature IS 'Email Signature';


--
-- Name: COLUMN res_users.share; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_users.share IS 'Share User';


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

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


--
-- Name: COLUMN res_users.tour_enabled; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_users.tour_enabled IS 'Onboarding';


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

COMMENT ON COLUMN public.res_users.notification_type IS 'Notification';


--
-- Name: COLUMN res_users.odoobot_state; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_users.odoobot_state IS 'OdooBot Status';


--
-- Name: COLUMN res_users.odoobot_failed; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_users.odoobot_failed IS 'Odoobot Failed';


--
-- Name: COLUMN res_users.sale_team_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_users.sale_team_id IS 'User Sales Team';


--
-- Name: COLUMN res_users.karma; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_users.karma IS 'Karma';


--
-- Name: COLUMN res_users.rank_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_users.rank_id IS 'Rank';


--
-- Name: COLUMN res_users.next_rank_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_users.next_rank_id IS 'Next Rank';


--
-- Name: COLUMN res_users.property_warehouse_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_users.property_warehouse_id IS 'Default Warehouse';


--
-- Name: COLUMN res_users.website_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_users.website_id IS 'Website';


--
-- Name: CONSTRAINT res_users_notification_type ON res_users; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT res_users_notification_type ON public.res_users IS 'CHECK (notification_type = ''email'' OR NOT share)';


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

CREATE TABLE public.res_users_apikeys (
    id integer NOT NULL,
    name character varying NOT NULL,
    user_id integer NOT NULL,
    scope character varying,
    expiration_date timestamp without time zone,
    index character varying(8),
    key character varying,
    create_date timestamp without time zone DEFAULT (now() AT TIME ZONE 'utc'::text),
    CONSTRAINT res_users_apikeys_index_check CHECK ((char_length((index)::text) = 8))
);


ALTER TABLE public.res_users_apikeys OWNER TO odoo;

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

CREATE TABLE public.res_users_apikeys_description (
    id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    name character varying NOT NULL,
    duration character varying NOT NULL,
    expiration_date timestamp without time zone,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.res_users_apikeys_description OWNER TO odoo;

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

COMMENT ON TABLE public.res_users_apikeys_description IS 'API Key Description';


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

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


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

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


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

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


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

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


--
-- Name: COLUMN res_users_apikeys_description.expiration_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_users_apikeys_description.expiration_date IS 'Expiration Date';


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

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


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

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


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

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


ALTER SEQUENCE public.res_users_apikeys_description_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.res_users_apikeys_description_id_seq OWNED BY public.res_users_apikeys_description.id;


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

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


ALTER SEQUENCE public.res_users_apikeys_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.res_users_apikeys_id_seq OWNED BY public.res_users_apikeys.id;


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

CREATE TABLE public.res_users_deletion (
    id integer NOT NULL,
    user_id integer,
    user_id_int integer,
    create_uid integer,
    write_uid integer,
    state character varying NOT NULL,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.res_users_deletion OWNER TO odoo;

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

COMMENT ON TABLE public.res_users_deletion IS 'Users Deletion Request';


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

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


--
-- Name: COLUMN res_users_deletion.user_id_int; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_users_deletion.user_id_int IS 'User Id';


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

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


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

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


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

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


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

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


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

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


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

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


ALTER SEQUENCE public.res_users_deletion_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.res_users_deletion_id_seq OWNED BY public.res_users_deletion.id;


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

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


ALTER SEQUENCE public.res_users_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.res_users_id_seq OWNED BY public.res_users.id;


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

CREATE TABLE public.res_users_identitycheck (
    id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    request character varying,
    auth_method character varying,
    password character varying,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.res_users_identitycheck OWNER TO odoo;

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

COMMENT ON TABLE public.res_users_identitycheck IS 'Password Check Wizard';


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

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


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

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


--
-- Name: COLUMN res_users_identitycheck.request; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_users_identitycheck.request IS 'Request';


--
-- Name: COLUMN res_users_identitycheck.auth_method; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_users_identitycheck.auth_method IS 'Auth Method';


--
-- Name: COLUMN res_users_identitycheck.password; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_users_identitycheck.password IS 'Password';


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

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


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

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


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

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


ALTER SEQUENCE public.res_users_identitycheck_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.res_users_identitycheck_id_seq OWNED BY public.res_users_identitycheck.id;


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

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

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

COMMENT ON TABLE public.res_users_log IS 'Users Log';


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

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


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

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


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

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


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

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


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

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


ALTER SEQUENCE public.res_users_log_id_seq OWNER TO odoo;

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

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


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

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


ALTER TABLE public.res_users_settings OWNER TO odoo;

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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

COMMENT ON COLUMN public.res_users_settings.channel_notifications IS 'Channel Notifications';


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

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


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

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


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

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


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

COMMENT ON COLUMN public.res_users_settings.mute_until_dt IS 'Mute notifications until';


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

COMMENT ON COLUMN public.res_users_settings.calendar_default_privacy IS 'Calendar Default Privacy';


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

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


ALTER SEQUENCE public.res_users_settings_id_seq OWNER TO odoo;

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

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


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

CREATE TABLE public.res_users_settings_volumes (
    id integer NOT NULL,
    user_setting_id integer NOT NULL,
    partner_id integer,
    guest_id integer,
    create_uid integer,
    write_uid integer,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    volume double precision,
    CONSTRAINT res_users_settings_volumes_partner_or_guest_exists CHECK ((((partner_id IS NOT NULL) AND (guest_id IS NULL)) OR ((partner_id IS NULL) AND (guest_id IS NOT NULL))))
);


ALTER TABLE public.res_users_settings_volumes OWNER TO odoo;

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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


ALTER SEQUENCE public.res_users_settings_volumes_id_seq OWNER TO odoo;

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

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


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

CREATE TABLE public.res_users_web_tour_tour_rel (
    web_tour_tour_id integer NOT NULL,
    res_users_id integer NOT NULL
);


ALTER TABLE public.res_users_web_tour_tour_rel OWNER TO odoo;

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

COMMENT ON TABLE public.res_users_web_tour_tour_rel IS 'RELATION BETWEEN web_tour_tour AND res_users';


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

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


ALTER TABLE public.reset_view_arch_wizard OWNER TO odoo;

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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


ALTER SEQUENCE public.reset_view_arch_wizard_id_seq OWNER TO odoo;

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

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


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

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


ALTER TABLE public.resource_calendar OWNER TO odoo;

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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

COMMENT ON COLUMN public.resource_calendar.flexible_hours IS 'Flexible Hours';


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

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


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

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


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

COMMENT ON COLUMN public.resource_calendar.full_time_required_hours IS 'Company Full Time';


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

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


ALTER TABLE public.resource_calendar_attendance OWNER TO odoo;

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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

COMMENT ON COLUMN public.resource_calendar_attendance.duration_days IS 'Duration (days)';


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

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


ALTER SEQUENCE public.resource_calendar_attendance_id_seq OWNER TO odoo;

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

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


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

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


ALTER SEQUENCE public.resource_calendar_id_seq OWNER TO odoo;

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

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


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

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


ALTER TABLE public.resource_calendar_leaves OWNER TO odoo;

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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


ALTER SEQUENCE public.resource_calendar_leaves_id_seq OWNER TO odoo;

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

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


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

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


ALTER TABLE public.resource_resource OWNER TO odoo;

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

COMMENT ON TABLE public.resource_resource IS 'Resources';


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


ALTER SEQUENCE public.resource_resource_id_seq OWNER TO odoo;

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

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


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

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


ALTER TABLE public.rule_group_rel OWNER TO odoo;

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

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


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

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


ALTER TABLE public.sale_advance_payment_inv OWNER TO odoo;

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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


ALTER SEQUENCE public.sale_advance_payment_inv_id_seq OWNER TO odoo;

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

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


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

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


ALTER TABLE public.sale_advance_payment_inv_sale_order_rel OWNER TO odoo;

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

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


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

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


ALTER TABLE public.sale_mass_cancel_orders OWNER TO odoo;

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

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


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

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


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

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


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

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


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

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


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

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


ALTER SEQUENCE public.sale_mass_cancel_orders_id_seq OWNER TO odoo;

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

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


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

CREATE TABLE public.sale_order (
    id integer NOT NULL,
    campaign_id integer,
    source_id integer,
    medium_id integer,
    company_id integer NOT NULL,
    partner_id integer NOT NULL,
    journal_id integer,
    partner_invoice_id integer NOT NULL,
    partner_shipping_id integer NOT NULL,
    fiscal_position_id integer,
    payment_term_id integer,
    pricelist_id integer,
    currency_id integer,
    user_id integer,
    team_id integer,
    create_uid integer,
    write_uid integer,
    access_token character varying,
    name character varying NOT NULL,
    state character varying,
    client_order_ref character varying,
    origin character varying,
    reference character varying,
    signed_by character varying,
    invoice_status character varying,
    validity_date date,
    note text,
    currency_rate numeric,
    amount_untaxed numeric,
    amount_tax numeric,
    amount_total numeric,
    locked boolean,
    require_signature boolean,
    require_payment boolean,
    create_date timestamp without time zone,
    commitment_date timestamp without time zone,
    date_order timestamp without time zone NOT NULL,
    signed_on timestamp without time zone,
    write_date timestamp without time zone,
    prepayment_percent double precision,
    pending_email_template_id integer,
    sale_order_template_id integer,
    customizable_pdf_form_fields jsonb,
    project_id integer,
    incoterm integer,
    warehouse_id integer,
    procurement_group_id integer,
    incoterm_location character varying,
    picking_policy character varying NOT NULL,
    delivery_status character varying,
    effective_date timestamp without time zone,
    x_ot character varying,
    x_planta character varying,
    x_albaran character varying,
    x_marca character varying,
    x_n_serie character varying,
    x_contacto_nombre character varying,
    x_contacto_email character varying,
    x_estado_importado character varying,
    CONSTRAINT sale_order_date_order_conditional_required CHECK (((((state)::text = 'sale'::text) AND (date_order IS NOT NULL)) OR ((state)::text <> 'sale'::text)))
);


ALTER TABLE public.sale_order OWNER TO odoo;

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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


ALTER TABLE public.sale_order_cancel OWNER TO odoo;

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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


ALTER SEQUENCE public.sale_order_cancel_id_seq OWNER TO odoo;

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

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


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

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


ALTER TABLE public.sale_order_discount OWNER TO odoo;

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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


--
-- Name: sale_order_discount_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.sale_order_discount_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.sale_order_discount_id_seq OWNER TO odoo;

--
-- Name: sale_order_discount_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.sale_order_discount_id_seq OWNED BY public.sale_order_discount.id;


--
-- Name: sale_order_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.sale_order_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.sale_order_id_seq OWNER TO odoo;

--
-- Name: sale_order_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.sale_order_id_seq OWNED BY public.sale_order.id;


--
-- Name: sale_order_line; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.sale_order_line (
    id integer NOT NULL,
    order_id integer NOT NULL,
    sequence integer,
    company_id integer,
    currency_id integer,
    order_partner_id integer,
    salesman_id integer,
    product_id integer,
    product_uom integer,
    linked_line_id integer,
    combo_item_id integer,
    product_packaging_id integer,
    create_uid integer,
    write_uid integer,
    state character varying,
    display_type character varying,
    virtual_id character varying,
    linked_virtual_id character varying,
    qty_delivered_method character varying,
    invoice_status character varying,
    analytic_distribution jsonb,
    name text NOT NULL,
    product_uom_qty numeric NOT NULL,
    price_unit numeric NOT NULL,
    discount numeric,
    price_subtotal numeric,
    price_total numeric,
    price_reduce_taxexcl numeric,
    price_reduce_taxinc numeric,
    qty_delivered numeric,
    qty_invoiced numeric,
    qty_to_invoice numeric,
    untaxed_amount_invoiced numeric,
    untaxed_amount_to_invoice numeric,
    is_downpayment boolean,
    is_expense boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    technical_price_unit double precision,
    price_tax double precision,
    product_packaging_qty double precision,
    customer_lead double precision NOT NULL,
    is_service boolean,
    project_id integer,
    task_id integer,
    route_id integer,
    warehouse_id integer,
    CONSTRAINT sale_order_line_accountable_required_fields CHECK (((display_type IS NOT NULL) OR is_downpayment OR ((product_id IS NOT NULL) AND (product_uom IS NOT NULL)))),
    CONSTRAINT sale_order_line_non_accountable_null_fields CHECK (((display_type IS NULL) OR ((product_id IS NULL) AND (price_unit = (0)::numeric) AND (product_uom_qty = (0)::numeric) AND (product_uom IS NULL) AND (customer_lead = (0)::double precision))))
);


ALTER TABLE public.sale_order_line OWNER TO odoo;

--
-- Name: TABLE sale_order_line; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.sale_order_line IS 'Sales Order Line';


--
-- Name: COLUMN sale_order_line.order_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.order_id IS 'Order Reference';


--
-- Name: COLUMN sale_order_line.sequence; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.sequence IS 'Sequence';


--
-- Name: COLUMN sale_order_line.company_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.company_id IS 'Company';


--
-- Name: COLUMN sale_order_line.currency_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.currency_id IS 'Currency';


--
-- Name: COLUMN sale_order_line.order_partner_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.order_partner_id IS 'Customer';


--
-- Name: COLUMN sale_order_line.salesman_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.salesman_id IS 'Salesperson';


--
-- Name: COLUMN sale_order_line.product_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.product_id IS 'Product';


--
-- Name: COLUMN sale_order_line.product_uom; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.product_uom IS 'Unit of Measure';


--
-- Name: COLUMN sale_order_line.linked_line_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.linked_line_id IS 'Linked Order Line';


--
-- Name: COLUMN sale_order_line.combo_item_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.combo_item_id IS 'Combo Item';


--
-- Name: COLUMN sale_order_line.product_packaging_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.product_packaging_id IS 'Packaging';


--
-- Name: COLUMN sale_order_line.create_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.create_uid IS 'Created by';


--
-- Name: COLUMN sale_order_line.write_uid; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.write_uid IS 'Last Updated by';


--
-- Name: COLUMN sale_order_line.state; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.state IS 'Order Status';


--
-- Name: COLUMN sale_order_line.display_type; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.display_type IS 'Display Type';


--
-- Name: COLUMN sale_order_line.virtual_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.virtual_id IS 'Virtual';


--
-- Name: COLUMN sale_order_line.linked_virtual_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.linked_virtual_id IS 'Linked Virtual';


--
-- Name: COLUMN sale_order_line.qty_delivered_method; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.qty_delivered_method IS 'Method to update delivered qty';


--
-- Name: COLUMN sale_order_line.invoice_status; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.invoice_status IS 'Invoice Status';


--
-- Name: COLUMN sale_order_line.analytic_distribution; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.analytic_distribution IS 'Analytic Distribution';


--
-- Name: COLUMN sale_order_line.name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.name IS 'Description';


--
-- Name: COLUMN sale_order_line.product_uom_qty; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.product_uom_qty IS 'Quantity';


--
-- Name: COLUMN sale_order_line.price_unit; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.price_unit IS 'Unit Price';


--
-- Name: COLUMN sale_order_line.discount; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.discount IS 'Discount (%)';


--
-- Name: COLUMN sale_order_line.price_subtotal; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.price_subtotal IS 'Subtotal';


--
-- Name: COLUMN sale_order_line.price_total; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.price_total IS 'Total';


--
-- Name: COLUMN sale_order_line.price_reduce_taxexcl; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.price_reduce_taxexcl IS 'Price Reduce Tax excl';


--
-- Name: COLUMN sale_order_line.price_reduce_taxinc; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.price_reduce_taxinc IS 'Price Reduce Tax incl';


--
-- Name: COLUMN sale_order_line.qty_delivered; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.qty_delivered IS 'Delivery Quantity';


--
-- Name: COLUMN sale_order_line.qty_invoiced; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.qty_invoiced IS 'Invoiced Quantity';


--
-- Name: COLUMN sale_order_line.qty_to_invoice; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.qty_to_invoice IS 'Quantity To Invoice';


--
-- Name: COLUMN sale_order_line.untaxed_amount_invoiced; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.untaxed_amount_invoiced IS 'Untaxed Invoiced Amount';


--
-- Name: COLUMN sale_order_line.untaxed_amount_to_invoice; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.untaxed_amount_to_invoice IS 'Untaxed Amount To Invoice';


--
-- Name: COLUMN sale_order_line.is_downpayment; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.is_downpayment IS 'Is a down payment';


--
-- Name: COLUMN sale_order_line.is_expense; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.is_expense IS 'Is expense';


--
-- Name: COLUMN sale_order_line.create_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.create_date IS 'Created on';


--
-- Name: COLUMN sale_order_line.write_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.write_date IS 'Last Updated on';


--
-- Name: COLUMN sale_order_line.technical_price_unit; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.technical_price_unit IS 'Technical Price Unit';


--
-- Name: COLUMN sale_order_line.price_tax; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.price_tax IS 'Total Tax';


--
-- Name: COLUMN sale_order_line.product_packaging_qty; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.product_packaging_qty IS 'Packaging Quantity';


--
-- Name: COLUMN sale_order_line.customer_lead; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.customer_lead IS 'Lead Time';


--
-- Name: COLUMN sale_order_line.project_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.project_id IS 'Generated Project';


--
-- Name: COLUMN sale_order_line.task_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.task_id IS 'Generated Task';


--
-- Name: COLUMN sale_order_line.route_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.route_id IS 'Route';


--
-- Name: COLUMN sale_order_line.warehouse_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.sale_order_line.warehouse_id IS 'Warehouse';


--
-- Name: CONSTRAINT sale_order_line_accountable_required_fields ON sale_order_line; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT sale_order_line_accountable_required_fields ON public.sale_order_line IS 'CHECK(display_type IS NOT NULL OR is_downpayment OR (product_id IS NOT NULL AND product_uom IS NOT NULL))';


--
-- Name: CONSTRAINT sale_order_line_non_accountable_null_fields ON sale_order_line; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT sale_order_line_non_accountable_null_fields ON public.sale_order_line IS 'CHECK(display_type IS NULL OR (product_id IS NULL AND price_unit = 0 AND product_uom_qty = 0 AND product_uom IS NULL AND customer_lead = 0))';


--
-- Name: sale_order_line_id_seq; Type: SEQUENCE; Schema: public; Owner: odoo
--

CREATE SEQUENCE public.sale_order_line_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE public.sale_order_line_id_seq OWNER TO odoo;

--
-- Name: sale_order_line_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: odoo
--

ALTER SEQUENCE public.sale_order_line_id_seq OWNED BY public.sale_order_line.id;


--
-- Name: sale_order_line_invoice_rel; Type: TABLE; Schema: public; Owner: odoo
--

CREATE TABLE public.sale_order_line_invoice_rel (
    invoice_line_id integer NOT NULL,
    order_line_id integer NOT NULL
);


ALTER TABLE public.sale_order_line_invoice_rel OWNER TO odoo;

--
-- Name: TABLE sale_order_line_invoice_rel; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON TABLE public.sale_order_line_invoice_rel IS 'RELATION BETWEEN account_move_line AND sale_order_line';


--
