--
-- PostgreSQL database dump
--

\restrict mO4150krz3BsMfWEPx3Zvjl31K0OokxzJhSHvB9OTTAzskuG7l6bbBPkGYjB7AC

-- Dumped from database version 16.14
-- Dumped by pg_dump version 16.14

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

--
-- Name: IdVerificationStatus; Type: TYPE; Schema: public; Owner: biess_user
--

CREATE TYPE public."IdVerificationStatus" AS ENUM (
    'UNSUBMITTED',
    'PENDING',
    'VERIFIED',
    'REJECTED'
);


ALTER TYPE public."IdVerificationStatus" OWNER TO biess_user;

--
-- Name: RequestStatus; Type: TYPE; Schema: public; Owner: biess_user
--

CREATE TYPE public."RequestStatus" AS ENUM (
    'PENDING',
    'APPROVED',
    'REJECTED',
    'READY',
    'RELEASED'
);


ALTER TYPE public."RequestStatus" OWNER TO biess_user;

--
-- Name: Role; Type: TYPE; Schema: public; Owner: biess_user
--

CREATE TYPE public."Role" AS ENUM (
    'RESIDENT',
    'ADMIN'
);


ALTER TYPE public."Role" OWNER TO biess_user;

SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- Name: Appointment; Type: TABLE; Schema: public; Owner: biess_user
--

CREATE TABLE public."Appointment" (
    id integer NOT NULL,
    date text NOT NULL,
    "timeSlot" text NOT NULL,
    "createdAt" timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
    "requestId" integer NOT NULL
);


ALTER TABLE public."Appointment" OWNER TO biess_user;

--
-- Name: Appointment_id_seq; Type: SEQUENCE; Schema: public; Owner: biess_user
--

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


ALTER SEQUENCE public."Appointment_id_seq" OWNER TO biess_user;

--
-- Name: Appointment_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: biess_user
--

ALTER SEQUENCE public."Appointment_id_seq" OWNED BY public."Appointment".id;


--
-- Name: DocumentType; Type: TABLE; Schema: public; Owner: biess_user
--

CREATE TABLE public."DocumentType" (
    id integer NOT NULL,
    name text NOT NULL,
    description text,
    fee numeric(10,2) DEFAULT 0 NOT NULL,
    "isActive" boolean DEFAULT true NOT NULL,
    "createdAt" timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
    "maxPerSlot" integer DEFAULT 10 NOT NULL
);


ALTER TABLE public."DocumentType" OWNER TO biess_user;

--
-- Name: DocumentType_id_seq; Type: SEQUENCE; Schema: public; Owner: biess_user
--

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


ALTER SEQUENCE public."DocumentType_id_seq" OWNER TO biess_user;

--
-- Name: DocumentType_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: biess_user
--

ALTER SEQUENCE public."DocumentType_id_seq" OWNED BY public."DocumentType".id;


--
-- Name: Notification; Type: TABLE; Schema: public; Owner: biess_user
--

CREATE TABLE public."Notification" (
    id integer NOT NULL,
    message text NOT NULL,
    "isRead" boolean DEFAULT false NOT NULL,
    "createdAt" timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
    "userId" integer NOT NULL,
    "requestId" integer
);


ALTER TABLE public."Notification" OWNER TO biess_user;

--
-- Name: Notification_id_seq; Type: SEQUENCE; Schema: public; Owner: biess_user
--

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


ALTER SEQUENCE public."Notification_id_seq" OWNER TO biess_user;

--
-- Name: Notification_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: biess_user
--

ALTER SEQUENCE public."Notification_id_seq" OWNED BY public."Notification".id;


--
-- Name: Purok; Type: TABLE; Schema: public; Owner: biess_user
--

CREATE TABLE public."Purok" (
    id integer NOT NULL,
    name text NOT NULL,
    latitude double precision NOT NULL,
    longitude double precision NOT NULL,
    "createdAt" timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL
);


ALTER TABLE public."Purok" OWNER TO biess_user;

--
-- Name: Purok_id_seq; Type: SEQUENCE; Schema: public; Owner: biess_user
--

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


ALTER SEQUENCE public."Purok_id_seq" OWNER TO biess_user;

--
-- Name: Purok_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: biess_user
--

ALTER SEQUENCE public."Purok_id_seq" OWNED BY public."Purok".id;


--
-- Name: PushSubscription; Type: TABLE; Schema: public; Owner: biess_user
--

CREATE TABLE public."PushSubscription" (
    id integer NOT NULL,
    endpoint text NOT NULL,
    p256dh text NOT NULL,
    auth text NOT NULL,
    "createdAt" timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
    "userId" integer NOT NULL
);


ALTER TABLE public."PushSubscription" OWNER TO biess_user;

--
-- Name: PushSubscription_id_seq; Type: SEQUENCE; Schema: public; Owner: biess_user
--

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


ALTER SEQUENCE public."PushSubscription_id_seq" OWNER TO biess_user;

--
-- Name: PushSubscription_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: biess_user
--

ALTER SEQUENCE public."PushSubscription_id_seq" OWNED BY public."PushSubscription".id;


--
-- Name: Request; Type: TABLE; Schema: public; Owner: biess_user
--

CREATE TABLE public."Request" (
    id integer NOT NULL,
    "trackingCode" text NOT NULL,
    status public."RequestStatus" DEFAULT 'PENDING'::public."RequestStatus" NOT NULL,
    purpose text NOT NULL,
    "rejectReason" text,
    paid boolean DEFAULT false NOT NULL,
    "createdAt" timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
    "updatedAt" timestamp(3) without time zone NOT NULL,
    "userId" integer NOT NULL,
    "documentTypeId" integer NOT NULL
);


ALTER TABLE public."Request" OWNER TO biess_user;

--
-- Name: Request_id_seq; Type: SEQUENCE; Schema: public; Owner: biess_user
--

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


ALTER SEQUENCE public."Request_id_seq" OWNER TO biess_user;

--
-- Name: Request_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: biess_user
--

ALTER SEQUENCE public."Request_id_seq" OWNED BY public."Request".id;


--
-- Name: User; Type: TABLE; Schema: public; Owner: biess_user
--

CREATE TABLE public."User" (
    id integer NOT NULL,
    role public."Role" DEFAULT 'RESIDENT'::public."Role" NOT NULL,
    "firstName" text NOT NULL,
    "lastName" text NOT NULL,
    email text NOT NULL,
    phone text,
    "passwordHash" text NOT NULL,
    "createdAt" timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
    "fatherFullName" text,
    gender text,
    "isOnlyChild" boolean DEFAULT false NOT NULL,
    "motherMaidenName" text,
    "siblingNames" text[] DEFAULT ARRAY[]::text[],
    "middleName" text,
    barangay text,
    country text,
    municipality text,
    province text,
    "purokId" integer,
    "idRejectionReason" text,
    "idVerificationStatus" public."IdVerificationStatus" DEFAULT 'UNSUBMITTED'::public."IdVerificationStatus" NOT NULL,
    "idType" text,
    "idBackImageFilename" text,
    "idFrontImageFilename" text,
    "idSelfieImageFilename" text,
    "profilePictureFilename" text
);


ALTER TABLE public."User" OWNER TO biess_user;

--
-- Name: User_id_seq; Type: SEQUENCE; Schema: public; Owner: biess_user
--

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


ALTER SEQUENCE public."User_id_seq" OWNER TO biess_user;

--
-- Name: User_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: biess_user
--

ALTER SEQUENCE public."User_id_seq" OWNED BY public."User".id;


--
-- Name: _prisma_migrations; Type: TABLE; Schema: public; Owner: biess_user
--

CREATE TABLE public._prisma_migrations (
    id character varying(36) NOT NULL,
    checksum character varying(64) NOT NULL,
    finished_at timestamp with time zone,
    migration_name character varying(255) NOT NULL,
    logs text,
    rolled_back_at timestamp with time zone,
    started_at timestamp with time zone DEFAULT now() NOT NULL,
    applied_steps_count integer DEFAULT 0 NOT NULL
);


ALTER TABLE public._prisma_migrations OWNER TO biess_user;

--
-- Name: Appointment id; Type: DEFAULT; Schema: public; Owner: biess_user
--

ALTER TABLE ONLY public."Appointment" ALTER COLUMN id SET DEFAULT nextval('public."Appointment_id_seq"'::regclass);


--
-- Name: DocumentType id; Type: DEFAULT; Schema: public; Owner: biess_user
--

ALTER TABLE ONLY public."DocumentType" ALTER COLUMN id SET DEFAULT nextval('public."DocumentType_id_seq"'::regclass);


--
-- Name: Notification id; Type: DEFAULT; Schema: public; Owner: biess_user
--

ALTER TABLE ONLY public."Notification" ALTER COLUMN id SET DEFAULT nextval('public."Notification_id_seq"'::regclass);


--
-- Name: Purok id; Type: DEFAULT; Schema: public; Owner: biess_user
--

ALTER TABLE ONLY public."Purok" ALTER COLUMN id SET DEFAULT nextval('public."Purok_id_seq"'::regclass);


--
-- Name: PushSubscription id; Type: DEFAULT; Schema: public; Owner: biess_user
--

ALTER TABLE ONLY public."PushSubscription" ALTER COLUMN id SET DEFAULT nextval('public."PushSubscription_id_seq"'::regclass);


--
-- Name: Request id; Type: DEFAULT; Schema: public; Owner: biess_user
--

ALTER TABLE ONLY public."Request" ALTER COLUMN id SET DEFAULT nextval('public."Request_id_seq"'::regclass);


