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