📘

Marketing, Kampagnen & Provisionen

marketing core_platform 🛡️ RLS Protected

Marketing, Kampagnen & Provisionen — aus Code abgeleitete Prozess- und API-Dokumentation.

Fachliche Bestimmung: Plattform- und Basisinfrastruktur: Marketing, Kampagnen & Provisionen — aus Code abgeleitete Prozess- und API-Dokumentation. Erfasst alle zugehörigen Geschäftsdaten, Zustandsmodelle, Automationskaskaden und Schnittstellen zur nahtlosen Einbindung in die unternehmensweiten Wertschöpfungsprozesse.

🧠 Fachprozess-Erzählung & KI-Architektur ⚡ Flussi ta' xogħol u ċikli ta' ħajja (0) ⚙️ Fachprozesse & Capabilities (34) 🗄️ Modelli tad-dejta & Felder (25) 🔌 Punti ta' Bidu (UI & API) (69) 🛡️ Regolatorji u konformità

⚡ Flussi ta' xogħol u ċikli ta' ħajja

Dieses Modul folgt dem standardisierten transaktionalen CRUD- und Event-Lifecycle.

⚙️ Fachprozesse & Capabilities (System-Fachlogik)

Registrierte Fachoperationen und System-Capabilities dieses Moduls zur Steuerung von Workflows, Kaskaden und KI-Agenten.

Gesamt: 34 manual_entry: 1 engine: 33

Capability & Schlüssel	Fachliche Bezeichnung	Ausführung / Coverage	Risikostufe & Freigabe	Effekte & Kaskaden
Agent-Einstieg campaign_strategist_agent `agent_entry:campaign_strategist_agent`	Agent-Einstieg campaign_strategist_agent Quelle: `code:module_agent_map`	manual_entry	✓ Auto	Keine Seiteneffekte deklariert
Provision korrigieren `capability:commission.entitlement.adjust` Op: `commission.entitlement.adjust`	Intent: `commission_entitlement_adjust` Quelle: `code:capability_registry`	⚙️ Engine	🔒 Freigabe nötig Risiko: `business_record`	`commission_ledger.adjusted`
Provisionen freigeben `capability:commission.entitlement.approve` Op: `commission.entitlement.approve`	Intent: `commission_entitlement_approve` Quelle: `code:capability_registry`	⚙️ Engine	🔒 Freigabe nötig Risiko: `business_record`	`commission_entitlement.approved`
Auszahlungslauf freigeben `capability:commission.payout.approve` Op: `commission.payout.approve`	Intent: `commission_payout_approve` Quelle: `code:capability_registry`	⚙️ Engine	🔒 Freigabe nötig Risiko: `irreversible`	`commission_payout.invoiced` `invoice.drafted`
Auszahlungslauf bilden `capability:commission.payout.create` Op: `commission.payout.create`	Intent: `commission_payout_create` Quelle: `code:capability_registry`	⚙️ Engine	✓ Auto Risiko: `business_record`	`commission_payout.created`
Provisionsregel simulieren `capability:commission.rule.evaluate` Op: `commission.rule.evaluate`	Intent: `commission_rule_evaluate` Quelle: `code:capability_registry`	⚙️ Engine	✓ Auto Risiko: `read_only`	Keine Seiteneffekte deklariert
Provisionsregel versionieren `capability:commission.rule.version` Op: `commission.rule.version`	Intent: `commission_rule_version` Quelle: `code:capability_registry`	⚙️ Engine	🔒 Freigabe nötig Risiko: `metadata`	`commission_rule.versioned`
Zielgruppe auswerten `capability:marketing.audience.evaluate` Op: `marketing.audience.evaluate`	Intent: `marketing_audience_evaluate` Quelle: `code:capability_registry`	⚙️ Engine	✓ Auto Risiko: `metadata`	`marketing_audience.evaluated`
Zielgruppe exportieren `capability:marketing.audience.export` Op: `marketing.audience.export`	Intent: `marketing_audience_export` Quelle: `code:capability_registry`	⚙️ Engine	🔒 Freigabe nötig Risiko: `external_effect`	`marketing_audience.exported`
Budget prüfen `capability:marketing.budget.alert` Op: `marketing.budget.alert`	Intent: `marketing_budget_alert` Quelle: `code:capability_registry`	⚙️ Engine	✓ Auto Risiko: `metadata`	`marketing_alert.raised`
Budgetprognose `capability:marketing.budget.forecast` Op: `marketing.budget.forecast`	Intent: `marketing_budget_forecast` Quelle: `code:capability_registry`	⚙️ Engine	✓ Auto Risiko: `read_only`	Keine Seiteneffekte deklariert
Kampagne aktivieren `capability:marketing.campaign.activate` Op: `marketing.campaign.activate`	Intent: `marketing_campaign_activate` Quelle: `code:capability_registry`	⚙️ Engine	🔒 Freigabe nötig Risiko: `business_record`	`marketing_campaign.activated`
Kampagne freigeben `capability:marketing.campaign.approve` Op: `marketing.campaign.approve`	Intent: `marketing_campaign_approve` Quelle: `code:capability_registry`	⚙️ Engine	🔒 Freigabe nötig Risiko: `business_record`	`marketing_campaign.approved`
Kampagne beenden `capability:marketing.campaign.complete` Op: `marketing.campaign.complete`	Intent: `marketing_campaign_complete` Quelle: `code:capability_registry`	⚙️ Engine	✓ Auto Risiko: `business_record`	`marketing_campaign.completed`
Kampagne anlegen `capability:marketing.campaign.create` Op: `marketing.campaign.create`	Intent: `marketing_campaign_create` Quelle: `code:capability_registry`	⚙️ Engine	✓ Auto Risiko: `business_record`	`marketing_campaign.created`
Kampagne aus Branchenvorlage `capability:marketing.campaign.instantiate_template` Op: `marketing.campaign.instantiate_template`	Intent: `marketing_campaign_instantiate_template` Quelle: `code:capability_registry`	⚙️ Engine	✓ Auto Risiko: `business_record`	`marketing_campaign.created`
Kampagne pausieren `capability:marketing.campaign.pause` Op: `marketing.campaign.pause`	Intent: `marketing_campaign_pause` Quelle: `code:capability_registry`	⚙️ Engine	✓ Auto Risiko: `business_record`	`marketing_campaign.paused`
Kampagnen-Kennzahlen `capability:marketing.campaign.report` Op: `marketing.campaign.report`	Intent: `marketing_campaign_report` Quelle: `code:capability_registry`	⚙️ Engine	✓ Auto Risiko: `read_only`	Keine Seiteneffekte deklariert
Kampagne zur Freigabe einreichen `capability:marketing.campaign.submit` Op: `marketing.campaign.submit`	Intent: `marketing_campaign_submit` Quelle: `code:capability_registry`	⚙️ Engine	✓ Auto Risiko: `business_record`	`marketing_campaign.submitted`
Prüffall entscheiden `capability:marketing.fraud.resolve` Op: `marketing.fraud.resolve`	Intent: `marketing_fraud_resolve` Quelle: `code:capability_registry`	⚙️ Engine	🔒 Freigabe nötig Risiko: `business_record`	`marketing_fraud_case.resolved`
Journey starten `capability:marketing.journey.execute` Op: `marketing.journey.execute`	Intent: `marketing_journey_execute` Quelle: `code:capability_registry`	⚙️ Engine	🔒 Freigabe nötig Risiko: `business_record`	`marketing_journey.started`
Journeys stoppen `capability:marketing.journey.stop` Op: `marketing.journey.stop`	Intent: `marketing_journey_stop` Quelle: `code:capability_registry`	⚙️ Engine	✓ Auto Risiko: `business_record`	`marketing_journey.stopped`
Lead erfassen `capability:marketing.lead.capture` Op: `marketing.lead.capture`	Intent: `marketing_lead_capture` Quelle: `code:capability_registry`	⚙️ Engine	✓ Auto Risiko: `business_record`	`crm_lead.created` `marketing_touchpoint.recorded`
Lead qualifizieren `capability:marketing.lead.qualify` Op: `marketing.lead.qualify`	Intent: `marketing_lead_qualify` Quelle: `code:capability_registry`	⚙️ Engine	✓ Auto Risiko: `metadata`	`marketing_lead.qualified`
Lead zuweisen `capability:marketing.lead.route` Op: `marketing.lead.route`	Intent: `marketing_lead_route` Quelle: `code:capability_registry`	⚙️ Engine	✓ Auto Risiko: `business_record`	`marketing_lead.routed`
Partner anlegen `capability:marketing.partner.create` Op: `marketing.partner.create`	Intent: `marketing_partner_create` Quelle: `code:capability_registry`	⚙️ Engine	✓ Auto Risiko: `business_record`	`marketing_partner.created`
Partnerstatus ändern `capability:marketing.partner.transition` Op: `marketing.partner.transition`	Intent: `marketing_partner_transition` Quelle: `code:capability_registry`	⚙️ Engine	🔒 Freigabe nötig Risiko: `business_record`	`marketing_partner.status_changed`
Marketing-Abgleich `capability:marketing.reconciliation.run` Op: `marketing.reconciliation.run`	Intent: `marketing_reconciliation_run` Quelle: `code:capability_registry`	⚙️ Engine	✓ Auto Risiko: `metadata`	`marketing_reconciliation.run`
Attribution neu berechnen `capability:marketing.tracking.attribute` Op: `marketing.tracking.attribute`	Intent: `marketing_tracking_attribute` Quelle: `code:capability_registry`	⚙️ Engine	✓ Auto Risiko: `metadata`	`marketing_attribution.computed`
Tracking-Link erzeugen `capability:marketing.tracking.create_link` Op: `marketing.tracking.create_link`	Intent: `marketing_tracking_create_link` Quelle: `code:capability_registry`	⚙️ Engine	✓ Auto Risiko: `business_record`	`marketing_tracking_link.created`
Conversion als Dublette verwerfen `capability:marketing.tracking.deduplicate` Op: `marketing.tracking.deduplicate`	Intent: `marketing_tracking_deduplicate` Quelle: `code:capability_registry`	⚙️ Engine	🔒 Freigabe nötig Risiko: `business_record`	`marketing_conversion.invalidated`
Tracking-Ereignis übernehmen `capability:marketing.tracking.ingest` Op: `marketing.tracking.ingest`	Intent: `marketing_tracking_ingest` Quelle: `code:capability_registry`	⚙️ Engine	✓ Auto Risiko: `business_record`	`marketing_touchpoint.recorded`
Gutschein einlösen `capability:promotion.code.redeem` Op: `promotion.code.redeem`	Intent: `promotion_code_redeem` Quelle: `code:capability_registry`	⚙️ Engine	✓ Auto Risiko: `business_record`	`marketing_promotion.redeemed`
Gutscheine prüfen `capability:promotion.rule.evaluate` Op: `promotion.rule.evaluate`	Intent: `promotion_rule_evaluate` Quelle: `code:capability_registry`	⚙️ Engine	✓ Auto Risiko: `read_only`	Keine Seiteneffekte deklariert

