Data model

"ALAN_PAYMENT_CARD_PROFILE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "app_id": VARCHAR(255) 
  "app_user_id": VARCHAR(255) 
  "provisioning_push_notification_sent_at": DATETIME 
}
"ALAN_PAYMENT_CARD_RECOVERY_SESSION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "freeze_date": DATE 
  "recovery_date": DATE 
  "recovery_period_end_date": DATE 
  "recovery_period_start_date": DATE 
}
"ALAN_PAYMENT_CARD_RECOVERY_DEBT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "alan_payment_card_profile_id": UUID 
  "alan_payment_card_recovery_session_id": UUID 
  "bank_transfer_id": UUID 
  "recovered_amount": INTEGER 
  "refunded_amount": INTEGER 
  "status": VARCHAR(255) 
}
"ALAN_PAYMENT_CARD_BALANCE_TRANSACTION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "alan_payment_card_profile_id": UUID 
  "alan_payment_card_recovery_debt_id": UUID 
  "amount": INTEGER 
  "bank_transfer_id": UUID 
  "card_payment_id": UUID 
  "event_type": VARCHAR(255) 
  "external_transaction_id": VARCHAR(255) 
  "push_notification_sent_at": DATETIME 
  "transaction_date": DATETIME 
}
"ALAN_PAYMENT_CARD_PROFILE_HISTORY" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "alan_payment_card_profile_id": UUID 
  "concept": VARCHAR(255) 
  "concept_reference_id": VARCHAR(255) 
  "end_date": DATE 
  "start_date": DATE 
}
"ALAN_PAYMENT_CARD_RECOVERY_SESSION"."id" -> "ALAN_PAYMENT_CARD_RECOVERY_DEBT"."alan_payment_card_recovery_session_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"ALAN_PAYMENT_CARD_PROFILE"."id" -> "ALAN_PAYMENT_CARD_RECOVERY_DEBT"."alan_payment_card_profile_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"ALAN_PAYMENT_CARD_PROFILE"."id" -> "ALAN_PAYMENT_CARD_BALANCE_TRANSACTION"."alan_payment_card_profile_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"ALAN_PAYMENT_CARD_RECOVERY_DEBT"."id" -> "ALAN_PAYMENT_CARD_BALANCE_TRANSACTION"."alan_payment_card_recovery_debt_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"ALAN_PAYMENT_CARD_PROFILE"."id" -> "ALAN_PAYMENT_CARD_PROFILE_HISTORY"."alan_payment_card_profile_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
Hold "Alt" / "Option" to enable pan & zoom