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)