
SET transaction_timeout = 0;

--
-- Name: deliverychannel; Type: TYPE; Schema: public; Owner: rateright_au
--

CREATE TYPE public.deliverychannel AS ENUM (
    'EMAIL',
    'SMS',
    'PUSH_WEB',
    'PUSH_MOBILE',
    'IN_APP'
);


ALTER TYPE public.deliverychannel OWNER TO rateright_au;

--
-- Name: filecategory; Type: TYPE; Schema: public; Owner: rateright_au
--

CREATE TYPE public.filecategory AS ENUM (
    'PROFILE_PICTURE',
    'MESSAGE_ATTACHMENT',
    'CONTRACT_DOCUMENT',
    'JOB_PHOTO',
    'CERTIFICATION',
    'INVOICE',
    'INSURANCE_DOCUMENT',
    'OTHER'
);


ALTER TYPE public.filecategory OWNER TO rateright_au;

--
-- Name: messagestatus; Type: TYPE; Schema: public; Owner: rateright_au
--

CREATE TYPE public.messagestatus AS ENUM (
    'SENT',
    'DELIVERED',
    'READ'
);


ALTER TYPE public.messagestatus OWNER TO rateright_au;

--
-- Name: notificationfrequency; Type: TYPE; Schema: public; Owner: rateright_au
--

CREATE TYPE public.notificationfrequency AS ENUM (
    'IMMEDIATE',
    'DAILY_DIGEST',
    'WEEKLY_SUMMARY',
    'DISABLED'
);


ALTER TYPE public.notificationfrequency OWNER TO rateright_au;

--
-- Name: notificationstatus; Type: TYPE; Schema: public; Owner: rateright_au
--

CREATE TYPE public.notificationstatus AS ENUM (
    'PENDING',
    'SENT',
    'DELIVERED',
    'FAILED',
    'READ'
);


ALTER TYPE public.notificationstatus OWNER TO rateright_au;

--
-- Name: notificationtype; Type: TYPE; Schema: public; Owner: rateright_au
--

CREATE TYPE public.notificationtype AS ENUM (
    'JOB_MATCH',
    'JOB_APPLICATION_UPDATE',
    'CONTRACT_AWARDED',
    'PAYMENT_RECEIVED',
    'PAYMENT_DUE',
    'INVOICE_GENERATED',
    'RATING_RECEIVED',
    'REVIEW_REQUEST',
    'ACHIEVEMENT_UNLOCKED',
    'MESSAGE_RECEIVED',
    'CHAT_NOTIFICATION',
    'DEADLINE_REMINDER',
    'INSURANCE_EXPIRY',
    'CERTIFICATION_RENEWAL',
    'SYSTEM_ANNOUNCEMENT',
    'SECURITY_ALERT',
    'WHS_COMPLIANCE',
    'TAX_OBLIGATION'
);


ALTER TYPE public.notificationtype OWNER TO rateright_au;

--
-- Name: storagebackend; Type: TYPE; Schema: public; Owner: rateright_au
--

CREATE TYPE public.storagebackend AS ENUM (
    'LOCAL',
    'CLOUDINARY',
    'AZURE',
    'S3'
);


ALTER TYPE public.storagebackend OWNER TO rateright_au;



--
-- Name: achievements; Type: TABLE; Schema: public; Owner: rateright_au
--

CREATE TABLE public.achievements (
    user_id integer NOT NULL,
    achievement_type character varying(50) NOT NULL,
    badge_name character varying(100) NOT NULL,
    description text NOT NULL,
    icon_url character varying(255),
    points_awarded integer NOT NULL,
    rarity_level character varying(20) NOT NULL,
    trigger_condition character varying(100) NOT NULL,
    trigger_value integer,
    unlocked_at timestamp without time zone NOT NULL,
    id integer NOT NULL,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL
);


ALTER TABLE public.achievements OWNER TO rateright_au;

--
-- Name: achievements_id_seq; Type: SEQUENCE; Schema: public; Owner: rateright_au
--

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


ALTER SEQUENCE public.achievements_id_seq OWNER TO rateright_au;

--
-- Name: achievements_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: rateright_au
--

ALTER SEQUENCE public.achievements_id_seq OWNED BY public.achievements.id;


--
-- Name: alembic_version; Type: TABLE; Schema: public; Owner: rateright_au
--

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


ALTER TABLE public.alembic_version OWNER TO rateright_au;

--
-- Name: applications; Type: TABLE; Schema: public; Owner: rateright_au
--

CREATE TABLE public.applications (
    job_id integer NOT NULL,
    worker_id integer NOT NULL,
    status character varying(20),
    proposed_rate numeric(10,2),
    cover_letter text,
    date_applied timestamp without time zone,
    abn_verified boolean,
    insurance_verified boolean,
    id integer NOT NULL,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL
);


ALTER TABLE public.applications OWNER TO rateright_au;

--
-- Name: applications_id_seq; Type: SEQUENCE; Schema: public; Owner: rateright_au
--

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


ALTER SEQUENCE public.applications_id_seq OWNER TO rateright_au;

--
-- Name: applications_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: rateright_au
--

ALTER SEQUENCE public.applications_id_seq OWNED BY public.applications.id;


--
-- Name: audit_logs; Type: TABLE; Schema: public; Owner: rateright_au
--

CREATE TABLE public.audit_logs (
    user_id integer,
    action_type character varying(50) NOT NULL,
    resource_type character varying(50) NOT NULL,
    resource_id integer,
    action_description text NOT NULL,
    ip_address character varying(45),
    user_agent text,
    before_state text,
    after_state text,
    id integer NOT NULL,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL
);


ALTER TABLE public.audit_logs OWNER TO rateright_au;

--
-- Name: audit_logs_id_seq; Type: SEQUENCE; Schema: public; Owner: rateright_au
--

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


ALTER SEQUENCE public.audit_logs_id_seq OWNER TO rateright_au;

--
-- Name: audit_logs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: rateright_au
--

ALTER SEQUENCE public.audit_logs_id_seq OWNED BY public.audit_logs.id;


--
-- Name: availability; Type: TABLE; Schema: public; Owner: rateright_au
--

CREATE TABLE public.availability (
    worker_id integer NOT NULL,
    date date NOT NULL,
    start_time time without time zone NOT NULL,
    end_time time without time zone NOT NULL,
    status character varying(20) NOT NULL,
    is_recurring boolean,
    recurrence_pattern text,
    max_bookings integer,
    current_bookings integer,
    buffer_time integer,
    notes text,
    id integer NOT NULL,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL
);


ALTER TABLE public.availability OWNER TO rateright_au;

--
-- Name: availability_id_seq; Type: SEQUENCE; Schema: public; Owner: rateright_au
--

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


ALTER SEQUENCE public.availability_id_seq OWNER TO rateright_au;

--
-- Name: availability_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: rateright_au
--

ALTER SEQUENCE public.availability_id_seq OWNED BY public.availability.id;

--
-- Name: bookings_id_seq; Type: SEQUENCE; Schema: public; Owner: rateright_au
--

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


ALTER SEQUENCE public.bookings_id_seq OWNER TO rateright_au;

--
-- Name: bookings_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: rateright_au
--

ALTER SEQUENCE public.bookings_id_seq OWNED BY public.bookings.id;


--
-- Name: categories; Type: TABLE; Schema: public; Owner: rateright_au
--

CREATE TABLE public.categories (
    name character varying(100) NOT NULL,
    description text,
    whs_risk_level character varying(20) NOT NULL,
    insurance_requirements text,
    license_required boolean NOT NULL,
    white_card_required boolean NOT NULL,
    is_active boolean NOT NULL,
    sort_order integer NOT NULL,
    id integer NOT NULL,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL
);


ALTER TABLE public.categories OWNER TO rateright_au;

--
-- Name: categories_id_seq; Type: SEQUENCE; Schema: public; Owner: rateright_au
--

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


ALTER SEQUENCE public.categories_id_seq OWNER TO rateright_au;

--
-- Name: categories_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: rateright_au
--

ALTER SEQUENCE public.categories_id_seq OWNED BY public.categories.id;


--
-- Name: contracts; Type: TABLE; Schema: public; Owner: rateright_au
--

CREATE TABLE public.contracts (
    job_id integer NOT NULL,
    contractor_id integer NOT NULL,
    worker_id integer NOT NULL,
    agreed_rate numeric(10,2) NOT NULL,
    rate_type character varying(20) NOT NULL,
    start_date date NOT NULL,
    end_date date NOT NULL,
    scope_of_work text NOT NULL,
    independent_contractor_status boolean NOT NULL,
    superannuation_required boolean NOT NULL,
    workers_comp_covered boolean NOT NULL,
    status character varying(20) NOT NULL,
    completion_status character varying(50) NOT NULL,
    payment_status character varying(50) NOT NULL,
    contractor_approval_date timestamp without time zone,
    worker_completion_date timestamp without time zone,
    contractor_signed boolean NOT NULL,
    worker_signed boolean NOT NULL,
    contractor_signed_date timestamp without time zone,
    worker_signed_date timestamp without time zone,
    contractor_reviewed boolean NOT NULL,
    worker_reviewed boolean NOT NULL,
    last_modified_by integer,
    contractor_rated boolean NOT NULL,
    worker_rated boolean NOT NULL,
    mutual_rating_completed_date timestamp without time zone,
    payment_terms character varying(50) NOT NULL,
    payment_schedule text,
    id integer NOT NULL,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL,
    worker_agreed_resolve boolean NOT NULL,
    contractor_agreed_resolve boolean NOT NULL,
    review_hours_status character varying(50) DEFAULT 'pending'::character varying NOT NULL,
    contractor_name character varying(200),
    worker_name character varying(200),
    contractor_email character varying(120),
    contractor_phone character varying(20),
    contractor_abn character varying(11),
    contractor_business_name character varying(200),
    worker_email character varying(120),
    worker_phone character varying(20),
    worker_abn character varying(11),
    worker_business_name character varying(200)
);


ALTER TABLE public.contracts OWNER TO rateright_au;

--
-- Name: contracts_id_seq; Type: SEQUENCE; Schema: public; Owner: rateright_au
--

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


ALTER SEQUENCE public.contracts_id_seq OWNER TO rateright_au;

--
-- Name: contracts_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: rateright_au
--

ALTER SEQUENCE public.contracts_id_seq OWNED BY public.contracts.id;

--
-- Name: cookie_consents_id_seq; Type: SEQUENCE; Schema: public; Owner: rateright_au
--

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


ALTER SEQUENCE public.cookie_consents_id_seq OWNER TO rateright_au;

--
-- Name: cookie_consents_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: rateright_au
--

ALTER SEQUENCE public.cookie_consents_id_seq OWNED BY public.cookie_consents.id;


--
-- Name: disputes; Type: TABLE; Schema: public; Owner: rateright_au
--

CREATE TABLE public.disputes (
    contract_id integer NOT NULL,
    dispute_reference character varying(50) NOT NULL,
    dispute_type character varying(50) NOT NULL,
    raised_by integer NOT NULL,
    description text NOT NULL,
    status character varying(20) NOT NULL,
    resolution_notes text,
    resolved_by integer,
    resolved_at timestamp without time zone,
    id integer NOT NULL,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL
);


ALTER TABLE public.disputes OWNER TO rateright_au;

--
-- Name: disputes_id_seq; Type: SEQUENCE; Schema: public; Owner: rateright_au
--

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


ALTER SEQUENCE public.disputes_id_seq OWNER TO rateright_au;

--
-- Name: disputes_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: rateright_au
--

ALTER SEQUENCE public.disputes_id_seq OWNED BY public.disputes.id;


--
-- Name: file_uploads; Type: TABLE; Schema: public; Owner: rateright_au
--

CREATE TABLE public.file_uploads (
    id integer NOT NULL,
    user_id integer NOT NULL,
    filename character varying(500) NOT NULL,
    original_filename character varying(500) NOT NULL,
    file_type character varying(100),
    file_size bigint,
    storage_backend public.storagebackend DEFAULT 'LOCAL'::public.storagebackend NOT NULL,
    storage_path text,
    public_url text,
    category public.filecategory DEFAULT 'OTHER'::public.filecategory,
    message_id integer,
    job_id integer,
    contract_id integer,
    width integer,
    height integer,
    cloud_metadata json,
    is_deleted boolean DEFAULT false,
    deleted_at timestamp without time zone,
    created_at timestamp without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
    updated_at timestamp without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL
);


ALTER TABLE public.file_uploads OWNER TO rateright_au;

--
-- Name: file_uploads_id_seq; Type: SEQUENCE; Schema: public; Owner: rateright_au
--

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


ALTER SEQUENCE public.file_uploads_id_seq OWNER TO rateright_au;

--
-- Name: file_uploads_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: rateright_au
--

ALTER SEQUENCE public.file_uploads_id_seq OWNED BY public.file_uploads.id;


--
-- Name: invoices; Type: TABLE; Schema: public; Owner: rateright_au
--

CREATE TABLE public.invoices (
    payment_id integer NOT NULL,
    contractor_id integer NOT NULL,
    invoice_number character varying(50) NOT NULL,
    invoice_date date NOT NULL,
    due_date date NOT NULL,
    description text NOT NULL,
    amount_ex_gst numeric(10,2) NOT NULL,
    gst_amount numeric(10,2) NOT NULL,
    total_amount numeric(10,2) NOT NULL,
    gst_rate numeric(5,4) NOT NULL,
    supplier_abn character varying(11) NOT NULL,
    supplier_name character varying(200) NOT NULL,
    buyer_abn character varying(11) NOT NULL,
    buyer_name character varying(200) NOT NULL,
    status character varying(20) NOT NULL,
    id integer NOT NULL,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL
);


ALTER TABLE public.invoices OWNER TO rateright_au;

--
-- Name: invoices_id_seq; Type: SEQUENCE; Schema: public; Owner: rateright_au
--

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


ALTER SEQUENCE public.invoices_id_seq OWNER TO rateright_au;

--
-- Name: invoices_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: rateright_au
--

ALTER SEQUENCE public.invoices_id_seq OWNED BY public.invoices.id;


--
-- Name: job_progress; Type: TABLE; Schema: public; Owner: rateright_au
--

CREATE TABLE public.job_progress (
    job_id integer NOT NULL,
    contract_id integer NOT NULL,
    status character varying(20) NOT NULL,
    progress_percentage integer NOT NULL,
    milestone_description character varying(200),
    start_date date,
    actual_completion_date date,
    estimated_completion_date date,
    worker_notes text,
    contractor_notes text,
    photos_urls text,
    safety_incidents_reported integer NOT NULL,
    safety_compliance_maintained boolean NOT NULL,
    daily_safety_checks_completed boolean NOT NULL,
    updated_by integer NOT NULL,
    id integer NOT NULL,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL
);


ALTER TABLE public.job_progress OWNER TO rateright_au;

--
-- Name: job_progress_id_seq; Type: SEQUENCE; Schema: public; Owner: rateright_au
--

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


ALTER SEQUENCE public.job_progress_id_seq OWNER TO rateright_au;

--
-- Name: job_progress_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: rateright_au
--

ALTER SEQUENCE public.job_progress_id_seq OWNED BY public.job_progress.id;


--
-- Name: jobs; Type: TABLE; Schema: public; Owner: rateright_au
--

CREATE TABLE public.jobs (
    title character varying(200) NOT NULL,
    description text NOT NULL,
    contractor_id integer NOT NULL,
    category_id integer NOT NULL,
    location character varying(100) NOT NULL,
    budget_min numeric(10,2),
    budget_max numeric(10,2),
    hourly_rate numeric(10,2),
    whs_requirements text,
    insurance_required boolean,
    white_card_required boolean,
    start_datetime timestamp without time zone,
    duration character varying(50),
    workers_needed integer,
    own_tools_required boolean,
    own_transport_required boolean,
    payment_terms character varying(50),
    status character varying(20),
    date_posted timestamp without time zone,
    deadline timestamp without time zone,
    applications_count integer,
    id integer NOT NULL,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL,
    accepted_workers_count integer DEFAULT 0
);


ALTER TABLE public.jobs OWNER TO rateright_au;

--
-- Name: jobs_id_seq; Type: SEQUENCE; Schema: public; Owner: rateright_au
--

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

--
-- Name: jobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: rateright_au
--

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


--
-- Name: leaderboards; Type: TABLE; Schema: public; Owner: rateright_au
--

CREATE TABLE public.leaderboards (
    user_id integer NOT NULL,
    period_type character varying(20) NOT NULL,
    period_start date NOT NULL,
    period_end date NOT NULL,
    points_earned integer NOT NULL,
    rank_position integer NOT NULL,
    jobs_completed integer NOT NULL,
    avg_rating numeric(3,2),
    safety_score numeric(5,2),
    league_tier character varying(20) NOT NULL,
    id integer NOT NULL,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL
);


ALTER TABLE public.leaderboards OWNER TO rateright_au;

--
-- Name: leaderboards_id_seq; Type: SEQUENCE; Schema: public; Owner: rateright_au
--

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


ALTER SEQUENCE public.leaderboards_id_seq OWNER TO rateright_au;

--
-- Name: leaderboards_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: rateright_au
--

ALTER SEQUENCE public.leaderboards_id_seq OWNED BY public.leaderboards.id;


--
-- Name: messages; Type: TABLE; Schema: public; Owner: rateright_au
--

CREATE TABLE public.messages (
    sender_id integer NOT NULL,
    receiver_id integer NOT NULL,
    text text NOT NULL,
    status public.messagestatus NOT NULL,
    read_at timestamp without time zone,
    contract_id integer,
    job_id integer,
    id integer NOT NULL,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL,
    sender_name character varying(200)
);


ALTER TABLE public.messages OWNER TO rateright_au;

--
-- Name: messages_id_seq; Type: SEQUENCE; Schema: public; Owner: rateright_au
--

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


ALTER SEQUENCE public.messages_id_seq OWNER TO rateright_au;

--
-- Name: messages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: rateright_au
--

ALTER SEQUENCE public.messages_id_seq OWNED BY public.messages.id;


--
-- Name: notification_preferences; Type: TABLE; Schema: public; Owner: rateright_au
--

CREATE TABLE public.notification_preferences (
    user_id integer NOT NULL,
    notification_type public.notificationtype NOT NULL,
    email_enabled boolean NOT NULL,
    email_frequency public.notificationfrequency,
    sms_enabled boolean NOT NULL,
    sms_frequency public.notificationfrequency,
    push_web_enabled boolean NOT NULL,
    push_mobile_enabled boolean NOT NULL,
    in_app_enabled boolean NOT NULL,
    quiet_hours_start time without time zone,
    quiet_hours_end time without time zone,
    respect_weekends boolean NOT NULL,
    consent_given boolean NOT NULL,
    consent_date timestamp without time zone,
    id integer NOT NULL,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL
);


ALTER TABLE public.notification_preferences OWNER TO rateright_au;

--
-- Name: notification_preferences_id_seq; Type: SEQUENCE; Schema: public; Owner: rateright_au
--

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


ALTER SEQUENCE public.notification_preferences_id_seq OWNER TO rateright_au;

--
-- Name: notification_preferences_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: rateright_au
--

ALTER SEQUENCE public.notification_preferences_id_seq OWNED BY public.notification_preferences.id;


--
-- Name: notification_templates; Type: TABLE; Schema: public; Owner: rateright_au
--

CREATE TABLE public.notification_templates (
    notification_type public.notificationtype NOT NULL,
    channel public.deliverychannel NOT NULL,
    subject_template text,
    body_template text NOT NULL,
    html_template text,
    template_name character varying(100) NOT NULL,
    description character varying(255),
    includes_unsubscribe boolean,
    privacy_compliant boolean NOT NULL,
    is_active boolean NOT NULL,
    id integer NOT NULL,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL
);


ALTER TABLE public.notification_templates OWNER TO rateright_au;

--
-- Name: notification_templates_id_seq; Type: SEQUENCE; Schema: public; Owner: rateright_au
--

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


ALTER SEQUENCE public.notification_templates_id_seq OWNER TO rateright_au;

--
-- Name: notification_templates_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: rateright_au
--

ALTER SEQUENCE public.notification_templates_id_seq OWNED BY public.notification_templates.id;


--
-- Name: notifications; Type: TABLE; Schema: public; Owner: rateright_au
--

CREATE TABLE public.notifications (
    user_id integer NOT NULL,
    notification_type public.notificationtype NOT NULL,
    title character varying(255) NOT NULL,
    content text NOT NULL,
    channels_attempted json,
    channels_delivered json,
    channels_failed json,
    status public.notificationstatus NOT NULL,
    scheduled_for timestamp without time zone,
    sent_at timestamp without time zone,
    delivered_at timestamp without time zone,
    read_at timestamp without time zone,
    priority integer,
    category character varying(50),
    action_url character varying(255),
    requires_consent boolean,
    business_hours_only boolean,
    error_count integer,
    last_error text,
    id integer NOT NULL,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL
);


ALTER TABLE public.notifications OWNER TO rateright_au;

--
-- Name: notifications_id_seq; Type: SEQUENCE; Schema: public; Owner: rateright_au
--

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


ALTER SEQUENCE public.notifications_id_seq OWNER TO rateright_au;

--
-- Name: notifications_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: rateright_au
--

ALTER SEQUENCE public.notifications_id_seq OWNED BY public.notifications.id;

--
-- Name: payments_id_seq; Type: SEQUENCE; Schema: public; Owner: rateright_au
--

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

--
-- Name: payments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: rateright_au
--

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


--
-- Name: point_activities; Type: TABLE; Schema: public; Owner: rateright_au
--

CREATE TABLE public.point_activities (
    user_id integer NOT NULL,
    activity_type character varying(50) NOT NULL,
    points_earned integer NOT NULL,
    description text NOT NULL,
    related_job_id integer,
    related_contract_id integer,
    related_review_id integer,
    base_points integer NOT NULL,
    bonus_multiplier numeric(3,2) NOT NULL,
    bonus_reason character varying(100),
    id integer NOT NULL,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL
);


ALTER TABLE public.point_activities OWNER TO rateright_au;

--
-- Name: point_activities_id_seq; Type: SEQUENCE; Schema: public; Owner: rateright_au
--

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


ALTER SEQUENCE public.point_activities_id_seq OWNER TO rateright_au;