🧠 Fachprozess-Erzählung & Dual Knowledge Architektur

Synthese aus der ideologischen Blaupause (Meta-Fachlogik / Soll), der faktischen System-Implementierung (System-Fachlogik / Ist) und No-Code Customizing für KI-Consultants.

Dual Knowledge Layer

📖

Der durchgängige Businessprozess im Detail (End-to-End Fließtext-Erzählung)

Der funktionale Ablauf von Marketing, Kampagnen & Provisionen in der Plattform-Architektur

Das Modul marketing erbringt zentrale Infrastruktur- und Steuerungsdienste im Monolithen. Jeder Aufruf durchläuft die zweistufige Sicherheitsarchitektur: Zunächst verifiziert der Session-Guard die Identität des Benutzers, woraufhin die PostgreSQL Row-Level-Security (RLS) aktiviert wird. Dadurch ist garantiert, dass Datenzugriffe mathematisch und physisch ausschließlich auf den authentifizierten tenant_id-Kontext beschränkt bleiben.

Mutationen und administrative Aktionen werden über transaktionale Services ausgeführt. Bei zustandsverändernden Operationen schreibt das System simultan in die betriebliche Zieltabelle und in die transaktionale Outbox. Asynchrone Worker greifen diese Signale ab und kaskadieren Ereignisse an nachgelagerte Module, ohne den synchronen HTTP-Pfad zu blockieren. Jeder Zugriff wird unveränderbar im Audit-Trail protokolliert.

🏛️

Meta-Fachlogik: Ideologische Blaupause, Soll-Weltbild & Normen

Meta-Fachlogik: Sicherheits- und Plattform-Architektur

Basiert auf den Standards ISO/IEC 27001:2022 (Informationssicherheits-Managementsysteme), den BSI IT-Grundschutz-Bausteinen (APP.3.1 Webanwendungen, SYS.1.1 Allgemeiner Server) und Art. 32 DSGVO.

Mandantentrennung als Primärinvariante: Keine Mandantendaten dürfen jemals ohne tenant_id-Filter geladen oder mutiert werden. Das Soll-Modell verlangt die Durchsetzung auf Datenbankebene via PostgreSQL RLS.
Unveränderbarkeit von Sicherheitsereignissen: Protokolldateien, Logins, Berechtigungsänderungen und Konfigurationsmutationen müssen revisionssicher und schreibgeschützt festgeschrieben werden.

⚙️

Systemische Fachlogik: Faktische Umsetzung in Centurio ERP & Capabilities

Systemische Fachlogik: Die faktische Umsetzung von Marketing, Kampagnen & Provisionen

In Centurio ERP wird marketing als modularer Monolith-Baustein unter app.modules.marketing geführt. Die Autorisierung erfolgt über die zentrale RBAC-Engine mit Berechtigungs-Prüfung gegen Rollen und Berechtigungen. Datenänderungen lösen Outbox-Events aus, die über den PostgreSQL events-Bus verteilt werden. Idempotente Requests verhindern Replay-Angriffe und versehentliche Mehrfachausführungen.

🤖

KI-Consultant Leitfaden: Customizing- & No-Code-Konzept (Soll-Ist-Synthese)

AI Solution Architect Blueprint

KI-Consultant Blueprint: Customizing & No-Code Leitfaden für Marketing, Kampagnen & Provisionen

No-Code Datenmodell-Erweiterung: Bei Bedarf können kundenspezifische Zusatzfelder im No-Code Customizing Studio angelegt werden.
Workflow-Integration: Administrative Ereignisse können als Trigger in der Canvas No-Code DAG Engine genutzt werden.
Sicherheitsregeln: Vor kritischen Systemänderungen sind Human-in-the-Loop Freigabegates einzurichten.

📚 Operative Prozessbegriffe & Transaktionsschnittstellen

Zentrale Fachbegriffe im Prozesszusammenhang (Operatives Modell)

Mandantenisolation (RLS)

PostgreSQL Row-Level-Security zur physischen und logischen Trennung aller Kundendaten auf Datenbankebene.

Zweistufige Authentifizierung

Strikte Trennung zwischen globalem Benutzerkonto und mandantenbezogener Rollenzuweisung (RBAC).

Transaktionale Outbox

Entkoppeltes Event-Publishing zur Vermeidung von Distributed-Transaction-Inkonsistenzen.

Revisionssicherer Audit-Trail

Lückenlose Aufzeichnung aller datenverändernden Zugriffe für Compliance und Rechnungsprüfung.

📥 Eingänge & Trigger (Inputs)

Systemaufrufe über REST-API oder Web-Portal
Hintergrund-Worker und Cron-Jobs
Ereignisse über den Outbox-Eventbus

📤 Ausgänge & Arbeitsergebnisse (Outputs)

Ausführungs- und Protokolldaten
Audit-Events im Revisionsjournal
Veränderte Systemzustände

⚡ Kaskaden & Folgeprozesse (Cascades)

security_event -> admin_alert: Alarmierung bei verdächtigen Zugriffen
config_changed -> cache_invalidation: Sofortige Aktualisierung

🛡️ Nebenprozesse & Resilienz

Manuelle Ausnahmebehandlung durch berechtigte Sachbearbeiter
Revisionssichere Protokollierung im Audit-Trail

💡 No-Code Checkliste & Praxistipps

Rollen- und Berechtigungsstufen exakt an Mitarbeiteraufgaben anpassen
Sicherheitsrichtlinien für Passwörter und Sessions aktivieren

🗄️ Modelli tad-dejta & Felder

MarketingAlerts marketing_alerts RLS Aktiv

17 Il-kamps / il-kolla

Tabelle marketing_alerts

Feldname	Tip ta' data	Obbligu	Schlüssel	L-importanza professjonali
`kind`	`VARCHAR(24)`	Ja *	-	Feld kind
`campaign_id`	`UUID`	Nein	FK ➔ marketing_campaigns.id	Feld campaign_id
`message`	`TEXT`	Ja *	-	Feld message
`status`	`VARCHAR(12)`	Ja *	-	Feld status
`idempotency_key`	`VARCHAR(160)`	Ja *	-	Feld idempotency_key
`task_id`	`UUID`	Nein	-	Feld task_id
`acknowledged_by`	`UUID`	Nein	-	Feld acknowledged_by
`acknowledged_at`	`DATETIME`	Nein	-	Feld acknowledged_at
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

MarketingAttributionPolicies marketing_attribution_policies RLS Aktiv

19 Il-kamps / il-kolla

Tabelle marketing_attribution_policies

Feldname	Tip ta' data	Obbligu	Schlüssel	L-importanza professjonali
`key`	`VARCHAR(48)`	Ja *	-	Feld key
`version`	`INTEGER`	Ja *	-	Feld version
`name`	`VARCHAR(255)`	Ja *	-	Feld name
`model`	`VARCHAR(16)`	Ja *	-	Feld model
`window_days`	`INTEGER`	Ja *	-	Feld window_days
`first_weight_pct`	`NUMERIC(5, 2)`	Ja *	-	Feld first_weight_pct
`last_weight_pct`	`NUMERIC(5, 2)`	Ja *	-	Feld last_weight_pct
`half_life_days`	`NUMERIC(6, 2)`	Ja *	-	Feld half_life_days
`include_impressions`	`BOOLEAN`	Ja *	-	Feld include_impressions
`active`	`BOOLEAN`	Ja *	-	Feld active
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

MarketingAttributionResults marketing_attribution_results RLS Aktiv

14 Il-kamps / il-kolla

Tabelle marketing_attribution_results

Feldname	Tip ta' data	Obbligu	Schlüssel	L-importanza professjonali
`conversion_id`	`UUID`	Ja *	FK ➔ marketing_conversions.id	Feld conversion_id
`policy_id`	`UUID`	Ja *	FK ➔ marketing_attribution_policies.id	Feld policy_id
`touchpoint_id`	`UUID`	Ja *	FK ➔ marketing_touchpoints.id	Feld touchpoint_id
`campaign_id`	`UUID`	Nein	-	Feld campaign_id
`channel_id`	`UUID`	Nein	-	Feld channel_id
`partner_id`	`UUID`	Nein	-	Feld partner_id
`weight`	`NUMERIC(9, 6)`	Ja *	-	Feld weight
`credited_amount`	`NUMERIC(14, 2)`	Ja *	-	Feld credited_amount
`currency`	`VARCHAR(3)`	Ja *	-	Feld currency
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

