Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| analyticsversion | int4 | 10 | √ | null |
|
|
The analyticsversion of the Purchase |
||||
| companyid | varchar | 36 | √ | null |
|
|
The ID of the learning site |
||||
| id | varchar | 36 | null |
|
|
Unique Identifier of the Purchase |
|||||
| amountcharged | numeric | 14,2 | √ | null |
|
|
The amountcharged of the Purchase |
||||
| amountdiscounted | numeric | 14,2 | √ | null |
|
|
The amountdiscounted of the Purchase |
||||
| amountdisputed | numeric | 14,2 | √ | null |
|
|
The amountdisputed of the Purchase |
||||
| amounttaxed | numeric | 14,2 | √ | null |
|
|
The amounttaxed of the Purchase |
||||
| amountnet | numeric | 14,2 | √ | null |
|
|
The amountnet of the Purchase |
||||
| attempt | int4 | 10 | √ | null |
|
|
The attempt of the Purchase |
||||
| coupon | varchar | 255 | √ | null |
|
|
The coupon of the Purchase |
||||
| createdat | timestamp | 29,6 | √ | null |
|
|
The date and time the Purchase was created |
||||
| failurecode | varchar | 255 | √ | null |
|
|
The failurecode of the Purchase |
||||
| failuremessage | varchar | 255 | √ | null |
|
|
The failuremessage of the Purchase |
||||
| giftrecipientemail | varchar | 255 | √ | null |
|
|
The giftrecipientemail of the Purchase |
||||
| groupid | varchar | 32 | √ | null |
|
|
The groupid of the Purchase |
||||
| info | varchar | 255 | √ | null |
|
|
The info of the Purchase |
||||
| orderid | varchar | 36 | √ | null |
|
|
The orderid of the Purchase |
||||
| processed | bool | 1 | √ | true |
|
|
The processed of the Purchase |
||||
| processeddispute | numeric | 14,2 | √ | null |
|
|
The processeddispute of the Purchase |
||||
| processeddisputedpurchase | numeric | 12,4 | √ | null |
|
|
The processeddisputedpurchase of the Purchase |
||||
| processedexpansion | numeric | 14,2 | √ | null |
|
|
The processedexpansion of the Purchase |
||||
| processedexpansionpurchase | numeric | 12,4 | √ | null |
|
|
The processedexpansionpurchase of the Purchase |
||||
| processednew | numeric | 14,2 | √ | null |
|
|
The processednew of the Purchase |
||||
| processednewpurchase | numeric | 12,4 | √ | null |
|
|
The processednewpurchase of the Purchase |
||||
| processedrefund | numeric | 14,2 | √ | null |
|
|
The processedrefund of the Purchase |
||||
| processedrefundedpurchase | numeric | 12,4 | √ | null |
|
|
The processedrefundedpurchase of the Purchase |
||||
| purchaserevenuetype | varchar | 16 | √ | null |
|
|
The purchaserevenuetype of the Purchase |
||||
| purchaseid | varchar | 36 | √ | null |
|
|
The purchaseid of the Purchase |
||||
| courseid | varchar | 36 | √ | null |
|
|
The courseid of the Purchase |
||||
| purchasetype | varchar | 32 | √ | null |
|
|
The purchasetype of the Purchase |
||||
| quantity | int4 | 10 | √ | null |
|
|
The quantity of the Purchase |
||||
| referrer | varchar | 64 | √ | null |
|
|
The referrer of the Purchase |
||||
| referrertype | varchar | 64 | √ | null |
|
|
The referrertype of the Purchase |
||||
| source | varchar | 64 | √ | null |
|
|
The source of the Purchase |
||||
| success | bool | 1 | √ | true |
|
|
The succes of the Purchase |
||||
| type | varchar | 16 | √ | null |
|
|
The type of the Purchase |
||||
| userid | varchar | 36 | √ | null |
|
|
The userid of the Purchase |
||||
| variation | varchar | 64 | √ | null |
|
|
The variation of the Purchase |
||||
| updatedat | timestamp | 29,6 | √ | ('now'::text)::timestamp with time zone |
|
|
The date and time the Purchase was created |
||||
| isbulkpurchase | bool | 1 | √ | false |
|
|
Relationships
Close relationships within degrees of separation
