Database Schema

users

{
  "id": {
    "type": "number",
    "increments": true
  },
  "name": {
    "type": "string"
  },
  "email": {
    "type": "string",
    "unique": true,
  },
  "email_verified_at": {
    "type": "datetime",
    "nullable": true
  },
  "password": {
    "type": "string"
  },
  "user_role_id": {
    "type": "number",
    "nullable": true
  },
  "client_id": {
    "type": "string",
    "unique": true,
    "default": "[system-generated]"
  }
}

password_resets

{
  "email": {
    "type": "string"
  },
  "token": {
    "type": "string"
  },
  "created_at": {
    "type": "datetime",
    "nullable": true
  }
}

user_roles

{
  "id": {
    "type": "number",
    "increments": true
  },
  "user_role": {
    "type": "string",
    "unique": true
  },
  "description": {
    "type": "string",
    "nullable": true,
  }
}

clients

{
  "client_id": {
    "type": "string",
    "unique": true
  },
  "client_name": {
    "type": "string"
  },
  "app_id": {
    "type": "string",
    "unique": true,
    "default": "[system-generated]"
  },
  "app_secret": {
    "type": "string",
    "unique": true,
    "default": "[system-generated]"
  }
}