| id | int(11) |
|
|
|
| nama_lengkap | varchar(100) |
|
|
|
| nis | varchar(20) |
|
|
|
| nisn | varchar(20) |
|
|
|
| kelas | varchar(50) |
|
|
|
| gelombang | tinyint(2) |
|
|
1
|
| gelombang_mulai | date |
|
|
|
| gelombang_selesai | date |
|
|
|
| username | varchar(50) |
|
|
|
| password | varchar(255) |
|
|
|
| role | enum | -- |
|
|
| role_detail | enum | -- |
|
siswa
|
| id_kelas | int(11) |
|
|
|
| foto_profil | varchar(255) |
|
|
default.png
|
| foto_face_model | text |
|
|
|
| token_device | varchar(255) |
|
|
|
| created_at | timestamp |
|
|
CURRENT_TIMESTAMP
|
| no_hp | varchar(20) |
|
|
|
| jam_masuk_default | time |
|
|
|
| jam_pulang_default | time |
|
|
|
| tanggal_lahir | date |
|
|
|
| theme_id | int(11) |
|
|
|
| preferensi_tema | enum | -- |
|
dark
|
| theme_preference | varchar(20) |
|
|
default
|
| izin_tugas_luar | tinyint(1) |
|
|
0
|