nexusLIMS.db.migrations.versions.v2_5_0a_add_external_user_identifiers#

Add external_user_identifiers table.

Adds table for mapping NexusLIMS usernames to external system user IDs using a star topology design with nexuslims_username as the canonical identifier.

Supports integration with:

  • NEMO (lab management system)

  • LabArchives ELN (electronic lab notebook)

  • LabArchives Scheduler (reservation system)

  • CDCS (Configurable Data Curation System)

Revision ID: v2_5_0a Revises: v2_4_0b Create Date: 2026-02-08 14:00:00.000000

Module Contents#

Functions#

upgrade

Create external_user_identifiers table.

downgrade

Drop external_user_identifiers table.

Data#

revision

down_revision

branch_labels

depends_on

API#

nexusLIMS.db.migrations.versions.v2_5_0a_add_external_user_identifiers.revision#

‘v2_5_0a’

Type: str

nexusLIMS.db.migrations.versions.v2_5_0a_add_external_user_identifiers.down_revision#

‘v2_4_0b’

Type: typing.Union[str, typing.Sequence[str], None]

nexusLIMS.db.migrations.versions.v2_5_0a_add_external_user_identifiers.branch_labels#

Type: typing.Union[str, typing.Sequence[str], None]

nexusLIMS.db.migrations.versions.v2_5_0a_add_external_user_identifiers.depends_on#

Type: typing.Union[str, typing.Sequence[str], None]

nexusLIMS.db.migrations.versions.v2_5_0a_add_external_user_identifiers.upgrade() → None[source]#

Create external_user_identifiers table.

nexusLIMS.db.migrations.versions.v2_5_0a_add_external_user_identifiers.downgrade() → None[source]#

Drop external_user_identifiers table.