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