Skip to content

Instantly share code, notes, and snippets.

@francois
Last active July 23, 2019 20:14
Show Gist options
  • Save francois/91b877c175eca80f34b1c19074f5d5df to your computer and use it in GitHub Desktop.
Save francois/91b877c175eca80f34b1c19074f5d5df to your computer and use it in GitHub Desktop.
Table "public.stops"
Column | Type | Collation | Nullable | Default
--------------------------------+-----------------------------+-----------+----------+-----------------------------------
id | integer | | not null | nextval('stops_id_seq'::regclass)
order | integer | | not null | 1
stop_type_id | integer | | not null |
bus_route_id | integer | | not null |
location_id | integer | | |
delay_in_seconds | integer | | not null | 0
duration_in_seconds | integer | | not null | 0
distance_in_km | integer | | not null | 0
arrival_time | timestamp without time zone | | |
departure_time | timestamp without time zone | | |
expected_arrival_time | timestamp without time zone | | |
expected_departure_time | timestamp without time zone | | |
description | text | | |
created_at | timestamp without time zone | | |
updated_at | timestamp without time zone | | |
duration_in_traffic_in_seconds | integer | | not null | 0
duration_extra_in_seconds | integer | | not null | 0
tickets_paid_at_departure | integer | | not null | 0
state | character varying | | not null | 'offline'::character varying
group | integer | | not null | 1
type | character varying | | |
# FAILS
xxx | text | | |
yyy | text | | |
# does not fail
xxx | text | | |
# does not fail
xxx | integer | | |
yyy | integer | | |
# does not fail
xxx | character(1) | | |
yyy | character(1) | | |
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment