Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
examiner_id | int8 | 19 | √ | null |
|
|
|||||||||||
version | int4 | 10 | 0 |
|
|
||||||||||||
created_by | text | 2147483647 | √ | null |
|
|
|||||||||||
modified_by | text | 2147483647 | √ | null |
|
|
|||||||||||
deleted_by | text | 2147483647 | √ | null |
|
|
|||||||||||
created_at | timestamptz | 35,6 | now() |
|
|
||||||||||||
modified_at | timestamptz | 35,6 | now() |
|
|
||||||||||||
deleted_at | timestamptz | 35,6 | √ | null |
|
|
|||||||||||
oid | varchar | 255 | null |
|
|
||||||||||||
varchar | 255 | null |
|
|
|||||||||||||
phone_number | varchar | 255 | √ | null |
|
|
|||||||||||
last_name | text | 2147483647 | null |
|
|
||||||||||||
first_name | text | 2147483647 | null |
|
|
||||||||||||
nickname | text | 2147483647 | null |
|
|
||||||||||||
exam_language_finnish | bool | 1 | null |
|
|
||||||||||||
exam_language_swedish | bool | 1 | null |
|
|
||||||||||||
is_public | bool | 1 | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
examiner_pkey | Primary key | Asc | examiner_id |
examiner_oid_uniq_idx | Must be unique | Asc | oid |