UDA-Life

Tables (47)

address

  • id — int — Primary key — NOT NULL
  • profile_id — int — Foreign key → profile.id — NOT NULL
  • lkp_address_type_id — int — Foreign key → lkp_address_type.id — NOT NULL
  • email — varchar
  • contact_no — varchar
  • address1 — varchar
  • address2 — varchar
  • address3 — varchar
  • postcode — varchar
  • town — varchar
  • state — varchar
  • country — varchar
  • status — int

engagement

  • id — int — Primary key — NOT NULL
  • engagement_group_id — int — Foreign key → engagement_group.id — NOT NULL
  • lkp_engagement_type_id — int — Foreign key → lkp_engagement_type.id — NOT NULL
  • content — longtext
  • status — int — 0 - Tidak Aktif 1 - Aktif

engagement_channel

  • engagement_id — int — Foreign key → engagement.id — NOT NULL
  • lkp_channel_id — int — Foreign key → lkp_channel.id — NOT NULL

engagement_group

  • id — int — Primary key — NOT NULL
  • description — varchar — group purchaser group potential buyer group sales agent
  • seq — int
  • status — int

engagement_group_profile

  • id — int — Primary key — NOT NULL
  • profile_id — int — Foreign key → profile.id — NOT NULL
  • engagement_group_id — int — Foreign key → engagement_group.id — NOT NULL
  • status — int

helpdesk

  • id — int — Primary key — NOT NULL
  • lkp_helpdesk_type_id — int — Foreign key → lkp_helpdesk_type.id — NOT NULL
  • lkp_helpdesk_status_id — int — Foreign key → lkp_helpdesk_status.id — NOT NULL
  • lkp_helpdesk_severity_id — int — Foreign key → lkp_heldesk_severity.id — NOT NULL
  • lkp_helpdesk_priority_id — int — Foreign key → lkp_heldesk_priority.id — NOT NULL
  • user_id — int — Foreign key → users.id — NOT NULL — escalated user
  • helpdesk_no — varchar
  • remark — text
  • name — varchar
  • contact_no — varchar
  • emel — varchar

helpdesk_action

  • id — int — Primary key — NOT NULL
  • helpdesk_id — int — Foreign key → helpdesk.id — NOT NULL
  • user_id — int — Foreign key → users.id — NOT NULL
  • transaction_date — datetime
  • remark — text
  • escalated_user_id — int — link table users

lampiran

  • id — int — Primary key — NOT NULL
  • model — varchar
  • model_id — int
  • path — varchar
  • url — varchar
  • size — number
  • filename_ori — varchar
  • type — varchar

lkp_address_type

  • id — int — Primary key — NOT NULL
  • description — varchar — office home
  • seq — int
  • status — int

lkp_channel

  • id — int — Primary key — NOT NULL
  • description — varchar — emel wassap telegram
  • token — varchar
  • seq — int
  • status — int

lkp_engagement_type

  • id — int — Primary key — NOT NULL
  • description — varchar
  • seq — int
  • status — int

lkp_heldesk_priority

  • id — int — Primary key — NOT NULL
  • code — varchar — P1 P2 P3 P4
  • description — varchar — P1 - Priority 1 P2 - Priority 2 P3 - Priority 3 P4 - Priority 4
  • seq — int
  • status — int

lkp_heldesk_severity

  • id — int — Primary key — NOT NULL
  • code — varchar — S1 S2 S3 S4
  • description — varchar — S1 - severity 1 S2 - severity 2 S3 - severity 3 S4 - severity 4
  • seq — int
  • status — int

lkp_helpdesk_status

  • id — int — Primary key — NOT NULL
  • description — varchar
  • seq — int
  • status — int

lkp_helpdesk_type

  • id — int — Primary key — NOT NULL
  • description — varchar — inquiry complaint suggestion others
  • seq — int
  • status — int

lkp_profile_category

  • id — int — Primary key — NOT NULL
  • description — varchar — individu syarikat persatuan glc kerajaan
  • seq — int
  • status — int

lkp_profile_type

  • id — int — Primary key — NOT NULL
  • description — varchar — kp passport biz reg
  • seq — int
  • status — int

lkp_property_booking_status

  • id — int — Primary key — NOT NULL
  • description — varchar — - new - follow up - confirm booking
  • seq — int
  • status — int

lkp_property_category

  • id — int — Primary key — NOT NULL
  • description — int — - Residential - Commercial - Waqf
  • seq — int
  • status — int

lkp_property_facility

  • id — int — Primary key — NOT NULL
  • description — int — - Multipurpose Hall, - Children Playground, - Basketball / Futsal court, - Prayer room (muslim)
  • image — varchar
  • facility_ind — 1- inside area 2- nearby
  • seq — int
  • status — int

lkp_property_spec

  • id — int — Primary key — NOT NULL
  • description — varchar — - project location - project type - land tenure - units - built_ up_area
  • seq — int
  • status — int

