Table ocum.datasource Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id int 10
objVersion int 10
objectName varchar 255
resourceKey varchar 512
healthStatus int 10
communicationStatus int 10  √  null
acquisitionStatus int 10  √  null
acquisitionMessage longtext 2147483647  √  null
analysisStatus int 10  √  null
analysisMessage longtext 2147483647  √  null
operation int 10  √  1
operationState int 10  √  0
operationStartTime timestamp 19  √  null
operationEndTime timestamp 19  √  null
lastOperationSuccessTime timestamp 19  √  null
lastOperationFailureTime timestamp 19  √  null
pingable bit 1 b'1'
objectResourceKey varchar 512 1

Table contained 0 rows at Tue Apr 23 05:29 EDT 2019

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
objectName Must be unique Asc DataSource_objectName_UQ