localhost:3306/othersemp/c/ http://localhost/phpmyadmin/index.php?route=/database/sql&db=othersemp Showing rows 0 - 215 (216 total, Query took 0.0320 seconds.) [TABLE_NAME: MS_APPROVER... - TRS_PO_ASSIGN_DETAIL...] [ORDINAL_POSITION: 1... - 9...] SELECT c.TABLE_NAME, c.COLUMN_NAME, c.ORDINAL_POSITION, c.COLUMN_TYPE, c.IS_NULLABLE, c.COLUMN_DEFAULT, c.COLUMN_KEY, c.EXTRA, kcu.REFERENCED_TABLE_NAME AS fk_table, kcu.REFERENCED_COLUMN_NAME AS fk_column FROM information_schema.COLUMNS c LEFT JOIN information_schema.KEY_COLUMN_USAGE kcu ON c.TABLE_SCHEMA = kcu.TABLE_SCHEMA AND c.TABLE_NAME = kcu.TABLE_NAME AND c.COLUMN_NAME = kcu.COLUMN_NAME WHERE c.TABLE_SCHEMA = DATABASE() AND c.TABLE_NAME IN ( 'ms_kode_mutasi', 'ms_saldo_awal', 'ms_supplier', 'ms_supplier_bank', 'ms_project', 'ms_kategori', 'ms_brand', 'ms_spesifikasi', 'ms_detail_kategori', 'ms_unit', 'ms_rekening', 'ms_term_of_payments', 'ms_my_company', 'ms_jabatan', 'ms_approver', 'trs_anggaran_plan_project', 'trs_po_assign', 'trs_po_assign_detail', 'trs_mutasi_bank_actual_project', 'rpt_rptbbk_detail', [...] TABLE_NAME COLUMN_NAME ORDINAL_POSITION COLUMN_TYPE IS_NULLABLE COLUMN_DEFAULT COLUMN_KEY EXTRA fk_table fk_column ms_approver id 1 bigint unsigned NO NULL PRI auto_increment NULL NULL ms_approver nama_approver 2 varchar(200) NO NULL MUL NULL NULL ms_approver jabatan_id 3 bigint unsigned NO NULL MUL ms_jabatan id ms_approver signature 4 longtext YES NULL NULL NULL ms_approver isactive 5 enum('0','1') NO 1 NULL NULL ms_approver created_at 6 timestamp NO CURRENT_TIMESTAMP DEFAULT_GENERATED NULL NULL ms_approver updated_at 7 timestamp NO CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP NULL NULL ms_approver user_create 8 varchar(255) YES NULL NULL NULL ms_approver user_update 9 varchar(255) YES NULL NULL NULL ms_brand id 1 bigint unsigned NO NULL PRI auto_increment NULL NULL ms_brand brand 2 varchar(150) NO NULL UNI NULL NULL ms_brand isactive 3 enum('0','1') NO 1 NULL NULL ms_brand created_at 4 timestamp NO CURRENT_TIMESTAMP DEFAULT_GENERATED NULL NULL ms_brand updated_at 5 timestamp NO CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP NULL NULL ms_brand user_create 6 varchar(255) YES NULL NULL NULL ms_brand user_update 7 varchar(255) YES NULL NULL NULL ms_detail_kategori id 1 bigint unsigned NO NULL PRI auto_increment NULL NULL ms_detail_kategori kategori_id 2 bigint unsigned NO NULL MUL ms_kategori id ms_detail_kategori detail_kategori 3 varchar(200) NO NULL NULL NULL ms_detail_kategori code 4 varchar(10) YES NULL NULL NULL ms_detail_kategori supplier_id 5 bigint unsigned YES NULL MUL ms_supplier id ms_detail_kategori brand_id 6 bigint unsigned YES NULL MUL ms_brand id ms_detail_kategori spesifikasi_id 7 bigint unsigned YES NULL MUL ms_spesifikasi id ms_detail_kategori isactive 8 enum('0','1') NO 1 NULL NULL ms_detail_kategori created_at 9 timestamp NO CURRENT_TIMESTAMP DEFAULT_GENERATED NULL NULL ms_detail_kategori updated_at 10 timestamp NO CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP NULL NULL ms_detail_kategori user_create 11 varchar(255) YES NULL NULL NULL ms_detail_kategori user_update 12 varchar(255) YES NULL NULL NULL ms_jabatan id 1 bigint unsigned NO NULL PRI auto_increment NULL NULL ms_jabatan jabatan_name 2 varchar(150) NO NULL UNI NULL NULL ms_jabatan isactive 3 enum('0','1') NO 1 NULL NULL ms_jabatan created_at 4 timestamp NO CURRENT_TIMESTAMP DEFAULT_GENERATED NULL NULL ms_jabatan updated_at 5 timestamp NO CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP NULL NULL ms_jabatan user_create 6 varchar(255) YES NULL NULL NULL ms_jabatan user_update 7 varchar(255) YES NULL NULL NULL ms_kategori id 1 bigint unsigned NO NULL PRI auto_increment NULL NULL ms_kategori kategori 2 varchar(150) NO NULL UNI NULL NULL ms_kategori code 3 varchar(10) YES NULL NULL NULL ms_kategori isactive 4 enum('0','1') NO 1 NULL NULL ms_kategori created_at 5 timestamp NO CURRENT_TIMESTAMP DEFAULT_GENERATED NULL NULL ms_kategori updated_at 6 timestamp NO CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP NULL NULL ms_kategori user_create 7 varchar(255) YES NULL NULL NULL ms_kategori user_update 8 varchar(255) YES NULL NULL NULL ms_kode_mutasi id 1 bigint unsigned NO NULL PRI auto_increment NULL NULL ms_kode_mutasi kode_mutasi 2 varchar(50) NO NULL UNI NULL NULL ms_kode_mutasi is_in 3 tinyint(1) NO 1 NULL NULL ms_kode_mutasi isactive 4 enum('0','1') NO 1 NULL NULL ms_kode_mutasi created_at 5 timestamp NO CURRENT_TIMESTAMP DEFAULT_GENERATED NULL NULL ms_kode_mutasi updated_at 6 timestamp NO CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP NULL NULL ms_kode_mutasi user_create 7 varchar(255) YES NULL NULL NULL ms_kode_mutasi user_update 8 varchar(255) YES NULL NULL NULL ms_my_company id 1 bigint unsigned NO NULL PRI auto_increment NULL NULL ms_my_company my_company_name 2 varchar(200) NO NULL NULL NULL ms_my_company logo 3 longtext YES NULL NULL NULL ms_my_company isactive 4 enum('0','1') NO 1 NULL NULL ms_my_company created_at 5 timestamp NO CURRENT_TIMESTAMP DEFAULT_GENERATED NULL NULL ms_my_company updated_at 6 timestamp NO CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP NULL NULL ms_my_company user_create 7 varchar(255) YES NULL NULL NULL ms_my_company user_update 8 varchar(255) YES NULL NULL NULL ms_project id 1 bigint unsigned NO NULL PRI auto_increment NULL NULL ms_project proyek 2 varchar(200) NO NULL MUL NULL NULL ms_project lokasi 3 varchar(200) YES NULL NULL NULL ms_project pekerjaan 4 varchar(200) YES NULL NULL NULL ms_project pemilik 5 varchar(200) YES NULL NULL NULL ms_project no_spk 6 varchar(100) YES NULL NULL NULL ms_project sales 8 varchar(150) YES NULL NULL NULL ms_project pv_capacity 9 decimal(18,2) YES NULL NULL NULL ms_project inverter_capacity 10 decimal(18,2) YES NULL NULL NULL ms_project forex 11 decimal(18,4) YES NULL NULL NULL ms_project isactive 12 enum('0','1') NO 1 NULL NULL ms_project created_at 13 timestamp NO CURRENT_TIMESTAMP DEFAULT_GENERATED NULL NULL ms_project updated_at 14 timestamp NO CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP NULL NULL ms_project user_create 15 varchar(255) YES NULL NULL NULL ms_project user_update 16 varchar(255) YES NULL NULL NULL ms_rekening id 1 bigint unsigned NO NULL PRI auto_increment NULL NULL ms_rekening kode_bank 2 varchar(50) YES NULL NULL NULL ms_rekening nama_bank 3 varchar(150) NO NULL MUL NULL NULL ms_rekening nomor_akun 4 varchar(100) NO NULL NULL NULL ms_rekening nama_akun 5 varchar(150) NO NULL NULL NULL ms_rekening saldo_awal 6 decimal(15,2) NO 0.00 NULL NULL ms_rekening tgl_saldo_awal 7 datetime YES NULL NULL NULL ms_rekening saldo_akhir 8 decimal(15,2) NO 0.00 NULL NULL ms_rekening tgl_saldo_akhir 9 datetime YES NULL NULL NULL ms_rekening isactive 10 enum('0','1') NO 1 NULL NULL ms_rekening created_at 11 timestamp NO CURRENT_TIMESTAMP DEFAULT_GENERATED NULL NULL ms_rekening updated_at 12 timestamp NO CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP NULL NULL ms_rekening user_create 13 varchar(255) YES NULL NULL NULL ms_rekening user_update 14 varchar(255) YES NULL NULL NULL ms_spesifikasi id 1 bigint unsigned NO NULL PRI auto_increment NULL NULL ms_spesifikasi brand_id 2 bigint unsigned NO NULL MUL ms_brand id ms_spesifikasi spesifikasi 3 varchar(200) NO NULL NULL NULL ms_spesifikasi isactive 4 enum('0','1') NO 1 NULL NULL ms_spesifikasi created_at 5 timestamp NO CURRENT_TIMESTAMP DEFAULT_GENERATED NULL NULL ms_spesifikasi updated_at 6 timestamp NO CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP NULL NULL ms_spesifikasi user_create 7 varchar(255) YES NULL NULL NULL ms_spesifikasi user_update 8 varchar(255) YES NULL NULL NULL ms_supplier id 1 bigint unsigned NO NULL PRI auto_increment NULL NULL ms_supplier supplier_name 2 varchar(200) NO NULL MUL NULL NULL ms_supplier supplier_type 3 varchar(100) YES NULL NULL NULL ms_supplier isactive 4 enum('0','1') NO 1 NULL NULL ms_supplier created_at 5 timestamp NO CURRENT_TIMESTAMP DEFAULT_GENERATED NULL NULL ms_supplier updated_at 6 timestamp NO CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP NULL NULL ms_supplier user_create 7 varchar(255) YES NULL NULL NULL ms_supplier user_update 8 varchar(255) YES NULL NULL NULL ms_supplier_bank id 1 bigint unsigned NO NULL PRI auto_increment NULL NULL ms_supplier_bank supplier_id 2 bigint unsigned NO NULL MUL ms_supplier id ms_supplier_bank kode_bank 3 varchar(50) YES NULL NULL NULL ms_supplier_bank nama_bank 4 varchar(150) NO NULL NULL NULL ms_supplier_bank nomor_akun 5 varchar(100) NO NULL NULL NULL ms_supplier_bank nama_akun 6 varchar(150) NO NULL NULL NULL ms_supplier_bank isactive 7 enum('0','1') NO 1 NULL NULL ms_supplier_bank created_at 8 timestamp NO CURRENT_TIMESTAMP DEFAULT_GENERATED NULL NULL ms_supplier_bank updated_at 9 timestamp NO CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP NULL NULL ms_supplier_bank user_create 10 varchar(255) YES NULL NULL NULL ms_supplier_bank user_update 11 varchar(255) YES NULL NULL NULL ms_term_of_payments id 1 bigint unsigned NO NULL PRI auto_increment NULL NULL ms_term_of_payments kode 2 varchar(50) NO NULL UNI NULL NULL ms_term_of_payments tterm_or_payments 3 varchar(200) NO NULL NULL NULL ms_term_of_payments isactive 4 enum('0','1') NO 1 NULL NULL ms_term_of_payments created_at 5 timestamp NO CURRENT_TIMESTAMP DEFAULT_GENERATED NULL NULL ms_term_of_payments updated_at 6 timestamp NO CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP NULL NULL ms_term_of_payments user_create 7 varchar(255) YES NULL NULL NULL ms_term_of_payments user_update 8 varchar(255) YES NULL NULL NULL ms_unit id 1 bigint unsigned NO NULL PRI auto_increment NULL NULL ms_unit unit 2 varchar(50) NO NULL UNI NULL NULL ms_unit isactive 3 enum('0','1') NO 1 NULL NULL ms_unit created_at 4 timestamp NO CURRENT_TIMESTAMP DEFAULT_GENERATED NULL NULL ms_unit updated_at 5 timestamp NO CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP NULL NULL ms_unit user_create 6 varchar(255) YES NULL NULL NULL ms_unit user_update 7 varchar(255) YES NULL NULL NULL rpt_rptbbk_detail id 1 bigint unsigned NO NULL PRI auto_increment NULL NULL rpt_rptbbk_detail header_id 2 bigint unsigned NO NULL MUL NULL NULL rpt_rptbbk_detail urutan 3 int NO 1 NULL NULL rpt_rptbbk_detail kategori 4 varchar(150) YES NULL NULL NULL rpt_rptbbk_detail detail_kategori 5 varchar(200) YES NULL NULL NULL rpt_rptbbk_detail amount 6 decimal(18,2) NO 0.00 NULL NULL rpt_rptbbk_detail created_at 7 timestamp YES NULL NULL NULL rpt_rptbbk_detail updated_at 8 timestamp YES NULL NULL NULL rpt_rptbbk_detail user_create 9 varchar(255) YES NULL NULL NULL rpt_rptbbk_detail user_update 10 varchar(255) YES NULL NULL NULL rpt_rptbbk_header id 1 bigint unsigned NO NULL PRI auto_increment NULL NULL rpt_rptbbk_header project_id 2 bigint unsigned YES NULL MUL NULL NULL rpt_rptbbk_header project_name 3 varchar(200) YES NULL NULL NULL rpt_rptbbk_header kode_mutasi_id 4 bigint unsigned YES NULL NULL NULL rpt_rptbbk_header kode_mutasi 5 varchar(50) YES NULL NULL NULL rpt_rptbbk_header is_in 6 tinyint(1) NO 0 NULL NULL rpt_rptbbk_header nomor_bukti 7 varchar(100) YES NULL NULL NULL rpt_rptbbk_header date 8 date YES NULL NULL NULL rpt_rptbbk_header supplier_name 9 varchar(200) YES NULL NULL NULL rpt_rptbbk_header dibayarkan_kepada 10 varchar(200) YES NULL NULL NULL rpt_rptbbk_header company_name 11 varchar(200) YES NULL NULL NULL rpt_rptbbk_header keterangan 12 text YES NULL NULL NULL rpt_rptbbk_header rekening_nama_bank 13 varchar(150) YES NULL NULL NULL rpt_rptbbk_header rekening_nomor_akun 14 varchar(100) YES NULL NULL NULL rpt_rptbbk_header supplier_nama_bank 15 varchar(150) YES NULL NULL NULL rpt_rptbbk_header supplier_nomor_akun 16 varchar(100) YES NULL NULL NULL rpt_rptbbk_header supplier_nama_akun 17 varchar(150) YES NULL NULL NULL rpt_rptbbk_header penerima_name 18 varchar(200) YES NULL NULL NULL rpt_rptbbk_header pembukuan_name 19 varchar(200) YES NULL NULL NULL rpt_rptbbk_header pembukuan_signature 20 longtext YES NULL NULL NULL rpt_rptbbk_header mengetahui_name 21 varchar(200) YES NULL NULL NULL rpt_rptbbk_header mengetahui_signature 22 longtext YES NULL NULL NULL rpt_rptbbk_header total_amount 23 decimal(18,2) NO 0.00 NULL NULL rpt_rptbbk_header created_at 24 timestamp YES NULL NULL NULL rpt_rptbbk_header updated_at 25 timestamp YES NULL NULL NULL rpt_rptbbk_header user_create 26 varchar(255) YES NULL NULL NULL rpt_rptbbk_header user_update 27 varchar(255) YES NULL NULL NULL trs_anggaran_plan_project id 1 bigint unsigned NO NULL PRI auto_increment NULL NULL trs_anggaran_plan_project project_id 2 bigint unsigned NO NULL MUL ms_project id trs_anggaran_plan_project detail_kategori_id 3 bigint unsigned NO NULL MUL ms_detail_kategori id trs_anggaran_plan_project detail_kategori_amount 4 decimal(15,2) YES NULL NULL NULL trs_anggaran_plan_project detail_kategori_unit_id 5 bigint unsigned YES NULL MUL ms_unit id trs_anggaran_plan_project amount 6 decimal(18,2) NO 0.00 NULL NULL trs_anggaran_plan_project created_at 7 timestamp NO CURRENT_TIMESTAMP DEFAULT_GENERATED NULL NULL trs_anggaran_plan_project updated_at 8 timestamp NO CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP NULL NULL trs_anggaran_plan_project user_create 9 varchar(255) YES NULL NULL NULL trs_anggaran_plan_project user_update 10 varchar(255) YES NULL NULL NULL trs_mutasi_bank_actual_project id 1 bigint unsigned NO NULL PRI auto_increment NULL NULL trs_mutasi_bank_actual_project po_assign_id 2 bigint unsigned YES NULL MUL trs_po_assign id trs_mutasi_bank_actual_project rekening_id 3 bigint unsigned YES NULL MUL ms_rekening id trs_mutasi_bank_actual_project date 4 date YES NULL NULL NULL trs_mutasi_bank_actual_project kode_mutasi_id 5 bigint unsigned YES NULL MUL ms_kode_mutasi id trs_mutasi_bank_actual_project nomor_bukti 6 varchar(255) YES NULL NULL NULL trs_mutasi_bank_actual_project is_credit 8 tinyint(1) NO 0 NULL NULL trs_mutasi_bank_actual_project is_dp 9 tinyint(1) NO 0 NULL NULL trs_mutasi_bank_actual_project dp_percentage 10 decimal(15,2) YES NULL NULL NULL trs_mutasi_bank_actual_project amount 11 decimal(15,2) YES NULL NULL NULL trs_mutasi_bank_actual_project saldo_akhir 12 decimal(15,2) YES NULL NULL NULL trs_mutasi_bank_actual_project pph_amount 13 decimal(15,2) YES NULL NULL NULL trs_mutasi_bank_actual_project created_at 14 timestamp NO CURRENT_TIMESTAMP DEFAULT_GENERATED NULL NULL trs_mutasi_bank_actual_project updated_at 15 timestamp NO CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP NULL NULL trs_mutasi_bank_actual_project user_create 16 varchar(255) YES NULL NULL NULL trs_mutasi_bank_actual_project user_update 17 varchar(255) YES NULL NULL NULL trs_po_assign id 1 bigint unsigned NO NULL PRI auto_increment NULL NULL trs_po_assign po_number 2 varchar(255) YES NULL UNI NULL NULL trs_po_assign is_project 3 tinyint(1) NO 0 NULL NULL trs_po_assign project_id 4 bigint unsigned YES NULL MUL ms_project id trs_po_assign is_supplier 5 decimal(15,2) YES NULL NULL NULL trs_po_assign supplier_id 6 bigint unsigned YES NULL MUL ms_supplier id trs_po_assign supplier_bank_id 7 bigint unsigned YES NULL MUL ms_supplier_bank id trs_po_assign description 8 text YES NULL NULL NULL trs_po_assign created_at 9 timestamp NO CURRENT_TIMESTAMP DEFAULT_GENERATED NULL NULL trs_po_assign updated_at 10 timestamp NO CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP NULL NULL trs_po_assign user_create 11 varchar(255) YES NULL NULL NULL trs_po_assign user_update 12 varchar(255) YES NULL NULL NULL trs_po_assign_detail id 1 bigint unsigned NO NULL PRI auto_increment NULL NULL trs_po_assign_detail po_assign_id 2 bigint unsigned YES NULL MUL trs_po_assign id trs_po_assign_detail detail_kategori_id 3 bigint unsigned YES NULL MUL ms_detail_kategori id trs_po_assign_detail detail_kategori_amount 4 decimal(15,2) YES NULL NULL NULL trs_po_assign_detail detail_kategori_unit_id 5 bigint unsigned YES NULL MUL ms_unit id trs_po_assign_detail created_at 6 timestamp NO CURRENT_TIMESTAMP DEFAULT_GENERATED NULL NULL trs_po_assign_detail updated_at 7 timestamp NO CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP NULL NULL trs_po_assign_detail user_create 8 varchar(255) YES NULL NULL NULL trs_po_assign_detail user_update 9 varchar(255) YES NULL NULL NULL