BIKIN TABLE member bank acc

28 Maret 2016 - 13:29:04 - By Administrator

CREATE TABLE member_bank_acc (id_member VARCHAR(6) COLLATE latin1_general_ci,npwp VARCHAR(100) COLLATE latin1_general_ci,nama_bank VARCHAR(50) COLLATE latin1_general_ci,cabang VARCHAR(50) COLLATE latin1_general_ci, nomor_rekening_pemilik VARCHAR(20) COLLATE latin1_general_ci,nama_pemilik_rekening VARCHAR(50) COLLATE latin1_general_ci,nama_ahli_waris VARCHAR(50) COLLATE latin1_general_ci, tempat_lahir_ahli_waris VARCHAR(50) COLLATE latin1_general_ci, tanggal_lahir_ahli_waris DATE DEFAULT '0000-00-00', PRIMARY KEY (id_member)) ;