Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int8 | 19 | null |
|
|
||||||
| version | int8 | 19 | null |
|
|
||||||
| suhdetyyppi | varchar | 255 | null |
|
|
||||||
| child_id | int8 | 19 | null |
|
|
||||||
| parent_id | int8 | 19 | null |
|
|
||||||
| opetuspisteenjarjnro | varchar | 255 | √ | null |
|
|
|||||
| paivityspvm | date | 13 | √ | ('now'::text)::date |
|
|
|||||
| paivittaja | varchar | 255 | √ | "current_user"() |
|
|
|||||
| alkupvm | date | 13 | √ | null |
|
|
|||||
| loppupvm | date | 13 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| organisaatiosuhde_pkey | Primary key | Asc | id |
| organisaatiosuhde_alkupvm_idx | Performance | Asc | alkupvm |
| organisaatiosuhde_child_id_idx | Performance | Asc | child_id |
| organisaatiosuhde_loppupvm_idx | Performance | Asc | loppupvm |
| organisaatiosuhde_parent_id_idx | Performance | Asc | parent_id |
| organisaatiosuhde_suhdetyyppi_idx | Performance | Asc | suhdetyyppi |
Relationships
Close relationships within degrees of separation
