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