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: int