PGDMP o distributor8.3.78.3.74I 00ENCODINGENCODINGSET client_encoding = 'UTF8'; falseJ 00 STDSTRINGS STDSTRINGS)SET standard_conforming_strings = 'off'; falseK 126216385 distributorDATABASEICREATE DATABASE distributor WITH TEMPLATE = template0 ENCODING = 'UTF8'; DROP DATABASE distributor; postgresfalse261516785AkuntingSCHEMACREATE SCHEMA "Akunting"; DROP SCHEMA "Akunting"; postgresfalseL 00SCHEMA "Akunting"COMMENTgCOMMENT ON SCHEMA "Akunting" IS 'Skema untuk menyimpan data transaksi yang di posting ke buku besar '; postgresfalse6261516786 GroupwareSCHEMACREATE SCHEMA "Groupware"; DROP SCHEMA "Groupware"; postgresfalseM 00SCHEMA "Groupware"COMMENTdCOMMENT ON SCHEMA "Groupware" IS 'Skema untuk alur informasi, yaitu berita, pesan/email, dan TODO'; postgresfalse7261516787GudangSCHEMACREATE SCHEMA "Gudang"; DROP SCHEMA "Gudang"; postgresfalse 261516788KeamananSCHEMACREATE SCHEMA "Keamanan"; DROP SCHEMA "Keamanan"; postgresfalseN 00SCHEMA "Keamanan"COMMENT\COMMENT ON SCHEMA "Keamanan" IS 'Skema untuk menyimpan catatan pegawai yang pernah login '; postgresfalse9 261516789PegawaiSCHEMACREATE SCHEMA "Pegawai"; DROP SCHEMA "Pegawai"; postgresfalseO 00SCHEMA "Pegawai"COMMENT^COMMENT ON SCHEMA "Pegawai" IS 'Skema untuk menyimpan data pegawai serta segmentasi grupnya'; postgresfalse10 261516790 PembelianSCHEMACREATE SCHEMA "Pembelian"; DROP SCHEMA "Pembelian"; postgresfalseP 00SCHEMA "Pembelian"COMMENTSCOMMENT ON SCHEMA "Pembelian" IS 'Skema untuk menyimpan data transaksi pembelian'; postgresfalse11 261516791 PenjualanSCHEMACREATE SCHEMA "Penjualan"; DROP SCHEMA "Penjualan"; postgresfalseQ 00SCHEMA "Penjualan"COMMENTSCOMMENT ON SCHEMA "Penjualan" IS 'Skema untuk menyimpan data transaksi penjualan'; postgresfalse12 261516792SettingsSCHEMACREATE SCHEMA "Settings"; DROP SCHEMA "Settings"; postgresfalseR 00SCHEMA "Settings"COMMENTICOMMENT ON SCHEMA "Settings" IS 'Untuk mencatat info usaha dan setting'; postgresfalse13261516793publicSCHEMACREATE SCHEMA public; DROP SCHEMA public; postgresfalseS 00 SCHEMA publicCOMMENT6COMMENT ON SCHEMA public IS 'Standard public schema'; postgresfalse14T 00publicACL¢REVOKE ALL ON SCHEMA public FROM PUBLIC; REVOKE ALL ON SCHEMA public FROM postgres; GRANT ALL ON SCHEMA public TO postgres; GRANT ALL ON SCHEMA public TO PUBLIC; postgresfalse14-261216794plpgsqlPROCEDURAL LANGUAGE$CREATE PROCEDURAL LANGUAGE plpgsql; "DROP PROCEDURAL LANGUAGE plpgsql; postgresfalseñ1259122317bankTABLE_CREATE TABLE bank ( kode_bank text NOT NULL, nama_bank text NOT NULL, info text ); DROP TABLE "Akunting".bank; Akuntingpostgresfalse6Á125916795 buku_besarTABLE?CREATE TABLE buku_besar ( kode_buku_besar text NOT NULL, kode_akunting text, tanggal_akunting timestamp without time zone, kode_pegawai text, subjek text, predikat text, objek text, debet numeric DEFAULT 0, kredit numeric DEFAULT 0, info1 text, info2 text, info3 text ); "DROP TABLE "Akunting".buku_besar; Akuntingpostgresfalse208320846U 00COLUMN buku_besar.subjekCOMMENT?COMMENT ON COLUMN buku_besar.subjek IS 'kode_sup / kode_cust'; Akuntingpostgresfalse1729V 00COLUMN buku_besar.predikatCOMMENT8COMMENT ON COLUMN buku_besar.predikat IS 'what to do '; Akuntingpostgresfalse1729W 00COLUMN buku_besar.objekCOMMENTQCOMMENT ON COLUMN buku_besar.objek IS 'no nota jual/beli/retur beli/retur jual'; Akuntingpostgresfalse1729Â125916803cekTABLE–CREATE TABLE cek ( kode text NOT NULL, no_seri text, subjek text, objek text, bank text, jumlah numeric, tanggal_terima timestamp without time zone, jatuh_tempo timestamp without time zone, tipe_cek text, cair boolean, info text, jenis text, info_pembayaran text, kode_pegawai text, terpakai numeric DEFAULT 0, habis boolean DEFAULT false ); DROP TABLE "Akunting".cek; Akuntingpostgrestrue208520866ó1259124598 cek_detailTABLE‚CREATE TABLE cek_detail ( kode text, objek text, no_bukti text, jumlah numeric, info1 text, info2 text ); "DROP TABLE "Akunting".cek_detail; Akuntinghenryfalse6Ã125916811daftar_akuntingTABLE‹CREATE TABLE daftar_akunting ( kode_akunting text NOT NULL, nama_akunting text, jenis_akunting text, info_akunting text ); 'DROP TABLE "Akunting".daftar_akunting; Akuntingpostgresfalse6X 00$COLUMN daftar_akunting.kode_akuntingCOMMENTDCOMMENT ON COLUMN daftar_akunting.kode_akunting IS 'misal 001,002'; Akuntingpostgresfalse1731û1259177513daftar_akunting_postingTABLE¡CREATE TABLE daftar_akunting_posting ( kode_supplier text NOT NULL, penjualan text, persediaan text, hpp text, info1 text, info2 text ); /DROP TABLE "Akunting".daftar_akunting_posting; Akuntingpostgresfalse61259451523daftar_bank_internalTABLE˜CREATE TABLE daftar_bank_internal ( kode_bank text NOT NULL, nama_bank text, no_rek text, info1 text, info2 text, info3 text ); ,DROP TABLE "Akunting".daftar_bank_internal; Akuntinghenryfalse61259270427 kartu_hutangTABLE,CREATE TABLE kartu_hutang ( kode_customer text, no_bukti text, uraian text, tanggal timestamp without time zone, tanggal_lunas timestamp without time zone, penjualan numeric DEFAULT 0 NOT NULL, pelunasan numeric DEFAULT 0 NOT NULL, saldo numeric DEFAULT 0 NOT NULL ); $DROP TABLE "Akunting".kartu_hutang; Akuntinghenrytrue21272128212961259270413 kartu_piutangTABLE-CREATE TABLE kartu_piutang ( kode_customer text, no_bukti text, uraian text, tanggal timestamp without time zone, tanggal_lunas timestamp without time zone, penjualan numeric DEFAULT 0 NOT NULL, pelunasan numeric DEFAULT 0 NOT NULL, saldo numeric DEFAULT 0 NOT NULL ); %DROP TABLE "Akunting".kartu_piutang; Akuntinghenrytrue212421252126612591994004 neraca_mutasiTABLEÐCREATE TABLE neraca_mutasi ( kode_akunting text NOT NULL, tanggal_akunting_awal timestamp without time zone NOT NULL, tanggal_akunting_akhir timestamp without time zone, kode_pegawai text, saldo_awal numeric DEFAULT 0, kas_debet numeric DEFAULT 0, kas_kredit numeric DEFAULT 0, jurnal_debet numeric DEFAULT 0, jurnal_kredit numeric DEFAULT 0, saldo_akhir numeric DEFAULT 0, info1 text, info2 text, info3 text ); %DROP TABLE "Akunting".neraca_mutasi; Akuntingpostgrestrue2143214421452146214721486ô1259124604rekap_penagihanTABLEÜCREATE TABLE rekap_penagihan ( kode_dpp text NOT NULL, kode_sales text, wilayah text, tanggal timestamp without time zone, bkm text, info1 text, info2 text, info3 text, status text ); 'DROP TABLE "Akunting".rekap_penagihan; Akuntinghenryfalse6õ1259124612rekap_penagihan_detailTABLE3CREATE TABLE rekap_penagihan_detail ( kode_dpp text NOT NULL, kode_customer text, kode_wilayah text, no_faktur text, tgl_terima text, jumlah_tag numeric, akumulasi numeric, ditagihkan numeric, pembayaran text, retur_pot text, kembali te