MarketingAudienceMembers marketing_audience_members RLS Aktiv

9 Il-kamps / il-kolla

Tabelle marketing_audience_members

Feldname	Tip ta' data	Obbligu	Schlüssel	L-importanza professjonali
`audience_id`	`UUID`	Ja *	FK ➔ marketing_audiences.id	Feld audience_id
`customer_id`	`UUID`	Ja *	-	Feld customer_id
`evaluated_at`	`DATETIME`	Ja *	-	Feld evaluated_at
`facts`	`JSONB`	Ja *	-	Feld facts
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

MarketingAudiences marketing_audiences RLS Aktiv

16 Il-kamps / il-kolla

Tabelle marketing_audiences

Feldname	Tip ta' data	Obbligu	Schlüssel	L-importanza professjonali
`name`	`VARCHAR(255)`	Ja *	-	Feld name
`purpose`	`VARCHAR(24)`	Ja *	-	Feld purpose
`rules`	`JSONB`	Ja *	-	Feld rules
`exclusions`	`JSONB`	Ja *	-	Feld exclusions
`status`	`VARCHAR(12)`	Ja *	-	Feld status
`member_count`	`INTEGER`	Ja *	-	Feld member_count
`last_evaluated_at`	`DATETIME`	Nein	-	Feld last_evaluated_at
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

MarketingCampaignChannels marketing_campaign_channels RLS Aktiv

20 Il-kamps / il-kolla

Tabelle marketing_campaign_channels

Feldname	Tip ta' data	Obbligu	Schlüssel	L-importanza professjonali
`campaign_id`	`UUID`	Ja *	FK ➔ marketing_campaigns.id	Feld campaign_id
`channel`	`VARCHAR(16)`	Ja *	-	Feld channel
`name`	`VARCHAR(255)`	Ja *	-	Feld name
`budget`	`NUMERIC(14, 2)`	Nein	-	Feld budget
`status`	`VARCHAR(12)`	Ja *	-	Feld status
`external_platform`	`VARCHAR(64)`	Nein	-	Feld external_platform
`external_id`	`VARCHAR(128)`	Nein	-	Feld external_id
`capability_profile`	`JSONB`	Ja *	-	Feld capability_profile
`spend_operation_id`	`UUID`	Nein	-	Feld spend_operation_id
`sync_status`	`VARCHAR(16)`	Ja *	-	Feld sync_status
`last_sync_at`	`DATETIME`	Nein	-	Feld last_sync_at
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

MarketingCampaigns marketing_campaigns RLS Aktiv

36 Il-kamps / il-kolla

Tabelle marketing_campaigns

Feldname	Tip ta' data	Obbligu	Schlüssel	L-importanza professjonali
`code`	`VARCHAR(40)`	Ja *	-	Feld code
`name`	`VARCHAR(255)`	Ja *	-	Feld name
`description`	`TEXT`	Nein	-	Feld description
`parent_id`	`UUID`	Nein	FK ➔ marketing_campaigns.id	Feld parent_id
`goal`	`VARCHAR(16)`	Ja *	-	Feld goal
`status`	`VARCHAR(20)`	Ja *	-	Feld status
`industry_process_key`	`VARCHAR(32)`	Nein	-	Feld industry_process_key
`start_date`	`DATE`	Nein	-	Feld start_date
`end_date`	`DATE`	Nein	-	Feld end_date
`regions`	`JSONB`	Ja *	-	Feld regions
`languages`	`JSONB`	Ja *	-	Feld languages
`product_ids`	`JSONB`	Ja *	-	Feld product_ids
`category_ids`	`JSONB`	Ja *	-	Feld category_ids
`audience_id`	`UUID`	Nein	FK ➔ marketing_audiences.id	Feld audience_id
`owner_id`	`UUID`	Nein	-	Feld owner_id
`budget_total`	`NUMERIC(14, 2)`	Nein	-	Feld budget_total
`budget_daily`	`NUMERIC(14, 2)`	Nein	-	Feld budget_daily
`currency`	`VARCHAR(3)`	Ja *	-	Feld currency
`cost_center`	`VARCHAR(64)`	Nein	-	Feld cost_center
`target_kpis`	`JSONB`	Ja *	-	Feld target_kpis
`external_ids`	`JSONB`	Ja *	-	Feld external_ids
`version`	`INTEGER`	Ja *	-	Feld version
`submitted_by`	`UUID`	Nein	-	Feld submitted_by
`submitted_at`	`DATETIME`	Nein	-	Feld submitted_at
`approved_by`	`UUID`	Nein	-	Feld approved_by
`approved_at`	`DATETIME`	Nein	-	Feld approved_at
`status_reason`	`TEXT`	Nein	-	Feld status_reason
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

MarketingConsentRecords marketing_consent_records RLS Aktiv

15 Il-kamps / il-kolla

Tabelle marketing_consent_records

Feldname	Tip ta' data	Obbligu	Schlüssel	L-importanza professjonali
`subject_type`	`VARCHAR(12)`	Ja *	-	Feld subject_type
`subject_id`	`UUID`	Nein	-	Feld subject_id
`email_hash`	`VARCHAR(64)`	Nein	-	Feld email_hash
`purpose`	`VARCHAR(24)`	Ja *	-	Feld purpose
`action`	`VARCHAR(12)`	Ja *	-	Feld action
`legal_basis`	`VARCHAR(24)`	Ja *	-	Feld legal_basis
`source`	`VARCHAR(16)`	Ja *	-	Feld source
`evidence`	`TEXT`	Nein	-	Feld evidence
`recorded_at`	`DATETIME`	Ja *	-	Feld recorded_at
`recorded_by`	`UUID`	Nein	-	Feld recorded_by
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

MarketingConversions marketing_conversions RLS Aktiv

37 Il-kamps / il-kolla

Tabelle marketing_conversions

