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