Skip to content

admins

Platform administrators (operators, instructors, support staff).

  • ETL strategy: merge
  • PK: id

Columns

ColumnTypeDescription
idBIGINTPK.
id_tenantBIGINTFK → tenants.id.
nameTEXTFull name.
emailTEXTEmail.
phoneTEXTMobile phone, digits only (no formatting).
documentTEXTNational document, digits only.
last_access_atTIMESTAMPTZMost recent access.
created_atTIMESTAMPTZ
deleted_atTIMESTAMPTZSoft delete.

Difference vs users: in admins both phone and document are stored stripped of any formatting (digits only). In users the values are kept as entered.

Relationships

OpenDB · Cademi LMS Data Warehouse