felice

Tables (47)

KAFKA_CLUSTER

  • id — serial — Primary key — NOT NULL
  • name — varchar(255) — NOT NULL
  • type — varchar(255) — NOT NULL
  • version — varchar(255) — NOT NULL
  • acl — boolean
  • description — text
  • cipher_key — text — NOT NULL
  • updated_at — timestamp
  • updater — varchar(255)
  • created_at — timestamp — NOT NULL
  • creator — varchar(255) — NOT NULL
  • broker_hosts_id — serial — NOT NULL
  • zookeeper_hosts_id — serial — NOT NULL
  • kafka_security_id — serial — NOT NULL

ALARM_ACTION

  • id — serial — Primary key — NOT NULL
  • creator_type — varchar(255) — NOT NULL
  • cluster_name — varchar(255) — NOT NULL
  • action_name — varchar(255) — NOT NULL
  • description — text — NOT NULL
  • alertInterval — integer — NOT NULL
  • durationIn_min — integer — NOT NULL
  • message_title — varchar(255) — NOT NULL
  • message_body — text
  • alarm_rule_uid — integer — NOT NULL
  • operator — varchar(255)
  • value — varchar(255)
  • severity_code — smallint — NOT NULL
  • resource_name — varchar(255)
  • resource_parameter1 — text
  • resource_parameter2 — text
  • percentile — smallint
  • resource_name_pattern — smallint
  • is_on — boolean — NOT NULL
  • updated_at — timestamp
  • updater — varchar(255)
  • created_at — timestamp — NOT NULL
  • creator — varchar(255) — NOT NULL

ALARM_ACTION_GROUP

  • id — serial — Primary key — NOT NULL
  • action_id — serial — NOT NULL
  • group_id — serial — NOT NULL

ALARM_ACTION_TARGET

  • id — serial — Primary key — NOT NULL
  • action_id — serial — NOT NULL
  • target_id — serial — NOT NULL

ALARM_ALERT

  • id — VARCHAR(255) — Primary key — NOT NULL
  • action_id — serial — NOT NULL
  • alarm_rule_group — varchar(255) — NOT NULL — 기존: groupName
  • instance — varchar(255)
  • alarm_name — varchar(255) — NOT NULL
  • monitor — varchar(255) — NOT NULL
  • severity — smallint — NOT NULL
  • summary — varchar(255)
  • is_sent — boolean — NOT NULL
  • ends_at — timestamp
  • starts_at — timestamp
  • created_at — timestamp
  • sent_at — timestamp

ALARM_GROUP

  • id — serial — Primary key — NOT NULL
  • recipient_type — varchar(255) — NOT NULL
  • group_name — varchar(255) — NOT NULL
  • description — text
  • updated_at — timestamp
  • updater — varchar(255)
  • created_at — timestamp — NOT NULL
  • creator — varchar(255) — NOT NULL

ALARM_GROUP_TARGET

  • id — serial — Primary key — NOT NULL
  • target_id — serial — NOT NULL
  • group_id — serial — NOT NULL

ALARM_TARGET

  • id — serial — Primary key — NOT NULL
  • recipient_type — varchar(255) — NOT NULL
  • address — varchar(255) — NOT NULL
  • sub_address — varchar(255)
  • updated_at — timestamp
  • updater — varchar(255)
  • created_at — timestamp — NOT NULL
  • creator — varchar(255) — NOT NULL

ALARM_TARGET_CUSTOM_HEADER

  • id — setial — Primary key — NOT NULL
  • target_id — serial — NOT NULL
  • custom_header — text — NOT NULL

ALARM_TARGET_TAGS

  • id — bigserial — Primary key — NOT NULL
  • target_id — serial — NOT NULL
  • tag — varchar(50)

API_KEY

  • api_key — text — Primary key — NOT NULL
  • token — text
  • issued_felice_user_name — varchar(255) — NOT NULL — 기존: issuedFeliceUserName
  • title — varchar(255)
  • description — text
  • issued_at — timestamp
  • expired_at — timestamp

API_KEY_ACCESS_LOG

  • message_key — text — Primary key — NOT NULL
  • nano_time — integer
  • accessed_at — timestamp
  • requested_url — text
  • remote_ip — text

AUDIT_LOG

  • id — bigserial — Primary key — NOT NULL
  • felice_user_name — varchar(255) — NOT NULL — 기존: feliceUserName
  • view_id — Integer
  • remote_host — text
  • request_url — text
  • target — text
  • previous_value — text
  • current_value — text
  • created_at — timestamp — NOT NULL
  • audit_action_no — integer — NOT NULL

AWS_MSK_IAM

  • id — serial — Primary key — NOT NULL
  • access_key_id — text — NOT NULL
  • secret_access_key — text — NOT NULL
  • region — text — NOT NULL
  • msk_arn — text — NOT NULL

BROKER

  • id — serial — Primary key — NOT NULL
  • use_metric — boolean — NOT NULL
  • use_node_metric — boolean — NOT NULL

BROKER_HOST

  • id — serial — Primary key — NOT NULL
  • role — varchar(255) — NOT NULL
  • rack — varchar(255)
  • host_id — serial — NOT NULL
  • broker_id — serial — NOT NULL

CLIENT_METADATA

  • id — serial — Primary key — NOT NULL — 기존: clientMetadataId
  • cluster_name — varchar(255)
  • service_name — varchar(255) — NOT NULL
  • manager — varchar(255)
  • team — varchar(255)
  • client_type — varchar(255)
  • client_id — varchar(255)
  • description — text
  • updated_at — timestamp
  • updater — varchar(255)
  • created_at — timestamp — NOT NULL
  • creator — varchar(255) — NOT NULL

CLIENT_METADATA_TAGS

  • id — serial — Primary key — NOT NULL
  • client_metadata_id — serial — NOT NULL — 기존: clientMetadataId
  • tag — varcher(255) — NOT NULL

CLIENT_METADATA_TOPIC

  • id — serial — Primary key — NOT NULL
  • client_metadata_id — serial — NOT NULL
  • topic — var(255) — NOT NULL

CONNECT_HOST

  • id — serial — Primary key — NOT NULL
  • kafka_connect_id — serial — NOT NULL
  • host_id — serial — NOT NULL
  • username_n_password_id — serial

CONSUMER_MESSAGE_PER_SEC

  • cluster_name — varchar(255) — Primary key — NOT NULL
  • consumer_group_id — varchar(255) — NOT NULL
  • topic_name — varchar(255) — NOT NULL
  • partition_id — integer — NOT NULL
  • offset — integer — NOT NULL
  • commit_timestamp — integer — NOT NULL
  • consume_message_per_sec — integer — NOT NULL

CONSUMER_OFFSETS

  • id — serial — Primary key — NOT NULL
  • consumer_group_id — varchar(255) — NOT NULL
  • topic — varchar(255) — NOT NULL
  • partition — integer — NOT NULL
  • leader_epoch — integer — NOT NULL
  • offset — integer — NOT NULL
  • commit_timestamp — integer — NOT NULL

DATAMASKING_FIELD

  • id — serial — Primary key — NOT NULL
  • datamasking_policy_id — serial — NOT NULL
  • field — varchar(255) — NOT NULL

DATAMASKING_POLICY

  • id — serial — Primary key — NOT NULL
  • name — varchar(255) — NOT NULL
  • type — varchar(255) — NOT NULL
  • description — text
  • updated_at — timestamp
  • updater — varchar(255)
  • created_at — timestamp — NOT NULL
  • creator — varchar(255) — NOT NULL

DATAMASKING_TAG

  • id — serial — Primary key — NOT NULL
  • datamasking_policy_id — serial — NOT NULL
  • tag — varchar(255)

FELICE_NETWORK

  • id — serial — Primary key — NOT NULL
  • ip_address — varchar(255) — NOT NULL
  • description — text
  • updated_at — timestamp
  • updater — varchar(255)
  • created_at — timestamp — NOT NULL
  • creator — varchar(255) — NOT NULL

FELICE_NOTICE

  • id — serial — Primary key — NOT NULL
  • title — varchar(255) — NOT NULL
  • description — text
  • notice_type — varchar(255) — NOT NULL
  • start_date_time — varchar(255)
  • end_date_time — varchar(255)
  • updated_at — timestamp
  • updater — varchar(255)
  • created_at — timestamp — NOT NULL
  • creator — varchar(255) — NOT NULL

FELICE_ROLE

  • name — varchar(255) — Primary key — NOT NULL
  • type_code — smallint — NOT NULL
  • updated_at — timestamp
  • updater — varchar(255)
  • created_at — timestamp — NOT NULL
  • creator — varchar(255) — NOT NULL

FELICE_USER

  • name — varchar(255) — Primary key — NOT NULL — 기존: feliceUserName
  • password — varchar(255) — NOT NULL
  • Field — boolean — NOT NULL
  • is_pass_locked_policy — boolean — NOT NULL
  • is_password_expired — boolean — NOT NULL
  • is_locked — boolean — NOT NULL
  • last_login_at — timestamp
  • update_pass_at — timestamp
  • pass_expiration_date — timestamp
  • updated_at — timestamp
  • updater — varchar(255)
  • created_at — timestamp — NOT NULL
  • creator — varchar(255) — NOT NULL

FELICE_USER_GROUP

  • name — varchar(255) — Primary key — NOT NULL — 기존: groupName
  • desc — text
  • updated_at — timestamp
  • updater — varchar(255)
  • created_at — timestamp — NOT NULL
  • creator — varchar(255) — NOT NULL

FELICE_USER_GROUP_TAGS

  • id — serial — Primary key — NOT NULL
  • felice_user_group_name — varchar(255) — Foreign key → FELICE_USER_GROUP.name — NOT NULL — 기존: groupName
  • tag — varchar(255)

FELICE_USER_LABEL

  • id — serial — Primary key — NOT NULL
  • name — varchar(255) — NOT NULL — 기존: feliceUserName
  • id2 — serial — NOT NULL

FELICE_USER_LABEL_TARGET

  • id — serial — Primary key — NOT NULL
  • type — varchar(255) — NOT NULL
  • name — varchar(255) — NOT NULL
  • felice_user_label_id — serial — NOT NULL

FELICE_USER_ROLE_MAPPER

  • id — serial — Primary key — NOT NULL
  • felice_username_name — varchar(255) — NOT NULL — 기존: feliceUserName
  • felice_role_name — varchar(255) — NOT NULL

FELICE_USER_TAGS

  • id — serial — Primary key — NOT NULL
  • felice_user_name — varchar(255) — NOT NULL — 기존: feliceUserName
  • tag — varchar(255)

FELICE_USER_USER_GROUP

  • id — serial — Primary key — NOT NULL
  • felice_user_name — varchar(255) — NOT NULL — 기존: feliceUserName
  • felice_user_group_name — varchar(255) — NOT NULL — 기존: groupName

GSSAPI

  • id — serial — Primary key — NOT NULL
  • sasl_kerberos_service_name — text — NOT NULL
  • key_tab — text — NOT NULL
  • principal — text — NOT NULL

HOST

  • id — serial — Primary key — NOT NULL
  • name — varchar(255)
  • port — integer
  • metric_port — integer
  • node_metric_port — integer
  • updated_at — timestamp
  • updater — varchar(255)
  • created_at — timestamp — NOT NULL
  • creator — varchar(255) — NOT NULL

KAFKA_CONNECT

  • id — serial — Primary key — NOT NULL
  • kafka_cluster_id — serial — NOT NULL
  • name — varchar(255) — NOT NULL
  • use_metric — boolean — NOT NULL
  • use_node_metric — boolean — NOT NULL
  • cipher_key — text
  • updated_at — timestamp
  • updater — varchar(255)
  • created_at — timestamp — NOT NULL
  • creator — varchar(255) — NOT NULL

KAFKA_CONNECT_TOPIC

  • id — serial — Foreign key → KAFKA_CONNECT.id — NOT NULL
  • configs — varchar(255)
  • offsets — varchar(255)
  • status — varchar(255)

KAFKA_SECURITY

  • id — serial — Primary key — NOT NULL
  • on_felice — varchar(255) — NOT NULL — 기존: kafka_security_on_felice
  • protocol — varchar(255) — NOT NULL
  • gssapi_id — serial
  • oauthbearer_id — serial
  • username_n_password_id — serial
  • ssl_id — serial
  • ssl_cert_id — serial
  • aws_msk_iam_id — serial
  • updated_at — timestamp
  • updater — varchar(255)
  • created_at — timestamp — NOT NULL
  • creator — varchar(255) — NOT NULL

OAUTHBEARER

  • id — serial — Primary key — NOT NULL
  • sasl_oauthbearer_token_endpoint_url — text — NOT NULL
  • client_id — text — NOT NULL
  • client_secret — text — NOT NULL
  • scope — text
  • extension_organization_id — text

SSL

  • id — serial — Primary key — NOT NULL
  • truststore_location — text
  • truststore_password — text
  • keystore_location — text
  • keystore_password — text
  • key_password — text
  • endpointIdentification_algorithm — text

SSL_CERT

  • id — serial — Primary key — NOT NULL
  • jks_truststore — text — NOT NULL
  • jks_keystore — text — NOT NULL

USERNAME_N_PASSWORD

  • id — serial — Primary key — NOT NULL
  • username — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL

ZOOKEEPER

  • id — serial — Primary key — NOT NULL
  • username_n_password_id — serial
  • zookeeper_module — text
  • namespace — varchar(255)
  • use_metric — boolean
  • use_node_metric — boolean

ZOOKEEPER_HOST

  • id — serial — Primary key — NOT NULL
  • host_id — serial — NOT NULL
  • zookeeper_id — serial — NOT NULL