--
-- Name: point_activities_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: rateright_au
--

ALTER SEQUENCE public.point_activities_id_seq OWNED BY public.point_activities.id;


--
-- Name: ratings; Type: TABLE; Schema: public; Owner: rateright_au
--

CREATE TABLE public.ratings (
    contract_id integer NOT NULL,
    rater_id integer NOT NULL,
    rated_id integer NOT NULL,
    overall_score double precision NOT NULL,
    quality_score double precision,
    communication_score double precision,
    reliability_score double precision,
    professionalism_score double precision,
    review_text text,
    rating_date timestamp without time zone NOT NULL,
    is_public boolean NOT NULL,
    id integer NOT NULL,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL
);


ALTER TABLE public.ratings OWNER TO rateright_au;

--
-- Name: ratings_id_seq; Type: SEQUENCE; Schema: public; Owner: rateright_au
--

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


ALTER SEQUENCE public.ratings_id_seq OWNER TO rateright_au;

--
-- Name: ratings_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: rateright_au
--

ALTER SEQUENCE public.ratings_id_seq OWNED BY public.ratings.id;


--
-- Name: recurring_bookings; Type: TABLE; Schema: public; Owner: rateright_au
--

CREATE TABLE public.recurring_bookings (
    client_id integer NOT NULL,
    worker_id integer NOT NULL,
    recurrence_type character varying(20) NOT NULL,
    recurrence_interval integer,
    recurrence_days text,
    recurrence_day_of_month integer,
    start_time time without time zone NOT NULL,
    duration_minutes integer NOT NULL,
    service_type character varying(100) NOT NULL,
    description text,
    location character varying(255),
    start_date date NOT NULL,
    end_date date,
    is_active boolean,
    estimated_cost_per_session double precision,
    next_occurrence date,
    id integer NOT NULL,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL
);


ALTER TABLE public.recurring_bookings OWNER TO rateright_au;

--
-- Name: recurring_bookings_id_seq; Type: SEQUENCE; Schema: public; Owner: rateright_au
--

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


ALTER SEQUENCE public.recurring_bookings_id_seq OWNER TO rateright_au;

--
-- Name: recurring_bookings_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: rateright_au
--

ALTER SEQUENCE public.recurring_bookings_id_seq OWNED BY public.recurring_bookings.id;


--
-- Name: reviews; Type: TABLE; Schema: public; Owner: rateright_au
--

CREATE TABLE public.reviews (
    reviewer_id integer NOT NULL,
    reviewee_id integer NOT NULL,
    job_id integer NOT NULL,
    contract_id integer,
    overall_rating integer NOT NULL,
    quality_rating integer NOT NULL,
    communication_rating integer NOT NULL,
    safety_rating integer NOT NULL,
    comment text,
    would_work_again boolean NOT NULL,
    verified_completion boolean NOT NULL,
    id integer NOT NULL,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL
);


ALTER TABLE public.reviews OWNER TO rateright_au;

--
-- Name: reviews_id_seq; Type: SEQUENCE; Schema: public; Owner: rateright_au
--

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


ALTER SEQUENCE public.reviews_id_seq OWNER TO rateright_au;

--
-- Name: reviews_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: rateright_au
--

ALTER SEQUENCE public.reviews_id_seq OWNED BY public.reviews.id;


--
-- Name: shift_bids; Type: TABLE; Schema: public; Owner: rateright_au
--

CREATE TABLE public.shift_bids (
    shift_id integer NOT NULL,
    worker_id integer NOT NULL,
    bid_amount double precision,
    availability_confirmed boolean,
    status character varying(20),
    selected_at timestamp without time zone,
    selected_by integer,
    worker_notes text,
    rejection_reason text,
    id integer NOT NULL,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL
);


ALTER TABLE public.shift_bids OWNER TO rateright_au;

--
-- Name: shift_bids_id_seq; Type: SEQUENCE; Schema: public; Owner: rateright_au
--

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


ALTER SEQUENCE public.shift_bids_id_seq OWNER TO rateright_au;

--
-- Name: shift_bids_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: rateright_au
--

ALTER SEQUENCE public.shift_bids_id_seq OWNED BY public.shift_bids.id;


--
-- Name: shift_swap_requests; Type: TABLE; Schema: public; Owner: rateright_au
--

CREATE TABLE public.shift_swap_requests (
    from_worker_id integer NOT NULL,
    from_shift_id integer NOT NULL,
    to_worker_id integer,
    to_shift_id integer,
    reason text,
    is_permanent boolean,
    status character varying(20),
    worker_approved boolean,
    manager_approved boolean,
    approved_by integer,
    approved_at timestamp without time zone,
    id integer NOT NULL,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL
);


ALTER TABLE public.shift_swap_requests OWNER TO rateright_au;

--
-- Name: shift_swap_requests_id_seq; Type: SEQUENCE; Schema: public; Owner: rateright_au
--

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


ALTER SEQUENCE public.shift_swap_requests_id_seq OWNER TO rateright_au;

--
-- Name: shift_swap_requests_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: rateright_au
--

ALTER SEQUENCE public.shift_swap_requests_id_seq OWNED BY public.shift_swap_requests.id;


--
-- Name: shifts; Type: TABLE; Schema: public; Owner: rateright_au
--

CREATE TABLE public.shifts (
    worker_id integer,
    job_id integer,
    shift_date date NOT NULL,
    start_time time without time zone NOT NULL,
    end_time time without time zone NOT NULL,
    shift_type character varying(50),
    shift_name character varying(100),
    is_open boolean,
    min_workers_required integer,
    max_workers_allowed integer,
    current_workers integer,
    required_skills text,
    min_rating double precision,
    hourly_rate double precision,
    overtime_rate double precision,
    status character varying(20),
    description text,
    special_instructions text,
    id integer NOT NULL,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL
);


ALTER TABLE public.shifts OWNER TO rateright_au;

--
-- Name: shifts_id_seq; Type: SEQUENCE; Schema: public; Owner: rateright_au
--

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


ALTER SEQUENCE public.shifts_id_seq OWNER TO rateright_au;

--
-- Name: shifts_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: rateright_au
--

ALTER SEQUENCE public.shifts_id_seq OWNED BY public.shifts.id;


--
-- Name: time_entries; Type: TABLE; Schema: public; Owner: rateright_au
--

CREATE TABLE public.time_entries (
    worker_id integer NOT NULL,
    job_id integer,
    booking_id integer,
    contract_id integer,
    clock_in timestamp without time zone NOT NULL,
    clock_out timestamp without time zone,
    break_start timestamp without time zone,
    break_end timestamp without time zone,
    total_break_minutes integer,
    total_minutes integer,
    regular_hours double precision,
    overtime_hours double precision,
    work_date date NOT NULL,
    description text,
    location character varying(255),
    is_approved boolean,
    approved_by integer,
    approved_at timestamp without time zone,
    is_manual_entry boolean,
    notes text,
    id integer NOT NULL,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL
);


ALTER TABLE public.time_entries OWNER TO rateright_au;

--
-- Name: time_entries_id_seq; Type: SEQUENCE; Schema: public; Owner: rateright_au
--

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


ALTER SEQUENCE public.time_entries_id_seq OWNER TO rateright_au;

--
-- Name: time_entries_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: rateright_au
--

ALTER SEQUENCE public.time_entries_id_seq OWNED BY public.time_entries.id;

--
-- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: rateright_au
--

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

--
-- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: rateright_au
--

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


--
-- Name: whs_assessments; Type: TABLE; Schema: public; Owner: rateright_au
--

CREATE TABLE public.whs_assessments (
    job_id integer NOT NULL,
    assessment_reference character varying(50) NOT NULL,
    risk_assessment text NOT NULL,
    hazard_identification text NOT NULL,
    risk_control_measures text NOT NULL,
    safety_plan_accepted boolean NOT NULL,
    safety_induction_completed boolean NOT NULL,
    emergency_procedures_briefed boolean NOT NULL,
    insurance_verified boolean NOT NULL,
    white_card_verified boolean NOT NULL,
    license_verification text,
    incident_report text,
    incidents_count integer NOT NULL,
    near_miss_count integer NOT NULL,
    status character varying(20) NOT NULL,
    completed_by integer NOT NULL,
    approved_by integer,
    id integer NOT NULL,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL
);


ALTER TABLE public.whs_assessments OWNER TO rateright_au;

--
-- Name: whs_assessments_id_seq; Type: SEQUENCE; Schema: public; Owner: rateright_au
--

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


ALTER SEQUENCE public.whs_assessments_id_seq OWNER TO rateright_au;

--
-- Name: whs_assessments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: rateright_au
--

ALTER SEQUENCE public.whs_assessments_id_seq OWNED BY public.whs_assessments.id;


--
-- Name: worker_schedule_preferences; Type: TABLE; Schema: public; Owner: rateright_au
--

CREATE TABLE public.worker_schedule_preferences (
    worker_id integer NOT NULL,
    default_start_time time without time zone,
    default_end_time time without time zone,
    working_days text,
    default_buffer_time integer,
    travel_time_buffer integer,
    min_advance_booking integer,
    max_advance_booking integer,
    google_calendar_id character varying(255),
    outlook_calendar_id character varying(255),
    sync_enabled boolean,
    last_sync timestamp without time zone,
    reminder_time integer,
    reminder_method character varying(20),
    id integer NOT NULL,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL
);


ALTER TABLE public.worker_schedule_preferences OWNER TO rateright_au;

--
-- Name: worker_schedule_preferences_id_seq; Type: SEQUENCE; Schema: public; Owner: rateright_au
--

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


ALTER SEQUENCE public.worker_schedule_preferences_id_seq OWNER TO rateright_au;

--
-- Name: worker_schedule_preferences_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: rateright_au
--

ALTER SEQUENCE public.worker_schedule_preferences_id_seq OWNED BY public.worker_schedule_preferences.id;


--
-- Name: achievements id; Type: DEFAULT; Schema: public; Owner: rateright_au
--

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


--
-- Name: applications id; Type: DEFAULT; Schema: public; Owner: rateright_au
--

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


--
-- Name: audit_logs id; Type: DEFAULT; Schema: public; Owner: rateright_au
--

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


--
-- Name: availability id; Type: DEFAULT; Schema: public; Owner: rateright_au
--

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


--
-- Name: categories id; Type: DEFAULT; Schema: public; Owner: rateright_au
--

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


--
-- Name: contracts id; Type: DEFAULT; Schema: public; Owner: rateright_au
--

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


--
-- Name: disputes id; Type: DEFAULT; Schema: public; Owner: rateright_au
--

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


--
-- Name: file_uploads id; Type: DEFAULT; Schema: public; Owner: rateright_au
--

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


--
-- Name: invoices id; Type: DEFAULT; Schema: public; Owner: rateright_au
--

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


--
-- Name: job_progress id; Type: DEFAULT; Schema: public; Owner: rateright_au
--

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


--
-- Name: jobs id; Type: DEFAULT; Schema: public; Owner: rateright_au
--

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


--
-- Name: leaderboards id; Type: DEFAULT; Schema: public; Owner: rateright_au
--

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


--
-- Name: messages id; Type: DEFAULT; Schema: public; Owner: rateright_au
--

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


--
-- Name: notification_preferences id; Type: DEFAULT; Schema: public; Owner: rateright_au
--

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


--
-- Name: notification_templates id; Type: DEFAULT; Schema: public; Owner: rateright_au
--

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


--
-- Name: notifications id; Type: DEFAULT; Schema: public; Owner: rateright_au
--

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


--
-- Name: point_activities id; Type: DEFAULT; Schema: public; Owner: rateright_au
--

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


--
-- Name: ratings id; Type: DEFAULT; Schema: public; Owner: rateright_au
--

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


--
-- Name: recurring_bookings id; Type: DEFAULT; Schema: public; Owner: rateright_au
--

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


--
-- Name: reviews id; Type: DEFAULT; Schema: public; Owner: rateright_au
--

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


--
-- Name: shift_bids id; Type: DEFAULT; Schema: public; Owner: rateright_au
--

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


--
-- Name: shift_swap_requests id; Type: DEFAULT; Schema: public; Owner: rateright_au
--

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


--
-- Name: shifts id; Type: DEFAULT; Schema: public; Owner: rateright_au
--

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


--
-- Name: time_entries id; Type: DEFAULT; Schema: public; Owner: rateright_au
--

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


--
-- Name: whs_assessments id; Type: DEFAULT; Schema: public; Owner: rateright_au
--

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


--
-- Name: worker_schedule_preferences id; Type: DEFAULT; Schema: public; Owner: rateright_au
--

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


--
-- Data for Name: achievements; Type: TABLE DATA; Schema: public; Owner: rateright_au
--

