-- -- PostgreSQL database dump -- \restrict 2l8yiQSFkYv15SaYOKvljtc2SVHJ8QqYcnaIZUgblP9KugP5XCZJxQXL0g6Et1N -- Dumped from database version 18.3 -- Dumped by pg_dump version 18.3 SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_timeout = 0; SET transaction_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; SET default_tablespace = ''; SET default_table_access_method = heap; -- -- Name: announcements; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.announcements ( id bigint NOT NULL, judul character varying(255) NOT NULL, isi text NOT NULL, is_published boolean DEFAULT false NOT NULL, published_at timestamp(0) without time zone, created_at timestamp(0) without time zone, updated_at timestamp(0) without time zone, status character varying(255) DEFAULT 'draft'::character varying NOT NULL, CONSTRAINT announcements_status_check CHECK (((status)::text = ANY ((ARRAY['draft'::character varying, 'published'::character varying])::text[]))) ); ALTER TABLE public.announcements OWNER TO postgres; -- -- Name: announcements_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.announcements_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.announcements_id_seq OWNER TO postgres; -- -- Name: announcements_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.announcements_id_seq OWNED BY public.announcements.id; -- -- Name: cache; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.cache ( key character varying(255) NOT NULL, value text NOT NULL, expiration integer NOT NULL ); ALTER TABLE public.cache OWNER TO postgres; -- -- Name: cache_locks; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.cache_locks ( key character varying(255) NOT NULL, owner character varying(255) NOT NULL, expiration integer NOT NULL ); ALTER TABLE public.cache_locks OWNER TO postgres; -- -- Name: documents; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.documents ( id bigint NOT NULL, registration_id bigint NOT NULL, jenis_dokumen character varying(255) NOT NULL, cloudinary_url character varying(255) NOT NULL, cloudinary_public_id character varying(255) NOT NULL, status_verifikasi character varying(255) DEFAULT 'belum_upload'::character varying NOT NULL, catatan text, created_at timestamp(0) without time zone, updated_at timestamp(0) without time zone, CONSTRAINT documents_jenis_dokumen_check CHECK (((jenis_dokumen)::text = ANY ((ARRAY['foto'::character varying, 'kk'::character varying, 'ijazah'::character varying, 'rapor'::character varying, 'piagam'::character varying])::text[]))), CONSTRAINT documents_status_verifikasi_check CHECK (((status_verifikasi)::text = ANY ((ARRAY['belum_upload'::character varying, 'menunggu_verifikasi'::character varying, 'disetujui'::character varying, 'ditolak'::character varying])::text[]))) ); ALTER TABLE public.documents OWNER TO postgres; -- -- Name: documents_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.documents_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.documents_id_seq OWNER TO postgres; -- -- Name: documents_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.documents_id_seq OWNED BY public.documents.id; -- -- Name: failed_jobs; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.failed_jobs ( id bigint NOT NULL, uuid character varying(255) NOT NULL, connection text NOT NULL, queue text NOT NULL, payload text NOT NULL, exception text NOT NULL, failed_at timestamp(0) without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL ); ALTER TABLE public.failed_jobs OWNER TO postgres; -- -- Name: failed_jobs_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.failed_jobs_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.failed_jobs_id_seq OWNER TO postgres; -- -- Name: failed_jobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.failed_jobs_id_seq OWNED BY public.failed_jobs.id; -- -- Name: jalur_pendaftaran; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.jalur_pendaftaran ( id bigint NOT NULL, nama character varying(255) NOT NULL, kuota integer NOT NULL, deskripsi text, created_at timestamp(0) without time zone, updated_at timestamp(0) without time zone ); ALTER TABLE public.jalur_pendaftaran OWNER TO postgres; -- -- Name: jalur_pendaftaran_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.jalur_pendaftaran_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.jalur_pendaftaran_id_seq OWNER TO postgres; -- -- Name: jalur_pendaftaran_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.jalur_pendaftaran_id_seq OWNED BY public.jalur_pendaftaran.id; -- -- Name: job_batches; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.job_batches ( id character varying(255) NOT NULL, name character varying(255) NOT NULL, total_jobs integer NOT NULL, pending_jobs integer NOT NULL, failed_jobs integer NOT NULL, failed_job_ids text NOT NULL, options text, cancelled_at integer, created_at integer NOT NULL, finished_at integer ); ALTER TABLE public.job_batches OWNER TO postgres; -- -- Name: jobs; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.jobs ( id bigint NOT NULL, queue character varying(255) NOT NULL, payload text NOT NULL, attempts smallint NOT NULL, reserved_at integer, available_at integer NOT NULL, created_at integer NOT NULL ); ALTER TABLE public.jobs OWNER TO postgres; -- -- Name: jobs_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.jobs_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.jobs_id_seq OWNER TO postgres; -- -- Name: jobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.jobs_id_seq OWNED BY public.jobs.id; -- -- Name: migrations; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.migrations ( id integer NOT NULL, migration character varying(255) NOT NULL, batch integer NOT NULL ); ALTER TABLE public.migrations OWNER TO postgres; -- -- Name: migrations_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.migrations_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.migrations_id_seq OWNER TO postgres; -- -- Name: migrations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.migrations_id_seq OWNED BY public.migrations.id; -- -- Name: password_reset_tokens; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.password_reset_tokens ( email character varying(255) NOT NULL, token character varying(255) NOT NULL, created_at timestamp(0) without time zone ); ALTER TABLE public.password_reset_tokens OWNER TO postgres; -- -- Name: registrations; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.registrations ( id bigint NOT NULL, student_id bigint NOT NULL, jalur_id bigint NOT NULL, nomor_pendaftaran character varying(255) NOT NULL, status character varying(255) DEFAULT 'menunggu_upload'::character varying NOT NULL, ranking_nilai integer, catatan_admin text, created_at timestamp(0) without time zone, updated_at timestamp(0) without time zone, is_final boolean DEFAULT false NOT NULL, CONSTRAINT registrations_status_check CHECK (((status)::text = ANY ((ARRAY['menunggu_upload'::character varying, 'menunggu_verifikasi'::character varying, 'terverifikasi'::character varying, 'diterima'::character varying, 'tidak_diterima'::character varying])::text[]))) ); ALTER TABLE public.registrations OWNER TO postgres; -- -- Name: registrations_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.registrations_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.registrations_id_seq OWNER TO postgres; -- -- Name: registrations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.registrations_id_seq OWNED BY public.registrations.id; -- -- Name: sessions; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.sessions ( id character varying(255) NOT NULL, user_id bigint, ip_address character varying(45), user_agent text, payload text NOT NULL, last_activity integer NOT NULL ); ALTER TABLE public.sessions OWNER TO postgres; -- -- Name: students; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.students ( id bigint NOT NULL, user_id bigint NOT NULL, nik character varying(255) NOT NULL, nama_lengkap character varying(255) NOT NULL, tempat_lahir character varying(255) NOT NULL, tanggal_lahir date NOT NULL, jenis_kelamin character varying(255) NOT NULL, agama character varying(255) NOT NULL, alamat text NOT NULL, no_hp character varying(255) NOT NULL, nama_ayah character varying(255) NOT NULL, nama_ibu character varying(255) NOT NULL, pekerjaan_ortu character varying(255) NOT NULL, sekolah_asal character varying(255) NOT NULL, nilai_rata_rata numeric(5,2) NOT NULL, created_at timestamp(0) without time zone, updated_at timestamp(0) without time zone, kecamatan character varying(255), CONSTRAINT students_jenis_kelamin_check CHECK (((jenis_kelamin)::text = ANY ((ARRAY['L'::character varying, 'P'::character varying])::text[]))) ); ALTER TABLE public.students OWNER TO postgres; -- -- Name: students_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.students_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.students_id_seq OWNER TO postgres; -- -- Name: students_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.students_id_seq OWNED BY public.students.id; -- -- Name: users; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.users ( id bigint NOT NULL, name character varying(255) NOT NULL, email character varying(255) NOT NULL, email_verified_at timestamp(0) without time zone, password character varying(255) NOT NULL, role character varying(255) DEFAULT 'student'::character varying NOT NULL, remember_token character varying(100), created_at timestamp(0) without time zone, updated_at timestamp(0) without time zone, CONSTRAINT users_role_check CHECK (((role)::text = ANY ((ARRAY['admin'::character varying, 'panitia'::character varying, 'student'::character varying])::text[]))) ); ALTER TABLE public.users OWNER TO postgres; -- -- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.users_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER SEQUENCE public.users_id_seq OWNER TO postgres; -- -- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.users_id_seq OWNED BY public.users.id; -- -- Name: announcements id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.announcements ALTER COLUMN id SET DEFAULT nextval('public.announcements_id_seq'::regclass); -- -- Name: documents id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.documents ALTER COLUMN id SET DEFAULT nextval('public.documents_id_seq'::regclass); -- -- Name: failed_jobs id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.failed_jobs ALTER COLUMN id SET DEFAULT nextval('public.failed_jobs_id_seq'::regclass); -- -- Name: jalur_pendaftaran id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.jalur_pendaftaran ALTER COLUMN id SET DEFAULT nextval('public.jalur_pendaftaran_id_seq'::regclass); -- -- Name: jobs id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.jobs ALTER COLUMN id SET DEFAULT nextval('public.jobs_id_seq'::regclass); -- -- Name: migrations id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.migrations ALTER COLUMN id SET DEFAULT nextval('public.migrations_id_seq'::regclass); -- -- Name: registrations id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.registrations ALTER COLUMN id SET DEFAULT nextval('public.registrations_id_seq'::regclass); -- -- Name: students id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.students ALTER COLUMN id SET DEFAULT nextval('public.students_id_seq'::regclass); -- -- Name: users id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.users ALTER COLUMN id SET DEFAULT nextval('public.users_id_seq'::regclass); -- -- Data for Name: announcements; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.announcements (id, judul, isi, is_published, published_at, created_at, updated_at, status) FROM stdin; \. -- -- Data for Name: cache; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.cache (key, value, expiration) FROM stdin; \. -- -- Data for Name: cache_locks; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.cache_locks (key, owner, expiration) FROM stdin; \. -- -- Data for Name: documents; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.documents (id, registration_id, jenis_dokumen, cloudinary_url, cloudinary_public_id, status_verifikasi, catatan, created_at, updated_at) FROM stdin; 1 1 foto https://res.cloudinary.com/drdjfs1us/image/upload/v1785913001/dxzgh889ppe1igokrupc.png dxzgh889ppe1igokrupc disetujui \N 2026-08-05 06:56:42 2026-08-05 07:05:22 2 1 kk https://res.cloudinary.com/drdjfs1us/image/upload/v1785913004/gn0ajfwgfw6s2vinuxft.png gn0ajfwgfw6s2vinuxft disetujui \N 2026-08-05 06:56:45 2026-08-05 07:05:24 3 1 ijazah https://res.cloudinary.com/drdjfs1us/image/upload/v1785913006/kifofbraoxg7cd0dkts2.png kifofbraoxg7cd0dkts2 disetujui \N 2026-08-05 06:56:47 2026-08-05 07:05:26 4 1 rapor https://res.cloudinary.com/drdjfs1us/image/upload/v1785913008/uiygisnrhpmt8y9rxgzr.png uiygisnrhpmt8y9rxgzr disetujui \N 2026-08-05 06:56:48 2026-08-05 07:05:28 5 1 piagam https://res.cloudinary.com/drdjfs1us/image/upload/v1785913010/bcqefgnn2r8ywp61xjrf.png bcqefgnn2r8ywp61xjrf disetujui \N 2026-08-05 06:56:51 2026-08-05 07:05:30 \. -- -- Data for Name: failed_jobs; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.failed_jobs (id, uuid, connection, queue, payload, exception, failed_at) FROM stdin; \. -- -- Data for Name: jalur_pendaftaran; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.jalur_pendaftaran (id, nama, kuota, deskripsi, created_at, updated_at) FROM stdin; 1 Reguler 20 Seleksi berdasarkan nilai rapor 2026-08-05 06:52:58 2026-08-05 06:52:58 2 Prestasi 8 Wajib sertifikat prestasi 2026-08-05 06:52:58 2026-08-05 06:52:58 3 Zonasi 5 Domisili sesuai kecamatan 2026-08-05 06:52:58 2026-08-05 06:52:58 \. -- -- Data for Name: job_batches; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.job_batches (id, name, total_jobs, pending_jobs, failed_jobs, failed_job_ids, options, cancelled_at, created_at, finished_at) FROM stdin; \. -- -- Data for Name: jobs; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.jobs (id, queue, payload, attempts, reserved_at, available_at, created_at) FROM stdin; \. -- -- Data for Name: migrations; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.migrations (id, migration, batch) FROM stdin; 1 0001_01_01_000000_create_users_table 1 2 0001_01_01_000001_create_cache_table 1 3 0001_01_01_000002_create_jobs_table 1 4 2026_06_12_061551_create_students_table 1 5 2026_06_12_061647_create_jalur_pendaftaran_table 1 6 2026_06_12_061758_create_registrations_table 1 7 2026_06_12_061903_create_documents_table 1 8 2026_06_12_061953_create_announcements_table 1 9 2026_06_23_060424_add_status_to_announcements_table 1 10 2026_06_23_071406_add_is_final_to_registrations_table 1 11 2026_08_05_070006_add_kecamatan_to_students_table 2 \. -- -- Data for Name: password_reset_tokens; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.password_reset_tokens (email, token, created_at) FROM stdin; \. -- -- Data for Name: registrations; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.registrations (id, student_id, jalur_id, nomor_pendaftaran, status, ranking_nilai, catatan_admin, created_at, updated_at, is_final) FROM stdin; 1 1 2 PPDB-2026-00001 diterima 1 \N 2026-08-05 06:55:40 2026-08-05 07:06:29 f \. -- -- Data for Name: sessions; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.sessions (id, user_id, ip_address, user_agent, payload, last_activity) FROM stdin; 5FDVG2FSnz0ErUzvsGwfyqwYetPtaH5hUOejSce7 \N 127.0.0.1 Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Code/1.131.0 Chrome/148.0.7778.280 Electron/42.7.0 Safari/537.36 YTozOntzOjY6Il90b2tlbiI7czo0MDoiYkZOWHZuUW9mV1UxSFRYTTk3d25sZWx1N3UzS0pkN2VoU2tYdEQ4TCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMCI7czo1OiJyb3V0ZSI7Tjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ== 1785912802 MkeTQfFFwYryzfiiKLVGKrNhjAhhh4BYDcoPyoTB \N 127.0.0.1 Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36 YTozOntzOjY6Il90b2tlbiI7czo0MDoicG1zN3hiWWJINUV4SFczM0d2YjBaY2lBVzV6d0Q4RldTc0paSTMxMCI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzA6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9yZWdpc3RlciI7czo1OiJyb3V0ZSI7Tjt9fQ== 1785914111 \. -- -- Data for Name: students; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.students (id, user_id, nik, nama_lengkap, tempat_lahir, tanggal_lahir, jenis_kelamin, agama, alamat, no_hp, nama_ayah, nama_ibu, pekerjaan_ortu, sekolah_asal, nilai_rata_rata, created_at, updated_at, kecamatan) FROM stdin; 1 2 1234567891234567 Marhadi Akbar Karawang 1997-08-06 L Islam Perumahan CKM\r\nBlok x14 no 0825656565656 Dadang rodiah BURUH smpn 2 leles 90.00 2026-08-05 06:55:40 2026-08-05 06:55:40 \N \. -- -- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY public.users (id, name, email, email_verified_at, password, role, remember_token, created_at, updated_at) FROM stdin; 1 Admin PPDB admin@ppdb.com \N $2y$12$i01satr0oN9Ra0rdUkz09OcIs9bpNWRLIqENPwqLUJ4L4TCcNZLRe admin \N 2026-08-05 06:52:58 2026-08-05 06:52:58 2 Marhadi Akbar marhadiakbar634@gmail.com \N $2y$12$M2xsCkq9KyOkpOKeqh5tgOE1Xs.HTkiY3nx62g5qVk/9cF9e0fuOm student \N 2026-08-05 06:54:47 2026-08-05 06:54:47 3 Nadia Rizky nadia12@gmail.com \N $2y$12$nW2GdipsS0KM0VM6jcBfKesfIN.DE7at.0OZxdePeuHtYozw8KMYK panitia \N 2026-08-05 07:04:39 2026-08-05 07:04:39 \. -- -- Name: announcements_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.announcements_id_seq', 1, false); -- -- Name: documents_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.documents_id_seq', 5, true); -- -- Name: failed_jobs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.failed_jobs_id_seq', 1, false); -- -- Name: jalur_pendaftaran_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.jalur_pendaftaran_id_seq', 3, true); -- -- Name: jobs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.jobs_id_seq', 1, false); -- -- Name: migrations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.migrations_id_seq', 11, true); -- -- Name: registrations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.registrations_id_seq', 1, true); -- -- Name: students_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.students_id_seq', 1, true); -- -- Name: users_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('public.users_id_seq', 3, true); -- -- Name: announcements announcements_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.announcements ADD CONSTRAINT announcements_pkey PRIMARY KEY (id); -- -- Name: cache_locks cache_locks_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.cache_locks ADD CONSTRAINT cache_locks_pkey PRIMARY KEY (key); -- -- Name: cache cache_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.cache ADD CONSTRAINT cache_pkey PRIMARY KEY (key); -- -- Name: documents documents_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.documents ADD CONSTRAINT documents_pkey PRIMARY KEY (id); -- -- Name: failed_jobs failed_jobs_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.failed_jobs ADD CONSTRAINT failed_jobs_pkey PRIMARY KEY (id); -- -- Name: failed_jobs failed_jobs_uuid_unique; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.failed_jobs ADD CONSTRAINT failed_jobs_uuid_unique UNIQUE (uuid); -- -- Name: jalur_pendaftaran jalur_pendaftaran_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.jalur_pendaftaran ADD CONSTRAINT jalur_pendaftaran_pkey PRIMARY KEY (id); -- -- Name: job_batches job_batches_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.job_batches ADD CONSTRAINT job_batches_pkey PRIMARY KEY (id); -- -- Name: jobs jobs_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.jobs ADD CONSTRAINT jobs_pkey PRIMARY KEY (id); -- -- Name: migrations migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.migrations ADD CONSTRAINT migrations_pkey PRIMARY KEY (id); -- -- Name: password_reset_tokens password_reset_tokens_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.password_reset_tokens ADD CONSTRAINT password_reset_tokens_pkey PRIMARY KEY (email); -- -- Name: registrations registrations_nomor_pendaftaran_unique; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.registrations ADD CONSTRAINT registrations_nomor_pendaftaran_unique UNIQUE (nomor_pendaftaran); -- -- Name: registrations registrations_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.registrations ADD CONSTRAINT registrations_pkey PRIMARY KEY (id); -- -- Name: sessions sessions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.sessions ADD CONSTRAINT sessions_pkey PRIMARY KEY (id); -- -- Name: students students_nik_unique; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.students ADD CONSTRAINT students_nik_unique UNIQUE (nik); -- -- Name: students students_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.students ADD CONSTRAINT students_pkey PRIMARY KEY (id); -- -- Name: users users_email_unique; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.users ADD CONSTRAINT users_email_unique UNIQUE (email); -- -- Name: users users_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.users ADD CONSTRAINT users_pkey PRIMARY KEY (id); -- -- Name: cache_expiration_index; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX cache_expiration_index ON public.cache USING btree (expiration); -- -- Name: cache_locks_expiration_index; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX cache_locks_expiration_index ON public.cache_locks USING btree (expiration); -- -- Name: jobs_queue_index; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX jobs_queue_index ON public.jobs USING btree (queue); -- -- Name: sessions_last_activity_index; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX sessions_last_activity_index ON public.sessions USING btree (last_activity); -- -- Name: sessions_user_id_index; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX sessions_user_id_index ON public.sessions USING btree (user_id); -- -- Name: documents documents_registration_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.documents ADD CONSTRAINT documents_registration_id_foreign FOREIGN KEY (registration_id) REFERENCES public.registrations(id) ON DELETE CASCADE; -- -- Name: registrations registrations_jalur_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.registrations ADD CONSTRAINT registrations_jalur_id_foreign FOREIGN KEY (jalur_id) REFERENCES public.jalur_pendaftaran(id); -- -- Name: registrations registrations_student_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.registrations ADD CONSTRAINT registrations_student_id_foreign FOREIGN KEY (student_id) REFERENCES public.students(id) ON DELETE CASCADE; -- -- Name: students students_user_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.students ADD CONSTRAINT students_user_id_foreign FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE; -- -- PostgreSQL database dump complete -- \unrestrict 2l8yiQSFkYv15SaYOKvljtc2SVHJ8QqYcnaIZUgblP9KugP5XCZJxQXL0g6Et1N