Data model
"INCOME" {
shape: sql_table
"id": UUID {constraint: primary_key}
"end_month": DATE
"monthly_income": INTEGER
"start_month": DATE
"user_ref": VARCHAR(255)
"version": INTEGER
}
"INCOME_DECLARATION" {
shape: sql_table
"id": UUID {constraint: primary_key}
"affiliation_start_date": DATE
"declaration_type": VARCHAR(255)
"invalidation_reason": VARCHAR(255)
"max_declared_monthly_income": INTEGER
"max_effective_monthly_income": INTEGER
"member_type": VARCHAR(255)
"min_declared_monthly_income": INTEGER
"min_effective_monthly_income": INTEGER
"monthly_income_brackets_min_edges": ARRAY
"proof_requested_on_date": DATE
"status": VARCHAR(255)
"submission_date": DATE
"subscription_id": VARCHAR(255)
"user_ref": VARCHAR(255)
"validated_on_date": DATE
}
"INCOME_SOURCE" {
shape: sql_table
"id": UUID {constraint: primary_key}
"end_month": DATE
"income_declaration_id": UUID
"monthly_income": INTEGER
"source_ref": VARCHAR(255)
"source_type": VARCHAR(255)
"start_month": DATE
"submission_date": DATE
"user_ref": VARCHAR(255)
}
"INCOME_DECLARATION"."id" -> "INCOME_SOURCE"."income_declaration_id": {
source-arrowhead.shape: cf-one
target-arrowhead.shape: cf-many
}
Hold "Alt" / "Option" to enable pan & zoom