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