test2
Tables (6)
image
- image_id — BIGINT — Primary key — NOT NULL
- image_url — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
member
- id — BIGINT — Primary key — NOT NULL
- username — VARCHAR(100) — NOT NULL
- password — VARCHAR(100) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- gender — ENUM('MALE','FEMALE')
- role — ENUM('ADMIN', 'POLICE', 'USER') — NOT NULL
- police_id — VARCHAR(50)
- status — ENUM('ACTIVE', 'INACTIVE', 'NOT_AVAILABLE', 'TRACKING') — NOT NULL
- created_at — DATETIME — NOT NULL
- edge_device_id — VARCHAR(100)
member_location
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- latitude — DECIMAL(10, 6) — NOT NULL
- longitude — DECIMAL(10, 6) — NOT NULL
- created_at — DATETIME — NOT NULL
task
- task_id — BIGINT — Primary key — NOT NULL
- wanted_vehicle_id — BIGINT — Foreign key → wanted_vehicles.wanted_vehicle_id — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- task_status — ENUM('ASSIGNED', 'ACCEPTED', 'REJECTED', 'COMPLETED', 'FAILED') — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
wanted_vehicles
- wanted_vehicle_id — BIGINT — Primary key — NOT NULL
- wanted_vehicle_number — VARCHAR(30) — NOT NULL
- case_number — VARCHAR(50) — NOT NULL
- crime_type — VARCHAR(100) — NOT NULL
- owner_name — VARCHAR(100) — NOT NULL
- wanted_vehicle_status — ENUM('WANTED', 'TRACKING', 'CAPTURED', 'INACTIVE', 'DELETED') — NOT NULL
- notes — TEXT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
wanted_vehicles_location
- location_id — BIGINT — Primary key — NOT NULL
- wanted_vehicle_id — BIGINT — Foreign key → wanted_vehicles.wanted_vehicle_id — NOT NULL
- latitude — DECIMAL(10, 6) — NOT NULL
- longitude — DECIMAL(10, 6) — NOT NULL
- reporter_name — VARCHAR(100) — NOT NULL
- sighted_at — DATETIME — NOT NULL