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)