Table bety.public.inputs |
Legend:
Primary key columns
Indexed columns
Column | Type | Size | Nulls | Auto | Default | References | Comments |
---|---|---|---|---|---|---|---|
id | serial | 10 | χ | √ | nextval('inputs_id_seq'::regclass) | ||
site_id | int4 | 10 | √ | χ | null | sites.id | |
notes | text | 2147483647 | √ | χ | null | ||
created_at | timestamp | 29,6 | √ | χ | null | ||
updated_at | timestamp | 29,6 | √ | χ | null | ||
start_date | timestamp | 29,6 | √ | χ | null | ||
end_date | timestamp | 29,6 | √ | χ | null | ||
name | varchar | 255 | √ | χ | null | ||
parent_id | int4 | 10 | √ | χ | null | inputs.id | |
user_id | int4 | 10 | √ | χ | null | ||
access_level | int4 | 10 | √ | χ | null | ||
raw | bool | 1 | √ | χ | null | ||
format_id | int4 | 10 | √ | χ | null | formats.id | |
file_id | int4 | 10 | √ | χ | null |
Indexes:
Column(s) | Type | Sort | Constraint Name |
---|---|---|---|
id | Primary key | Asc | inputs_pkey |
format_id | Performance | Asc | index_inputs_on_format_id |
parent_id | Performance | Asc | index_inputs_on_parent_id |
site_id | Performance | Asc | index_inputs_on_site_id |
user_id | Performance | Asc | index_inputs_on_user_id |