Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| companyid | varchar | 36 | √ | null |
|
|
The ID of the learning site |
||||
| id | varchar | 36 | null |
|
|
Unique Identifier of the Award |
|||||
| awardwhen | varchar | 32 | √ | null |
|
|
The awardwhen of the Award |
||||
| deleted | bool | 1 | √ | false |
|
|
The deleted of the Award |
||||
| userid | varchar | 36 | √ | null |
|
|
The userid of the Award |
||||
| awardamount | float8 | 17,17 | √ | null |
|
|
The awardamount of the Award |
||||
| clientid | varchar | 36 | √ | null |
|
|
The clientid of the Award |
||||
| resourceid | varchar | 36 | √ | null |
|
|
The resource of the Award |
||||
| resourcetype | varchar | 32 | √ | null |
|
|
The resourcetype of the Award |
||||
| idempotencykey | varchar | 36 | √ | null |
|
|
The idempotencykey of the Award |
||||
| createdat | timestamp | 29,6 | √ | ('now'::text)::timestamp with time zone |
|
|
The date and time the Award was created |
||||
| updatedat | timestamp | 29,6 | √ | ('now'::text)::timestamp with time zone |
|
|
The date and time the Award was created |
||||
| rdbgroup | varchar | 100 | √ | null |
|
|
|||||
| awardtypeid | varchar | 36 | √ | null |
|
|
|||||
| statusgroup | varchar | 256 | √ | null |
|
|
|||||
| statusgroupupdatedat | timestamp | 29,6 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
