iAkaun
Tables (91)
account_action
- id — INTEGER
- account_id — INTEGER
- user_id — INTEGER
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
- remarks — TEXT
account_mapping
- id — SERIAL — Primary key — NOT NULL
- account_id — INTEGER — Foreign key → accounts.id
- account_to_id — INTEGER — Foreign key → accounts.id
- no_hasil — TEXT
- no_mesin — TEXT
- kaedah — TEXT
- kemudahan — TEXT
- user_id — INTEGER
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
account_mapping_kod_hasil
- id — SERIAL — Primary key — NOT NULL
- kod_hasil — TEXT
- account_id — INTEGER — Foreign key → accounts.id
- kod_gst — TEXT
- user_id — INTEGER
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
account_mapping_pymnt
- id — SERIAL — Primary key — NOT NULL
- account_id — INTEGER — Foreign key → accounts.id
- kod_bank — TEXT
- user_id — INTEGER
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
account_types
- id — SERIAL — Primary key — NOT NULL
- description — TEXT
- user_id — INTEGER
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
- nominal — CHARACTER
- account_type_id — INTEGER
accounting_peret
- id — SERIAL — Primary key — NOT NULL
- day — INTEGER
- month — INTEGER
- description — TEXT
- user_id — INTEGER
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
accounts
- id — SERIAL — Primary key — NOT NULL
- account_id — INTEGER — Foreign key → accounts.id
- account_type_id — INTEGER — Foreign key → account_types.id
- account_no — TEXT
- kod_saiis — TEXT
- gst — TEXT
- description — TEXT
- level — INTEGER
- last_child — INTEGER
- user_id — INTEGER
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
- customer_id — INTEGER
- akaun_asas — INTEGER
- remarks — CHARACTER
actions
- id — SERIAL — Primary key — NOT NULL
- description — TEXT
- user_id — INTEGER
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
alamat
- id — SERIAL — Primary key — NOT NULL
- profil_id — INTEGER
- lkp_jenis_alamat_id — INTEGER — Foreign key → lkp_jenis_alamat.id
- baris1 — CHARACTER
- baris2 — CHARACTER
- baris3 — CHARACTER
- baris4 — CHARACTER
- lkp_negeri_id — INTEGER
- lkp_bandar_id — INTEGER — Foreign key → lkp_bandar.id
- no_tel_bimbel — TEXT
- no_tel_pejabat — TEXT
- no_faks — TEXT
- emel — TEXT
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
bank_pembekal
- id — SERIAL — Primary key — NOT NULL
- lkp_bank_id — INTEGER — Foreign key → lkp_bank.id
- profil_id — INTEGER
- no_akaun — CHARACTER
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
configurations
- id — SERIAL — Primary key — NOT NULL
- config_name — TEXT
- value — TEXT
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
customers
- id — SERIAL — Primary key — NOT NULL
- lkp_customer_type_id — INTEGER — Foreign key → lkp_customer_types.id
- id_no — TEXT
- name — TEXT
- address_line_1 — TEXT
- address_line_2 — TEXT
- address_line_3 — TEXT
- postcode — TEXT
- city — TEXT
- state — TEXT
- phone_no1 — TEXT
- phone_no2 — TEXT
- user_id — INTEGER
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
exception_data
- document_no — CHARACTER
- no_mesin — CHARACTER
- account_no — CHARACTER
- id_no — CHARACTER
- date — TIMESTAMP(6)
- pay_mode — CHARACTER
- amount — DOUBLE
- kod_hasil — CHARACTER
- status — CHARACTER
- kemudahan — CHARACTER
- kaunter — CHARACTER
- description — CHARACTER
- voucher_no — CHARACTER
- cheque_no — CHARACTER
- eft_no — CHARACTER
- jenis_transaksi — CHARACTER
integration_statuses
- id — SERIAL — Primary key — NOT NULL
- description — TEXT
- created_at — TIMESTAMP(6)
- updated_at — TIMESTAMP(6)
- deleted_at — TIMESTAMP(6)
jejak_audit
- id — SERIAL — Primary key — NOT NULL
- modul_id — INTEGER
- submodul_id — INTEGER
- data_id — INTEGER
- sebelum — TEXT
- selepas — TEXT
- lkp_tindakan_id — INTEGER
- lkp_status_id — INTEGER
- user_id — INTEGER
- ip — TEXT
- catatan — TEXT
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
journal_accounts
- id — SERIAL — Primary key — NOT NULL
- journal_id — INTEGER — Foreign key → journals.id
- account_id — INTEGER — Foreign key → accounts.id
- amount — DOUBLE
- dc — INTEGER — NOT NULL
- note — TEXT
- gst — TEXT
- user_id — INTEGER
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
- clouse — INTEGER
- related_id — INTEGER
- source_id — CHARACTER
- source_data_id — CHARACTER
journal_action
- id — SERIAL — Primary key — NOT NULL
- journal_id — INTEGER — Foreign key → journals.id
- status_id — INTEGER
- user_id — INTEGER
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
- remarks — TEXT
journal_documents
- id — SERIAL — Primary key — NOT NULL
- journal_id — INTEGER — Foreign key → journals.id
- lable — TEXT
- path — TEXT
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
journal_types
- id — SERIAL — Primary key — NOT NULL
- description — TEXT
- user_id — INTEGER
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
journals
- id — SERIAL — Primary key — NOT NULL
- type_id — INTEGER
- method_id — INTEGER
- machine_id — INTEGER
- customer_id — INTEGER — Foreign key → customers.id
- status_id — INTEGER
- journal_type_id — INTEGER — Foreign key → journal_types.id
- date — DATE
- document_no — TEXT
- description — TEXT
- voucher_no — TEXT
- cheque_no — TEXT
- eft_no — TEXT
- mopocc_no — TEXT
- user_id — INTEGER
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
- path — TEXT
- document — TEXT
- journal_no — TEXT
- journal_id — INTEGER
- invnodok — CHARACTER
- remarks — TEXT
- account_id2 — INTEGER — TEMPORARY
- integration_status_id — INTEGER
- draf_no — CHARACTER
- running — BIGINT
- lkp_jabatan_id — BIGINT
kb_bajet_butiran
- id — BIGSERIAL — Primary key — NOT NULL
- kb_bajet_id — INTEGER
- account_id — INTEGER — Foreign key → accounts.id
- amaun — DOUBLE
- kb_lkp_jenis_bajet_id — INTEGER — Foreign key → kb_lkp_jenis_bajet.id
- status — TEXT
- catatan — TEXT
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
- kb_lkp_jenis_dasar_id — BIGINT
- pindahan_ind — BIGINT
kb_bajet_subbutiran
- id — BIGSERIAL — Primary key — NOT NULL
- kb_bajet_butiran_id — INTEGER — Foreign key → kb_bajet_butiran.id
- kadar — DOUBLE
- bil_1 — DOUBLE
- unit_1 — INTEGER
- bil_2 — DOUBLE
- unit_2 — INTEGER
- bil_3 — DOUBLE
- unit_3 — INTEGER
- bil_4 — DOUBLE
- unit_4 — INTEGER
- bil_5 — DOUBLE
- unit_5 — INTEGER
- jumlah — DOUBLE
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
- kb_bajet_subbutiran_id — BIGINT
- perkara — TEXT
kb_batas
- id — BIGSERIAL — Primary key — NOT NULL
- lkp_jabatan_id — INTEGER — Foreign key → lkp_jabatan.id
- kb_lkp_status_batas_id — INTEGER — Foreign key → kb_lkp_status_batas.id
- tahun — INTEGER
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
- no_rujukan — TEXT
- running — BIGINT
kb_batas_butiran
- id — SERIAL — Primary key — NOT NULL
- kb_batas_id — INTEGER
- kb_lkp_jenis_bajet_id — INTEGER
- amaun — DOUBLE
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
kb_lkp_batas_akaun
- id — BIGSERIAL — Primary key — NOT NULL
- account_id — INTEGER — Foreign key → accounts.id
- jenis_akaun — TEXT
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
kb_lkp_formula_batas
- id — BIGSERIAL — Primary key — NOT NULL
- jenis — TEXT
- peratus — TEXT
- status — TEXT
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
kb_lkp_jenis_bajet
- id — BIGSERIAL — Primary key — NOT NULL
- keterangan — TEXT
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
kb_lkp_jenis_dasar
- id — BIGSERIAL — Primary key — NOT NULL
- keterangan — TEXT
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
kb_lkp_status_bajet
- id — BIGSERIAL — Primary key — NOT NULL
- keterangan — TEXT
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
kb_lkp_status_batas
- id — BIGSERIAL — Primary key — NOT NULL
- keterangan — TEXT
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
kb_lkp_status_pindahan
- id — BIGSERIAL — Primary key — NOT NULL
- keterangan — TEXT
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
kb_lkp_tindakan_bajet
- id — BIGSERIAL — Primary key — NOT NULL
- keterangan — TEXT
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
kb_lkp_tindakan_batas
- id — BIGSERIAL — Primary key — NOT NULL
- keterangan — TEXT
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
kb_lkp_tindakan_pindahan
- id — BIGSERIAL — Primary key — NOT NULL
- keterangan — TEXT
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
kb_pindahan
- id — BIGSERIAL — Primary key — NOT NULL
- lkp_jabatan_id — INTEGER — Foreign key → lkp_jabatan.id
- tahun — INTEGER
- kb_lkp_status_pindahan_id — INTEGER — Foreign key → kb_lkp_status_pindahan.id
- jabatan_ind — INTEGER
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
- no_permohonan — TEXT
- running — BIGINT
kb_pindahan_butiran
- id — BIGSERIAL — Primary key — NOT NULL
- lkp_jabatan_id — INTEGER — Foreign key → lkp_jabatan.id
- account_id — INTEGER — Foreign key → accounts.id
- amaun — DOUBLE
- debit_kredit — INTEGER
- catatan_tidak_mencukupi — TEXT
- catatan_asas_pengiraan — TEXT
- catatan_boleh_pindah — TEXT
- status — TEXT
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
- kb_pindahan_id — BIGINT
kod_bank
- id — SERIAL — Primary key — NOT NULL
- kod_bank — TEXT
- description — TEXT
- user_id — INTEGER
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
kod_bidang_pembekal
- id — SERIAL — Primary key — NOT NULL
- lkp_kod_bidang_id — INTEGER
- sijil_pembekal_id — INTEGER
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
kod_hasil
- id — SERIAL — Primary key — NOT NULL
- kod_hasil — TEXT
- description — TEXT
- user_id — INTEGER
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
- kod_gst — CHARACTER
lampiran
- id — SERIAL — Primary key — NOT NULL
- jenis_fail — TEXT
- modul_id — INTEGER
- submodul_id — INTEGER
- user_id — INTEGER
- nama — TEXT
- paparan — TEXT
- path — TEXT
- url — TEXT
- size — DOUBLE
- views — CHARACTER
- mime — CHARACTER
- remark — CHARACTER
- mobile_upload — CHARACTER
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
- data_id — BIGINT
- lkp_status_id — BIGINT
lejar_amounts
- id — BIGSERIAL — Primary key — NOT NULL
- account_id — INTEGER — Foreign key → accounts.id
- date — DATE
- debit — DOUBLE
- kredit — DOUBLE
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- typee — INTEGER
lejar_json
- id — SERIAL — Primary key — NOT NULL
- from — DATE
- to — DATE
- level4 — TEXT
- status — INTEGER
- path — TEXT
- user_id — INTEGER
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
- type — TEXT
- process — INTEGER
- params — TEXT
lkp_bandar
- id — SERIAL — Primary key — NOT NULL
- lkp_negeri_id — INTEGER
- keterangan — TEXT
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
lkp_bank
- id — SERIAL — Primary key — NOT NULL
- keterangan — TEXT
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
lkp_customer_types
- id — SERIAL — Primary key — NOT NULL
- description — TEXT
- user_id — INTEGER
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
lkp_jabatan
- id — BIGSERIAL — Primary key — NOT NULL
- kod_jabatan — TEXT
- keterangan — TEXT
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
lkp_jenis_alamat
- id — SERIAL — Primary key — NOT NULL
- keterangan — TEXT
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
lkp_jenis_kod_bidang
- id — SERIAL — Primary key — NOT NULL
- keterangan — TEXT
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
lkp_jenis_profil
- id — SERIAL — Primary key — NOT NULL
- keterangan — TEXT
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
lkp_kod_bidang
- id — SERIAL — Primary key — NOT NULL
- lkp_jenis_kod_bidang_id — INTEGER
- lkp_kod_bidang_id — INTEGER
- kod_bidang — CHARACTER
- keterangan — TEXT
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
lkp_negeri
- id — SERIAL — Primary key — NOT NULL
- keterangan — TEXT
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
lkp_poskod
- id — SERIAL — Primary key — NOT NULL
- lkp_negeri_id — INTEGER — Foreign key → lkp_negeri.id
- lkp_bandar_id — INTEGER
- keterangan — TEXT
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
lkp_seksyen
- id — SERIAL — Primary key — NOT NULL
- lkp_poskod_id — INTEGER — Foreign key → lkp_poskod.id
- kod — TEXT
- keterangan — TEXT
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
lkp_unit
- id — BIGSERIAL — Primary key — NOT NULL
- keterangan — TEXT
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
locations
- id — SERIAL — Primary key — NOT NULL
- description — TEXT
- user_id — INTEGER — Foreign key
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
- remarks — TEXT
machines
- id — SERIAL — Primary key — NOT NULL
- location_id — INTEGER — Foreign key → locations.id
- no_mesin — TEXT
- description — TEXT
- user_id — INTEGER — Foreign key
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
- from_saiis_param_table — INTEGER
- from_saiis_receipt_table — INTEGER
menu_permission
- menu_id — INTEGER — Foreign key → menus.id — NOT NULL
- permission_id — INTEGER — Foreign key → permissions.id — NOT NULL
menus
- id — SERIAL — Primary key — NOT NULL
- menu_id — INTEGER
- name — CHARACTER
- path — CHARACTER
- route — CHARACTER
- param — CHARACTER
- query — CHARACTER
- url — CHARACTER
- status — INTEGER
- level — INTEGER
- position — INTEGER
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- icon — TEXT
- class — CHARACTER
methods
- id — SERIAL — Primary key — NOT NULL
- description — TEXT
- user_id — INTEGER — Foreign key
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
- id_from_source — CHARACTER
- remarks — CHARACTER
migrations
- id — SERIAL — Primary key — NOT NULL
- migration — CHARACTER — NOT NULL
- batch — INTEGER — NOT NULL
model_has_permissions
- model_id — BIGINT — Primary key — NOT NULL
- model_type — CHARACTER — Primary key — NOT NULL
- permission_id — INTEGER — Foreign key → permissions.id — NOT NULL
model_has_roles
- model_id — BIGINT — Primary key — NOT NULL
- model_type — CHARACTER — Primary key — NOT NULL
- role_id — INTEGER — Foreign key — NOT NULL
modul_menu
- modul_id — INTEGER — Foreign key → modules.id — NOT NULL
- menu_id — INTEGER — Foreign key → menus.id — NOT NULL
modules
- id — SERIAL — Primary key — NOT NULL
- name — CHARACTER
- description — TEXT
- status — INTEGER
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
password_resets
- email — CHARACTER — NOT NULL
- token — CHARACTER — NOT NULL
- created_at — TIMESTAMP(0)
pembekal
- id — SERIAL — Primary key — NOT NULL
- profil_id — INTEGER
- tarikh_daftar — DATE
- tarikh_mula_ssm — DATE
- tarikh_tamat_ssm — DATE
- nama_pegawai — CHARACTER
- no_tel_pegawai — CHARACTER
- lkp_status_id — INTEGER
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
permission_role
- permission_id — INTEGER — Foreign key → permissions.id — NOT NULL
- role_id — INTEGER — Foreign key — NOT NULL
permission_user
- permission_id — INTEGER — Foreign key → permissions.id — NOT NULL
- user_id — INTEGER — Foreign key — NOT NULL
permissions
- id — SERIAL — Primary key — NOT NULL
- name — CHARACTER — NOT NULL
- display_name — CHARACTER
- description — CHARACTER
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(6)
- permission_type_id — INTEGER — configurations.permission_types;
- access_type_id — INTEGER
- menu_position — INTEGER
- url — CHARACTER
- icon_id — INTEGER
- view_public — BOOLEAN
- allow_multiwindow — BOOLEAN
- view_as_submenu — BOOLEAN
- is_main_permission — BOOLEAN
- is_crud_action — BOOLEAN
- view_as_mainmenu — BOOLEAN
- full_url — BOOLEAN
- guard_name — TEXT
po_lkp_pembelian
- id — SERIAL — Primary key — NOT NULL
- keterangan — TEXT
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
po_lkp_perkhidmatan
- id — SERIAL — Primary key — NOT NULL
- keterangan — TEXT
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
po_lkp_perkhidmatan_pembelian
- id — SERIAL — Primary key — NOT NULL
- po_lkp_perkhidmatan_id — INTEGER — NOT NULL
- po_lkp_pembelian_id — INTEGER — NOT NULL
- amaun_minimum — DOUBLE
- amaun_maksimum — DOUBLE
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
po_lkp_status
- id — SERIAL — Primary key — NOT NULL
- keterangan — TEXT
- deleted_at — TIMESTAMP(0)
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
po_lkp_tindakan
- id — SERIAL — Primary key — NOT NULL
- keterangan — TEXT
- deleted_at — TIMESTAMP(0)
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
po_lkp_unit_tempoh
- id — SERIAL — Primary key — NOT NULL
- keterangan — TEXT
- deleted_at — TIMESTAMP(0)
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
po_permohonan
- id — SERIAL — Primary key — NOT NULL
- po_permohonan_id — INTEGER
- account_id — INTEGER
- lkp_jabatan_id — INTEGER
- lkp_kod_bidang_id — INTEGER
- po_lkp_perkhidmatan_pembelian_id — INTEGER
- po_lkp_status_id — INTEGER
- po_lkp_unit_tempoh_id — INTEGER
- kb_bajet_butiran_id — INTEGER
- tajuk — CHARACTER
- anggaran_harga — DOUBLE
- tarikh_keperluan — DATE
- tempoh — INTEGER
- sumber — CHARACTER
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
profil
- id — SERIAL — Primary key — NOT NULL
- no_id — CHARACTER
- lkp_jenis_profil_id — INTEGER
- nama — TEXT
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
reports
- id — BIGINT — Primary key — NOT NULL
- type — TEXT
- params — TEXT
- status — INTEGER
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
role_accounts
- id — SERIAL — Primary key — NOT NULL
- role_id — INTEGER — Foreign key
- account_id — INTEGER
- user_id — INTEGER — Foreign key
- created_at — TIMESTAMP(0)
- updated_at — TIMESTAMP(0)
- deleted_at — TIMESTAMP(0)
role_user
- id — SERIAL — Primary key — NOT NULL
- user_id — INTEGER — Foreign key — NOT NULL
- role_id — INTEGER — Foreign key — NOT NULL
- created_at — TIMESTAMP(6)
- updated_at — TIMESTAMP(6)
and 11 more tables