--
-- Name: User id; Type: DEFAULT; Schema: public; Owner: biess_user
--

ALTER TABLE ONLY public."User" ALTER COLUMN id SET DEFAULT nextval('public."User_id_seq"'::regclass);


--
-- Data for Name: Appointment; Type: TABLE DATA; Schema: public; Owner: biess_user
--

COPY public."Appointment" (id, date, "timeSlot", "createdAt", "requestId") FROM stdin;
1	2026-08-15	10:00-11:00	2026-08-09 15:28:22.949	3
2	2026-08-12	10:00-11:00	2026-08-09 15:50:28.608	4
3	2026-08-19	09:00-10:00	2026-08-18 18:59:52.74	6
4	2026-08-19	10:00-11:00	2026-08-18 19:00:48.08	5
5	2026-08-19	09:00-10:00	2026-08-18 19:38:26.709	7
6	2026-08-31	09:00-10:00	2026-08-27 09:28:35	8
7	2026-08-31	09:00-10:00	2026-08-27 09:47:45.943	9
\.


--
-- Data for Name: DocumentType; Type: TABLE DATA; Schema: public; Owner: biess_user
--

COPY public."DocumentType" (id, name, description, fee, "isActive", "createdAt", "maxPerSlot") FROM stdin;
7	TES Recommendation Letter	Eligibility scholarship certification 	50.00	t	2026-08-06 09:19:45.458	10
1	Barangay Clearance	General purpose clearance certifying good standing in the barangay.	50.00	t	2026-08-04 07:18:00.377	15
8	Presidential Scholarship	Application for Presidential Scholarship	0.00	t	2026-08-18 18:32:46.746	20
2	Certificate of Indigency	Certifies that the resident belongs to a low-income household.	50.00	t	2026-08-04 07:19:09.331	10
\.


--
-- Data for Name: Notification; Type: TABLE DATA; Schema: public; Owner: biess_user
--

COPY public."Notification" (id, message, "isRead", "createdAt", "userId", "requestId") FROM stdin;
1	Your request for Barangay Clearance (BIESS-2026-787C0D) was approved. Please pay ₱50.00 at the Barangay Hall to claim it.	f	2026-08-04 07:35:27.956	1	1
2	Your request for Barangay Clearance (BIESS-2026-A36232) was approved. Please pay ₱50.00 at the Barangay Hall to claim it.	f	2026-08-04 16:11:40.09	3	2
3	Your Barangay Clearance (BIESS-2026-A36232) is printed and ready for pickup at the Barangay Hall.	f	2026-08-04 16:16:51.169	3	2
4	Your Barangay Clearance (BIESS-2026-A36232) has been released. Thank you!	f	2026-08-07 02:09:47.088	3	2
5	Your Barangay Clearance (BIESS-2026-787C0D) is printed and ready for pickup at the Barangay Hall.	f	2026-08-07 02:10:13.372	1	1
6	Your Barangay Clearance (BIESS-2026-787C0D) has been released. Thank you!	f	2026-08-07 02:10:17.98	1	1
7	Your request for Barangay Clearance (BIESS-2026-724C7A) was approved. Please pay ₱50.00 at the Barangay Hall to claim it.	f	2026-08-09 15:26:59.051	1	3
8	Your Barangay Clearance (BIESS-2026-724C7A) is printed and ready for pickup at the Barangay Hall.	f	2026-08-09 15:27:38.281	1	3
9	Your Barangay Clearance (BIESS-2026-724C7A) is printed and ready for pickup at the Barangay Hall.	f	2026-08-09 15:27:41.825	1	3
10	Your request for Barangay Clearance (BIESS-2026-A98F6A) was approved. Please pay ₱50.00 at the Barangay Hall to claim it.	f	2026-08-09 15:47:57.48	1	4
11	Your Barangay Clearance (BIESS-2026-A98F6A) is printed and ready for pickup at the Barangay Hall.	f	2026-08-09 15:50:28.696	1	4
12	Your request for Certificate of Indigency (BIESS-2026-C8F622) was approved. Please pay ₱50.00 at the Barangay Hall to claim it.	f	2026-08-18 18:59:07.198	4	6
13	Your request for Certificate of Indigency (BIESS-2026-6EFC4F) was approved. Please pay ₱50.00 at the Barangay Hall to claim it.	f	2026-08-18 18:59:08.831	4	5
14	Your Certificate of Indigency (BIESS-2026-C8F622) is printed and ready for pickup at the Barangay Hall.	f	2026-08-18 18:59:52.787	4	6
15	Your Certificate of Indigency (BIESS-2026-6EFC4F) is printed and ready for pickup at the Barangay Hall.	f	2026-08-18 19:00:48.14	4	5
16	Your request for Barangay Clearance (BIESS-2026-7EC40D) was approved. Please pay ₱50.00 at the Barangay Hall to claim it.	f	2026-08-18 19:01:58.935	4	7
17	Your Barangay Clearance (BIESS-2026-7EC40D) is printed and ready for pickup at the Barangay Hall.	f	2026-08-18 19:38:26.764	4	7
18	Your password was changed successfully.	f	2026-08-18 19:40:52.51	4	\N
19	Your ID verification has been approved.	f	2026-08-18 20:58:34.169	4	\N
20	Your ID verification has been approved.	f	2026-08-27 06:16:24.676	13	\N
21	Your ID verification has been approved.	f	2026-08-27 06:16:24.679	13	\N
25	Your request for Barangay Clearance (BIESS-2026-7807CB) was approved. Please pay ₱50.00 at the Barangay Hall to claim it.	f	2026-08-27 09:47:38.104	16	9
26	Your Barangay Clearance (BIESS-2026-7807CB) is printed and ready for pickup at the Barangay Hall.	f	2026-08-27 09:47:45.991	16	9
24	Your Certificate of Indigency (BIESS-2026-A2B01D) is printed and ready for pickup at the Barangay Hall.	t	2026-08-27 09:28:35.038	15	8
23	Your request for Certificate of Indigency (BIESS-2026-A2B01D) was approved. Please pay ₱50.00 at the Barangay Hall to claim it.	t	2026-08-27 09:28:11.074	15	8
22	Your ID verification has been approved.	t	2026-08-27 07:03:42.034	15	\N
\.


--
-- Data for Name: Purok; Type: TABLE DATA; Schema: public; Owner: biess_user
--

COPY public."Purok" (id, name, latitude, longitude, "createdAt") FROM stdin;
2	Purok Tambis	10.1280460562208	124.8729819059372	2026-08-09 17:12:19.726
3	Purok Nangka	10.12899396299511	124.8733735084534	2026-08-28 16:21:03.367
1	Purok Mangga	10.13470774837819	124.8755836486817	2026-08-09 16:47:51.572
\.


--
-- Data for Name: PushSubscription; Type: TABLE DATA; Schema: public; Owner: biess_user
--

COPY public."PushSubscription" (id, endpoint, p256dh, auth, "createdAt", "userId") FROM stdin;
1	https://fcm.googleapis.com/fcm/send/ev0JpfwJaSQ:APA91bHyrEwiuygm-hvWpkImNIq6fSivLsz7_MAuq07XVmEyNL0xmYkNf4RIfkSaMt_giCOQJsIAr1Ak3i_D-iV9yowy-lYX54wsXQykJkvik5gsz6Q19kjFAI1-4wkx8DY1K6JsnAbE	BPC0qQmDSQ5gLSOTXGEqYA0SL5Oz0Ntx6YLR6gqrIg_8sexM_F7b6pjeT7E_Lf2Rlv4OL_WSIA6hE33xXyhXPxo	v5l913NCUA08L_QmNte_Fw	2026-08-18 19:36:30.332	4
2	https://fcm.googleapis.com/fcm/send/cwQtZwMDWD0:APA91bGhyE0mNpbHY8ucI7ntS9PSoDbSQPSp5RLSIVB7jJD0wbiBwbhGlBwb1BUJJj7XiUVueAzPkVMvLTg7_rDFX99InWyEzc4FGXGnsACByragY5FfJdzHJwVFhR8dsTPHygqIP5fR	BH4S_dDp7yVMLbMrIiBh9kwfOVSREOWxl7MCw0R6daScisN9i5DRjB6MDP8jxLYDLE1djIKjjji4Xk3nJdj16PA	IhERrwF9goke6TkYsrOS9w	2026-08-26 17:12:44.908	11
3	https://fcm.googleapis.com/fcm/send/d8_S9XmD8ek:APA91bG3sbADTzUKDiS_VerL4--lk9BUpcx8ukaxnmFuRjYtlg_G28YJ-KTUfzW5l4vB1piev--XDH-H_NM0VsTsexC36Df_Aim_dKNUztA-Jnb702aSlQfGyIFYnFYVc8vUQoLWp_fb	BHXAX2Wseuczl8feL4gNvGep8YE745ioDayKgfEAvB1-_tmNUck6U76r45rijTMMmnMhJBM69nyaMTABANsDD6g	fOdHDHmFDvrNW6rfk8VBfA	2026-08-27 05:38:40.542	15
\.


--
-- Data for Name: Request; Type: TABLE DATA; Schema: public; Owner: biess_user
--

COPY public."Request" (id, "trackingCode", status, purpose, "rejectReason", paid, "createdAt", "updatedAt", "userId", "documentTypeId") FROM stdin;
2	BIESS-2026-A36232	RELEASED	Para TES ni yati	\N	f	2026-08-04 14:57:29.243	2026-08-07 02:09:47.033	3	1
1	BIESS-2026-787C0D	RELEASED	Employment requirement	\N	f	2026-08-04 07:28:21.612	2026-08-07 02:10:17.959	1	1
3	BIESS-2026-724C7A	READY	Testing appointment booking	\N	f	2026-08-09 15:25:57.328	2026-08-09 15:27:41.809	1	1
4	BIESS-2026-A98F6A	READY	Testing appointment booking	\N	f	2026-08-09 15:29:19.099	2026-08-09 15:50:28.676	1	1
6	BIESS-2026-C8F622	READY	safasfasf	\N	f	2026-08-18 18:58:36.811	2026-08-18 18:59:52.776	4	2
5	BIESS-2026-6EFC4F	READY	pang BIR tin ID	\N	f	2026-08-18 18:58:22.495	2026-08-18 19:00:48.122	4	2
7	BIESS-2026-7EC40D	READY	fasfasf	\N	f	2026-08-18 19:01:51.531	2026-08-18 19:38:26.739	4	1
8	BIESS-2026-A2B01D	READY	For scholarship purposes	\N	f	2026-08-27 09:27:30.826	2026-08-27 09:28:35.026	15	2
9	BIESS-2026-7807CB	READY	for school	\N	f	2026-08-27 09:47:20.257	2026-08-27 09:47:45.974	16	1
\.


--
-- Data for Name: User; Type: TABLE DATA; Schema: public; Owner: biess_user
--

COPY public."User" (id, role, "firstName", "lastName", email, phone, "passwordHash", "createdAt", "fatherFullName", gender, "isOnlyChild", "motherMaidenName", "siblingNames", "middleName", barangay, country, municipality, province, "purokId", "idRejectionReason", "idVerificationStatus", "idType", "idBackImageFilename", "idFrontImageFilename", "idSelfieImageFilename", "profilePictureFilename") FROM stdin;
2	ADMIN	Barangay	Administrator	admin@isagani.gov.ph	\N	$2b$10$sNv6iCi4zj0HR.KYPwpl7enlFzH59p9JIiv3MZUUsospMH7jI22nS	2026-08-04 15:00:00	\N	\N	f	\N	{}	\N	\N	\N	\N	\N	\N	\N	UNSUBMITTED	\N	\N	\N	\N	\N
3	RESIDENT	Maria	Santos	maria@example.com	\N	$2b$10$7xP5qj8tupawiFdI5kxJF.OPpx0sI65pLlVasIa0El.dySqOOgkk2	2026-08-04 14:45:42.623	\N	\N	f	\N	{}	\N	\N	\N	\N	\N	\N	\N	UNSUBMITTED	\N	\N	\N	\N	\N
16	RESIDENT	vera	salubre	vera@gmail.com	09949653560	$2b$10$iEAe.kOKcIhY2Kthureem.rR6KWRPARIwZUVRMTLsSwYOkGZMeA1G	2026-08-27 09:33:57.887	\N	Female	f	\N	{}	\N	Isagani	Philippines	Maasin City	Southern Leyte	1	\N	UNSUBMITTED	\N	\N	\N	\N	\N
1	RESIDENT	Juan	Dela Cruz	juan@example.com	09171234567	$2b$10$oj6AmRNySPN1ypFXVaR.WesB55zbmE6zIsyXjlMnyCMmpiJ8PQf7.	2026-07-29 16:07:42.445	\N	\N	f	\N	{}	\N	\N	\N	\N	\N	\N	\N	UNSUBMITTED	\N	\N	\N	\N	\N
5	RESIDENT	Test	Resident	testpurok@example.com	\N	$2b$10$i95HRPRq8k/.KmsRFvUQ9.MgKl7CScY/HC13MVl3bVfVL9S4Uz.Ea	2026-08-09 16:59:29.439	\N	Male	f	\N	{}	\N	Isagani	Philippines	Maasin City	Southern Leyte	1	\N	UNSUBMITTED	\N	\N	\N	\N	\N
6	RESIDENT	fritz	aring	aringfritz@gmail.com	09753182324	$2b$10$TpROSPtAeKBhSq4HLYPsD.ll0AULLEi.u9CTD9VRZS4qqNXATVtry	2026-08-14 02:06:39.143	\N	Male	f	\N	{}	gaviola	isagani	Philippines	Maasin City	Southern Leyte	1	\N	UNSUBMITTED	\N	\N	\N	\N	\N
7	RESIDENT	ariel	doron	doronariel@gmail.com	09753182324	$2b$10$dSg9cAAQo7rP1XB3WvDWmeLEGF4lqesexZFaEgylbu5n7XQjRoF5u	2026-08-14 02:44:32.171	\N	Male	f	\N	{}	b	Isagani	Philippines	Maasin City	Southern Leyte	2	\N	UNSUBMITTED	\N	\N	\N	\N	\N
15	RESIDENT	Fritz Leenard	Aring	darktager64@gmail.com	09946535614	$2b$10$JdeSPbvBD6ZK0z9ceKqM.uhMTfmAcZTVh.ixMqjn054VjEJ.HyQ6G	2026-08-27 06:31:56.359	yo casyo	Male	t	nigga	{}	\N	Isagani	Philippines	Maasin City	Southern Leyte	1	\N	VERIFIED	Philippine National ID (PhilSys)	15-idBack-1787812375102.jpg	15-idFront-1787812375098.jpg	15-selfie-1787812375106.jpg	15-profile-1788541400526.jpg
8	RESIDENT	Prexie 	Enso	prexieenso@gmail.com	099264525465	$2b$10$pJ2MHFaODr6VDwllBF5IJuut1WBDwgd/UbnVBvvOOJDJc/ocHoaS.	2026-08-18 19:43:13.075	\N	Female	f	\N	{}	\N	Isagani	Philippines 	Maasin City	Southern Leyte	\N	\N	UNSUBMITTED	\N	\N	\N	\N	\N
9	RESIDENT	Fritz	Aring	leenard@gmail.com	09566256514	$2b$10$unNXAN2UT04Dyvl22MEeH.Zf2jYeJcSZUUUAbSx44YJQRZtCUQq9W	2026-08-18 19:56:33.866	\N	Male	f	\N	{}	Leenard	Isagani	Philippines	Maasin	Southern Leyte	1	\N	UNSUBMITTED	\N	\N	\N	\N	\N
10	RESIDENT	John 	Andre	andre@gmail.com	09924562131	$2b$10$tO6blDfHKWIryFITd6jPaOEAMvQVVv.6ICUyUbCI5JjJg85xpanhe	2026-08-18 20:11:03.63	\N	Male	f	\N	{}	\N	Isagani	Philippines	Maasin City	Southern Leyte	1	\N	UNSUBMITTED	\N	\N	\N	\N	\N
4	RESIDENT	John Andre	Salubre	johnandre@gmail.com	0992653	$2b$10$KcA2JiGqUUFBVrHwJ6Hg5e1sssTYMVDv6BkPucYQephDf6zXygzpC	2026-08-04 15:23:35.459	Ariel Doron	Male	f	Prexie Enso	{"Jhay Cajes","Fritz Aring"}	\N	\N	\N	\N	\N	\N	\N	VERIFIED	Philippine Passport	\N	\N	\N	\N
11	RESIDENT	nigga	enso	nigga@gmail.com	09924695356	$2b$10$WPaPvzp1t5G7qTsDuudfl.4M7hJdqPAxEQ7lsvDljJWMfSIkDJvBO	2026-08-26 17:12:35.82	\N	Male	f	\N	{}	\N	Isagani	Philippines	Maasin City	Southern Leyte	1	\N	UNSUBMITTED	\N	\N	\N	\N	\N
12	RESIDENT	prexie	gwapa	prexie@gmail.com	09924965356	$2b$10$2HRpDamM4.jlIMxTyHJ/yOqQMpzR9jALJQ29EOO6bf7.HhEjgn7Xu	2026-08-26 17:29:41.984	\N	Female	f	\N	{}	\N	Isagani	Philippines	Maasin City	Southern Leyte	2	\N	UNSUBMITTED	\N	\N	\N	\N	\N
13	RESIDENT	Prexie	Gwapa	gwapa@gmail.com	09949653561	$2b$10$jr0Svxad8yE7aXlSZr2BlOJ3JuH6SjcnjL.fMNz20nYzl5Hyn8AM.	2026-08-27 05:38:34.428	\N	Female	f	\N	{}	\N	Isagani	Philippines	Maasin City	Southern Leyte	1	\N	VERIFIED	Philippine National ID (PhilSys)	13-idBack-1787809137844.jpg	13-idFront-1787809137819.jpg	13-selfie-1787809137851.jpg	\N
14	RESIDENT	Nigga 	Prexie	prexiegwapa@gmail.com	09949653561	$2b$10$m6pq2MmpYo0BcRz6qNpow.1YSBHTwm3VLuDjbQ39u4nRg4ukUikTu	2026-08-27 06:26:09.699	Ariel Doron	Female	f	Ronalda Dayona	{"Fritz Aring"}	\N	Isagani	Philippines	Maasin City	Southern Leyte	2	\N	PENDING	Philippine National ID (PhilSys)	14-idBack-1787812209065.jpg	14-idFront-1787812209057.jpg	14-selfie-1787812209071.jpg	\N
\.


--
-- Data for Name: _prisma_migrations; Type: TABLE DATA; Schema: public; Owner: biess_user
--

COPY public._prisma_migrations (id, checksum, finished_at, migration_name, logs, rolled_back_at, started_at, applied_steps_count) FROM stdin;
2a3a40cb-15ef-4243-83f1-4f4ce5de0e68	6c01322c79deda771298f4ee4624111ad8484c64e9629142545659fde3faf1df	2026-07-29 15:08:38.269453+00	20260729150838_init	\N	\N	2026-07-29 15:08:38.143375+00	1
d1498057-0cd5-4c9c-a3ff-73f269e17364	2a103029a6e198fe072f1b509af65e6ead34482c4103bc66d5b92d79131b9cbf	2026-08-04 15:07:44.907631+00	20260804150744_add_resident_details	\N	\N	2026-08-04 15:07:44.883618+00	1
ece35b33-8348-43cf-ad09-bc9815c1ae83	bb70b0c3f0af13bd66d677f8dab90dbe9f5e089d5f265321453015c038a6f3dc	2026-08-04 15:30:18.836781+00	20260804153018_add_middle_name	\N	\N	2026-08-04 15:30:18.82198+00	1
add3f428-e5a5-4fcc-b2ff-c4d5c54cf59c	3c5afdc639c04a0dc5d01f16da23626e7f45654775929e9ff4eb47d5a728f2bc	2026-08-09 15:12:11.112997+00	20260809151211_add_appointments	\N	\N	2026-08-09 15:12:11.037417+00	1
a82b65be-e1cd-4ef0-a36e-f5febfcceec9	3f1eef24201d06a4ec7fc385225073d0e91eaa80134f66776e57ce5c466c61cd	2026-08-09 16:39:46.573836+00	20260809163946_add_purok_and_split_address	\N	\N	2026-08-09 16:39:46.501856+00	1
f8b95ff8-790a-49fc-b7ef-cb4c45a8442b	9168d0dbe41a6de6058c7908bacae21d6dabb7bfec55ceecf23e48f116e491d8	2026-08-18 18:20:46.732486+00	20260818182046_per_document_type_capacity	\N	\N	2026-08-18 18:20:46.682492+00	1
8da29683-c82c-429f-9ec5-9263bfe32ba5	323e3c2d6ee1b27c20ac0ffbdf67b42eb1a7e9a8bf6b70cf8e51a7f120c3695a	2026-08-18 19:15:30.787841+00	20260818191530_add_push_subscription	\N	\N	2026-08-18 19:15:30.728411+00	1
fc9e8987-d902-41ac-b785-b01064753a54	cf54bdc6c9e5927deed063a032151b02a87c2051c342a9af68b8a9879c036ed1	2026-08-18 20:16:06.038807+00	20260818201605_add_id_verification	\N	\N	2026-08-18 20:16:06.01321+00	1
a1b6593d-515f-4812-b815-0fdc27f31c22	d82162406394293edf8c93f2e18c7a73d46dad1d3a4c0cbbbdc58825b85cee58	2026-08-18 20:28:36.211794+00	20260818202836_add_id_type	\N	\N	2026-08-18 20:28:36.187433+00	1
a565c8a8-0abd-4201-a08c-fa0f29463c05	7379d69524d1b9284cce3b47e28ee8875b4c68232954021068cab9e8298c9f20	2026-08-26 17:23:33.393801+00	20260826172333_split_id_images	\N	\N	2026-08-26 17:23:33.345599+00	1
be33f690-6aaa-4a7c-8625-2bd8d88b3606	d3ec8ada7a5c2ed8b782cbfc95b8518af0c335d16873aa18f98ca092ac61e2da	2026-09-04 16:31:15.37976+00	20260904163115_add_profile_picture	\N	\N	2026-09-04 16:31:15.356059+00	1
\.


--
-- Name: Appointment_id_seq; Type: SEQUENCE SET; Schema: public; Owner: biess_user
--

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


--
-- Name: DocumentType_id_seq; Type: SEQUENCE SET; Schema: public; Owner: biess_user
--

SELECT pg_catalog.setval('public."DocumentType_id_seq"', 8, true);


--
-- Name: Notification_id_seq; Type: SEQUENCE SET; Schema: public; Owner: biess_user
--

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


--
-- Name: Purok_id_seq; Type: SEQUENCE SET; Schema: public; Owner: biess_user
--

SELECT pg_catalog.setval('public."Purok_id_seq"', 3, true);


--
-- Name: PushSubscription_id_seq; Type: SEQUENCE SET; Schema: public; Owner: biess_user
--

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


--
-- Name: Request_id_seq; Type: SEQUENCE SET; Schema: public; Owner: biess_user
--

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


--
-- Name: User_id_seq; Type: SEQUENCE SET; Schema: public; Owner: biess_user
--

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


--
-- Name: Appointment Appointment_pkey; Type: CONSTRAINT; Schema: public; Owner: biess_user
--

ALTER TABLE ONLY public."Appointment"
    ADD CONSTRAINT "Appointment_pkey" PRIMARY KEY (id);


