sr

Tables (21)

access_requests

  • id — varchar(36) — Primary key — NOT NULL
  • tenant_id — varchar(36) — Foreign key → tenants.id — NOT NULL
  • user_id — varchar(36) — Foreign key → users.id — NOT NULL
  • requested_role_name — varchar(80) — NOT NULL
  • permission_type — varchar(64) — NOT NULL
  • reason — text
  • status — varchar(20) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

approvals

  • id — varchar(36) — Primary key — NOT NULL
  • access_request_id — varchar(36) — Foreign key → access_requests.id — NOT NULL
  • approver_user_id — varchar(36) — Foreign key → users.id — NOT NULL
  • decision — varchar(20) — NOT NULL
  • comment — text
  • decided_at — datetime — NOT NULL

local_accounts

  • id — varchar(36) — Primary key — NOT NULL
  • user_id — varchar(36) — Foreign key → users.id — NOT NULL
  • password_hash — varchar(255) — NOT NULL
  • is_active — tinyint(1) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

oauth_accounts

  • id — varchar(36) — Primary key — NOT NULL
  • user_id — varchar(36) — Foreign key → users.id — NOT NULL
  • provider — varchar(50) — NOT NULL
  • provider_user_id — varchar(255) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

permissions

  • id — varchar(36) — Primary key — NOT NULL
  • code — varchar(120) — NOT NULL
  • description — varchar(255)
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

project_members

  • id — varchar(36) — Primary key — NOT NULL
  • project_id — varchar(36) — Foreign key → projects.id — NOT NULL
  • user_id — varchar(36) — Foreign key → users.id — NOT NULL
  • role_name — varchar(80) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

projects

  • id — varchar(36) — Primary key — NOT NULL
  • tenant_id — varchar(36) — Foreign key → tenants.id — NOT NULL
  • code — varchar(64) — NOT NULL
  • name — varchar(150) — NOT NULL
  • location — varchar(255)
  • timezone — varchar(64) — NOT NULL
  • drawing_image_url — varchar(500)
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

regions

  • id — varchar(36) — Primary key — NOT NULL
  • tenant_id — varchar(36) — Foreign key → tenants.id — NOT NULL
  • code — varchar(64) — NOT NULL
  • name — varchar(150) — NOT NULL
  • location — varchar(255)
  • timezone — varchar(64) — NOT NULL
  • site_image_url — varchar(500)
  • is_active — tinyint(1) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

role_permissions

  • id — varchar(36) — Primary key — NOT NULL
  • role_id — varchar(36) — Foreign key → roles.id — NOT NULL
  • permission_id — varchar(36) — Foreign key → permissions.id — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

roles

  • id — varchar(36) — Primary key — NOT NULL
  • name — varchar(80) — NOT NULL
  • description — varchar(255)
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

sensor_alerts

  • id — int — Primary key — NOT NULL
  • tenant_id — varchar(36) — Foreign key → tenants.id — NOT NULL
  • region_id — varchar(36) — Foreign key → regions.id — NOT NULL
  • sensor_id — varchar(36) — Foreign key → sensors.id — NOT NULL
  • axis — varchar(10) — NOT NULL
  • severity — varchar(20) — NOT NULL
  • measured_value — decimal(16,6) — NOT NULL
  • threshold_value — decimal(16,6) — NOT NULL
  • message — varchar(255) — NOT NULL
  • occurred_at — datetime — NOT NULL
  • resolved_at — datetime
  • created_at — datetime — NOT NULL

sensor_anomalies

  • id — int — Primary key — NOT NULL
  • tenant_id — varchar(36) — Foreign key → tenants.id — NOT NULL
  • region_id — varchar(36) — Foreign key → regions.id — NOT NULL
  • sensor_id — varchar(36) — Foreign key → sensors.id — NOT NULL
  • model_key — varchar(80) — NOT NULL
  • score — decimal(12,6) — NOT NULL
  • verdict — varchar(30) — NOT NULL
  • basis — text
  • detected_at — datetime — NOT NULL
  • created_at — datetime — NOT NULL

