ATOP

Tables (27)

Admin (Untitled8)

  • adminId (Key) — Primary key — NOT NULL
  • email (Field)
  • name (Field2)
  • role (Field3)
  • pwd (Field4)

DISTS (Untitled3)

  • APPID (Key3) — Primary key — NOT NULL
  • VERSION (Key) — Primary key — NOT NULL
  • SCOPE (Key2) — Primary key — NOT NULL
  • EXECUTOR (Field)
  • EXECUTEDATE (Field2)
  • STATUS (Field3)
  • LATEST (Field4)
  • 긴급 (Field8)
  • DESCRIPTION (Field5)
  • CREATEDATE (Field6)
  • UPDATEDATE (Field7)

DISTS_DEPARTMENT (Untitled4)

  • APPID (Key4) — Primary key — NOT NULL
  • VERSION (Key2) — Primary key — NOT NULL
  • SCOPE (Key3) — Primary key — NOT NULL
  • TARGET (Key) — Primary key — NOT NULL
  • (Key5) — Foreign key → DISTS.VERSION — NOT NULL
  • APPID (Key32) — Foreign key → DISTS.APPID — NOT NULL
  • CREATEDATE (Field)
  • UPDATEDATE (Field2)

DISTS_FILES_INFO (Untitled6)

  • PATH (Key) — Primary key — NOT NULL
  • (Key4) — Foreign key → DIST_FILES.PATH — NOT NULL
  • SCOPE (Key22) — Foreign key → DIST_FILES.Key22 — NOT NULL
  • DESTPATH (Field)
  • TYPE (Field2)
  • ORDEROFEXECUTION (Field3)

DISTS_RESULT (Untitled18)

  • APPID (Key3) — Primary key — NOT NULL
  • VERSION (Key) — Primary key — NOT NULL
  • SCOPE (Key2) — Primary key — NOT NULL
  • DEVICEID (Key4) — Primary key — NOT NULL
  • IP (Field)
  • DEPARTCODE (Field2)

DIST_FILES (Untitled5)

  • APPID (Key3) — Primary key — NOT NULL
  • VERSION (Key) — Primary key — NOT NULL
  • SCOPE (Key2) — Primary key — NOT NULL
  • PATH (Key4) — Primary key — NOT NULL
  • (Key22) — Foreign key → DISTS.SCOPE — NOT NULL
  • COMPAREKEY (Field)

Department (Untitled7)

  • DEPARTCODE (Key) — Primary key — NOT NULL
  • DEPARTNAME (Field)
  • DEPARTLEVEL (Field2)
  • UPPERCODE (Field3)
  • CREATEDATE (Field4)
  • UPDATEDATE (Field5)

Device (Untitled)

  • DeviceID (Key) — Primary key — NOT NULL
  • APPID (Key2) — Primary key — NOT NULL
  • (Key3) — Foreign key → Department.DEPARTCODE — NOT NULL
  • OSTYPE (Field)
  • UNIQUEID (Field2)
  • IP (Field3)
  • SESSIONSTATE (Field4)
  • UPDATEVERSION (Field5)
  • UPDATESTATE (Field6)
  • UPDATESCOPE (Field7)
  • UPDATEDATE (Field8)
  • DISTVERSION (Field9)
  • DISTSCOPE (Field10)
  • DISTSTATE (Field11)
  • DISTUPDATEDATE (Field12)
  • STATE (Field13)
  • CREATEDATE (Field14)
  • UPDATEDATE (Field15)
  • LASTDATE (Field16)
  • DEPARTCODE (Field17)

DeviceState (monitoring) (Untitled11)

  • DEVICEID (Key3) — Primary key — NOT NULL
  • APPID (Key4) — Primary key — NOT NULL
  • USERID (Key5) — Primary key — NOT NULL
  • (Key2) — Foreign key → Device.DeviceID — NOT NULL
  • (Key22) — Foreign key → Device.APPID — NOT NULL
  • (Key) — Foreign key → User.USERID — NOT NULL

Group (Untitled12)

  • GROUPID (Key3) — Primary key — NOT NULL
  • (Key) — Foreign key → Department.DEPARTCODE — NOT NULL
  • (Key2) — Foreign key → User.USERID — NOT NULL
  • type_value (Field)
  • type (Field2)
  • policyGroupID (Field3)

IP? (Untitled9)

  • ID (Key) — Primary key — NOT NULL
  • class (Field)
  • IPINDEX (Field2)
  • deviceID (Field3)
  • departCode (Field4)

Organization (Untitled10)

  • ID (Key) — Primary key — NOT NULL
  • ORG (Field)
  • CREATEDAT (Field2)
  • UPDATEDAT (Field3)

Role (Untitled16)

  • INDEX (Key) — Primary key — NOT NULL
  • (Key2) — Foreign key → integrity_policy.ID — NOT NULL
  • (Key222) — Foreign key → integrity_policy.Key22 — NOT NULL
  • TYPE (Field)
  • PARAMETER (Field2)
  • SCRIPT (Field3)
  • WAIT (Field4)

