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

COMMENT ON COLUMN public.project_milestone.quantity_percentage IS 'Quantity';


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

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


ALTER TABLE public.project_milestone_id_seq OWNER TO odoo;

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

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


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

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


ALTER TABLE public.project_project OWNER TO odoo;

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

COMMENT ON TABLE public.project_project IS 'Project';


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

COMMENT ON COLUMN public.project_project.partner_email IS 'Email';


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

COMMENT ON COLUMN public.project_project.partner_phone IS 'Phone';


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

COMMENT ON COLUMN public.project_project.allow_subtasks IS 'Sub-tasks';


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

COMMENT ON COLUMN public.project_project.allow_recurring_tasks IS 'Recurring Tasks';


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


ALTER TABLE public.project_project_id_seq OWNER TO odoo;

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

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


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

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


ALTER TABLE public.project_project_project_tags_rel OWNER TO odoo;

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

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


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

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


ALTER TABLE public.project_project_project_task_type_delete_wizard_rel OWNER TO odoo;

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

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


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

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


ALTER TABLE public.project_project_stage OWNER TO odoo;

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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


ALTER TABLE public.project_project_stage_id_seq OWNER TO odoo;

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

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


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

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


ALTER TABLE public.project_share_wizard OWNER TO odoo;

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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

COMMENT ON COLUMN public.project_share_wizard.display_access_mode IS 'Display Access Mode';


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

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


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

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


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

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


ALTER TABLE public.project_share_wizard_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.project_share_wizard_id_seq OWNED BY public.project_share_wizard.id;


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

CREATE TABLE public.project_share_wizard_res_partner_rel (
    project_share_wizard_id integer NOT NULL,
    res_partner_id integer NOT NULL
);


ALTER TABLE public.project_share_wizard_res_partner_rel OWNER TO odoo;

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

COMMENT ON TABLE public.project_share_wizard_res_partner_rel IS 'RELATION BETWEEN project_share_wizard AND res_partner';


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

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


ALTER TABLE public.project_tags OWNER TO odoo;

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

COMMENT ON TABLE public.project_tags IS 'Project Tags';


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

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


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

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


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

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


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

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


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

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


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

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


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

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


ALTER TABLE public.project_tags_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.project_tags_id_seq OWNED BY public.project_tags.id;


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

CREATE TABLE public.project_tags_project_task_rel (
    project_task_id integer NOT NULL,
    project_tags_id integer NOT NULL
);


ALTER TABLE public.project_tags_project_task_rel OWNER TO odoo;

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

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


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

CREATE TABLE public.project_task (
    id integer NOT NULL,
    message_main_attachment_id integer,
    sequence integer,
    stage_id integer,
    project_id integer,
    display_project_id integer,
    partner_id integer,
    company_id integer NOT NULL,
    color integer,
    displayed_image_id integer,
    parent_id integer,
    ancestor_id integer,
    milestone_id integer,
    recurrence_id integer,
    analytic_account_id integer,
    create_uid integer,
    write_uid integer,
    email_cc character varying,
    access_token character varying,
    name character varying NOT NULL,
    priority character varying,
    kanban_state character varying NOT NULL,
    partner_email character varying,
    partner_phone character varying,
    email_from character varying,
    date_deadline date,
    task_properties jsonb,
    description text,
    working_hours_open numeric,
    working_hours_close numeric,
    active boolean,
    is_closed boolean,
    is_blocked boolean,
    recurring_task boolean,
    is_analytic_account_id_changed boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    date_end timestamp without time zone,
    date_assign timestamp without time zone,
    date_last_stage_update timestamp without time zone,
    rating_last_value double precision,
    planned_hours double precision,
    working_days_open double precision,
    working_days_close double precision,
    sale_order_id integer,
    sale_line_id integer
);


ALTER TABLE public.project_task OWNER TO odoo;

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

COMMENT ON TABLE public.project_task IS 'Task';


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

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


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

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


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

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


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

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


--
-- Name: COLUMN project_task.display_project_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task.display_project_id IS 'Display Project';


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

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


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

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


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

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


--
-- Name: COLUMN project_task.displayed_image_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task.displayed_image_id IS 'Cover Image';


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

COMMENT ON COLUMN public.project_task.parent_id IS 'Parent Task';


--
-- Name: COLUMN project_task.ancestor_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task.ancestor_id IS 'Ancestor Task';


--
-- Name: COLUMN project_task.milestone_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task.milestone_id IS 'Milestone';


--
-- Name: COLUMN project_task.recurrence_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task.recurrence_id IS 'Recurrence';


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

COMMENT ON COLUMN public.project_task.kanban_state IS 'Status';


--
-- Name: COLUMN project_task.partner_email; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task.partner_email IS 'Email';


--
-- Name: COLUMN project_task.partner_phone; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task.partner_phone IS 'Phone';


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

COMMENT ON COLUMN public.project_task.email_from IS 'Email From';


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

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


--
-- Name: COLUMN project_task.task_properties; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task.task_properties IS 'Properties';


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

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


--
-- Name: COLUMN project_task.working_hours_open; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task.working_hours_open IS 'Working Hours to Assign';


--
-- Name: COLUMN project_task.working_hours_close; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task.working_hours_close IS 'Working Hours to Close';


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

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


--
-- Name: COLUMN project_task.is_closed; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task.is_closed IS 'Closing Stage';


--
-- Name: COLUMN project_task.is_blocked; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task.is_blocked IS 'Is Blocked';


--
-- Name: COLUMN project_task.recurring_task; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task.recurring_task IS 'Recurrent';


--
-- Name: COLUMN project_task.is_analytic_account_id_changed; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task.is_analytic_account_id_changed IS 'Is Analytic Account Manually Changed';


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

COMMENT ON COLUMN public.project_task.create_date IS 'Created On';


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

COMMENT ON COLUMN public.project_task.write_date IS 'Last Updated On';


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

COMMENT ON COLUMN public.project_task.date_end IS 'Ending Date';


--
-- Name: COLUMN project_task.date_assign; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task.date_assign IS 'Assigning Date';


--
-- Name: COLUMN project_task.date_last_stage_update; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task.date_last_stage_update IS 'Last Stage Update';


--
-- Name: COLUMN project_task.rating_last_value; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task.rating_last_value IS 'Rating Last Value';


--
-- Name: COLUMN project_task.planned_hours; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task.planned_hours IS 'Initially Planned Hours';