sensor_channels

  • id — varchar(36) — Primary key — NOT NULL
  • sensor_id — varchar(36) — Foreign key → sensors.id — NOT NULL
  • channel_code — varchar(16) — NOT NULL
  • display_name — varchar(120) — NOT NULL
  • unit — varchar(40) — NOT NULL
  • is_active — tinyint(1) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

sensor_data

  • id — int — Primary key — NOT NULL
  • tenant_id — varchar(36) — Foreign key → tenants.id — NOT NULL
  • project_id — varchar(36) — Foreign key → projects.id — NOT NULL
  • sensor_id — varchar(36) — Foreign key → sensors.id — NOT NULL
  • channel — varchar(16) — NOT NULL
  • timestamp — datetime — NOT NULL
  • value — decimal(16,6) — NOT NULL
  • created_at — datetime — NOT NULL

sensor_readings

  • id — int — Primary key — NOT NULL
  • tenant_id — varchar(36) — Foreign key → tenants.id — NOT NULL
  • region_id — varchar(36) — Foreign key → regions.id — NOT NULL
  • sensor_id — varchar(36) — Foreign key → sensors.id — NOT NULL
  • measured_at — datetime — NOT NULL
  • x_value — decimal(16,6) — NOT NULL
  • y_value — decimal(16,6) — NOT NULL
  • temperature — decimal(8,3)
  • battery_voltage — decimal(8,3)
  • signal_status — varchar(20)
  • source_type — varchar(40) — NOT NULL
  • raw_payload — text
  • created_at — datetime — NOT NULL

sensor_thresholds

  • id — varchar(36) — Primary key — NOT NULL
  • sensor_id — varchar(36) — Foreign key → sensors.id — NOT NULL
  • axis — varchar(10) — NOT NULL
  • level1 — decimal(16,6) — NOT NULL
  • level2 — decimal(16,6) — NOT NULL
  • level3 — decimal(16,6) — NOT NULL
  • effective_from — datetime — NOT NULL
  • effective_to — datetime
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

sensor_types

  • id — varchar(36) — Primary key — NOT NULL
  • code — varchar(80) — NOT NULL
  • name — varchar(120) — NOT NULL
  • description — varchar(255)
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

sensors

  • id — varchar(36) — Primary key — NOT NULL
  • tenant_id — varchar(36) — Foreign key → tenants.id — NOT NULL
  • project_id — varchar(36) — Foreign key → projects.id — NOT NULL
  • sensor_type_id — varchar(36) — Foreign key → sensor_types.id — NOT NULL
  • region_id — char(36) — Foreign key → regions.id
  • manager_code — varchar(100) — NOT NULL
  • name — varchar(150) — NOT NULL
  • device_id — varchar(120) — NOT NULL
  • location_label — varchar(255)
  • map_x — decimal(7,3)
  • map_y — decimal(7,3)
  • sensor_kind — varchar(80) — NOT NULL
  • status — varchar(20) — NOT NULL
  • is_active — tinyint(1) — NOT NULL
  • last_measured_at — datetime(6)
  • last_battery_voltage — decimal(8,3)
  • last_signal_status — varchar(20)
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

tenant_users

  • id — varchar(36) — Primary key — NOT NULL
  • tenant_id — varchar(36) — Foreign key → tenants.id — NOT NULL
  • user_id — varchar(36) — Foreign key → users.id — NOT NULL
  • role_id — varchar(36) — Foreign key → roles.id — NOT NULL
  • is_active — tinyint(1) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

tenants

  • id — varchar(36) — Primary key — NOT NULL
  • name — varchar(120) — NOT NULL
  • slug — varchar(120) — NOT NULL
  • service_type — varchar(80) — NOT NULL
  • is_active — tinyint(1) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

users

  • id — varchar(36) — Primary key — NOT NULL
  • email — varchar(255) — NOT NULL
  • name — varchar(120) — NOT NULL
  • is_active — tinyint(1) — NOT NULL
  • status — varchar(20) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL