aioc.sc_policy_connection_approval
This table keeps the records for the connection approval request and their details with following tables.
Column | Data Type | Description |
---|---|---|
Id | Character varying(255) | Table's primary key |
User_name | Character varying(255) | Username |
Host | Text | The IP address of the device |
Host_name | Text | The name of the device |
Status | Character varying(255) | The status of the created request |
Creation_date_time | Timestamp | Creation time of the request |
Sent | Boolean | If the request has been sent or not |
Sent_date_time | Timestamp | Sent time of the request |
Approved_rejected_user | Character varying(255) | Username of the approver/rejecter of the request |
Last_activity_date | Timestamp | Last Activity time of the request |
channel | Character varying(255) | The channel of sending the request |
Reason_for_connection | Character varying(1000) | The reason of creating the request |
Start_time | Timestamp | Start time of the connection reservation |
End_time | Timestamp | End time of the connection reservation |
Selected_username | Character varying(255) | Selected account name |
Selected_application | Character varying(255) | Selected application name |
Current_level | Bigint | Level of approval |
Workflow_id | Bigint | Foreign key to approval workflow table |
Approval_id | Bigint | Foreign key to connection approval dev table |