Skip to content

Instantly share code, notes, and snippets.

@matxpg
Created October 31, 2014 23:12
Show Gist options
  • Save matxpg/1fa711efd48ceeb5493b to your computer and use it in GitHub Desktop.
Save matxpg/1fa711efd48ceeb5493b to your computer and use it in GitHub Desktop.
public | t_volunteer | table | cmpt370_group06
public | t_volunteeravailability | table | cmpt370_group06
INSERT into t_volunteer (vol_emailaddress, vol_firstname, vol_surname, vol_phone)
VALUES (getemail,getfirstname, getlastname, getphone);
------------------+--------------+-----------
vol_emailaddress | emailaddress | not null
vol_firstname | firstname | not null
vol_surname | surname | not null
vol_phone | phone |
vol_password | password | not null
Table "public.t_volunteeravailability"
Column | Type | Modifiers
----------------------------+--------------+-----------
vav_emailaddress_volunteer | emailaddress | not null
vav_availability_start | availability | not null
vav_availability_end | availability | not null
For EACH AVAILABILITY INTERVAL
INSERT into t_volunteeravailability (vav_emailaddress_volunteer, vav_availability_start, vav_availability_end)
VALUES (getEmail, timestamp '2001-09-29 03:00', timestamp '####-##-## ##:##')
where you get the ####-##-## ##:## from the timeinterval start and end
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment