Intermediate_04
Tables (5)
j (Job)
- JobID — Primary key — NOT NULL
- AccountID — Primary key — NOT NULL
- EmailID
- AccountUserID
- FromName
- FromEmail
- SchedTime
- PickupTime
- DeliveredTime
- EventID
- IsMultipart
- JobType
- JobStatus
- ModifiedBy
- ModifiedDate
- EmailName
- EmailSubject
- IsWrapped
- TestEmailAddr
- SendClassification
- Field (TriggererSendDefinitionObjectID)
- Field2 (TriggeredSendCustomerKey)
jn (Journey)
- VersionID — Primary key — NOT NULL
- JourneyID — Primary key — NOT NULL
- JourneyName
- VersionNumber
- CreatedDate
- LastPublishedDate
- ModifiedDate
- JourneyStatus
jna (JourneyActivity)
- VersionID — Foreign key → jn.VersionID — NOT NULL
- ActivityName
- ActivityExternalKey
- JourneyActivityObjectID
- ActivityType
o (Open)
- AccountID — Primary key — NOT NULL
- OYBAccountID — Primary key — NOT NULL
- JobID — Primary key — NOT NULL
- ListID — Primary key — NOT NULL
- SubscriberID
- SubscriberKey
- EventDate
- Domain
- IsUnique
- TriggererSendDefinitionObjectID
- TriggeredSendCustomerKey (Field11)
s (Sent)
- AccountID — Foreign key → o.AccountID — NOT NULL
- OYBAccountID — Foreign key → o.OYBAccountID — NOT NULL
- JobID — Foreign key → o.JobID — NOT NULL
- ListID — Foreign key → o.ListID — NOT NULL
- BatchID
- SubscriberID
- SubscriberKey
- EventDate
- Domain
- TriggererSendDefinitionObjectID
- TriggeredSendCustomerKey