Skip to content

Instantly share code, notes, and snippets.

@apinstein

apinstein/tour_event def

Created November 7, 2015 02:30
Show Gist options
  • Save apinstein/a8bf773929a7fc6d387b to your computer and use it in GitHub Desktop.
Save apinstein/a8bf773929a7fc6d387b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
tour_event def
virtualtour=> \d+ tour_event
Table "public.tour_event"
Column | Type | Modifiers | Storage | Stats target | Description
--------------------+-----------------------------+-----------------------------------------------------------------------------------+----------+--------------+-------------
tour_event_id | integer | not null default nextval(('public.tour_event_tour_event_id_seq'::text)::regclass) | plain | |
tour_event_type_id | integer | not null | plain | |
tour_id | integer | not null | plain | |
visitor_id | text | | extended | |
dts | timestamp without time zone | not null default now() | plain | |
custom | text | | extended | |
Indexes:
"tour_event_pkey" PRIMARY KEY, btree (tour_event_id)
"tour_event_tour_id_idx" btree (tour_id) CLUSTER
Foreign-key constraints:
"tour_event_tour_event_type_id_fkey" FOREIGN KEY (tour_event_type_id) REFERENCES tour_event_type(tour_event_type_id) ON DELETE RESTRICT
"tour_event_tour_id_fkey" FOREIGN KEY (tour_id) REFERENCES tour(tour_id) ON DELETE CASCADE
Has OIDs: no
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment