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)