PI Data Archive tables and primary keys
- Last UpdatedJan 13, 2023
- 1 minute read
- PI System
- PI Server
These are the Data Archive tables that you can view and edit with the piconfig utility. Note that a table that is available on one version of a Data Archive server might not be available in another. Use the ?tbl command to get the current list for the Data Archive server you are working with.
|
Database |
Table names |
Primary key |
|
Points |
PIPOINT |
TAG |
|
Digital states |
PIDS |
SET |
|
Digital State Strings |
PISTATE |
STATE |
|
Users |
PIUSER |
USER |
|
Groups |
PIGROUP |
GROUP |
|
Snapshot |
PISNAP or PISNAP2 |
TAG |
|
Archive |
PIARC |
TAG |
|
Database Security |
DBSECURITY |
DBName |
|
Batch Unit |
PIBAUNIT |
UNITNAME |
|
Batch Alias |
PIBAALIAS |
ALIAS |
|
Collective |
PICOLLECTIVE |
NAME |
|
Trust Logins |
PITRUST |
TRUST |
|
Firewall |
PIFIREWALL |
HOSTMASK |
|
Timeout Database |
PITIMEOUT |
NAME |
|
Attribute Sets |
PIATRSET |
SET |
|
Point Classes |
PIPTCLS |
CLASS |
|
Point Source |
PIPTSRC |
PTSRC |
|
PI Subsystem Information |
PISUBSYS, subsystem |
Not Applicable |
|
PI Subsystem Statistics |
PISUBSYSSTATS, subsystem |
Not Applicable |
|
PI Net Manager Statistics |
PINetMgrStats |
ID |
|
Subsystem Threads |
PITHREAD, subsystem |
ID |
|
Server |
PISERVER |
NAME |
|
PI Identities |
PIIDENT |
Ident |
|
PI Identity Mappings |
PIIDENTMAP |
IdentMap |
|
Batch |
PIBATCH |
HANDLE |
Related Links
- Attribute set table (PIATRSET)
- Archive table (PIARC)
- Batch table (PIBATCH)
- Batch alias table (PIBAALIAS)
- Batch unit table (PIBAUNIT)
- Collective table (PICOLLECTIVE)
- Database security table (DBSECURITY)
- Digital state table (PIDS)
- Digital state strings (PISTATE)
- Firewall table (PIFIREWALL)
- Group table (PIGROUP)
- Identity table (PIIDENT)
- Identity mappings table (PIIDENTMAP)
- Network manager statistics table (PINETMGRSTATS)
- Point class (PIPTCLS)
- Point database table (PIPOINT)
- Point source table (PIPTSRC)
- Server table (PISERVER)
- Snapshot table (PISNAP and PISNAP2)
- Subsystem table (PISUBSYS)
- Subsystem Statistics table (PISUBSYSSTATS)
- Thread table (PITHREAD)
- Timeout table (PITIMEOUT)
- Trust table (PITRUST)
- Users table (PIUSER)