Table

purchases

Each row represents a commerce purchase with amounts, tax, discounts, success/failure, user, and product context.

Redshift

Each row represents a commerce purchase with amounts, tax, discounts, success/failure, user, and product context.

Full schema

No, this table does not include a statusgroup column.

Column	Type
`analyticsversion`	int4
`companyid`	varchar(36)
`id`	varchar(36)
`amountcharged`	numeric(14,2)
`amountdiscounted`	numeric(14,2)
`amountdisputed`	numeric(14,2)
`amounttaxed`	numeric(14,2)
`amountnet`	numeric(14,2)
`attempt`	int4
`coupon`	varchar(255)
`createdat`	timestamp
`failurecode`	varchar(255)
`failuremessage`	varchar(255)
`giftrecipientemail`	varchar(255)
`groupid`	varchar(32)
`info`	varchar(255)
`orderid`	varchar(36)
`processed`	bool
`processeddispute`	numeric(14,2)
`processeddisputedpurchase`	numeric(12,4)
`processedexpansion`	numeric(14,2)
`processedexpansionpurchase`	numeric(12,4)
`processednew`	numeric(14,2)
`processednewpurchase`	numeric(12,4)
`processedrefund`	numeric(14,2)
`processedrefundedpurchase`	numeric(12,4)
`purchaserevenuetype`	varchar(16)
`purchaseid`	varchar(36)
`courseid`	varchar(36)
`purchasetype`	varchar(32)
`quantity`	int4
`referrer`	varchar(64)
`referrertype`	varchar(64)
`source`	varchar(64)
`success`	bool
`type`	varchar(16)
`userid`	varchar(36)
`variation`	varchar(64)
`updatedat`	timestamp
`isbulkpurchase`	bool

Column names and types come from the Redshift analytics schema. SchemaSpy is authoritative for nullability, defaults, keys, and relationships.

select
  t.analyticsversion,
  t.amountcharged,
  t.amountdiscounted,
  t.amountdisputed,
  t.amounttaxed
from purchases as t
limit 100