Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | serial | 10 | √ | nextval('shared_modules_id_seq'::regclass) |
|
|
|||||
| uuid | 2147483647 | public.gen_random_uuid() |
|
|
|||||||
| tutkinnonosa_module_uuid | uuid | 2147483647 | null |
|
|
||||||
| tutkinnonosa_tyyppi | varchar | 256 | null |
|
|
||||||
| uuid | 2147483647 | null |
|
|
|||||||
| varchar | 256 | null |
|
|
|||||||
| voimassaolo_alku | date | 13 | null |
|
|
||||||
| voimassaolo_loppu | date | 13 | null |
|
|
||||||
| hoks_eid | varchar | 36 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| shared_modules_pkey | Primary key | Asc | id |
| shared_modules_idx | Performance | Asc/Asc | share_id + hoks_eid |
| shared_modules_shared_module_uuid_idx | Performance | Asc | shared_module_uuid |
Relationships
Close relationships within degrees of separation
