dooray

Tables (7)

adt_common_global_env_infos

  • env_uuid — UUID — Primary key — NOT NULL
  • env_type_code — TEXT — NOT NULL
  • env_value_name — TEXT — NOT NULL
  • env_key — TEXT — NOT NULL
  • env_value — TEXT — NOT NULL
  • env_value_min — TEXT
  • env_value_max — TEXT
  • env_value_default — TEXT
  • env_comment — TEXT
  • maingroup_type_code — TEXT
  • subgroup_type_code — TEXT
  • subgroup_order — BIGINT
  • code_order — BIGINT
  • product_code — TEXT
  • env_sub_value_array — TEXT
  • env_ref_parent_code — TEXT
  • env_value_input_type — TEXT — NOT NULL
  • use_tf — BOOLEAN — NOT NULL
  • created_by — UUID
  • created_at — TIMESTAMPTZ
  • updated_by — UUID
  • updated_at — TIMESTAMPTZ

adt_logging_audit_logs

  • timestamp — TIMESTAMPTZ — Primary key — NOT NULL
  • log_id — SERIAL — NOT NULL
  • request_id — VARCHAR(100)
  • event — VARCHAR(50)
  • api — VARCHAR(255)
  • method — VARCHAR(10)
  • client_ip — VARCHAR(50)
  • user_code — VARCHAR(100)
  • email — VARCHAR(255)
  • drm_server — VARCHAR(100)
  • status_code — INTEGER
  • elapsed_ms — INTEGER
  • filename — VARCHAR(500)
  • drm_label — VARCHAR(255)

adt_logging_auth_logs

  • timestamp — TIMESTAMPTZ — Primary key — NOT NULL
  • log_id — SERIAL — NOT NULL
  • request_id — VARCHAR(100)
  • event — VARCHAR(50)
  • client_ip — VARCHAR(50)
  • user_code — VARCHAR(100)
  • email — VARCHAR(255)
  • jwt_expiry_secs — INTEGER

adt_summary_stats_by_user_per_minute

  • bucket — TIMESTAMPTZ
  • user_id — VARCHAR(1)
  • log_count — BIGINT
  • timestamp — TIMESTAMPTZ — Foreign key → adt_logging_audit_logs.timestamp — NOT NULL

adt_summary_stats_total_per_hour

  • bucket — TIMESTAMPTZ
  • log_count — BIGINT
  • unique_ips — BIGINT
  • unique_users — BIGINT
  • error_count — BIGINT
  • avg_elapsed_ms — NUMERIC
  • timestamp — TIMESTAMPTZ — Foreign key → adt_logging_audit_logs.timestamp — NOT NULL

adt_summary_stats_total_per_minute

  • bucket — TIMESTAMPTZ
  • log_count — BIGINT
  • unique_ips — BIGINT
  • error_count — BIGINT
  • timestamp — TIMESTAMPTZ — Foreign key → adt_logging_audit_logs.timestamp — NOT NULL

mng_admin_user_infos

  • admin_uuid — UUID — Primary key — NOT NULL
  • admin_id — TEXT — NOT NULL
  • admin_password — TEXT — NOT NULL
  • admin_name — TEXT — NOT NULL
  • admin_email — VARCHAR(255)
  • admin_phone — VARCHAR(50)
  • admin_role — TEXT — NOT NULL
  • status_cd — TEXT — NOT NULL
  • last_login_at — TIMESTAMPTZ
  • last_login_ip — VARCHAR(50)
  • login_fail_cnt — BIGINT — NOT NULL
  • created_by — UUID
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_by — UUID
  • updated_at — TIMESTAMPTZ — NOT NULL