EZIS
Tables (19)
Code Detail (codedetail)
- code (1) — varchar(20) — Primary key — NOT NULL
- Detail code (detailcode) — varchar(24) — Primary key — NOT NULL
- Value (value) — varchar(128)
- Description (descr) — varchar(2000)
Object Info (object)
- Object ID (objectid) — int4 — Primary key — NOT NULL
- Open Object (openobject) — varchar(20)
- Group of Object (objectgroup) — varchar(20)
- Object Type (type) — varchar(10)
- User yes/no (5) — varchar(1)
Product Event (productevent)
- stat_id — int8 — Primary key — NOT NULL
- stat_id (stat_id2) — int8 — Foreign key → userproducteventmessage.stat_id — NOT NULL
- eventlevel — pbchar(1)
- useyn — bpchar(1)
Sending Method Info (sendmethod)
- Method Number (methodno) — int4 — Primary key — NOT NULL
- Method's description (descr) — varchar(64)
- Method Configuration (config) — varchar(2048)
- Method Type (type) — varchar(10)
- Group Massage yes/no (isgroupmsg) — bpchar(1)
- User yes/no (useyn) — bpchar(1)
Server Info (server)
- Server's Number (serverno) — int4 — Primary key — NOT NULL
- Server's Number (serverno2) — int4 — Foreign key → User's server.Server's Number — NOT NULL
- Management Number (mgmtno2) — int4 — Foreign key → User's server.Management Number — NOT NULL
- Stat ID (stat_id) — int8 — Foreign key → User's server.Stat ID — NOT NULL
- Management Number (mgmtno22) — int4 — Foreign key → User's server.Management Number — NOT NULL
- Server's Number (serverno22) — int4 — Foreign key → User's server.Server's Number — NOT NULL
- Management Number (mgmtno222) — int4 — Foreign key → User's server.Management Number — NOT NULL
- Stat ID (stat_id2) — int8 — Foreign key → User's server.Stat ID — NOT NULL
- Management Number (mgmtno2222) — int4 — Foreign key → User's server.Management Number — NOT NULL
- mgmtno (mgmtno3) — int4 — Foreign key → servermgmt.mgmtno — NOT NULL
- Server's ID (serverid) — varchar(40)
- Management Number (mgmtno) — int4
- Login ID (loginid) — varchar(40)
- Login Password (loginpassword) — varchar((128)
- IP Adress (ipaddr) — varchar(256)
- Port (port) — int4
- Connection Type (connectiontype) — varchar(12)
- Connection Name (connectionname) — varchar(128)
- Instance ID (instanceid) — varchar(128)
- Character Set (charset) — varchar(12)
- Use yes/no (useyn) — varchar(1)
- Agentkey (agentkey) — varchar(512)
Server's Event's Info (serverevent)
- Stat ID (stat_id) — int8 — Primary key — NOT NULL
- Management Number (mgmtno) — int4 — Primary key — NOT NULL
- Server's Number (serverno) — int4 — Foreign key → User's server.Server's Number — NOT NULL
- Management Number (mgmtno2) — int4 — Foreign key → User's server.Management Number — NOT NULL
- Stat ID (stat_id2) — int8 — Foreign key → User's server.Stat ID — NOT NULL
- Management Number (mgmtno22) — int4 — Foreign key → User's server.Management Number — NOT NULL
- event's Level (eventlevel) — bpchar(1)
- User yes/no (useyn) — bpchar(1)
Stat (stat)
- stat_id — int8 — Primary key — NOT NULL
- stat_id (stat_id2) — int8 — Foreign key → Product Event.stat_id — NOT NULL
- stat_id (stat_id22) — int8 — Foreign key → Product Event.stat_id — NOT NULL
- stat_id (stat_id3) — int8 — Foreign key → stat_oracle.stat_id — NOT NULL
- statname — varchar(120)
- stattype — varchar(24)
- display — varchar(64)
User Account (userxaccount)
- User's Number (userno) — int4 — Primary key — NOT NULL
- User Type (type) — int4 — Primary key — NOT NULL
User Info (users)
- User's Number (userno) — int4 — Primary key — NOT NULL
- Management Number (mgmtno) — int4 — Foreign key → User Management.Management Number — NOT NULL
- User Type (type) — int4 — Foreign key → User Account.User Type — NOT NULL
- userid (2) — varchar(20)
- password (3) — varchar(80)
- username (4) — varchar(40)
- mgmtno (5) — int4
- email (6) — varchar(50)
- cellphone (7) — varchar(20)
- lang (8) — varchar(10)
User Management (usermgmt)
- Management Number (mgmtno) — int4 — Primary key — NOT NULL
- Description (descr) — varchar(60)
User's Object (userobject)
- Object ID (objectid) — int4 — Primary key — NOT NULL
- mgmtno — int4 — Primary key — NOT NULL
- Object ID (objectid2) — int4 — Foreign key → Object Info.Object ID — NOT NULL
User's Sending Method (usermgmtxsendmethod)
- Method Number (methodno) — int4 — Primary key
- Management Number (mgmtno) — int4 — Primary key
- Method Number (methodno2) — int4 — Foreign key → Sending Method Info.Method Number — NOT NULL
User's server (userserver)
- Server's Number (serverno) — int4 — Primary key — NOT NULL
- Management Number (mgmtno) — int4 — Primary key — NOT NULL
- Stat ID (stat_id) — int8 — Foreign key → Server's Event's Info.Stat ID — NOT NULL
- Management Number (mgmtno2) — int4 — Foreign key → Server's Event's Info.Management Number — NOT NULL
- Server's Number (serverno2) — int4 — Foreign key → Server's Event's Info.Server's Number — NOT NULL
- Management Number (mgmtno22) — int4 — Foreign key → Server's Event's Info.Management Number — NOT NULL
- Stat ID (stat_id2) — int8 — Foreign key → Server's Event's Info.Stat ID — NOT NULL
- Management Number (mgmtno222) — int4 — Foreign key → Server's Event's Info.Management Number — NOT NULL
agent
- agentkey — varchar(512) — Primary key — NOT NULL
- ipaddr — varchar(24)
- hostname — varchar(128)
server_tns_mgmt
- mgmtno — int4 — Primary key — NOT NULL
- descr — varchar(512)
servermgmt
- mgmtno — int4 — Primary key — NOT NULL
- machinetype — varchar(20)
- descr — varchar(60)
stat_oracle
- stat_id — int8 — Primary key — NOT NULL
- class — inst4
- con_id — int4
- viewtype — varchar(10)
- processingtype — varchar(18)
userproducteventmessage
- stat_id — int8 — Primary key — NOT NULL
- mgmtno — int4