Data model
"BADGE" {
shape: sql_table
"id": UUID {constraint: primary_key}
"customer_priority": VARCHAR(255)
"level": INTEGER
"name": VARCHAR
"only_for_fifty_plus_employees": BOOLEAN
}
"BADGE_ACTION" {
shape: sql_table
"id": UUID {constraint: primary_key}
"badge_id": UUID
"name": VARCHAR
"only_for_fifty_plus_employees": BOOLEAN
"order": INTEGER
}
"BADGE_ACTION_USER" {
shape: sql_table
"id": UUID {constraint: primary_key}
"account_id": VARCHAR
"app_id": VARCHAR(255)
"badge_action_id": UUID
"user_id": VARCHAR
}
"BADGE_USER" {
shape: sql_table
"id": UUID {constraint: primary_key}
"account_id": VARCHAR
"app_id": VARCHAR(255)
"badge_id": UUID
"user_id": VARCHAR
}
"ACCOUNT_CREDITS" {
shape: sql_table
"id": UUID {constraint: primary_key}
"account_id": UUID
"app_name": VARCHAR(255)
"initially_available_credits": INTEGER
"internal_comment": VARCHAR
}
"WORKSHOP_REQUEST" {
shape: sql_table
"id": UUID {constraint: primary_key}
"account_id": UUID
"account_name": TEXT
"address": TEXT
"alaner_intervention_comment": TEXT
"allocated_expert_slug": VARCHAR(255)
"allocation_was_automated": BOOLEAN
"app_name": VARCHAR(255)
"country": VARCHAR(255)
"did_alaner_intervene": BOOLEAN
"format": VARCHAR(255)
"language": VARCHAR(255)
"notifications_slack_thread_ts": TEXT
"number_of_workshops": INTEGER
"ops_comment": TEXT
"organizer_point_of_contact_user_id": VARCHAR(255)
"request_state": VARCHAR(255)
"request_validated_at": DATETIME
"requested_by_user_id": VARCHAR(255)
"requested_by_user_name": TEXT
"source": VARCHAR(255)
"subtopic": VARCHAR
"workshop_topic": VARCHAR(255)
"zip_code": VARCHAR(20)
}
"ACCOUNT_CREDIT_CONSUMPTION" {
shape: sql_table
"id": UUID {constraint: primary_key}
"account_credits_id": UUID
"consumed_credits_count": INTEGER
"consuming_workshop_request_id": UUID
"internal_comment": TEXT
}
"CRISIS_REQUEST" {
shape: sql_table
"id": UUID {constraint: primary_key}
"account_id": UUID
"account_name": TEXT
"admin_user_id": VARCHAR(255)
"admin_user_name": TEXT
"app_name": VARCHAR(255)
"call_with_an_expert_at": DATETIME
"context_gathering_sync_session_at": DATETIME
"crisis_subtype": VARCHAR(255)
"crisis_summary": TEXT
"crisis_type": VARCHAR(255)
"event_occurred_at": DATETIME
"informative_sheet_url": VARCHAR(255)
"is_automated": BOOLEAN
"is_preventable": BOOLEAN
"notion_page_url": VARCHAR(255)
"ops_owner": VARCHAR(255)
"preferred_contact_method": VARCHAR(255)
"request_information": TEXT
"request_origin": VARCHAR(255)
"requested_at": DATETIME
"requested_by_user_id": VARCHAR(255)
"requested_by_user_name": TEXT
"requested_by_user_slack_handle": VARCHAR(255)
"slack_thread_url": VARCHAR(255)
"status": VARCHAR(255)
"support_type": VARCHAR(255)
}
"CRISIS_RESOLUTION_PLAN" {
shape: sql_table
"id": UUID {constraint: primary_key}
"crisis_request_id": UUID
"dato_model_id": VARCHAR
"first_support_actions_published_at": DATETIME
"follow_up_actions_published_at": DATETIME
"notion_page_url": VARCHAR
}
"COMPANY_ACCOUNTS_TURING_DATA" {
shape: sql_table
"id": UUID {constraint: primary_key}
"customer_success_manager_name": TEXT
"key_account_manager_name": TEXT
}
"CUSTOMER_PRIORITIES_SURVEY_OPTION" {
shape: sql_table
"id": UUID {constraint: primary_key}
"name": VARCHAR
"order": INTEGER
}
"CUSTOMER_PRIORITIES_SURVEY_ANSWER" {
shape: sql_table
"id": UUID {constraint: primary_key}
"account_id": VARCHAR
"app_id": VARCHAR(255)
"customer_priorities_survey_option_id": UUID
"other_text": TEXT
"source": VARCHAR(255)
"user_id": VARCHAR
}
"WORKSHOP_SESSION" {
shape: sql_table
"id": UUID {constraint: primary_key}
"allocated_expert_slug": VARCHAR(255)
"briefing_session_calendly_event_url": VARCHAR
"briefing_session_event_data": JSONB
"briefing_session_google_calendar_event_id": VARCHAR
"briefing_session_start_datetime": DATETIME
"calendly_event_url": VARCHAR
"event_data": JSONB
"format": VARCHAR(255)
"google_calendar_event_id": VARCHAR
"is_cancelled": BOOLEAN
"language": VARCHAR(255)
"notification_for_participant_collection_sent_at": DATETIME
"start_datetime": DATETIME
"subtopic": VARCHAR
"workshop_followed_recommendations": VARCHAR(255)
"workshop_followed_recommendations_comment": TEXT
"workshop_request_id": UUID
"workshop_topic": VARCHAR(255)
}
"POST_WORKSHOP_REPORT" {
shape: sql_table
"id": UUID {constraint: primary_key}
"notification_email_sent_at": DATETIME
"report_first_seen_at": DATETIME
"workshop_session_id": UUID
}
"WORKSHOP_PARTICIPANT" {
shape: sql_table
"id": UUID {constraint: primary_key}
"alan_user_id": VARCHAR
"app_name": VARCHAR(255)
"attended": BOOLEAN
"attendee_metadata": JSONB
"email_address": VARCHAR
"workshop_session_id": UUID
}
"BADGE"."id" -> "BADGE_ACTION"."badge_id": {
source-arrowhead.shape: cf-one-required
target-arrowhead.shape: cf-many
}
"BADGE_ACTION"."id" -> "BADGE_ACTION_USER"."badge_action_id": {
source-arrowhead.shape: cf-one-required
target-arrowhead.shape: cf-many
}
"BADGE"."id" -> "BADGE_USER"."badge_id": {
source-arrowhead.shape: cf-one-required
target-arrowhead.shape: cf-many
}
"ACCOUNT_CREDITS"."id" -> "ACCOUNT_CREDIT_CONSUMPTION"."account_credits_id": {
source-arrowhead.shape: cf-one-required
target-arrowhead.shape: cf-many
}
"WORKSHOP_REQUEST"."id" -> "ACCOUNT_CREDIT_CONSUMPTION"."consuming_workshop_request_id": {
source-arrowhead.shape: cf-one
target-arrowhead.shape: cf-one-required
}
"CRISIS_REQUEST"."id" -> "CRISIS_RESOLUTION_PLAN"."crisis_request_id": {
source-arrowhead.shape: cf-one-required
target-arrowhead.shape: cf-many
}
"CUSTOMER_PRIORITIES_SURVEY_OPTION"."id" -> "CUSTOMER_PRIORITIES_SURVEY_ANSWER"."customer_priorities_survey_option_id": {
source-arrowhead.shape: cf-one
target-arrowhead.shape: cf-many
}
"WORKSHOP_REQUEST"."id" -> "WORKSHOP_SESSION"."workshop_request_id": {
source-arrowhead.shape: cf-one-required
target-arrowhead.shape: cf-many
}
"WORKSHOP_SESSION"."id" -> "POST_WORKSHOP_REPORT"."workshop_session_id": {
source-arrowhead.shape: cf-one-required
target-arrowhead.shape: cf-one-required
}
"WORKSHOP_SESSION"."id" -> "WORKSHOP_PARTICIPANT"."workshop_session_id": {
source-arrowhead.shape: cf-one-required
target-arrowhead.shape: cf-many
}
Hold "Alt" / "Option" to enable pan & zoom