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)