|
id
INTEGER
|
1 |
|
category_id
INTEGER
|
4 → location_categories |
|
name
VARCHAR
|
GODOWN -1 |
|
description
TEXT
|
null |
|
latitude
DOUBLE_PRECISION
|
null |
|
longitude
DOUBLE_PRECISION
|
null |
|
geofence
TEXT
|
null |
|
is_active
BOOLEAN
|
Inactive |
|
created_at
TIMESTAMP
|
2026-04-20T11:41:20.430557 |
|
updated_at
TIMESTAMP
|
2026-04-22T04:17:52.355311 |
|
remarks
TEXT
|
null |
|
qr_code_string
VARCHAR
|
loc=V1-Backyard-ZN02-SZ01;SRL=1 |
|
qr_image_path
VARCHAR
|
subcategories/1/qr/locV1-Backyard-ZN02-SZ01_SRL1_A4.png |
|
code
VARCHAR
|
SZ01 |