safeport

Tables (6)

access_logs

  • log_id — BIGSERIAL
  • helmet_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • project_id — BIGINT — NOT NULL
  • check_in — TIMESTAMP — NOT NULL
  • check_out — TIMESTAMP

alert_events

  • event_id — BIGSERIAL
  • helmet_id — BIGINT — NOT NULL
  • user_id — BIGINT
  • event_type — VARCHAR(50)
  • other)) — NOT — NOT NULL
  • message — TEXT
  • created_at — TIMESTAMP
  • resolved — BOOLEAN

helmets

  • helmet_id — BIGSERIAL
  • serial_number — VARCHAR(100) — NOT NULL
  • project_id — BIGINT
  • assigned_to — BIGINT
  • status — VARCHAR(20)
  • maintenance)) — DEFAULT
  • registered_at — TIMESTAMP

projects

  • project_id — BIGSERIAL
  • name — VARCHAR(150) — NOT NULL
  • location — VARCHAR(255)
  • description — TEXT
  • start_date — DATE
  • end_date — DATE

sensor_data

  • data_id — BIGSERIAL
  • helmet_id — BIGINT — NOT NULL
  • timestamp — TIMESTAMP — NOT NULL
  • temperature — FLOAT
  • gas_level — FLOAT
  • shock_detected — BOOLEAN
  • battery_level — FLOAT

users

  • user_id — BIGSERIAL
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(150) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • role — VARCHAR(20)
  • worker)) — NOT — NOT NULL
  • phone — VARCHAR(30)
  • created_at — TIMESTAMP