-
Notifications
You must be signed in to change notification settings - Fork 9
Tables
Max Veytsman edited this page Jan 24, 2022
·
2 revisions
| column_name | description | data_type | is_nullable |
|---|---|---|---|
| id | unique identifier for the task | bigint | NO |
| campaign_id | unique identifier of parent campaign | bigint | YES |
| submitted_on | deprecated. timestamp when task is imported from a google sheet | timestamp without time zone | YES |
| size | deprecated. used to track delivery size, it's always 4 now :( | integer | YES |
| delivery_date | deprecated. For no good reason I hardcoded this to 2020-07-28 for tasks that are imported via sheet :( | date | YES |
| dropoff_location | lat/lon of where the delivery is to be dropped off to. (to be deprecated by a new location field) | USER-DEFINED | YES |
| pickup_location | lat/lon of where the delivery is picked up. Better to look at campaigns.location | USER-DEFINED | YES |
| delivery_distance | straight-line distance between pickup_location and dropoff_location in metres. This is automatically generated by postgres. | integer | YES |
| assigned_rider_id | unique identifier for the rider this task is assigned to (or null if task is unassigned) | bigint | YES |
| dropoff_organization | deprecated. never been used | character varying | YES |
| dropoff_name | name of person being delivered to | character varying | YES |
| dropoff_email | deprecated. never been used? | character varying | YES |
| dropoff_address | address of person being delivered to | character varying | YES |
| dropoff_address2 | deprecated, not used | character varying | YES |
| dropoff_city | city of person being delivered to | character varying | YES |
| dropoff_province | province of person being delivered to | character varying | YES |
| dropoff_postal | postal of person being delivered to | character varying | YES |
| onfleet_dropoff_id | deprecated. used to be used for onfleet integration | character varying | YES |
| rider_notes | notes from dispatchers to the rider (includes unit & buzzer info and delivery instructions) | text | YES |
| delivery_status_notes | notes about the delivery after attempted (things like "person has moved" or "phone is off") | character varying | YES |
| pickup_address | deprecated, stored on the campaign | character varying | YES |
| pickup_address2 | deprecated, stored on the campaign | character varying | YES |
| pickup_city | deprecated, stored on the campaign | character varying | YES |
| pickup_province | deprecated, stored on the campaign | character varying | YES |
| pickup_postal | deprecated, stored on the campaign | character varying | YES |
| pickup_country | deprecated, stored on the campaign | character varying | YES |
| delivery_status | current status of the delivery, defaults to pending until changed to completed if delivery is succesful, failed if the rider was unable to complete the delivery. picked_up hasn't been used since Dec 2020. Was null before June 30 2020. |
character varying | YES |
| dropoff_phone | phone number of recipient | character varying | YES |
| organization_name | deprecated | character varying | YES |
| contact_name | deprecated here be dragons. | character varying | YES |
| contact_email | deprecated | character varying | YES |
| contact_phone | deprecated | character varying | YES |
| request_type | deprecated. Used to store type of delivery, now handled by items | character varying | YES |
| other_items | deprecated/never used | character varying | YES |
| organization_partner | misnamed. Only used for foodshare, this is a task id from the partner, in the past they gave use the name of the org who the client comes from, now its a unique id afaik | character varying | YES |
| onfleet_pickup_id | deprecated. used to be used for onfleet integration | character varying | YES |
| delivery_window | deprected. Used to a be a string of the time window for delivery, now stored on campaign as delivery_start / delivery_end. | character varying | YES |
| inserted_at | timestamp when task was created (generated by postgres) | timestamp without time zone | NO |
| updated_at | timestamp when task was last updated (generated by postgres) | timestamp without time zone | NO |
| column_name | data_type | is_nullable | |
|---|---|---|---|
| id | unique identifier | bigint | NO |
| category | Item category used for aggregation in the journal | character varying | YES |
| description | Description of the item | text | YES |
| name | Name of the item (more detailed than the category, i.e. "Large Food Hamper") | character varying | YES |
| photo | Not used | character varying | YES |
| plural_name | Plural of the name (for displaying) | character varying | YES |
| program_id | id of the program this item belongs to. | bigint | YES |
| inserted_at | timestamp | timestamp without time zone | NO |
| updated_at | timestamp | timestamp without time zone | NO |