Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | bigserial | 19 | √ | nextval('application_reviews_id_seq'::regclass) |
|
|
|||||
| modified_time | timestamptz | 35,6 | √ | now() |
|
|
Tilan muutoksen ajankohta. |
||||
| state | varchar | 40 | √ | null |
|
|
Onko hakemus aktiivinen vai passiivinen. Muut tilat eivät käytössä. |
||||
| application_key | varchar | 40 | √ | null |
|
|
Hakemuksen tunniste. |
||||
| score | numeric | 0 | √ | null |
|
|
Hakemuksen pisteet. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| application_reviews_pkey | Primary key | Asc | id |
| application_reviews_application_key | Must be unique | Asc | application_key |
| application_reviews_state_idx | Performance | Asc | state |
Relationships
Close relationships within degrees of separation
