# Synthetic marketing schema (generated by scripts/gen_schema.py)

# Audience documentation
Audience as aud0
----
AudienceId PK int IDENTITY
OnboardingRef0 int FK -< Onboarding.OnboardingId
DriverRef1 int FK >- Driver.DriverId
Field0Audience date NULL
Field1Audience decimal(10,2) default=0
Field2Audience bool UNIQUE

AudienceMember
---
AudienceMemberId PK int IDENTITY
FeeRef0 int FK >-< Fee.FeeId
Field0AudienceMember date default=4
Field1AudienceMember string INDEX
Field2AudienceMember int
Field3AudienceMember varchar(200) NULL
Field4AudienceMember varchar(200) NULL

Email
----------
EmailId PK int IDENTITY
SalesNoteRef0 int FK -0 SalesNote.SalesNoteId
Field0Email money INDEX
Field1Email string INDEX
Field2Email text
Field3Email bool INDEX
Field4Email bool
"Display Name" string="Unnamed Email"

EmailSend
rel >- Cart
----------
EmailSendId PK int IDENTITY
ReceiptLineRef0 int FK 0- ReceiptLine.ReceiptLineId
OpportunityRef1 int FK 0-0 Opportunity.OpportunityId
Field0EmailSend money INDEX
Field1EmailSend decimal(10,2) UNIQUE
Field2EmailSend bool UNIQUE
Field3EmailSend text NULL
Field4EmailSend date UNIQUE
Field5EmailSend int
Field6EmailSend uuid
Field7EmailSend varchar(200) INDEX
Field8EmailSend int NULL

EmailOpen
---
EmailOpenId PK int IDENTITY
EntityRef0 int FK -0< Entity.EntityId
LedgerRef1 int FK >0- led0.LedgerId
Field0EmailOpen string UNIQUE
Field1EmailOpen string
Field2EmailOpen varchar(200) INDEX
Field3EmailOpen datetime INDEX
Field4EmailOpen string

# EmailClick documentation
"marketing.EmailClick"
---
EmailClickId PK int IDENTITY
PriceListRef0 int FK - PriceList.PriceListId
Field0EmailClick date default=3
Field1EmailClick uuid
Field2EmailClick bool INDEX

LandingPage
---
LandingPageId PK int IDENTITY
RegionRef0 int FK -< "sales.Region".RegionId
Field0LandingPage money
Field1LandingPage string UNIQUE
Field2LandingPage bool NULL
Field3LandingPage money

Visit as vis7
---
VisitId PK int IDENTITY
Field0Visit date default=0
Field1Visit varchar(200) UNIQUE
Field2Visit decimal(10,2) INDEX
Field3Visit date NULL
Field4Visit string NULL
Field5Visit string
Field6Visit money INDEX
Field7Visit bool NULL
Field8Visit datetime NULL

PageView
----
PageViewId PK int IDENTITY
SalesRepRef0 int FK >- SalesRep.SalesRepId
EntityRef1 int FK >-< Entity.EntityId
Field0PageView text default=9
Field1PageView decimal(10,2) UNIQUE
Field2PageView int INDEX
Field3PageView money NULL

Form
----------
FormId PK int IDENTITY
PensionRef0 int FK -0 Pension.PensionId
RegionRef1 int FK 0- "sales.Region".RegionId
Field0Form int UNIQUE
Field1Form varchar(200) default=6
Field2Form money default=5
Field3Form varchar(200)
Field4Form int
Field5Form int NULL
Field6Form int INDEX
Field7Form text
Field8Form text INDEX

# FormSubmission documentation
FormSubmission
----------
FormSubmissionId PK int IDENTITY
Field0FormSubmission text NULL
Field1FormSubmission datetime UNIQUE
Field2FormSubmission string NULL
Field3FormSubmission varchar(200) UNIQUE
Field4FormSubmission money
Field5FormSubmission string
Field6FormSubmission money
Field7FormSubmission decimal(10,2) INDEX
Field8FormSubmission string default=7

Ad
-
AdId PK int IDENTITY
FormSubmissionRef0 int FK 0-0 FormSubmission.FormSubmissionId
Field0Ad string
Field1Ad varchar(200) NULL
Field2Ad uuid default=5

AdGroup
----
AdGroupId PK int IDENTITY
Field0AdGroup varchar(200)
Field1AdGroup string UNIQUE
Field2AdGroup money default=4
Field3AdGroup string
Field4AdGroup date INDEX
Field5AdGroup uuid UNIQUE

AdCampaign
-
AdCampaignId PK int IDENTITY
ContractorRef0 int FK -0< Contractor.ContractorId
Field0AdCampaign bool UNIQUE
Field1AdCampaign string
Field2AdCampaign string

Keyword as key14
rel >- can21
-
KeywordId PK int IDENTITY
Field0Keyword decimal(10,2) INDEX

# Impression documentation
Impression
----
ImpressionId PK int IDENTITY
CampaignRef0 int FK >0- Campaign.CampaignId
Field0Impression int
Field1Impression money UNIQUE
Field2Impression decimal(10,2)

Click
----
ClickId PK int IDENTITY
PriceListRef0 int FK - PriceList.PriceListId
Field0Click string
Field1Click int NULL
Field2Click text INDEX
Field3Click string UNIQUE
Field4Click datetime
Field5Click text

Conversion
----
ConversionId PK int IDENTITY
Field0Conversion date
Field1Conversion date INDEX
Field2Conversion bool INDEX
Field3Conversion decimal(10,2) NULL
Field4Conversion varchar(200) INDEX

"marketing.Attribution"
-
AttributionId PK int IDENTITY
Field0Attribution bool UNIQUE
Field1Attribution int
Field2Attribution datetime NULL
Field3Attribution text INDEX
Field4Attribution uuid NULL
Field5Attribution datetime
Field6Attribution decimal(10,2) INDEX
Field7Attribution bool
Field8Attribution string

UtmSource
---
UtmSourceId PK int IDENTITY
OperationRef0 int FK -< Operation.OperationId
PriceListRef1 int FK >- PriceList.PriceListId
Field0UtmSource money NULL
"Display Name" string="Unnamed UtmSource"

# Content documentation
Content
----
ContentId PK int IDENTITY
ProductRef0 int FK >-< pro0.ProductId
Field0Content bool INDEX
Field1Content datetime
Field2Content decimal(10,2) default=2
Field3Content string
Field4Content varchar(200) INDEX
Field5Content bool
Field6Content text NULL

Asset2 as ass21
----------
Asset2Id PK int IDENTITY
KitItemRef0 int FK -0 KitItem.KitItemId
Field0Asset2 string NULL
Field1Asset2 datetime
Field2Asset2 decimal(10,2) NULL
Field3Asset2 string UNIQUE
Field4Asset2 money

Tag
----
TagId PK int IDENTITY
CurrencyRef0 int FK 0- Currency.CurrencyId
Field0Tag money default=7

ContentTag
---
ContentTagId PK int IDENTITY
Field0ContentTag string
Field1ContentTag int NULL
Field2ContentTag varchar(200) INDEX
Field3ContentTag bool default=1
Field4ContentTag date
Field5ContentTag int NULL
Field6ContentTag uuid
Field7ContentTag bool

Webinar
----------
WebinarId PK int IDENTITY
Field0Webinar date
Field1Webinar money
Field2Webinar money NULL

# Registration documentation
Registration
rel >- BomLine
---
RegistrationId PK int IDENTITY
Field0Registration datetime NULL
Field1Registration int default=9
Field2Registration date
Field3Registration datetime INDEX
Field4Registration text

Event
-
EventId PK int IDENTITY
WorkOrderRef0 int FK 0-0 "inventory.WorkOrder".WorkOrderId
Field0Event money
Field1Event text
Field2Event text INDEX

EventAttendee
----
EventAttendeeId PK int IDENTITY
CourseRef0 int FK -0< Course.CourseId
Field0EventAttendee bool default=9
Field1EventAttendee bool UNIQUE
Field2EventAttendee varchar(200) UNIQUE
Field3EventAttendee date
Field4EventAttendee datetime INDEX
Field5EventAttendee text default=5
Field6EventAttendee decimal(10,2)
Field7EventAttendee decimal(10,2) UNIQUE

Sponsor as spo28
-
SponsorId PK int IDENTITY
Field0Sponsor bool NULL
Field1Sponsor decimal(10,2) UNIQUE
Field2Sponsor bool
Field3Sponsor bool default=9
Field4Sponsor varchar(200) NULL
Field5Sponsor uuid UNIQUE
Field6Sponsor varchar(200)

Influencer
-
InfluencerId PK int IDENTITY
Field0Influencer date
Field1Influencer text
Field2Influencer bool NULL
Field3Influencer varchar(200)

# Post documentation
Post
---
PostId PK int IDENTITY
LeadRef0 int FK >0- Lead.LeadId
Field0Post varchar(200)

"marketing.SocialAccount"
---
SocialAccountId PK int IDENTITY
Field0SocialAccount bool UNIQUE
Field1SocialAccount money
Field2SocialAccount bool UNIQUE
Field3SocialAccount varchar(200)
Field4SocialAccount money
Field5SocialAccount bool
Field6SocialAccount text UNIQUE
Field7SocialAccount decimal(10,2) NULL
Field8SocialAccount money

Mention
----
MentionId PK int IDENTITY
Field0Mention int INDEX
Field1Mention date NULL
Field2Mention date default=5

Experiment
---
ExperimentId PK int IDENTITY
OfferRef0 int FK - Offer.OfferId
PaymentRef1 int FK -< Payment.PaymentId
Field0Experiment varchar(200)
Field1Experiment string UNIQUE
Field2Experiment bool
Field3Experiment string INDEX
Field4Experiment int NULL
Field5Experiment decimal(10,2) UNIQUE
Field6Experiment datetime
Field7Experiment int INDEX

Variant
----------
VariantId PK int IDENTITY
StopRef0 int FK >- Stop.StopId
JournalRef1 int FK >-< Journal.JournalId
Field0Variant uuid UNIQUE
Field1Variant text
Field2Variant uuid
Field3Variant decimal(10,2) INDEX
Field4Variant string UNIQUE
Field5Variant int UNIQUE
Field6Variant string UNIQUE

# Assignment documentation
Assignment as ass35
---
AssignmentId PK int IDENTITY
LedgerEntryRef0 int FK -0 LedgerEntry.LedgerEntryId
Field0Assignment text UNIQUE
Field1Assignment date INDEX

Score
rel >- ass35
-
ScoreId PK int IDENTITY
VisitRef0 int FK 0- vis7.VisitId
Field0Score date NULL
Field1Score int UNIQUE
Field2Score decimal(10,2) INDEX
"Display Name" string="Unnamed Score"

ScoreRule
----
ScoreRuleId PK int IDENTITY
SettlementRef0 int FK 0-0 Settlement.SettlementId
GLGroupRef1 int FK -0< GLGroup.GLGroupId
Field0ScoreRule string INDEX
Field1ScoreRule date INDEX
Field2ScoreRule varchar(200) UNIQUE
Field3ScoreRule int

Persona
----
PersonaId PK int IDENTITY
AudienceRef0 int FK >0- aud0.AudienceId
ManagerRef1 int FK - Manager.ManagerId
Field0Persona decimal(10,2)
Field1Persona decimal(10,2)
Field2Persona datetime INDEX
Field3Persona string INDEX
Field4Persona uuid
Field5Persona datetime
Field6Persona text NULL
Field7Persona bool UNIQUE

Journey
---
JourneyId PK int IDENTITY
ShipmentRef0 int FK -< Shipment.ShipmentId
Field0Journey uuid UNIQUE
Field1Journey decimal(10,2) default=4
Field2Journey int
Field3Journey string
Field4Journey bool INDEX