--
-- Name: DocumentType DocumentType_pkey; Type: CONSTRAINT; Schema: public; Owner: biess_user
--

ALTER TABLE ONLY public."DocumentType"
    ADD CONSTRAINT "DocumentType_pkey" PRIMARY KEY (id);


--
-- Name: Notification Notification_pkey; Type: CONSTRAINT; Schema: public; Owner: biess_user
--

ALTER TABLE ONLY public."Notification"
    ADD CONSTRAINT "Notification_pkey" PRIMARY KEY (id);


--
-- Name: Purok Purok_pkey; Type: CONSTRAINT; Schema: public; Owner: biess_user
--

ALTER TABLE ONLY public."Purok"
    ADD CONSTRAINT "Purok_pkey" PRIMARY KEY (id);


--
-- Name: PushSubscription PushSubscription_pkey; Type: CONSTRAINT; Schema: public; Owner: biess_user
--

ALTER TABLE ONLY public."PushSubscription"
    ADD CONSTRAINT "PushSubscription_pkey" PRIMARY KEY (id);


--
-- Name: Request Request_pkey; Type: CONSTRAINT; Schema: public; Owner: biess_user
--

ALTER TABLE ONLY public."Request"
    ADD CONSTRAINT "Request_pkey" PRIMARY KEY (id);


--
-- Name: User User_pkey; Type: CONSTRAINT; Schema: public; Owner: biess_user
--

ALTER TABLE ONLY public."User"
    ADD CONSTRAINT "User_pkey" PRIMARY KEY (id);


--
-- Name: _prisma_migrations _prisma_migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: biess_user
--

ALTER TABLE ONLY public._prisma_migrations
    ADD CONSTRAINT _prisma_migrations_pkey PRIMARY KEY (id);


--
-- Name: Appointment_requestId_key; Type: INDEX; Schema: public; Owner: biess_user
--

CREATE UNIQUE INDEX "Appointment_requestId_key" ON public."Appointment" USING btree ("requestId");


--
-- Name: DocumentType_name_key; Type: INDEX; Schema: public; Owner: biess_user
--

CREATE UNIQUE INDEX "DocumentType_name_key" ON public."DocumentType" USING btree (name);


--
-- Name: Purok_name_key; Type: INDEX; Schema: public; Owner: biess_user
--

CREATE UNIQUE INDEX "Purok_name_key" ON public."Purok" USING btree (name);


--
-- Name: PushSubscription_endpoint_key; Type: INDEX; Schema: public; Owner: biess_user
--

CREATE UNIQUE INDEX "PushSubscription_endpoint_key" ON public."PushSubscription" USING btree (endpoint);


--
-- Name: Request_trackingCode_key; Type: INDEX; Schema: public; Owner: biess_user
--

CREATE UNIQUE INDEX "Request_trackingCode_key" ON public."Request" USING btree ("trackingCode");


--
-- Name: User_email_key; Type: INDEX; Schema: public; Owner: biess_user
--

CREATE UNIQUE INDEX "User_email_key" ON public."User" USING btree (email);


--
-- Name: Appointment Appointment_requestId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: biess_user
--

ALTER TABLE ONLY public."Appointment"
    ADD CONSTRAINT "Appointment_requestId_fkey" FOREIGN KEY ("requestId") REFERENCES public."Request"(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: Notification Notification_requestId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: biess_user
--

ALTER TABLE ONLY public."Notification"
    ADD CONSTRAINT "Notification_requestId_fkey" FOREIGN KEY ("requestId") REFERENCES public."Request"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: Notification Notification_userId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: biess_user
--

ALTER TABLE ONLY public."Notification"
    ADD CONSTRAINT "Notification_userId_fkey" FOREIGN KEY ("userId") REFERENCES public."User"(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: PushSubscription PushSubscription_userId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: biess_user
--

ALTER TABLE ONLY public."PushSubscription"
    ADD CONSTRAINT "PushSubscription_userId_fkey" FOREIGN KEY ("userId") REFERENCES public."User"(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: Request Request_documentTypeId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: biess_user
--

ALTER TABLE ONLY public."Request"
    ADD CONSTRAINT "Request_documentTypeId_fkey" FOREIGN KEY ("documentTypeId") REFERENCES public."DocumentType"(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: Request Request_userId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: biess_user
--

ALTER TABLE ONLY public."Request"
    ADD CONSTRAINT "Request_userId_fkey" FOREIGN KEY ("userId") REFERENCES public."User"(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: User User_purokId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: biess_user
--

ALTER TABLE ONLY public."User"
    ADD CONSTRAINT "User_purokId_fkey" FOREIGN KEY ("purokId") REFERENCES public."Purok"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- PostgreSQL database dump complete
--

\unrestrict mO4150krz3BsMfWEPx3Zvjl31K0OokxzJhSHvB9OTTAzskuG7l6bbBPkGYjB7AC