CREATE TABLE "kelurahan" ( "id_kel" SERIAL PRIMARY KEY, "nama_kel" CHARACTER VARYING(100) NOT NULL, "kecamatan" CHARACTER VARYING(100) NOT NULL ); CREATE TABLE "pemilih" ( "no_ktp" CHARACTER VARYING(200) NOT NULL, "nm_pemilih" CHARACTER VARYING(200) NOT NULL, "jk" SMALLINT NOT NULL, "ttl" CHARACTER VARYING(200) NOT NULL, "id_kel" INTEGER NOT NULL REFERENCES kelurahan(id_kel) ON DELETE CASCADE ON UPDATE CASCADE, "tps" CHARACTER VARYING(80) NOT NULL, "alamat" CHARACTER VARYING(200) NOT NULL, "ket" CHARACTER VARYING(100) NOT NULL ); CREATE TABLE "relawan" ( "no_ktp" CHARACTER VARYING(200) NOT NULL, "nm_relawan" CHARACTER VARYING(200) NOT NULL, "nm_posko" CHARACTER VARYING(200) NOT NULL, "id_kel" INTEGER NOT NULL REFERENCES kelurahan(id_kel) ON DELETE CASCADE ON UPDATE CASCADE, "tps" CHARACTER VARYING(80) NOT NULL, "alamat" CHARACTER VARYING(200) NOT NULL, "kontak" CHARACTER VARYING(100) NOT NULL, "ket" CHARACTER VARYING(100) NOT NULL ); CREATE TABLE "koordinasi" ( "id_koor" SERIAL PRIMARY KEY, "no_ktp_pemilih" CHARACTER VARYING(200) NOT NULL, "no_ktp_relawan" CHARACTER VARYING(200) NOT NULL, "ket" CHARACTER VARYING(200) NOT NULL ); COMMENT ON COLUMN pemilih.jk IS 'Jenis Kelamin = 1 laki, 2 cewek'; CREATE TABLE "admin" ( "id_admin" SERIAL PRIMARY KEY, "nama" CHARACTER VARYING(200) NOT NULL, "username" CHARACTER VARYING(200) NOT NULL, "password" CHARACTER VARYING(200) NOT NULL );