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