--
--


-- Started on 2024-06-02 14:02:11

SELECT pg_catalog.set_config('search_path', '', false);

--
-- TOC entry 5 (class 2615 OID 2200)
-- Name: public; Type: SCHEMA; Schema: -; Owner: postgres
--

CREATE SCHEMA public;


ALTER SCHEMA public OWNER TO postgres;

--
-- TOC entry 4654 (class 0 OID 0)
-- Dependencies: 5
-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
--

COMMENT ON SCHEMA public IS 'standard public schema';




--
-- TOC entry 234 (class 1259 OID 18644)
-- Name: alembic_version; Type: TABLE; Schema: public; Owner: developer
--

CREATE TABLE public.alembic_version (
    version_num character varying(32) NOT NULL
);


ALTER TABLE public.alembic_version OWNER TO developer;

--
-- TOC entry 236 (class 1259 OID 18651)
-- Name: clients; Type: TABLE; Schema: public; Owner: developer
--

CREATE TABLE public.clients (
    id integer NOT NULL,
    name character varying(150) NOT NULL,
    phone_number character varying(150),
    address_billing character varying(200) NOT NULL,
    city_billing character varying(100) NOT NULL,
    state_billing character varying(100) NOT NULL,
    zipcode_billing character varying(50) NOT NULL,
    email character varying(150),
    password character varying(200),
    user_level integer,
    note text
);


ALTER TABLE public.clients OWNER TO developer;

--
-- TOC entry 235 (class 1259 OID 18649)
-- Name: clients_id_seq; Type: SEQUENCE; Schema: public; Owner: developer
--

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


ALTER SEQUENCE public.clients_id_seq OWNER TO developer;

--
-- TOC entry 4656 (class 0 OID 0)
-- Dependencies: 235
-- Name: clients_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: developer
--

ALTER SEQUENCE public.clients_id_seq OWNED BY public.clients.id;


--
-- TOC entry 250 (class 1259 OID 18878)
-- Name: contacts; Type: TABLE; Schema: public; Owner: developer
--

CREATE TABLE public.contacts (
    id integer NOT NULL,
    client_name character varying(150),
    client_email character varying(150),
    client_phone character varying(150),
    subject character varying(150),
    message text
);


ALTER TABLE public.contacts OWNER TO developer;

--
-- TOC entry 249 (class 1259 OID 18876)
-- Name: contacts_id_seq; Type: SEQUENCE; Schema: public; Owner: developer
--

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


ALTER SEQUENCE public.contacts_id_seq OWNER TO developer;

--
-- TOC entry 4657 (class 0 OID 0)
-- Dependencies: 249
-- Name: contacts_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: developer
--

ALTER SEQUENCE public.contacts_id_seq OWNED BY public.contacts.id;


--
-- TOC entry 268 (class 1259 OID 19893)
-- Name: email_log_status; Type: TABLE; Schema: public; Owner: developer
--

CREATE TABLE public.email_log_status (
    id integer NOT NULL,
    message_id text NOT NULL,
    date timestamp without time zone NOT NULL,
    event text NOT NULL
);


ALTER TABLE public.email_log_status OWNER TO developer;

--
-- TOC entry 267 (class 1259 OID 19892)
-- Name: email_log_status_id_seq; Type: SEQUENCE; Schema: public; Owner: developer
--

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


ALTER SEQUENCE public.email_log_status_id_seq OWNER TO developer;

--
-- TOC entry 4658 (class 0 OID 0)
-- Dependencies: 267
-- Name: email_log_status_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: developer
--

ALTER SEQUENCE public.email_log_status_id_seq OWNED BY public.email_log_status.id;


--
-- TOC entry 264 (class 1259 OID 19212)
-- Name: estimate_logs; Type: TABLE; Schema: public; Owner: developer
--

CREATE TABLE public.estimate_logs (
    id integer NOT NULL,
    action integer NOT NULL,
    date date NOT NULL,
    estimate_id integer,
    message_id text
);


ALTER TABLE public.estimate_logs OWNER TO developer;

--
-- TOC entry 263 (class 1259 OID 19210)
-- Name: estimate_logs_id_seq; Type: SEQUENCE; Schema: public; Owner: developer
--

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


ALTER SEQUENCE public.estimate_logs_id_seq OWNER TO developer;

--
-- TOC entry 4659 (class 0 OID 0)
-- Dependencies: 263
-- Name: estimate_logs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: developer
--

ALTER SEQUENCE public.estimate_logs_id_seq OWNED BY public.estimate_logs.id;


--
-- TOC entry 238 (class 1259 OID 18685)
-- Name: estimates; Type: TABLE; Schema: public; Owner: developer
--

CREATE TABLE public.estimates (
    id integer NOT NULL,
    date date NOT NULL,
    note text,
    client_id integer,
    address_shipping character varying(200) NOT NULL,
    city_shipping character varying(100) NOT NULL,
    state_shipping character varying(100) NOT NULL,
    zipcode_shipping character varying(50) NOT NULL,
    name character varying(150) NOT NULL,
    authorization_date date,
    accepted_home_improvement_date date,
    due_date date,
    hash character varying(150),
    charge_tax boolean
);


ALTER TABLE public.estimates OWNER TO developer;

--
-- TOC entry 237 (class 1259 OID 18683)
-- Name: estimates_id_seq; Type: SEQUENCE; Schema: public; Owner: developer
--

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


ALTER SEQUENCE public.estimates_id_seq OWNER TO developer;

--
-- TOC entry 4660 (class 0 OID 0)
-- Dependencies: 237
-- Name: estimates_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: developer
--

ALTER SEQUENCE public.estimates_id_seq OWNED BY public.estimates.id;


--
-- TOC entry 240 (class 1259 OID 18701)
-- Name: estimates_items; Type: TABLE; Schema: public; Owner: developer
--

CREATE TABLE public.estimates_items (
    id integer NOT NULL,
    name text,
    qtd integer NOT NULL,
    unique_amount numeric(25,15) NOT NULL,
    estimate_id integer,
    description text,
    hidden boolean,
    ordem integer NOT NULL,
    material boolean
);


ALTER TABLE public.estimates_items OWNER TO developer;

--
-- TOC entry 239 (class 1259 OID 18699)
-- Name: estimates_items_id_seq; Type: SEQUENCE; Schema: public; Owner: developer
--

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


ALTER SEQUENCE public.estimates_items_id_seq OWNER TO developer;

--
-- TOC entry 4661 (class 0 OID 0)
-- Dependencies: 239
-- Name: estimates_items_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: developer
--

ALTER SEQUENCE public.estimates_items_id_seq OWNED BY public.estimates_items.id;


--
-- TOC entry 225 (class 1259 OID 18552)
-- Name: expenses; Type: TABLE; Schema: public; Owner: developer
--

CREATE TABLE public.expenses (
    id integer NOT NULL,
    jobs_id integer,
    subcontractors_id integer,
    date date NOT NULL,
    store character varying(100) NOT NULL,
    amount numeric(10,2) NOT NULL
);


ALTER TABLE public.expenses OWNER TO developer;

--
-- TOC entry 224 (class 1259 OID 18550)
-- Name: expenses_id_seq; Type: SEQUENCE; Schema: public; Owner: developer
--

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


ALTER SEQUENCE public.expenses_id_seq OWNER TO developer;

--
-- TOC entry 4662 (class 0 OID 0)
-- Dependencies: 224
-- Name: expenses_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: developer
--

ALTER SEQUENCE public.expenses_id_seq OWNED BY public.expenses.id;


--
-- TOC entry 227 (class 1259 OID 18570)
-- Name: external_payments; Type: TABLE; Schema: public; Owner: developer
--

CREATE TABLE public.external_payments (
    id integer NOT NULL,
    external_subcontractor_id integer,
    date date NOT NULL,
    builder_name character varying(50) NOT NULL,
    amount numeric(10,2) NOT NULL,
    percentage integer NOT NULL,
    profit numeric(10,2) NOT NULL
);


ALTER TABLE public.external_payments OWNER TO developer;

--
-- TOC entry 226 (class 1259 OID 18568)
-- Name: external_payments_id_seq; Type: SEQUENCE; Schema: public; Owner: developer
--

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


ALTER SEQUENCE public.external_payments_id_seq OWNER TO developer;

--
-- TOC entry 4663 (class 0 OID 0)
-- Dependencies: 226
-- Name: external_payments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: developer
--

ALTER SEQUENCE public.external_payments_id_seq OWNED BY public.external_payments.id;


--
-- TOC entry 215 (class 1259 OID 18504)
-- Name: external_subcontractors; Type: TABLE; Schema: public; Owner: developer
--

CREATE TABLE public.external_subcontractors (
    id integer NOT NULL,
    name character varying(50) NOT NULL,
    bank character varying(50),
    account character varying(50)
);


ALTER TABLE public.external_subcontractors OWNER TO developer;

--
-- TOC entry 214 (class 1259 OID 18502)
-- Name: external_subcontractors_id_seq; Type: SEQUENCE; Schema: public; Owner: developer
--

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


ALTER SEQUENCE public.external_subcontractors_id_seq OWNER TO developer;

--
-- TOC entry 4664 (class 0 OID 0)
-- Dependencies: 214
-- Name: external_subcontractors_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: developer
--

ALTER SEQUENCE public.external_subcontractors_id_seq OWNED BY public.external_subcontractors.id;


--
-- TOC entry 248 (class 1259 OID 18856)
-- Name: feedbacks; Type: TABLE; Schema: public; Owner: developer
--

CREATE TABLE public.feedbacks (
    id integer NOT NULL,
    client_name character varying(150),
    text text
);


ALTER TABLE public.feedbacks OWNER TO developer;

--
-- TOC entry 247 (class 1259 OID 18854)
-- Name: feedbacks_id_seq; Type: SEQUENCE; Schema: public; Owner: developer
--

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


ALTER SEQUENCE public.feedbacks_id_seq OWNER TO developer;

--
-- TOC entry 4665 (class 0 OID 0)
-- Dependencies: 247
-- Name: feedbacks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: developer
--

ALTER SEQUENCE public.feedbacks_id_seq OWNED BY public.feedbacks.id;


--
-- TOC entry 217 (class 1259 OID 18512)
-- Name: jobs; Type: TABLE; Schema: public; Owner: developer
--

CREATE TABLE public.jobs (
    id integer NOT NULL,
    name character varying(150) NOT NULL,
    status integer NOT NULL,
    phone_number character varying(30),
    amount numeric(10,2) NOT NULL,
    address_shipping character varying(200) NOT NULL,
    city_shipping character varying(100) NOT NULL,
    state_shipping character varying(100) NOT NULL,
    zipcode_shipping character varying(50) NOT NULL,
    address_billing character varying(200),
    city_billing character varying(100),
    state_billing character varying(100),
    zipcode_billing character varying(50),
    note text,
    client_id integer,
    estimate_id integer,
    accepted_completion_certificate_date date,
    accepted_home_improvement_date date,
    final_payment numeric(10,2),
    init_payment numeric(10,2),
    partial_payment numeric(10,2),
    material numeric(10,2),
    labor numeric(10,2),
    tax numeric(10,2)
);


ALTER TABLE public.jobs OWNER TO developer;

--
-- TOC entry 242 (class 1259 OID 18753)
-- Name: jobs_files; Type: TABLE; Schema: public; Owner: developer
--

CREATE TABLE public.jobs_files (
    id integer NOT NULL,
    jobs_id integer,
    estimate text
);


ALTER TABLE public.jobs_files OWNER TO developer;

--
-- TOC entry 241 (class 1259 OID 18751)
-- Name: jobs_files_id_seq; Type: SEQUENCE; Schema: public; Owner: developer
--

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


ALTER SEQUENCE public.jobs_files_id_seq OWNER TO developer;

--
-- TOC entry 4666 (class 0 OID 0)
-- Dependencies: 241
-- Name: jobs_files_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: developer
--

ALTER SEQUENCE public.jobs_files_id_seq OWNED BY public.jobs_files.id;


--
-- TOC entry 216 (class 1259 OID 18510)
-- Name: jobs_id_seq; Type: SEQUENCE; Schema: public; Owner: developer
--

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


ALTER SEQUENCE public.jobs_id_seq OWNER TO developer;

--
-- TOC entry 4667 (class 0 OID 0)
-- Dependencies: 216
-- Name: jobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: developer
--

ALTER SEQUENCE public.jobs_id_seq OWNED BY public.jobs.id;


--
-- TOC entry 260 (class 1259 OID 19093)
-- Name: licences; Type: TABLE; Schema: public; Owner: developer
--

CREATE TABLE public.licences (
    id integer NOT NULL,
    file text NOT NULL,
    name character varying(50) NOT NULL
);


ALTER TABLE public.licences OWNER TO developer;

--
-- TOC entry 259 (class 1259 OID 19091)
-- Name: licences_id_seq; Type: SEQUENCE; Schema: public; Owner: developer
--

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


ALTER SEQUENCE public.licences_id_seq OWNER TO developer;

--
-- TOC entry 4668 (class 0 OID 0)
-- Dependencies: 259
-- Name: licences_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: developer
--

ALTER SEQUENCE public.licences_id_seq OWNED BY public.licences.id;


--
-- TOC entry 266 (class 1259 OID 19842)
-- Name: login_request; Type: TABLE; Schema: public; Owner: developer
--

CREATE TABLE public.login_request (
    id integer NOT NULL,
    hash character varying(150),
    code character varying(6),
    used boolean,
    user_id integer
);


ALTER TABLE public.login_request OWNER TO developer;

--
-- TOC entry 265 (class 1259 OID 19841)
-- Name: login_request_id_seq; Type: SEQUENCE; Schema: public; Owner: developer
--

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


ALTER SEQUENCE public.login_request_id_seq OWNER TO developer;

--
-- TOC entry 4669 (class 0 OID 0)
-- Dependencies: 265
-- Name: login_request_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: developer
--

ALTER SEQUENCE public.login_request_id_seq OWNED BY public.login_request.id;


--
-- TOC entry 262 (class 1259 OID 19165)
-- Name: miscellaneous; Type: TABLE; Schema: public; Owner: developer
--

CREATE TABLE public.miscellaneous (
    id integer NOT NULL,
    description text NOT NULL,
    amount numeric(10,2) NOT NULL,
    date date NOT NULL,
    jobs_id integer
);


ALTER TABLE public.miscellaneous OWNER TO developer;

--
-- TOC entry 261 (class 1259 OID 19163)
-- Name: miscellaneous_id_seq; Type: SEQUENCE; Schema: public; Owner: developer
--

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


ALTER SEQUENCE public.miscellaneous_id_seq OWNER TO developer;

--
-- TOC entry 4670 (class 0 OID 0)
-- Dependencies: 261
-- Name: miscellaneous_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: developer
--

ALTER SEQUENCE public.miscellaneous_id_seq OWNED BY public.miscellaneous.id;


--
-- TOC entry 229 (class 1259 OID 18583)
-- Name: payments; Type: TABLE; Schema: public; Owner: developer
--

CREATE TABLE public.payments (
    id integer NOT NULL,
    description text NOT NULL,
    amount numeric(10,2) NOT NULL,
    date date NOT NULL,
    jobs_id integer
);


ALTER TABLE public.payments OWNER TO developer;

--
-- TOC entry 228 (class 1259 OID 18581)
-- Name: payments_id_seq; Type: SEQUENCE; Schema: public; Owner: developer
--

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


ALTER SEQUENCE public.payments_id_seq OWNER TO developer;

--
-- TOC entry 4671 (class 0 OID 0)
-- Dependencies: 228
-- Name: payments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: developer
--

ALTER SEQUENCE public.payments_id_seq OWNED BY public.payments.id;


--
-- TOC entry 246 (class 1259 OID 18813)
-- Name: project_photos; Type: TABLE; Schema: public; Owner: developer
--

CREATE TABLE public.project_photos (
    id integer NOT NULL,
    project_id integer,
    photo text
);


ALTER TABLE public.project_photos OWNER TO developer;

--
-- TOC entry 245 (class 1259 OID 18811)
-- Name: project_photos_id_seq; Type: SEQUENCE; Schema: public; Owner: developer
--

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


ALTER SEQUENCE public.project_photos_id_seq OWNER TO developer;

--
-- TOC entry 4672 (class 0 OID 0)
-- Dependencies: 245
-- Name: project_photos_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: developer
--

ALTER SEQUENCE public.project_photos_id_seq OWNED BY public.project_photos.id;


--
-- TOC entry 244 (class 1259 OID 18786)
-- Name: projects; Type: TABLE; Schema: public; Owner: developer
--

CREATE TABLE public.projects (
    id integer NOT NULL,
    name character varying(150),
    text text,
    year integer,
    category integer NOT NULL,
    location character varying(150)
);


ALTER TABLE public.projects OWNER TO developer;

--
-- TOC entry 243 (class 1259 OID 18784)
-- Name: projects_id_seq; Type: SEQUENCE; Schema: public; Owner: developer
--

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


ALTER SEQUENCE public.projects_id_seq OWNER TO developer;

--
-- TOC entry 4673 (class 0 OID 0)
-- Dependencies: 243
-- Name: projects_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: developer
--

ALTER SEQUENCE public.projects_id_seq OWNED BY public.projects.id;


--
-- TOC entry 258 (class 1259 OID 19036)
-- Name: remember_password; Type: TABLE; Schema: public; Owner: developer
--

CREATE TABLE public.remember_password (
    id integer NOT NULL,
    code character varying(150),
    forgoted boolean,
    client_id integer,
    redirect character varying(150)
);


ALTER TABLE public.remember_password OWNER TO developer;

--
-- TOC entry 257 (class 1259 OID 19034)
-- Name: remember_password_id_seq; Type: SEQUENCE; Schema: public; Owner: developer
--

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


ALTER SEQUENCE public.remember_password_id_seq OWNER TO developer;

--
-- TOC entry 4674 (class 0 OID 0)
-- Dependencies: 257
-- Name: remember_password_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: developer
--

ALTER SEQUENCE public.remember_password_id_seq OWNED BY public.remember_password.id;


--
-- TOC entry 219 (class 1259 OID 18523)
-- Name: settings; Type: TABLE; Schema: public; Owner: developer
--

CREATE TABLE public.settings (
    id integer NOT NULL,
    ip_address character varying(100) NOT NULL
);


ALTER TABLE public.settings OWNER TO developer;

--
-- TOC entry 218 (class 1259 OID 18521)
-- Name: settings_id_seq; Type: SEQUENCE; Schema: public; Owner: developer
--

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


ALTER SEQUENCE public.settings_id_seq OWNER TO developer;

--
-- TOC entry 4675 (class 0 OID 0)
-- Dependencies: 218
-- Name: settings_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: developer
--

ALTER SEQUENCE public.settings_id_seq OWNED BY public.settings.id;


--
-- TOC entry 252 (class 1259 OID 18908)
-- Name: shop_lists; Type: TABLE; Schema: public; Owner: developer
--

CREATE TABLE public.shop_lists (
    id integer NOT NULL,
    date date NOT NULL,
    note text,
    client_id integer,
    estimate_id integer
);


ALTER TABLE public.shop_lists OWNER TO developer;

--
-- TOC entry 251 (class 1259 OID 18906)
-- Name: shop_lists_id_seq; Type: SEQUENCE; Schema: public; Owner: developer
--

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


ALTER SEQUENCE public.shop_lists_id_seq OWNER TO developer;

--
-- TOC entry 4676 (class 0 OID 0)
-- Dependencies: 251
-- Name: shop_lists_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: developer
--

ALTER SEQUENCE public.shop_lists_id_seq OWNED BY public.shop_lists.id;


--
-- TOC entry 254 (class 1259 OID 18924)
-- Name: shop_lists_items; Type: TABLE; Schema: public; Owner: developer
--

CREATE TABLE public.shop_lists_items (
    id integer NOT NULL,
    material text,
    qtd text,
    shop_list_id integer,
    ordem integer NOT NULL
);


ALTER TABLE public.shop_lists_items OWNER TO developer;

--
-- TOC entry 253 (class 1259 OID 18922)
-- Name: shop_lists_items_id_seq; Type: SEQUENCE; Schema: public; Owner: developer
--

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


ALTER SEQUENCE public.shop_lists_items_id_seq OWNER TO developer;

--
-- TOC entry 4677 (class 0 OID 0)
-- Dependencies: 253
-- Name: shop_lists_items_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: developer
--

ALTER SEQUENCE public.shop_lists_items_id_seq OWNED BY public.shop_lists_items.id;


--
-- TOC entry 256 (class 1259 OID 19001)
-- Name: subcontractor_miscellaneous; Type: TABLE; Schema: public; Owner: developer
--

CREATE TABLE public.subcontractor_miscellaneous (
    id integer NOT NULL,
    date date NOT NULL,
    name character varying(100) NOT NULL,
    description text,
    amount numeric(10,2) NOT NULL,
    subcontractors_id integer
);


ALTER TABLE public.subcontractor_miscellaneous OWNER TO developer;

--
-- TOC entry 255 (class 1259 OID 18999)
-- Name: subcontractor_miscellaneous_id_seq; Type: SEQUENCE; Schema: public; Owner: developer
--

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


ALTER SEQUENCE public.subcontractor_miscellaneous_id_seq OWNER TO developer;

--
-- TOC entry 4678 (class 0 OID 0)
-- Dependencies: 255
-- Name: subcontractor_miscellaneous_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: developer
--

ALTER SEQUENCE public.subcontractor_miscellaneous_id_seq OWNED BY public.subcontractor_miscellaneous.id;


--
-- TOC entry 231 (class 1259 OID 18599)
-- Name: subcontractor_payment; Type: TABLE; Schema: public; Owner: developer
--

CREATE TABLE public.subcontractor_payment (
    id integer NOT NULL,
    jobs_id integer,
    subcontractors_id integer,
    date date NOT NULL,
    status integer NOT NULL,
    description text NOT NULL
);


ALTER TABLE public.subcontractor_payment OWNER TO developer;

--
-- TOC entry 230 (class 1259 OID 18597)
-- Name: subcontractor_payment_id_seq; Type: SEQUENCE; Schema: public; Owner: developer
--

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


ALTER SEQUENCE public.subcontractor_payment_id_seq OWNER TO developer;

--
-- TOC entry 4679 (class 0 OID 0)
-- Dependencies: 230
-- Name: subcontractor_payment_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: developer
--

ALTER SEQUENCE public.subcontractor_payment_id_seq OWNED BY public.subcontractor_payment.id;


--
-- TOC entry 233 (class 1259 OID 18620)
-- Name: subcontractor_payment_items; Type: TABLE; Schema: public; Owner: developer
--

CREATE TABLE public.subcontractor_payment_items (
    id integer NOT NULL,
    activity text NOT NULL,
    date date NOT NULL,
    amount numeric(10,2) NOT NULL,
    subcontractors_payment_id integer
);


ALTER TABLE public.subcontractor_payment_items OWNER TO developer;

--
-- TOC entry 232 (class 1259 OID 18618)
-- Name: subcontractor_payment_items_id_seq; Type: SEQUENCE; Schema: public; Owner: developer
--

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


ALTER SEQUENCE public.subcontractor_payment_items_id_seq OWNER TO developer;

--
-- TOC entry 4680 (class 0 OID 0)
-- Dependencies: 232
-- Name: subcontractor_payment_items_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: developer
--

ALTER SEQUENCE public.subcontractor_payment_items_id_seq OWNED BY public.subcontractor_payment_items.id;


--
-- TOC entry 221 (class 1259 OID 18531)
-- Name: subcontractors; Type: TABLE; Schema: public; Owner: developer
--

CREATE TABLE public.subcontractors (
    id integer NOT NULL,
    name character varying(50) NOT NULL,
    description text NOT NULL
);


ALTER TABLE public.subcontractors OWNER TO developer;

--
-- TOC entry 220 (class 1259 OID 18529)
-- Name: subcontractors_id_seq; Type: SEQUENCE; Schema: public; Owner: developer
--

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


ALTER SEQUENCE public.subcontractors_id_seq OWNER TO developer;

--
-- TOC entry 4681 (class 0 OID 0)
-- Dependencies: 220
-- Name: subcontractors_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: developer
--

ALTER SEQUENCE public.subcontractors_id_seq OWNED BY public.subcontractors.id;


--
-- TOC entry 223 (class 1259 OID 18542)
-- Name: users; Type: TABLE; Schema: public; Owner: developer
--

CREATE TABLE public.users (
    id integer NOT NULL,
    name character varying(50) NOT NULL,
    email character varying(150) NOT NULL,
    password character varying(200) NOT NULL,
    user_level integer NOT NULL
);


ALTER TABLE public.users OWNER TO developer;

--
-- TOC entry 222 (class 1259 OID 18540)
-- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: developer
--

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


ALTER SEQUENCE public.users_id_seq OWNER TO developer;

--
-- TOC entry 4682 (class 0 OID 0)
-- Dependencies: 222
-- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: developer
--

ALTER SEQUENCE public.users_id_seq OWNED BY public.users.id;


--
-- TOC entry 4350 (class 2604 OID 16409)
-- Name: clients id; Type: DEFAULT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.clients ALTER COLUMN id SET DEFAULT nextval('public.clients_id_seq'::regclass);


--
-- TOC entry 4357 (class 2604 OID 16410)
-- Name: contacts id; Type: DEFAULT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.contacts ALTER COLUMN id SET DEFAULT nextval('public.contacts_id_seq'::regclass);


--
-- TOC entry 4366 (class 2604 OID 19896)
-- Name: email_log_status id; Type: DEFAULT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.email_log_status ALTER COLUMN id SET DEFAULT nextval('public.email_log_status_id_seq'::regclass);


--
-- TOC entry 4364 (class 2604 OID 16411)
-- Name: estimate_logs id; Type: DEFAULT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.estimate_logs ALTER COLUMN id SET DEFAULT nextval('public.estimate_logs_id_seq'::regclass);


--
-- TOC entry 4351 (class 2604 OID 16412)
-- Name: estimates id; Type: DEFAULT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.estimates ALTER COLUMN id SET DEFAULT nextval('public.estimates_id_seq'::regclass);


--
-- TOC entry 4352 (class 2604 OID 16413)
-- Name: estimates_items id; Type: DEFAULT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.estimates_items ALTER COLUMN id SET DEFAULT nextval('public.estimates_items_id_seq'::regclass);


--
-- TOC entry 4345 (class 2604 OID 16414)
-- Name: expenses id; Type: DEFAULT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.expenses ALTER COLUMN id SET DEFAULT nextval('public.expenses_id_seq'::regclass);


--
-- TOC entry 4346 (class 2604 OID 16415)
-- Name: external_payments id; Type: DEFAULT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.external_payments ALTER COLUMN id SET DEFAULT nextval('public.external_payments_id_seq'::regclass);


--
-- TOC entry 4340 (class 2604 OID 16416)
-- Name: external_subcontractors id; Type: DEFAULT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.external_subcontractors ALTER COLUMN id SET DEFAULT nextval('public.external_subcontractors_id_seq'::regclass);


