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