ci_sessions
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| session_id (Primary) | varchar(40) | No | 0 | |||
| ip_address | varchar(45) | No | 0 | |||
| user_agent | varchar(120) | No | ||||
| last_activity | int(10) | No | 0 | |||
| user_data | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | session_id | 2 | A | No | |
| last_activity | BTREE | No | No | last_activity | 2 | A | No |
tabungan
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| no_rek | varchar(30) | No | ||||
| anggota_id | bigint(20) | Yes | NULL | |||
| tgl_pembuatan | timestamp | Yes | CURRENT_TIMESTAMP | |||
| update_data | timestamp | No | CURRENT_TIMESTAMP | |||
| debet | bigint(100) | No | ||||
| kredit | bigint(100) | No | ||||
| bunga | bigint(100) | No | ||||
| min_saldo | bigint(100) | No | ||||
| max_saldo | bigint(100) | No | ||||
| saldo | bigint(100) | No | ||||
| status | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 1120 | A | No |
tbl_anggota
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | bigint(20) | No | ||||
| nik | varchar(25) | Yes | NULL | |||
| nama | varchar(255) | Yes | NULL | |||
| jns_anggota | int(11) | Yes | NULL | |||
| jk | enum('L', 'P') | Yes | NULL | |||
| tmp_lahir | varchar(225) | Yes | NULL | |||
| tgl_lahir | date | Yes | NULL | |||
| status | varchar(30) | Yes | NULL | |||
| agama | varchar(30) | Yes | NULL | |||
| pekerjaan | varchar(30) | Yes | NULL | |||
| pendidikan | varchar(30) | Yes | NULL | |||
| alamat | text | Yes | NULL | |||
| notelp | varchar(12) | Yes | NULL | |||
| tgl_daftar | date | Yes | NULL | |||
| aktif | enum('Y', 'N') | Yes | NULL | |||
| pass_word | varchar(225) | Yes | NULL | |||
| file_pic | varchar(225) | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 1120 | A | No |
tbl_anggota_kelompok
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| tgl_registrasi | date | No | ||||
| korpok_id | int(11) | No | ||||
| anggota_id | int(11) | No | ||||
| ketua_korpok_id | int(11) | No | ||||
| wilayah_id | int(11) | No | ||||
| no_rek | varchar(50) | No | ||||
| keterangan | varchar(200) | No | ||||
| status_aktif | enum('Y', 'T') | No | ||||
| user_name | varchar(30) | No | ||||
| tgl_keluar | date | No | ||||
| status | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 1058 | A | No |
tbl_jns_anggota
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| deskripsi | varchar(100) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 3 | A | No |
tbl_kode
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| opsi_key | varchar(10) | Yes | NULL | |||
| opsi_val | varchar(50) | Yes | NULL | |||
| dk | enum('D', 'K') | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 6 | A | No |
tbl_korpok
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| korpok_id | int(11) | No | ||||
| ketua_korpok_id | int(11) | No | ||||
| wilayah_id | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 64 | A | No |
tbl_no_perkiraan
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| tgl_pembuatan | date | No | ||||
| acc | varchar(100) | No | ||||
| jns_trans | varchar(100) | No | ||||
| akun | enum('AKTIVA', 'PASIVA') | No | ||||
| jns_akun | int(11) | No | ||||
| kode | varchar(250) | No | ||||
| kode1 | int(11) | No | ||||
| kode2 | int(11) | No | ||||
| kode3 | int(11) | No | ||||
| kode_aktiva | varchar(100) | No | ||||
| laba_rugi | varchar(100) | No | ||||
| pemasukan | enum('Y', 'T') | No | ||||
| pengeluaran | enum('Y', 'T') | No | ||||
| aktif | enum('Y', 'T') | No | ||||
| gol | varchar(100) | No | ||||
| keterangan | varchar(255) | No | ||||
| status | int(11) | No | ||||
| dk | enum('D', 'K') | No | ||||
| debet | int(11) | No | ||||
| kredit | int(11) | No | ||||
| saldo | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 152 | A | No |
tbl_pengajuan
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | bigint(20) | No | ||||
| no_ajuan | int(11) | Yes | NULL | |||
| ajuan_id | varchar(255) | Yes | NULL | |||
| anggota_id | bigint(20) | Yes | NULL | |||
| wakil | varchar(100) | Yes | NULL | |||
| tgl_input | datetime | Yes | NULL | |||
| jenis | varchar(255) | Yes | NULL | |||
| nominal | bigint(20) | Yes | NULL | |||
| lama_ags | int(11) | Yes | NULL | |||
| bunga | float | Yes | NULL | |||
| keterangan | varchar(255) | Yes | NULL | |||
| status | tinyint(4) | Yes | NULL | |||
| alasan | varchar(255) | Yes | NULL | |||
| tgl_cair | date | Yes | NULL | |||
| tgl_update | datetime | Yes | NULL | |||
| jenis_usaha | varchar(20) | Yes | NULL | |||
| tempat_usaha | text | Yes | NULL | |||
| omzet_perbulan | bigint(20) | Yes | NULL | |||
| biaya_hidup | bigint(20) | Yes | NULL | |||
| keuntungan | bigint(20) | Yes | NULL | |||
| anggunan | varchar(20) | Yes | NULL | |||
| harga_taksiran | bigint(20) | Yes | NULL | |||
| surveyor | varchar(25) | Yes | NULL | |||
| jenis_bpkb | varchar(100) | Yes | NULL | |||
| merek_kendaraan | varchar(25) | Yes | NULL | |||
| no_bpkb | varchar(20) | Yes | NULL | |||
| no_mesin | varchar(20) | Yes | NULL | |||
| no_rangka | varchar(20) | Yes | NULL | |||
| warna | varchar(200) | Yes | NULL | |||
| atas_nama | varchar(25) | Yes | NULL | |||
| no_polisi | varchar(20) | Yes | NULL | |||
| tahun_kendaraan | varchar(255) | Yes | NULL | |||
| alamat_kendaraan | varchar(255) | Yes | NULL | |||
| no_shm | varchar(20) | Yes | NULL | |||
| an_shm | varchar(255) | Yes | NULL | |||
| luas_shm | varchar(20) | Yes | NULL | |||
| alamat_shm | varchar(255) | Yes | NULL | |||
| kec_shm | varchar(255) | Yes | NULL | |||
| kab_shm | varchar(255) | Yes | NULL | |||
| prov_shm | varchar(50) | Yes | NULL | |||
| kondisi_tanah | varchar(50) | Yes | NULL | |||
| no_urut | varchar(10) | Yes | NULL | |||
| jenis_emas | varchar(100) | Yes | NULL | |||
| warna_emas | varchar(100) | Yes | NULL | |||
| berat_emas | varchar(25) | Yes | NULL | |||
| jml_gaji | bigint(100) | Yes | NULL | |||
| lain_lain | varchar(1000) | Yes | NULL | |||
| no_telp | varchar(20) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
tbl_setting
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | bigint(20) | No | ||||
| opsi_key | varchar(255) | No | ||||
| opsi_val | varchar(255) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 19 | A | No |
tbl_trans
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | bigint(20) | No | ||||
| id_trans | int(11) | No | ||||
| no_kk_km | varchar(100) | Yes | NULL | |||
| tgl_transaksi | datetime | Yes | NULL | |||
| anggota_id | bigint(20) | Yes | NULL | |||
| no_rek | varchar(30) | Yes | NULL | |||
| no_perkiraan | varchar(10) | Yes | NULL | |||
| kode | varchar(10) | Yes | NULL | |||
| jenis_id | int(5) | Yes | NULL | |||
| jumlah | int(255) | Yes | NULL | |||
| saldo | bigint(20) | Yes | NULL | |||
| keterangan | varchar(255) | Yes | NULL | |||
| akun | enum('Setoran', 'Penarikan') | Yes | NULL | |||
| dk | enum('D', 'K') | Yes | NULL | |||
| kas_id | bigint(20) | Yes | NULL | |||
| jenis | varchar(10) | No | ||||
| golongan | varchar(10) | No | ||||
| update_data | datetime | Yes | NULL | |||
| user_name | varchar(255) | Yes | NULL | |||
| status | int(11) | Yes | NULL | |||
| aktif | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
tbl_trans_sp
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | bigint(20) | No | ||||
| tgl_transaksi | datetime | Yes | NULL | |||
| anggota_id | bigint(20) | Yes | NULL | |||
| no_rek | varchar(30) | Yes | NULL | |||
| kode | varchar(10) | Yes | NULL | |||
| jenis_id | int(5) | Yes | NULL | |||
| jumlah | double | Yes | NULL | |||
| saldo | bigint(20) | Yes | NULL | |||
| jumlah_sebenarnya | double | Yes | NULL | |||
| lama | int(3) | Yes | NULL | |||
| jpenarikan | double | Yes | NULL | |||
| keterangan | varchar(255) | Yes | NULL | |||
| akun | enum('Setoran', 'Penarikan') | Yes | NULL | |||
| dk | enum('D', 'K') | Yes | NULL | |||
| kas_id | bigint(20) | Yes | NULL | |||
| update_data | datetime | Yes | NULL | |||
| user_name | varchar(255) | Yes | NULL | |||
| nama_penyetor | varchar(255) | Yes | NULL | |||
| no_identitas | varchar(20) | Yes | NULL | |||
| alamat | varchar(255) | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 179 | A | No |
tbl_trans_spk
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| tgl_transaksi | datetime | Yes | NULL | |||
| no_rek | varchar(50) | Yes | NULL | |||
| ketua_id | int(11) | Yes | NULL | |||
| anggota_id | int(11) | Yes | NULL | |||
| bunga | int(11) | Yes | NULL | |||
| ags_ke | int(11) | Yes | NULL | |||
| bayar_pokok | int(11) | Yes | NULL | |||
| bayar_sr | int(11) | Yes | NULL | |||
| jml_bayar | int(11) | Yes | NULL | |||
| saldo_setoran | int(11) | Yes | NULL | |||
| saldo_sr | int(11) | Yes | NULL | |||
| saldo_total | int(11) | Yes | NULL | |||
| akun | enum('Setoran', 'Penarikan') | Yes | NULL | |||
| dk | enum('D', 'K') | Yes | NULL | |||
| kas_id | int(11) | Yes | NULL | |||
| jns_trans | int(11) | Yes | NULL | |||
| status | enum('Belum', 'Lunas') | Yes | NULL | |||
| user_name | varchar(30) | Yes | NULL | |||
| keterangan | varchar(256) | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
tbl_user
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | bigint(20) | No | ||||
| nama | varchar(30) | Yes | NULL | |||
| tmpt_lahir | varchar(30) | Yes | NULL | |||
| tgl_lahir | date | Yes | NULL | |||
| jk | enum('L', 'P') | Yes | NULL | |||
| agama | enum('Islam', 'Kristen', 'Hindu', 'Budha', 'Katolik') | Yes | NULL | |||
| alamat | varchar(255) | Yes | NULL | |||
| no_telp | varchar(15) | Yes | NULL | |||
| departement | varchar(255) | Yes | NULL | |||
| u_name | varchar(255) | Yes | NULL | |||
| pass_word | varchar(255) | Yes | NULL | |||
| aktif | enum('Y', 'N') | Yes | NULL | |||
| level | enum('admin', 'cs', 'teller', 'pelayanan') | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 3 | A | No |
tbl_wilayah
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(100) | No | ||||
| wilayah | varchar(100) | No | ||||
| kode_pos | int(100) | No | ||||
| tgl_aktif | timestamp | No | CURRENT_TIMESTAMP |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 22 | A | No |
temp_histori
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | bigint(20) | No | ||||
| id_trans | bigint(20) | Yes | NULL | |||
| tgl_transaksi | datetime | Yes | NULL | |||
| tgl_hapus | datetime | Yes | NULL | |||
| anggota_id | bigint(20) | Yes | NULL | |||
| ketua_id | int(11) | No | ||||
| no_trans | varchar(30) | Yes | NULL | |||
| kode | varchar(10) | Yes | NULL | |||
| tbl_asal | varchar(100) | Yes | NULL | |||
| jns_trans | varchar(100) | No | ||||
| pokok | int(11) | No | ||||
| bunga | int(11) | No | ||||
| denda | int(11) | No | ||||
| jumlah | int(11) | No | ||||
| saldo | bigint(20) | Yes | NULL | |||
| lama | int(3) | Yes | NULL | |||
| keterangan | varchar(255) | Yes | NULL | |||
| akun | varchar(100) | Yes | NULL | |||
| dk | varchar(10) | No | ||||
| user_name | varchar(255) | Yes | NULL | |||
| nama_penghapus | varchar(255) | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |