Lss
Tables (5)
lss
- uuid — uuid — Primary key — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
- lss_id — int — NOT NULL
- latitude — float — NOT NULL
- longitude — float — NOT NULL
- altitude — float — NOT NULL
- heading — float — NOT NULL
- name — varchar — NOT NULL
- description — varchar — NOT NULL
role
- uuid — uuid — Primary key — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
- name — varchar — NOT NULL
- description — varchar — NOT NULL
- is_activated — bool
role_lss
- uuid — uuid — Primary key — NOT NULL
- lss_uuid — uuid — Foreign key → lss.uuid — NOT NULL
- role_uuid — uuid — Foreign key → role.uuid — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
- rolePermission — varchar — NOT NULL
user
- uuid — uuid — Primary key — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
- user_id — varchar — NOT NULL
- salt — varchar — NOT NULL
- name — varchar — NOT NULL
- hash — varchar — NOT NULL
- is_activated — bool — NOT NULL
- user_type — varchar — NOT NULL
- phone_number — varchar
user__role
- user_uuid — uuid — Foreign key → user.uuid — NOT NULL
- role_uuid — uuid — Foreign key → role.uuid — NOT NULL