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