| id_siswa | int(11) |
|
|
|
| nisn | int(10) unsigned zerofill |
|
|
|
| nis | varchar(20) |
|
|
|
| nama | varchar(50) |
|
|
|
| jenis_kelamin | varchar(1) |
|
|
|
| username | varchar(50) |
|
|
|
| password | mediumtext |
|
|
|
| kelas_awal | int(11) |
|
|
|
| tahun_masuk | varchar(30) |
|
|
|
| sekolah_asal | varchar(100) |
|
|
|
| tempat_lahir | varchar(100) |
|
|
|
| tanggal_lahir | varchar(30) |
|
|
|
| agama | varchar(10) |
|
|
|
| hp | varchar(15) |
|
|
|
| email | varchar(254) |
|
|
|
| foto | varchar(255) |
|
|
siswa.png
|
| anak_ke | int(11) |
|
|
|
| status_keluarga | varchar(1) |
|
|
|
| alamat | longtext |
|
|
|
| rt | varchar(5) |
|
|
|
| rw | varchar(5) |
|
|
|
| kelurahan | varchar(100) |
|
|
|
| kecamatan | varchar(100) |
|
|
|
| kabupaten | varchar(100) |
|
|
|
| provinsi | varchar(100) |
|
|
|
| kode_pos | int(11) |
|
|
|
| nama_ayah | varchar(150) |
|
|
|
| tgl_lahir_ayah | varchar(50) |
|
|
|
| pendidikan_ayah | varchar(50) |
|
|
|
| pekerjaan_ayah | varchar(100) |
|
|
|
| nohp_ayah | varchar(20) |
|
|
|
| alamat_ayah | longtext |
|
|
|
| nama_ibu | varchar(50) |
|
|
|
| tgl_lahir_ibu | varchar(50) |
|
|
|
| pendidikan_ibu | varchar(50) |
|
|
|
| pekerjaan_ibu | varchar(100) |
|
|
|
| nohp_ibu | varchar(20) |
|
|
|
| alamat_ibu | longtext |
|
|
|
| nama_wali | varchar(150) |
|
|
|
| tgl_lahir_wali | varchar(50) |
|
|
|
| pendidikan_wali | varchar(50) |
|
|
|
| pekerjaan_wali | varchar(100) |
|
|
|
| nohp_wali | varchar(20) |
|
|
|
| alamat_wali | longtext |
|
|
|
| nik | varchar(30) |
|
|
|
| warga_negara | varchar(20) |
|
|
|
| uid | varchar(255) |
|
|
|
