Mini_v12
Tables (8)
AlertLogger (ALERT_LOGGER)
- schema (SCHEMA) — VARCHAR — Primary key — NOT NULL
- before (BEFORE) — BOOLEAN
- after (AFTER) — BOOLEAN
- time (TIME) — TIMESTAMP
InitialInformation (INITIAL_INFORMATION)
- alias (ALIAS) — VARCHAR — Primary key
- aliasNum (ALIAS_NUM) — INTEGER
- address (ADDRESS) — VARCHAR
- port (PORT) — INTEGER
- name (NAME) — VARCHAR
- dbId (DB_ID) — VARCHAR
- dbPasswd (DB_PASSWD) — VARCHAR
- liveState (LIVE_STATE) — BOOLEAN
MfoPgSettings1day (MFO_PG_SETTINGS_1DAY)
- name (NAME) — TEXT
- setting (SETTING) — TEXT
- unit (UNIT) — TEXT
- category (CATEGORY) — TEXT
- shortDesc (SHORT_DESC) — TEXT
- extraDesc (EXTRA_DESC) — TEXT
- context (CONTEXT) — TEXT
- vartype (VARTYPE) — TEXT
- source (SOURCE) — TEXT
- minVal (MIN_VAL) — TEXT
- maxVal (MAX_VAL) — TEXT
- enumvals (ENUMVALS) — TEXT
- bootVal (BOOT_VAL) — TEXT
- resetVal (RESET_VAL) — TEXT
- sourcefile (SOURCEFILE) — TEXT
- sourceline (SOURCELINE) — INTEGER
- db_id (DB_ID) — INTEGER
- time (TIME) — TIMESTAMP
MfoPgStatAllTables1hour (MFO_PG_STAT_ALL_TABLES_1HOUR)
- schemaname (SCHEMANAME) — NAME
- relname (RELNAME) — NAME
- totalRelSize (TOTAL_REL_SIZE) — BIGINT
- reSize (RE_SIZE) — BIGINT
- tabSize (TAB_SIZE) — BIGINT
- indSize (IND_SIZE) — BIGINT
- seqScan (SEQ_SCAN) — BIGINT
- seqTupRead (SEQ_TUP_READ) — BIGINT
- idxScan (IDX_SCAN) — BIGINT
- idxTupFetch (IDX_TUP_FETCH) — BIGINT
- nTupIns (N_TUP_INS) — BIGINT
- nTupUpd (N_TUP_UPD) — BIGINT
- nTupDel (N_TUP_DEL) — BIGINT
- nTupHotUpd (N_TUP_HOT_UPD) — BIGINT
- nLiveTup (N_LIVE_TUP) — BIGINT
- nDeadTup (N_DEAD_TUP) — BIGINT
- nModSinceAnalyze (N_MOD_SINCE_ANALYZE) — BIGINT
- lastVacuum (LAST_VACUUM) — TIMESTAMP
- lastAutovacuum (LAST_AUTOVACUUM) — TIMESTAMP
- lastAnalyze (LAST_ANALYZE) — TIMESTAMP
- lastAutoanalyze (LAST_AUTOANALYZE) — TIMESTAMP
- vacuumCount (VACUUM_COUNT) — BIGINT
- autovacuumCount (AUTOVACUUM_COUNT) — BIGINT
- analyzeCount (ANALYZE_COUNT) — BIGINT
- autoanalyzeCount (AUTOANALYZE_COUNT) — BIGINT
- db_id (DB_ID) — INTEGER
- time (TIME) — TIMESTAMP
MfoPgStatDatabase5sec (MFO_PG_STAT_DATABASE_5SEC)
- numBackends (NUMBACKENDS) — BIGINT
- xactCommit (XACT_COMMIT) — BIGINT
- xactRollback (XACT_ROLLBACK) — BIGINT
- blksRead (BLKS_READ) — BIGINT
- blksHit (BLKS_HIT) — BIGINT
- tupReturned (TUP_RETURNED) — BIGINT
- tupFetched (TUP_FETCHED) — BIGINT
- tupInserted (TUP_INSERTED) — BIGINT
- upUpdated (TUP_UPDATED) — BIGINT
- tupDeleted (TUP_DELETED) — BIGINT
- conflicts (CONFLICTS) — BIGINT
- tempFiles (TEMP_FILES) — BIGINT
- tempBytes (TEMP_BYTES) — BIGINT
- deadlocks (DEADLOCKS) — BIGINT
- blkReadTime (BLK_READ_TIME) — DOUBLE PRECISION
- blkWriteTime (BLK_WRITE_TIME) — DOUBLE PRECISION
- db_id (DB_ID) — INTEGER
- time (TIME) — TIMESTAMP
StorageCycle (STORAGE_CYCLE)
- aliasNum (ALIAS_NUM) — INTEGER — Primary key — NOT NULL
- tableName (TABLE_NAME) — VARCHAR — Primary key
- tableCycle (TABLE_CYCLE) — INTEGER
TableSchedule (TABLE_SCHEDULE)
- aliasNum (ALIAS_NUM) — INTEGER — Primary key — NOT NULL
- pgStatDatabase5secSec (PG_STAT_DATABASE_5SEC_SEC) — INTEGER
User (USER)
- id (USER_PK) — SERIAL — Primary key — NOT NULL
- userId (USER_ID) — VARCHAR
- password (PASSWD) — VARCHAR
- userName (USER_NAME) — VARCHAR
- roleType (ROLE_TYPE) — VARCHAR