Invitation Sent Fact Table

This fact table captures events related to the sending of invitations during a referral campaign. It stores detailed information about each invitation sent, including the date and time at which the invitation was sent, identifiers for the campaign, client, and invitee, type of identifier and the status of the invitee.

Databricks Table Name: invitation_sent

Invitation Sent Fact - Entity Relationship Diagram (ERD)

Zoom in the table for more clarity. Click the table title to view its details.

Invitation Sentauto_update_time: bigintclient_code: stringclient_type: stringdim_campaign_id: bigintdim_event_date_id: bigintdim_event_time_id: bigintdim_event_user_id: bigintdim_event_zone_till_id: bigintdim_latest_updated_date_id: bigintdim_latest_updated_time_id: bigintidentifier_type: stringPKinvitee_id: bigintinvitee_identifier: stringinvitee_name: stringyear: intCampaignsis_recurring: stringcampaign_end_date: stringis_migrated: stringauto_update_campaign: bigintLKcampaign_id: bigintcampaign_type: stringroi_type: stringcampaign_start_date: stringname: stringDateLKdate_id: intday_of_month: intweek_of_year: intmonth: stringyear: intquarter: stringweek_number: intweek_start_date: stringweek_end_date: stringday_of_week: stringmonth_no: intmonth_no_of_year: intmonth_of_year: stringday_of_week_no: intquarter_no: intyearly_quarter_no: intdate: stringTimeLKtime_id: biginttime: stringhour_of_day: intminute_of_day: intday_shift: stringday_shift_no: inthour_range: stringZone_tillsstore_country: stringexternal_id_1: stringstore: stringauto_update_till_parent: bigintarea: stringstore_name: stringstore_city: stringstore_state: stringtill: stringauto_update_till_store_relation: bigintis_ffc_enabled: stringLKtill_id: biginttype: stringtill_description: stringauto_update_till: bigintstore_channel: stringexternal_id: stringis_billable: stringstore_id: bigintis_active: stringauto_update_store: bigintstore_description: stringlatitude: stringtimezone: stringexternal_id_2: stringtill_name: stringzone_name: stringDateTimeZone Tillsusersauto_update_merged_customer: bigintauto_update_loyalty: bigintfraud_status: stringtest_control_bucket: stringis_merged_customer: stringsubscription_status_email_bulk: stringfirst_name: stringslab_name: stringsubscription_status_wechat_bulk: stringemail: stringlast_name: stringmerged_user_id: bigintLKuser_id: bigintsubscription_status_wechat_trans: stringsubscription_status_sms_bulk: stringndnc_status: stringsubscription_status_email_trans: stringtest_control_status: stringauto_update_fraud_user: bigintis_inactive: stringsource: stringslab_number: intauto_update_users: bigintregistered_till_id: bigintauto_update_customer_enrollment: bigintslab_expiry_date: stringcustomer_external_id: stringsubscription_status_sms_trans: stringmobile: stringloyalty_type: stringauto_update_ndnc_status: bigintUsersInvitation SentCampaigns

Legend

PK   Primary Key

LK   Linking Key

Fact Table
Dimension Table

Invitation Sent Fact Table

Column Name

Data Type

Description

Linked Table

Availability for Export in the

Invitation Sent

Template

*

*

auto_update_time

bigint

Date and time when the corresponding record in the invitation_sent table available at the source was last updated. It is in the Unix timestamp format.

_

Yes; Measure Name: Auto Update Time

client_code

string

Referrers to the store code.

_

Yes; Measure Name: Client Code

client_type

string

Referrers to the client type from where the invitee came.

_

Yes; Measure Name: Client Type

dim_campaign_id

bigint

Identifier for the campaign under which the referral was made.

campaign

Yes; Dimension Name: Campaign > Campaign Id

dim_event_date_id

bigint

Date when the invitation was sent.

date

Yes; Dimension Name: Date > Date

dim_event_time_id

bigint

Time when the invitation was sent.

time

Yes; Dimension Name: Time > Time Id

dim_event_user_id

bigint

Identifier for the user who sent the invitation.

users

Yes; Dimension Name: User > User Id

dim_event_zone_till_id

bigint

Identifier assigned to the point-of-sale (POS) terminal within a store. It distinguishes one checkout location from another within the same store.

zone_till

Yes; Dimension Name: Store Hierarchy > Till Id

dim_latest_updated_date_id

bigint

Date when the data corresponding to this event/row is changed in the source table.

date

Yes; Dimension Name: Latest Updated Date > Date

dim_latest_updated_time_id

bigint

Time when the data corresponding to this event/row is changed in the source table.

time

Yes; Dimension Name: Latest Updated Time > Time Id

identifier_type

string

Type of identifier used for the invitee (e.g., email, mobile).

_

Yes; Measure Name: Identifier Type

invitee_id

bigint

Unique identifier for the invitee. It is the primary key of the table.

_

Yes; Measure Name: Invitee Id

invitee_identifier

string

Identifier for the invitee, such as mobile number.

_

Yes; Measure Name: Invitee Identifier

invitee_name

string

Name of the invitee.

_

Yes; Measure Name: Invitee Name

year

int

Year when the invitation was sent.

_

Yes; Dimension Name: Year