COPY public.achievements (user_id, achievement_type, badge_name, description, icon_url, points_awarded, rarity_level, trigger_condition, trigger_value, unlocked_at, id, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: alembic_version; Type: TABLE DATA; Schema: public; Owner: rateright_au
--

COPY public.alembic_version (version_num) FROM stdin;
ab0d186d8497
\.


--
-- Data for Name: applications; Type: TABLE DATA; Schema: public; Owner: rateright_au
--

COPY public.applications (job_id, worker_id, status, proposed_rate, cover_letter, date_applied, abn_verified, insurance_verified, id, created_at, updated_at) FROM stdin;
31	49	pending	45.00	Im shit hot at what I do 	2025-11-21 05:01:25.16985	t	f	37	2025-11-21 05:01:25.169856	2025-11-21 05:01:25.169861
33	65	accepted	25.00	30 years steel fixing experience. Worked on commercial, civil, and infrastructure projects across Sydney, Melbourne, Perth, London and Ireland. Own tools, white card current. Reliable - I show up.	2026-01-09 06:25:01.224738	t	t	38	2026-01-09 06:25:01.224742	2026-01-09 06:26:04.485206
34	65	accepted	25.00	3o years experiance and i show up	2026-01-14 01:03:06.953767	t	t	39	2026-01-14 01:03:06.953773	2026-01-14 01:03:35.96534
38	18	accepted	45.00		2026-01-29 15:28:57.9523	t	t	40	2026-01-29 15:28:57.952307	2026-01-29 15:29:06.128849
\.


--
-- Data for Name: audit_logs; Type: TABLE DATA; Schema: public; Owner: rateright_au
--

COPY public.audit_logs (user_id, action_type, resource_type, resource_id, action_description, ip_address, user_agent, before_state, after_state, id, created_at, updated_at) FROM stdin;
17	create_user	users	51	Created user: admin@rateright.com.au (super_admin)	\N	\N	\N	\N	1	2025-12-01 16:33:22.961679	2025-12-01 16:33:22.961686
\.


--
-- Data for Name: availability; Type: TABLE DATA; Schema: public; Owner: rateright_au
--

COPY public.availability (worker_id, date, start_time, end_time, status, is_recurring, recurrence_pattern, max_bookings, current_bookings, buffer_time, notes, id, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: categories; Type: TABLE DATA; Schema: public; Owner: rateright_au
--

COPY public.categories (name, description, whs_risk_level, insurance_requirements, license_required, white_card_required, is_active, sort_order, id, created_at, updated_at) FROM stdin;
Construction Manager	Leads overall site operations, budgeting, and project timelines	medium	Professional Indemnity $2M, Public Liability $10M	f	t	t	1	1	2025-08-23 09:43:37.933229	2025-08-23 09:43:37.933232
Project Manager	Oversees project delivery, coordination, and stakeholder management	medium	Professional Indemnity $1M, Public Liability $5M	f	t	t	2	2	2025-08-23 09:43:37.933233	2025-08-23 09:43:37.933234
Site Manager	Daily oversight of construction activities and site operations	medium	Professional Indemnity $1M, Public Liability $10M	f	t	t	3	3	2025-08-23 09:43:37.933234	2025-08-23 09:43:37.933236
Building Surveyor	Ensures compliance with building codes and standards	low	Professional Indemnity $5M, Public Liability $2M	t	t	t	8	4	2025-08-23 09:43:37.933237	2025-08-23 09:43:37.933238
Quantity Surveyor	Manages costs, materials, and contract administration	low	Professional Indemnity $2M, Public Liability $1M	f	f	t	10	5	2025-08-23 09:43:37.933238	2025-08-23 09:43:37.933239
Safety Officer	Oversees WHS compliance and risk assessments	medium	Professional Indemnity $2M, Public Liability $5M	t	t	t	11	6	2025-08-23 09:43:37.933239	2025-08-23 09:43:37.93324
Electrician	Electrical wiring, installations, and maintenance	extreme	Public Liability $10M, Professional Indemnity $2M	t	t	t	50	7	2025-08-23 09:43:37.93324	2025-08-23 09:43:37.93324
Auto Electrician	Vehicle and machinery electrical systems	extreme	Public Liability $5M, Vehicle Work Coverage	t	t	t	51	8	2025-08-23 09:43:37.933241	2025-08-23 09:43:37.933254
Solar Installer	Photovoltaic system design and installation	extreme	Public Liability $10M, Height Work $2M	t	t	t	52	9	2025-08-23 09:43:37.933254	2025-08-23 09:43:37.933255
Data Electrician	Network and data communications infrastructure	high	Public Liability $5M, Data Loss Coverage	t	t	t	53	10	2025-08-23 09:43:37.933255	2025-08-23 09:43:37.933256
Communications Electrician	Telecommunications and broadcast systems	high	Public Liability $5M, Communications Equipment Coverage	t	t	t	54	11	2025-08-23 09:43:37.933256	2025-08-23 09:43:37.933257
Plumber	Installs and repairs water, drainage, and heating systems	high	Public Liability $5M, Professional Indemnity $1M	t	t	t	40	12	2025-08-23 09:43:37.933257	2025-08-23 09:43:37.933257
Gasfitter	Gas system installation and maintenance specialist	extreme	Public Liability $10M, Gas Work Specialty $5M	t	t	t	41	13	2025-08-23 09:43:37.933258	2025-08-23 09:43:37.933258
Drainer	Sewage, stormwater, and waste system specialist	high	Public Liability $5M, Environmental Liability $2M	t	t	t	42	14	2025-08-23 09:43:37.933259	2025-08-23 09:43:37.933259
Roofer Plumber	Roof drainage systems and guttering specialist	extreme	Public Liability $5M, Height Work $2M	t	t	t	43	15	2025-08-23 09:43:37.933259	2025-08-23 09:43:37.93326
Irrigation Specialist	Automated watering and irrigation systems	medium	Public Liability $2M, System Warranty Coverage	t	t	t	44	16	2025-08-23 09:43:37.93326	2025-08-23 09:43:37.933261
Carpenter	Frames structures and installs timber fittings	medium	Public Liability $2M, Tools Coverage $15k	f	t	t	30	17	2025-08-23 09:43:37.933261	2025-08-23 09:43:37.933261
Bricklayer	Lays bricks, blocks, and masonry construction	medium	Public Liability $2M, Tools Coverage $10k	f	t	t	20	18	2025-08-23 09:43:37.933262	2025-08-23 09:43:37.933262
Roofer	General roof installation and repair	extreme	Public Liability $10M, Height Work $5M	t	t	t	90	19	2025-08-23 09:43:37.933263	2025-08-23 09:43:37.933263
Painter	Interior and exterior painting and finishing	low	Public Liability $2M, Chemical Exposure Coverage	f	t	t	60	20	2025-08-23 09:43:37.933263	2025-08-23 09:43:37.933264
Tiler	Ceramic, stone, and tile installation specialist	medium	Public Liability $2M, Materials Breakage Coverage	f	t	t	80	21	2025-08-23 09:43:37.933264	2025-08-23 09:43:37.933265
Plasterer	Wall and ceiling plastering and rendering	medium	Public Liability $2M, Dust Exposure Coverage	f	t	t	70	22	2025-08-23 09:43:37.933265	2025-08-23 09:43:37.933265
General Labourer	General construction assistance and site work	medium	Public Liability $1M, Personal Accident	f	t	t	300	23	2025-08-23 09:43:37.933266	2025-08-23 09:43:37.933266
Steelfixer	Steel reinforcement specialist for concrete structures	high	Public Liability $5M, Height Work Coverage	f	t	t	104	24	2025-08-23 09:47:20.154716	2025-08-23 09:47:20.15472
Welder	Metal fabrication and structural welding	high	Public Liability $5M, Hot Work Coverage $2M	t	t	t	100	25	2025-08-23 09:47:20.154721	2025-08-23 09:47:20.154721
Boilermaker	Heavy metal fabrication and pressure vessels	high	Public Liability $10M, Pressure Vessel Certification	t	t	t	101	26	2025-08-23 09:47:20.154722	2025-08-23 09:47:20.154724
Structural Steel Welder	Building framework welding specialist	high	Public Liability $10M, Structural Warranty	t	t	t	102	27	2025-08-23 09:47:20.154725	2025-08-23 09:47:20.154725
Pressure Welder	Pipeline and pressure system welding	extreme	Public Liability $20M, Pressure System Liability	t	t	t	103	28	2025-08-23 09:47:20.154726	2025-08-23 09:47:20.154726
Scaffolder	Scaffolding erection and safety systems	high	Public Liability $10M, Height Work $5M	t	t	t	130	29	2025-08-23 09:47:20.154727	2025-08-23 09:47:20.154727
Rigger	Heavy lifting and crane operation specialist	extreme	Public Liability $20M, Crane Operation Coverage	t	t	t	131	30	2025-08-23 09:47:20.154728	2025-08-23 09:47:20.154728
Advanced Scaffolder	High-risk scaffolding and complex structures	extreme	Public Liability $20M, Advanced Height Work	t	t	t	132	31	2025-08-23 09:47:20.154729	2025-08-23 09:47:20.154729
Dogger	Crane signaling and load coordination	extreme	Public Liability $10M, Crane Signaling Certification	t	t	t	133	32	2025-08-23 09:47:20.154729	2025-08-23 09:47:20.15473
Joiner	Precision woodwork and fitting	medium	Public Liability $2M, Tools Coverage $20k	f	t	t	31	33	2025-08-23 09:47:20.15473	2025-08-23 09:47:20.154731
Formworker	Creates concrete molds and forms	high	Public Liability $5M, Height Work Coverage	f	t	t	32	34	2025-08-23 09:47:20.154731	2025-08-23 09:47:20.154731
Shopfitter	Retail interior installations	medium	Public Liability $5M, Tools Coverage $25k	f	t	t	33	35	2025-08-23 09:47:20.154732	2025-08-23 09:47:20.154732
Cabinetmaker	Custom furniture and cabinetry	low	Public Liability $2M, Workshop Coverage $50k	f	f	t	34	36	2025-08-23 09:47:20.154733	2025-08-23 09:47:20.154733
Mason	Stone and traditional masonry	medium	Public Liability $2M, Tools Coverage $15k	f	t	t	21	37	2025-08-23 09:47:20.154734	2025-08-23 09:47:20.154734
Stonemason	Natural stone cutting and installation	medium	Public Liability $5M, Tools Coverage $20k	f	t	t	22	38	2025-08-23 09:47:20.154734	2025-08-23 09:47:20.154735
Refractory Bricklayer	High-temperature furnace specialist	high	Public Liability $5M, Specialist Coverage $50k	t	t	t	23	39	2025-08-23 09:47:20.154735	2025-08-23 09:47:20.154736
Concreter	Concrete pouring and finishing	high	Public Liability $5M, Chemical Exposure Coverage	f	t	t	120	40	2025-08-23 09:47:20.154736	2025-08-23 09:47:20.154736
Precast Specialist	Precast concrete installation	high	Public Liability $10M, Crane Work Coverage	f	t	t	121	41	2025-08-23 09:47:20.154737	2025-08-23 09:47:20.154737
Decorative Concreter	Stamped and polished concrete	medium	Public Liability $5M, Artistic Work Coverage	f	t	t	122	42	2025-08-23 09:47:20.154738	2025-08-23 09:47:20.154738
Metal Roofer	Sheet metal roofing specialist	extreme	Public Liability $10M, Height Work $5M	t	t	t	91	43	2025-08-23 09:47:20.154739	2025-08-23 09:47:20.154739
Slate Roofer	Natural slate roofing specialist	extreme	Public Liability $10M, Specialist Materials $100k	t	t	t	92	44	2025-08-23 09:47:20.154739	2025-08-23 09:47:20.15474
Roof Tiler	Clay and concrete tile roofing	extreme	Public Liability $10M, Height Work $5M	t	t	t	82	45	2025-08-23 09:47:20.15474	2025-08-23 09:47:20.154741
Decorator	Decorative finishing specialist	low	Public Liability $2M, Artwork Coverage $50k	f	t	t	61	46	2025-08-23 09:47:20.154741	2025-08-23 09:47:20.154741
Industrial Painter	Heavy-duty coating specialist	medium	Public Liability $5M, Chemical Exposure $1M	f	t	t	62	47	2025-08-23 09:47:20.154742	2025-08-23 09:47:20.154742
Signwriter	Commercial signage specialist	low	Public Liability $2M, Design Copyright Coverage	f	f	t	63	48	2025-08-23 09:47:20.154743	2025-08-23 09:47:20.154743
Site Supervisor	Daily construction oversight	medium	Public Liability $5M, Workers Compensation	f	t	t	5	49	2025-08-23 09:47:20.154743	2025-08-23 09:47:20.154744
Foreman	Team supervision and quality control	medium	Public Liability $5M, Workers Compensation	f	t	t	6	50	2025-08-23 09:47:20.154744	2025-08-23 09:47:20.154745
Leading Hand	Small team supervision	medium	Public Liability $2M, Workers Compensation	f	t	t	7	51	2025-08-23 09:47:20.154745	2025-08-23 09:47:20.154745
Demolition Worker	Building demolition specialist	extreme	Public Liability $20M, Environmental Liability $5M	t	t	t	180	52	2025-08-23 09:47:20.154746	2025-08-23 09:47:20.154746
Excavator Operator	Heavy machinery operation	high	Public Liability $10M, Equipment Coverage	t	t	t	135	53	2025-08-23 09:47:20.154747	2025-08-23 09:47:20.154747
Crane Operator	Tower and mobile crane operation	extreme	Public Liability $20M, Equipment Coverage	t	t	t	136	54	2025-08-23 09:47:20.154747	2025-08-23 09:47:20.154748
Glazier	Glass cutting, installation, and repair	medium	Public Liability $5M, Glass Breakage Coverage	f	t	t	110	55	2025-08-23 09:54:08.257498	2025-08-23 09:54:08.257502
Structural Glazier	Large-scale building facade glazing	high	Public Liability $10M, Height Work $5M	t	t	t	111	56	2025-08-23 09:54:08.257503	2025-08-23 09:54:08.257503
Automotive Glazier	Vehicle windscreen and glass specialist	low	Public Liability $2M, Vehicle Damage Coverage	f	f	t	112	57	2025-08-23 09:54:08.257504	2025-08-23 09:54:08.257506
Landscaper	Outdoor space design and construction	medium	Public Liability $5M, Plant Guarantee Coverage	f	t	t	140	58	2025-08-23 09:54:08.257507	2025-08-23 09:54:08.257508
Horticulturist	Plant cultivation and garden management	low	Public Liability $2M, Plant Health Guarantee	f	f	t	141	59	2025-08-23 09:54:08.257508	2025-08-23 09:54:08.257509
Fencer	Residential and commercial fencing installation	medium	Public Liability $2M, Materials Coverage	f	t	t	150	60	2025-08-23 09:54:08.257509	2025-08-23 09:54:08.257509
Security Fencer	High-security perimeter fencing specialist	medium	Public Liability $5M, Security System Coverage	t	t	t	151	61	2025-08-23 09:54:08.25751	2025-08-23 09:54:08.25751
Rural Fencer	Farm and agricultural fencing specialist	medium	Public Liability $2M, Rural Property Coverage	f	t	t	152	62	2025-08-23 09:54:08.257511	2025-08-23 09:54:08.257511
Insulation Installer	Building thermal and acoustic insulation	medium	Public Liability $2M, Respiratory Health Coverage	f	t	t	160	63	2025-08-23 09:54:08.257511	2025-08-23 09:54:08.257512
Acoustic Specialist	Sound insulation and noise control	medium	Public Liability $2M, Performance Warranty	f	t	t	161	64	2025-08-23 09:54:08.257512	2025-08-23 09:54:08.257513
Thermal Installer	Temperature control insulation systems	medium	Public Liability $2M, Energy Performance Warranty	f	t	t	162	65	2025-08-23 09:54:08.257513	2025-08-23 09:54:08.257513
Sheet Metal Worker	Ductwork fabrication and installation	medium	Public Liability $2M, Equipment Coverage	f	t	t	170	66	2025-08-23 09:54:08.257514	2025-08-23 09:54:08.257514
HVAC Fabricator	Heating and cooling system fabrication	medium	Public Liability $5M, Refrigeration License	t	t	t	171	67	2025-08-23 09:54:08.257515	2025-08-23 09:54:08.257515
Architectural Cladder	Building exterior cladding installation	high	Public Liability $10M, Height Work Coverage	f	t	t	172	68	2025-08-23 09:54:08.257516	2025-08-23 09:54:08.257516
Air Conditioning Mechanic	HVAC system installation and maintenance	high	Public Liability $5M, Refrigeration License	t	t	t	190	69	2025-08-23 09:54:08.257516	2025-08-23 09:54:08.257517
Refrigeration Mechanic	Commercial refrigeration system specialist	high	Public Liability $5M, Refrigerant Handling License	t	t	t	191	70	2025-08-23 09:54:08.257517	2025-08-23 09:54:08.257518
Commercial Refrigeration Tech	Large-scale refrigeration and cooling systems	high	Public Liability $10M, Commercial System Coverage	t	t	t	192	71	2025-08-23 09:54:08.257518	2025-08-23 09:54:08.257518
Elevator Installer	Lift and escalator installation specialist	extreme	Public Liability $20M, Vertical Transportation License	t	t	t	200	72	2025-08-23 09:54:08.257519	2025-08-23 09:54:08.257519
Elevator Mechanic	Lift maintenance and repair specialist	high	Public Liability $10M, Lift Mechanic License	t	t	t	201	73	2025-08-23 09:54:08.25752	2025-08-23 09:54:08.25752
Maintenance Specialist	General equipment maintenance and repair	medium	Public Liability $2M, Equipment Coverage	f	t	t	202	74	2025-08-23 09:54:08.25752	2025-08-23 09:54:08.257521
Floor Finisher	Floor polishing, sanding, and finishing	medium	Public Liability $2M, Chemical Exposure Coverage	f	t	t	210	75	2025-08-23 09:54:08.257521	2025-08-23 09:54:08.257522
Timber Floor Specialist	Hardwood flooring installation and restoration	medium	Public Liability $5M, Materials Warranty	f	t	t	211	76	2025-08-23 09:54:08.257522	2025-08-23 09:54:08.257522
Epoxy Coater	Industrial floor coating and chemical-resistant surfaces	high	Public Liability $5M, Chemical Handling Coverage	f	t	t	212	77	2025-08-23 09:54:08.257523	2025-08-23 09:54:08.257523
Builder's Labourer	Assists trades, material handling, and site preparation	medium	Public Liability $1M, Basic Tools Coverage	f	t	t	300	78	2025-08-23 09:54:08.257524	2025-08-23 09:54:08.257524
Handyperson	Minor repairs and maintenance specialist	medium	Public Liability $2M, Tools Coverage	f	t	t	302	79	2025-08-23 09:54:08.257524	2025-08-23 09:54:08.257525
Paving Labourer	Road and pathway construction assistant	medium	Public Liability $2M, Road Work Coverage	f	t	t	303	80	2025-08-23 09:54:08.257525	2025-08-23 09:54:08.257525
Surfacing Labourer	Surface preparation and finishing assistant	medium	Public Liability $1M, Chemical Exposure Basic	f	t	t	304	81	2025-08-23 09:54:08.257526	2025-08-23 09:54:08.257526
Garden Labourer	Landscape construction and maintenance assistant	low	Public Liability $1M, Plant Damage Coverage	f	f	t	305	82	2025-08-23 09:54:08.257527	2025-08-23 09:54:08.257527
Landscape Assistant	Outdoor construction and planting helper	low	Public Liability $1M, Equipment Coverage	f	t	t	306	83	2025-08-23 09:54:08.257527	2025-08-23 09:54:08.257528
Road Traffic Controller	Site traffic management and safety coordination	high	Public Liability $10M, Traffic Control Certificate	t	t	t	307	84	2025-08-23 09:54:08.257528	2025-08-23 09:54:08.257529
Site Cleaner	Construction site cleaning and debris removal	low	Public Liability $1M, Equipment Coverage	f	t	t	308	85	2025-08-23 09:54:08.257529	2025-08-23 09:54:08.257529
Builders Cleaner	Post-construction cleanup specialist	medium	Public Liability $2M, Chemical Handling Basic	f	t	t	309	86	2025-08-23 09:54:08.25753	2025-08-23 09:54:08.25753
Cleaning Supervisor	Cleaning team coordination and quality control	low	Public Liability $2M, Team Management	f	t	t	310	87	2025-08-23 09:54:08.257531	2025-08-23 09:54:08.257531
Chimney Sweep	Chimney cleaning and maintenance specialist	high	Public Liability $2M, Fire Risk Coverage	t	t	t	311	88	2025-08-23 09:54:08.257531	2025-08-23 09:54:08.257532
Waste Management Operator	Site recycling, disposal, and waste coordination	medium	Public Liability $5M, Environmental Coverage	f	t	t	312	89	2025-08-23 09:54:08.257532	2025-08-23 09:54:08.257533
Solid Plasterer	Traditional solid plaster wall specialist	medium	Public Liability $2M, Materials Coverage	f	t	t	71	90	2025-08-23 09:54:08.257533	2025-08-23 09:54:08.257533
Fibrous Plasterer	Decorative ceiling and molding specialist	medium	Public Liability $2M, Specialist Materials $25k	f	t	t	72	91	2025-08-23 09:54:08.257534	2025-08-23 09:54:08.257534
Wall and Floor Tiler	Interior tiling specialist for wet areas	medium	Public Liability $2M, Waterproofing Warranty	f	t	t	81	92	2025-08-23 09:54:08.257535	2025-08-23 09:54:08.257535
Explosives Specialist	Controlled blasting and explosives expert	extreme	Public Liability $50M, Explosive Operations License	t	t	t	181	93	2025-08-23 09:54:08.257536	2025-08-23 09:54:08.257536
\.


--
-- Data for Name: contracts; Type: TABLE DATA; Schema: public; Owner: rateright_au
--

COPY public.contracts (job_id, contractor_id, worker_id, agreed_rate, rate_type, start_date, end_date, scope_of_work, independent_contractor_status, superannuation_required, workers_comp_covered, status, completion_status, payment_status, contractor_approval_date, worker_completion_date, contractor_signed, worker_signed, contractor_signed_date, worker_signed_date, contractor_reviewed, worker_reviewed, last_modified_by, contractor_rated, worker_rated, mutual_rating_completed_date, payment_terms, payment_schedule, id, created_at, updated_at, worker_agreed_resolve, contractor_agreed_resolve, review_hours_status, contractor_name, worker_name, contractor_email, contractor_phone, contractor_abn, contractor_business_name, worker_email, worker_phone, worker_abn, worker_business_name) FROM stdin;
38	33	18	45.00	hourly	2026-01-29	2026-02-27	need a carpenter for some framing on a shed	t	f	f	signed	not_started	pending	\N	\N	t	t	2026-01-29 15:29:28.672866	2026-01-29 15:29:38.759441	t	t	\N	f	f	\N	completion	\N	26	2026-01-29 15:29:06.137121	2026-01-29 15:29:38.761304	f	f	pending	markus lindo	Markus Lindo	markus2@rateright.com.au	0499999999	12349999999	\N	markus@rateright.com	0412345679	12345678912	\N
34	66	65	25.00	hourly	2026-01-20	2026-01-20	tie steel for slab and walls	t	f	f	completed	completed	paid	\N	2026-01-14 01:18:45.797539	t	t	2026-01-14 01:06:58.382152	2026-01-14 01:08:48.814237	t	t	\N	t	t	2026-01-14 01:18:45.814565	completion	\N	25	2026-01-14 01:03:35.976818	2026-01-14 01:18:45.821912	f	f	ready_for_closeout	Michael McLoughlin	Michael McLoughlin	rocky.mcloughlin@gmail.com	0423535353	96767867687	\N	mcloughlinmichael.r@gmail.com	0425656565	12312215616	\N
33	66	65	25.00	hourly	2026-01-10	2026-01-10	Steel fixing for ground floor slab pour. Tying mesh, setting chairs, edge bars. Must have own hand tools and white card. Early start, be on time.	t	f	f	completed	completed	paid	\N	2026-01-09 06:44:01.959542	t	t	2026-01-09 06:28:03.259738	2026-01-09 06:29:55.378008	t	t	\N	t	t	2026-01-09 06:44:01.971876	completion	\N	24	2026-01-09 06:26:04.496271	2026-01-09 06:44:01.978432	f	f	ready_for_closeout	Michael McLoughlin	Michael McLoughlin	rocky.mcloughlin@gmail.com	0423535353	96767867687	\N	mcloughlinmichael.r@gmail.com	0425656565	12312215616	\N
\.


--
-- Data for Name: disputes; Type: TABLE DATA; Schema: public; Owner: rateright_au
--

COPY public.disputes (contract_id, dispute_reference, dispute_type, raised_by, description, status, resolution_notes, resolved_by, resolved_at, id, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: file_uploads; Type: TABLE DATA; Schema: public; Owner: rateright_au
--

COPY public.file_uploads (id, user_id, filename, original_filename, file_type, file_size, storage_backend, storage_path, public_url, category, message_id, job_id, contract_id, width, height, cloud_metadata, is_deleted, deleted_at, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: invoices; Type: TABLE DATA; Schema: public; Owner: rateright_au
--

COPY public.invoices (payment_id, contractor_id, invoice_number, invoice_date, due_date, description, amount_ex_gst, gst_amount, total_amount, gst_rate, supplier_abn, supplier_name, buyer_abn, buyer_name, status, id, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: job_progress; Type: TABLE DATA; Schema: public; Owner: rateright_au
--

COPY public.job_progress (job_id, contract_id, status, progress_percentage, milestone_description, start_date, actual_completion_date, estimated_completion_date, worker_notes, contractor_notes, photos_urls, safety_incidents_reported, safety_compliance_maintained, daily_safety_checks_completed, updated_by, id, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: jobs; Type: TABLE DATA; Schema: public; Owner: rateright_au
--

COPY public.jobs (title, description, contractor_id, category_id, location, budget_min, budget_max, hourly_rate, whs_requirements, insurance_required, white_card_required, start_datetime, duration, workers_needed, own_tools_required, own_transport_required, payment_terms, status, date_posted, deadline, applications_count, id, created_at, updated_at, accepted_workers_count) FROM stdin;
AC repairer	Repair a package ac unit.	43	69	Sydney	\N	\N	45.00	Category: Air Conditioning Mechanic. Risk Level: high.	t	t	2025-11-17 07:00:00	2 days	1	f	f	on_completion	open	2025-11-14 04:14:17.636528	\N	1	31	2025-11-14 04:14:17.636534	2025-11-21 05:01:25.166863	0
Civil ground works and concrete Bokkards	Need to dig around hobs and piur plinths for concrete bollards	54	17	Sydney	\N	\N	40.00	Category: Carpenter. Risk Level: medium.	f	t	2025-12-08 07:00:00	2 days	2	f	f	on_completion	open	2025-12-04 01:47:54.641927	\N	0	32	2025-12-04 01:47:54.641935	2025-12-04 01:47:54.641939	0
Steelfixer - Commercial Pour	Steel fixing for ground floor slab pour. Tying mesh, setting chairs, edge bars. Must have own hand tools and white card. Early start, be on time.	66	24	Sydney	\N	\N	25.00	the usual	t	t	2026-01-10 07:00:00	4 hours	1	f	f	on_completion	assigned	2026-01-09 06:15:22.849945	\N	1	33	2026-01-09 06:15:22.849956	2026-01-09 06:26:04.482533	1
Steelfixer Needed - Sydney CBD Project	tie steel for slab and walls	66	24	Sydney	\N	\N	25.00	the usual	t	t	2026-01-20 07:00:00	4 hours	1	f	f	on_completion	assigned	2026-01-14 01:02:22.776072	\N	1	34	2026-01-14 01:02:22.776081	2026-01-14 01:03:35.962459	1
Formworker Needed ASAP at Hornsby	Need formworkers for slab on ground pour. Ongoing work for the right candidate.	54	34	Sydney	\N	\N	45.00	Category: Formworker. Risk Level: high.	t	t	2026-01-30 07:00:00	8	2	f	f	on_completion	open	2026-01-29 05:22:50.871803	\N	0	35	2026-01-29 05:22:50.871811	2026-01-29 05:22:50.871816	0
Slab on Ground Formwork Parramatta	Slab on Ground, V drains and footpaths	54	34	Sydney	\N	\N	45.00	Category: Formworker. Risk Level: high.	t	t	2026-01-30 07:00:00	8	2	f	f	on_completion	open	2026-01-29 05:24:19.03029	\N	0	36	2026-01-29 05:24:19.030296	2026-01-29 05:24:19.030299	0
Culvert and Pits Formwork	Need formworkers for forming up insitu pits and laying precast culverts	54	34	Sydney	\N	\N	50.00	Category: Formworker. Risk Level: high.	t	t	2026-02-02 07:00:00	10	3	f	f	on_completion	open	2026-01-29 05:26:12.16627	\N	0	37	2026-01-29 05:26:12.166277	2026-01-29 05:26:12.166281	0
Personal Renovation	need a carpenter for some framing on a shed	33	17	Other	\N	\N	45.00	Category: Carpenter. Risk Level: medium.	t	t	2026-01-29 07:00:00	8	1	f	f	on_completion	assigned	2026-01-29 15:28:47.261329	\N	1	38	2026-01-29 15:28:47.261335	2026-01-29 15:29:06.126854	1
Air conditioning	Installation mechanic required for commercial projects	46	69	Sydney	\N	\N	45.00	Category: Air Conditioning Mechanic. Risk Level: high.	t	t	2025-11-17 07:00:00	3-5 days	2	f	f	on_completion	open	2025-11-14 02:12:40.249938	\N	0	30	2025-11-14 02:12:40.249944	2025-11-14 02:12:40.24995	0
\.


--
-- Data for Name: leaderboards; Type: TABLE DATA; Schema: public; Owner: rateright_au
--

COPY public.leaderboards (user_id, period_type, period_start, period_end, points_earned, rank_position, jobs_completed, avg_rating, safety_score, league_tier, id, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: messages; Type: TABLE DATA; Schema: public; Owner: rateright_au
--

COPY public.messages (sender_id, receiver_id, text, status, read_at, contract_id, job_id, id, created_at, updated_at, sender_name) FROM stdin;
1	2	ok	READ	2025-08-25 03:23:25.166025	\N	\N	1	2025-08-25 03:23:16.372124	2025-08-25 03:23:25.167666	Michael McLoughlin
2	1	hey hows it going	READ	2025-08-25 03:52:12.383625	\N	\N	2	2025-08-25 03:23:39.312006	2025-08-25 03:52:12.384907	Michael Rocco McLoughlin
1	2	hey hows it going	READ	2025-08-25 03:52:31.871231	\N	\N	3	2025-08-25 03:52:23.682726	2025-08-25 03:52:31.871825	Michael McLoughlin
2	1	ok	READ	2025-08-25 04:30:21.191103	\N	\N	4	2025-08-25 03:52:42.534053	2025-08-25 04:30:21.192482	Michael Rocco McLoughlin
12	1	Hi, Michael! Test message	READ	2025-09-21 06:20:59.376277	\N	\N	5	2025-09-20 20:02:13.08817	2025-09-21 06:20:59.377883	Angelica Belo
12	1	Hi, Michael! Test message	READ	2025-09-21 06:20:59.385957	\N	\N	6	2025-09-20 20:02:14.344826	2025-09-21 06:20:59.38631	Angelica Belo
1	12	recived	READ	2025-09-21 18:13:50.642054	\N	\N	7	2025-09-21 06:21:04.66861	2025-09-21 18:13:50.64402	Michael McLoughlin
1	12	Is Applications still broken or has it been fixed? When we pushed the new landing page, I think my fixes didn’t save to the main branch and got overwritten. I pushed them live from another branch, but I believe I’ve fixed it now. Let’s double-check when we get a chance.	READ	2025-09-21 18:13:50.651187	\N	\N	8	2025-09-21 06:23:59.99943	2025-09-21 18:13:50.651614	Michael McLoughlin
1	12	test	READ	2025-09-21 18:13:50.655741	\N	\N	9	2025-09-21 07:11:44.567917	2025-09-21 18:13:50.656023	Michael McLoughlin
1	12	test	READ	2025-09-21 18:13:50.660573	\N	\N	10	2025-09-21 08:08:50.648738	2025-09-21 18:13:50.660927	Michael McLoughlin
12	1	It works! but I added a new bug	READ	2025-09-22 07:16:00.567381	\N	\N	11	2025-09-21 18:17:12.561023	2025-09-22 07:16:00.568848	Angelica Belo
1	12	hello is this fixed?	READ	2025-10-01 19:20:07.662595	\N	\N	12	2025-09-28 10:21:38.927313	2025-10-01 19:20:07.664561	Michael McLoughlin
12	1	Still not fixed	READ	2025-10-04 00:09:29.069949	\N	\N	13	2025-10-01 19:20:16.837818	2025-10-04 00:09:29.072014	Angelica Belo
12	1	- Angelica	READ	2025-10-04 00:09:29.08059	\N	\N	14	2025-10-01 19:20:51.335038	2025-10-04 00:09:29.081037	Angelica Belo
1	12	result! i'm on fire fire today.	READ	2025-10-06 09:12:26.1748	\N	\N	15	2025-10-04 01:29:35.736721	2025-10-06 09:12:26.176338	Michael McLoughlin
1	12	double result	READ	2025-10-06 09:12:26.269302	\N	\N	16	2025-10-04 01:30:59.170802	2025-10-06 09:12:26.269629	Michael McLoughlin
9	25	what time do i start	SENT	\N	\N	\N	17	2025-10-06 10:43:10.837002	2025-10-06 10:43:10.837005	Test Contractor
29	18	hello there	READ	2025-10-13 12:25:38.97165	\N	\N	18	2025-10-13 12:25:34.393269	2025-10-13 12:25:38.973378	Markus Lindo
18	29	yes hello	READ	2025-10-13 12:25:49.917599	\N	\N	19	2025-10-13 12:25:43.227282	2025-10-13 12:25:49.919629	Markus Lindo
29	18	good job on the tiling	READ	2025-10-14 10:21:31.192319	\N	\N	20	2025-10-14 10:21:25.08856	2025-10-14 10:21:31.193304	Markus Lindo
18	29	thank you very much	READ	2025-10-14 10:41:09.652218	\N	\N	21	2025-10-14 10:21:36.525123	2025-10-14 10:41:09.65319	Markus Lindo
34	31	Hey	SENT	\N	\N	\N	22	2025-10-14 14:05:24.913747	2025-10-14 14:05:24.913751	Angelica Contractor
34	31	Checking	SENT	\N	\N	\N	23	2025-10-14 14:05:30.165185	2025-10-14 14:05:30.165193	Angelica Contractor
34	31	asd	SENT	\N	\N	\N	24	2025-10-14 15:33:13.65243	2025-10-14 15:33:13.652433	Angelica Contractor
34	31	hey	SENT	\N	\N	\N	25	2025-10-14 15:49:05.522279	2025-10-14 15:49:05.522282	Angelica Contractor
34	31	sup	SENT	\N	\N	\N	26	2025-10-14 16:56:58.247829	2025-10-14 16:56:58.247833	Angelica Contractor
34	31	test	SENT	\N	\N	\N	27	2025-10-14 17:46:36.378945	2025-10-14 17:46:36.378951	Angelica Contractor
34	31	https://rateright.com.au/messages	SENT	\N	\N	\N	28	2025-10-14 17:46:45.308493	2025-10-14 17:46:45.308497	Angelica Contractor
12	1	test	SENT	\N	\N	\N	29	2025-10-14 17:46:58.758834	2025-10-14 17:46:58.75884	Angelica Belo
34	31	ayoo	SENT	\N	\N	\N	30	2025-10-14 17:47:38.098245	2025-10-14 17:47:38.098252	Angelica Contractor
12	1	test	SENT	\N	\N	\N	31	2025-10-14 17:48:06.560585	2025-10-14 17:48:06.560592	Angelica Belo
35	36	Hi! Thanks for accepting the job	READ	2025-10-15 10:33:47.464084	\N	\N	34	2025-10-15 10:33:17.811601	2025-10-15 10:33:47.465254	Contractor Test
36	35	No worries. I will be there soon	READ	2025-10-15 10:34:15.913526	\N	\N	35	2025-10-15 10:34:08.43213	2025-10-15 10:34:15.914509	Test Worker
35	36	It's in 10 days what do you mean	READ	2025-10-15 10:34:32.270521	\N	\N	36	2025-10-15 10:34:21.555412	2025-10-15 10:34:32.271612	Contractor Test
36	35	pretend it's been 10 days u dummy	READ	2025-10-15 10:34:33.286125	\N	\N	37	2025-10-15 10:34:31.698579	2025-10-15 10:34:33.287026	Test Worker
35	36	Don't go here ser	READ	2025-10-15 10:34:37.067811	\N	\N	38	2025-10-15 10:34:33.064866	2025-10-15 10:34:37.068205	Contractor Test
35	36	abort	READ	2025-10-15 10:34:37.075782	\N	\N	39	2025-10-15 10:34:35.454993	2025-10-15 10:34:37.076058	Contractor Test
36	35	knock knock	READ	2025-10-15 10:34:59.934677	\N	\N	40	2025-10-15 10:34:47.717519	2025-10-15 10:34:59.935357	Test Worker
35	36	who's there	READ	2025-10-15 10:45:47.453495	\N	\N	41	2025-10-15 10:35:05.44459	2025-10-15 10:45:47.453911	Contractor Test
35	18	my dino is better than ur dragon	READ	2025-10-15 10:54:27.001581	\N	\N	42	2025-10-15 10:54:26.931267	2025-10-15 10:54:27.002005	Contractor Test
18	35	no u	READ	2025-10-15 10:54:36.284326	\N	\N	43	2025-10-15 10:54:35.807081	2025-10-15 10:54:36.284731	Markus Lindo
18	35	ur mom gay	READ	2025-10-15 10:54:41.294003	\N	\N	44	2025-10-15 10:54:39.955587	2025-10-15 10:54:41.294925	Markus Lindo
18	35	click on u	READ	2025-10-15 10:55:20.40787	\N	\N	45	2025-10-15 10:55:04.708759	2025-10-15 10:55:20.408282	Markus Lindo
34	12	Hi!	READ	2025-10-22 12:57:54.590716	\N	\N	32	2025-10-14 17:52:43.142305	2025-10-22 12:57:54.592707	Angelica Contractor
34	12	supp	READ	2025-10-22 12:57:54.606879	\N	\N	33	2025-10-14 17:56:53.086773	2025-10-22 12:57:54.607425	Angelica Contractor
12	34	whats up	SENT	\N	\N	\N	47	2025-10-22 12:57:59.547986	2025-10-22 12:57:59.547993	Angelica Belo
39	40	sup	READ	2025-10-22 13:23:51.876465	\N	\N	50	2025-10-22 13:23:28.92198	2025-10-22 13:23:51.877384	Angelica Tradie
43	2	What’s the craic	READ	2025-10-28 10:02:51.49022	\N	\N	53	2025-10-28 09:58:57.979789	2025-10-28 10:02:51.491354	Stephen Joyce
2	43	No worries. But very clunky	READ	2025-10-28 10:04:18.09645	\N	\N	54	2025-10-28 10:03:22.419154	2025-10-28 10:04:18.096985	Michael Rocco McLoughlin
39	40	sdfdsf	SENT	\N	\N	\N	55	2025-11-07 09:35:53.232292	2025-11-07 09:35:53.232298	Angelica Tradie
35	18	hi	READ	2025-11-14 13:46:02.165804	\N	\N	46	2025-10-22 12:47:02.204212	2025-11-14 13:46:02.167791	Contractor Test
35	18	sup	READ	2025-11-14 13:46:02.177457	\N	\N	48	2025-10-22 13:00:28.042879	2025-11-14 13:46:02.178005	Contractor Test
35	18	hey	READ	2025-11-14 13:46:02.185989	\N	\N	49	2025-10-22 13:02:05.419815	2025-11-14 13:46:02.186336	Contractor Test
35	18	suo	READ	2025-11-14 13:46:02.193576	\N	\N	51	2025-10-22 13:55:07.089253	2025-11-14 13:46:02.193869	Contractor Test
35	18	asdas	READ	2025-11-14 13:46:02.202126	\N	\N	52	2025-10-24 04:22:13.345859	2025-11-14 13:46:02.202477	Contractor Test
39	40	supp	SENT	\N	\N	\N	56	2025-11-28 03:04:31.446511	2025-11-28 03:04:31.446521	Angelica Tradie
51	58	Hey Dwayne, Michael here - founder of RateRight. Just saw you signed up, appreciate you checking us out. Straight up - we're brand new, still building. But I'm a steelfixer myself, 30 years in the game, and I'm building this to cut out the agency bullshit. What kind of work are you looking to fill? Keen to know what brought you to us.	SENT	\N	\N	\N	57	2025-12-09 09:05:32.521288	2025-12-09 09:05:32.521294	Admin RateRight
51	57	Hey Des ya bollocks, saw you signed up. Sound man.	SENT	\N	\N	\N	58	2025-12-09 09:07:30.613515	2025-12-09 09:07:30.61352	Admin RateRight
51	56	Hey Andrea, Michael here - founder of RateRight. Thanks for signing up mate. I'm a steelfixer myself, building this to give workers a fair go. Any questions or feedback, just shout.	SENT	\N	\N	\N	59	2025-12-09 09:09:07.452142	2025-12-09 09:09:07.452148	Admin RateRight
51	55	Message him same energy as Dwayne:   Hey Dimitar, Michael here - founder of RateRight. Saw you signed up last week, thanks for checking us out. We're just getting started - I'm a steelfixer myself, 30 years in the trade. What kind of work are you looking to fill? Keen to hear what brought you to us.	SENT	\N	\N	\N	60	2025-12-09 09:10:23.729344	2025-12-09 09:10:23.72935	Admin RateRight
51	53	Thanks lad for checking out the site, appreciate it.	SENT	\N	\N	\N	62	2025-12-09 09:13:29.846075	2025-12-09 09:13:29.846081	Admin RateRight
51	52	Oi, are these messages working? If they are answer me back	READ	2025-12-09 10:10:18.651691	\N	\N	63	2025-12-09 09:14:12.003553	2025-12-09 10:10:18.652626	Admin RateRight
52	51	Yes	SENT	\N	\N	\N	64	2025-12-09 10:10:29.663794	2025-12-09 10:10:29.6638	Roy McLoughlin
51	54	hey you bollox	READ	2026-01-29 05:20:01.726815	\N	\N	61	2025-12-09 09:12:25.493691	2026-01-29 05:20:01.728023	Admin RateRight
\.


--
-- Data for Name: notification_preferences; Type: TABLE DATA; Schema: public; Owner: rateright_au
--

COPY public.notification_preferences (user_id, notification_type, email_enabled, email_frequency, sms_enabled, sms_frequency, push_web_enabled, push_mobile_enabled, in_app_enabled, quiet_hours_start, quiet_hours_end, respect_weekends, consent_given, consent_date, id, created_at, updated_at) FROM stdin;
15	JOB_APPLICATION_UPDATE	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-09-17 09:36:55.515807	5	2025-09-17 09:36:55.517041	2025-09-17 09:36:55.517043
12	MESSAGE_RECEIVED	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-09-21 06:21:04.694201	6	2025-09-21 06:21:04.695691	2025-09-21 06:21:04.695693
9	JOB_APPLICATION_UPDATE	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-10-06 10:36:19.904066	7	2025-10-06 10:36:19.905194	2025-10-06 10:36:19.905196
25	MESSAGE_RECEIVED	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-10-06 10:43:10.853706	8	2025-10-06 10:43:10.85476	2025-10-06 10:43:10.854762
33	JOB_APPLICATION_UPDATE	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-10-10 12:06:44.844237	9	2025-10-10 12:06:44.845424	2025-10-10 12:06:44.845426
3	JOB_MATCH	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-10-13 12:05:55.600199	10	2025-10-13 12:05:55.602087	2025-10-13 12:05:55.60209
4	JOB_MATCH	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-10-13 12:05:55.680352	11	2025-10-13 12:05:55.680814	2025-10-13 12:05:55.680815
10	JOB_MATCH	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-10-13 12:05:55.857503	12	2025-10-13 12:05:55.857945	2025-10-13 12:05:55.857946
12	JOB_MATCH	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-10-13 12:05:55.926137	13	2025-10-13 12:05:55.926421	2025-10-13 12:05:55.926423
17	JOB_MATCH	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-10-13 12:05:55.990764	14	2025-10-13 12:05:55.991249	2025-10-13 12:05:55.991251
18	JOB_MATCH	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-10-13 12:05:56.061412	15	2025-10-13 12:05:56.061832	2025-10-13 12:05:56.061833
19	JOB_MATCH	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-10-13 12:05:56.131157	16	2025-10-13 12:05:56.131504	2025-10-13 12:05:56.131506
27	JOB_MATCH	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-10-13 12:05:56.200684	17	2025-10-13 12:05:56.20099	2025-10-13 12:05:56.200991
29	JOB_APPLICATION_UPDATE	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-10-13 12:06:22.005201	18	2025-10-13 12:06:22.006625	2025-10-13 12:06:22.006627
18	MESSAGE_RECEIVED	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-10-13 12:25:34.42096	19	2025-10-13 12:25:34.422025	2025-10-13 12:25:34.422026
29	MESSAGE_RECEIVED	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-10-13 12:25:43.25878	20	2025-10-13 12:25:43.259203	2025-10-13 12:25:43.259205
31	MESSAGE_RECEIVED	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-10-14 14:05:24.94597	21	2025-10-14 14:05:24.947262	2025-10-14 14:05:24.947264
34	JOB_APPLICATION_UPDATE	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-10-14 16:31:06.21906	22	2025-10-14 16:31:06.220215	2025-10-14 16:31:06.220216
36	JOB_MATCH	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-10-15 10:20:17.154377	23	2025-10-15 10:20:17.155561	2025-10-15 10:20:17.155564
35	JOB_APPLICATION_UPDATE	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-10-15 10:24:02.898717	24	2025-10-15 10:24:02.899962	2025-10-15 10:24:02.899965
36	MESSAGE_RECEIVED	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-10-15 10:33:17.832853	25	2025-10-15 10:33:17.834961	2025-10-15 10:33:17.834968
35	MESSAGE_RECEIVED	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-10-15 10:34:08.444829	26	2025-10-15 10:34:08.445936	2025-10-15 10:34:08.445939
18	JOB_APPLICATION_UPDATE	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-10-20 09:14:42.917043	27	2025-10-20 09:14:42.918259	2025-10-20 09:14:42.918262
14	JOB_MATCH	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-10-20 10:09:50.664752	28	2025-10-20 10:09:50.665288	2025-10-20 10:09:50.665291
12	CONTRACT_AWARDED	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-10-22 07:09:24.502956	29	2025-10-22 07:09:24.504218	2025-10-22 07:09:24.504221
35	CONTRACT_AWARDED	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-10-22 07:10:00.804468	30	2025-10-22 07:10:00.806047	2025-10-22 07:10:00.806051
34	MESSAGE_RECEIVED	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-10-22 12:57:59.585839	31	2025-10-22 12:57:59.587428	2025-10-22 12:57:59.587433
40	JOB_APPLICATION_UPDATE	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-10-22 13:21:01.91061	32	2025-10-22 13:21:01.912073	2025-10-22 13:21:01.912077
39	CONTRACT_AWARDED	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-10-22 13:21:19.787034	33	2025-10-22 13:21:19.787383	2025-10-22 13:21:19.787385
40	CONTRACT_AWARDED	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-10-22 13:21:50.451047	34	2025-10-22 13:21:50.451403	2025-10-22 13:21:50.451405
40	MESSAGE_RECEIVED	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-10-22 13:23:28.957411	35	2025-10-22 13:23:28.958462	2025-10-22 13:23:28.958464
18	CONTRACT_AWARDED	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-10-23 18:35:28.209587	36	2025-10-23 18:35:28.210665	2025-10-23 18:35:28.210668
29	CONTRACT_AWARDED	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-10-23 18:35:49.426571	37	2025-10-23 18:35:49.427899	2025-10-23 18:35:49.427902
37	JOB_MATCH	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-10-28 09:01:57.941627	38	2025-10-28 09:01:57.942758	2025-10-28 09:01:57.942761
38	JOB_MATCH	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-10-28 09:01:58.012517	39	2025-10-28 09:01:58.012853	2025-10-28 09:01:58.012855
39	JOB_MATCH	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-10-28 09:01:58.075914	40	2025-10-28 09:01:58.076207	2025-10-28 09:01:58.076209
41	JOB_MATCH	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-10-28 09:01:58.147389	41	2025-10-28 09:01:58.147677	2025-10-28 09:01:58.147678
43	JOB_APPLICATION_UPDATE	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-10-28 09:57:28.721376	42	2025-10-28 09:57:28.721706	2025-10-28 09:57:28.721708
43	MESSAGE_RECEIVED	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-10-28 10:03:22.441893	44	2025-10-28 10:03:22.443416	2025-10-28 10:03:22.443421
43	CONTRACT_AWARDED	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-10-28 10:04:00.997869	45	2025-10-28 10:04:00.998336	2025-10-28 10:04:00.998339
45	JOB_MATCH	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-11-14 02:12:40.477447	46	2025-11-14 02:12:40.478803	2025-11-14 02:12:40.478806
52	SYSTEM_ANNOUNCEMENT	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	f	\N	47	2025-12-03 16:04:12.939	2025-12-03 16:04:12.939006
53	SYSTEM_ANNOUNCEMENT	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-12-03 18:53:31.218029	48	2025-12-03 18:53:31.225641	2025-12-03 18:53:31.225649
54	SYSTEM_ANNOUNCEMENT	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-12-04 01:42:15.788999	49	2025-12-04 01:42:15.795098	2025-12-04 01:42:15.795103
52	JOB_MATCH	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-12-04 01:47:54.739444	50	2025-12-04 01:47:54.741079	2025-12-04 01:47:54.741084
48	JOB_MATCH	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-12-04 01:47:54.840957	51	2025-12-04 01:47:54.841337	2025-12-04 01:47:54.84134
49	JOB_MATCH	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-12-04 01:47:54.855813	52	2025-12-04 01:47:54.856079	2025-12-04 01:47:54.856081
50	JOB_MATCH	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-12-04 01:47:54.87244	53	2025-12-04 01:47:54.872963	2025-12-04 01:47:54.872966
55	SYSTEM_ANNOUNCEMENT	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	f	\N	54	2025-12-04 04:43:54.615157	2025-12-04 04:43:54.615159
56	SYSTEM_ANNOUNCEMENT	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-12-05 01:19:11.183226	55	2025-12-05 01:19:11.191854	2025-12-05 01:19:11.191859
57	SYSTEM_ANNOUNCEMENT	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-12-05 20:20:41.623552	56	2025-12-05 20:20:41.628712	2025-12-05 20:20:41.628715
58	SYSTEM_ANNOUNCEMENT	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-12-09 08:10:09.228662	57	2025-12-09 08:10:09.236326	2025-12-09 08:10:09.236332
58	MESSAGE_RECEIVED	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-12-09 09:05:32.550294	58	2025-12-09 09:05:32.551801	2025-12-09 09:05:32.551806
57	MESSAGE_RECEIVED	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-12-09 09:07:30.63584	59	2025-12-09 09:07:30.636257	2025-12-09 09:07:30.63626
56	MESSAGE_RECEIVED	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-12-09 09:09:07.483792	60	2025-12-09 09:09:07.484237	2025-12-09 09:09:07.48424
55	MESSAGE_RECEIVED	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-12-09 09:10:23.763396	61	2025-12-09 09:10:23.764483	2025-12-09 09:10:23.764485
54	MESSAGE_RECEIVED	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-12-09 09:12:25.534227	62	2025-12-09 09:12:25.535611	2025-12-09 09:12:25.535614
53	MESSAGE_RECEIVED	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-12-09 09:13:29.8769	63	2025-12-09 09:13:29.878205	2025-12-09 09:13:29.878208
52	MESSAGE_RECEIVED	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-12-09 09:14:12.037332	64	2025-12-09 09:14:12.038344	2025-12-09 09:14:12.038349
51	MESSAGE_RECEIVED	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-12-09 10:10:29.7228	65	2025-12-09 10:10:29.72329	2025-12-09 10:10:29.723293
59	SYSTEM_ANNOUNCEMENT	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2025-12-11 03:03:54.497014	66	2025-12-11 03:03:54.501766	2025-12-11 03:03:54.50177
60	SYSTEM_ANNOUNCEMENT	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2026-01-05 10:19:32.470741	67	2026-01-05 10:19:32.476396	2026-01-05 10:19:32.476401
61	SYSTEM_ANNOUNCEMENT	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2026-01-07 18:04:13.612103	68	2026-01-07 18:04:13.618351	2026-01-07 18:04:13.61836
64	SYSTEM_ANNOUNCEMENT	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	f	\N	71	2026-01-09 05:55:00.725398	2026-01-09 05:55:00.725403
65	SYSTEM_ANNOUNCEMENT	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2026-01-09 05:58:27.911919	72	2026-01-09 05:58:27.914294	2026-01-09 05:58:27.914297
66	SYSTEM_ANNOUNCEMENT	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2026-01-09 06:01:41.500532	73	2026-01-09 06:01:41.507191	2026-01-09 06:01:41.507197
59	JOB_MATCH	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2026-01-09 06:15:22.953151	74	2026-01-09 06:15:22.954427	2026-01-09 06:15:22.954431
57	JOB_MATCH	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2026-01-09 06:15:23.162976	75	2026-01-09 06:15:23.163586	2026-01-09 06:15:23.16359
61	JOB_MATCH	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2026-01-09 06:15:23.203402	76	2026-01-09 06:15:23.203751	2026-01-09 06:15:23.203754
65	JOB_MATCH	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2026-01-09 06:15:23.22599	77	2026-01-09 06:15:23.226343	2026-01-09 06:15:23.226345
66	JOB_APPLICATION_UPDATE	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2026-01-09 06:25:01.254342	78	2026-01-09 06:25:01.254683	2026-01-09 06:25:01.254685
65	CONTRACT_AWARDED	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2026-01-09 06:26:04.5315	79	2026-01-09 06:26:04.53195	2026-01-09 06:26:04.531953
66	CONTRACT_AWARDED	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	t	2026-01-09 06:29:55.405186	80	2026-01-09 06:29:55.40566	2026-01-09 06:29:55.405663
67	SYSTEM_ANNOUNCEMENT	t	IMMEDIATE	f	DISABLED	t	t	t	21:00:00	07:00:00	t	f	\N	81	2026-02-19 02:16:43.40189	2026-02-19 02:16:43.401893
\.


--
-- Data for Name: notification_templates; Type: TABLE DATA; Schema: public; Owner: rateright_au
--

COPY public.notification_templates (notification_type, channel, subject_template, body_template, html_template, template_name, description, includes_unsubscribe, privacy_compliant, is_active, id, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: notifications; Type: TABLE DATA; Schema: public; Owner: rateright_au
--

COPY public.notifications (user_id, notification_type, title, content, channels_attempted, channels_delivered, channels_failed, status, scheduled_for, sent_at, delivered_at, read_at, priority, category, action_url, requires_consent, business_hours_only, error_count, last_error, id, created_at, updated_at) FROM stdin;
3	JOB_MATCH	New Job Posted	New Air Conditioning Mechanic job: Air conditioning in Sydney	\N	\N	\N	PENDING	2025-11-14 02:12:40.27074	\N	\N	\N	5	job	/jobs/30	f	f	0	\N	165	2025-11-14 02:12:40.270746	2025-11-14 02:12:40.270749
4	JOB_MATCH	New Job Posted	New Air Conditioning Mechanic job: Air conditioning in Sydney	\N	\N	\N	PENDING	2025-11-14 02:12:40.293695	\N	\N	\N	5	job	/jobs/30	f	f	0	\N	166	2025-11-14 02:12:40.293702	2025-11-14 02:12:40.293707
10	JOB_MATCH	New Job Posted	New Air Conditioning Mechanic job: Air conditioning in Sydney	\N	\N	\N	PENDING	2025-11-14 02:12:40.309333	\N	\N	\N	5	job	/jobs/30	f	f	0	\N	167	2025-11-14 02:12:40.309338	2025-11-14 02:12:40.309342
19	JOB_MATCH	New Job Posted	New Air Conditioning Mechanic job: Air conditioning in Sydney	\N	\N	\N	PENDING	2025-11-14 02:12:40.326606	\N	\N	\N	5	job	/jobs/30	f	f	0	\N	168	2025-11-14 02:12:40.326614	2025-11-14 02:12:40.326618
27	JOB_MATCH	New Job Posted	New Air Conditioning Mechanic job: Air conditioning in Sydney	\N	\N	\N	PENDING	2025-11-14 02:12:40.342032	\N	\N	\N	5	job	/jobs/30	f	f	0	\N	169	2025-11-14 02:12:40.342038	2025-11-14 02:12:40.342042
12	JOB_MATCH	New Job Posted	New Air Conditioning Mechanic job: Air conditioning in Sydney	\N	\N	\N	PENDING	2025-11-14 02:12:40.357087	\N	\N	\N	5	job	/jobs/30	f	f	0	\N	170	2025-11-14 02:12:40.357092	2025-11-14 02:12:40.357096
2	JOB_MATCH	New Job Posted	New Air Conditioning Mechanic job: Air conditioning in Sydney	\N	\N	\N	PENDING	2025-11-14 02:12:40.37269	\N	\N	\N	5	job	/jobs/30	f	f	0	\N	171	2025-11-14 02:12:40.372696	2025-11-14 02:12:40.3727
36	JOB_MATCH	New Job Posted	New Air Conditioning Mechanic job: Air conditioning in Sydney	\N	\N	\N	PENDING	2025-11-14 02:12:40.390798	\N	\N	\N	5	job	/jobs/30	f	f	0	\N	172	2025-11-14 02:12:40.390804	2025-11-14 02:12:40.390807
37	JOB_MATCH	New Job Posted	New Air Conditioning Mechanic job: Air conditioning in Sydney	\N	\N	\N	PENDING	2025-11-14 02:12:40.407364	\N	\N	\N	5	job	/jobs/30	f	f	0	\N	173	2025-11-14 02:12:40.407371	2025-11-14 02:12:40.407375
38	JOB_MATCH	New Job Posted	New Air Conditioning Mechanic job: Air conditioning in Sydney	\N	\N	\N	PENDING	2025-11-14 02:12:40.42434	\N	\N	\N	5	job	/jobs/30	f	f	0	\N	174	2025-11-14 02:12:40.424347	2025-11-14 02:12:40.42435
45	JOB_MATCH	New Job Posted	New Air Conditioning Mechanic job: Air conditioning in Sydney	\N	\N	\N	PENDING	2025-11-14 02:12:40.46395	\N	\N	\N	5	job	/jobs/30	f	f	0	\N	176	2025-11-14 02:12:40.463957	2025-11-14 02:12:40.463961
18	JOB_MATCH	New Job Posted	New Air Conditioning Mechanic job: Air conditioning in Sydney	\N	\N	\N	PENDING	2025-11-14 02:12:40.496888	\N	\N	\N	5	job	/jobs/30	f	f	0	\N	177	2025-11-14 02:12:40.496895	2025-11-14 02:12:40.4969
39	JOB_MATCH	New Job Posted	New Air Conditioning Mechanic job: Air conditioning in Sydney	\N	\N	\N	PENDING	2025-11-14 02:12:40.517926	\N	\N	\N	5	job	/jobs/30	f	f	0	\N	178	2025-11-14 02:12:40.517933	2025-11-14 02:12:40.517937
3	JOB_MATCH	New Job Posted	New Air Conditioning Mechanic job: AC repairer in Sydney	\N	\N	\N	PENDING	2025-11-14 04:14:17.65081	\N	\N	\N	5	job	/jobs/31	f	f	0	\N	179	2025-11-14 04:14:17.650844	2025-11-14 04:14:17.650847
4	JOB_MATCH	New Job Posted	New Air Conditioning Mechanic job: AC repairer in Sydney	\N	\N	\N	PENDING	2025-11-14 04:14:17.666355	\N	\N	\N	5	job	/jobs/31	f	f	0	\N	180	2025-11-14 04:14:17.666361	2025-11-14 04:14:17.666365
10	JOB_MATCH	New Job Posted	New Air Conditioning Mechanic job: AC repairer in Sydney	\N	\N	\N	PENDING	2025-11-14 04:14:17.683162	\N	\N	\N	5	job	/jobs/31	f	f	0	\N	181	2025-11-14 04:14:17.683168	2025-11-14 04:14:17.683171
19	JOB_MATCH	New Job Posted	New Air Conditioning Mechanic job: AC repairer in Sydney	\N	\N	\N	PENDING	2025-11-14 04:14:17.698654	\N	\N	\N	5	job	/jobs/31	f	f	0	\N	182	2025-11-14 04:14:17.698662	2025-11-14 04:14:17.698666
27	JOB_MATCH	New Job Posted	New Air Conditioning Mechanic job: AC repairer in Sydney	\N	\N	\N	PENDING	2025-11-14 04:14:17.715112	\N	\N	\N	5	job	/jobs/31	f	f	0	\N	183	2025-11-14 04:14:17.715118	2025-11-14 04:14:17.715121
12	JOB_MATCH	New Job Posted	New Air Conditioning Mechanic job: AC repairer in Sydney	\N	\N	\N	PENDING	2025-11-14 04:14:17.729339	\N	\N	\N	5	job	/jobs/31	f	f	0	\N	184	2025-11-14 04:14:17.729347	2025-11-14 04:14:17.729351
2	JOB_MATCH	New Job Posted	New Air Conditioning Mechanic job: AC repairer in Sydney	\N	\N	\N	PENDING	2025-11-14 04:14:17.745722	\N	\N	\N	5	job	/jobs/31	f	f	0	\N	185	2025-11-14 04:14:17.745729	2025-11-14 04:14:17.745734
36	JOB_MATCH	New Job Posted	New Air Conditioning Mechanic job: AC repairer in Sydney	\N	\N	\N	PENDING	2025-11-14 04:14:17.760468	\N	\N	\N	5	job	/jobs/31	f	f	0	\N	186	2025-11-14 04:14:17.760475	2025-11-14 04:14:17.76048
37	JOB_MATCH	New Job Posted	New Air Conditioning Mechanic job: AC repairer in Sydney	\N	\N	\N	PENDING	2025-11-14 04:14:17.77471	\N	\N	\N	5	job	/jobs/31	f	f	0	\N	187	2025-11-14 04:14:17.774716	2025-11-14 04:14:17.774719
38	JOB_MATCH	New Job Posted	New Air Conditioning Mechanic job: AC repairer in Sydney	\N	\N	\N	PENDING	2025-11-14 04:14:17.791934	\N	\N	\N	5	job	/jobs/31	f	f	0	\N	188	2025-11-14 04:14:17.791941	2025-11-14 04:14:17.791945
45	JOB_MATCH	New Job Posted	New Air Conditioning Mechanic job: AC repairer in Sydney	\N	\N	\N	PENDING	2025-11-14 04:14:17.821928	\N	\N	\N	5	job	/jobs/31	f	f	0	\N	190	2025-11-14 04:14:17.821936	2025-11-14 04:14:17.821941
18	JOB_MATCH	New Job Posted	New Air Conditioning Mechanic job: AC repairer in Sydney	\N	\N	\N	PENDING	2025-11-14 04:14:17.837981	\N	\N	\N	5	job	/jobs/31	f	f	0	\N	191	2025-11-14 04:14:17.837986	2025-11-14 04:14:17.83799
39	JOB_MATCH	New Job Posted	New Air Conditioning Mechanic job: AC repairer in Sydney	\N	\N	\N	PENDING	2025-11-14 04:14:17.853635	\N	\N	\N	5	job	/jobs/31	f	f	0	\N	192	2025-11-14 04:14:17.853642	2025-11-14 04:14:17.853646
41	JOB_MATCH	New Job Posted	New Air Conditioning Mechanic job: AC repairer in Sydney	\N	\N	\N	READ	2025-11-14 04:14:17.807002	\N	\N	2025-11-19 23:10:55.354298	5	job	/jobs/31	f	f	0	\N	189	2025-11-14 04:14:17.807008	2025-11-19 23:10:55.355228
41	JOB_MATCH	New Job Posted	New Air Conditioning Mechanic job: Air conditioning in Sydney	\N	\N	\N	READ	2025-11-14 02:12:40.441201	\N	\N	2025-11-19 23:11:43.882717	5	job	/jobs/30	f	f	0	\N	175	2025-11-14 02:12:40.441208	2025-11-19 23:11:43.884846
43	JOB_APPLICATION_UPDATE	New Application for 'AC repairer'	Eoin Corcoran has applied to your job 'AC repairer' in Sydney. Proposed rate: $45.00/hour.	\N	\N	\N	PENDING	2025-11-21 05:01:25.193347	\N	\N	\N	3	job_alerts	/applications/received?job_id=31	f	f	0	\N	193	2025-11-21 05:01:25.193355	2025-11-21 05:01:25.193358
40	MESSAGE_RECEIVED	New Message	New message from Angelica Tradie: supp...	\N	\N	\N	PENDING	2025-11-28 03:04:31.473441	\N	\N	\N	3	social	/messages	f	f	0	\N	194	2025-11-28 03:04:31.473447	2025-11-28 03:04:31.47345
3	JOB_MATCH	New Job Posted	New Carpenter job: Civil ground works and concrete Bokkards in Sydney	\N	\N	\N	PENDING	2025-12-04 01:47:54.660938	\N	\N	\N	5	job	/jobs/32	f	f	0	\N	195	2025-12-04 01:47:54.660945	2025-12-04 01:47:54.660951
4	JOB_MATCH	New Job Posted	New Carpenter job: Civil ground works and concrete Bokkards in Sydney	\N	\N	\N	PENDING	2025-12-04 01:47:54.681787	\N	\N	\N	5	job	/jobs/32	f	f	0	\N	196	2025-12-04 01:47:54.681793	2025-12-04 01:47:54.681797
10	JOB_MATCH	New Job Posted	New Carpenter job: Civil ground works and concrete Bokkards in Sydney	\N	\N	\N	PENDING	2025-12-04 01:47:54.696773	\N	\N	\N	5	job	/jobs/32	f	f	0	\N	197	2025-12-04 01:47:54.696779	2025-12-04 01:47:54.696782
12	JOB_MATCH	New Job Posted	New Carpenter job: Civil ground works and concrete Bokkards in Sydney	\N	\N	\N	PENDING	2025-12-04 01:47:54.709001	\N	\N	\N	5	job	/jobs/32	f	f	0	\N	198	2025-12-04 01:47:54.709006	2025-12-04 01:47:54.709009
27	JOB_MATCH	New Job Posted	New Carpenter job: Civil ground works and concrete Bokkards in Sydney	\N	\N	\N	PENDING	2025-12-04 01:47:54.721053	\N	\N	\N	5	job	/jobs/32	f	f	0	\N	199	2025-12-04 01:47:54.721061	2025-12-04 01:47:54.721066
52	JOB_MATCH	New Job Posted	New Carpenter job: Civil ground works and concrete Bokkards in Sydney	\N	\N	\N	PENDING	2025-12-04 01:47:54.733606	\N	\N	\N	5	job	/jobs/32	f	f	0	\N	200	2025-12-04 01:47:54.733611	2025-12-04 01:47:54.733616
19	JOB_MATCH	New Job Posted	New Carpenter job: Civil ground works and concrete Bokkards in Sydney	\N	\N	\N	PENDING	2025-12-04 01:47:54.75523	\N	\N	\N	5	job	/jobs/32	f	f	0	\N	201	2025-12-04 01:47:54.755237	2025-12-04 01:47:54.755241
2	JOB_MATCH	New Job Posted	New Carpenter job: Civil ground works and concrete Bokkards in Sydney	\N	\N	\N	PENDING	2025-12-04 01:47:54.767587	\N	\N	\N	5	job	/jobs/32	f	f	0	\N	202	2025-12-04 01:47:54.767594	2025-12-04 01:47:54.767598
36	JOB_MATCH	New Job Posted	New Carpenter job: Civil ground works and concrete Bokkards in Sydney	\N	\N	\N	PENDING	2025-12-04 01:47:54.78096	\N	\N	\N	5	job	/jobs/32	f	f	0	\N	203	2025-12-04 01:47:54.780966	2025-12-04 01:47:54.780969
37	JOB_MATCH	New Job Posted	New Carpenter job: Civil ground works and concrete Bokkards in Sydney	\N	\N	\N	PENDING	2025-12-04 01:47:54.792529	\N	\N	\N	5	job	/jobs/32	f	f	0	\N	204	2025-12-04 01:47:54.792536	2025-12-04 01:47:54.792539
45	JOB_MATCH	New Job Posted	New Carpenter job: Civil ground works and concrete Bokkards in Sydney	\N	\N	\N	PENDING	2025-12-04 01:47:54.804061	\N	\N	\N	5	job	/jobs/32	f	f	0	\N	205	2025-12-04 01:47:54.804068	2025-12-04 01:47:54.804071
38	JOB_MATCH	New Job Posted	New Carpenter job: Civil ground works and concrete Bokkards in Sydney	\N	\N	\N	PENDING	2025-12-04 01:47:54.814517	\N	\N	\N	5	job	/jobs/32	f	f	0	\N	206	2025-12-04 01:47:54.814523	2025-12-04 01:47:54.814526
41	JOB_MATCH	New Job Posted	New Carpenter job: Civil ground works and concrete Bokkards in Sydney	\N	\N	\N	PENDING	2025-12-04 01:47:54.824451	\N	\N	\N	5	job	/jobs/32	f	f	0	\N	207	2025-12-04 01:47:54.824455	2025-12-04 01:47:54.824459
48	JOB_MATCH	New Job Posted	New Carpenter job: Civil ground works and concrete Bokkards in Sydney	\N	\N	\N	PENDING	2025-12-04 01:47:54.834708	\N	\N	\N	5	job	/jobs/32	f	f	0	\N	208	2025-12-04 01:47:54.834712	2025-12-04 01:47:54.834715
49	JOB_MATCH	New Job Posted	New Carpenter job: Civil ground works and concrete Bokkards in Sydney	\N	\N	\N	PENDING	2025-12-04 01:47:54.851093	\N	\N	\N	5	job	/jobs/32	f	f	0	\N	209	2025-12-04 01:47:54.851098	2025-12-04 01:47:54.8511
50	JOB_MATCH	New Job Posted	New Carpenter job: Civil ground works and concrete Bokkards in Sydney	\N	\N	\N	PENDING	2025-12-04 01:47:54.865693	\N	\N	\N	5	job	/jobs/32	f	f	0	\N	210	2025-12-04 01:47:54.865698	2025-12-04 01:47:54.865701
39	JOB_MATCH	New Job Posted	New Carpenter job: Civil ground works and concrete Bokkards in Sydney	\N	\N	\N	PENDING	2025-12-04 01:47:54.89398	\N	\N	\N	5	job	/jobs/32	f	f	0	\N	212	2025-12-04 01:47:54.893985	2025-12-04 01:47:54.893988
18	JOB_MATCH	New Job Posted	New Carpenter job: Civil ground works and concrete Bokkards in Sydney	\N	\N	\N	READ	2025-12-04 01:47:54.883204	\N	\N	2025-12-11 01:05:47.67419	5	job	/jobs/32	f	f	0	\N	211	2025-12-04 01:47:54.88321	2025-12-11 01:05:47.675124
58	MESSAGE_RECEIVED	New Message	New message from Admin RateRight: Hey Dwayne, Michael here - founder of RateRight. J...	["in_app", "email", "push_web", "push_mobile"]	["in_app", "email", "push_web", "push_mobile"]	\N	DELIVERED	2025-12-09 09:05:32.538046	2025-12-09 09:05:33.008668	2025-12-09 09:05:33.008657	\N	3	social	/messages	f	f	0	\N	213	2025-12-09 09:05:32.538054	2025-12-09 09:05:33.009563
3	JOB_MATCH	New Job Posted	New Steelfixer job: Steelfixer - Commercial Pour in Sydney	\N	\N	\N	PENDING	2026-01-09 06:15:22.871489	\N	\N	\N	5	job	/jobs/33	f	f	0	\N	221	2026-01-09 06:15:22.871496	2026-01-09 06:15:22.871499
57	MESSAGE_RECEIVED	New Message	New message from Admin RateRight: Hey Des ya bollocks, saw you signed up. Sound man....	["in_app", "email", "push_web", "push_mobile"]	["in_app", "email", "push_web", "push_mobile"]	\N	DELIVERED	2025-12-09 09:07:30.627424	2025-12-09 09:07:31.836077	2025-12-09 09:07:31.836069	\N	3	social	/messages	f	f	0	\N	214	2025-12-09 09:07:30.627432	2025-12-09 09:07:31.837016
4	JOB_MATCH	New Job Posted	New Steelfixer job: Steelfixer - Commercial Pour in Sydney	\N	\N	\N	PENDING	2026-01-09 06:15:22.89813	\N	\N	\N	5	job	/jobs/33	f	f	0	\N	222	2026-01-09 06:15:22.898138	2026-01-09 06:15:22.898142
56	MESSAGE_RECEIVED	New Message	New message from Admin RateRight: Hey Andrea, Michael here - founder of RateRight. T...	["in_app", "email", "push_web", "push_mobile"]	["in_app", "email", "push_web", "push_mobile"]	\N	DELIVERED	2025-12-09 09:09:07.471913	2025-12-09 09:09:08.74495	2025-12-09 09:09:08.744941	\N	3	social	/messages	f	f	0	\N	215	2025-12-09 09:09:07.471922	2025-12-09 09:09:08.74616
10	JOB_MATCH	New Job Posted	New Steelfixer job: Steelfixer - Commercial Pour in Sydney	\N	\N	\N	PENDING	2026-01-09 06:15:22.914926	\N	\N	\N	5	job	/jobs/33	f	f	0	\N	223	2026-01-09 06:15:22.914933	2026-01-09 06:15:22.914937
55	MESSAGE_RECEIVED	New Message	New message from Admin RateRight: Message him same energy as Dwayne:   Hey Dimitar, ...	["in_app", "email", "push_web", "push_mobile"]	["in_app", "email", "push_web", "push_mobile"]	\N	DELIVERED	2025-12-09 09:10:23.751463	2025-12-09 09:10:25.095338	2025-12-09 09:10:25.095329	\N	3	social	/messages	f	f	0	\N	216	2025-12-09 09:10:23.751468	2025-12-09 09:10:25.096229
12	JOB_MATCH	New Job Posted	New Steelfixer job: Steelfixer - Commercial Pour in Sydney	\N	\N	\N	PENDING	2026-01-09 06:15:22.930901	\N	\N	\N	5	job	/jobs/33	f	f	0	\N	224	2026-01-09 06:15:22.930907	2026-01-09 06:15:22.930911
59	JOB_MATCH	New Job Posted	New Steelfixer job: Steelfixer - Commercial Pour in Sydney	\N	\N	\N	PENDING	2026-01-09 06:15:22.945736	\N	\N	\N	5	job	/jobs/33	f	f	0	\N	225	2026-01-09 06:15:22.945743	2026-01-09 06:15:22.945748
53	MESSAGE_RECEIVED	New Message	New message from Admin RateRight: Thanks lad for checking out the site, appreciate i...	["in_app", "email", "push_web", "push_mobile"]	["in_app", "email", "push_web", "push_mobile"]	\N	DELIVERED	2025-12-09 09:13:29.865349	2025-12-09 09:13:30.32099	2025-12-09 09:13:30.320981	\N	3	social	/messages	f	f	0	\N	218	2025-12-09 09:13:29.865356	2025-12-09 09:13:30.321848
27	JOB_MATCH	New Job Posted	New Steelfixer job: Steelfixer - Commercial Pour in Sydney	\N	\N	\N	PENDING	2026-01-09 06:15:22.970409	\N	\N	\N	5	job	/jobs/33	f	f	0	\N	226	2026-01-09 06:15:22.970417	2026-01-09 06:15:22.970421
52	JOB_MATCH	New Job Posted	New Steelfixer job: Steelfixer - Commercial Pour in Sydney	\N	\N	\N	PENDING	2026-01-09 06:15:22.988556	\N	\N	\N	5	job	/jobs/33	f	f	0	\N	227	2026-01-09 06:15:22.988563	2026-01-09 06:15:22.988567
52	MESSAGE_RECEIVED	New Message	New message from Admin RateRight: Oi, are these messages working? If they are answer...	["in_app", "email", "push_web", "push_mobile"]	["in_app", "email", "push_web", "push_mobile"]	\N	READ	2025-12-09 09:14:12.026047	2025-12-09 09:14:12.439347	2025-12-09 09:14:12.439339	2025-12-09 10:10:15.300451	3	social	/messages	f	f	0	\N	219	2025-12-09 09:14:12.026053	2025-12-09 10:10:15.301048
19	JOB_MATCH	New Job Posted	New Steelfixer job: Steelfixer - Commercial Pour in Sydney	\N	\N	\N	PENDING	2026-01-09 06:15:23.006631	\N	\N	\N	5	job	/jobs/33	f	f	0	\N	228	2026-01-09 06:15:23.006642	2026-01-09 06:15:23.006648
51	MESSAGE_RECEIVED	New Message	New message from Roy McLoughlin: Yes...	["in_app", "email", "push_web", "push_mobile"]	["in_app", "email", "push_web", "push_mobile"]	\N	DELIVERED	2025-12-09 10:10:29.705664	2025-12-09 10:10:30.273493	2025-12-09 10:10:30.273482	\N	3	social	/messages	f	f	0	\N	220	2025-12-09 10:10:29.705672	2025-12-09 10:10:30.273898
36	JOB_MATCH	New Job Posted	New Steelfixer job: Steelfixer - Commercial Pour in Sydney	\N	\N	\N	PENDING	2026-01-09 06:15:23.021301	\N	\N	\N	5	job	/jobs/33	f	f	0	\N	229	2026-01-09 06:15:23.021307	2026-01-09 06:15:23.021311
37	JOB_MATCH	New Job Posted	New Steelfixer job: Steelfixer - Commercial Pour in Sydney	\N	\N	\N	PENDING	2026-01-09 06:15:23.035082	\N	\N	\N	5	job	/jobs/33	f	f	0	\N	230	2026-01-09 06:15:23.035089	2026-01-09 06:15:23.035094
45	JOB_MATCH	New Job Posted	New Steelfixer job: Steelfixer - Commercial Pour in Sydney	\N	\N	\N	PENDING	2026-01-09 06:15:23.048442	\N	\N	\N	5	job	/jobs/33	f	f	0	\N	231	2026-01-09 06:15:23.048448	2026-01-09 06:15:23.048452
38	JOB_MATCH	New Job Posted	New Steelfixer job: Steelfixer - Commercial Pour in Sydney	\N	\N	\N	PENDING	2026-01-09 06:15:23.064434	\N	\N	\N	5	job	/jobs/33	f	f	0	\N	232	2026-01-09 06:15:23.064443	2026-01-09 06:15:23.064448
41	JOB_MATCH	New Job Posted	New Steelfixer job: Steelfixer - Commercial Pour in Sydney	\N	\N	\N	PENDING	2026-01-09 06:15:23.080416	\N	\N	\N	5	job	/jobs/33	f	f	0	\N	233	2026-01-09 06:15:23.080423	2026-01-09 06:15:23.080426
48	JOB_MATCH	New Job Posted	New Steelfixer job: Steelfixer - Commercial Pour in Sydney	\N	\N	\N	PENDING	2026-01-09 06:15:23.096907	\N	\N	\N	5	job	/jobs/33	f	f	0	\N	234	2026-01-09 06:15:23.096913	2026-01-09 06:15:23.096917
49	JOB_MATCH	New Job Posted	New Steelfixer job: Steelfixer - Commercial Pour in Sydney	\N	\N	\N	PENDING	2026-01-09 06:15:23.111842	\N	\N	\N	5	job	/jobs/33	f	f	0	\N	235	2026-01-09 06:15:23.111848	2026-01-09 06:15:23.111851
50	JOB_MATCH	New Job Posted	New Steelfixer job: Steelfixer - Commercial Pour in Sydney	\N	\N	\N	PENDING	2026-01-09 06:15:23.126263	\N	\N	\N	5	job	/jobs/33	f	f	0	\N	236	2026-01-09 06:15:23.12627	2026-01-09 06:15:23.126274
18	JOB_MATCH	New Job Posted	New Steelfixer job: Steelfixer - Commercial Pour in Sydney	\N	\N	\N	PENDING	2026-01-09 06:15:23.140817	\N	\N	\N	5	job	/jobs/33	f	f	0	\N	237	2026-01-09 06:15:23.140823	2026-01-09 06:15:23.140827
57	JOB_MATCH	New Job Posted	New Steelfixer job: Steelfixer - Commercial Pour in Sydney	\N	\N	\N	PENDING	2026-01-09 06:15:23.155318	\N	\N	\N	5	job	/jobs/33	f	f	0	\N	238	2026-01-09 06:15:23.155324	2026-01-09 06:15:23.155327
39	JOB_MATCH	New Job Posted	New Steelfixer job: Steelfixer - Commercial Pour in Sydney	\N	\N	\N	PENDING	2026-01-09 06:15:23.18103	\N	\N	\N	5	job	/jobs/33	f	f	0	\N	239	2026-01-09 06:15:23.181037	2026-01-09 06:15:23.181042
61	JOB_MATCH	New Job Posted	New Steelfixer job: Steelfixer - Commercial Pour in Sydney	\N	\N	\N	PENDING	2026-01-09 06:15:23.196005	\N	\N	\N	5	job	/jobs/33	f	f	0	\N	240	2026-01-09 06:15:23.196011	2026-01-09 06:15:23.196014
65	CONTRACT_AWARDED	Application Accepted!	Your application for 'Steelfixer - Commercial Pour' was accepted. Contract #24 created and ready for review.	\N	\N	\N	READ	2026-01-09 06:26:04.52123	\N	\N	2026-01-09 06:30:33.589034	3	job_alerts	/contracts/24/review	f	f	0	\N	243	2026-01-09 06:26:04.521237	2026-01-09 06:30:33.590265
65	JOB_MATCH	New Job Posted	New Steelfixer job: Steelfixer - Commercial Pour in Sydney	\N	\N	\N	READ	2026-01-09 06:15:23.216416	\N	\N	2026-01-10 12:40:26.973088	5	job	/jobs/33	f	f	0	\N	241	2026-01-09 06:15:23.216422	2026-01-10 12:40:26.973386
66	JOB_APPLICATION_UPDATE	New Application for 'Steelfixer - Commercial Pour'	Michael McLoughlin has applied to your job 'Steelfixer - Commercial Pour' in Sydney. Proposed rate: $25.00/hour.	\N	\N	\N	READ	2026-01-09 06:25:01.241872	\N	\N	2026-01-14 01:13:29.117956	3	job_alerts	/applications/received?job_id=33	f	f	0	\N	242	2026-01-09 06:25:01.241879	2026-01-14 01:13:29.118931
54	MESSAGE_RECEIVED	New Message	New message from Admin RateRight: hey you bollox...	["in_app", "email", "push_web", "push_mobile"]	["in_app", "email", "push_web", "push_mobile"]	\N	READ	2025-12-09 09:12:25.517	2025-12-09 09:12:25.964579	2025-12-09 09:12:25.964561	2026-01-29 05:19:57.898065	3	social	/messages	f	f	0	\N	217	2025-12-09 09:12:25.517006	2026-01-29 05:19:57.899269
65	CONTRACT_AWARDED	Contract Awaiting Your Signature	Contract #24 for 'Steelfixer - Commercial Pour' has been signed by the other party. Please review and sign.	\N	\N	\N	READ	2026-01-09 06:28:03.279002	\N	\N	2026-01-09 06:29:34.944018	3	contract	/contracts/24/review	f	f	0	\N	244	2026-01-09 06:28:03.279008	2026-01-09 06:29:34.945203
66	CONTRACT_AWARDED	Contract Awaiting Your Signature	Contract #24 for 'Steelfixer - Commercial Pour' has been signed by the other party. Please review and sign.	\N	\N	\N	READ	2026-01-09 06:29:55.397135	\N	\N	2026-01-09 06:41:15.639089	3	contract	/contracts/24/review	f	f	0	\N	245	2026-01-09 06:29:55.397142	2026-01-09 06:41:15.639559
66	CONTRACT_AWARDED	Contract Awaiting Your Signature	Contract #25 for 'Steelfixer Needed - Sydney CBD Project' has been signed by the other party. Please review and sign.	\N	\N	\N	READ	2026-01-14 01:08:48.837612	\N	\N	2026-01-14 01:09:43.926973	3	contract	/contracts/25/review	f	f	0	\N	271	2026-01-14 01:08:48.837618	2026-01-14 01:09:43.92766
65	CONTRACT_AWARDED	Contract is Now Active! 🎉	The contract for 'Steelfixer - Commercial Pour' is now active. Payment has been secured in escrow. You can start work!	["in_app", "email", "push_web", "push_mobile"]	["in_app", "email", "push_web", "push_mobile"]	\N	READ	2026-01-09 06:42:06.979421	2026-01-09 06:42:07.579544	2026-01-09 06:42:07.579532	2026-01-10 12:40:04.450594	1	contract	http://rateright.com.au/contracts/24	f	f	0	\N	246	2026-01-09 06:42:06.97943	2026-01-10 12:40:04.451011
3	JOB_MATCH	New Job Posted	New Steelfixer job: Steelfixer Needed - Sydney CBD Project in Sydney	\N	\N	\N	PENDING	2026-01-14 01:02:22.800434	\N	\N	\N	5	job	/jobs/34	f	f	0	\N	247	2026-01-14 01:02:22.800442	2026-01-14 01:02:22.800446
4	JOB_MATCH	New Job Posted	New Steelfixer job: Steelfixer Needed - Sydney CBD Project in Sydney	\N	\N	\N	PENDING	2026-01-14 01:02:22.819841	\N	\N	\N	5	job	/jobs/34	f	f	0	\N	248	2026-01-14 01:02:22.819848	2026-01-14 01:02:22.819852
10	JOB_MATCH	New Job Posted	New Steelfixer job: Steelfixer Needed - Sydney CBD Project in Sydney	\N	\N	\N	PENDING	2026-01-14 01:02:22.832946	\N	\N	\N	5	job	/jobs/34	f	f	0	\N	249	2026-01-14 01:02:22.832951	2026-01-14 01:02:22.832954
12	JOB_MATCH	New Job Posted	New Steelfixer job: Steelfixer Needed - Sydney CBD Project in Sydney	\N	\N	\N	PENDING	2026-01-14 01:02:22.843979	\N	\N	\N	5	job	/jobs/34	f	f	0	\N	250	2026-01-14 01:02:22.843983	2026-01-14 01:02:22.843986
59	JOB_MATCH	New Job Posted	New Steelfixer job: Steelfixer Needed - Sydney CBD Project in Sydney	\N	\N	\N	PENDING	2026-01-14 01:02:22.854784	\N	\N	\N	5	job	/jobs/34	f	f	0	\N	251	2026-01-14 01:02:22.854791	2026-01-14 01:02:22.854795
27	JOB_MATCH	New Job Posted	New Steelfixer job: Steelfixer Needed - Sydney CBD Project in Sydney	\N	\N	\N	PENDING	2026-01-14 01:02:22.866114	\N	\N	\N	5	job	/jobs/34	f	f	0	\N	252	2026-01-14 01:02:22.866137	2026-01-14 01:02:22.866141
52	JOB_MATCH	New Job Posted	New Steelfixer job: Steelfixer Needed - Sydney CBD Project in Sydney	\N	\N	\N	PENDING	2026-01-14 01:02:22.877494	\N	\N	\N	5	job	/jobs/34	f	f	0	\N	253	2026-01-14 01:02:22.8775	2026-01-14 01:02:22.877504
19	JOB_MATCH	New Job Posted	New Steelfixer job: Steelfixer Needed - Sydney CBD Project in Sydney	\N	\N	\N	PENDING	2026-01-14 01:02:22.889203	\N	\N	\N	5	job	/jobs/34	f	f	0	\N	254	2026-01-14 01:02:22.889211	2026-01-14 01:02:22.889215
36	JOB_MATCH	New Job Posted	New Steelfixer job: Steelfixer Needed - Sydney CBD Project in Sydney	\N	\N	\N	PENDING	2026-01-14 01:02:22.900105	\N	\N	\N	5	job	/jobs/34	f	f	0	\N	255	2026-01-14 01:02:22.900111	2026-01-14 01:02:22.900115
37	JOB_MATCH	New Job Posted	New Steelfixer job: Steelfixer Needed - Sydney CBD Project in Sydney	\N	\N	\N	PENDING	2026-01-14 01:02:22.91172	\N	\N	\N	5	job	/jobs/34	f	f	0	\N	256	2026-01-14 01:02:22.911728	2026-01-14 01:02:22.911731
45	JOB_MATCH	New Job Posted	New Steelfixer job: Steelfixer Needed - Sydney CBD Project in Sydney	\N	\N	\N	PENDING	2026-01-14 01:02:22.9246	\N	\N	\N	5	job	/jobs/34	f	f	0	\N	257	2026-01-14 01:02:22.924608	2026-01-14 01:02:22.924612
38	JOB_MATCH	New Job Posted	New Steelfixer job: Steelfixer Needed - Sydney CBD Project in Sydney	\N	\N	\N	PENDING	2026-01-14 01:02:22.936089	\N	\N	\N	5	job	/jobs/34	f	f	0	\N	258	2026-01-14 01:02:22.936097	2026-01-14 01:02:22.9361
41	JOB_MATCH	New Job Posted	New Steelfixer job: Steelfixer Needed - Sydney CBD Project in Sydney	\N	\N	\N	PENDING	2026-01-14 01:02:22.947837	\N	\N	\N	5	job	/jobs/34	f	f	0	\N	259	2026-01-14 01:02:22.947845	2026-01-14 01:02:22.947848
48	JOB_MATCH	New Job Posted	New Steelfixer job: Steelfixer Needed - Sydney CBD Project in Sydney	\N	\N	\N	PENDING	2026-01-14 01:02:22.959956	\N	\N	\N	5	job	/jobs/34	f	f	0	\N	260	2026-01-14 01:02:22.959963	2026-01-14 01:02:22.959967
49	JOB_MATCH	New Job Posted	New Steelfixer job: Steelfixer Needed - Sydney CBD Project in Sydney	\N	\N	\N	PENDING	2026-01-14 01:02:22.97059	\N	\N	\N	5	job	/jobs/34	f	f	0	\N	261	2026-01-14 01:02:22.970596	2026-01-14 01:02:22.9706
50	JOB_MATCH	New Job Posted	New Steelfixer job: Steelfixer Needed - Sydney CBD Project in Sydney	\N	\N	\N	PENDING	2026-01-14 01:02:22.982209	\N	\N	\N	5	job	/jobs/34	f	f	0	\N	262	2026-01-14 01:02:22.982216	2026-01-14 01:02:22.98222
18	JOB_MATCH	New Job Posted	New Steelfixer job: Steelfixer Needed - Sydney CBD Project in Sydney	\N	\N	\N	PENDING	2026-01-14 01:02:22.992887	\N	\N	\N	5	job	/jobs/34	f	f	0	\N	263	2026-01-14 01:02:22.992894	2026-01-14 01:02:22.992898
57	JOB_MATCH	New Job Posted	New Steelfixer job: Steelfixer Needed - Sydney CBD Project in Sydney	\N	\N	\N	PENDING	2026-01-14 01:02:23.003898	\N	\N	\N	5	job	/jobs/34	f	f	0	\N	264	2026-01-14 01:02:23.003904	2026-01-14 01:02:23.003907
39	JOB_MATCH	New Job Posted	New Steelfixer job: Steelfixer Needed - Sydney CBD Project in Sydney	\N	\N	\N	PENDING	2026-01-14 01:02:23.014757	\N	\N	\N	5	job	/jobs/34	f	f	0	\N	265	2026-01-14 01:02:23.014764	2026-01-14 01:02:23.014767
61	JOB_MATCH	New Job Posted	New Steelfixer job: Steelfixer Needed - Sydney CBD Project in Sydney	\N	\N	\N	PENDING	2026-01-14 01:02:23.027944	\N	\N	\N	5	job	/jobs/34	f	f	0	\N	266	2026-01-14 01:02:23.02795	2026-01-14 01:02:23.027953
65	JOB_MATCH	New Job Posted	New Steelfixer job: Steelfixer Needed - Sydney CBD Project in Sydney	\N	\N	\N	PENDING	2026-01-14 01:02:23.037441	\N	\N	\N	5	job	/jobs/34	f	f	0	\N	267	2026-01-14 01:02:23.037446	2026-01-14 01:02:23.03745
65	CONTRACT_AWARDED	Application Accepted!	Your application for 'Steelfixer Needed - Sydney CBD Project' was accepted. Contract #25 created and ready for review.	\N	\N	\N	PENDING	2026-01-14 01:03:36.008668	\N	\N	\N	3	job_alerts	/contracts/25/review	f	f	0	\N	269	2026-01-14 01:03:36.008675	2026-01-14 01:03:36.008679
66	JOB_APPLICATION_UPDATE	New Application for 'Steelfixer Needed - Sydney CBD Project'	Michael McLoughlin has applied to your job 'Steelfixer Needed - Sydney CBD Project' in Sydney. Proposed rate: $25.00/hour.	\N	\N	\N	READ	2026-01-14 01:03:06.971615	\N	\N	2026-01-14 01:13:25.587442	3	job_alerts	/applications/received?job_id=34	f	f	0	\N	268	2026-01-14 01:03:06.971622	2026-01-14 01:13:25.588364
3	JOB_MATCH	New Job Posted	New Formworker job: Formworker Needed ASAP at Hornsby in Sydney	\N	\N	\N	PENDING	2026-01-29 05:22:50.89599	\N	\N	\N	5	job	/jobs/35	f	f	0	\N	273	2026-01-29 05:22:50.895996	2026-01-29 05:22:50.896
65	CONTRACT_AWARDED	Contract is Now Active! 🎉	The contract for 'Steelfixer Needed - Sydney CBD Project' is now active. Payment has been secured in escrow. You can start work!	["in_app", "email", "push_web", "push_mobile"]	["in_app", "email", "push_web", "push_mobile"]	\N	READ	2026-01-14 01:11:20.392419	2026-01-14 01:11:20.945567	2026-01-14 01:11:20.94556	2026-01-14 01:15:13.148525	1	contract	http://rateright-au.fly.dev/contracts/25	f	f	0	\N	272	2026-01-14 01:11:20.392428	2026-01-14 01:15:13.148871
65	CONTRACT_AWARDED	Contract Awaiting Your Signature	Contract #25 for 'Steelfixer Needed - Sydney CBD Project' has been signed by the other party. Please review and sign.	\N	\N	\N	READ	2026-01-14 01:06:58.397607	\N	\N	2026-01-14 01:16:18.186157	3	contract	/contracts/25/review	f	f	0	\N	270	2026-01-14 01:06:58.397614	2026-01-14 01:16:18.187023
4	JOB_MATCH	New Job Posted	New Formworker job: Formworker Needed ASAP at Hornsby in Sydney	\N	\N	\N	PENDING	2026-01-29 05:22:50.917517	\N	\N	\N	5	job	/jobs/35	f	f	0	\N	274	2026-01-29 05:22:50.917524	2026-01-29 05:22:50.917527
10	JOB_MATCH	New Job Posted	New Formworker job: Formworker Needed ASAP at Hornsby in Sydney	\N	\N	\N	PENDING	2026-01-29 05:22:50.935744	\N	\N	\N	5	job	/jobs/35	f	f	0	\N	275	2026-01-29 05:22:50.935751	2026-01-29 05:22:50.935755
12	JOB_MATCH	New Job Posted	New Formworker job: Formworker Needed ASAP at Hornsby in Sydney	\N	\N	\N	PENDING	2026-01-29 05:22:50.954116	\N	\N	\N	5	job	/jobs/35	f	f	0	\N	276	2026-01-29 05:22:50.954122	2026-01-29 05:22:50.954126
59	JOB_MATCH	New Job Posted	New Formworker job: Formworker Needed ASAP at Hornsby in Sydney	\N	\N	\N	PENDING	2026-01-29 05:22:50.974942	\N	\N	\N	5	job	/jobs/35	f	f	0	\N	277	2026-01-29 05:22:50.974948	2026-01-29 05:22:50.974952
27	JOB_MATCH	New Job Posted	New Formworker job: Formworker Needed ASAP at Hornsby in Sydney	\N	\N	\N	PENDING	2026-01-29 05:22:50.990801	\N	\N	\N	5	job	/jobs/35	f	f	0	\N	278	2026-01-29 05:22:50.990806	2026-01-29 05:22:50.990809
52	JOB_MATCH	New Job Posted	New Formworker job: Formworker Needed ASAP at Hornsby in Sydney	\N	\N	\N	PENDING	2026-01-29 05:22:51.009957	\N	\N	\N	5	job	/jobs/35	f	f	0	\N	279	2026-01-29 05:22:51.009965	2026-01-29 05:22:51.009968
19	JOB_MATCH	New Job Posted	New Formworker job: Formworker Needed ASAP at Hornsby in Sydney	\N	\N	\N	PENDING	2026-01-29 05:22:51.026458	\N	\N	\N	5	job	/jobs/35	f	f	0	\N	280	2026-01-29 05:22:51.026463	2026-01-29 05:22:51.026466
36	JOB_MATCH	New Job Posted	New Formworker job: Formworker Needed ASAP at Hornsby in Sydney	\N	\N	\N	PENDING	2026-01-29 05:22:51.048272	\N	\N	\N	5	job	/jobs/35	f	f	0	\N	281	2026-01-29 05:22:51.048278	2026-01-29 05:22:51.048281
37	JOB_MATCH	New Job Posted	New Formworker job: Formworker Needed ASAP at Hornsby in Sydney	\N	\N	\N	PENDING	2026-01-29 05:22:51.068909	\N	\N	\N	5	job	/jobs/35	f	f	0	\N	282	2026-01-29 05:22:51.068916	2026-01-29 05:22:51.068919
45	JOB_MATCH	New Job Posted	New Formworker job: Formworker Needed ASAP at Hornsby in Sydney	\N	\N	\N	PENDING	2026-01-29 05:22:51.087291	\N	\N	\N	5	job	/jobs/35	f	f	0	\N	283	2026-01-29 05:22:51.087296	2026-01-29 05:22:51.087299
38	JOB_MATCH	New Job Posted	New Formworker job: Formworker Needed ASAP at Hornsby in Sydney	\N	\N	\N	PENDING	2026-01-29 05:22:51.101828	\N	\N	\N	5	job	/jobs/35	f	f	0	\N	284	2026-01-29 05:22:51.101834	2026-01-29 05:22:51.101836
41	JOB_MATCH	New Job Posted	New Formworker job: Formworker Needed ASAP at Hornsby in Sydney	\N	\N	\N	PENDING	2026-01-29 05:22:51.116987	\N	\N	\N	5	job	/jobs/35	f	f	0	\N	285	2026-01-29 05:22:51.116992	2026-01-29 05:22:51.116995
48	JOB_MATCH	New Job Posted	New Formworker job: Formworker Needed ASAP at Hornsby in Sydney	\N	\N	\N	PENDING	2026-01-29 05:22:51.131037	\N	\N	\N	5	job	/jobs/35	f	f	0	\N	286	2026-01-29 05:22:51.131042	2026-01-29 05:22:51.131045
49	JOB_MATCH	New Job Posted	New Formworker job: Formworker Needed ASAP at Hornsby in Sydney	\N	\N	\N	PENDING	2026-01-29 05:22:51.146316	\N	\N	\N	5	job	/jobs/35	f	f	0	\N	287	2026-01-29 05:22:51.14632	2026-01-29 05:22:51.146323
50	JOB_MATCH	New Job Posted	New Formworker job: Formworker Needed ASAP at Hornsby in Sydney	\N	\N	\N	PENDING	2026-01-29 05:22:51.164608	\N	\N	\N	5	job	/jobs/35	f	f	0	\N	288	2026-01-29 05:22:51.164616	2026-01-29 05:22:51.16462
18	JOB_MATCH	New Job Posted	New Formworker job: Formworker Needed ASAP at Hornsby in Sydney	\N	\N	\N	PENDING	2026-01-29 05:22:51.183047	\N	\N	\N	5	job	/jobs/35	f	f	0	\N	289	2026-01-29 05:22:51.183055	2026-01-29 05:22:51.183059
57	JOB_MATCH	New Job Posted	New Formworker job: Formworker Needed ASAP at Hornsby in Sydney	\N	\N	\N	PENDING	2026-01-29 05:22:51.19798	\N	\N	\N	5	job	/jobs/35	f	f	0	\N	290	2026-01-29 05:22:51.197985	2026-01-29 05:22:51.197989
39	JOB_MATCH	New Job Posted	New Formworker job: Formworker Needed ASAP at Hornsby in Sydney	\N	\N	\N	PENDING	2026-01-29 05:22:51.213595	\N	\N	\N	5	job	/jobs/35	f	f	0	\N	291	2026-01-29 05:22:51.213601	2026-01-29 05:22:51.213604
61	JOB_MATCH	New Job Posted	New Formworker job: Formworker Needed ASAP at Hornsby in Sydney	\N	\N	\N	PENDING	2026-01-29 05:22:51.228643	\N	\N	\N	5	job	/jobs/35	f	f	0	\N	292	2026-01-29 05:22:51.228648	2026-01-29 05:22:51.228651
65	JOB_MATCH	New Job Posted	New Formworker job: Formworker Needed ASAP at Hornsby in Sydney	\N	\N	\N	PENDING	2026-01-29 05:22:51.24449	\N	\N	\N	5	job	/jobs/35	f	f	0	\N	293	2026-01-29 05:22:51.244497	2026-01-29 05:22:51.2445
3	JOB_MATCH	New Job Posted	New Formworker job: Slab on Ground Formwork Parramatta in Sydney	\N	\N	\N	PENDING	2026-01-29 05:24:19.04668	\N	\N	\N	5	job	/jobs/36	f	f	0	\N	294	2026-01-29 05:24:19.046686	2026-01-29 05:24:19.046689
4	JOB_MATCH	New Job Posted	New Formworker job: Slab on Ground Formwork Parramatta in Sydney	\N	\N	\N	PENDING	2026-01-29 05:24:19.066326	\N	\N	\N	5	job	/jobs/36	f	f	0	\N	295	2026-01-29 05:24:19.066332	2026-01-29 05:24:19.066336
10	JOB_MATCH	New Job Posted	New Formworker job: Slab on Ground Formwork Parramatta in Sydney	\N	\N	\N	PENDING	2026-01-29 05:24:19.077933	\N	\N	\N	5	job	/jobs/36	f	f	0	\N	296	2026-01-29 05:24:19.077939	2026-01-29 05:24:19.077943
12	JOB_MATCH	New Job Posted	New Formworker job: Slab on Ground Formwork Parramatta in Sydney	\N	\N	\N	PENDING	2026-01-29 05:24:19.089086	\N	\N	\N	5	job	/jobs/36	f	f	0	\N	297	2026-01-29 05:24:19.089093	2026-01-29 05:24:19.089096
59	JOB_MATCH	New Job Posted	New Formworker job: Slab on Ground Formwork Parramatta in Sydney	\N	\N	\N	PENDING	2026-01-29 05:24:19.100335	\N	\N	\N	5	job	/jobs/36	f	f	0	\N	298	2026-01-29 05:24:19.100342	2026-01-29 05:24:19.100345
27	JOB_MATCH	New Job Posted	New Formworker job: Slab on Ground Formwork Parramatta in Sydney	\N	\N	\N	PENDING	2026-01-29 05:24:19.112227	\N	\N	\N	5	job	/jobs/36	f	f	0	\N	299	2026-01-29 05:24:19.112232	2026-01-29 05:24:19.112235
52	JOB_MATCH	New Job Posted	New Formworker job: Slab on Ground Formwork Parramatta in Sydney	\N	\N	\N	PENDING	2026-01-29 05:24:19.123188	\N	\N	\N	5	job	/jobs/36	f	f	0	\N	300	2026-01-29 05:24:19.123192	2026-01-29 05:24:19.123195
19	JOB_MATCH	New Job Posted	New Formworker job: Slab on Ground Formwork Parramatta in Sydney	\N	\N	\N	PENDING	2026-01-29 05:24:19.133825	\N	\N	\N	5	job	/jobs/36	f	f	0	\N	301	2026-01-29 05:24:19.133828	2026-01-29 05:24:19.133831
36	JOB_MATCH	New Job Posted	New Formworker job: Slab on Ground Formwork Parramatta in Sydney	\N	\N	\N	PENDING	2026-01-29 05:24:19.143149	\N	\N	\N	5	job	/jobs/36	f	f	0	\N	302	2026-01-29 05:24:19.143152	2026-01-29 05:24:19.143154
37	JOB_MATCH	New Job Posted	New Formworker job: Slab on Ground Formwork Parramatta in Sydney	\N	\N	\N	PENDING	2026-01-29 05:24:19.153531	\N	\N	\N	5	job	/jobs/36	f	f	0	\N	303	2026-01-29 05:24:19.153537	2026-01-29 05:24:19.15354
45	JOB_MATCH	New Job Posted	New Formworker job: Slab on Ground Formwork Parramatta in Sydney	\N	\N	\N	PENDING	2026-01-29 05:24:19.166069	\N	\N	\N	5	job	/jobs/36	f	f	0	\N	304	2026-01-29 05:24:19.166075	2026-01-29 05:24:19.166078
38	JOB_MATCH	New Job Posted	New Formworker job: Slab on Ground Formwork Parramatta in Sydney	\N	\N	\N	PENDING	2026-01-29 05:24:19.18385	\N	\N	\N	5	job	/jobs/36	f	f	0	\N	305	2026-01-29 05:24:19.183854	2026-01-29 05:24:19.183857
41	JOB_MATCH	New Job Posted	New Formworker job: Slab on Ground Formwork Parramatta in Sydney	\N	\N	\N	PENDING	2026-01-29 05:24:19.194648	\N	\N	\N	5	job	/jobs/36	f	f	0	\N	306	2026-01-29 05:24:19.194651	2026-01-29 05:24:19.194653
48	JOB_MATCH	New Job Posted	New Formworker job: Slab on Ground Formwork Parramatta in Sydney	\N	\N	\N	PENDING	2026-01-29 05:24:19.203872	\N	\N	\N	5	job	/jobs/36	f	f	0	\N	307	2026-01-29 05:24:19.203876	2026-01-29 05:24:19.203879
49	JOB_MATCH	New Job Posted	New Formworker job: Slab on Ground Formwork Parramatta in Sydney	\N	\N	\N	PENDING	2026-01-29 05:24:19.212627	\N	\N	\N	5	job	/jobs/36	f	f	0	\N	308	2026-01-29 05:24:19.212631	2026-01-29 05:24:19.212634
50	JOB_MATCH	New Job Posted	New Formworker job: Slab on Ground Formwork Parramatta in Sydney	\N	\N	\N	PENDING	2026-01-29 05:24:19.223207	\N	\N	\N	5	job	/jobs/36	f	f	0	\N	309	2026-01-29 05:24:19.223212	2026-01-29 05:24:19.223214
18	JOB_MATCH	New Job Posted	New Formworker job: Slab on Ground Formwork Parramatta in Sydney	\N	\N	\N	PENDING	2026-01-29 05:24:19.232829	\N	\N	\N	5	job	/jobs/36	f	f	0	\N	310	2026-01-29 05:24:19.232835	2026-01-29 05:24:19.232838
57	JOB_MATCH	New Job Posted	New Formworker job: Slab on Ground Formwork Parramatta in Sydney	\N	\N	\N	PENDING	2026-01-29 05:24:19.243663	\N	\N	\N	5	job	/jobs/36	f	f	0	\N	311	2026-01-29 05:24:19.243668	2026-01-29 05:24:19.243671
39	JOB_MATCH	New Job Posted	New Formworker job: Slab on Ground Formwork Parramatta in Sydney	\N	\N	\N	PENDING	2026-01-29 05:24:19.254793	\N	\N	\N	5	job	/jobs/36	f	f	0	\N	312	2026-01-29 05:24:19.254799	2026-01-29 05:24:19.254802
61	JOB_MATCH	New Job Posted	New Formworker job: Slab on Ground Formwork Parramatta in Sydney	\N	\N	\N	PENDING	2026-01-29 05:24:19.266597	\N	\N	\N	5	job	/jobs/36	f	f	0	\N	313	2026-01-29 05:24:19.266603	2026-01-29 05:24:19.266606
65	JOB_MATCH	New Job Posted	New Formworker job: Slab on Ground Formwork Parramatta in Sydney	\N	\N	\N	PENDING	2026-01-29 05:24:19.277259	\N	\N	\N	5	job	/jobs/36	f	f	0	\N	314	2026-01-29 05:24:19.277264	2026-01-29 05:24:19.277267
3	JOB_MATCH	New Job Posted	New Formworker job: Culvert and Pits Formwork in Sydney	\N	\N	\N	PENDING	2026-01-29 05:26:12.177039	\N	\N	\N	5	job	/jobs/37	f	f	0	\N	315	2026-01-29 05:26:12.177046	2026-01-29 05:26:12.177049
4	JOB_MATCH	New Job Posted	New Formworker job: Culvert and Pits Formwork in Sydney	\N	\N	\N	PENDING	2026-01-29 05:26:12.189438	\N	\N	\N	5	job	/jobs/37	f	f	0	\N	316	2026-01-29 05:26:12.189445	2026-01-29 05:26:12.189447
10	JOB_MATCH	New Job Posted	New Formworker job: Culvert and Pits Formwork in Sydney	\N	\N	\N	PENDING	2026-01-29 05:26:12.201005	\N	\N	\N	5	job	/jobs/37	f	f	0	\N	317	2026-01-29 05:26:12.201011	2026-01-29 05:26:12.201013
12	JOB_MATCH	New Job Posted	New Formworker job: Culvert and Pits Formwork in Sydney	\N	\N	\N	PENDING	2026-01-29 05:26:12.212037	\N	\N	\N	5	job	/jobs/37	f	f	0	\N	318	2026-01-29 05:26:12.212041	2026-01-29 05:26:12.212044
59	JOB_MATCH	New Job Posted	New Formworker job: Culvert and Pits Formwork in Sydney	\N	\N	\N	PENDING	2026-01-29 05:26:12.22255	\N	\N	\N	5	job	/jobs/37	f	f	0	\N	319	2026-01-29 05:26:12.222557	2026-01-29 05:26:12.22256
27	JOB_MATCH	New Job Posted	New Formworker job: Culvert and Pits Formwork in Sydney	\N	\N	\N	PENDING	2026-01-29 05:26:12.233454	\N	\N	\N	5	job	/jobs/37	f	f	0	\N	320	2026-01-29 05:26:12.23346	2026-01-29 05:26:12.233463
52	JOB_MATCH	New Job Posted	New Formworker job: Culvert and Pits Formwork in Sydney	\N	\N	\N	PENDING	2026-01-29 05:26:12.243935	\N	\N	\N	5	job	/jobs/37	f	f	0	\N	321	2026-01-29 05:26:12.243941	2026-01-29 05:26:12.243944
19	JOB_MATCH	New Job Posted	New Formworker job: Culvert and Pits Formwork in Sydney	\N	\N	\N	PENDING	2026-01-29 05:26:12.255102	\N	\N	\N	5	job	/jobs/37	f	f	0	\N	322	2026-01-29 05:26:12.255108	2026-01-29 05:26:12.255111
36	JOB_MATCH	New Job Posted	New Formworker job: Culvert and Pits Formwork in Sydney	\N	\N	\N	PENDING	2026-01-29 05:26:12.264875	\N	\N	\N	5	job	/jobs/37	f	f	0	\N	323	2026-01-29 05:26:12.264881	2026-01-29 05:26:12.264885
37	JOB_MATCH	New Job Posted	New Formworker job: Culvert and Pits Formwork in Sydney	\N	\N	\N	PENDING	2026-01-29 05:26:12.275654	\N	\N	\N	5	job	/jobs/37	f	f	0	\N	324	2026-01-29 05:26:12.27566	2026-01-29 05:26:12.275662
45	JOB_MATCH	New Job Posted	New Formworker job: Culvert and Pits Formwork in Sydney	\N	\N	\N	PENDING	2026-01-29 05:26:12.287212	\N	\N	\N	5	job	/jobs/37	f	f	0	\N	325	2026-01-29 05:26:12.287218	2026-01-29 05:26:12.287222
38	JOB_MATCH	New Job Posted	New Formworker job: Culvert and Pits Formwork in Sydney	\N	\N	\N	PENDING	2026-01-29 05:26:12.29827	\N	\N	\N	5	job	/jobs/37	f	f	0	\N	326	2026-01-29 05:26:12.298277	2026-01-29 05:26:12.29828
41	JOB_MATCH	New Job Posted	New Formworker job: Culvert and Pits Formwork in Sydney	\N	\N	\N	PENDING	2026-01-29 05:26:12.313268	\N	\N	\N	5	job	/jobs/37	f	f	0	\N	327	2026-01-29 05:26:12.313273	2026-01-29 05:26:12.313276
48	JOB_MATCH	New Job Posted	New Formworker job: Culvert and Pits Formwork in Sydney	\N	\N	\N	PENDING	2026-01-29 05:26:12.325925	\N	\N	\N	5	job	/jobs/37	f	f	0	\N	328	2026-01-29 05:26:12.325931	2026-01-29 05:26:12.325934
49	JOB_MATCH	New Job Posted	New Formworker job: Culvert and Pits Formwork in Sydney	\N	\N	\N	PENDING	2026-01-29 05:26:12.337441	\N	\N	\N	5	job	/jobs/37	f	f	0	\N	329	2026-01-29 05:26:12.337448	2026-01-29 05:26:12.337452
50	JOB_MATCH	New Job Posted	New Formworker job: Culvert and Pits Formwork in Sydney	\N	\N	\N	PENDING	2026-01-29 05:26:12.360276	\N	\N	\N	5	job	/jobs/37	f	f	0	\N	330	2026-01-29 05:26:12.360283	2026-01-29 05:26:12.360287
18	JOB_MATCH	New Job Posted	New Formworker job: Culvert and Pits Formwork in Sydney	\N	\N	\N	PENDING	2026-01-29 05:26:12.370652	\N	\N	\N	5	job	/jobs/37	f	f	0	\N	331	2026-01-29 05:26:12.370658	2026-01-29 05:26:12.370661
57	JOB_MATCH	New Job Posted	New Formworker job: Culvert and Pits Formwork in Sydney	\N	\N	\N	PENDING	2026-01-29 05:26:12.381352	\N	\N	\N	5	job	/jobs/37	f	f	0	\N	332	2026-01-29 05:26:12.381358	2026-01-29 05:26:12.381361
39	JOB_MATCH	New Job Posted	New Formworker job: Culvert and Pits Formwork in Sydney	\N	\N	\N	PENDING	2026-01-29 05:26:12.390692	\N	\N	\N	5	job	/jobs/37	f	f	0	\N	333	2026-01-29 05:26:12.390699	2026-01-29 05:26:12.390702
61	JOB_MATCH	New Job Posted	New Formworker job: Culvert and Pits Formwork in Sydney	\N	\N	\N	PENDING	2026-01-29 05:26:12.400289	\N	\N	\N	5	job	/jobs/37	f	f	0	\N	334	2026-01-29 05:26:12.400294	2026-01-29 05:26:12.400297
65	JOB_MATCH	New Job Posted	New Formworker job: Culvert and Pits Formwork in Sydney	\N	\N	\N	PENDING	2026-01-29 05:26:12.411409	\N	\N	\N	5	job	/jobs/37	f	f	0	\N	335	2026-01-29 05:26:12.411415	2026-01-29 05:26:12.411418
18	CONTRACT_AWARDED	Application Accepted!	Your application for 'Personal Renovation' was accepted. Contract #26 created and ready for review.	["in_app", "email", "push_web", "push_mobile"]	["in_app", "email", "push_web", "push_mobile"]	\N	DELIVERED	2026-01-29 15:29:06.160465	2026-01-29 15:29:06.90845	2026-01-29 15:29:06.908442	\N	3	job_alerts	/contracts/26/review	f	f	0	\N	336	2026-01-29 15:29:06.160471	2026-01-29 15:29:06.909171
\.


--
-- Data for Name: point_activities; Type: TABLE DATA; Schema: public; Owner: rateright_au
--

COPY public.point_activities (user_id, activity_type, points_earned, description, related_job_id, related_contract_id, related_review_id, base_points, bonus_multiplier, bonus_reason, id, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: ratings; Type: TABLE DATA; Schema: public; Owner: rateright_au
--

COPY public.ratings (contract_id, rater_id, rated_id, overall_score, quality_score, communication_score, reliability_score, professionalism_score, review_text, rating_date, is_public, id, created_at, updated_at) FROM stdin;
24	65	66	5	5	5	5	5		2026-01-09 06:43:55.388442	t	15	2026-01-09 06:43:55.388445	2026-01-09 06:43:55.388447
24	66	65	5	5	5	5	5		2026-01-09 06:44:01.962754	t	16	2026-01-09 06:44:01.962757	2026-01-09 06:44:01.96276
25	66	65	5	5	5	5	5	good	2026-01-14 01:17:38.490375	t	17	2026-01-14 01:17:38.49038	2026-01-14 01:17:38.490382
25	65	66	5	5	5	5	5	good	2026-01-14 01:18:45.805033	t	18	2026-01-14 01:18:45.805038	2026-01-14 01:18:45.805041
\.


--
-- Data for Name: recurring_bookings; Type: TABLE DATA; Schema: public; Owner: rateright_au
--

COPY public.recurring_bookings (client_id, worker_id, recurrence_type, recurrence_interval, recurrence_days, recurrence_day_of_month, start_time, duration_minutes, service_type, description, location, start_date, end_date, is_active, estimated_cost_per_session, next_occurrence, id, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: reviews; Type: TABLE DATA; Schema: public; Owner: rateright_au
--

COPY public.reviews (reviewer_id, reviewee_id, job_id, contract_id, overall_rating, quality_rating, communication_rating, safety_rating, comment, would_work_again, verified_completion, id, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: shift_bids; Type: TABLE DATA; Schema: public; Owner: rateright_au
--

COPY public.shift_bids (shift_id, worker_id, bid_amount, availability_confirmed, status, selected_at, selected_by, worker_notes, rejection_reason, id, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: shift_swap_requests; Type: TABLE DATA; Schema: public; Owner: rateright_au
--

COPY public.shift_swap_requests (from_worker_id, from_shift_id, to_worker_id, to_shift_id, reason, is_permanent, status, worker_approved, manager_approved, approved_by, approved_at, id, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: shifts; Type: TABLE DATA; Schema: public; Owner: rateright_au
--

COPY public.shifts (worker_id, job_id, shift_date, start_time, end_time, shift_type, shift_name, is_open, min_workers_required, max_workers_allowed, current_workers, required_skills, min_rating, hourly_rate, overtime_rate, status, description, special_instructions, id, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: time_entries; Type: TABLE DATA; Schema: public; Owner: rateright_au
--

COPY public.time_entries (worker_id, job_id, booking_id, contract_id, clock_in, clock_out, break_start, break_end, total_break_minutes, total_minutes, regular_hours, overtime_hours, work_date, description, location, is_approved, approved_by, approved_at, is_manual_entry, notes, id, created_at, updated_at) FROM stdin;
65	\N	\N	24	2026-01-09 06:42:27.096094	2026-01-09 06:42:30.017965	2026-01-09 06:42:28.772933	\N	0	0	0	0	2026-01-09	Test Work #1	\N	t	66	2026-01-09 06:43:19.308558	f	\N	17	2026-01-09 06:42:27.097497	2026-01-09 06:43:19.309667
65	33	\N	24	2026-01-10 09:00:00	2026-01-10 11:00:00	\N	\N	0	120	2	0	2026-01-10	Test Work #2		t	66	2026-01-09 06:43:19.308569	t	\N	18	2026-01-09 06:42:41.56331	2026-01-09 06:43:19.309672
65	34	\N	25	2026-01-14 09:00:00	2026-01-14 13:00:00	\N	\N	0	240	4	0	2026-01-14	allwork complete		t	66	2026-01-14 01:13:04.759728	t	\N	19	2026-01-14 01:12:23.009628	2026-01-14 01:13:04.761311
\.


--
-- Data for Name: whs_assessments; Type: TABLE DATA; Schema: public; Owner: rateright_au
--

COPY public.whs_assessments (job_id, assessment_reference, risk_assessment, hazard_identification, risk_control_measures, safety_plan_accepted, safety_induction_completed, emergency_procedures_briefed, insurance_verified, white_card_verified, license_verification, incident_report, incidents_count, near_miss_count, status, completed_by, approved_by, id, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: worker_schedule_preferences; Type: TABLE DATA; Schema: public; Owner: rateright_au
--

COPY public.worker_schedule_preferences (worker_id, default_start_time, default_end_time, working_days, default_buffer_time, travel_time_buffer, min_advance_booking, max_advance_booking, google_calendar_id, outlook_calendar_id, sync_enabled, last_sync, reminder_time, reminder_method, id, created_at, updated_at) FROM stdin;
\.



--
-- Name: shift_bids _shift_worker_uc; Type: CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.shift_bids
    ADD CONSTRAINT _shift_worker_uc UNIQUE (shift_id, worker_id);


--
-- Name: achievements achievements_pkey; Type: CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.achievements
    ADD CONSTRAINT achievements_pkey PRIMARY KEY (id);


--
-- Name: alembic_version alembic_version_pkc; Type: CONSTRAINT; Schema: public; Owner: rateright_au
--

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


--
-- Name: applications applications_pkey; Type: CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.applications
    ADD CONSTRAINT applications_pkey PRIMARY KEY (id);


--
-- Name: audit_logs audit_logs_pkey; Type: CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.audit_logs
    ADD CONSTRAINT audit_logs_pkey PRIMARY KEY (id);


--
-- Name: availability availability_pkey; Type: CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.availability
    ADD CONSTRAINT availability_pkey PRIMARY KEY (id);


--
-- Name: categories categories_name_key; Type: CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.categories
    ADD CONSTRAINT categories_name_key UNIQUE (name);


--
-- Name: categories categories_pkey; Type: CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.categories
    ADD CONSTRAINT categories_pkey PRIMARY KEY (id);


--
-- Name: contracts contracts_pkey; Type: CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.contracts
    ADD CONSTRAINT contracts_pkey PRIMARY KEY (id);


--
-- Name: disputes disputes_dispute_reference_key; Type: CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.disputes
    ADD CONSTRAINT disputes_dispute_reference_key UNIQUE (dispute_reference);


--
-- Name: disputes disputes_pkey; Type: CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.disputes
    ADD CONSTRAINT disputes_pkey PRIMARY KEY (id);


--
-- Name: file_uploads file_uploads_pkey; Type: CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.file_uploads
    ADD CONSTRAINT file_uploads_pkey PRIMARY KEY (id);


--
-- Name: invoices invoices_invoice_number_key; Type: CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.invoices
    ADD CONSTRAINT invoices_invoice_number_key UNIQUE (invoice_number);


--
-- Name: invoices invoices_pkey; Type: CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.invoices
    ADD CONSTRAINT invoices_pkey PRIMARY KEY (id);


--
-- Name: job_progress job_progress_pkey; Type: CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.job_progress
    ADD CONSTRAINT job_progress_pkey PRIMARY KEY (id);


--
-- Name: jobs jobs_pkey; Type: CONSTRAINT; Schema: public; Owner: rateright_au
--

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


--
-- Name: leaderboards leaderboards_pkey; Type: CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.leaderboards
    ADD CONSTRAINT leaderboards_pkey PRIMARY KEY (id);


--
-- Name: messages messages_pkey; Type: CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.messages
    ADD CONSTRAINT messages_pkey PRIMARY KEY (id);


--
-- Name: notification_preferences notification_preferences_pkey; Type: CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.notification_preferences
    ADD CONSTRAINT notification_preferences_pkey PRIMARY KEY (id);


--
-- Name: notification_templates notification_templates_pkey; Type: CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.notification_templates
    ADD CONSTRAINT notification_templates_pkey PRIMARY KEY (id);


--
-- Name: notifications notifications_pkey; Type: CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.notifications
    ADD CONSTRAINT notifications_pkey PRIMARY KEY (id);


--
-- Name: point_activities point_activities_pkey; Type: CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.point_activities
    ADD CONSTRAINT point_activities_pkey PRIMARY KEY (id);


--
-- Name: ratings ratings_pkey; Type: CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.ratings
    ADD CONSTRAINT ratings_pkey PRIMARY KEY (id);


--
-- Name: recurring_bookings recurring_bookings_pkey; Type: CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.recurring_bookings
    ADD CONSTRAINT recurring_bookings_pkey PRIMARY KEY (id);


--
-- Name: reviews reviews_pkey; Type: CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.reviews
    ADD CONSTRAINT reviews_pkey PRIMARY KEY (id);


--
-- Name: shift_bids shift_bids_pkey; Type: CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.shift_bids
    ADD CONSTRAINT shift_bids_pkey PRIMARY KEY (id);


--
-- Name: shift_swap_requests shift_swap_requests_pkey; Type: CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.shift_swap_requests
    ADD CONSTRAINT shift_swap_requests_pkey PRIMARY KEY (id);


--
-- Name: shifts shifts_pkey; Type: CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.shifts
    ADD CONSTRAINT shifts_pkey PRIMARY KEY (id);


--
-- Name: time_entries time_entries_pkey; Type: CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.time_entries
    ADD CONSTRAINT time_entries_pkey PRIMARY KEY (id);


--
-- Name: notification_templates unique_template_type_channel; Type: CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.notification_templates
    ADD CONSTRAINT unique_template_type_channel UNIQUE (notification_type, channel);


--
-- Name: notification_preferences unique_user_notification_pref; Type: CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.notification_preferences
    ADD CONSTRAINT unique_user_notification_pref UNIQUE (user_id, notification_type);


--
-- Name: whs_assessments whs_assessments_assessment_reference_key; Type: CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.whs_assessments
    ADD CONSTRAINT whs_assessments_assessment_reference_key UNIQUE (assessment_reference);


--
-- Name: whs_assessments whs_assessments_pkey; Type: CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.whs_assessments
    ADD CONSTRAINT whs_assessments_pkey PRIMARY KEY (id);


--
-- Name: worker_schedule_preferences worker_schedule_preferences_pkey; Type: CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.worker_schedule_preferences
    ADD CONSTRAINT worker_schedule_preferences_pkey PRIMARY KEY (id);


--
-- Name: worker_schedule_preferences worker_schedule_preferences_worker_id_key; Type: CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.worker_schedule_preferences
    ADD CONSTRAINT worker_schedule_preferences_worker_id_key UNIQUE (worker_id);


--
-- Name: idx_availability_date_status; Type: INDEX; Schema: public; Owner: rateright_au
--

CREATE INDEX idx_availability_date_status ON public.availability USING btree (date, status);


--
-- Name: idx_availability_worker_date; Type: INDEX; Schema: public; Owner: rateright_au
--

CREATE INDEX idx_availability_worker_date ON public.availability USING btree (worker_id, date);


--
-- Name: idx_file_contract; Type: INDEX; Schema: public; Owner: rateright_au
--

CREATE INDEX idx_file_contract ON public.file_uploads USING btree (contract_id);


--
-- Name: idx_file_job; Type: INDEX; Schema: public; Owner: rateright_au
--

CREATE INDEX idx_file_job ON public.file_uploads USING btree (job_id);


--
-- Name: idx_file_message; Type: INDEX; Schema: public; Owner: rateright_au
--

CREATE INDEX idx_file_message ON public.file_uploads USING btree (message_id);


--
-- Name: idx_file_storage; Type: INDEX; Schema: public; Owner: rateright_au
--

CREATE INDEX idx_file_storage ON public.file_uploads USING btree (storage_backend);


--
-- Name: idx_file_user_category; Type: INDEX; Schema: public; Owner: rateright_au
--

CREATE INDEX idx_file_user_category ON public.file_uploads USING btree (user_id, category);


--
-- Name: idx_message_created_at; Type: INDEX; Schema: public; Owner: rateright_au
--

CREATE INDEX idx_message_created_at ON public.messages USING btree (created_at);


--
-- Name: idx_message_receiver_status; Type: INDEX; Schema: public; Owner: rateright_au
--

CREATE INDEX idx_message_receiver_status ON public.messages USING btree (receiver_id, status);


--
-- Name: idx_message_sender_receiver; Type: INDEX; Schema: public; Owner: rateright_au
--

CREATE INDEX idx_message_sender_receiver ON public.messages USING btree (sender_id, receiver_id);


--
-- Name: idx_shift_bid_status; Type: INDEX; Schema: public; Owner: rateright_au
--

CREATE INDEX idx_shift_bid_status ON public.shift_bids USING btree (shift_id, status);


--
-- Name: idx_shift_date_status; Type: INDEX; Schema: public; Owner: rateright_au
--

CREATE INDEX idx_shift_date_status ON public.shifts USING btree (shift_date, status);


--
-- Name: idx_shift_worker; Type: INDEX; Schema: public; Owner: rateright_au
--

CREATE INDEX idx_shift_worker ON public.shifts USING btree (worker_id, shift_date);


--
-- Name: idx_time_entry_booking; Type: INDEX; Schema: public; Owner: rateright_au
--

CREATE INDEX idx_time_entry_booking ON public.time_entries USING btree (booking_id);


--
-- Name: idx_time_entry_job; Type: INDEX; Schema: public; Owner: rateright_au
--

CREATE INDEX idx_time_entry_job ON public.time_entries USING btree (job_id);


--
-- Name: idx_time_entry_worker_date; Type: INDEX; Schema: public; Owner: rateright_au
--

CREATE INDEX idx_time_entry_worker_date ON public.time_entries USING btree (worker_id, work_date);


--
-- Name: achievements achievements_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.achievements
    ADD CONSTRAINT achievements_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: applications applications_job_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.applications
    ADD CONSTRAINT applications_job_id_fkey FOREIGN KEY (job_id) REFERENCES public.jobs(id);


--
-- Name: applications applications_worker_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.applications
    ADD CONSTRAINT applications_worker_id_fkey FOREIGN KEY (worker_id) REFERENCES public.users(id);


--
-- Name: audit_logs audit_logs_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.audit_logs
    ADD CONSTRAINT audit_logs_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: availability availability_worker_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.availability
    ADD CONSTRAINT availability_worker_id_fkey FOREIGN KEY (worker_id) REFERENCES public.users(id);


--
-- Name: contracts contracts_contractor_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.contracts
    ADD CONSTRAINT contracts_contractor_id_fkey FOREIGN KEY (contractor_id) REFERENCES public.users(id);


--
-- Name: contracts contracts_job_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.contracts
    ADD CONSTRAINT contracts_job_id_fkey FOREIGN KEY (job_id) REFERENCES public.jobs(id);


--
-- Name: contracts contracts_last_modified_by_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.contracts
    ADD CONSTRAINT contracts_last_modified_by_fkey FOREIGN KEY (last_modified_by) REFERENCES public.users(id);


--
-- Name: contracts contracts_worker_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.contracts
    ADD CONSTRAINT contracts_worker_id_fkey FOREIGN KEY (worker_id) REFERENCES public.users(id);


--
-- Name: disputes disputes_contract_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.disputes
    ADD CONSTRAINT disputes_contract_id_fkey FOREIGN KEY (contract_id) REFERENCES public.contracts(id);


--
-- Name: disputes disputes_raised_by_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.disputes
    ADD CONSTRAINT disputes_raised_by_fkey FOREIGN KEY (raised_by) REFERENCES public.users(id);


--
-- Name: disputes disputes_resolved_by_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.disputes
    ADD CONSTRAINT disputes_resolved_by_fkey FOREIGN KEY (resolved_by) REFERENCES public.users(id);


--
-- Name: file_uploads file_uploads_contract_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.file_uploads
    ADD CONSTRAINT file_uploads_contract_id_fkey FOREIGN KEY (contract_id) REFERENCES public.contracts(id);


--
-- Name: file_uploads file_uploads_job_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.file_uploads
    ADD CONSTRAINT file_uploads_job_id_fkey FOREIGN KEY (job_id) REFERENCES public.jobs(id);


--
-- Name: file_uploads file_uploads_message_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.file_uploads
    ADD CONSTRAINT file_uploads_message_id_fkey FOREIGN KEY (message_id) REFERENCES public.messages(id);


--
-- Name: file_uploads file_uploads_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.file_uploads
    ADD CONSTRAINT file_uploads_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: invoices invoices_contractor_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.invoices
    ADD CONSTRAINT invoices_contractor_id_fkey FOREIGN KEY (contractor_id) REFERENCES public.users(id);


--
-- Name: invoices invoices_payment_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.invoices
    ADD CONSTRAINT invoices_payment_id_fkey FOREIGN KEY (payment_id) REFERENCES public.payments(id);


--
-- Name: job_progress job_progress_contract_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.job_progress
    ADD CONSTRAINT job_progress_contract_id_fkey FOREIGN KEY (contract_id) REFERENCES public.contracts(id);


--
-- Name: job_progress job_progress_job_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.job_progress
    ADD CONSTRAINT job_progress_job_id_fkey FOREIGN KEY (job_id) REFERENCES public.jobs(id);


--
-- Name: job_progress job_progress_updated_by_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.job_progress
    ADD CONSTRAINT job_progress_updated_by_fkey FOREIGN KEY (updated_by) REFERENCES public.users(id);


--
-- Name: jobs jobs_category_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.jobs
    ADD CONSTRAINT jobs_category_id_fkey FOREIGN KEY (category_id) REFERENCES public.categories(id);


--
-- Name: jobs jobs_contractor_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.jobs
    ADD CONSTRAINT jobs_contractor_id_fkey FOREIGN KEY (contractor_id) REFERENCES public.users(id);


--
-- Name: leaderboards leaderboards_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.leaderboards
    ADD CONSTRAINT leaderboards_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: messages messages_contract_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.messages
    ADD CONSTRAINT messages_contract_id_fkey FOREIGN KEY (contract_id) REFERENCES public.contracts(id);


--
-- Name: messages messages_job_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.messages
    ADD CONSTRAINT messages_job_id_fkey FOREIGN KEY (job_id) REFERENCES public.jobs(id);


--
-- Name: messages messages_receiver_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.messages
    ADD CONSTRAINT messages_receiver_id_fkey FOREIGN KEY (receiver_id) REFERENCES public.users(id);


--
-- Name: messages messages_sender_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.messages
    ADD CONSTRAINT messages_sender_id_fkey FOREIGN KEY (sender_id) REFERENCES public.users(id);


--
-- Name: notification_preferences notification_preferences_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.notification_preferences
    ADD CONSTRAINT notification_preferences_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: notifications notifications_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.notifications
    ADD CONSTRAINT notifications_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: point_activities point_activities_related_contract_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.point_activities
    ADD CONSTRAINT point_activities_related_contract_id_fkey FOREIGN KEY (related_contract_id) REFERENCES public.contracts(id);


--
-- Name: point_activities point_activities_related_job_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.point_activities
    ADD CONSTRAINT point_activities_related_job_id_fkey FOREIGN KEY (related_job_id) REFERENCES public.jobs(id);


--
-- Name: point_activities point_activities_related_review_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.point_activities
    ADD CONSTRAINT point_activities_related_review_id_fkey FOREIGN KEY (related_review_id) REFERENCES public.reviews(id);


--
-- Name: point_activities point_activities_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.point_activities
    ADD CONSTRAINT point_activities_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: ratings ratings_contract_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.ratings
    ADD CONSTRAINT ratings_contract_id_fkey FOREIGN KEY (contract_id) REFERENCES public.contracts(id);


--
-- Name: ratings ratings_rated_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.ratings
    ADD CONSTRAINT ratings_rated_id_fkey FOREIGN KEY (rated_id) REFERENCES public.users(id);


--
-- Name: ratings ratings_rater_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.ratings
    ADD CONSTRAINT ratings_rater_id_fkey FOREIGN KEY (rater_id) REFERENCES public.users(id);


--
-- Name: recurring_bookings recurring_bookings_client_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.recurring_bookings
    ADD CONSTRAINT recurring_bookings_client_id_fkey FOREIGN KEY (client_id) REFERENCES public.users(id);


--
-- Name: recurring_bookings recurring_bookings_worker_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.recurring_bookings
    ADD CONSTRAINT recurring_bookings_worker_id_fkey FOREIGN KEY (worker_id) REFERENCES public.users(id);


--
-- Name: reviews reviews_contract_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.reviews
    ADD CONSTRAINT reviews_contract_id_fkey FOREIGN KEY (contract_id) REFERENCES public.contracts(id);


--
-- Name: reviews reviews_job_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.reviews
    ADD CONSTRAINT reviews_job_id_fkey FOREIGN KEY (job_id) REFERENCES public.jobs(id);


--
-- Name: reviews reviews_reviewee_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.reviews
    ADD CONSTRAINT reviews_reviewee_id_fkey FOREIGN KEY (reviewee_id) REFERENCES public.users(id);


--
-- Name: reviews reviews_reviewer_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.reviews
    ADD CONSTRAINT reviews_reviewer_id_fkey FOREIGN KEY (reviewer_id) REFERENCES public.users(id);


--
-- Name: shift_bids shift_bids_selected_by_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.shift_bids
    ADD CONSTRAINT shift_bids_selected_by_fkey FOREIGN KEY (selected_by) REFERENCES public.users(id);


--
-- Name: shift_bids shift_bids_shift_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.shift_bids
    ADD CONSTRAINT shift_bids_shift_id_fkey FOREIGN KEY (shift_id) REFERENCES public.shifts(id);


--
-- Name: shift_bids shift_bids_worker_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.shift_bids
    ADD CONSTRAINT shift_bids_worker_id_fkey FOREIGN KEY (worker_id) REFERENCES public.users(id);


--
-- Name: shift_swap_requests shift_swap_requests_approved_by_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.shift_swap_requests
    ADD CONSTRAINT shift_swap_requests_approved_by_fkey FOREIGN KEY (approved_by) REFERENCES public.users(id);


--
-- Name: shift_swap_requests shift_swap_requests_from_shift_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.shift_swap_requests
    ADD CONSTRAINT shift_swap_requests_from_shift_id_fkey FOREIGN KEY (from_shift_id) REFERENCES public.shifts(id);


--
-- Name: shift_swap_requests shift_swap_requests_from_worker_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.shift_swap_requests
    ADD CONSTRAINT shift_swap_requests_from_worker_id_fkey FOREIGN KEY (from_worker_id) REFERENCES public.users(id);


--
-- Name: shift_swap_requests shift_swap_requests_to_shift_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.shift_swap_requests
    ADD CONSTRAINT shift_swap_requests_to_shift_id_fkey FOREIGN KEY (to_shift_id) REFERENCES public.shifts(id);


--
-- Name: shift_swap_requests shift_swap_requests_to_worker_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.shift_swap_requests
    ADD CONSTRAINT shift_swap_requests_to_worker_id_fkey FOREIGN KEY (to_worker_id) REFERENCES public.users(id);


--
-- Name: shifts shifts_job_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.shifts
    ADD CONSTRAINT shifts_job_id_fkey FOREIGN KEY (job_id) REFERENCES public.jobs(id);


--
-- Name: shifts shifts_worker_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.shifts
    ADD CONSTRAINT shifts_worker_id_fkey FOREIGN KEY (worker_id) REFERENCES public.users(id);


--
-- Name: time_entries time_entries_approved_by_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.time_entries
    ADD CONSTRAINT time_entries_approved_by_fkey FOREIGN KEY (approved_by) REFERENCES public.users(id);


--
-- Name: time_entries time_entries_booking_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.time_entries
    ADD CONSTRAINT time_entries_booking_id_fkey FOREIGN KEY (booking_id) REFERENCES public.bookings(id);


--
-- Name: time_entries time_entries_contract_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.time_entries
    ADD CONSTRAINT time_entries_contract_id_fkey FOREIGN KEY (contract_id) REFERENCES public.contracts(id);


--
-- Name: time_entries time_entries_job_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.time_entries
    ADD CONSTRAINT time_entries_job_id_fkey FOREIGN KEY (job_id) REFERENCES public.jobs(id);


--
-- Name: time_entries time_entries_worker_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.time_entries
    ADD CONSTRAINT time_entries_worker_id_fkey FOREIGN KEY (worker_id) REFERENCES public.users(id);


--
-- Name: whs_assessments whs_assessments_approved_by_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.whs_assessments
    ADD CONSTRAINT whs_assessments_approved_by_fkey FOREIGN KEY (approved_by) REFERENCES public.users(id);


--
-- Name: whs_assessments whs_assessments_completed_by_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.whs_assessments
    ADD CONSTRAINT whs_assessments_completed_by_fkey FOREIGN KEY (completed_by) REFERENCES public.users(id);


--
-- Name: whs_assessments whs_assessments_job_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.whs_assessments
    ADD CONSTRAINT whs_assessments_job_id_fkey FOREIGN KEY (job_id) REFERENCES public.jobs(id);


--
-- Name: worker_schedule_preferences worker_schedule_preferences_worker_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rateright_au
--

ALTER TABLE ONLY public.worker_schedule_preferences
    ADD CONSTRAINT worker_schedule_preferences_worker_id_fkey FOREIGN KEY (worker_id) REFERENCES public.users(id);


--
-- Name: SCHEMA public; Type: ACL; Schema: -; Owner: pg_database_owner
--

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