22 lines
1.2 KiB
SQL
22 lines
1.2 KiB
SQL
-- Seed Data Transaksional Izin Lingkungan (AMDAL / UKL-UPL)
|
|
CREATE TABLE IF NOT EXISTS public.environmental_permits (
|
|
id SERIAL PRIMARY KEY,
|
|
permit_number VARCHAR(64) UNIQUE NOT NULL,
|
|
company_name VARCHAR(255) NOT NULL,
|
|
permit_type VARCHAR(32) NOT NULL,
|
|
issued_date DATE NOT NULL,
|
|
status VARCHAR(32) NOT NULL,
|
|
watermark_ts TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP,
|
|
updated_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP
|
|
);
|
|
|
|
INSERT INTO public.environmental_permits (permit_number, company_name, permit_type, issued_date, status, updated_at)
|
|
VALUES
|
|
('PERM-DLH-2026-001', 'PT Semen Nusatama', 'AMDAL', '2026-01-15', 'ACTIVE', NOW() - INTERVAL '2 days'),
|
|
('PERM-DLH-2026-002', 'CV Logam Berkah Mandiri', 'UKL-UPL', '2026-02-10', 'ACTIVE', NOW() - INTERVAL '1 day'),
|
|
('PERM-DLH-2026-003', 'PT Tekstil Jaya Abadi', 'AMDAL', '2025-11-20', 'REVOKED', NOW() - INTERVAL '5 hours'),
|
|
('PERM-DLH-2026-004', 'Klinik Medika Sehat', 'SPPL', '2026-03-01', 'ACTIVE', NOW() - INTERVAL '1 hour'),
|
|
('PERM-DLH-2026-005', 'PT Kimia Farma Unit 4', 'AMDAL', '2026-02-28', 'PENDING', NOW())
|
|
ON CONFLICT (permit_number) DO UPDATE
|
|
SET status = EXCLUDED.status, updated_at = EXCLUDED.updated_at;
|