authorization table

Tables (7)

device (Untitled3)

  • device_id (Key2) — Primary key — NOT NULL
  • device_name (Field)

group (Untitled)

  • group_id (Key) — Primary key — NOT NULL
  • group_type (Field)

group_device_mapping (Untitled6)

  • group_id (Key) — Foreign key → group.group_id — NOT NULL
  • device_id (Key2) — Foreign key → device.device_id — NOT NULL

group_task_mapping (Untitled5)

  • group_id (Key) — Foreign key → group.group_id — NOT NULL
  • task_id (Key2) — Foreign key → task.task_id — NOT NULL

task (Untitled2)

  • task_id (Key2) — Primary key — NOT NULL
  • task_name (Field)

user_group_mapping (Untitled4)

  • user_id (Key2) — Foreign key → users.user_id — NOT NULL
  • group_id (Key) — Foreign key → group.group_id — NOT NULL

users

  • user_id (Key2) — Primary key — NOT NULL
  • username (Field)
  • email (Field2)