Table definitions

gistfile1.txt

                                          Table "public.events"
       Column        |            Type             |                      Modifiers                      
---------------------+-----------------------------+-----------------------------------------------------
 id                  | integer                     | not null default nextval('events_id_seq'::regclass)
 name                | character varying(255)      | 
 location            | text                        | 
 notes               | text                        | 
 created_at          | timestamp without time zone | not null
 updated_at          | timestamp without time zone | not null
 default_shift_start | timestamp without time zone | 
 default_shift_end   | timestamp without time zone | 

                                          Table "public.shifts"
       Column        |            Type             |                      Modifiers                      
---------------------+-----------------------------+-----------------------------------------------------
 id                  | integer                     | not null default nextval('shifts_id_seq'::regclass)
 event_id            | integer                     | 
 starts_at           | timestamp without time zone | 
 ends_at             | timestamp without time zone | 
 qualification_id    | integer                     | 
 created_at          | timestamp without time zone | not null
 updated_at          | timestamp without time zone | not null
 qualifications_mask | integer                     | 
 open                | boolean                     | not null default true
 using_default       | boolean                     | not null default false