security_architecture

Tables (5)

AdminAcessLog (CopyOfUntitled4)

  • id (Key) — Primary key — NOT NULL
  • admin_user_id (Field)
  • endpoint (Field2)
  • http_method (Field3)
  • ip_address (Field4)
  • access_time (Field5)

LoginFailLog (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • user_id (Field)
  • username_input (Field2)
  • id_address (Field3)
  • fail_reason (Field4)
  • created_at (Field5)

Role (Untitled2)

  • role_id (Key) — Primary key — NOT NULL
  • name (Field)

User (Untitled)

  • user_id (Key) — Primary key — NOT NULL
  • username (Field2)
  • password (Field3)
  • locked (Field4)
  • enabled (Field5)
  • created_at (Field6)

User_Role (Untitled3)

  • user_id (Key3) — Foreign key → User.user_id — NOT NULL
  • role_id (Key) — Foreign key → Role.role_id — NOT NULL