cms_int
Tables (50)
activity_log
- id — int — Primary key — NOT NULL
- log_name — varchar(255)
- description — text — NOT NULL
- subject_id — int
- subject_type — varchar(255)
- event — varchar(255)
- causer_id — int
- causer_type — varchar(255)
- properties — text
- batch_uuid — char(36)
- created_at — timestamp
- updated_at — timestamp
announcements
- id — int — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- subject — text — NOT NULL
- started_at — date — NOT NULL
- ended_at — date — NOT NULL
- is_internal — tinyint(1) — NOT NULL
- is_public — tinyint(1) — NOT NULL
- is_guest — tinyint(1) — NOT NULL
- creator_id — int — Foreign key — NOT NULL
- deleted_at — timestamp
- created_at — timestamp
- updated_at — timestamp
- internal_id — int
api_log
- id — int — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- request_info — text — NOT NULL
- response — longtext
- completed — tinyint(1)
- aduan_id — bigint
- created_at — timestamp
- updated_at — timestamp
- request_type — varchar(255)
- request_id — bigint
auth_log
- id — int — Primary key — NOT NULL
- user_id — int — Foreign key
- type — enum('login','logout','try','imp_start','imp_stop') — NOT NULL
- username — varchar(255) — NOT NULL
- ip — varchar(255) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
complainers
- id — int — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- people_id — int — Foreign key → people.id — NOT NULL
- snapshot — longtext
- old_password — varchar(255)
- deleted_at — timestamp
- created_at — timestamp
- updated_at — timestamp
- public_id — int
- internal_id — bigint
complaint_feedbacks
- id — int — Primary key — NOT NULL
- title — varchar(255)
- content — text — NOT NULL
- sms — text
- raw_to — text
- telephone — varchar(255)
- parent_id — int — Foreign key → complaint_feedbacks.id
- type_id — int — Foreign key — NOT NULL
- complaint_id — int — Foreign key → complaints.id — NOT NULL
- is_queued — tinyint(1) — NOT NULL
- marking — varchar(255)
- has_sent — tinyint(1)
- created_by — bigint
- verified_by — bigint
- approved_by — bigint
- created_remark — text
- verified_remark — text
- approved_remark — text
- created_at — timestamp
- updated_at — timestamp
complaint_jmm_meeting
- id — int — Primary key — NOT NULL
- complaint_id — int — Foreign key → complaints.id — NOT NULL
- jmm_meeting_id — int — Foreign key → jmm_meetings.id — NOT NULL
- deleted_at — timestamp
- created_at — timestamp
- updated_at — timestamp
complaint_letters
- id — int — Primary key — NOT NULL
- complaint_id — int — Foreign key → complaints.id — NOT NULL
- feedback_id — bigint
- marking — varchar(255)
- sprm_reference_number — varchar(255)
- receiver_reference_number — varchar(255)
- receiver_refer_id — int — Foreign key
- recipient — longtext
- copy_to — longtext
- type — longtext
- jmm_date — date
- letter_date — date
- letter_hijr_date — datetime
- receiver_address_title_id — int — Foreign key
- receiver_address — text — NOT NULL
- receiver_prefix_title — varchar(255)
- receiver_title_id — int — Foreign key — NOT NULL
- title — varchar(255) — NOT NULL
- content — text — NOT NULL
- copy_remark — text
- additional_copy_remark — text
- kc_remark — text
- email_to — varchar(255)
- email_to_additional — text
- feedback_remark — text
- letter — text — Letter Generated & Attached
- send_to_kc — int
- signed_by — int — Foreign key
- emailed_by — int — Foreign key
- created_by — int — Foreign key — NOT NULL
- verified_by — bigint
- approved_by — bigint
- created_remark — text
- verified_remark — text
- approved_remark — text
- created_at — timestamp
- updated_at — timestamp
- emailed_at — datetime
- deleted_at — timestamp
complaint_logs
- id — int — Primary key — NOT NULL
- complaint_id — int — Foreign key → complaints.id — NOT NULL
- remark — text — NOT NULL
- remark_by — int — Foreign key
- deleted_at — timestamp
- created_at — timestamp
- updated_at — timestamp
- j003complaintlog_id — varchar(255)
complaint_references
- id — int — Primary key — NOT NULL
- data_source — varchar(255) — NOT NULL
- complaint_id — int — Foreign key → complaints.id — NOT NULL
- reference_complaint_id — int — Foreign key → complaints.id
- reference_other_key — varchar(255)
- cris_number — varchar(255)
- ks_number — varchar(255)
- description — longtext
- doket_description — varchar(255)
- suspect_id — int — Foreign key → suspects.id
- user_id — int — Foreign key
- deleted_at — timestamp
- created_at — timestamp
- updated_at — timestamp
complaint_status_logs
- id — int — Primary key — NOT NULL
- complaint_id — int — Foreign key → complaints.id — NOT NULL
- from_status_id — int — Foreign key
- to_status_id — int — Foreign key — NOT NULL
- from_user_id — int — Foreign key
- to_user_id — int — Foreign key
- sla — int
- time_difference — int — NOT NULL
- is_overdue — int — NOT NULL
- remark — text
- deleted_at — timestamp
- created_at — timestamp
- updated_at — timestamp
- j002complaint_id — varchar(255)
- j003complaintlog_id — varchar(255)
complaint_tasks
- id — int — Primary key — NOT NULL
- complaint_id — int — Foreign key → complaints.id — NOT NULL
- user_id — int — Foreign key — NOT NULL
- is_active — tinyint(1) — NOT NULL
- remark — text
- deleted_at — timestamp
- created_at — timestamp
- updated_at — timestamp
complaints
- id — int — Primary key — NOT NULL
- slug — varchar(255)
- reference_number — varchar(255)
- public_cms_number — varchar(255)
- info_number — varchar(255)
- branch_info_number — varchar(255)
- title — text — NOT NULL
- description — mediumtext
- description_1 — text
- description_2 — text
- description_3 — text
- description_4 — text
- description_5 — longtext
- description_6 — text
- note — text
- is_urgent — tinyint(1) — NOT NULL
- is_agreed_for_referral — tinyint(1) — NOT NULL
- is_submitted — tinyint(1) — NOT NULL
- complainer_id — int — Foreign key → complainers.id
- old_complainer — varchar(255)
- is_whistleblower — tinyint(1) — NOT NULL
- is_no_suspect — tinyint(1) — NOT NULL
- no_feedback — tinyint(1)
- no_feedback_reason — text
- no_feedback_approver — bigint
- source_id — int — Foreign key — NOT NULL
- status_id — int — Foreign key — NOT NULL
- marking — varchar(255) — Complaint Flow Marking
- complaint_category_id — int — Foreign key
- field_category_id — int — Foreign key
- field_subcategory_id — int
- feed_email_detail_id — int — Foreign key → feed_email_details.id
- nfa_remark_id — int — Foreign key
- state_id — int — Foreign key
- department_id — int — Foreign key
- zone_id — int — Foreign key
- active_user_id — int — Foreign key
- inboxed_at — datetime
- is_cris_check — tinyint(1) — NOT NULL
- cris_aduan_id — int — use aduan because old data is using idaduan
- cris_raw — text
- cris_case_type_id — int — Foreign key
- cris_description — text
- currency_type — int — Foreign key
- property_value — varchar(255)
- other_property_value — varchar(255)
- cris_detail_level_1_id — int — Foreign key
- cris_detail_level_2_id — int — Foreign key
- cris_detail_level_3_id — int — Foreign key
- cris_organization_level_4_id — int — Foreign key
- agency_name — varchar(255)
- organisation — longtext — organisation information
- organization_link — varchar(255)
- classification_detail_id — int — Foreign key
- classification_type_id — int — Foreign key
- classification_act_id — int — Foreign key
- classification_section_id — int — Foreign key
- bribe_state_id — int — Foreign key
- bribe_district_id — int — Foreign key
- cris_io — varchar(255) — dari cris
- … +50
complaints_412023
- id — int — Primary key — NOT NULL
- slug — varchar(255)
- reference_number — varchar(255)
- public_cms_number — varchar(255)
- info_number — varchar(255)
- branch_info_number — varchar(255)
- title — varchar(255) — NOT NULL
- description — mediumtext
- description_1 — text
- description_2 — text
- description_3 — text
- description_4 — text
- description_5 — longtext
- description_6 — text
- note — text
- is_urgent — tinyint(1) — NOT NULL
- is_agreed_for_referral — tinyint(1) — NOT NULL
- is_submitted — tinyint(1) — NOT NULL
- complainer_id — int
- old_complainer — varchar(255)
- is_whistleblower — tinyint(1) — NOT NULL
- is_no_suspect — tinyint(1) — NOT NULL
- source_id — int — NOT NULL
- status_id — int — NOT NULL
- complaint_category_id — int
- field_category_id — int
- field_subcategory_id — int
- feed_email_detail_id — int
- nfa_remark_id — int
- state_id — int
- department_id — int
- zone_id — int
- active_user_id — int
- inboxed_at — datetime
- is_cris_check — tinyint(1) — NOT NULL
- cris_aduan_id — int — use aduan because old data is using idaduan
- cris_raw — text
- cris_case_type_id — int
- cris_description — text
- currency_type — int
- property_value — varchar(255)
- other_property_value — varchar(255)
- cris_detail_level_1_id — int
- cris_detail_level_2_id — int
- cris_detail_level_3_id — int
- cris_organization_level_4_id — int
- agency_name — varchar(255)
- organization_link — varchar(255)
- classification_detail_id — int
- classification_type_id — int
- classification_act_id — int
- classification_section_id — int
- bribe_state_id — int
- bribe_district_id — int
- cris_io — varchar(255) — dari cris
- cris_io_ic — varchar(255)
- cris_status — int — dari cris
- cris_status_description — varchar(255) — dari cris
- cris_doket_description — varchar(255)
- cris_doket_code — varchar(255)
- … +42
directory_branches
- id — int — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- address — text — NOT NULL
- state_id — int — Foreign key — NOT NULL
- is_main — tinyint(1) — NOT NULL
- phone_number — varchar(255) — NOT NULL
- fax_number — varchar(255) — NOT NULL
- geo_lat — varchar(255) — NOT NULL
- geo_lng — varchar(255) — NOT NULL
- cris_code — varchar(255)
- deleted_at — timestamp
- created_at — timestamp
- updated_at — timestamp
- internal_id — int
failed_jobs
- id — bigint — Primary key — NOT NULL
- uuid — char(36) — NOT NULL
- connection — text — NOT NULL
- queue — text — NOT NULL
- payload — longtext — NOT NULL
- exception — longtext — NOT NULL
- failed_at — timestamp — NOT NULL
feed_email_details
- id — int — Primary key — NOT NULL
- email_id — int — Foreign key → feed_emails.id — NOT NULL
- subject — varchar(255) — NOT NULL
- content — longtext — NOT NULL
- message_id — varchar(255) — NOT NULL
- message_reply_id — varchar(255)
- is_input — tinyint(1) — NOT NULL
- is_read — tinyint(1) — NOT NULL
- other_recipient — text
- creator_id — int — Foreign key
- deleted_at — timestamp
- created_at — timestamp
- updated_at — timestamp
feed_emails
- id — int — Primary key — NOT NULL
- email — varchar(255) — NOT NULL
- is_active — tinyint(1) — NOT NULL
- is_blocked — tinyint(1) — NOT NULL
- deleted_at — timestamp
- created_at — timestamp
- updated_at — timestamp
feed_sms_details
- id — int — Primary key — NOT NULL
- sms_id — int — Foreign key → feed_smses.id — NOT NULL
- content — text — NOT NULL
- parent_id — int — Foreign key → feed_sms_details.id
- uid — varchar(255) — NOT NULL
- ack — varchar(255) — NOT NULL
- send_at — timestamp
- delivery_status — varchar(255)
- deliver_at — timestamp
- is_input — tinyint(1) — NOT NULL
- creator_id — int — Foreign key
- inbox — longtext — Array of inbox msg_id
- deleted_at — timestamp
- created_at — timestamp
- updated_at — timestamp
- received_date — date
feed_smses
- id — int — Primary key — NOT NULL
- phone_number — varchar(255) — NOT NULL
- is_active — tinyint(1) — NOT NULL
- is_blocked — tinyint(1) — NOT NULL
- deleted_at — timestamp
- created_at — timestamp
- updated_at — timestamp
feed_templates
- id — int — Primary key — NOT NULL
- sort — varchar(255) — NOT NULL
- category — enum('email','sms') — NOT NULL
- code — varchar(255)
- title — varchar(255) — NOT NULL
- body — text — NOT NULL
- deleted_at — timestamp
- created_at — timestamp
- updated_at — timestamp
- t008_id — varchar(255)
inquiries
- id — int — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- reference_number — varchar(255) — NOT NULL
- description — text — NOT NULL
- user_id — int — Foreign key
- status_id — int — Foreign key — NOT NULL
- zone_id — int — Foreign key
- deleted_at — timestamp
- created_at — timestamp
- updated_at — timestamp
jmm_meetings
- id — int — Primary key — NOT NULL
- uuid — char(36)
- running_number — varchar(255) — NOT NULL
- jmm_number — varchar(255)
- remark — text
- is_conclude — tinyint(1)
- is_special — tinyint(1)
- meeting_date — date — NOT NULL
- jmm_meeting_date — date
- chairman_id — int — Foreign key — NOT NULL
- hod_id — int — Foreign key — NOT NULL
- member_id — int — Foreign key — NOT NULL
- presenter_id — int — Foreign key — NOT NULL
- deleted_at — timestamp
- created_at — timestamp
- updated_at — timestamp
jobs
- id — bigint — Primary key — NOT NULL
- queue — varchar(255) — NOT NULL
- payload — longtext — NOT NULL
- attempts — tinyint — NOT NULL
- reserved_at — int
- available_at — int — NOT NULL
- created_at — int — NOT NULL
letter_feedback
- id — bigint — Primary key — NOT NULL
- reference — varchar(255)
- content — text
- status_id — bigint — NOT NULL — Status From Feedback
- complaint_id — bigint — NOT NULL — Complaint associate to the letter
- letter_id — bigint — NOT NULL — Letter to referring the feedback
- create_by — bigint — NOT NULL — Person that upload refer feedback
- letter_date — date
- attachment — text
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
mail_token
- id — int — Primary key — NOT NULL
- token — varchar(255) — NOT NULL
- notifiable_type — varchar(255) — NOT NULL
- notifiable_id — bigint — NOT NULL
- last_mail_at — timestamp
- last_verify_at — timestamp
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
media
- id — int — Primary key — NOT NULL
- uuid — char(36) — NOT NULL
- model_type — varchar(255) — NOT NULL
- model_id — bigint — NOT NULL
- collection_name — varchar(255) — NOT NULL
- name — varchar(255) — NOT NULL
- file_name — varchar(255) — NOT NULL
- mime_type — varchar(255)
- disk — varchar(255) — NOT NULL
- size — int — NOT NULL
- manipulations — longtext — NOT NULL
- custom_properties — longtext — NOT NULL
- responsive_images — longtext — NOT NULL
- order_column — int
- public_id — int
- conversions_disk — varchar(255) — NOT NULL
- generated_conversions — varchar(255) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
migrations
- id — int — Primary key — NOT NULL
- migration — varchar(255) — NOT NULL
- batch — int — NOT NULL
model_has_permissions
- model_id — bigint — Primary key — NOT NULL
- model_type — varchar(255) — Primary key — NOT NULL
- permission_id — int — Foreign key → permissions.id — NOT NULL
model_has_roles
- model_id — bigint — Primary key — NOT NULL
- model_type — varchar(255) — Primary key — NOT NULL
- role_id — int — Foreign key → roles.id — NOT NULL
notifications
- id — char(36) — Primary key — NOT NULL
- type — varchar(255) — NOT NULL
- notifiable_type — varchar(255) — NOT NULL
- notifiable_id — bigint — NOT NULL
- data — text — NOT NULL
- read_at — timestamp
- created_at — timestamp
- updated_at — timestamp
oauth_access_tokens
- id — varchar(100) — Primary key — NOT NULL
- user_id — int
- client_id — int — NOT NULL
- name — varchar(255)
- scopes — text
- revoked — tinyint(1) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- expires_at — datetime
oauth_auth_codes
- id — varchar(100) — Primary key — NOT NULL
- user_id — int — NOT NULL
- client_id — int — NOT NULL
- scopes — text
- revoked — tinyint(1) — NOT NULL
- expires_at — datetime
oauth_clients
- id — int — Primary key — NOT NULL
- user_id — int
- name — varchar(255) — NOT NULL
- secret — varchar(100) — NOT NULL
- redirect — text — NOT NULL
- personal_access_client — tinyint(1) — NOT NULL
- password_client — tinyint(1) — NOT NULL
- revoked — tinyint(1) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
oauth_personal_access_clients
- id — int — Primary key — NOT NULL
- client_id — int — NOT NULL
- created_at — timestamp
- updated_at — timestamp
oauth_refresh_tokens
- id — varchar(100) — Primary key — NOT NULL
- access_token_id — varchar(100) — NOT NULL
- revoked — tinyint(1) — NOT NULL
- expires_at — datetime
options
- id — int — Primary key — NOT NULL
- type — varchar(255) — NOT NULL
- setting — varchar(255) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
password_reset_tokens
- email — varchar(255) — Primary key — NOT NULL
- token — varchar(255) — NOT NULL
- created_at — timestamp
password_resets
- email — varchar(255) — NOT NULL
- token — varchar(255) — NOT NULL
- created_at — timestamp
people
- id — int — Primary key — NOT NULL
- has_update — tinyint(1) — Indicator data has been update
- user_title_id — int — Foreign key
- name — varchar(255) — NOT NULL
- internal_identity_type — tinyint — NOT NULL
- nric — varchar(255)
- id_type — longtext — 1-MyKad,2-MyKid,3-MyPR,4-Passport/UNCHR,5-Polis/Tentera,6-Kad Pengenalan Lama,7-No. Syarikat
- old_nric — varchar(255)
- passport — varchar(255)
- army_police_number — varchar(255)
- email — varchar(255)
- telephone_number — varchar(255)
- designation — varchar(255)
- department — varchar(255)
- office_telephone_number — varchar(255)
- user_type_id — int — Foreign key
- position_grade — varchar(255)
- organisation — longtext — organisation information
- organization_1_id — int — Foreign key
- organization_2_id — int — Foreign key
- organization_3_id — int — Foreign key
- organization_4_id — int — Foreign key
- position_organization_id — int — Foreign key
- sub_position_organization_id — int — Foreign key
- position_group_id — int — Foreign key
- organization_state_id — int — Foreign key
- gender_id — int — Foreign key
- race_id — int — Foreign key
- nationality_id — int — Foreign key
- religion_id — int — Foreign key
- address_1 — varchar(255)
- address_2 — varchar(255)
- address_3 — varchar(255)
- address_selected — bigint — address selected from profile bank
- mail_address_same — tinyint(1) — Mailing Address Same As Permanent
- mail_address_1 — varchar(255)
- mail_address_2 — varchar(255)
- mail_postcode — varchar(255)
- mail_country_id — int
- mail_state_id — int
- mail_district_id — int
- country_id — int — Foreign key
- state_id — int — Foreign key
- district_id — int — Foreign key
- district — varchar(255)
- subdistrict_id — int — Foreign key
- postcode — varchar(255)
- remark — varchar(255)
- deleted_at — timestamp
- created_at — timestamp
- updated_at — timestamp
- j001client_id — varchar(255)
- j008ott_id — varchar(255)
- t001user_id — varchar(255)
- public_id — int
- internal_id — bigint
people_extra
- id — int — Primary key — NOT NULL
- subject — varchar(255) — NOT NULL
- people_id — int — Foreign key → people.id — NOT NULL
- type_id — int — Foreign key — NOT NULL
- deleted_at — timestamp
- created_at — timestamp
- updated_at — timestamp
permissions
- id — int — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- guard_name — varchar(255) — NOT NULL
- group — varchar(255) — NOT NULL
- can_assign — tinyint(1) — mark this if can be assigned
- created_at — timestamp
- updated_at — timestamp
personal_access_tokens
- id — bigint — Primary key — NOT NULL
- tokenable_type — varchar(255) — NOT NULL
- tokenable_id — bigint — NOT NULL
- name — varchar(255) — NOT NULL
- token — varchar(64) — NOT NULL
- abilities — text
- last_used_at — timestamp
- expires_at — timestamp
- created_at — timestamp
- updated_at — timestamp
role_has_permissions
- permission_id — int — Foreign key → permissions.id — NOT NULL
- role_id — int — Foreign key → roles.id — NOT NULL
roles
- id — int — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- description — varchar(255)
- guard_name — varchar(255) — NOT NULL
- group — varchar(255) — NOT NULL
- level — int — NOT NULL
- active — tinyint(1) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
runners
- id — int — Primary key — NOT NULL
- rule_1 — varchar(255) — NOT NULL
- rule_2 — varchar(255)
- rule_3 — varchar(255)
- rule_4 — varchar(255)
- rule_5 — varchar(255)
- runner — varchar(255) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
seeders
- seed — varchar(255) — NOT NULL
- env — varchar(255) — NOT NULL
- batch — int — NOT NULL
sessions
- id — varchar(255) — Primary key — NOT NULL
- user_id — bigint
- ip_address — varchar(45)
- user_agent — text
- payload — longtext — NOT NULL
- last_activity — int — NOT NULL
suspect_charge
- id — int — Primary key — NOT NULL
- suspect_id — int — Foreign key → suspects.id — NOT NULL
- charge_id — int — Foreign key — NOT NULL
- deleted_at — timestamp
- created_at — timestamp
- updated_at — timestamp
suspects
- id — int — Primary key — NOT NULL
- people_id — int — Foreign key → people.id — NOT NULL
- complaint_id — int — Foreign key → complaints.id
- user_title_id — int — Foreign key
- office_telephone_number — varchar(255)
- position_grade — varchar(255)
- position_organization_id — int — Foreign key
- sub_position_organization_id — int — Foreign key
- position_group_id — int — Foreign key
- organization_state_id — int — Foreign key
- designation — varchar(255)
- department — varchar(255)
- organization_1_id — int — Foreign key
- organization_2_id — int — Foreign key
- organization_3_id — int — Foreign key
- organization_4_id — int — Foreign key
- address_1 — varchar(255)
- address_2 — varchar(255)
- address_3 — varchar(255)
- country_id — int — Foreign key
- state_id — int — Foreign key
- district_id — int — Foreign key
- subdistrict_id — int — Foreign key
- postcode — varchar(255)
- remark — varchar(255)
- order — int — NOT NULL
- deleted_at — timestamp
- created_at — timestamp
- updated_at — timestamp
- j009ottjabatan_id — varchar(255)