Skip to content

Data model

sandramchung edited this page Jun 29, 2017 · 14 revisions

assignment

  • id: type.string(),
  • user_id: requiredString(),
  • campaign_id: requiredString(),
  • created_at: timestamp()

campaign

  • id: type.string(),
  • organization_id: requiredString(),
  • title: optionalString(),
  • description: optionalString(),
  • is_started: type.boolean().required(),
  • due_by: type.date().required().default(null),
  • created_at: timestamp(),
  • is_archived: type.boolean().required()

campaign-contact

  • id: type.string(),
  • campaign_id: requiredString(),
  • assignment_id: optionalString(),
  • first_name: optionalString(),
  • last_name: optionalString(),
  • cell: requiredString(),
  • zip: optionalString(),
  • custom_fields: type.object().required().allowNull(false).default({}),
  • created_at: timestamp(),
  • message_status: requiredString().enum(['needsMessage','needsResponse','messaged','closed']).default('needsMessage'),
  • is_opted_out: type.boolean().default(false),
  • timezone_offset: type.string().default('').required()

canned-response

custom-types

interaction-step

invite

job-request

message

opt-out

organization

pending-message-part

question-response

user

user-cell

user-organization

zip-code

Clone this wiki locally