Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | bigserial | 19 | √ | nextval('app_marketplace_linkedin_learning_object_id_seq'::regclass) |
|
|
||||
| urn | varchar | 255 | ''::character varying |
|
|
|||||
| title | varchar | 255 | ''::character varying |
|
|
|||||
| description | text | 2147483647 | √ | null |
|
|
||||
| description_include_html | text | 2147483647 | √ | null |
|
|
||||
| short_description | text | 2147483647 | √ | null |
|
|
||||
| locale_language | varchar | 10 | ''::character varying |
|
|
|||||
| locale_country | varchar | 10 | ''::character varying |
|
|
|||||
| last_updated_at | int8 | 19 | null |
|
|
|||||
| published_at | int8 | 19 | null |
|
|
|||||
| retired_at | int8 | 19 | √ | null |
|
|
||||
| level | varchar | 255 | √ | null |
|
|
||||
| primary_image_url | text | 2147483647 | √ | null |
|
|
||||
| time_to_complete | int8 | 19 | √ | null |
|
|
||||
| web_launch_url | text | 2147483647 | √ | null |
|
|
||||
| sso_launch_url | text | 2147483647 | √ | null |
|
|
||||
| asset_type | varchar | 255 | ''::character varying |
|
|
|||||
| availability | varchar | 10 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| app_marklinklearobje_id_pk | Primary key | Asc | id |
| app_marklinklearobje_las_ix | Performance | Asc | last_updated_at |
| app_marklinklearobje_pub_ix | Performance | Asc | published_at |
| app_marklinklearobje_tit_ix | Performance | Asc | title |
| app_marklinklearobje_urn_uix | Must be unique | Asc | urn |
Relationships
Close relationships within degrees of separation