lkp_property_type

  • id — int — Primary key — NOT NULL
  • description — varchar — - Double Storey Bungalows - Apartment (Residensi Wilayah) - Apartment - Service Apartment - Semi-D & Bungalow (2 & 3 St…
  • seq — int
  • status — int

lkp_property_unit_status

  • id — int — Primary key — NOT NULL
  • description — varchar — - vacant - book - loan approve
  • seq — int
  • status — int

lkp_property_utility

  • id — int — Primary key — NOT NULL
  • description — varchar
  • image — varchar
  • seq — int
  • status — int

lkp_source_info

  • id — int — Primary key — NOT NULL
  • description — varchar — - social media - roadshow - media electronic - print media
  • seq — int
  • status — int

model_has_permissions

  • id — int — Primary key — NOT NULL
  • permissions_id — int — Foreign key → permissions.id — NOT NULL
  • model_id — int — Foreign key → users.id — NOT NULL
  • model_type — varchar

model_has_roles

  • id — int — Primary key — NOT NULL
  • roles_id — int — Foreign key → roles.id — NOT NULL
  • model_id — int — Foreign key → users.id — NOT NULL
  • model_type — varchar

modules

  • id — int — Primary key — NOT NULL
  • name — varchar
  • module_id — int — Foreign key → modules.id — NOT NULL
  • seq — int
  • status — int

permissions

  • id — int — Primary key — NOT NULL
  • name — varchar
  • guard_name — varchar

profile

  • id — int — Primary key — NOT NULL
  • lkp_profile_category_id — int — Foreign key → lkp_profile_category.id — NOT NULL
  • lkp_profile_type_id — int — Foreign key → lkp_profile_type.id — NOT NULL
  • name — varchar
  • id_no — varchar
  • Field

property

  • id — int — Primary key — NOT NULL
  • lkp_property_category_id — int — Foreign key → lkp_property_category.id — NOT NULL
  • region_id — int — Foreign key → region.id — NOT NULL
  • lkp_property_type_id — int — Foreign key → lkp_property_type.id — NOT NULL
  • name — varchar — - property name
  • size — decimal
  • price — decimal
  • about — text
  • logo_image — varchar
  • background_image — varchar
  • status — int — 1- launch 2- coming soon

property_award

  • id — int — Primary key — NOT NULL
  • property_id — int — Foreign key → property.id — NOT NULL
  • description — varchar
  • image — varchar

property_booking

  • id — int — Primary key — NOT NULL
  • property_id — int — Foreign key → property.id — NOT NULL
  • property_unit_id — int — Foreign key → property_unit.id — NOT NULL
  • profile_id — int — Foreign key → profile.id — NOT NULL
  • lkp_source_info_id — int — Foreign key → lkp_source_info.id — NOT NULL
  • state_id — int — Foreign key → state.id — NOT NULL
  • lkp_property_booking_status_id (lkp_property_booking_status) — int — Foreign key → lkp_property_booking_status.id — NOT NULL

property_facility

  • id — int — Primary key — NOT NULL
  • property_id — int — Foreign key → property.id — NOT NULL
  • lkp_property_facility_id — int — Foreign key → lkp_property_facility.id — NOT NULL
  • seq — int
  • status — int

property_floor_detail

  • id — int — Primary key — NOT NULL
  • lkp_property_utility_id — int — Foreign key → lkp_property_utility.id — NOT NULL
  • property_floor_plan_id — int — Foreign key → property_floor_plan.id — NOT NULL
  • quantity — number

property_floor_plan

  • id — int — Primary key — NOT NULL
  • property_id — int — Foreign key → property.id — NOT NULL
  • type_name — varchar
  • size — decimal
  • image — varchar

property_highlight

  • id — int — Primary key — NOT NULL
  • property_id — int — Foreign key → property.id — NOT NULL
  • lkp_property_facility_id — int — Foreign key → lkp_property_facility.id — NOT NULL
  • seq — int
  • status — int

property_highlight_detail

  • id — int — Primary key — NOT NULL
  • property_highlight_id — int — Foreign key → property_highlight.id — NOT NULL
  • description — text
  • seq — int
  • status — int

property_image

  • id — int — Primary key — NOT NULL
  • property_id — int — Foreign key → property.id — NOT NULL
  • description — varchar
  • image — varchar
  • seq — int
  • status — int

property_spec

  • id — int — Primary key — NOT NULL
  • property_id — int — Foreign key → property.id — NOT NULL
  • lkp_property_spec_id — int — Foreign key → lkp_property_spec.id — NOT NULL
  • description — varchar
  • seq — int
  • status — int

property_unit

  • id — int — Primary key — NOT NULL
  • property_id — int — Foreign key → property.id — NOT NULL
  • property_floor_plan_id — int — Foreign key → property_floor_plan.id — NOT NULL
  • lkp_property_unit_status_id — int — Foreign key → lkp_property_unit_status.id — NOT NULL
  • block — varchar
  • floor — varchar
  • unit — varchar

region

  • id — int — Primary key — NOT NULL
  • description — varchar — -central -east -north -south
  • seq — int
  • status — int

roles

  • id — int — Primary key — NOT NULL
  • module_id — int — Foreign key → modules.id — NOT NULL
  • name — varchar
  • status — int

state

  • id — int — Primary key — NOT NULL
  • region_id — int — Foreign key → region.id — NOT NULL
  • desciption — varchar
  • seq — int
  • status — int

survey

  • id — int — Primary key — NOT NULL
  • engagement_id — int — Foreign key → engagement.id — NOT NULL
  • url — varchar
  • description — varchar

survey_score

  • id — int — Primary key — NOT NULL
  • survey_id — int — Foreign key → survey.id — NOT NULL
  • profile_id — int — Foreign key → profile.id — NOT NULL

users

  • id — int — Primary key — NOT NULL
  • profile_id — int — Foreign key → profile.id — NOT NULL
  • user_id — varchar
  • password — varchar
  • name — varchar
  • email — varchar
  • email_verification — datetime
  • status — int
  • remember_token — varchar
  • sso_id — text