CSEBase
Tables (19)
access_control_policy
- id — SERIAL
- acp_id — VARCHAR(255) — NOT NULL
- resource_name — VARCHAR(255) — NOT NULL
- parent_resource_id — INT
- privileges — TEXT — NOT NULL
- self_privileges — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- labels — TEXT
ae
- id — SERIAL
- ae_id — VARCHAR(255) — NOT NULL
- resource_name — VARCHAR(255) — NOT NULL
- app_id — VARCHAR(255) — NOT NULL
- app_name — VARCHAR(255)
- parent_cse_id — INT — NOT NULL
- point_of_access — TEXT
- request_reachability — BOOLEAN — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- node_link — VARCHAR(255)
- acpi — TEXT
- labels — TEXT
analytics
- id — SERIAL
- analytics_id — VARCHAR(255) — NOT NULL
- resource_name — VARCHAR(255) — NOT NULL
- target_resource_id — VARCHAR(255) — NOT NULL
- analysis_type — VARCHAR(50) — NOT NULL
- analysis_result — TEXT
- execution_time — TIMESTAMP
- status — VARCHAR(50)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- labels — TEXT
audit_log
- id — SERIAL
- log_id — VARCHAR(255) — NOT NULL
- resource_id — VARCHAR(255) — NOT NULL
- resource_name — VARCHAR(255)
- action — VARCHAR(50) — NOT NULL
- performed_by — VARCHAR(255) — NOT NULL
- performed_at — TIMESTAMP
- description — TEXT
- result — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMP
- labels — TEXT
container
- id — SERIAL
- container_id — VARCHAR(255) — NOT NULL
- resource_name — VARCHAR(255) — NOT NULL
- parent_ae_id — INT — NOT NULL
- parent_node_id — INT
- max_nr_of_instances — INTEGER
- max_byte_size — INTEGER
- current_nr_of_instances — INTEGER
- current_byte_size — INTEGER
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- acpi — TEXT
- labels — TEXT
content_instance
- id — SERIAL
- content_instance_id — VARCHAR(255) — NOT NULL
- resource_name — VARCHAR(255) — NOT NULL
- parent_container_id — INT — NOT NULL
- content_info — VARCHAR(255)
- content — TEXT — NOT NULL
- content_size — INTEGER
- creation_time — TIMESTAMP
- expiry_time — TIMESTAMP
- labels — TEXT
- state_tag — INTEGER
- creator — VARCHAR(255)
cse
- id — SERIAL
- cse_id — VARCHAR(255) — NOT NULL
- resource_name — VARCHAR(255) — NOT NULL
- cse_type — VARCHAR(50) — NOT NULL
- csi — VARCHAR(255) — NOT NULL
- point_of_access — TEXT
- supported_resource_types — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- acpi — TEXT
- srt — TEXT
- node_link — VARCHAR(255)
- notification_congestion_policy — TEXT
- management_uri — TEXT
- csebase_id — INT
csebase
- id — SERIAL
- cse_id — VARCHAR(255) — NOT NULL
- resource_name — VARCHAR(255) — NOT NULL
- cse_type — VARCHAR(50) — NOT NULL
- supported_resource_types — TEXT
- point_of_access — TEXT
- node_link — VARCHAR(255)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- notification_congestion_policy — TEXT
- csi — VARCHAR(255) — NOT NULL
- srt — TEXT
- acpi — TEXT
device_capability
- id — SERIAL
- capability_id — VARCHAR(255) — NOT NULL
- resource_name — VARCHAR(255) — NOT NULL
- device_id — VARCHAR(255) — NOT NULL
- capabilities — TEXT — NOT NULL
- status — VARCHAR(50)
- last_checked_at — TIMESTAMP
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- labels — TEXT
event_handler
- id — SERIAL
- event_handler_id — VARCHAR(255) — NOT NULL
- resource_name — VARCHAR(255) — NOT NULL
- trigger_condition — TEXT — NOT NULL
- action_type — VARCHAR(50) — NOT NULL
- target_resource_id — VARCHAR(255) — NOT NULL
- action_params — TEXT
- status — VARCHAR(50)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- labels — TEXT
exec_instance
- id — SERIAL
- exec_instance_id — VARCHAR(255) — NOT NULL
- resource_name — VARCHAR(255) — NOT NULL
- parent_mgmt_cmd_id — INT — NOT NULL
- exec_status — VARCHAR(50) — NOT NULL
- exec_result — TEXT
- exec_start_time — TIMESTAMP
- exec_end_time — TIMESTAMP
- exec_target — VARCHAR(255)
- creation_time — TIMESTAMP
- labels — TEXT
- retry_count — INTEGER
- exec_mode — VARCHAR(50)
firmware
- id — SERIAL
- firmware_id — VARCHAR(255) — NOT NULL
- resource_name — VARCHAR(255) — NOT NULL
- device_id — VARCHAR(255) — NOT NULL
- version — VARCHAR(50) — NOT NULL
- download_uri — TEXT
- update_status — VARCHAR(50)
- last_update_time — TIMESTAMP
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- labels — TEXT
group
- id — SERIAL
- group_id — VARCHAR(255) — NOT NULL
- resource_name — VARCHAR(255) — NOT NULL
- member_ids — TEXT — NOT NULL
- max_nr_of_members — INTEGER
- current_nr_of_members — INTEGER
- group_type — VARCHAR(50)
- status — VARCHAR(50)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- acpi — TEXT
- labels — TEXT
location_policy
- id — SERIAL
- location_policy_id — VARCHAR(255) — NOT NULL
- resource_name — VARCHAR(255) — NOT NULL
- resource_id — VARCHAR(255) — NOT NULL
- latitude — DECIMAL(10, 7)
- longitude — DECIMAL(10, 7)
- altitude — DECIMAL(10, 2)
- location_source — VARCHAR(50)
- update_frequency — INTEGER
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- labels — TEXT
mgmt_cmd
- id — SERIAL
- mgmt_cmd_id — VARCHAR(255) — NOT NULL
- resource_name — VARCHAR(255) — NOT NULL
- cmd_type — VARCHAR(50) — NOT NULL
- target_id — VARCHAR(255) — NOT NULL
- exec_req_args — TEXT
- exec_mode — VARCHAR(50)
- exec_frequency — INTEGER
- exec_status — VARCHAR(50)
- exec_result — VARCHAR(255)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- expiration_time — TIMESTAMP
- requester_ae_id — VARCHAR(255)
- labels — TEXT
node
- id — SERIAL
- node_id — VARCHAR(255) — NOT NULL
- resource_name — VARCHAR(255) — NOT NULL
- node_type — VARCHAR(50)
- parent_cse_id — INT — NOT NULL
- hosted_ae_ids — TEXT
- mgmt_link — VARCHAR(255)
- point_of_access — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- acpi — TEXT
- status — VARCHAR(50)
- labels — TEXT
notification_log
- id — SERIAL
- notification_id — VARCHAR(255) — NOT NULL
- subscription_id — VARCHAR(255) — NOT NULL
- target_uri — TEXT — NOT NULL
- notification_content — TEXT — NOT NULL
- status — VARCHAR(50) — NOT NULL
- timestamp — TIMESTAMP
- response_code — VARCHAR(50)
- retry_count — INTEGER
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- labels — TEXT
remote_cse
- id — SERIAL
- remote_cse_id — VARCHAR(255) — NOT NULL
- resource_name — VARCHAR(255) — NOT NULL
- cse_type — VARCHAR(50) — NOT NULL
- csi — VARCHAR(255) — NOT NULL
- point_of_access — TEXT
- cse_status — VARCHAR(50)
- last_connection_time — TIMESTAMP
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- acpi — TEXT
- labels — TEXT
- csebase_id — INT
subscription
- id — SERIAL
- subscription_id — VARCHAR(255) — NOT NULL
- resource_name — VARCHAR(255) — NOT NULL
- parent_resource_id — INT — NOT NULL
- notification_uri — TEXT — NOT NULL
- event_notification_criteria — TEXT
- expiration_time — TIMESTAMP
- notification_content_type — VARCHAR(50)
- notification_event_category — VARCHAR(50)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- subscriber_ae_id — VARCHAR(255)
- labels — TEXT