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