aimonitor

Tables (4)

Comment

  • ID (id) — INTEGER — Primary key — NOT NULL
  • Event_id (event_id) — INTEGER — Foreign key → Event.ID — NOT NULL
  • User_id (user_id) — INTEGER — Foreign key → User.ID — NOT NULL
  • Content (content) — VARCHAR(500) — NOT NULL
  • Created_at (created_at) — TIMESTAMP — NOT NULL

Equipment

  • ID (id) — INTEGER — Primary key — NOT NULL
  • Type (type) — VARCHAR(20) — NOT NULL
  • Location_name (location_name) — VARCHAR(100) — NOT NULL
  • Status (status) — VARCHAR(20) — NOT NULL

Event

  • ID (id) — INTEGER — Primary key — NOT NULL
  • User_id (user_id) — INTEGER — Foreign key → User.ID
  • Equipment_id (equipment_id) — INTEGER — Foreign key → Equipment.ID — NOT NULL
  • Obstacle_type (obstacle_type) — VARCHAR(50) — NOT NULL
  • Confidence (confidence) — FLOAT — NOT NULL
  • Status (status) — VARCHAR(20) — NOT NULL
  • Image_URL (image_url) — VARCHAR(255) — NOT NULL
  • Detected_at (detected_at) — TIMESTAMP — NOT NULL
  • Latitude (latitude) — FLOAT — NOT NULL
  • Longitude (longitude) — FLOAT — NOT NULL

User

  • ID (id) — INTEGER — Primary key — NOT NULL
  • Username (username) — VARCHAR(50) — NOT NULL
  • Role (role) — VARCHAR(20) — NOT NULL
  • Created_at (created_at) — TIMESTAMP — NOT NULL