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