| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | varchar(50) | false | ||||
| name | varchar(100) | true | ||||
| description | varchar(500) | true | ||||
| version | varchar(255) | true | ||||
| externalid | varchar(50) | true | ||||
| source | varchar(50) | true | ||||
| enforcecontentorder | boolean | true | ||||
| isarchived | boolean | true | ||||
| ispublished | boolean | true | ||||
| completiontimeindays | integer | true | ||||
| type | varchar(50) | true | ||||
| datecreated | timestamp without time zone | true | ||||
| datemodified | timestamp without time zone | true | ||||
| lengthinminutes | numeric(20,2) | true | ||||
| updated | timestamp without time zone | true |
| Name | Type | Definition |
|---|---|---|
| learningmodule_pkey | PRIMARY KEY | PRIMARY KEY (id) |
| Name | Definition |
|---|---|
| learningmodule_pkey | CREATE UNIQUE INDEX learningmodule_pkey ON public.learningmodules USING btree (id) |