| id |
int(11)
|
|
|
|
| inmate_fullname |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| inmate_gender |
varchar(10)
|
utf8mb4_unicode_ci
|
|
|
| inmate_code |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| deposit_account_no |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| inmate_id_card |
varchar(13)
|
utf8mb4_unicode_ci
|
|
|
| inmate_race |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| inmate_nationality |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| inmate_age |
int(3)
|
|
|
|
| inmate_address |
text
|
utf8mb4_unicode_ci
|
|
|
| relative_name_1 |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| relative_name_2 |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| relative_name_3 |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| relative_name_4 |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| relative_name_5 |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| relative_name_6 |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| relative_name_7 |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| relative_name_8 |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| relative_name_9 |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| relative_name_10 |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| photo_path |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| created_at |
timestamp
|
|
|
|
| rel_updated_1 |
date
|
|
|
|
| rel_updated_2 |
date
|
|
|
|
| rel_updated_3 |
date
|
|
|
|
| rel_updated_4 |
date
|
|
|
|
| rel_updated_5 |
date
|
|
|
|
| rel_updated_6 |
date
|
|
|
|
| rel_updated_7 |
date
|
|
|
|
| rel_updated_8 |
date
|
|
|
|
| rel_updated_9 |
date
|
|
|
|
| rel_updated_10 |
date
|
|
|
|
| relative_updated_1 |
date
|
|
|
|
| relative_updated_2 |
date
|
|
|
|
| relative_updated_3 |
date
|
|
|
|
| relative_updated_4 |
date
|
|
|
|
| relative_updated_5 |
date
|
|
|
|
| relative_updated_6 |
date
|
|
|
|
| relative_updated_7 |
date
|
|
|
|
| relative_updated_8 |
date
|
|
|
|
| relative_updated_9 |
date
|
|
|
|
| relative_updated_10 |
date
|
|
|
|
| relative_name_11 |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| relative_updated_11 |
date
|
|
|
|
| relative_name_12 |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| relative_updated_12 |
date
|
|
|
|
| relative_name_13 |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| relative_updated_13 |
date
|
|
|
|
| relative_name_14 |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| relative_updated_14 |
date
|
|
|
|
| relative_name_15 |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| relative_updated_15 |
date
|
|
|
|
| relative_name_16 |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| relative_updated_16 |
date
|
|
|
|