--
-- TOC entry 4356 (class 2604 OID 16417)
-- Name: feedbacks id; Type: DEFAULT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.feedbacks ALTER COLUMN id SET DEFAULT nextval('public.feedbacks_id_seq'::regclass);


--
-- TOC entry 4341 (class 2604 OID 16418)
-- Name: jobs id; Type: DEFAULT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.jobs ALTER COLUMN id SET DEFAULT nextval('public.jobs_id_seq'::regclass);


--
-- TOC entry 4353 (class 2604 OID 16419)
-- Name: jobs_files id; Type: DEFAULT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.jobs_files ALTER COLUMN id SET DEFAULT nextval('public.jobs_files_id_seq'::regclass);


--
-- TOC entry 4362 (class 2604 OID 16420)
-- Name: licences id; Type: DEFAULT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.licences ALTER COLUMN id SET DEFAULT nextval('public.licences_id_seq'::regclass);


--
-- TOC entry 4365 (class 2604 OID 19845)
-- Name: login_request id; Type: DEFAULT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.login_request ALTER COLUMN id SET DEFAULT nextval('public.login_request_id_seq'::regclass);


--
-- TOC entry 4363 (class 2604 OID 16421)
-- Name: miscellaneous id; Type: DEFAULT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.miscellaneous ALTER COLUMN id SET DEFAULT nextval('public.miscellaneous_id_seq'::regclass);


--
-- TOC entry 4347 (class 2604 OID 16422)
-- Name: payments id; Type: DEFAULT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.payments ALTER COLUMN id SET DEFAULT nextval('public.payments_id_seq'::regclass);


--
-- TOC entry 4355 (class 2604 OID 16423)
-- Name: project_photos id; Type: DEFAULT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.project_photos ALTER COLUMN id SET DEFAULT nextval('public.project_photos_id_seq'::regclass);


--
-- TOC entry 4354 (class 2604 OID 16424)
-- Name: projects id; Type: DEFAULT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.projects ALTER COLUMN id SET DEFAULT nextval('public.projects_id_seq'::regclass);


--
-- TOC entry 4361 (class 2604 OID 16425)
-- Name: remember_password id; Type: DEFAULT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.remember_password ALTER COLUMN id SET DEFAULT nextval('public.remember_password_id_seq'::regclass);


--
-- TOC entry 4342 (class 2604 OID 16426)
-- Name: settings id; Type: DEFAULT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.settings ALTER COLUMN id SET DEFAULT nextval('public.settings_id_seq'::regclass);


--
-- TOC entry 4358 (class 2604 OID 16427)
-- Name: shop_lists id; Type: DEFAULT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.shop_lists ALTER COLUMN id SET DEFAULT nextval('public.shop_lists_id_seq'::regclass);


--
-- TOC entry 4359 (class 2604 OID 16428)
-- Name: shop_lists_items id; Type: DEFAULT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.shop_lists_items ALTER COLUMN id SET DEFAULT nextval('public.shop_lists_items_id_seq'::regclass);


--
-- TOC entry 4360 (class 2604 OID 16429)
-- Name: subcontractor_miscellaneous id; Type: DEFAULT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.subcontractor_miscellaneous ALTER COLUMN id SET DEFAULT nextval('public.subcontractor_miscellaneous_id_seq'::regclass);


--
-- TOC entry 4348 (class 2604 OID 16430)
-- Name: subcontractor_payment id; Type: DEFAULT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.subcontractor_payment ALTER COLUMN id SET DEFAULT nextval('public.subcontractor_payment_id_seq'::regclass);


--
-- TOC entry 4349 (class 2604 OID 16431)
-- Name: subcontractor_payment_items id; Type: DEFAULT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.subcontractor_payment_items ALTER COLUMN id SET DEFAULT nextval('public.subcontractor_payment_items_id_seq'::regclass);


--
-- TOC entry 4343 (class 2604 OID 16432)
-- Name: subcontractors id; Type: DEFAULT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.subcontractors ALTER COLUMN id SET DEFAULT nextval('public.subcontractors_id_seq'::regclass);


--
-- TOC entry 4344 (class 2604 OID 16433)
-- Name: users id; Type: DEFAULT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.users ALTER COLUMN id SET DEFAULT nextval('public.users_id_seq'::regclass);


--
-- TOC entry 4614 (class 0 OID 18644)
-- Dependencies: 234
-- Data for Name: alembic_version; Type: TABLE DATA; Schema: public; Owner: developer
--

INSERT INTO public.alembic_version (version_num) VALUES ('168afa4c2728');


--
-- TOC entry 4616 (class 0 OID 18651)
-- Dependencies: 236
-- Data for Name: clients; Type: TABLE DATA; Schema: public; Owner: developer
--

INSERT INTO public.clients (id, name, phone_number, address_billing, city_billing, state_billing, zipcode_billing, email, password, user_level, note) VALUES (12, 'Wendy Carvalho e Silva', '', 'Rua Oswaldo De Freitas Nunes N 212, Casa', 'Pacajús', 'CE', '62870000', 'wendy.car.silva@gmail.com', NULL, NULL, NULL);
INSERT INTO public.clients (id, name, phone_number, address_billing, city_billing, state_billing, zipcode_billing, email, password, user_level, note) VALUES (1, 'Filipe Carvalho', '85999688200', 'Rua Oswaldo De Freitas Nunes N 212, Casa', 'Pacajús', 'CE', '62870000', 'filipekav@gmail.com', '$pbkdf2-sha256$29000$JYQw5ty719ob4/xfaw2hFA$3w57JQ9NYm6PP9oQFLG4zjFZ6NnzgWpwkE2YBF8VANE', 3, 'Teste de notas
ok');
INSERT INTO public.clients (id, name, phone_number, address_billing, city_billing, state_billing, zipcode_billing, email, password, user_level, note) VALUES (16, 'Wendy Carvalho e Silva', '', '3519 chastain glen ln ne, 3519 chastain glen ln ne', 'marietta', 'Georgia', '30066', 'filipecarvalho_01@yahoo.com.br', NULL, NULL, NULL);


--
-- TOC entry 4630 (class 0 OID 18878)
-- Dependencies: 250
-- Data for Name: contacts; Type: TABLE DATA; Schema: public; Owner: developer
--



--
-- TOC entry 4648 (class 0 OID 19893)
-- Dependencies: 268
-- Data for Name: email_log_status; Type: TABLE DATA; Schema: public; Owner: developer
--

INSERT INTO public.email_log_status (id, message_id, date, event) VALUES (8, '<171577994955.31644.11814149527799500085@PC-FILIPE>', '2024-05-15 10:09:00', 'request');
INSERT INTO public.email_log_status (id, message_id, date, event) VALUES (9, '<171577994955.31644.11814149527799500085@PC-FILIPE>', '2024-05-15 10:09:00', 'click');
INSERT INTO public.email_log_status (id, message_id, date, event) VALUES (10, '<171577994955.31644.11814149527799500085@PC-FILIPE>', '2024-05-15 10:09:00', 'deferred');
INSERT INTO public.email_log_status (id, message_id, date, event) VALUES (11, '<171577994955.31644.11814149527799500085@PC-FILIPE>', '2024-05-15 10:09:00', 'delivered');
INSERT INTO public.email_log_status (id, message_id, date, event) VALUES (12, '<171577994955.31644.11814149527799500085@PC-FILIPE>', '2024-05-15 10:09:00', 'soft_bounce');
INSERT INTO public.email_log_status (id, message_id, date, event) VALUES (13, '<171577994955.31644.11814149527799500085@PC-FILIPE>', '2024-05-15 10:09:00', 'hard_bounce');
INSERT INTO public.email_log_status (id, message_id, date, event) VALUES (14, '<171577994955.31644.11814149527799500085@PC-FILIPE>', '2024-05-15 10:09:00', 'complaint');
INSERT INTO public.email_log_status (id, message_id, date, event) VALUES (15, '<171577994955.31644.11814149527799500085@PC-FILIPE>', '2024-05-15 10:09:00', 'unique_opened');
INSERT INTO public.email_log_status (id, message_id, date, event) VALUES (16, '<171577994955.31644.11814149527799500085@PC-FILIPE>', '2024-05-15 10:09:00', 'opened');
INSERT INTO public.email_log_status (id, message_id, date, event) VALUES (17, '<171577994955.31644.11814149527799500085@PC-FILIPE>', '2024-05-15 10:09:00', 'invalid_email');
INSERT INTO public.email_log_status (id, message_id, date, event) VALUES (18, '<171577994955.31644.11814149527799500085@PC-FILIPE>', '2024-05-15 10:09:00', 'blocked');
INSERT INTO public.email_log_status (id, message_id, date, event) VALUES (19, '<171586013570.12472.12285351355915931560@PC-FILIPE>', '2024-05-15 10:09:00', 'Send');


--
-- TOC entry 4644 (class 0 OID 19212)
-- Dependencies: 264
-- Data for Name: estimate_logs; Type: TABLE DATA; Schema: public; Owner: developer
--

INSERT INTO public.estimate_logs (id, action, date, estimate_id, message_id) VALUES (1, 0, '2021-03-30', 11, NULL);
INSERT INTO public.estimate_logs (id, action, date, estimate_id, message_id) VALUES (2, 0, '2021-03-30', 31, NULL);
INSERT INTO public.estimate_logs (id, action, date, estimate_id, message_id) VALUES (3, 1, '2021-03-30', 31, NULL);
INSERT INTO public.estimate_logs (id, action, date, estimate_id, message_id) VALUES (4, 0, '2021-04-08', 32, NULL);
INSERT INTO public.estimate_logs (id, action, date, estimate_id, message_id) VALUES (5, 0, '2021-08-18', 22, NULL);
INSERT INTO public.estimate_logs (id, action, date, estimate_id, message_id) VALUES (6, 0, '2021-11-29', 31, NULL);
INSERT INTO public.estimate_logs (id, action, date, estimate_id, message_id) VALUES (7, 0, '2021-11-29', 31, NULL);
INSERT INTO public.estimate_logs (id, action, date, estimate_id, message_id) VALUES (8, 0, '2021-11-29', 31, NULL);
INSERT INTO public.estimate_logs (id, action, date, estimate_id, message_id) VALUES (9, 0, '2021-11-29', 31, NULL);
INSERT INTO public.estimate_logs (id, action, date, estimate_id, message_id) VALUES (10, 0, '2021-11-29', 31, NULL);
INSERT INTO public.estimate_logs (id, action, date, estimate_id, message_id) VALUES (11, 0, '2021-11-29', 31, NULL);
INSERT INTO public.estimate_logs (id, action, date, estimate_id, message_id) VALUES (12, 0, '2021-11-29', 31, NULL);
INSERT INTO public.estimate_logs (id, action, date, estimate_id, message_id) VALUES (13, 0, '2021-11-29', 31, NULL);
INSERT INTO public.estimate_logs (id, action, date, estimate_id, message_id) VALUES (14, 0, '2021-11-29', 31, NULL);
INSERT INTO public.estimate_logs (id, action, date, estimate_id, message_id) VALUES (15, 0, '2021-12-06', 31, NULL);
INSERT INTO public.estimate_logs (id, action, date, estimate_id, message_id) VALUES (16, 0, '2024-02-18', 22, NULL);
INSERT INTO public.estimate_logs (id, action, date, estimate_id, message_id) VALUES (17, 1, '2024-02-18', 22, NULL);
INSERT INTO public.estimate_logs (id, action, date, estimate_id, message_id) VALUES (18, 0, '2024-04-10', 11, NULL);
INSERT INTO public.estimate_logs (id, action, date, estimate_id, message_id) VALUES (19, 0, '2024-04-10', 31, NULL);
INSERT INTO public.estimate_logs (id, action, date, estimate_id, message_id) VALUES (20, 0, '2024-04-10', 31, NULL);
INSERT INTO public.estimate_logs (id, action, date, estimate_id, message_id) VALUES (21, 0, '2024-04-10', 11, NULL);
INSERT INTO public.estimate_logs (id, action, date, estimate_id, message_id) VALUES (22, 1, '2024-04-10', 11, NULL);
INSERT INTO public.estimate_logs (id, action, date, estimate_id, message_id) VALUES (23, 0, '2024-04-10', 11, NULL);
INSERT INTO public.estimate_logs (id, action, date, estimate_id, message_id) VALUES (24, 1, '2024-04-10', 11, NULL);
INSERT INTO public.estimate_logs (id, action, date, estimate_id, message_id) VALUES (25, 0, '2024-04-10', 11, NULL);
INSERT INTO public.estimate_logs (id, action, date, estimate_id, message_id) VALUES (26, 1, '2024-04-10', 11, NULL);
INSERT INTO public.estimate_logs (id, action, date, estimate_id, message_id) VALUES (27, 0, '2024-04-16', 33, NULL);
INSERT INTO public.estimate_logs (id, action, date, estimate_id, message_id) VALUES (28, 0, '2024-04-25', 34, NULL);
INSERT INTO public.estimate_logs (id, action, date, estimate_id, message_id) VALUES (29, 0, '2024-04-25', 34, NULL);
INSERT INTO public.estimate_logs (id, action, date, estimate_id, message_id) VALUES (30, 0, '2024-04-30', 34, NULL);
INSERT INTO public.estimate_logs (id, action, date, estimate_id, message_id) VALUES (31, 0, '2024-04-30', 34, NULL);
INSERT INTO public.estimate_logs (id, action, date, estimate_id, message_id) VALUES (32, 0, '2024-04-30', 34, NULL);
INSERT INTO public.estimate_logs (id, action, date, estimate_id, message_id) VALUES (33, 0, '2024-05-15', 34, '<171577994955.31644.11814149527799500085@PC-FILIPE>');
INSERT INTO public.estimate_logs (id, action, date, estimate_id, message_id) VALUES (34, 0, '2024-05-16', 34, '<171586013570.12472.12285351355915931560@PC-FILIPE>');
INSERT INTO public.estimate_logs (id, action, date, estimate_id, message_id) VALUES (35, 0, '2024-05-21', 22, '<171632067058.30556.15422010131801767912@PC-FILIPE>');
INSERT INTO public.estimate_logs (id, action, date, estimate_id, message_id) VALUES (36, 0, '2024-05-21', 34, '<171632088624.22080.7503388132949681553@PC-FILIPE>');
INSERT INTO public.estimate_logs (id, action, date, estimate_id, message_id) VALUES (37, 0, '2024-05-21', 22, '<171632096921.32564.4881274398300022460@PC-FILIPE>');
INSERT INTO public.estimate_logs (id, action, date, estimate_id, message_id) VALUES (38, 0, '2024-05-21', 22, '<171632100062.32564.5665003263314357756@PC-FILIPE>');


--
-- TOC entry 4618 (class 0 OID 18685)
-- Dependencies: 238
-- Data for Name: estimates; Type: TABLE DATA; Schema: public; Owner: developer
--

INSERT INTO public.estimates (id, date, note, client_id, address_shipping, city_shipping, state_shipping, zipcode_shipping, name, authorization_date, accepted_home_improvement_date, due_date, hash, charge_tax) VALUES (11, '2020-09-24', '<p>-Customer to supply Tiles only.
<br>
-Contractor to supply setting material as needed.
<br>
-Customer will select grout color.
<br>
-Anti fraction, waterproofing will be applied, NO EXTRA CHARGE!
<br>
-Plumbing it''s not included </p>', 1, 'Rua Oswaldo De Freitas Nunes N 212, Casa', 'Pacajús', 'CE', '62870000', 'Master bathroom and floor tile (whole apartment)', '2024-04-10', NULL, '2024-05-08', '16291508f75611ee910d047f0e495bdc', NULL);
INSERT INTO public.estimates (id, date, note, client_id, address_shipping, city_shipping, state_shipping, zipcode_shipping, name, authorization_date, accepted_home_improvement_date, due_date, hash, charge_tax) VALUES (32, '2021-04-08', '<p></p>', 16, 'Rua Oswaldo De Freitas Nunes N 212', 'Pacajús', 'CE', '62870000', 'Teste', NULL, NULL, NULL, NULL, NULL);
INSERT INTO public.estimates (id, date, note, client_id, address_shipping, city_shipping, state_shipping, zipcode_shipping, name, authorization_date, accepted_home_improvement_date, due_date, hash, charge_tax) VALUES (33, '2024-04-16', '<p>-Customer to supply Tiles only.
<br>
-Contractor to supply setting material as needed.
<br>
-Customer will select grout color.
<br>
-Anti fraction, waterproofing will be applied, NO EXTRA CHARGE!
<br>
-Plumbing it''s not included </p>', 1, 'Rua Oswaldo De Freitas Nunes N 212, Casa', 'Pacajús', 'CE', '62870000', 'Master bathroom and floor tile (whole apartment) - Clone', NULL, NULL, '2024-04-10', '24485ff6fc3311eeba1e047f0e495bdc', false);
INSERT INTO public.estimates (id, date, note, client_id, address_shipping, city_shipping, state_shipping, zipcode_shipping, name, authorization_date, accepted_home_improvement_date, due_date, hash, charge_tax) VALUES (31, '2021-03-22', 'TESTE NOTEasdfg
asdgfasdfh
dhfaadfhadfh
adfhadfhadfh
adfhadfhdaf
adhfadh
adfhadfh
adhfadhfadfh
TESTE NOTEasdfg
asdgfasdfh
dhfaadfhadfh
adfhadfhadfh
adfhadfhdaf
adhfadh
adfhadfh
adhfadhfadfh
TESTE NOTEasdfg
asdgfasdfh
dhfaadfhadfh
adfhadfhadfh
adfhadfhdaf
adhfadh
adfhadfh
adhfadhfadfh
TESTE NOTEasdfg
asdgfasdfh
dhfaadfhadfh
adfhadfhadfh
adfhadfhdaf
adhfadh
adfhadfh
adhfadhfadfh
TESTE NOTEasdfg
asdgfasdfh
dhfaadfhadfh
adfhadfhadfh
adfhadfhdaf
adhfadh
adfhadfh
adhfadhfadfh', 1, 'Rua Oswaldo De Freitas Nunes N 212, Casa', 'Pacajús', 'CE', '62870000', 'Master bathroom and floor tile (whole apartment) - Clone', '2021-03-30', NULL, '2024-02-01', '52ffa0e4f73a11eeac2b047f0e495bdc', false);
INSERT INTO public.estimates (id, date, note, client_id, address_shipping, city_shipping, state_shipping, zipcode_shipping, name, authorization_date, accepted_home_improvement_date, due_date, hash, charge_tax) VALUES (34, '2024-04-08', '', 1, 'Rua Oswaldo De Freitas Nunes N 212, Casa', 'Pacajús', 'CE', '62870000', 'teste 1 item', NULL, NULL, '2024-04-24', '092e7c4217ab11efba8a74563c646cb3', true);
INSERT INTO public.estimates (id, date, note, client_id, address_shipping, city_shipping, state_shipping, zipcode_shipping, name, authorization_date, accepted_home_improvement_date, due_date, hash, charge_tax) VALUES (22, '2021-02-16', '<p><p>1
<br><br>
2
<br><br>
3
<br><br>
54</p></p>', 1, 'Rua Oswaldo De Freitas Nunes N 212, Casa', 'Pacajús', 'CE', '62870000', 'Novo', '2024-02-18', '2024-02-18', NULL, '4c7e870217ab11efb6dd74563c646cb3', NULL);
INSERT INTO public.estimates (id, date, note, client_id, address_shipping, city_shipping, state_shipping, zipcode_shipping, name, authorization_date, accepted_home_improvement_date, due_date, hash, charge_tax) VALUES (35, '2024-06-02', '', 1, 'Rua Oswaldo De Freitas Nunes N 212, Casa', 'Pacajús', 'CE', '62870000', 'teste 1 item - Clone', NULL, NULL, NULL, NULL, false);
INSERT INTO public.estimates (id, date, note, client_id, address_shipping, city_shipping, state_shipping, zipcode_shipping, name, authorization_date, accepted_home_improvement_date, due_date, hash, charge_tax) VALUES (13, '2020-10-15', 'SHOP LIST: CUSTOMER TO BUY
FLOOR TILE 1186 SQ FT (10% for waste has been added)

CUSTOMER TO SUPPLY TILES ONLY. 
CONTRACTOR TO  SUPPLY SETTING MATERIAL AS NEEDED. 
', 12, 'Rua Oswaldo De Freitas Nunes N 212, Casa', 'Pacajús', 'CE', '62870000', 'Casa', NULL, NULL, NULL, NULL, NULL);


--
-- TOC entry 4620 (class 0 OID 18701)
-- Dependencies: 240
-- Data for Name: estimates_items; Type: TABLE DATA; Schema: public; Owner: developer
--

INSERT INTO public.estimates_items (id, name, qtd, unique_amount, estimate_id, description, hidden, ordem, material) VALUES (47, 'Instalar Piso', 2, 1.000000000000000, NULL, 'teste', false, 0, NULL);
INSERT INTO public.estimates_items (id, name, qtd, unique_amount, estimate_id, description, hidden, ordem, material) VALUES (48, 'asd', 1, 10.000000000000000, NULL, 'teste', false, 0, NULL);
INSERT INTO public.estimates_items (id, name, qtd, unique_amount, estimate_id, description, hidden, ordem, material) VALUES (77, 'Labor to remove floor tile', 92, 1.000000000000000, 33, 'Apartment balcony', false, 0, false);
INSERT INTO public.estimates_items (id, name, qtd, unique_amount, estimate_id, description, hidden, ordem, material) VALUES (78, 'Labor to apply waterproofing ', 92, 1.000000000000000, 33, 'Apartment balcony', false, 1, false);
INSERT INTO public.estimates_items (id, name, qtd, unique_amount, estimate_id, description, hidden, ordem, material) VALUES (79, 'Labor to install floor tile (Diagonal)', 92, 10.000000000000000, 33, 'Apartment balcony', false, 2, false);
INSERT INTO public.estimates_items (id, name, qtd, unique_amount, estimate_id, description, hidden, ordem, material) VALUES (80, 'Flat Line (clips)', 92, 0.200000000000000, 33, '', false, 3, false);
INSERT INTO public.estimates_items (id, name, qtd, unique_amount, estimate_id, description, hidden, ordem, material) VALUES (81, 'Material', 100, 2.000000000000000, 33, 'Teste', false, 4, true);
INSERT INTO public.estimates_items (id, name, qtd, unique_amount, estimate_id, description, hidden, ordem, material) VALUES (82, 'TIJOLO', 1, 300.000000000000000, 33, 'Thin set, grout, caulk, Schluter and waterproofing', false, 5, true);
INSERT INTO public.estimates_items (id, name, qtd, unique_amount, estimate_id, description, hidden, ordem, material) VALUES (83, 'CIMENTO', 20, 100.000000000000000, 33, '', false, 6, true);
INSERT INTO public.estimates_items (id, name, qtd, unique_amount, estimate_id, description, hidden, ordem, material) VALUES (66, 'Labor to remove floor tile', 92, 1.000000000000000, 31, 'Apartment balcony', false, 0, false);
INSERT INTO public.estimates_items (id, name, qtd, unique_amount, estimate_id, description, hidden, ordem, material) VALUES (67, 'Labor to apply waterproofing ', 92, 1.000000000000000, 31, 'Apartment balcony', false, 1, false);
INSERT INTO public.estimates_items (id, name, qtd, unique_amount, estimate_id, description, hidden, ordem, material) VALUES (68, 'Labor to install floor tile (Diagonal)', 92, 10.000000000000000, 31, 'Apartment balcony', false, 2, false);
INSERT INTO public.estimates_items (id, name, qtd, unique_amount, estimate_id, description, hidden, ordem, material) VALUES (69, 'Flat Line (clips)', 92, 0.200000000000000, 31, '', false, 3, false);
INSERT INTO public.estimates_items (id, name, qtd, unique_amount, estimate_id, description, hidden, ordem, material) VALUES (70, 'Installation Material', 1, 275.600000000000000, 31, 'Thin set, grout, caulk, Schluter and waterproofing', false, 4, false);
INSERT INTO public.estimates_items (id, name, qtd, unique_amount, estimate_id, description, hidden, ordem, material) VALUES (22, 'Labor to remove floor tile', 92, 1.000000000000000, 11, 'Apartment balcony', false, 0, false);
INSERT INTO public.estimates_items (id, name, qtd, unique_amount, estimate_id, description, hidden, ordem, material) VALUES (23, 'Labor to apply waterproofing ', 92, 1.000000000000000, 11, 'Apartment balcony', false, 1, false);
INSERT INTO public.estimates_items (id, name, qtd, unique_amount, estimate_id, description, hidden, ordem, material) VALUES (24, 'Flat Line (clips)', 92, 0.200000000000000, 11, '', false, 3, false);
INSERT INTO public.estimates_items (id, name, qtd, unique_amount, estimate_id, description, hidden, ordem, material) VALUES (42, 'Labor to install floor tile (Diagonal)', 92, 10.000000000000000, 11, 'Apartment balcony', false, 2, false);
INSERT INTO public.estimates_items (id, name, qtd, unique_amount, estimate_id, description, hidden, ordem, material) VALUES (43, 'TIJOLO', 1, 300.000000000000000, 11, 'Thin set, grout, caulk, Schluter and waterproofing', false, 5, true);
INSERT INTO public.estimates_items (id, name, qtd, unique_amount, estimate_id, description, hidden, ordem, material) VALUES (75, 'Material', 100, 2.000000000000000, 11, 'Teste', false, 4, true);
INSERT INTO public.estimates_items (id, name, qtd, unique_amount, estimate_id, description, hidden, ordem, material) VALUES (76, 'CIMENTO', 20, 100.000000000000000, 11, '', false, 6, true);
INSERT INTO public.estimates_items (id, name, qtd, unique_amount, estimate_id, description, hidden, ordem, material) VALUES (25, 'remover piso', 3, 11.666666666666666, 13, 'asdfasdfsdfsdf', false, 0, NULL);
INSERT INTO public.estimates_items (id, name, qtd, unique_amount, estimate_id, description, hidden, ordem, material) VALUES (27, 'Instalar Piso', 6, 90.333333333333330, 13, 'adsfasfdasdf', true, 1, NULL);
INSERT INTO public.estimates_items (id, name, qtd, unique_amount, estimate_id, description, hidden, ordem, material) VALUES (29, 'Labor to install floor tile (tile 8x48)', 30, 200.000000000000000, 13, 'Living room, hall, master bedroom and Closets', false, 5, NULL);
INSERT INTO public.estimates_items (id, name, qtd, unique_amount, estimate_id, description, hidden, ordem, material) VALUES (36, 'asd', 2, 1.000000000000000, 13, 'asd', false, 2, NULL);
INSERT INTO public.estimates_items (id, name, qtd, unique_amount, estimate_id, description, hidden, ordem, material) VALUES (37, 'asd', 2, 4.000000000000000, 13, 'asd', false, 3, NULL);
INSERT INTO public.estimates_items (id, name, qtd, unique_amount, estimate_id, description, hidden, ordem, material) VALUES (38, 'saaaa', 23, 12.000000000000000, 13, 'dsadas', false, 4, NULL);
INSERT INTO public.estimates_items (id, name, qtd, unique_amount, estimate_id, description, hidden, ordem, material) VALUES (71, 'Flat Line (clips)', 12, 22.000000000000000, 32, '', false, 0, NULL);
INSERT INTO public.estimates_items (id, name, qtd, unique_amount, estimate_id, description, hidden, ordem, material) VALUES (45, 'Flat Line (clips)', 1, 10.000000000000000, 22, 'teste', false, 0, NULL);
INSERT INTO public.estimates_items (id, name, qtd, unique_amount, estimate_id, description, hidden, ordem, material) VALUES (46, 'Instalar Piso', 3, 20.000000000000000, 22, 'asd', false, 1, NULL);
INSERT INTO public.estimates_items (id, name, qtd, unique_amount, estimate_id, description, hidden, ordem, material) VALUES (72, 'Labor to remove floor tile ', 12, 1.000000000000000, 31, 'asdf', false, 5, false);
INSERT INTO public.estimates_items (id, name, qtd, unique_amount, estimate_id, description, hidden, ordem, material) VALUES (73, ' Labor to remove floor tile', 3, 5.000000000000000, 31, 'asd', false, 6, false);
INSERT INTO public.estimates_items (id, name, qtd, unique_amount, estimate_id, description, hidden, ordem, material) VALUES (74, 'LABOR TO REMOVE FLOOR TILE', 3, 45.000000000000000, 31, 'asfd', false, 7, false);
INSERT INTO public.estimates_items (id, name, qtd, unique_amount, estimate_id, description, hidden, ordem, material) VALUES (84, 'install', 10, 100.000000000000000, 34, 'teste', false, 0, false);
INSERT INTO public.estimates_items (id, name, qtd, unique_amount, estimate_id, description, hidden, ordem, material) VALUES (85, 'material', 20, 200.000000000000000, 34, 'teste', false, 1, true);
INSERT INTO public.estimates_items (id, name, qtd, unique_amount, estimate_id, description, hidden, ordem, material) VALUES (86, 'install', 10, 100.000000000000000, 35, 'teste', false, 0, false);
INSERT INTO public.estimates_items (id, name, qtd, unique_amount, estimate_id, description, hidden, ordem, material) VALUES (87, 'material', 20, 200.000000000000000, 35, 'teste', false, 1, false);


--
-- TOC entry 4605 (class 0 OID 18552)
-- Dependencies: 225
-- Data for Name: expenses; Type: TABLE DATA; Schema: public; Owner: developer
--

INSERT INTO public.expenses (id, jobs_id, subcontractors_id, date, store, amount) VALUES (4, 32, 1, '2024-01-01', 'loja 1', 356.00);


--
-- TOC entry 4607 (class 0 OID 18570)
-- Dependencies: 227
-- Data for Name: external_payments; Type: TABLE DATA; Schema: public; Owner: developer
--

INSERT INTO public.external_payments (id, external_subcontractor_id, date, builder_name, amount, percentage, profit) VALUES (1, 1, '2024-01-09', 'Jhon', 10000.00, 25, 2500.00);


--
-- TOC entry 4595 (class 0 OID 18504)
-- Dependencies: 215
-- Data for Name: external_subcontractors; Type: TABLE DATA; Schema: public; Owner: developer
--

INSERT INTO public.external_subcontractors (id, name, bank, account) VALUES (1, 'jose', 'bb', '1234');


--
-- TOC entry 4628 (class 0 OID 18856)
-- Dependencies: 248
-- Data for Name: feedbacks; Type: TABLE DATA; Schema: public; Owner: developer
--

INSERT INTO public.feedbacks (id, client_name, text) VALUES (1, NULL, NULL);
INSERT INTO public.feedbacks (id, client_name, text) VALUES (2, NULL, NULL);
INSERT INTO public.feedbacks (id, client_name, text) VALUES (3, NULL, NULL);
INSERT INTO public.feedbacks (id, client_name, text) VALUES (4, NULL, NULL);
INSERT INTO public.feedbacks (id, client_name, text) VALUES (5, NULL, NULL);
INSERT INTO public.feedbacks (id, client_name, text) VALUES (6, NULL, NULL);
INSERT INTO public.feedbacks (id, client_name, text) VALUES (7, NULL, NULL);
INSERT INTO public.feedbacks (id, client_name, text) VALUES (8, NULL, NULL);
INSERT INTO public.feedbacks (id, client_name, text) VALUES (10, NULL, NULL);
INSERT INTO public.feedbacks (id, client_name, text) VALUES (11, NULL, NULL);
INSERT INTO public.feedbacks (id, client_name, text) VALUES (12, NULL, NULL);
INSERT INTO public.feedbacks (id, client_name, text) VALUES (13, NULL, NULL);
INSERT INTO public.feedbacks (id, client_name, text) VALUES (20, 'Luciana', 'As a real estate investor I have worked with a lot of contractors and I can tell you the good ones are hard to come by. This was my first time working with Geraldo and I can say he was very professional and fairly priced. I will definitely be using him again in the future.');
INSERT INTO public.feedbacks (id, client_name, text) VALUES (17, 'Anderson', 'Tesde de feedback ');
INSERT INTO public.feedbacks (id, client_name, text) VALUES (16, 'Filipe', 'AS A REAL ESTATE INVESTOR I HAVE WORKED WITH A LOT OF CONTRACTORS AND I CAN TELL YOU THE GOOD ONES ARE HARD TO COME BY. THIS WAS MY FIRST TIME WORKING WITH GERALDO AND I CAN SAY HE WAS VERY PROFESSIONAL AND FAIRLY PRICED. I WILL DEFINITELY BE USING HIM AGAIN IN THE FUTURE.');
INSERT INTO public.feedbacks (id, client_name, text) VALUES (15, 'Filipe', 'AS A REAL ESTATE INVESTOR I HAVE WORKED WITH A LOT OF CONTRACTORS AND I CAN TELL YOU THE GOOD ONES ARE HARD TO COME BY. THIS WAS MY FIRST TIME WORKING WITH GERALDO AND I CAN SAY HE WAS VERY PROFESSIONAL AND FAIRLY PRICED. I WILL DEFINITELY BE USING HIM AGAIN IN THE FUTURE.aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa');
INSERT INTO public.feedbacks (id, client_name, text) VALUES (14, 'Geraldo', 'AS A REAL ESTATE INVESTOR I HAVE WORKED WITH A LOT OF CONTRACTORS AND I CAN TELL YOU THE GOOD ONES ARE HARD TO COME BY. THIS WAS MY FIRST TIME WORKING WITH GERALDO AND I CAN SAY HE WAS VERY PROFESSIONAL AND FAIRLY PRICED. I WILL DEFINITELY BE USING HIM AGAIN IN THE FUTURE.aaaaaaaaaaaaaaaaaaaaaaaaaaa');


--
-- TOC entry 4597 (class 0 OID 18512)
-- Dependencies: 217
-- Data for Name: jobs; Type: TABLE DATA; Schema: public; Owner: developer
--

INSERT INTO public.jobs (id, name, status, phone_number, amount, address_shipping, city_shipping, state_shipping, zipcode_shipping, address_billing, city_billing, state_billing, zipcode_billing, note, client_id, estimate_id, accepted_completion_certificate_date, accepted_home_improvement_date, final_payment, init_payment, partial_payment, material, labor, tax) VALUES (41, 'Novo', 1, NULL, 70.00, 'Rua Oswaldo De Freitas Nunes N 212, Casa', 'Pacajús', 'CE', '62870000', NULL, NULL, NULL, NULL, '', 1, 22, NULL, NULL, NULL, NULL, NULL, 0.00, 70.00, 0.00);
INSERT INTO public.jobs (id, name, status, phone_number, amount, address_shipping, city_shipping, state_shipping, zipcode_shipping, address_billing, city_billing, state_billing, zipcode_billing, note, client_id, estimate_id, accepted_completion_certificate_date, accepted_home_improvement_date, final_payment, init_payment, partial_payment, material, labor, tax) VALUES (34, 'Master bathroom and floor tile (whole apartment)', 1, NULL, 3622.40, 'Rua Oswaldo De Freitas Nunes N 212, Casa', 'Pacajús', 'CE', '62870000', NULL, NULL, NULL, NULL, '', 1, 33, NULL, NULL, 561.20, 3236.20, NULL, 2500.00, 1122.40, 175.00);
INSERT INTO public.jobs (id, name, status, phone_number, amount, address_shipping, city_shipping, state_shipping, zipcode_shipping, address_billing, city_billing, state_billing, zipcode_billing, note, client_id, estimate_id, accepted_completion_certificate_date, accepted_home_improvement_date, final_payment, init_payment, partial_payment, material, labor, tax) VALUES (36, 'teste 1 item', 1, NULL, 5000.00, 'Rua Oswaldo De Freitas Nunes N 212, Casa', 'Pacajús', 'CE', '62870000', NULL, NULL, NULL, NULL, '', 1, 35, NULL, NULL, 0.00, 1070.00, NULL, 1000.00, 0.00, 70.00);
INSERT INTO public.jobs (id, name, status, phone_number, amount, address_shipping, city_shipping, state_shipping, zipcode_shipping, address_billing, city_billing, state_billing, zipcode_billing, note, client_id, estimate_id, accepted_completion_certificate_date, accepted_home_improvement_date, final_payment, init_payment, partial_payment, material, labor, tax) VALUES (37, 'teste 1 item', 1, NULL, 5000.00, 'Rua Oswaldo De Freitas Nunes N 212, Casa', 'Pacajús', 'CE', '62870000', NULL, NULL, NULL, NULL, '', 1, 35, NULL, NULL, 500.00, 500.00, NULL, 0.00, 1000.00, 0.00);
INSERT INTO public.jobs (id, name, status, phone_number, amount, address_shipping, city_shipping, state_shipping, zipcode_shipping, address_billing, city_billing, state_billing, zipcode_billing, note, client_id, estimate_id, accepted_completion_certificate_date, accepted_home_improvement_date, final_payment, init_payment, partial_payment, material, labor, tax) VALUES (38, 'teste 1 item', 1, NULL, 5000.00, 'Rua Oswaldo De Freitas Nunes N 212, Casa', 'Pacajús', 'CE', '62870000', NULL, NULL, NULL, NULL, '', 1, 35, NULL, NULL, 500.00, 4780.00, NULL, 4000.00, 1000.00, 280.00);
INSERT INTO public.jobs (id, name, status, phone_number, amount, address_shipping, city_shipping, state_shipping, zipcode_shipping, address_billing, city_billing, state_billing, zipcode_billing, note, client_id, estimate_id, accepted_completion_certificate_date, accepted_home_improvement_date, final_payment, init_payment, partial_payment, material, labor, tax) VALUES (39, 'teste 1 item', 1, NULL, 5000.00, 'Rua Oswaldo De Freitas Nunes N 212, Casa', 'Pacajús', 'CE', '62870000', NULL, NULL, NULL, NULL, '', 1, 35, NULL, NULL, 500.00, 4500.00, NULL, 4000.00, 1000.00, 0.00);
INSERT INTO public.jobs (id, name, status, phone_number, amount, address_shipping, city_shipping, state_shipping, zipcode_shipping, address_billing, city_billing, state_billing, zipcode_billing, note, client_id, estimate_id, accepted_completion_certificate_date, accepted_home_improvement_date, final_payment, init_payment, partial_payment, material, labor, tax) VALUES (35, 'Master bathroom and floor tile (whole apartment) - Clone', 1, NULL, 3622.40, 'Rua Oswaldo De Freitas Nunes N 212, Casa', 'Pacajús', 'CE', '62870000', NULL, NULL, NULL, NULL, '', 1, 33, NULL, NULL, 561.20, 3236.20, NULL, 2500.00, 1122.40, 175.00);
INSERT INTO public.jobs (id, name, status, phone_number, amount, address_shipping, city_shipping, state_shipping, zipcode_shipping, address_billing, city_billing, state_billing, zipcode_billing, note, client_id, estimate_id, accepted_completion_certificate_date, accepted_home_improvement_date, final_payment, init_payment, partial_payment, material, labor, tax) VALUES (40, 'teste 1 item', 1, NULL, 5280.00, 'Rua Oswaldo De Freitas Nunes N 212, Casa', 'Pacajús', 'CE', '62870000', NULL, NULL, NULL, NULL, '', 1, 35, NULL, NULL, 500.00, 4780.00, NULL, 4000.00, 1000.00, 280.00);
INSERT INTO public.jobs (id, name, status, phone_number, amount, address_shipping, city_shipping, state_shipping, zipcode_shipping, address_billing, city_billing, state_billing, zipcode_billing, note, client_id, estimate_id, accepted_completion_certificate_date, accepted_home_improvement_date, final_payment, init_payment, partial_payment, material, labor, tax) VALUES (32, 'Master bathroom and floor tile (whole apartment)', 1, NULL, 1560.00, 'Rua Oswaldo De Freitas Nunes N 212, Casa', 'Pacajús', 'CE', '62870000', NULL, NULL, NULL, NULL, '', 1, 31, NULL, NULL, 1000.00, 60.00, 150.30, 900.00, 100.00, NULL);


--
-- TOC entry 4622 (class 0 OID 18753)
-- Dependencies: 242
-- Data for Name: jobs_files; Type: TABLE DATA; Schema: public; Owner: developer
--



--
-- TOC entry 4640 (class 0 OID 19093)
-- Dependencies: 260
-- Data for Name: licences; Type: TABLE DATA; Schema: public; Owner: developer
--

INSERT INTO public.licences (id, file, name) VALUES (8, '2020-12-29-15-05-09-Gala_Tile_Licenses.pdf', 'Gala-Tile-Licenses.pdf');


--
-- TOC entry 4646 (class 0 OID 19842)
-- Dependencies: 266
-- Data for Name: login_request; Type: TABLE DATA; Schema: public; Owner: developer
--

INSERT INTO public.login_request (id, hash, code, used, user_id) VALUES (1, 'cab088a2f6b911ee89f2047f0e495bdc', 'BXLRXW', false, NULL);
INSERT INTO public.login_request (id, hash, code, used, user_id) VALUES (2, '423204c2f6bb11ee8faf047f0e495bdc', 'OUHVCV', true, NULL);
INSERT INTO public.login_request (id, hash, code, used, user_id) VALUES (3, '92e56b4cf6bf11eeb919047f0e495bdc', 'MBEKBH', true, NULL);
INSERT INTO public.login_request (id, hash, code, used, user_id) VALUES (4, '071598d8f6c011eea89c047f0e495bdc', 'GXTCTK', true, NULL);
INSERT INTO public.login_request (id, hash, code, used, user_id) VALUES (5, 'd96bb708f6c011ee9c1e047f0e495bdc', 'KFQRMU', true, NULL);
INSERT INTO public.login_request (id, hash, code, used, user_id) VALUES (6, 'f62129b6f6c511eeb5ee047f0e495bdc', 'MUSTNM', true, NULL);
INSERT INTO public.login_request (id, hash, code, used, user_id) VALUES (7, '64d56576f6c611eea855047f0e495bdc', 'OEPTWI', true, NULL);
INSERT INTO public.login_request (id, hash, code, used, user_id) VALUES (8, '177dba02f6c711eeb3a6047f0e495bdc', 'VBVSLI', true, NULL);
INSERT INTO public.login_request (id, hash, code, used, user_id) VALUES (9, '7d08d6caf6c711ee8f78047f0e495bdc', '8YVX62', true, NULL);
INSERT INTO public.login_request (id, hash, code, used, user_id) VALUES (10, '6ac4f308f73211ee97fb047f0e495bdc', 'WJA9X8', true, NULL);
INSERT INTO public.login_request (id, hash, code, used, user_id) VALUES (11, 'afe1299ef73f11ee808e047f0e495bdc', '259VYS', true, NULL);
INSERT INTO public.login_request (id, hash, code, used, user_id) VALUES (12, '22bfae80f75711ee9269047f0e495bdc', 'ON9E3A', true, NULL);
INSERT INTO public.login_request (id, hash, code, used, user_id) VALUES (13, 'c18b07ccf75e11eeb4f7047f0e495bdc', 'Y1N4I2', true, NULL);
INSERT INTO public.login_request (id, hash, code, used, user_id) VALUES (14, '62484b40f76111ee8e42047f0e495bdc', 'BY1DIB', true, NULL);
INSERT INTO public.login_request (id, hash, code, used, user_id) VALUES (15, 'ce32a0baf77111eebf81047f0e495bdc', 'KKAWKV', true, NULL);
INSERT INTO public.login_request (id, hash, code, used, user_id) VALUES (16, '91902e86f83e11eea08e047f0e495bdc', 'RCGVVK', true, NULL);
INSERT INTO public.login_request (id, hash, code, used, user_id) VALUES (17, 'd0eafb9cf8c711ee8f14047f0e495bdc', 'UDZDQ8', true, NULL);
INSERT INTO public.login_request (id, hash, code, used, user_id) VALUES (18, '7b436e1cf8ec11ee8f0c047f0e495bdc', '1GO23G', true, NULL);
INSERT INTO public.login_request (id, hash, code, used, user_id) VALUES (19, '81522dd2f90b11eeae3d047f0e495bdc', 'GWHUQH', true, NULL);
INSERT INTO public.login_request (id, hash, code, used, user_id) VALUES (20, '5748a1d8f96d11ee878a047f0e495bdc', '39VI2B', true, NULL);
INSERT INTO public.login_request (id, hash, code, used, user_id) VALUES (22, '3c3bf48cf99311ee9dab047f0e495bdc', '9F3060', false, NULL);
INSERT INTO public.login_request (id, hash, code, used, user_id) VALUES (21, '3b13e374f99311eea0bd047f0e495bdc', 'J2VXSZ', true, NULL);
INSERT INTO public.login_request (id, hash, code, used, user_id) VALUES (23, '5b202eb4faa711ee9211047f0e495bdc', '325VWL', true, NULL);
INSERT INTO public.login_request (id, hash, code, used, user_id) VALUES (24, '8f6774d8fb1a11eeb79d047f0e495bdc', 'GYGFB4', true, NULL);
INSERT INTO public.login_request (id, hash, code, used, user_id) VALUES (25, '3f97deccfc3811ee80ad047f0e495bdc', '75K4NK', true, NULL);
INSERT INTO public.login_request (id, hash, code, used, user_id) VALUES (26, 'c2c9b29efc3c11eeb465047f0e495bdc', 'ENBXWO', true, 1);


--
-- TOC entry 4642 (class 0 OID 19165)
-- Dependencies: 262
-- Data for Name: miscellaneous; Type: TABLE DATA; Schema: public; Owner: developer
--

INSERT INTO public.miscellaneous (id, description, amount, date, jobs_id) VALUES (1, 'Acrecimo no Projeto', 100.00, '2021-03-24', 32);
INSERT INTO public.miscellaneous (id, description, amount, date, jobs_id) VALUES (2, 'Refund de material', -50.00, '2021-03-24', 32);


--
-- TOC entry 4609 (class 0 OID 18583)
-- Dependencies: 229
-- Data for Name: payments; Type: TABLE DATA; Schema: public; Owner: developer
--

INSERT INTO public.payments (id, description, amount, date, jobs_id) VALUES (10, 'Down Payment', 699.00, '2021-03-19', 32);


--
-- TOC entry 4626 (class 0 OID 18813)
-- Dependencies: 246
-- Data for Name: project_photos; Type: TABLE DATA; Schema: public; Owner: developer
--

INSERT INTO public.project_photos (id, project_id, photo) VALUES (8, 5, '2020-10-20-08-10-07-120892236_2781181585481085_8768580502236380797_n.jpg');
INSERT INTO public.project_photos (id, project_id, photo) VALUES (9, 5, '2020-10-20-08-10-08-121014093_2781181578814419_3805301602140278797_n.jpg');
INSERT INTO public.project_photos (id, project_id, photo) VALUES (10, 5, '2020-10-20-08-10-08-120997040_2781181582147752_2684403684761343910_n.jpg');
INSERT INTO public.project_photos (id, project_id, photo) VALUES (11, 6, '2020-10-20-08-10-32-120892236_2781181585481085_8768580502236380797_n.jpg');
INSERT INTO public.project_photos (id, project_id, photo) VALUES (12, 6, '2020-10-20-08-10-33-121014093_2781181578814419_3805301602140278797_n.jpg');
INSERT INTO public.project_photos (id, project_id, photo) VALUES (13, 6, '2020-10-20-08-10-34-120997040_2781181582147752_2684403684761343910_n.jpg');
INSERT INTO public.project_photos (id, project_id, photo) VALUES (14, 7, '2020-10-20-08-10-55-120892236_2781181585481085_8768580502236380797_n.jpg');
INSERT INTO public.project_photos (id, project_id, photo) VALUES (15, 7, '2020-10-20-08-10-56-121014093_2781181578814419_3805301602140278797_n.jpg');
INSERT INTO public.project_photos (id, project_id, photo) VALUES (16, 7, '2020-10-20-08-10-56-120997040_2781181582147752_2684403684761343910_n.jpg');
INSERT INTO public.project_photos (id, project_id, photo) VALUES (17, 8, '2020-10-20-08-11-24-120892236_2781181585481085_8768580502236380797_n.jpg');
INSERT INTO public.project_photos (id, project_id, photo) VALUES (18, 8, '2020-10-20-08-11-25-121014093_2781181578814419_3805301602140278797_n.jpg');
INSERT INTO public.project_photos (id, project_id, photo) VALUES (19, 8, '2020-10-20-08-11-25-120997040_2781181582147752_2684403684761343910_n.jpg');
INSERT INTO public.project_photos (id, project_id, photo) VALUES (20, 6, '2020-10-20-08-17-24-');
INSERT INTO public.project_photos (id, project_id, photo) VALUES (21, 9, '2020-10-20-10-14-44-120892236_2781181585481085_8768580502236380797_n.jpg');
INSERT INTO public.project_photos (id, project_id, photo) VALUES (22, 9, '2020-10-20-10-14-45-121014093_2781181578814419_3805301602140278797_n.jpg');
INSERT INTO public.project_photos (id, project_id, photo) VALUES (23, 9, '2020-10-20-10-14-45-120997040_2781181582147752_2684403684761343910_n.jpg');
INSERT INTO public.project_photos (id, project_id, photo) VALUES (24, 10, '2020-10-20-10-15-05-120892236_2781181585481085_8768580502236380797_n.jpg');
INSERT INTO public.project_photos (id, project_id, photo) VALUES (25, 10, '2020-10-20-10-15-06-121014093_2781181578814419_3805301602140278797_n.jpg');
INSERT INTO public.project_photos (id, project_id, photo) VALUES (26, 10, '2020-10-20-10-15-06-120997040_2781181582147752_2684403684761343910_n.jpg');
INSERT INTO public.project_photos (id, project_id, photo) VALUES (27, 11, '2020-10-20-10-15-29-120892236_2781181585481085_8768580502236380797_n.jpg');
INSERT INTO public.project_photos (id, project_id, photo) VALUES (28, 11, '2020-10-20-10-15-29-121014093_2781181578814419_3805301602140278797_n.jpg');
INSERT INTO public.project_photos (id, project_id, photo) VALUES (29, 11, '2020-10-20-10-15-30-120997040_2781181582147752_2684403684761343910_n.jpg');
INSERT INTO public.project_photos (id, project_id, photo) VALUES (30, 12, '2020-10-20-10-15-57-120892236_2781181585481085_8768580502236380797_n.jpg');
INSERT INTO public.project_photos (id, project_id, photo) VALUES (31, 12, '2020-10-20-10-15-58-121014093_2781181578814419_3805301602140278797_n.jpg');
INSERT INTO public.project_photos (id, project_id, photo) VALUES (32, 12, '2020-10-20-10-15-59-120997040_2781181582147752_2684403684761343910_n.jpg');
INSERT INTO public.project_photos (id, project_id, photo) VALUES (33, 13, '2020-12-08-10-47-56-4dae12fb-4b02-4c1f-ae15-82a4f6baec68.jpg');
INSERT INTO public.project_photos (id, project_id, photo) VALUES (35, 14, '2020-12-08-11-02-42-2020-10-20-17-00-04-bk1.jpg');


--
-- TOC entry 4624 (class 0 OID 18786)
-- Dependencies: 244
-- Data for Name: projects; Type: TABLE DATA; Schema: public; Owner: developer
--

INSERT INTO public.projects (id, name, text, year, category, location) VALUES (5, 'reforma do quarto', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum', 2020, 2, 'Brazil');
INSERT INTO public.projects (id, name, text, year, category, location) VALUES (7, 'Telhado', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum', 2020, 4, 'Miami');
INSERT INTO public.projects (id, name, text, year, category, location) VALUES (8, 'teste', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum', 2002, 5, 'Miami');
INSERT INTO public.projects (id, name, text, year, category, location) VALUES (6, 'Piso Novo', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum', 2002, 3, 'Brazil');
INSERT INTO public.projects (id, name, text, year, category, location) VALUES (13, 'Floor', ' ', 2020, 1, 'Miami');
INSERT INTO public.projects (id, name, text, year, category, location) VALUES (9, 'Novo ap', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.', 2020, 5, 'Miami');
INSERT INTO public.projects (id, name, text, year, category, location) VALUES (10, 'Casa de Praia', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.', 2002, 3, 'Brazil');
INSERT INTO public.projects (id, name, text, year, category, location) VALUES (11, 'Sitio', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.', 2020, 2, 'Miami');
INSERT INTO public.projects (id, name, text, year, category, location) VALUES (12, 'Piso Novo', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.', 2020, 2, 'Miami');
INSERT INTO public.projects (id, name, text, year, category, location) VALUES (14, 'New', '', 2020, 5, 'Miami');


--
-- TOC entry 4638 (class 0 OID 19036)
-- Dependencies: 258
-- Data for Name: remember_password; Type: TABLE DATA; Schema: public; Owner: developer
--

INSERT INTO public.remember_password (id, code, forgoted, client_id, redirect) VALUES (2, '45af204a359211eb86da1cbfce75904f', true, 1, NULL);
INSERT INTO public.remember_password (id, code, forgoted, client_id, redirect) VALUES (1, '290d2774359211eb96841cbfce75904f', true, 1, NULL);
INSERT INTO public.remember_password (id, code, forgoted, client_id, redirect) VALUES (3, '59de8f46359b11ebbead1cbfce75904f', true, 1, NULL);
INSERT INTO public.remember_password (id, code, forgoted, client_id, redirect) VALUES (4, 'bf64510c359b11eba4e61cbfce75904f', false, 1, NULL);
INSERT INTO public.remember_password (id, code, forgoted, client_id, redirect) VALUES (5, 'd69fab7435a111eb95791cbfce75904f', true, 1, NULL);
INSERT INTO public.remember_password (id, code, forgoted, client_id, redirect) VALUES (6, '676729425a5f11eb9fd7408d5cc2e8e1', true, 1, NULL);
INSERT INTO public.remember_password (id, code, forgoted, client_id, redirect) VALUES (7, 'b7da3ae65a6411eb92fc408d5cc2e8e1', true, 1, 'page.my_dashboard');
INSERT INTO public.remember_password (id, code, forgoted, client_id, redirect) VALUES (8, '427057805a7511eba4de408d5cc2e8e1', true, 1, '/my-dashboard/estimate/21/');
INSERT INTO public.remember_password (id, code, forgoted, client_id, redirect) VALUES (9, '309f8f125a7711ebb6a5408d5cc2e8e1', true, 1, '/my-dashboard/estimate/11/');
INSERT INTO public.remember_password (id, code, forgoted, client_id, redirect) VALUES (10, '6701655a5a7c11ebb681408d5cc2e8e1', false, 1, NULL);
INSERT INTO public.remember_password (id, code, forgoted, client_id, redirect) VALUES (11, '841ef6ac987111eb960c408d5cc2e8e1', false, 16, '/my-dashboard/estimate/32/');
INSERT INTO public.remember_password (id, code, forgoted, client_id, redirect) VALUES (12, 'ffe54986f73e11eeb7da047f0e495bdc', true, 1, NULL);


--
-- TOC entry 4599 (class 0 OID 18523)
-- Dependencies: 219
-- Data for Name: settings; Type: TABLE DATA; Schema: public; Owner: developer
--

INSERT INTO public.settings (id, ip_address) VALUES (1, '127.0.0.1');


--
-- TOC entry 4632 (class 0 OID 18908)
-- Dependencies: 252
-- Data for Name: shop_lists; Type: TABLE DATA; Schema: public; Owner: developer
--

INSERT INTO public.shop_lists (id, date, note, client_id, estimate_id) VALUES (7, '2020-11-20', 'Teste de nota', 16, NULL);
INSERT INTO public.shop_lists (id, date, note, client_id, estimate_id) VALUES (10, '2020-11-20', '', 12, 13);
INSERT INTO public.shop_lists (id, date, note, client_id, estimate_id) VALUES (8, '2020-11-06', '<p></p>', 1, 11);
INSERT INTO public.shop_lists (id, date, note, client_id, estimate_id) VALUES (12, '2021-08-06', '11
2
3
4', 1, 22);


--
-- TOC entry 4634 (class 0 OID 18924)
-- Dependencies: 254
-- Data for Name: shop_lists_items; Type: TABLE DATA; Schema: public; Owner: developer
--

INSERT INTO public.shop_lists_items (id, material, qtd, shop_list_id, ordem) VALUES (3, 'asd', 'asdasd', 7, 0);
INSERT INTO public.shop_lists_items (id, material, qtd, shop_list_id, ordem) VALUES (4, 'asd', 'asd', 7, 2);
INSERT INTO public.shop_lists_items (id, material, qtd, shop_list_id, ordem) VALUES (5, 'asdasdasdas', 'asdasd', 7, 3);
INSERT INTO public.shop_lists_items (id, material, qtd, shop_list_id, ordem) VALUES (6, 'ultimo', 'asdasd', 7, 1);
INSERT INTO public.shop_lists_items (id, material, qtd, shop_list_id, ordem) VALUES (9, 'Teste', '1', 10, 0);
INSERT INTO public.shop_lists_items (id, material, qtd, shop_list_id, ordem) VALUES (7, 'Floor Tile', '100 sq ft', 8, 0);
INSERT INTO public.shop_lists_items (id, material, qtd, shop_list_id, ordem) VALUES (11, 'Teste', '1', 12, 0);


--
-- TOC entry 4636 (class 0 OID 19001)
-- Dependencies: 256
-- Data for Name: subcontractor_miscellaneous; Type: TABLE DATA; Schema: public; Owner: developer
--

INSERT INTO public.subcontractor_miscellaneous (id, date, name, description, amount, subcontractors_id) VALUES (1, '2020-11-13', 'Acrecimo', '', 100.00, 1);
INSERT INTO public.subcontractor_miscellaneous (id, date, name, description, amount, subcontractors_id) VALUES (2, '2020-11-10', 'Desconto', 'descriçaoo', -40.00, 1);


--
-- TOC entry 4611 (class 0 OID 18599)
-- Dependencies: 231
-- Data for Name: subcontractor_payment; Type: TABLE DATA; Schema: public; Owner: developer
--

INSERT INTO public.subcontractor_payment (id, jobs_id, subcontractors_id, date, status, description) VALUES (4, 32, 1, '2024-01-09', 2, '123');
INSERT INTO public.subcontractor_payment (id, jobs_id, subcontractors_id, date, status, description) VALUES (5, 34, 1, '2024-05-10', 1, 'teste de status de pagamento');
INSERT INTO public.subcontractor_payment (id, jobs_id, subcontractors_id, date, status, description) VALUES (6, 34, 1, '2024-05-11', 2, 'teste de pagamento');
INSERT INTO public.subcontractor_payment (id, jobs_id, subcontractors_id, date, status, description) VALUES (7, 41, 1, '2024-06-07', 1, 'teste');


--
-- TOC entry 4613 (class 0 OID 18620)
-- Dependencies: 233
-- Data for Name: subcontractor_payment_items; Type: TABLE DATA; Schema: public; Owner: developer
--

INSERT INTO public.subcontractor_payment_items (id, activity, date, amount, subcontractors_payment_id) VALUES (7, 'install', '2024-01-02', 123.00, 4);
INSERT INTO public.subcontractor_payment_items (id, activity, date, amount, subcontractors_payment_id) VALUES (8, 'day 1', '2024-05-10', 120.00, 5);
INSERT INTO public.subcontractor_payment_items (id, activity, date, amount, subcontractors_payment_id) VALUES (9, 'day 2', '2024-05-11', 200.00, 6);
INSERT INTO public.subcontractor_payment_items (id, activity, date, amount, subcontractors_payment_id) VALUES (10, 'teste', '2024-06-12', 50.00, 7);


--
-- TOC entry 4601 (class 0 OID 18531)
-- Dependencies: 221
-- Data for Name: subcontractors; Type: TABLE DATA; Schema: public; Owner: developer
--

INSERT INTO public.subcontractors (id, name, description) VALUES (1, 'jhon', 'instaler');


--
-- TOC entry 4603 (class 0 OID 18542)
-- Dependencies: 223
-- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: developer
--

INSERT INTO public.users (id, name, email, password, user_level) VALUES (1, 'User', 'user@gmail.com', '$pbkdf2-sha256$29000$HKO09p6Tck5JaU3p3TuntA$nYSg3P6M0O9BJ1iEbBdBfJ2CfISqDyDL.q4KzMBRpHw', 1);
INSERT INTO public.users (id, name, email, password, user_level) VALUES (3, 'FILIPE N CARVALHO', 'filipekav@gmail.com', '$pbkdf2-sha256$29000$EgIAAEDIOYewVmotZWwNAQ$EyOuvp8fFhm3R/jiY9RozDYMjjwy6K/.fXF0Tss7Cbc', 0);
INSERT INTO public.users (id, name, email, password, user_level) VALUES (2, 'teste', 'teste@gmail.com', '$pbkdf2-sha256$29000$BkDovfe.l5KSstb6XytFKA$JBzCXuRtQYZPKo9RMxzBy404y83lOScVVQ/1NQgH69g', 0);


--
-- TOC entry 4683 (class 0 OID 0)
-- Dependencies: 235
-- Name: clients_id_seq; Type: SEQUENCE SET; Schema: public; Owner: developer
--

SELECT pg_catalog.setval('public.clients_id_seq', 16, true);


--
-- TOC entry 4684 (class 0 OID 0)
-- Dependencies: 249
-- Name: contacts_id_seq; Type: SEQUENCE SET; Schema: public; Owner: developer
--

SELECT pg_catalog.setval('public.contacts_id_seq', 7, true);


--
-- TOC entry 4685 (class 0 OID 0)
-- Dependencies: 267
-- Name: email_log_status_id_seq; Type: SEQUENCE SET; Schema: public; Owner: developer
--

SELECT pg_catalog.setval('public.email_log_status_id_seq', 19, true);


--
-- TOC entry 4686 (class 0 OID 0)
-- Dependencies: 263
-- Name: estimate_logs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: developer
--

SELECT pg_catalog.setval('public.estimate_logs_id_seq', 38, true);


--
-- TOC entry 4687 (class 0 OID 0)
-- Dependencies: 237
-- Name: estimates_id_seq; Type: SEQUENCE SET; Schema: public; Owner: developer
--

SELECT pg_catalog.setval('public.estimates_id_seq', 35, true);


--
-- TOC entry 4688 (class 0 OID 0)
-- Dependencies: 239
-- Name: estimates_items_id_seq; Type: SEQUENCE SET; Schema: public; Owner: developer
--

SELECT pg_catalog.setval('public.estimates_items_id_seq', 87, true);


--
-- TOC entry 4689 (class 0 OID 0)
-- Dependencies: 224
-- Name: expenses_id_seq; Type: SEQUENCE SET; Schema: public; Owner: developer
--

SELECT pg_catalog.setval('public.expenses_id_seq', 4, true);


--
-- TOC entry 4690 (class 0 OID 0)
-- Dependencies: 226
-- Name: external_payments_id_seq; Type: SEQUENCE SET; Schema: public; Owner: developer
--

SELECT pg_catalog.setval('public.external_payments_id_seq', 1, true);


--
-- TOC entry 4691 (class 0 OID 0)
-- Dependencies: 214
-- Name: external_subcontractors_id_seq; Type: SEQUENCE SET; Schema: public; Owner: developer
--

SELECT pg_catalog.setval('public.external_subcontractors_id_seq', 1, true);


--
-- TOC entry 4692 (class 0 OID 0)
-- Dependencies: 247
-- Name: feedbacks_id_seq; Type: SEQUENCE SET; Schema: public; Owner: developer
--

SELECT pg_catalog.setval('public.feedbacks_id_seq', 21, true);


--
-- TOC entry 4693 (class 0 OID 0)
-- Dependencies: 241
-- Name: jobs_files_id_seq; Type: SEQUENCE SET; Schema: public; Owner: developer
--

SELECT pg_catalog.setval('public.jobs_files_id_seq', 22, true);


--
-- TOC entry 4694 (class 0 OID 0)
-- Dependencies: 216
-- Name: jobs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: developer
--

SELECT pg_catalog.setval('public.jobs_id_seq', 41, true);


--
-- TOC entry 4695 (class 0 OID 0)
-- Dependencies: 259
-- Name: licences_id_seq; Type: SEQUENCE SET; Schema: public; Owner: developer
--

SELECT pg_catalog.setval('public.licences_id_seq', 9, true);


--
-- TOC entry 4696 (class 0 OID 0)
-- Dependencies: 265
-- Name: login_request_id_seq; Type: SEQUENCE SET; Schema: public; Owner: developer
--

SELECT pg_catalog.setval('public.login_request_id_seq', 26, true);


--
-- TOC entry 4697 (class 0 OID 0)
-- Dependencies: 261
-- Name: miscellaneous_id_seq; Type: SEQUENCE SET; Schema: public; Owner: developer
--

SELECT pg_catalog.setval('public.miscellaneous_id_seq', 5, true);


--
-- TOC entry 4698 (class 0 OID 0)
-- Dependencies: 228
-- Name: payments_id_seq; Type: SEQUENCE SET; Schema: public; Owner: developer
--

SELECT pg_catalog.setval('public.payments_id_seq', 10, true);


--
-- TOC entry 4699 (class 0 OID 0)
-- Dependencies: 245
-- Name: project_photos_id_seq; Type: SEQUENCE SET; Schema: public; Owner: developer
--

SELECT pg_catalog.setval('public.project_photos_id_seq', 35, true);


--
-- TOC entry 4700 (class 0 OID 0)
-- Dependencies: 243
-- Name: projects_id_seq; Type: SEQUENCE SET; Schema: public; Owner: developer
--

SELECT pg_catalog.setval('public.projects_id_seq', 14, true);


--
-- TOC entry 4701 (class 0 OID 0)
-- Dependencies: 257
-- Name: remember_password_id_seq; Type: SEQUENCE SET; Schema: public; Owner: developer
--

SELECT pg_catalog.setval('public.remember_password_id_seq', 12, true);


--
-- TOC entry 4702 (class 0 OID 0)
-- Dependencies: 218
-- Name: settings_id_seq; Type: SEQUENCE SET; Schema: public; Owner: developer
--

SELECT pg_catalog.setval('public.settings_id_seq', 1, true);


--
-- TOC entry 4703 (class 0 OID 0)
-- Dependencies: 251
-- Name: shop_lists_id_seq; Type: SEQUENCE SET; Schema: public; Owner: developer
--

SELECT pg_catalog.setval('public.shop_lists_id_seq', 12, true);


--
-- TOC entry 4704 (class 0 OID 0)
-- Dependencies: 253
-- Name: shop_lists_items_id_seq; Type: SEQUENCE SET; Schema: public; Owner: developer
--

SELECT pg_catalog.setval('public.shop_lists_items_id_seq', 11, true);


--
-- TOC entry 4705 (class 0 OID 0)
-- Dependencies: 255
-- Name: subcontractor_miscellaneous_id_seq; Type: SEQUENCE SET; Schema: public; Owner: developer
--

SELECT pg_catalog.setval('public.subcontractor_miscellaneous_id_seq', 5, true);


--
-- TOC entry 4706 (class 0 OID 0)
-- Dependencies: 230
-- Name: subcontractor_payment_id_seq; Type: SEQUENCE SET; Schema: public; Owner: developer
--

SELECT pg_catalog.setval('public.subcontractor_payment_id_seq', 7, true);


--
-- TOC entry 4707 (class 0 OID 0)
-- Dependencies: 232
-- Name: subcontractor_payment_items_id_seq; Type: SEQUENCE SET; Schema: public; Owner: developer
--

SELECT pg_catalog.setval('public.subcontractor_payment_items_id_seq', 10, true);


--
-- TOC entry 4708 (class 0 OID 0)
-- Dependencies: 220
-- Name: subcontractors_id_seq; Type: SEQUENCE SET; Schema: public; Owner: developer
--

SELECT pg_catalog.setval('public.subcontractors_id_seq', 1, true);


--
-- TOC entry 4709 (class 0 OID 0)
-- Dependencies: 222
-- Name: users_id_seq; Type: SEQUENCE SET; Schema: public; Owner: developer
--

SELECT pg_catalog.setval('public.users_id_seq', 12, true);


--
-- TOC entry 4390 (class 2606 OID 16434)
-- Name: alembic_version alembic_version_pkc; Type: CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.alembic_version
    ADD CONSTRAINT alembic_version_pkc PRIMARY KEY (version_num);


--
-- TOC entry 4392 (class 2606 OID 16435)
-- Name: clients clients_pkey; Type: CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.clients
    ADD CONSTRAINT clients_pkey PRIMARY KEY (id);


--
-- TOC entry 4408 (class 2606 OID 16436)
-- Name: contacts contacts_pkey; Type: CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.contacts
    ADD CONSTRAINT contacts_pkey PRIMARY KEY (id);


--
-- TOC entry 4430 (class 2606 OID 19900)
-- Name: email_log_status email_log_status_pkey; Type: CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.email_log_status
    ADD CONSTRAINT email_log_status_pkey PRIMARY KEY (id);


--
-- TOC entry 4424 (class 2606 OID 16437)
-- Name: estimate_logs estimate_logs_pkey; Type: CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.estimate_logs
    ADD CONSTRAINT estimate_logs_pkey PRIMARY KEY (id);


--
-- TOC entry 4394 (class 2606 OID 19856)
-- Name: estimates estimates_hash_key; Type: CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.estimates
    ADD CONSTRAINT estimates_hash_key UNIQUE (hash);


--
-- TOC entry 4398 (class 2606 OID 16438)
-- Name: estimates_items estimates_items_pkey; Type: CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.estimates_items
    ADD CONSTRAINT estimates_items_pkey PRIMARY KEY (id);


--
-- TOC entry 4396 (class 2606 OID 16439)
-- Name: estimates estimates_pkey; Type: CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.estimates
    ADD CONSTRAINT estimates_pkey PRIMARY KEY (id);


--
-- TOC entry 4380 (class 2606 OID 16440)
-- Name: expenses expenses_pkey; Type: CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.expenses
    ADD CONSTRAINT expenses_pkey PRIMARY KEY (id);


--
-- TOC entry 4382 (class 2606 OID 16441)
-- Name: external_payments external_payments_pkey; Type: CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.external_payments
    ADD CONSTRAINT external_payments_pkey PRIMARY KEY (id);


--
-- TOC entry 4368 (class 2606 OID 16442)
-- Name: external_subcontractors external_subcontractors_pkey; Type: CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.external_subcontractors
    ADD CONSTRAINT external_subcontractors_pkey PRIMARY KEY (id);


--
-- TOC entry 4406 (class 2606 OID 16443)
-- Name: feedbacks feedbacks_pkey; Type: CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.feedbacks
    ADD CONSTRAINT feedbacks_pkey PRIMARY KEY (id);


--
-- TOC entry 4400 (class 2606 OID 16444)
-- Name: jobs_files jobs_files_pkey; Type: CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.jobs_files
    ADD CONSTRAINT jobs_files_pkey PRIMARY KEY (id);


--
-- TOC entry 4370 (class 2606 OID 16445)
-- Name: jobs jobs_pkey; Type: CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.jobs
    ADD CONSTRAINT jobs_pkey PRIMARY KEY (id);


--
-- TOC entry 4420 (class 2606 OID 16446)
-- Name: licences licences_pkey; Type: CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.licences
    ADD CONSTRAINT licences_pkey PRIMARY KEY (id);


--
-- TOC entry 4426 (class 2606 OID 19849)
-- Name: login_request login_request_hash_key; Type: CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.login_request
    ADD CONSTRAINT login_request_hash_key UNIQUE (hash);


--
-- TOC entry 4428 (class 2606 OID 19847)
-- Name: login_request login_request_pkey; Type: CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.login_request
    ADD CONSTRAINT login_request_pkey PRIMARY KEY (id);


--
-- TOC entry 4422 (class 2606 OID 16447)
-- Name: miscellaneous miscellaneous_pkey; Type: CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.miscellaneous
    ADD CONSTRAINT miscellaneous_pkey PRIMARY KEY (id);


--
-- TOC entry 4384 (class 2606 OID 16448)
-- Name: payments payments_pkey; Type: CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.payments
    ADD CONSTRAINT payments_pkey PRIMARY KEY (id);


--
-- TOC entry 4404 (class 2606 OID 16449)
-- Name: project_photos project_photos_pkey; Type: CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.project_photos
    ADD CONSTRAINT project_photos_pkey PRIMARY KEY (id);


--
-- TOC entry 4402 (class 2606 OID 16450)
-- Name: projects projects_pkey; Type: CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.projects
    ADD CONSTRAINT projects_pkey PRIMARY KEY (id);


--
-- TOC entry 4416 (class 2606 OID 16451)
-- Name: remember_password remember_password_code_key; Type: CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.remember_password
    ADD CONSTRAINT remember_password_code_key UNIQUE (code);


--
-- TOC entry 4418 (class 2606 OID 16452)
-- Name: remember_password remember_password_pkey; Type: CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.remember_password
    ADD CONSTRAINT remember_password_pkey PRIMARY KEY (id);


--
-- TOC entry 4372 (class 2606 OID 16453)
-- Name: settings settings_pkey; Type: CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.settings
    ADD CONSTRAINT settings_pkey PRIMARY KEY (id);


--
-- TOC entry 4412 (class 2606 OID 16454)
-- Name: shop_lists_items shop_lists_items_pkey; Type: CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.shop_lists_items
    ADD CONSTRAINT shop_lists_items_pkey PRIMARY KEY (id);


--
-- TOC entry 4410 (class 2606 OID 16455)
-- Name: shop_lists shop_lists_pkey; Type: CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.shop_lists
    ADD CONSTRAINT shop_lists_pkey PRIMARY KEY (id);


--
-- TOC entry 4414 (class 2606 OID 16456)
-- Name: subcontractor_miscellaneous subcontractor_miscellaneous_pkey; Type: CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.subcontractor_miscellaneous
    ADD CONSTRAINT subcontractor_miscellaneous_pkey PRIMARY KEY (id);


--
-- TOC entry 4388 (class 2606 OID 16457)
-- Name: subcontractor_payment_items subcontractor_payment_items_pkey; Type: CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.subcontractor_payment_items
    ADD CONSTRAINT subcontractor_payment_items_pkey PRIMARY KEY (id);


--
-- TOC entry 4386 (class 2606 OID 16458)
-- Name: subcontractor_payment subcontractor_payment_pkey; Type: CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.subcontractor_payment
    ADD CONSTRAINT subcontractor_payment_pkey PRIMARY KEY (id);


--
-- TOC entry 4374 (class 2606 OID 16459)
-- Name: subcontractors subcontractors_pkey; Type: CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.subcontractors
    ADD CONSTRAINT subcontractors_pkey PRIMARY KEY (id);


--
-- TOC entry 4376 (class 2606 OID 16460)
-- Name: users users_email_key; Type: CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.users
    ADD CONSTRAINT users_email_key UNIQUE (email);


--
-- TOC entry 4378 (class 2606 OID 16461)
-- Name: users users_pkey; Type: CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.users
    ADD CONSTRAINT users_pkey PRIMARY KEY (id);


--
-- TOC entry 4450 (class 2606 OID 16462)
-- Name: estimate_logs estimate_logs_estimate_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.estimate_logs
    ADD CONSTRAINT estimate_logs_estimate_id_fkey FOREIGN KEY (estimate_id) REFERENCES public.estimates(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- TOC entry 4440 (class 2606 OID 16467)
-- Name: estimates estimates_client_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.estimates
    ADD CONSTRAINT estimates_client_id_fkey FOREIGN KEY (client_id) REFERENCES public.clients(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- TOC entry 4441 (class 2606 OID 16472)
-- Name: estimates_items estimates_items_estimate_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.estimates_items
    ADD CONSTRAINT estimates_items_estimate_id_fkey FOREIGN KEY (estimate_id) REFERENCES public.estimates(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- TOC entry 4433 (class 2606 OID 16477)
-- Name: expenses expenses_jobs_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.expenses
    ADD CONSTRAINT expenses_jobs_id_fkey FOREIGN KEY (jobs_id) REFERENCES public.jobs(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- TOC entry 4434 (class 2606 OID 16482)
-- Name: expenses expenses_subcontractors_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.expenses
    ADD CONSTRAINT expenses_subcontractors_id_fkey FOREIGN KEY (subcontractors_id) REFERENCES public.subcontractors(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- TOC entry 4435 (class 2606 OID 16487)
-- Name: external_payments external_payments_external_subcontractor_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.external_payments
    ADD CONSTRAINT external_payments_external_subcontractor_id_fkey FOREIGN KEY (external_subcontractor_id) REFERENCES public.external_subcontractors(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- TOC entry 4431 (class 2606 OID 16492)
-- Name: jobs jobs_client_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.jobs
    ADD CONSTRAINT jobs_client_id_fkey FOREIGN KEY (client_id) REFERENCES public.clients(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- TOC entry 4432 (class 2606 OID 16497)
-- Name: jobs jobs_estimate_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.jobs
    ADD CONSTRAINT jobs_estimate_id_fkey FOREIGN KEY (estimate_id) REFERENCES public.estimates(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- TOC entry 4442 (class 2606 OID 16502)
-- Name: jobs_files jobs_files_jobs_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.jobs_files
    ADD CONSTRAINT jobs_files_jobs_id_fkey FOREIGN KEY (jobs_id) REFERENCES public.jobs(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- TOC entry 4451 (class 2606 OID 19876)
-- Name: login_request login_request_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.login_request
    ADD CONSTRAINT login_request_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- TOC entry 4449 (class 2606 OID 16507)
-- Name: miscellaneous miscellaneous_jobs_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.miscellaneous
    ADD CONSTRAINT miscellaneous_jobs_id_fkey FOREIGN KEY (jobs_id) REFERENCES public.jobs(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- TOC entry 4436 (class 2606 OID 16512)
-- Name: payments payments_jobs_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.payments
    ADD CONSTRAINT payments_jobs_id_fkey FOREIGN KEY (jobs_id) REFERENCES public.jobs(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- TOC entry 4443 (class 2606 OID 16517)
-- Name: project_photos project_photos_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.project_photos
    ADD CONSTRAINT project_photos_project_id_fkey FOREIGN KEY (project_id) REFERENCES public.projects(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- TOC entry 4448 (class 2606 OID 16522)
-- Name: remember_password remember_password_client_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.remember_password
    ADD CONSTRAINT remember_password_client_id_fkey FOREIGN KEY (client_id) REFERENCES public.clients(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- TOC entry 4444 (class 2606 OID 16527)
-- Name: shop_lists shop_lists_client_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.shop_lists
    ADD CONSTRAINT shop_lists_client_id_fkey FOREIGN KEY (client_id) REFERENCES public.clients(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- TOC entry 4445 (class 2606 OID 16532)
-- Name: shop_lists shop_lists_estimate_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.shop_lists
    ADD CONSTRAINT shop_lists_estimate_id_fkey FOREIGN KEY (estimate_id) REFERENCES public.estimates(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- TOC entry 4446 (class 2606 OID 16537)
-- Name: shop_lists_items shop_lists_items_shop_list_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.shop_lists_items
    ADD CONSTRAINT shop_lists_items_shop_list_id_fkey FOREIGN KEY (shop_list_id) REFERENCES public.shop_lists(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- TOC entry 4447 (class 2606 OID 16542)
-- Name: subcontractor_miscellaneous subcontractor_miscellaneous_subcontractors_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.subcontractor_miscellaneous
    ADD CONSTRAINT subcontractor_miscellaneous_subcontractors_id_fkey FOREIGN KEY (subcontractors_id) REFERENCES public.subcontractors(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- TOC entry 4439 (class 2606 OID 16547)
-- Name: subcontractor_payment_items subcontractor_payment_items_subcontractors_payment_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.subcontractor_payment_items
    ADD CONSTRAINT subcontractor_payment_items_subcontractors_payment_id_fkey FOREIGN KEY (subcontractors_payment_id) REFERENCES public.subcontractor_payment(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- TOC entry 4437 (class 2606 OID 16552)
-- Name: subcontractor_payment subcontractor_payment_jobs_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.subcontractor_payment
    ADD CONSTRAINT subcontractor_payment_jobs_id_fkey FOREIGN KEY (jobs_id) REFERENCES public.jobs(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- TOC entry 4438 (class 2606 OID 16557)
-- Name: subcontractor_payment subcontractor_payment_subcontractors_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: developer
--

ALTER TABLE ONLY public.subcontractor_payment
    ADD CONSTRAINT subcontractor_payment_subcontractors_id_fkey FOREIGN KEY (subcontractors_id) REFERENCES public.subcontractors(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- TOC entry 4655 (class 0 OID 0)
-- Dependencies: 5
-- Name: SCHEMA public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE USAGE ON SCHEMA public FROM PUBLIC;
GRANT ALL ON SCHEMA public TO PUBLIC;


-- Completed on 2024-06-02 14:02:32

--
--

