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)

Untitled

    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