--
-- Name: COLUMN project_task.working_days_open; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task.working_days_open IS 'Working Days to Assign';


--
-- Name: COLUMN project_task.working_days_close; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task.working_days_close IS 'Working Days to Close';


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

COMMENT ON COLUMN public.project_task.sale_order_id IS 'Sales Order';


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

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


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

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


ALTER TABLE public.project_task_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.project_task_id_seq OWNED BY public.project_task.id;


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

CREATE TABLE public.project_task_recurrence (
    id integer NOT NULL,
    recurrence_left integer,
    repeat_interval integer,
    repeat_number integer,
    create_uid integer,
    write_uid integer,
    repeat_unit character varying,
    repeat_type character varying,
    repeat_on_month character varying,
    repeat_on_year character varying,
    repeat_day character varying,
    repeat_week character varying,
    repeat_weekday character varying,
    repeat_month character varying,
    next_recurrence_date date,
    repeat_until date,
    mon boolean,
    tue boolean,
    wed boolean,
    thu boolean,
    fri boolean,
    sat boolean,
    sun boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.project_task_recurrence OWNER TO odoo;

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

COMMENT ON TABLE public.project_task_recurrence IS 'Task Recurrence';


--
-- Name: COLUMN project_task_recurrence.recurrence_left; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task_recurrence.recurrence_left IS 'Number of Tasks Left to Create';


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

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


--
-- Name: COLUMN project_task_recurrence.repeat_number; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task_recurrence.repeat_number IS 'Repetitions';


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

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


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

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


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

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


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

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


--
-- Name: COLUMN project_task_recurrence.repeat_on_month; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task_recurrence.repeat_on_month IS 'Repeat On Month';


--
-- Name: COLUMN project_task_recurrence.repeat_on_year; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task_recurrence.repeat_on_year IS 'Repeat On Year';


--
-- Name: COLUMN project_task_recurrence.repeat_day; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task_recurrence.repeat_day IS 'Repeat Day';


--
-- Name: COLUMN project_task_recurrence.repeat_week; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task_recurrence.repeat_week IS 'Repeat Week';


--
-- Name: COLUMN project_task_recurrence.repeat_weekday; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task_recurrence.repeat_weekday IS 'Day Of The Week';


--
-- Name: COLUMN project_task_recurrence.repeat_month; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task_recurrence.repeat_month IS 'Repeat Month';


--
-- Name: COLUMN project_task_recurrence.next_recurrence_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task_recurrence.next_recurrence_date IS 'Next Recurrence Date';


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

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


--
-- Name: COLUMN project_task_recurrence.mon; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task_recurrence.mon IS 'Mon';


--
-- Name: COLUMN project_task_recurrence.tue; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task_recurrence.tue IS 'Tue';


--
-- Name: COLUMN project_task_recurrence.wed; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task_recurrence.wed IS 'Wed';


--
-- Name: COLUMN project_task_recurrence.thu; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task_recurrence.thu IS 'Thu';


--
-- Name: COLUMN project_task_recurrence.fri; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task_recurrence.fri IS 'Fri';


--
-- Name: COLUMN project_task_recurrence.sat; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task_recurrence.sat IS 'Sat';


--
-- Name: COLUMN project_task_recurrence.sun; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task_recurrence.sun IS 'Sun';


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

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


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

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


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

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


ALTER TABLE public.project_task_recurrence_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.project_task_recurrence_id_seq OWNED BY public.project_task_recurrence.id;


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

CREATE TABLE public.project_task_type (
    id integer NOT NULL,
    sequence integer,
    mail_template_id integer,
    rating_template_id integer,
    user_id integer,
    create_uid integer,
    write_uid integer,
    name jsonb NOT NULL,
    description jsonb,
    legend_blocked jsonb NOT NULL,
    legend_done jsonb NOT NULL,
    legend_normal jsonb NOT NULL,
    active boolean,
    fold boolean,
    auto_validation_kanban_state boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    sms_template_id integer
);


ALTER TABLE public.project_task_type OWNER TO odoo;

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

COMMENT ON TABLE public.project_task_type IS 'Task Stage';


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

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


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

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


--
-- Name: COLUMN project_task_type.rating_template_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task_type.rating_template_id IS 'Rating Email Template';


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

COMMENT ON COLUMN public.project_task_type.user_id IS 'Stage Owner';


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

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


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

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


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

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


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

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


--
-- Name: COLUMN project_task_type.legend_blocked; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task_type.legend_blocked IS 'Red Kanban Label';


--
-- Name: COLUMN project_task_type.legend_done; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task_type.legend_done IS 'Green Kanban Label';


--
-- Name: COLUMN project_task_type.legend_normal; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task_type.legend_normal IS 'Grey Kanban Label';


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

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


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

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


--
-- Name: COLUMN project_task_type.auto_validation_kanban_state; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_task_type.auto_validation_kanban_state IS 'Automatic Kanban Status';


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

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


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

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


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

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


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

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


ALTER TABLE public.project_task_type_delete_wizard OWNER TO odoo;

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

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


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

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


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

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


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

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


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

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


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

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


ALTER TABLE public.project_task_type_delete_wizard_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.project_task_type_delete_wizard_id_seq OWNED BY public.project_task_type_delete_wizard.id;


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

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


ALTER TABLE public.project_task_type_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.project_task_type_id_seq OWNED BY public.project_task_type.id;


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

CREATE TABLE public.project_task_type_project_task_type_delete_wizard_rel (
    project_task_type_delete_wizard_id integer NOT NULL,
    project_task_type_id integer NOT NULL
);


ALTER TABLE public.project_task_type_project_task_type_delete_wizard_rel OWNER TO odoo;

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

COMMENT ON TABLE public.project_task_type_project_task_type_delete_wizard_rel IS 'RELATION BETWEEN project_task_type_delete_wizard AND project_task_type';


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

CREATE TABLE public.project_task_type_rel (
    type_id integer NOT NULL,
    project_id integer NOT NULL
);


ALTER TABLE public.project_task_type_rel OWNER TO odoo;

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

COMMENT ON TABLE public.project_task_type_rel IS 'RELATION BETWEEN project_task_type AND project_project';


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

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


ALTER TABLE public.project_task_user_rel OWNER TO odoo;

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

COMMENT ON TABLE public.project_task_user_rel IS 'Personal Task Stage';


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

COMMENT ON COLUMN public.project_task_user_rel.task_id IS 'Task';


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

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


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

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


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

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


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

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


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

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


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

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


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

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


ALTER TABLE public.project_task_user_rel_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.project_task_user_rel_id_seq OWNED BY public.project_task_user_rel.id;


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

CREATE TABLE public.project_update (
    id integer NOT NULL,
    message_main_attachment_id integer,
    progress integer,
    user_id integer NOT NULL,
    project_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    email_cc character varying,
    name character varying NOT NULL,
    status character varying NOT NULL,
    date date,
    description text,
    create_date timestamp without time zone,
    write_date timestamp without time zone
);


ALTER TABLE public.project_update OWNER TO odoo;

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

COMMENT ON TABLE public.project_update IS 'Project Update';


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

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


--
-- Name: COLUMN project_update.progress; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_update.progress IS 'Progress';


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

COMMENT ON COLUMN public.project_update.user_id IS 'Author';


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

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


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

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


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

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


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

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


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

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


--
-- Name: COLUMN project_update.status; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.project_update.status IS 'Status';


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

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


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

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


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

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


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

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


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

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


ALTER TABLE public.project_update_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.project_update_id_seq OWNED BY public.project_update.id;


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

CREATE TABLE public.purchase_order (
    id integer NOT NULL,
    message_main_attachment_id integer,
    partner_id integer NOT NULL,
    dest_address_id integer,
    currency_id integer NOT NULL,
    invoice_count integer,
    fiscal_position_id integer,
    payment_term_id integer,
    incoterm_id integer,
    user_id integer,
    company_id integer NOT NULL,
    create_uid integer,
    write_uid integer,
    access_token character varying,
    name character varying NOT NULL,
    priority character varying,
    origin character varying,
    partner_ref character varying,
    state character varying,
    invoice_status character varying,
    notes text,
    amount_untaxed numeric,
    amount_tax numeric,
    amount_total numeric,
    mail_reminder_confirmed boolean,
    mail_reception_confirmed boolean,
    date_order timestamp without time zone NOT NULL,
    date_approve timestamp without time zone,
    date_planned timestamp without time zone,
    date_calendar_start timestamp without time zone,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    currency_rate double precision,
    picking_type_id integer NOT NULL,
    group_id integer,
    incoterm_location character varying,
    receipt_status character varying,
    effective_date timestamp without time zone
);


ALTER TABLE public.purchase_order OWNER TO odoo;

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

COMMENT ON TABLE public.purchase_order IS 'Purchase Order';


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

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


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

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


--
-- Name: COLUMN purchase_order.dest_address_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.purchase_order.dest_address_id IS 'Dropship Address';


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

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


--
-- Name: COLUMN purchase_order.invoice_count; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.purchase_order.invoice_count IS 'Bill Count';


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

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


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

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


--
-- Name: COLUMN purchase_order.incoterm_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.purchase_order.incoterm_id IS 'Incoterm';


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

COMMENT ON COLUMN public.purchase_order.user_id IS 'Buyer';


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

COMMENT ON COLUMN public.purchase_order.invoice_status IS 'Billing Status';


--
-- Name: COLUMN purchase_order.notes; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.purchase_order.notes IS 'Terms and Conditions';


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

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


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

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


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

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


--
-- Name: COLUMN purchase_order.mail_reminder_confirmed; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.purchase_order.mail_reminder_confirmed IS 'Reminder Confirmed';


--
-- Name: COLUMN purchase_order.mail_reception_confirmed; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.purchase_order.mail_reception_confirmed IS 'Reception Confirmed';


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

COMMENT ON COLUMN public.purchase_order.date_order IS 'Order Deadline';


--
-- Name: COLUMN purchase_order.date_approve; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.purchase_order.date_approve IS 'Confirmation Date';


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

COMMENT ON COLUMN public.purchase_order.date_planned IS 'Expected Arrival';


--
-- Name: COLUMN purchase_order.date_calendar_start; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.purchase_order.date_calendar_start IS 'Date Calendar Start';


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

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


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

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


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

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


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

COMMENT ON COLUMN public.purchase_order.picking_type_id IS 'Deliver To';


--
-- Name: COLUMN purchase_order.group_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.purchase_order.group_id IS 'Procurement Group';


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

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


--
-- Name: COLUMN purchase_order.receipt_status; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.purchase_order.receipt_status IS 'Receipt Status';


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

COMMENT ON COLUMN public.purchase_order.effective_date IS 'Arrival';


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

CREATE VIEW public.purchase_bill_union AS
 SELECT account_move.id,
    account_move.name,
    account_move.ref AS reference,
    account_move.partner_id,
    account_move.date,
    account_move.amount_untaxed AS amount,
    account_move.currency_id,
    account_move.company_id,
    account_move.id AS vendor_bill_id,
    NULL::integer AS purchase_order_id
   FROM public.account_move
  WHERE (((account_move.move_type)::text = 'in_invoice'::text) AND ((account_move.state)::text = 'posted'::text))
UNION
 SELECT (- purchase_order.id) AS id,
    purchase_order.name,
    purchase_order.partner_ref AS reference,
    purchase_order.partner_id,
    (purchase_order.date_order)::date AS date,
    purchase_order.amount_untaxed AS amount,
    purchase_order.currency_id,
    purchase_order.company_id,
    NULL::integer AS vendor_bill_id,
    purchase_order.id AS purchase_order_id
   FROM public.purchase_order
  WHERE (((purchase_order.state)::text = ANY ((ARRAY['purchase'::character varying, 'done'::character varying])::text[])) AND ((purchase_order.invoice_status)::text = ANY ((ARRAY['to invoice'::character varying, 'no'::character varying])::text[])));


ALTER TABLE public.purchase_bill_union OWNER TO odoo;

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

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


ALTER TABLE public.purchase_order_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.purchase_order_id_seq OWNED BY public.purchase_order.id;


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

CREATE TABLE public.purchase_order_line (
    id integer NOT NULL,
    sequence integer,
    product_uom integer,
    product_id integer,
    order_id integer NOT NULL,
    company_id integer,
    partner_id integer,
    currency_id integer,
    product_packaging_id integer,
    create_uid integer,
    write_uid integer,
    state character varying,
    qty_received_method character varying,
    display_type character varying,
    analytic_distribution jsonb,
    name text NOT NULL,
    product_qty numeric NOT NULL,
    price_unit numeric NOT NULL,
    price_subtotal numeric,
    price_total numeric,
    qty_invoiced numeric,
    qty_received numeric,
    qty_received_manual numeric,
    qty_to_invoice numeric,
    date_planned timestamp without time zone,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    product_uom_qty double precision,
    price_tax double precision,
    product_packaging_qty double precision,
    orderpoint_id integer,
    product_description_variants character varying,
    propagate_cancel boolean,
    sale_order_id integer,
    sale_line_id integer,
    CONSTRAINT purchase_order_line_accountable_required_fields CHECK (((display_type IS NOT NULL) OR ((product_id IS NOT NULL) AND (product_uom IS NOT NULL) AND (date_planned IS NOT NULL)))),
    CONSTRAINT purchase_order_line_non_accountable_null_fields CHECK (((display_type IS NULL) OR ((product_id IS NULL) AND (price_unit = (0)::numeric) AND (product_uom_qty = (0)::double precision) AND (product_uom IS NULL) AND (date_planned IS NULL))))
);


ALTER TABLE public.purchase_order_line OWNER TO odoo;

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

COMMENT ON TABLE public.purchase_order_line IS 'Purchase Order Line';


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


--
-- Name: COLUMN purchase_order_line.qty_received_method; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.purchase_order_line.qty_received_method IS 'Received Qty Method';


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

COMMENT ON COLUMN public.purchase_order_line.qty_invoiced IS 'Billed Qty';


--
-- Name: COLUMN purchase_order_line.qty_received; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.purchase_order_line.qty_received IS 'Received Qty';


--
-- Name: COLUMN purchase_order_line.qty_received_manual; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.purchase_order_line.qty_received_manual IS 'Manual Received Qty';


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

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


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

COMMENT ON COLUMN public.purchase_order_line.date_planned IS 'Expected Arrival';


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

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


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

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


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

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


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

COMMENT ON COLUMN public.purchase_order_line.price_tax IS 'Tax';


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

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


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

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


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

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


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

COMMENT ON COLUMN public.purchase_order_line.propagate_cancel IS 'Propagate cancellation';


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

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


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

COMMENT ON COLUMN public.purchase_order_line.sale_line_id IS 'Origin Sale Item';


--
-- Name: CONSTRAINT purchase_order_line_accountable_required_fields ON purchase_order_line; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT purchase_order_line_accountable_required_fields ON public.purchase_order_line IS 'CHECK(display_type IS NOT NULL OR (product_id IS NOT NULL AND product_uom IS NOT NULL AND date_planned IS NOT NULL))';


--
-- Name: CONSTRAINT purchase_order_line_non_accountable_null_fields ON purchase_order_line; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT purchase_order_line_non_accountable_null_fields ON public.purchase_order_line IS 'CHECK(display_type IS NULL OR (product_id IS NULL AND price_unit = 0 AND product_uom_qty = 0 AND product_uom IS NULL AND date_planned is NULL))';


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

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


ALTER TABLE public.purchase_order_line_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.purchase_order_line_id_seq OWNED BY public.purchase_order_line.id;


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

CREATE TABLE public.purchase_order_stock_picking_rel (
    purchase_order_id integer NOT NULL,
    stock_picking_id integer NOT NULL
);


ALTER TABLE public.purchase_order_stock_picking_rel OWNER TO odoo;

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

COMMENT ON TABLE public.purchase_order_stock_picking_rel IS 'RELATION BETWEEN purchase_order AND stock_picking';


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

CREATE TABLE public.rating_rating (
    id integer NOT NULL,
    res_model_id integer,
    res_id integer NOT NULL,
    parent_res_model_id integer,
    parent_res_id integer,
    rated_partner_id integer,
    partner_id integer,
    message_id integer,
    create_uid integer,
    write_uid integer,
    res_name character varying,
    res_model character varying,
    parent_res_name character varying,
    parent_res_model character varying,
    rating_text character varying,
    access_token character varying,
    feedback text,
    is_internal boolean,
    consumed boolean,
    create_date timestamp without time zone,
    write_date timestamp without time zone,
    rating double precision,
    publisher_id integer,
    publisher_comment text,
    publisher_datetime timestamp without time zone,
    CONSTRAINT rating_rating_rating_range CHECK (((rating >= (0)::double precision) AND (rating <= (5)::double precision)))
);


ALTER TABLE public.rating_rating OWNER TO odoo;

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

COMMENT ON TABLE public.rating_rating IS 'Rating';


--
-- Name: COLUMN rating_rating.res_model_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.rating_rating.res_model_id IS 'Related Document Model';


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

COMMENT ON COLUMN public.rating_rating.res_id IS 'Document';


--
-- Name: COLUMN rating_rating.parent_res_model_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.rating_rating.parent_res_model_id IS 'Parent Related Document Model';


--
-- Name: COLUMN rating_rating.parent_res_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.rating_rating.parent_res_id IS 'Parent Document';


--
-- Name: COLUMN rating_rating.rated_partner_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.rating_rating.rated_partner_id IS 'Rated Operator';


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

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


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

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


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

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


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

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


--
-- Name: COLUMN rating_rating.res_name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.rating_rating.res_name IS 'Resource name';


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

COMMENT ON COLUMN public.rating_rating.res_model IS 'Document Model';


--
-- Name: COLUMN rating_rating.parent_res_name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.rating_rating.parent_res_name IS 'Parent Document Name';


--
-- Name: COLUMN rating_rating.parent_res_model; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.rating_rating.parent_res_model IS 'Parent Document Model';


--
-- Name: COLUMN rating_rating.rating_text; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.rating_rating.rating_text IS 'Rating';


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

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


--
-- Name: COLUMN rating_rating.feedback; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.rating_rating.feedback IS 'Comment';


--
-- Name: COLUMN rating_rating.is_internal; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.rating_rating.is_internal IS 'Visible Internally Only';


--
-- Name: COLUMN rating_rating.consumed; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.rating_rating.consumed IS 'Filled Rating';


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

COMMENT ON COLUMN public.rating_rating.create_date IS 'Submitted on';


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

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


--
-- Name: COLUMN rating_rating.rating; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.rating_rating.rating IS 'Rating Value';


--
-- Name: COLUMN rating_rating.publisher_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.rating_rating.publisher_id IS 'Commented by';


--
-- Name: COLUMN rating_rating.publisher_comment; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.rating_rating.publisher_comment IS 'Publisher comment';


--
-- Name: COLUMN rating_rating.publisher_datetime; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.rating_rating.publisher_datetime IS 'Commented on';


--
-- Name: CONSTRAINT rating_rating_rating_range ON rating_rating; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON CONSTRAINT rating_rating_rating_range ON public.rating_rating IS 'check(rating >= 0 and rating <= 5)';


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

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


ALTER TABLE public.rating_rating_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.rating_rating_id_seq OWNED BY public.rating_rating.id;


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

CREATE TABLE public.rel_badge_auth_users (
    gamification_badge_id integer NOT NULL,
    res_users_id integer NOT NULL
);


ALTER TABLE public.rel_badge_auth_users OWNER TO odoo;

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

COMMENT ON TABLE public.rel_badge_auth_users IS 'RELATION BETWEEN gamification_badge AND res_users';


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

CREATE TABLE public.rel_modules_langexport (
    wiz_id integer NOT NULL,
    module_id integer NOT NULL
);


ALTER TABLE public.rel_modules_langexport OWNER TO odoo;

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

COMMENT ON TABLE public.rel_modules_langexport IS 'RELATION BETWEEN base_language_export AND ir_module_module';


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

CREATE TABLE public.rel_server_actions (
    server_id integer NOT NULL,
    action_id integer NOT NULL
);


ALTER TABLE public.rel_server_actions OWNER TO odoo;

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

COMMENT ON TABLE public.rel_server_actions IS 'RELATION BETWEEN ir_act_server AND ir_act_server';


--
-- Name: 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 TABLE 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,
    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.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 TABLE 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 ( SELECT 1) AS nbr,
    t.id,
    t.id AS task_id,
    t.active,
    t.create_date,
    t.date_assign,
    t.date_end,
    t.date_last_stage_update,
    t.date_deadline,
    t.project_id,
    t.priority,
    t.name,
    t.company_id,
    t.partner_id,
    t.parent_id,
    t.ancestor_id,
    t.stage_id,
    t.is_closed,
    t.kanban_state AS state,
    t.milestone_id,
    pm.is_reached AS milestone_reached,
    pm.deadline AS milestone_deadline,
    NULLIF(t.rating_last_value, (0)::double precision) AS rating_last_value,
    avg(rt.rating) AS rating_avg,
    t.working_days_close,
    t.working_days_open,
    t.working_hours_open,
    t.working_hours_close,
    (EXTRACT(epoch FROM ((t.date_deadline)::timestamp without time zone - (now() AT TIME ZONE 'UTC'::text))) / ((3600 * 24))::numeric) AS delay_endings_days,
    t.sale_line_id,
    t.sale_order_id
   FROM ((public.project_task t
     LEFT JOIN public.rating_rating rt ON (((rt.res_id = t.id) AND ((rt.res_model)::text = 'project.task'::text) AND (rt.consumed = true) AND (rt.rating >= (1)::double precision))))
     LEFT JOIN public.project_milestone pm ON ((pm.id = t.milestone_id)))
  WHERE (t.project_id IS NOT NULL)
  GROUP BY t.id, t.active, t.create_date, t.date_assign, t.date_end, t.date_last_stage_update, t.date_deadline, t.project_id, t.ancestor_id, t.priority, t.name, t.company_id, t.partner_id, t.parent_id, t.stage_id, t.is_closed, t.kanban_state, t.rating_last_value, t.working_days_close, t.working_days_open, t.working_hours_open, t.working_hours_close, t.milestone_id, pm.is_reached, pm.deadline, t.sale_line_id, t.sale_order_id;


ALTER TABLE 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,
    return_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 (Days)';


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


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

COMMENT ON COLUMN public.stock_location.return_location IS 'Is a Return 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,
    partner_id integer,
    picking_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_done numeric,
    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,
    analytic_account_line_id integer,
    to_refund boolean,
    sale_line_id integer,
    purchase_line_id integer,
    created_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 'Destination 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.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';


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


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

COMMENT ON COLUMN public.stock_move.quantity_done IS 'Quantity Done';


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

COMMENT ON COLUMN public.stock_move.analytic_account_line_id IS 'Analytic Account Line';


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

COMMENT ON COLUMN public.stock_move.purchase_line_id IS 'Purchase Order Line';


--
-- Name: COLUMN stock_move.created_purchase_line_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_move.created_purchase_line_id IS 'Created 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,
    return_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,
    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.return_type_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.stock_warehouse.return_type_id IS 'Return 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.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, date, state, company_id, whs_id, whd_id) AS (
         SELECT m.id,
            m.product_id,
            pt.id,
            m.product_qty,
            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 = m.location_dest_id)))
             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.type)::text = 'product'::text) 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, 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",
            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(forecast_qty.id) AS id,
    forecast_qty.product_id,
    forecast_qty.product_tmpl_id,
    forecast_qty.state,
    forecast_qty.date,
    sum(forecast_qty.product_qty) AS product_qty,
    forecast_qty.company_id,
    forecast_qty.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.product_qty
                    WHEN ((m.whd_id IS NOT NULL) AND (m.whs_id IS NULL) AND ((m.state)::text = 'done'::text)) THEN (- m.product_qty)
                    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 forecast_qty.product_id, forecast_qty.product_tmpl_id, forecast_qty.state, forecast_qty.date, forecast_qty.company_id, forecast_qty.warehouse_id;


