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