Data Model
Overview
The cmdlet dynamically retrieves notes and views from your Domino database and models them as tables and views. Domino notes are modeled as tables. Domino views are modeled as views.
Tables, Views, Columns and Stored Procedures
Simple and Display Names
The cmdlet supports options for controlling how tables, views, and columns are named:
Note Metadata
In addition to the items defined on each note, Domino exposes metadata about each note that the cmdlet maps to special columns. These columns are:
- unid The unique note identifier, which identifies this specific note across all databases on the server. This is available in all tables and views.
Note that some column names will be different when UseSimpleNames is enabled because they can contain special characters.
Null Values
Domino does not have a direct equivalent of the SQL NULL value. The cmdlet reports NULL values for columns in these scenarios:
- When an item is not set on a note. In Domino formulas, this is equivalent to @IsAvailable(item) = 0.
- When a single-valued item on a note is the empty text value. In Domino formulas, this is equivalent to @IsNull(item) = 1. Here, a single-valued item is an item on the base table or view where the cmdlet did not find any multi-value entries during type detection.
Tables
Available tables are listed using System Tables queries.For example:
SELECT * FROM sys_tables WHERE TableName = 'Person'
Views
Available views are listed using System Tables queries.For example:
SELECT * FROM sys_tables WHERE TableName = '($Account)'
Columns
Available columns on tables and views are listed using System Table Columns queries.For example:
SELECT * FROM sys_tablecolumns WHERE TableName = 'Person'
Stored Procedures
Stored procedures allow you to execute operations to Domino Attachments can be manipulated via the DownloadAttachment, UploadAttachment, and RemoveAttachment stored procedures.