UPDATE (CopyOfUntitled3)

  • APPID (Key3) — Primary key — NOT NULL
  • VERSION (Key) — Primary key — NOT NULL
  • SCOPE (Key2) — Primary key — NOT NULL
  • EXECUTOR (Field)
  • EXECUTEDATE (Field2)
  • STATUS (Field3)
  • LATEST (Field4)
  • 긴급 (Field8)
  • DESCRIPTION (Field5)
  • CREATEDATE (Field6)
  • UPDATEDATE (Field7)

UPDATE_DEPARTMENT (C)

  • APPID (Key4) — Primary key — NOT NULL
  • VERSION (Key2) — Primary key — NOT NULL
  • SCOPE (Key3) — Primary key — NOT NULL
  • TARGET (Key) — Primary key — NOT NULL
  • (Key32) — Foreign key → UPDATE.APPID — NOT NULL
  • CREATEDATE (Field)
  • UPDATEDATE (Field2)

UPDATE_FILES (CopyOfUntitled5)

  • APPID (Key3) — Primary key — NOT NULL
  • VERSION (Key) — Primary key — NOT NULL
  • SCOPE (Key2) — Primary key — NOT NULL
  • PATH (Key4) — Primary key — NOT NULL
  • (Key32) — Foreign key → UPDATE.APPID — NOT NULL
  • COMPAREKEY (Field)

UPDATE_FILES_INFO (CopyOfUntitled6)

  • PATH (Key) — Primary key — NOT NULL
  • (Key4) — Foreign key → UPDATE_FILES.PATH — NOT NULL
  • APPID (Key32) — Foreign key → UPDATE_FILES.Key32 — NOT NULL
  • DESTPATH (Field)
  • TYPE (Field2)
  • ORDEROFEXECUTION (Field3)

User (Untitled2)

  • USERID (Key) — Primary key — NOT NULL
  • (Key2) — Foreign key → Department.DEPARTCODE — NOT NULL
  • NAME (Field)
  • DUTY (Field2)
  • POSITION (Field3)
  • REGDATE (Field4)
  • APPLYDATE (Field5)
  • VALID (Field6)
  • CREATEDATE (Field7)
  • UPDATEDATE (Field8)
  • DEPARTCODE (Field9)

collection (Untitled13)

  • ID (Key) — Primary key — NOT NULL
  • (Key2) — Foreign key → gatherThresthold.ID — NOT NULL
  • (Key4) — Foreign key → sendOption.ID — NOT NULL
  • (Key3) — Foreign key → policy_group.ID — NOT NULL
  • gatgerThrestholdID (Field2)
  • sendOptionID (Field3)
  • collectionIfoID (Field4)

collection_info (Untitled22)

  • ID (Key) — Primary key — NOT NULL
  • (Key4) — Foreign key → collection.Key4 — NOT NULL
  • ID (Key3) — Foreign key → collection.Key3 — NOT NULL
  • collectionID (Field)
  • collectionPolicyID (Field2)

collection_policy (Untitled15)

  • ID (Key) — Primary key — NOT NULL
  • (Key2) — Foreign key → gatherThresthold.ID — NOT NULL
  • (Key4) — Foreign key → sendOption.ID — NOT NULL
  • (Key5) — Foreign key → conditions.ID — NOT NULL
  • (Key42) — Foreign key → collection_info.Key4 — NOT NULL
  • ID (Key3) — Foreign key → collection_info.ID — NOT NULL
  • collectionID (Field)
  • gatgerThrestholdID (Field2)
  • sendOptionID (Field3)
  • contidionsID (Field4)
  • collectionInfoID (Field5)
  • url (Field6)
  • intervalType (Field7)
  • interval (Field8)
  • columns (Field9)

conditions (Untitled21)

  • ID (Key) — Primary key — NOT NULL
  • id (Field)
  • level (Field2)
  • channel (Field3)
  • date (Field4)

gatherThresthold (Untitled19)

  • ID (Key) — Primary key — NOT NULL
  • cpuUasge (Field)
  • diskUsage (Field2)
  • memoryUsage (Field3)
  • intervalType (Field4)
  • interval (Field5)

integrity (Untitled14)

  • ID (Key) — Primary key — NOT NULL
  • (Key2) — Foreign key → policy_group.ID — NOT NULL
  • URL (Field)
  • integrityPolicyID (Field2)

integrity_policy (Untitled17)

  • ID (Key) — Primary key — NOT NULL
  • (Key22) — Foreign key → integrity.Key2 — NOT NULL
  • isTargetHome (Field)
  • isAlways (Field2)
  • integrityID (Field3)

policy_group (Untitled23)

  • ID (Key) — Primary key — NOT NULL
  • (Key3) — Foreign key → Group.GROUPID — NOT NULL
  • collectionID (Field)
  • integrityID (Field2)

sendOption (Untitled20)

  • ID (Key) — Primary key — NOT NULL
  • sentToCollector (Field)
  • interval Type (Field2)
  • interval (Field3)
  • maxRow (Field4)