ALTER TABLE 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 TABLE 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_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,
    base_onboarding_company_state character varying,
    font character varying,
    primary_color character varying,
    secondary_color character varying,
    layout_background character varying NOT NULL,
    report_footer jsonb,
    report_header text,
    company_details text,
    active boolean,
    write_date timestamp without time zone,
    logo_web bytea,
    resource_calendar_id integer,
    partner_gid integer,
    iap_enrich_auto_done boolean,
    snailmail_color boolean,
    snailmail_cover boolean,
    snailmail_duplex boolean,
    payment_provider_onboarding_state character varying,
    payment_onboarding_payment_method character varying,
    message_main_attachment_id integer,
    fiscalyear_last_day integer NOT NULL,
    transfer_account_id integer,
    chart_template_id integer,
    default_cash_difference_income_account_id integer,
    default_cash_difference_expense_account_id integer,
    account_journal_suspense_account_id integer,
    account_journal_payment_debit_account_id integer,
    account_journal_payment_credit_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,
    property_stock_account_input_categ_id integer,
    property_stock_account_output_categ_id integer,
    property_stock_valuation_account_id integer,
    incoterm_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,
    fiscalyear_last_month character varying NOT NULL,
    bank_account_code_prefix character varying,
    cash_account_code_prefix character varying,
    early_pay_discount_computation character varying,
    transfer_account_code_prefix character varying,
    tax_calculation_rounding_method character varying,
    account_setup_bank_data_state character varying,
    account_setup_fy_data_state character varying,
    account_setup_coa_state character varying,
    account_setup_taxes_state character varying,
    account_onboarding_invoice_layout_state character varying,
    account_onboarding_sale_tax_state character varying,
    account_invoice_onboarding_state character varying,
    account_dashboard_onboarding_state character varying,
    terms_type character varying,
    account_setup_bill_state character varying,
    quick_edit_mode character varying,
    period_lock_date date,
    fiscalyear_lock_date date,
    tax_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,
    invoice_is_email boolean,
    invoice_is_print boolean,
    account_use_credit_limit boolean,
    account_onboarding_create_invoice_state_flag boolean,
    tax_exigibility boolean,
    account_storno boolean,
    invoice_is_snailmail boolean,
    quotation_validity_days integer,
    sale_quotation_onboarding_state character varying,
    sale_onboarding_order_confirmation_state character varying,
    sale_onboarding_sample_quotation_state character varying,
    sale_onboarding_payment_method character varying,
    portal_confirmation_sign boolean,
    portal_confirmation_pay boolean,
    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,
    hr_presence_control_email_amount integer,
    hr_presence_control_ip_list character varying,
    vat_check_vies boolean,
    website_id integer,
    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,
    stock_sms_confirmation_template_id integer,
    stock_move_sms_validation boolean,
    has_received_warning_stock_sms boolean,
    security_lead double precision NOT NULL,
    po_lock character varying,
    po_double_validation character varying,
    po_double_validation_amount numeric,
    po_lead double precision NOT NULL,
    days_to_purchase double precision,
    expense_journal_id integer,
    company_expense_journal_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.base_onboarding_company_state; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.base_onboarding_company_state IS 'State of the onboarding company step';


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

COMMENT ON COLUMN public.res_company.report_footer IS 'Report Footer';


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

COMMENT ON COLUMN public.res_company.payment_provider_onboarding_state IS 'State of the onboarding payment provider step';


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

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


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

COMMENT ON COLUMN public.res_company.chart_template_id IS 'Chart Template';


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


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


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

COMMENT ON COLUMN public.res_company.account_journal_payment_debit_account_id IS 'Journal Outstanding Receipts Account';


--
-- Name: COLUMN res_company.account_journal_payment_credit_account_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.account_journal_payment_credit_account_id IS 'Journal Outstanding Payments 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.property_stock_account_input_categ_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.property_stock_account_input_categ_id IS 'Input Account for Stock Valuation';


--
-- Name: COLUMN res_company.property_stock_account_output_categ_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.property_stock_account_output_categ_id IS 'Output Account for Stock Valuation';


--
-- Name: COLUMN res_company.property_stock_valuation_account_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.property_stock_valuation_account_id IS 'Account Template for Stock Valuation';


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

COMMENT ON COLUMN public.res_company.early_pay_discount_computation IS 'Cash Discount Tax Reduction';


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

COMMENT ON COLUMN public.res_company.account_setup_bank_data_state IS 'State of the onboarding bank data step';


--
-- Name: COLUMN res_company.account_setup_fy_data_state; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.account_setup_fy_data_state IS 'State of the onboarding fiscal year step';


