How-To Guides
...
Data Model Dictionary
Table Catalog

aioc.sc_policy_connection_approval

1min

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