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