--
-- Name: COLUMN res_company.account_setup_coa_state; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.account_setup_coa_state IS 'State of the onboarding charts of account step';


--
-- Name: COLUMN res_company.account_setup_taxes_state; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.account_setup_taxes_state IS 'State of the onboarding Taxes step';


--
-- Name: COLUMN res_company.account_onboarding_invoice_layout_state; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.account_onboarding_invoice_layout_state IS 'State of the onboarding invoice layout step';


--
-- Name: COLUMN res_company.account_onboarding_sale_tax_state; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.account_onboarding_sale_tax_state IS 'State of the onboarding sale tax step';


--
-- Name: COLUMN res_company.account_invoice_onboarding_state; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.account_invoice_onboarding_state IS 'State of the account invoice onboarding panel';


--
-- Name: COLUMN res_company.account_dashboard_onboarding_state; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.account_dashboard_onboarding_state IS 'State of the account dashboard onboarding panel';


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

COMMENT ON COLUMN public.res_company.account_setup_bill_state IS 'State of the onboarding bill step';


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

COMMENT ON COLUMN public.res_company.period_lock_date IS 'Journals Entries Lock Date';


--
-- Name: COLUMN res_company.fiscalyear_lock_date; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.fiscalyear_lock_date IS 'All Users 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.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.invoice_is_email; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.invoice_is_email IS 'Email by default';


--
-- Name: COLUMN res_company.invoice_is_print; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.invoice_is_print IS 'Print by default';


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

COMMENT ON COLUMN public.res_company.account_onboarding_create_invoice_state_flag IS 'Account Onboarding Create Invoice State Flag';


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

COMMENT ON COLUMN public.res_company.invoice_is_snailmail IS 'Send by Post';


--
-- 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 (Days)';


--
-- Name: COLUMN res_company.sale_quotation_onboarding_state; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.sale_quotation_onboarding_state IS 'State of the sale onboarding panel';


--
-- Name: COLUMN res_company.sale_onboarding_order_confirmation_state; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.sale_onboarding_order_confirmation_state IS 'State of the onboarding confirmation order step';


--
-- Name: COLUMN res_company.sale_onboarding_sample_quotation_state; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.sale_onboarding_sample_quotation_state IS 'State of the onboarding sample quotation step';


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

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


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

COMMENT ON COLUMN public.res_company.expense_journal_id IS 'Default Expense Journal';


--
-- Name: COLUMN res_company.company_expense_journal_id; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_company.company_expense_journal_id IS 'Default Company Expense Journal';


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

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

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

COMMENT ON TABLE public.res_config_installer IS 'Config Installer';


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

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


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

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


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

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


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

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


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

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


ALTER TABLE public.res_config_installer_id_seq OWNER TO odoo;

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

ALTER SEQUENCE public.res_config_installer_id_seq OWNED BY public.res_config_installer.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,
    company_id integer NOT NULL,
    user_default_rights boolean,
    external_email_server_default 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_base_gengo boolean,
    module_account_inter_company_rules boolean,
    module_voip boolean,
    module_web_unsplash boolean,
    module_partner_autocomplete boolean,
    module_base_geolocalize boolean,
    module_google_recaptcha boolean,
    group_multi_currency boolean,
    show_effect boolean,
    module_product_images boolean,
    profiling_enabled_until timestamp without time zone,
    alias_domain character varying,
    twilio_account_sid character varying,
    twilio_account_token character varying,
    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_pricelist_setting character varying,
    product_weight_in_lbs character varying,
    product_volume_volume_in_cubic_feet character varying,
    group_discount_per_so_line boolean,
    group_uom boolean,
    group_product_variant boolean,
    module_sale_product_matrix boolean,
    module_loyalty boolean,
    group_stock_packaging boolean,
    group_product_pricelist boolean,
    group_sale_pricelist boolean,
    unsplash_access_key character varying,
    unsplash_app_id character varying,
    digest_id integer,
    digest_emails boolean,
    chart_template_id integer,
    show_line_subtotals_tax_selection character varying NOT NULL,
    module_account_accountant boolean,
    group_warning_account boolean,
    group_cash_rounding boolean,
    group_show_line_subtotals_tax_excluded boolean,
    group_show_line_subtotals_tax_included 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_sepa 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_taxcloud boolean,
    module_account_invoice_extract boolean,
    module_snailmail_account boolean,
    use_invoice_terms boolean,
    group_sale_delivery_address boolean,
    pay_invoices_online boolean,
    deposit_default_product_id integer,
    invoice_mail_template_id integer,
    default_invoice_policy character varying,
    group_auto_done_setting boolean,
    group_proforma_sales boolean,
    group_warning_sale boolean,
    automatic_invoice boolean,
    use_quotation_validity_days boolean,
    module_delivery boolean,
    module_delivery_bpost boolean,
    module_delivery_dhl boolean,
    module_delivery_easypost boolean,
    module_delivery_sendcloud boolean,
    module_delivery_fedex boolean,
    module_delivery_ups boolean,
    module_delivery_usps boolean,
    module_product_email_template boolean,
    module_sale_amazon boolean,
    module_sale_loyalty boolean,
    module_sale_margin boolean,
    group_sale_order_template boolean,
    module_sale_quotation_builder boolean,
    module_hr_presence boolean,
    module_hr_skills boolean,
    module_hr_homeworking boolean,
    hr_presence_control_login boolean,
    hr_presence_control_email boolean,
    hr_presence_control_ip boolean,
    module_hr_attendance boolean,
    hr_employee_self_edit boolean,
    mass_mailing_mail_server_id integer,
    group_mass_mailing_campaign boolean,
    mass_mailing_outgoing_mail_server boolean,
    show_blacklist_buttons boolean,
    mass_mailing_reports boolean,
    module_project_forecast boolean,
    module_hr_timesheet boolean,
    group_subtask_project boolean,
    group_project_rating boolean,
    group_project_stages boolean,
    group_project_recurring_tasks boolean,
    group_project_task_dependencies boolean,
    group_project_milestone boolean,
    crm_auto_assignment_interval_number integer,
    crm_auto_assignment_action character varying,
    crm_auto_assignment_interval_type character varying,
    lead_enrich_auto character varying,
    predictive_lead_scoring_start_date_str character varying,
    predictive_lead_scoring_fields_str character varying,
    group_use_lead boolean,
    group_use_recurring_revenues boolean,
    is_membership_multi boolean,
    crm_use_auto_assignment boolean,
    module_crm_iap_mine boolean,
    module_crm_iap_enrich boolean,
    module_website_crm_iap_reveal boolean,
    lead_mining_in_pipeline boolean,
    crm_auto_assignment_run_datetime timestamp without time zone,
    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,
    module_payment_paypal boolean,
    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,
    group_stock_picking_wave boolean,
    module_stock_barcode boolean,
    module_stock_sms boolean,
    module_quality_control boolean,
    module_quality_control_worksheet boolean,
    group_stock_multi_locations boolean,
    group_stock_storage_categories boolean,
    group_stock_reception_report boolean,
    module_stock_landed_costs boolean,
    group_lot_on_invoice boolean,
    default_picking_policy character varying NOT NULL,
    group_display_incoterm boolean,
    use_security_lead 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,
    module_stock_dropshipping boolean,
    is_installed_sale boolean,
    expense_alias_prefix character varying,
    use_mailgateway boolean,
    module_hr_payroll_expense boolean,
    module_hr_expense_extract 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.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.external_email_server_default; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.external_email_server_default IS 'Custom Email Servers';


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

COMMENT ON COLUMN public.res_config_settings.module_base_gengo IS 'Translate Your Website with Gengo';


--
-- 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 'Asterisk (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_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.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.alias_domain; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.alias_domain IS 'Alias Domain';


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

COMMENT ON COLUMN public.res_config_settings.product_pricelist_setting IS 'Pricelists Method';


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

COMMENT ON COLUMN public.res_config_settings.group_sale_pricelist IS 'Advanced Pricelists';


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

COMMENT ON COLUMN public.res_config_settings.chart_template_id IS 'Template';


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

COMMENT ON COLUMN public.res_config_settings.show_line_subtotals_tax_selection IS 'Line Subtotals Tax Display';


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

COMMENT ON COLUMN public.res_config_settings.group_show_line_subtotals_tax_excluded IS 'Show line subtotals without taxes (B2B)';


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

COMMENT ON COLUMN public.res_config_settings.group_show_line_subtotals_tax_included IS 'Show line subtotals with taxes (B2C)';


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

COMMENT ON COLUMN public.res_config_settings.module_account_sepa IS 'SEPA Credit Transfer (SCT)';


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

COMMENT ON COLUMN public.res_config_settings.module_account_taxcloud IS 'Account TaxCloud';


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

COMMENT ON COLUMN public.res_config_settings.deposit_default_product_id IS 'Deposit Product';


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

COMMENT ON COLUMN public.res_config_settings.use_quotation_validity_days IS 'Default Quotation Validity';


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

COMMENT ON COLUMN public.res_config_settings.module_sale_quotation_builder IS 'Quotation Builder';


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


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

COMMENT ON COLUMN public.res_config_settings.hr_presence_control_login IS 'Based on user status in system';


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

COMMENT ON COLUMN public.res_config_settings.hr_presence_control_email IS 'Based on number of emails sent';


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

COMMENT ON COLUMN public.res_config_settings.hr_presence_control_ip IS 'Based on IP Address';


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

COMMENT ON COLUMN public.res_config_settings.module_hr_attendance IS 'Based on attendances';


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

COMMENT ON COLUMN public.res_config_settings.mass_mailing_mail_server_id IS 'Mail Server';


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

COMMENT ON COLUMN public.res_config_settings.group_mass_mailing_campaign IS 'Mailing Campaigns';


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

COMMENT ON COLUMN public.res_config_settings.mass_mailing_outgoing_mail_server IS 'Dedicated Server';


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

COMMENT ON COLUMN public.res_config_settings.show_blacklist_buttons IS 'Blacklist Option when Unsubscribing';


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

COMMENT ON COLUMN public.res_config_settings.mass_mailing_reports IS '24H Stat Mailing Reports';


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

COMMENT ON COLUMN public.res_config_settings.module_project_forecast IS 'Planning';


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

COMMENT ON COLUMN public.res_config_settings.group_subtask_project IS 'Sub-tasks';


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

COMMENT ON COLUMN public.res_config_settings.crm_auto_assignment_interval_number IS 'Repeat every';


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

COMMENT ON COLUMN public.res_config_settings.crm_auto_assignment_action IS 'Auto Assignment Action';


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

COMMENT ON COLUMN public.res_config_settings.crm_auto_assignment_interval_type IS 'Auto Assignment Interval Unit';


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

COMMENT ON COLUMN public.res_config_settings.lead_enrich_auto IS 'Enrich lead automatically';


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

COMMENT ON COLUMN public.res_config_settings.predictive_lead_scoring_start_date_str IS 'Lead Scoring Starting Date in String';


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

COMMENT ON COLUMN public.res_config_settings.predictive_lead_scoring_fields_str IS 'Lead Scoring Frequency Fields in String';


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

COMMENT ON COLUMN public.res_config_settings.group_use_lead IS 'Leads';


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

COMMENT ON COLUMN public.res_config_settings.group_use_recurring_revenues IS 'Recurring Revenues';


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

COMMENT ON COLUMN public.res_config_settings.is_membership_multi IS 'Multi Teams';


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

COMMENT ON COLUMN public.res_config_settings.crm_use_auto_assignment IS 'Rule-Based Assignment';


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

COMMENT ON COLUMN public.res_config_settings.module_crm_iap_mine IS 'Generate new leads based on their country, industries, size, etc.';


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

COMMENT ON COLUMN public.res_config_settings.module_crm_iap_enrich IS 'Enrich your leads automatically with company data based on their email address.';


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

COMMENT ON COLUMN public.res_config_settings.module_website_crm_iap_reveal IS 'Create Leads/Opportunities from your website''s traffic';


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

COMMENT ON COLUMN public.res_config_settings.lead_mining_in_pipeline IS 'Create a lead mining request directly from the opportunity pipeline.';


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

COMMENT ON COLUMN public.res_config_settings.crm_auto_assignment_run_datetime IS 'Auto Assignment Next Execution Date';


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

COMMENT ON COLUMN public.res_config_settings.module_payment_paypal IS 'Paypal - Express Checkout';


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


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

COMMENT ON COLUMN public.res_config_settings.group_stock_picking_wave IS 'Wave 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_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_storage_categories; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_config_settings.group_stock_storage_categories IS 'Storage Categories';


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

COMMENT ON COLUMN public.res_config_settings.group_display_incoterm IS 'Incoterms';


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

COMMENT ON COLUMN public.res_config_settings.expense_alias_prefix IS 'Default Alias Name for Expenses';


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

COMMENT ON COLUMN public.res_config_settings.use_mailgateway IS 'Let your employees record expenses by email';


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

COMMENT ON COLUMN public.res_config_settings.module_hr_payroll_expense IS 'Reimburse Expenses in Payslip';


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

COMMENT ON COLUMN public.res_config_settings.module_hr_expense_extract IS 'Send bills to OCR to generate expenses';


--
-- 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 TABLE 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),
    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 TABLE 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 TABLE 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 TABLE 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,
    decimal_places integer,
    create_uid integer,
    write_uid integer,
    full_name character varying,
    "position" character varying,
    currency_unit_label character varying,
    currency_subunit_label character varying,
    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.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 TABLE 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 TABLE 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_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
);


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: 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 TABLE 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_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,
    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.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 TABLE 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,
    display_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,
    date date,
    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_main_attachment_id integer,
    message_bounce integer,
    email_normalized character varying,
    signup_type character varying,
    signup_expiration timestamp without time zone,
    signup_token character varying,
    team_id integer,
    partner_gid integer,
    additional_info character varying,
    phone_sanitized character varying,
    supplier_rank integer,
    customer_rank integer,
    invoice_warn character varying,
    invoice_warn_msg text,
    debit_limit numeric,
    last_time_entries_checked timestamp without time zone,
    sale_warn character varying,
    sale_warn_msg text,
    calendar_last_notif_ack timestamp without time zone,
    website_id integer,
    is_published boolean,
    picking_warn character varying,
    picking_warn_msg text,
    purchase_warn character varying,
    purchase_warn_msg text,
    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.display_name; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_partner.display_name IS 'Display 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.date; Type: COMMENT; Schema: public; Owner: odoo
--

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


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

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


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

COMMENT ON COLUMN public.res_partner.signup_expiration IS 'Signup Expiration';


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

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


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

COMMENT ON COLUMN public.res_partner.last_time_entries_checked IS 'Latest Invoices & Payments Matching Date';


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

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


--
-- 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: 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 TABLE 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,
    message_main_attachment_id integer
);


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

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


--
-- 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 TABLE 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 'Parent 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 'Tag 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 TABLE 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 TABLE 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 TABLE 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 TABLE 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,
    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,
    target_sales_won integer,
    target_sales_done integer,
    target_sales_invoiced integer,
    website_id integer,
    livechat_username character varying,
    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.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.target_sales_won; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_users.target_sales_won IS 'Won in Opportunities Target';


--
-- Name: COLUMN res_users.target_sales_done; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_users.target_sales_done IS 'Activities Done Target';


--
-- Name: COLUMN res_users.target_sales_invoiced; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_users.target_sales_invoiced IS 'Invoiced in Sales Orders Target';


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

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


--
-- Name: COLUMN res_users.livechat_username; Type: COMMENT; Schema: public; Owner: odoo
--

COMMENT ON COLUMN public.res_users.livechat_username IS 'Livechat Username';


--
-- 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,
    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,
    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.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 TABLE 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 TABLE 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 TABLE 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 TABLE 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,
    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.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 TABLE 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';


--
