Table that stores information about discovered devices
Data model
Fields
| Field | Type | Description |
|---|---|---|
| address* | NVARCHAR (80) | Device IP Address |
| discovered_by | INT | Discovered device associated with conserver ID |
| discovery_date* | DATETIME | Device Discovery Date |
| name* | NVARCHAR (100) | Device Name |
| update_date | DATETIME | Device discovery update date |
Primary Key
| PK_ADM_DEVICE_DISCOVERY |
|---|
| address |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| device_id* | dbo.AAM_DEVICE | id | FK01_ADM_DEVICE_DISCOVERY |
| discovered_by | dbo.ADM_COMMUNICATION_NODE | id | FK02_ADM_DEVICE_DISCOVERY |