| ID |
int(11)
|
|
|
|
| nombor_tentera |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| pangkat |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| pangkat_id |
int(11)
|
|
|
|
| nama |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| nama_panggilan |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| call_sign |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| email |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| nombor_telefon |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| email_verified_at |
datetime
|
|
|
|
| email_verified_value |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| email_verification_token_hash |
varchar(64)
|
utf8mb4_general_ci
|
|
|
| email_verification_expires_at |
datetime
|
|
|
|
| email_verification_last_sent_at |
datetime
|
|
|
|
| email_verification_grace_used_at |
datetime
|
|
|
|
| password |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| role |
enum('admin', 'user', 'pentadbir_markas', 'mto')
|
utf8mb4_general_ci
|
|
|
| status |
enum('active', 'inactive')
|
utf8mb4_general_ci
|
|
|
| unit |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| unit_id |
int(11)
|
|
|
|
| skn_caw_bhg |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| branch_id |
int(11)
|
|
|
|
| reset_token_hash |
varchar(64)
|
utf8mb4_general_ci
|
|
|
| reset_token_expires |
datetime
|
|
|
|
| alamat |
text
|
utf8mb4_general_ci
|
|
|
| alamat_keluarga_lokasi |
text
|
utf8mb4_general_ci
|
|
|
| alamat_keluarga_poskod |
varchar(10)
|
utf8mb4_general_ci
|
|
|
| alamat_keluarga_daerah |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| alamat_keluarga_negeri |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| alamat_semasa_lokasi |
text
|
utf8mb4_general_ci
|
|
|
| alamat_semasa_poskod |
varchar(10)
|
utf8mb4_general_ci
|
|
|
| alamat_semasa_daerah |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| alamat_semasa_negeri |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| tarikh_lahir |
varchar(10)
|
utf8mb4_general_ci
|
|
|
| tarikh_tauliah |
date
|
|
|
|
| status_perkahwinan |
enum('BERKAHWIN', 'BUJANG', 'DUDA', 'JANDA')
|
utf8mb4_general_ci
|
|
|
| agama |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| bangsa |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| jantina |
enum('LELAKI', 'PEREMPUAN')
|
utf8mb4_general_ci
|
|
|
| profile_picture |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| profile_identity_locked |
tinyint(1)
|
|
|
|
| jawatan |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| bahagian |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| section_id |
int(11)
|
|
|
|
| tred |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| kepakaran |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| allow_maklumat_lesen |
tinyint(1)
|
|
|
|
| updated_at |
timestamp
|
|
|
|
| mapping_verified_at |
datetime
|
|
|
|
