study

Tables (14)

account

  • id — int8 — Primary key — NOT NULL
  • bio — varchar(255)
  • email — varchar(255)
  • email_check_token — varchar(255)
  • email_check_token_generated_at — timestamp
  • email_verified — boolean — NOT NULL
  • joined_at — timestamp
  • location — varchar(255)
  • nickname — varchar(255)
  • occupation — varchar(255)
  • password — varchar(255)
  • profile_image — text
  • study_created_by_email — boolean — NOT NULL
  • study_created_by_web — boolean — NOT NULL
  • study_enrollment_result_by_email — boolean — NOT NULL
  • study_enrollment_result_by_web — boolean — NOT NULL
  • study_updated_by_email — boolean — NOT NULL
  • study_updated_by_web — boolean — NOT NULL
  • url — varchar(255)

account_tags

  • account_id — int8 — Primary key — NOT NULL
  • tags_id — int8 — Primary key — NOT NULL

account_zones

  • account_id — int8 — Primary key — NOT NULL
  • zones_id — int8 — Primary key — NOT NULL

enrollment

  • id — int8 — Primary key — NOT NULL
  • accepted — boolean — NOT NULL
  • attended — boolean — NOT NULL
  • enrolled_at — timestamp
  • account_id — int8
  • event_id — int8

event

  • id — int8 — Primary key — NOT NULL
  • created_date_time — timestamp — NOT NULL
  • description — text
  • end_date_time — timestamp — NOT NULL
  • end_enrollment_date_time — timestamp — NOT NULL
  • event_type — varchar(255)
  • limit_of_enrollments — int4
  • start_date_time — timestamp — NOT NULL
  • title — varchar(255) — NOT NULL
  • created_by_id — int8
  • study_id — int8

notification

  • id — int8 — Primary key — NOT NULL
  • checked — boolean — NOT NULL
  • created_date_time — timestamp
  • link — varchar(255)
  • message — varchar(255)
  • notification_type — varchar(255)
  • title — varchar(255)
  • account_id — int8

persistent_logins

  • series — varchar(64) — Primary key — NOT NULL
  • last_used — timestamp — NOT NULL
  • token — varchar(64) — NOT NULL
  • username — varchar(64) — NOT NULL

study

  • id — int8 — Primary key — NOT NULL
  • closed — boolean — NOT NULL
  • closed_date_time — timestamp
  • full_description — text
  • image — text
  • member_count — int4 — NOT NULL
  • path — varchar(255)
  • published — boolean — NOT NULL
  • published_date_time — timestamp
  • recruiting — boolean — NOT NULL
  • recruiting_updated_date_time — timestamp
  • short_description — varchar(255)
  • title — varchar(255)
  • use_banner — boolean — NOT NULL

study_managers

  • study_id — int8 — Primary key — NOT NULL
  • managers_id — int8 — Primary key — NOT NULL

study_members

  • study_id — int8 — Primary key — NOT NULL
  • members_id — int8 — Primary key — NOT NULL

study_tags

  • study_id — int8 — Primary key — NOT NULL
  • tags_id — int8 — Primary key — NOT NULL

study_zones

  • study_id — int8 — Primary key — NOT NULL
  • zones_id — int8 — Primary key — NOT NULL

tag

  • id — int8 — Primary key — NOT NULL
  • title — varchar(255) — NOT NULL

zone

  • id — int8 — Primary key — NOT NULL
  • city — varchar(255) — NOT NULL
  • local_name_of_city — varchar(255) — NOT NULL
  • province — varchar(255)