Feldname	Tip ta' data	Obbligu	Schlüssel	L-importanza professjonali
`conversion_type`	`VARCHAR(16)`	Ja *	-	Feld conversion_type
`status`	`VARCHAR(24)`	Ja *	-	Feld status
`idempotency_key`	`VARCHAR(160)`	Ja *	-	Feld idempotency_key
`occurred_at`	`DATETIME`	Ja *	-	Feld occurred_at
`source_module`	`VARCHAR(32)`	Ja *	-	Feld source_module
`entity_type`	`VARCHAR(48)`	Nein	-	Feld entity_type
`entity_id`	`UUID`	Nein	-	Feld entity_id
`invoice_id`	`UUID`	Nein	-	Feld invoice_id
`customer_id`	`UUID`	Nein	-	Feld customer_id
`lead_id`	`UUID`	Nein	-	Feld lead_id
`click_id`	`VARCHAR(40)`	Nein	-	Feld click_id
`amount`	`NUMERIC(14, 2)`	Ja *	-	Feld amount
`margin_amount`	`NUMERIC(14, 2)`	Nein	-	Feld margin_amount
`currency`	`VARCHAR(3)`	Ja *	-	Feld currency
`confirmed_amount`	`NUMERIC(14, 2)`	Ja *	-	Feld confirmed_amount
`reversed_amount`	`NUMERIC(14, 2)`	Ja *	-	Feld reversed_amount
`partner_id`	`UUID`	Nein	FK ➔ marketing_partners.id	Feld partner_id
`partner_rule`	`VARCHAR(24)`	Nein	-	Feld partner_rule
`promotion_code_id`	`UUID`	Nein	-	Feld promotion_code_id
`campaign_id`	`UUID`	Nein	FK ➔ marketing_campaigns.id	Feld campaign_id
`product_ids`	`JSONB`	Ja *	-	Feld product_ids
`region`	`VARCHAR(16)`	Nein	-	Feld region
`consent_state`	`VARCHAR(12)`	Ja *	-	Feld consent_state
`validated_at`	`DATETIME`	Nein	-	Feld validated_at
`attributed_at`	`DATETIME`	Nein	-	Feld attributed_at
`financially_confirmed_at`	`DATETIME`	Nein	-	Feld financially_confirmed_at
`reversed_at`	`DATETIME`	Nein	-	Feld reversed_at
`status_reason`	`TEXT`	Nein	-	Feld status_reason
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

MarketingCreatives marketing_creatives RLS Aktiv

26 Il-kamps / il-kolla

Tabelle marketing_creatives

Feldname	Tip ta' data	Obbligu	Schlüssel	L-importanza professjonali
`campaign_id`	`UUID`	Ja *	FK ➔ marketing_campaigns.id	Feld campaign_id
`channel_id`	`UUID`	Nein	FK ➔ marketing_campaign_channels.id	Feld channel_id
`name`	`VARCHAR(255)`	Ja *	-	Feld name
`kind`	`VARCHAR(16)`	Ja *	-	Feld kind
`variant_key`	`VARCHAR(16)`	Nein	-	Feld variant_key
`headline`	`VARCHAR(255)`	Nein	-	Feld headline
`body`	`TEXT`	Nein	-	Feld body
`landing_url`	`VARCHAR(1024)`	Nein	-	Feld landing_url
`document_id`	`UUID`	Nein	-	Feld document_id
`product_id`	`UUID`	Nein	-	Feld product_id
`status`	`VARCHAR(12)`	Ja *	-	Feld status
`version`	`INTEGER`	Ja *	-	Feld version
`approved_by`	`UUID`	Nein	-	Feld approved_by
`approved_at`	`DATETIME`	Nein	-	Feld approved_at
`ai_generated`	`BOOLEAN`	Ja *	-	Feld ai_generated
`ai_confidence`	`NUMERIC(4, 3)`	Nein	-	Feld ai_confidence
`ai_rationale`	`TEXT`	Nein	-	Feld ai_rationale
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

MarketingFraudCases marketing_fraud_cases RLS Aktiv

21 Il-kamps / il-kolla

Tabelle marketing_fraud_cases

Feldname	Tip ta' data	Obbligu	Schlüssel	L-importanza professjonali
`kind`	`VARCHAR(20)`	Ja *	-	Feld kind
`severity`	`VARCHAR(8)`	Ja *	-	Feld severity
`status`	`VARCHAR(12)`	Ja *	-	Feld status
`partner_id`	`UUID`	Nein	FK ➔ marketing_partners.id	Feld partner_id
`link_id`	`UUID`	Nein	FK ➔ marketing_tracking_links.id	Feld link_id
`conversion_id`	`UUID`	Nein	FK ➔ marketing_conversions.id	Feld conversion_id
`lead_id`	`UUID`	Nein	-	Feld lead_id
`evidence`	`JSONB`	Ja *	-	Feld evidence
`idempotency_key`	`VARCHAR(160)`	Ja *	-	Feld idempotency_key
`resolved_by`	`UUID`	Nein	-	Feld resolved_by
`resolved_at`	`DATETIME`	Nein	-	Feld resolved_at
`resolution_note`	`TEXT`	Nein	-	Feld resolution_note
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

MarketingIdentityLinks marketing_identity_links RLS Aktiv

11 Il-kamps / il-kolla

Tabelle marketing_identity_links

Feldname	Tip ta' data	Obbligu	Schlüssel	L-importanza professjonali
`click_id`	`VARCHAR(40)`	Nein	-	Feld click_id
`session_key`	`VARCHAR(64)`	Nein	-	Feld session_key
`lead_id`	`UUID`	Nein	-	Feld lead_id
`customer_id`	`UUID`	Nein	-	Feld customer_id
`method`	`VARCHAR(20)`	Ja *	-	Feld method
`created_by`	`UUID`	Nein	-	Feld created_by
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

MarketingJourneyExecutions marketing_journey_executions RLS Aktiv

19 Il-kamps / il-kolla

Tabelle marketing_journey_executions

Feldname	Tip ta' data	Obbligu	Schlüssel	L-importanza professjonali
`journey_id`	`UUID`	Ja *	FK ➔ marketing_journeys.id	Feld journey_id
`journey_version`	`INTEGER`	Ja *	-	Feld journey_version
`customer_id`	`UUID`	Nein	-	Feld customer_id
`lead_id`	`UUID`	Nein	-	Feld lead_id
`status`	`VARCHAR(12)`	Ja *	-	Feld status
`current_step`	`INTEGER`	Ja *	-	Feld current_step
`next_run_at`	`DATETIME`	Nein	-	Feld next_run_at
`idempotency_key`	`VARCHAR(160)`	Ja *	-	Feld idempotency_key
`log`	`JSONB`	Ja *	-	Feld log
`stop_reason`	`VARCHAR(64)`	Nein	-	Feld stop_reason
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

MarketingJourneys marketing_journeys RLS Aktiv

22 Il-kamps / il-kolla

Tabelle marketing_journeys

Feldname	Tip ta' data	Obbligu	Schlüssel	L-importanza professjonali
`name`	`VARCHAR(255)`	Ja *	-	Feld name
`trigger`	`VARCHAR(24)`	Ja *	-	Feld trigger
`trigger_filter`	`JSONB`	Ja *	-	Feld trigger_filter
`steps`	`JSONB`	Ja *	-	Feld steps
`status`	`VARCHAR(12)`	Ja *	-	Feld status
`version`	`INTEGER`	Ja *	-	Feld version
`campaign_id`	`UUID`	Nein	FK ➔ marketing_campaigns.id	Feld campaign_id
`audience_id`	`UUID`	Nein	FK ➔ marketing_audiences.id	Feld audience_id
`required_consent_purpose`	`VARCHAR(24)`	Nein	-	Feld required_consent_purpose
`frequency_cap_per_7d`	`INTEGER`	Nein	-	Feld frequency_cap_per_7d
`stop_on_conversion`	`BOOLEAN`	Ja *	-	Feld stop_on_conversion
`approved_by`	`UUID`	Nein	-	Feld approved_by
`approved_at`	`DATETIME`	Nein	-	Feld approved_at
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

MarketingLeadProfiles marketing_lead_profiles RLS Aktiv

23 Il-kamps / il-kolla

Tabelle marketing_lead_profiles

Feldname	Tip ta' data	Obbligu	Schlüssel	L-importanza professjonali
`lead_id`	`UUID`	Ja *	FK ➔ crm_leads.id	Feld lead_id
`campaign_id`	`UUID`	Nein	FK ➔ marketing_campaigns.id	Feld campaign_id
`partner_id`	`UUID`	Nein	FK ➔ marketing_partners.id	Feld partner_id
`first_touchpoint_id`	`UUID`	Nein	-	Feld first_touchpoint_id
`capture_channel`	`VARCHAR(16)`	Ja *	-	Feld capture_channel
`lifecycle`	`VARCHAR(16)`	Ja *	-	Feld lifecycle
`score`	`INTEGER`	Ja *	-	Feld score
`score_reasons`	`JSONB`	Ja *	-	Feld score_reasons
`mql_at`	`DATETIME`	Nein	-	Feld mql_at
`sql_at`	`DATETIME`	Nein	-	Feld sql_at
`routed_to`	`UUID`	Nein	-	Feld routed_to
`routed_at`	`DATETIME`	Nein	-	Feld routed_at
`sla_due_at`	`DATETIME`	Nein	-	Feld sla_due_at
`duplicate_count`	`INTEGER`	Ja *	-	Feld duplicate_count
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

MarketingMessageDispatches marketing_message_dispatches RLS Aktiv

15 Il-kamps / il-kolla

Tabelle marketing_message_dispatches

Feldname	Tip ta' data	Obbligu	Schlüssel	L-importanza professjonali
`channel`	`VARCHAR(12)`	Ja *	-	Feld channel
`customer_id`	`UUID`	Nein	-	Feld customer_id
`lead_id`	`UUID`	Nein	-	Feld lead_id
`journey_id`	`UUID`	Nein	-	Feld journey_id
`execution_id`	`UUID`	Nein	-	Feld execution_id
`subject`	`VARCHAR(255)`	Nein	-	Feld subject
`status`	`VARCHAR(12)`	Ja *	-	Feld status
`error`	`VARCHAR(255)`	Nein	-	Feld error
`sent_at`	`DATETIME`	Ja *	-	Feld sent_at
`idempotency_key`	`VARCHAR(160)`	Ja *	-	Feld idempotency_key
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

MarketingPartners marketing_partners RLS Aktiv

26 Il-kamps / il-kolla

Tabelle marketing_partners

Feldname	Tip ta' data	Obbligu	Schlüssel	L-importanza professjonali
`name`	`VARCHAR(255)`	Ja *	-	Feld name
`partner_type`	`VARCHAR(20)`	Ja *	-	Feld partner_type
`status`	`VARCHAR(12)`	Ja *	-	Feld status
`email`	`VARCHAR(320)`	Nein	-	Feld email
`referral_code`	`VARCHAR(32)`	Nein	-	Feld referral_code
`parent_partner_id`	`UUID`	Nein	FK ➔ marketing_partners.id	Feld parent_partner_id
`supplier_id`	`UUID`	Nein	FK ➔ suppliers.id	Feld supplier_id
`customer_id`	`UUID`	Nein	FK ➔ customers.id	Feld customer_id
`sales_agent_id`	`UUID`	Nein	FK ➔ sales_agents.id	Feld sales_agent_id
`contract_id`	`UUID`	Nein	-	Feld contract_id
`employee_user_id`	`UUID`	Nein	-	Feld employee_user_id
`payout_currency`	`VARCHAR(3)`	Ja *	-	Feld payout_currency
`payout_tax_rate`	`NUMERIC(5, 2)`	Nein	-	Feld payout_tax_rate
`verified_at`	`DATETIME`	Nein	-	Feld verified_at
`verified_by`	`UUID`	Nein	-	Feld verified_by
`verification_note`	`TEXT`	Nein	-	Feld verification_note
`status_reason`	`TEXT`	Nein	-	Feld status_reason
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

MarketingPromotionCodes marketing_promotion_codes RLS Aktiv

13 Il-kamps / il-kolla

Tabelle marketing_promotion_codes

Feldname	Tip ta' data	Obbligu	Schlüssel	L-importanza professjonali
`promotion_id`	`UUID`	Ja *	FK ➔ marketing_promotions.id	Feld promotion_id
`code`	`VARCHAR(32)`	Ja *	-	Feld code
`max_redemptions`	`INTEGER`	Nein	-	Feld max_redemptions
`active`	`BOOLEAN`	Ja *	-	Feld active
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

MarketingPromotionRedemptions marketing_promotion_redemptions RLS Aktiv

19 Il-kamps / il-kolla

Tabelle marketing_promotion_redemptions

Feldname	Tip ta' data	Obbligu	Schlüssel	L-importanza professjonali
`promotion_id`	`UUID`	Ja *	FK ➔ marketing_promotions.id	Feld promotion_id
`code_id`	`UUID`	Nein	FK ➔ marketing_promotion_codes.id	Feld code_id
`customer_id`	`UUID`	Nein	-	Feld customer_id
`order_ref`	`VARCHAR(128)`	Ja *	-	Feld order_ref
`order_amount`	`NUMERIC(14, 2)`	Ja *	-	Feld order_amount
`discount_amount`	`NUMERIC(14, 2)`	Ja *	-	Feld discount_amount
`currency`	`VARCHAR(3)`	Ja *	-	Feld currency
`status`	`VARCHAR(12)`	Ja *	-	Feld status
`idempotency_key`	`VARCHAR(160)`	Ja *	-	Feld idempotency_key
`reversed_at`	`DATETIME`	Nein	-	Feld reversed_at
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

MarketingPromotions marketing_promotions RLS Aktiv

28 Il-kamps / il-kolla

Tabelle marketing_promotions

Feldname	Tip ta' data	Obbligu	Schlüssel	L-importanza professjonali
`name`	`VARCHAR(255)`	Ja *	-	Feld name
`campaign_id`	`UUID`	Nein	FK ➔ marketing_campaigns.id	Feld campaign_id
`partner_id`	`UUID`	Nein	FK ➔ marketing_partners.id	Feld partner_id
`kind`	`VARCHAR(16)`	Ja *	-	Feld kind
`value`	`NUMERIC(14, 2)`	Ja *	-	Feld value
`currency`	`VARCHAR(3)`	Ja *	-	Feld currency
`status`	`VARCHAR(12)`	Ja *	-	Feld status
`valid_from`	`DATETIME`	Nein	-	Feld valid_from
`valid_to`	`DATETIME`	Nein	-	Feld valid_to
`min_order_amount`	`NUMERIC(14, 2)`	Nein	-	Feld min_order_amount
`max_discount_amount`	`NUMERIC(14, 2)`	Nein	-	Feld max_discount_amount
`include_product_ids`	`JSONB`	Ja *	-	Feld include_product_ids
`include_category_ids`	`JSONB`	Ja *	-	Feld include_category_ids
`exclude_product_ids`	`JSONB`	Ja *	-	Feld exclude_product_ids
`customer_ids`	`JSONB`	Ja *	-	Feld customer_ids
`combinable`	`BOOLEAN`	Ja *	-	Feld combinable
`priority`	`INTEGER`	Ja *	-	Feld priority
`max_redemptions`	`INTEGER`	Nein	-	Feld max_redemptions
`max_per_customer`	`INTEGER`	Nein	-	Feld max_per_customer
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

MarketingReconciliationRuns marketing_reconciliation_runs RLS Aktiv

14 Il-kamps / il-kolla

Tabelle marketing_reconciliation_runs

Feldname	Tip ta' data	Obbligu	Schlüssel	L-importanza professjonali
`period_start`	`DATE`	Ja *	-	Feld period_start
`period_end`	`DATE`	Ja *	-	Feld period_end
`status`	`VARCHAR(12)`	Ja *	-	Feld status
`results`	`JSONB`	Ja *	-	Feld results
`findings`	`JSONB`	Ja *	-	Feld findings
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

MarketingSettings marketing_settings RLS Aktiv

20 Il-kamps / il-kolla

Tabelle marketing_settings

Feldname	Tip ta' data	Obbligu	Schlüssel	L-importanza professjonali
`default_attribution_policy_id`	`UUID`	Nein	-	Feld default_attribution_policy_id
`click_dedup_seconds`	`INTEGER`	Ja *	-	Feld click_dedup_seconds
`click_burst_threshold`	`INTEGER`	Ja *	-	Feld click_burst_threshold
`budget_alert_percent`	`INTEGER`	Ja *	-	Feld budget_alert_percent
`require_tracking_consent`	`BOOLEAN`	Ja *	-	Feld require_tracking_consent
`mql_score`	`INTEGER`	Ja *	-	Feld mql_score
`sql_score`	`INTEGER`	Ja *	-	Feld sql_score
`lead_sla_hours`	`INTEGER`	Ja *	-	Feld lead_sla_hours
`default_lead_owner_id`	`UUID`	Nein	-	Feld default_lead_owner_id
`frequency_cap_per_7d`	`INTEGER`	Ja *	-	Feld frequency_cap_per_7d
`conversion_window_days`	`INTEGER`	Ja *	-	Feld conversion_window_days
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

MarketingSpend marketing_spend RLS Aktiv

21 Il-kamps / il-kolla

Tabelle marketing_spend

Feldname	Tip ta' data	Obbligu	Schlüssel	L-importanza professjonali
`campaign_id`	`UUID`	Ja *	FK ➔ marketing_campaigns.id	Feld campaign_id
`channel_id`	`UUID`	Nein	FK ➔ marketing_campaign_channels.id	Feld channel_id
`spend_date`	`DATE`	Ja *	-	Feld spend_date
`amount`	`NUMERIC(14, 2)`	Ja *	-	Feld amount
`currency`	`VARCHAR(3)`	Ja *	-	Feld currency
`impressions`	`INTEGER`	Ja *	-	Feld impressions
`clicks`	`INTEGER`	Ja *	-	Feld clicks
`platform_conversions`	`INTEGER`	Ja *	-	Feld platform_conversions
`platform_conversion_value`	`NUMERIC(14, 2)`	Ja *	-	Feld platform_conversion_value
`source`	`VARCHAR(16)`	Ja *	-	Feld source
`external_key`	`VARCHAR(128)`	Ja *	-	Feld external_key
`invoice_id`	`UUID`	Nein	-	Feld invoice_id
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

MarketingTouchpoints marketing_touchpoints RLS Aktiv

28 Il-kamps / il-kolla

Tabelle marketing_touchpoints

Feldname	Tip ta' data	Obbligu	Schlüssel	L-importanza professjonali
`event_type`	`VARCHAR(16)`	Ja *	-	Feld event_type
`schema_version`	`INTEGER`	Ja *	-	Feld schema_version
`occurred_at`	`DATETIME`	Ja *	-	Feld occurred_at
`source`	`VARCHAR(12)`	Ja *	-	Feld source
`idempotency_key`	`VARCHAR(160)`	Ja *	-	Feld idempotency_key
`campaign_id`	`UUID`	Nein	FK ➔ marketing_campaigns.id	Feld campaign_id
`channel_id`	`UUID`	Nein	FK ➔ marketing_campaign_channels.id	Feld channel_id
`link_id`	`UUID`	Nein	FK ➔ marketing_tracking_links.id	Feld link_id
`creative_id`	`UUID`	Nein	FK ➔ marketing_creatives.id	Feld creative_id
`partner_id`	`UUID`	Nein	FK ➔ marketing_partners.id	Feld partner_id
`click_id`	`VARCHAR(40)`	Nein	-	Feld click_id
`session_key`	`VARCHAR(64)`	Nein	-	Feld session_key
`lead_id`	`UUID`	Nein	-	Feld lead_id
`customer_id`	`UUID`	Nein	-	Feld customer_id
`entity_type`	`VARCHAR(48)`	Nein	-	Feld entity_type
`entity_id`	`UUID`	Nein	-	Feld entity_id
`amount`	`NUMERIC(14, 2)`	Nein	-	Feld amount
`currency`	`VARCHAR(3)`	Nein	-	Feld currency
`consent_state`	`VARCHAR(12)`	Ja *	-	Feld consent_state
`consent_reference`	`VARCHAR(128)`	Nein	-	Feld consent_reference
`bot_suspected`	`BOOLEAN`	Ja *	-	Feld bot_suspected
`duplicate_of_id`	`UUID`	Nein	-	Feld duplicate_of_id
`props`	`JSONB`	Ja *	-	Feld props
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

MarketingTrackingLinks marketing_tracking_links RLS Aktiv

23 Il-kamps / il-kolla

Tabelle marketing_tracking_links

Feldname	Tip ta' data	Obbligu	Schlüssel	L-importanza professjonali
`code`	`VARCHAR(16)`	Ja *	-	Feld code
`label`	`VARCHAR(255)`	Nein	-	Feld label
`campaign_id`	`UUID`	Ja *	FK ➔ marketing_campaigns.id	Feld campaign_id
`channel_id`	`UUID`	Nein	FK ➔ marketing_campaign_channels.id	Feld channel_id
`creative_id`	`UUID`	Nein	FK ➔ marketing_creatives.id	Feld creative_id
`partner_id`	`UUID`	Nein	FK ➔ marketing_partners.id	Feld partner_id
`target_url`	`VARCHAR(1024)`	Ja *	-	Feld target_url
`utm_source`	`VARCHAR(128)`	Nein	-	Feld utm_source
`utm_medium`	`VARCHAR(128)`	Nein	-	Feld utm_medium
`utm_campaign`	`VARCHAR(128)`	Nein	-	Feld utm_campaign
`utm_content`	`VARCHAR(128)`	Nein	-	Feld utm_content
`utm_term`	`VARCHAR(128)`	Nein	-	Feld utm_term
`active`	`BOOLEAN`	Ja *	-	Feld active
`expires_at`	`DATETIME`	Nein	-	Feld expires_at
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

🔌 Punti ta' Bidu (UI & API)

Art	Il-metodu	Punti ta ' tmiem / pjaċċ	Titel & Zweck	L-eżenzjoni
⚡ REST API	GET	`/api/v1/marketing/agreements`	list_agreements Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/api/v1/marketing/attribution-policies`	list_policies Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/api/v1/marketing/audiences`	list_audiences Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/api/v1/marketing/campaigns`	list_campaigns Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/api/v1/marketing/campaigns/{campaign_id}`	get_campaign Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/api/v1/marketing/campaigns/{campaign_id}/kpis`	campaign_kpis Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/api/v1/marketing/consents`	consent_history Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/api/v1/marketing/conversions`	list_conversions Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/api/v1/marketing/entitlements`	list_entitlements Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/api/v1/marketing/entitlements/{entitlement_id}/explain`	explain_entitlement Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/api/v1/marketing/fraud-cases`	list_fraud Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/api/v1/marketing/journeys`	list_journeys Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/api/v1/marketing/leads/{lead_id}/profile`	lead_profile Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/api/v1/marketing/links`	list_links Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/api/v1/marketing/overview`	ħarsa ġenerali Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/api/v1/marketing/partners`	list_partners Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/api/v1/marketing/partners/{partner_id}/statement`	partner_statement Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/api/v1/marketing/payouts`	list_payouts Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/api/v1/marketing/promotions`	list_promotions Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/api/v1/marketing/settings`	get_settings Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/api/v1/marketing/templates`	templates Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	PATCH	`/api/v1/marketing/campaigns/{campaign_id}`	patch_campaign Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	PATCH	`/api/v1/marketing/partners/{partner_id}`	patch_partner Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/agreements`	create_agreement Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/agreements/{agreement_id}/activate`	activate_agreement Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/agreements/{agreement_id}/rules`	add_rule Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/alerts/{alert_id}/acknowledge`	acknowledge_alert Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/attribution-policies`	save_policy Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/audiences`	save_audience Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/audiences/{audience_id}/evaluate`	evaluate_audience Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/audiences/{audience_id}/export`	export_audience Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/campaigns`	create_campaign Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/campaigns/from-template`	campaign_from_template Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/campaigns/{campaign_id}/channels`	add_channel Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/campaigns/{campaign_id}/creatives`	add_creative Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/campaigns/{campaign_id}/transition`	transition_campaign Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/consents`	record_consent Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/conversions/{conversion_id}/attribute`	attribute_conversion Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/conversions/{conversion_id}/invalidate`	invalidate_conversion Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/creatives/{creative_id}/review`	review_creative Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/entitlements/approve`	approve_entitlements Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/entitlements/{entitlement_id}/adjust`	adjust_entitlement Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/entitlements/{entitlement_id}/dispute`	dispute_entitlement Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/entitlements/{entitlement_id}/reject`	reject_entitlement Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/events`	ingest_events Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/fraud-cases/{case_id}/resolve`	resolve_fraud Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/journeys`	save_journey Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/journeys/{journey_id}/start`	journey_start Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/journeys/{journey_id}/status`	journey_status Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/leads`	capture_lead Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/leads/{lead_id}/qualify`	qualify_lead Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/leads/{lead_id}/route`	route_lead Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/links`	create_link Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/links/{link_id}/deactivate`	deactivate_link Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/partners`	create_partner Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/partners/{partner_id}/transition`	transition_partner Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/payouts`	create_payout Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/payouts/{batch_id}/approve`	approve_payout Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/payouts/{batch_id}/cancel`	cancel_payout Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/promotions`	create_promotion Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/promotions/evaluate`	evaluate_promotions Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/promotions/redeem`	redeem_promotions Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/promotions/{promotion_id}/codes`	add_codes Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/promotions/{promotion_id}/status`	promotion_status Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/reconciliation`	reconcile Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/rules/simulate`	simulate_rule Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/spend`	import_spend Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/spend/csv`	import_spend_csv Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	PUT	`/api/v1/marketing/settings`	put_settings Semantic binding: operator_surface; mutation=True	`marketing`

🛡️ Regolatorji u konformità

Dieses Modul unterliegt folgenden gesetzlichen, regulatorischen und Revisionsstandards:

L-impriża għandha tinvestiga l-impriża.
Il-konnessjoni tal-konnessjoni