erDiagram
  USER {
    string id
    string email
    string name
    string passwordHash
    string status
    number failedLoginCount
    datetime lockedUntil
    datetime lastLoginAt
    string refreshTokenHash
    string phoneNumber
  }
  ROLE {
    string id
    string name
    string description
    boolean isSystem
    datetime createdAt
    datetime updatedAt
    string users
    string permissions
    string projectUsers
  }
  PERMISSION {
    string id
    string key
    string name
    string description
    string group
    string riskLevel
    boolean isSystem
    datetime createdAt
    datetime updatedAt
    string roles
  }
  USERPERMISSION {
    string userId
    string permissionId
    string effect
    datetime createdAt
    datetime updatedAt
    string user
    string permission
  }
  USERROLE {
    string userId
    string roleId
    string user
    string role
  }
  ROLEPERMISSION {
    string roleId
    string permissionId
    string role
    string permission
  }
  PROJECT {
    string id
    string name
    string slug
    string description
    string status
    string environment
    string tags
    boolean allowInternalHttpChecks
    string ownerUserId
    string owner
  }
  PROJECTUSER {
    string id
    string projectId
    string userId
    string roleId
    string projectRoleId
    string assignedByUserId
    string status
    datetime createdAt
    datetime updatedAt
    string project
  }
  PROJECTROLE {
    string id
    string name
    string description
    boolean isSystem
    datetime createdAt
    datetime updatedAt
    string permissions
    string members
  }
  PROJECTROLEPERMISSION {
    string projectRoleId
    string permissionId
    string projectRole
    string permission
  }
  PROJECTDOMAIN {
    string id
    string projectId
    string name
    string url
    number type
    string environment
    string previewDevice
    boolean isActive
    number expectedStatusCode
    string healthPath
  }
  HTTPCHECK {
    string id
    string projectId
    string name
    string description
    string rawCurl
    string method
    string url
    string headers
    string queryParams
    string body
  }
  HTTPCHECKRUN {
    string id
    string checkId
    string projectId
    datetime startedAt
    datetime finishedAt
    number durationMs
    string status
    number statusCode
    string responseHeaders
    string responseBodyPreview
  }
  SERVER {
    string id
    string projectId
    string name
    string ipAddress
    string hostname
    string environment
    string description
    boolean isActive
    number pingIntervalMinutes
    number alertAfterFailures
  }