dd

Tables (12)

activities

  • id — bigint — Primary key — NOT NULL
  • latitude — double
  • longitude — double
  • recruitment_end_date — date
  • recruitment_number — integer
  • recruitment_start_date — date
  • activity_start_date_time — timestamp
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp
  • address — character
  • other_info — character
  • program_info — character
  • supplies — character
  • activity_location — character — NOT NULL
  • category — character — NOT NULL
  • organization_name — character — NOT NULL
  • project_name — character — NOT NULL
  • region — character — NOT NULL
  • state — character
  • transportation — character — NOT NULL
  • organization_id — bigint — NOT NULL
  • region_id — bigint — NOT NULL
  • recruiter_id — bigint
  • current_participants — integer — NOT NULL
  • activity_date — character

activity_participant

  • activity_participant_id — bigint — Primary key — NOT NULL
  • activity_id — bigint — NOT NULL
  • applied_at — timestamp — NOT NULL
  • approved_at — timestamp
  • check_in_at — timestamp
  • check_out_at — timestamp
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp
  • user_id — bigint — NOT NULL
  • apply_status — character — NOT NULL
  • role — character — NOT NULL

activity_waste_collection

  • collection_id — bigint — Primary key — NOT NULL
  • quantity — numeric — NOT NULL
  • activity_id — bigint — NOT NULL
  • created_at — timestamp — NOT NULL
  • recorded_at — timestamp — NOT NULL
  • recorded_by_user_id — bigint — NOT NULL
  • updated_at — timestamp
  • waste_category_id — bigint — NOT NULL
  • unit — character
  • note — character

communities

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp
  • content — oid — NOT NULL
  • title — character — NOT NULL
  • activity_id — bigint
  • post_type — character — NOT NULL
  • author_user_id — bigint — NOT NULL
  • image_url — character

community_images

  • id — bigint — Primary key — NOT NULL
  • image_url — character — NOT NULL
  • community_id — bigint — NOT NULL

metric_daily_agg_test

  • id — bigint — Primary key — NOT NULL
  • activity_count — integer
  • date — date — NOT NULL
  • new_signup_count — integer
  • participant_count — integer
  • waste_total_qty — numeric
  • org_id — bigint
  • region_id — bigint
  • org_name — character
  • region_name — character

metric_participation_by_age_test

  • id — bigint — Primary key — NOT NULL
  • date — date — NOT NULL
  • participant_count — integer
  • org_id — bigint
  • region_id — bigint
  • age_bucket — character — NOT NULL
  • org_name — character
  • region_name — character

metric_waste_by_category_test

  • id — bigint — Primary key — NOT NULL
  • date — date — NOT NULL
  • quantity_sum — numeric
  • org_id — bigint
  • region_id — bigint
  • waste_category_id — bigint
  • org_name — character
  • region_name — character
  • waste_category_name — character

organization

  • org_id — bigint — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • region_id — bigint — NOT NULL
  • updated_at — timestamp
  • status — character
  • contact_phone — character
  • type — character — NOT NULL
  • contact_name — character
  • contact_email — character
  • name — character — NOT NULL
  • logo_image_url — character

region

  • region_id — bigint — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • parent_region_id — bigint
  • updated_at — timestamp
  • code — character
  • name — character — NOT NULL

users

  • id — bigint — Primary key — NOT NULL
  • birth_date — date — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp
  • email — character — NOT NULL
  • gender — character — NOT NULL
  • name — character — NOT NULL
  • password — character — NOT NULL
  • phone — character — NOT NULL
  • role — character — NOT NULL
  • organization_id — bigint
  • total_activity_count — integer
  • total_volunteer_hours — double
  • total_waste_collected — numeric

waste_category

  • waste_category_id — bigint — Primary key — NOT NULL
  • is_active — boolean — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp
  • unit — character — NOT NULL
  • name — character — NOT NULL