maine-log-private

Tables (16)

activity

  • id — BIGINT
  • name — VARCHAR(200) — NOT NULL
  • description — VARCHAR(1000)
  • start_datetime — DATETIME(3)
  • end_datetime — DATETIME(3)
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME(3) — NOT NULL
  • updated_at — DATETIME(3) — NOT NULL

activity_location

  • activity_id — BIGINT
  • geom — POINT — NOT NULL
  • address — VARCHAR(255)
  • region_lvl1 — VARCHAR(100)
  • region_lvl2 — VARCHAR(100)
  • region_lvl3 — VARCHAR(100)
  • created_at — DATETIME(3) — NOT NULL
  • updated_at — DATETIME(3) — NOT NULL
  • SPATIAL — INDEX

activity_participant

  • activity_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Primary key — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • checkin_at — DATETIME(3)
  • checkout_at — DATETIME(3)
  • service_minutes — INT

activity_picture

  • id — BIGINT
  • activity_id — BIGINT — NOT NULL
  • picture_url — VARCHAR(500) — NOT NULL
  • uploaded_by — BIGINT
  • captured_at — DATETIME(3)
  • sha256_hash — CHAR(64)
  • created_at — DATETIME(3) — NOT NULL

activity_post

  • id — BIGINT
  • activity_id — BIGINT — NOT NULL
  • author_user_id — BIGINT — NOT NULL
  • title — VARCHAR(200)
  • content — TEXT
  • created_at — DATETIME(3) — NOT NULL
  • updated_at — DATETIME(3) — NOT NULL

activity_record

  • activity_id — BIGINT
  • participants_count — INT
  • total_weight_kg — DECIMAL(10,2)
  • total_volume_l — DECIMAL(10,2)
  • weather_json — JSON
  • created_at — DATETIME(3) — NOT NULL
  • updated_at — DATETIME(3) — NOT NULL

agg_waste_monthly

  • yyyymm — CHAR(6) — Primary key — NOT NULL
  • organization_id — BIGINT
  • type_id — INT
  • total_weight_kg — DECIMAL(18,2)
  • total_volume_l — DECIMAL(18,2)

hosted_by

  • activity_id — BIGINT — Primary key — NOT NULL
  • organization_id — BIGINT — Primary key — NOT NULL

organization

  • id — BIGINT
  • name — VARCHAR(200) — NOT NULL
  • location — VARCHAR(255)
  • description — VARCHAR(1000)
  • created_at — DATETIME(3) — NOT NULL
  • updated_at — DATETIME(3) — NOT NULL

organization_member

  • organization_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Primary key — NOT NULL
  • org_role — VARCHAR(30) — NOT NULL
  • created_at — DATETIME(3) — NOT NULL

social_login

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • provider — VARCHAR(30) — NOT NULL
  • provider_id — VARCHAR(128) — NOT NULL
  • access_token — TEXT
  • refresh_token — TEXT
  • access_token_expires_at — DATETIME(3)
  • refresh_token_expires_at — DATETIME(3)
  • created_at — DATETIME(3) — NOT NULL
  • updated_at — DATETIME(3) — NOT NULL

user

  • id — BIGINT
  • email — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100)
  • phone_number — VARCHAR(40)
  • address — VARCHAR(255)
  • status — VARCHAR(20) — NOT NULL
  • last_login_at — DATETIME(3)
  • created_at — DATETIME(3) — NOT NULL
  • updated_at — DATETIME(3) — NOT NULL
  • deleted_at — DATETIME(3)

user_consent

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • policy_type — VARCHAR(30) — NOT NULL
  • policy_ver — VARCHAR(20) — NOT NULL
  • agreed — TINYINT(1) — NOT NULL
  • agreed_at — DATETIME(3) — NOT NULL

waste

  • id — BIGINT
  • activity_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • specific_type_id — INT
  • count_items — INT
  • weight_kg — DECIMAL(10,2)
  • volume_l — DECIMAL(10,2)
  • environment — VARCHAR(30)
  • picture_url — VARCHAR(500)
  • created_at — DATETIME(3) — NOT NULL

waste_specific_type

  • id — INT
  • type_id — INT — NOT NULL
  • name — VARCHAR(100) — NOT NULL

waste_type

  • id — INT
  • name — VARCHAR(100) — NOT NULL