IF Commons GitHub

sql/typed/models/identity-device.auto

The typed tables of the identityDevice model, generated by IFC Data from the model. Do not edit: change the model and run bun tools/typed.ts --write.

Device identities: endpoints, servers and things

Source: commons/data/sql/typed/models/identity-device.auto.ts

0 of 20 exports are imported by a test of the run. A test that imports an export may not call it or check what it returns.

identityDevicenamespace
namespace identityDevice
identityDevice.PlatformRowinterfaceno test imports it
interface PlatformRow

What a device runs

MemberTypeWhat it is
codestringThe code other tables point to: a short word that does not change
labelstringWhat a person is shown for the code
descriptionstring | nullWhat the code means, where the label is not enough
identityDevice.PlatformInsertinterfaceno test imports it
interface PlatformInsert

What an insert into platform takes: what the database fills may be left out.

MemberTypeWhat it is
codestring
labelstring
description?string | null
identityDevice.PlatformKeytypeno test imports it
type PlatformKey = { readonly code: string };

The key of a row of platform.

identityDevice.platformconstno test imports it
const platform: Table<PlatformRow, PlatformInsert, "platform">

What a device runs

identityDevice.DeviceRowinterfaceno test imports it
interface DeviceRow

Hardware that has an identity and an owner: an endpoint, a server or a thing

MemberTypeWhat it is
principalIdstringThe principal the device is
deviceKind"iot" | "laptop" | "other" | "phone" | "server" | "tablet"What kind of device it is
platformCodestringWhat it runs
hardwareHashstringA hash of its serial number or hardware identifier
labelstring | nullWhat it is called
managementState"managed" | "registered" | "retired" | "unmanaged"How far it is managed
ownership"corporate" | "personal" | "shared"Whose it is
enrolledAtTimestampWhen it was enrolled
lastSeenAtTimestamp | nullWhen it was last seen
trustedUntilTimestamp | nullUntil when it is trusted without a fresh attestation
identityDevice.DeviceInsertinterfaceno test imports it
interface DeviceInsert

What an insert into device takes: what the database fills may be left out.

MemberTypeWhat it is
principalIdstring
deviceKind"iot" | "laptop" | "other" | "phone" | "server" | "tablet"
platformCodestring
hardwareHashstring
label?string | null
managementState"managed" | "registered" | "retired" | "unmanaged"
ownership"corporate" | "personal" | "shared"
enrolledAtTimestamp
lastSeenAt?Timestamp | null
trustedUntil?Timestamp | null
identityDevice.DeviceKeytypeno test imports it
type DeviceKey = { readonly principalId: string };

The key of a row of device.

identityDevice.deviceconstno test imports it
const device: Table<DeviceRow, DeviceInsert, "device">

Hardware that has an identity and an owner: an endpoint, a server or a thing

identityDevice.DeviceAttestationRowinterfaceno test imports it
interface DeviceAttestationRow

What a device proved about itself, and how it was judged

MemberTypeWhat it is
deviceAttestationIdstringWhat identifies the attestation, made by the application
kind"cloud_instance" | "mdm_enrollment" | "platform_attestation" | "spiffe_node" | "tpm" | "webauthn_attestation"What was proved
evidenceHashstringA hash of the evidence; the evidence is kept by the verifier
verifierstringWhat judged it
result"failed" | "passed" | "unknown"How it was judged
attestedAtTimestampWhen it was judged
expiresAtTimestampWhen it stops counting
nonceHashstringA hash of the nonce the device was challenged with
devicePrincipalIdstringThe device
identityDevice.DeviceAttestationInsertinterfaceno test imports it
interface DeviceAttestationInsert

What an insert into device_attestation takes: what the database fills may be left out.

MemberTypeWhat it is
deviceAttestationIdstring
kind"cloud_instance" | "mdm_enrollment" | "platform_attestation" | "spiffe_node" | "tpm" | "webauthn_attestation"
evidenceHashstring
verifierstring
result"failed" | "passed" | "unknown"
attestedAtTimestamp
expiresAtTimestamp
nonceHashstring
devicePrincipalIdstring
identityDevice.DeviceAttestationKeytypeno test imports it
type DeviceAttestationKey = { readonly deviceAttestationId: string };

The key of a row of device_attestation.

identityDevice.deviceAttestationconstno test imports it
const deviceAttestation: Table<DeviceAttestationRow, DeviceAttestationInsert, "deviceAttestation">

What a device proved about itself, and how it was judged

identityDevice.DevicePostureRowinterfaceno test imports it
interface DevicePostureRow

How a device was doing when it last reported; after its time is up it reads as unknown, never as compliant

MemberTypeWhat it is
devicePostureIdstringWhat identifies the report, made by the application
source"agent" | "edr" | "manual" | "mdm"What reported it
compliance"compliant" | "noncompliant" | "unknown"Whether the device meets what is asked of it
osVersionstring | nullThe version of what it runs
diskEncryptedboolean | nullWhether its storage is encrypted
screenLockboolean | nullWhether it locks its screen
firewallboolean | nullWhether its firewall is on
jailbrokenboolean | nullWhether it has been broken out of its platform's protections
edrActiveboolean | nullWhether endpoint detection is running
patchAgeDaysnumber | nullHow many days old its latest patch is
riskScorenumber | nullA score from its reporter
detailsunknownWhat else was reported
reportedAtTimestampWhen it was reported
validUntilTimestampWhen the report stops counting
devicePrincipalIdstringThe device
identityDevice.DevicePostureInsertinterfaceno test imports it
interface DevicePostureInsert

What an insert into device_posture takes: what the database fills may be left out.

MemberTypeWhat it is
devicePostureIdstring
source"agent" | "edr" | "manual" | "mdm"
compliance"compliant" | "noncompliant" | "unknown"
osVersion?string | null
diskEncrypted?boolean | null
screenLock?boolean | null
firewall?boolean | null
jailbroken?boolean | null
edrActive?boolean | null
patchAgeDays?number | null
riskScore?number | null
details?unknown
reportedAtTimestamp
validUntilTimestamp
devicePrincipalIdstring
identityDevice.DevicePostureKeytypeno test imports it
type DevicePostureKey = { readonly devicePostureId: string };

The key of a row of device_posture.

identityDevice.devicePostureconstno test imports it
const devicePosture: Table<DevicePostureRow, DevicePostureInsert, "devicePosture">

How a device was doing when it last reported; after its time is up it reads as unknown, never as compliant

identityDevice.DeviceSessionRowinterfaceno test imports it
interface DeviceSessionRow

A session of a person that is on a device, so that a decision about the person can use the device's posture

MemberTypeWhat it is
devicePrincipalIdstringThe device
sessionLoginSessionSessionIdstringThe session
boundAtTimestampWhen the session was bound to the device
identityDevice.DeviceSessionInsertinterfaceno test imports it
interface DeviceSessionInsert

What an insert into device_session takes: what the database fills may be left out.

MemberTypeWhat it is
devicePrincipalIdstring
sessionLoginSessionSessionIdstring
boundAtTimestamp
identityDevice.DeviceSessionKeytypeno test imports it
type DeviceSessionKey = { readonly devicePrincipalId: string; readonly sessionLoginSessionSessionId: string };

The key of a row of device_session.

identityDevice.deviceSessionconstno test imports it
const deviceSession: Table<DeviceSessionRow, DeviceSessionInsert, "deviceSession">

A session of a person that is on a device, so that a decision about the person can use the device's posture

Titles, headings, exports, tables, columns and requirements. Esc closes.