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