Auction

Tables (43)

ALERT

  • LOG_TIME — NUMBER(20) — Primary key — NOT NULL
  • DATABASE_ID — VARCHAR(40) — Foreign key → INSTANCE.DATABASE_ID — NOT NULL
  • INSTANCE_ID — VARCHAR(40) — Foreign key → INSTANCE.ID — NOT NULL
  • ID — NUMBER(20)
  • TITLE — VARCHAR(50) — NOT NULL
  • DESCRIPTION — VARCHAR(255) — NOT NULL
  • ALERT_LEVEL — NUMBER(1) — NOT NULL
  • COMPLETED — CHAR(1) — NOT NULL
  • ALERT_RULE_ID — VARCHAR(40) — Foreign key → ALERT_RULE.ID
  • ALERT_MONITORING_ID — VARCHAR(40) — Foreign key → ALERT_MONITORING.ID

ALERT_MONITORING

  • ID — VARCHAR(40) — Primary key — NOT NULL
  • TITLE — VARCHAR(50) — NOT NULL
  • DESCRIPTION — VARCHAR(255)
  • SCHEDULED_TIME — NUMBER(20) — NOT NULL
  • STATUS — NUMBER(1) — NOT NULL
  • LAST_CHECKED_TIME — NUMBER(20)
  • CREATED_AT — NUMBER(20) — NOT NULL
  • UPDATED_AT — NUMBER(20)
  • ALERT_RULE_ID — VARCHAR(40) — Foreign key → ALERT_RULE.ID — NOT NULL
  • INSTANCE_ID — VARCHAR(40) — Foreign key → INSTANCE.ID — NOT NULL
  • DATABASE_ID — VARCHAR(40) — Foreign key → INSTANCE.DATABASE_ID — NOT NULL

ALERT_RULE

  • ID — VARCHAR(40) — Primary key — NOT NULL
  • TITLE — VARCHAR(50) — NOT NULL
  • DESCRIPTION — VARCHAR(255)
  • ALERT_LEVEL — NUMBER(1) — NOT NULL
  • TIME_INTERVAL — NUMBER(20) — NOT NULL
  • REPEATED_COUNT — NUMBER(20) — NOT NULL
  • TIME_UNIT — CHAR(1) — NOT NULL
  • STATEFUL — CHAR(1) — NOT NULL
  • METRIC_NAME — VARCHAR(50)
  • METRIC_OP — VARCHAR(5)
  • METRIC_THRESHOLD — NUMBER(20)
  • KEYWORD — VARCHAR(255)
  • IS_IMMEDIATE — CHAR(1) — NOT NULL
  • CREATED_AT — NUMBER(20) — NOT NULL
  • UPDATED_AT — NUMBER(20)
  • INSTANCE_ID — VARCHAR(40) — Foreign key → INSTANCE.ID — NOT NULL
  • DATABASE_ID — VARCHAR(40) — Foreign key → INSTANCE.DATABASE_ID — NOT NULL

ARCHIVE

  • DATA_ID — VARCHAR(40)
  • LOG_ID — VARCHAR(40)
  • DATABASE_ID — VARCHAR(40) — Foreign key → DATABASE.ID
  • NAME — VARCHAR(40)
  • EXPIRED_AT — NUMBER(20)
  • AUTO_CREATION — VARCHAR(10)
  • START_SEQUENCE — NUMBER(10)
  • END_SEQUENCE — NUMBER(10)
  • SNAPSHOT_CREATED_AT — NUMBER(20)
  • END_TSN — NUMBER(20)
  • ARCHIVE_CREATED_AT — NUMBER(20)
  • STATUS — VARCHAR(30)

ARCHIVE_POLICY

  • DATABASE_ID — VARCHAR(40) — Foreign key → DATABASE.ID
  • CYCLE_TYPE — VARCHAR(10)
  • CYCLE_PERIOD — NUMBER(5)
  • EXPIRE_TYPE — VARCHAR(10)
  • EXPIRE_PERIOD — NUMBER(5)
  • START_TIME — NUMBER(20)
  • AUTO_CREATION — VARCHAR(10)

ASSESS_HISTORY

  • ID — NUMBER(20) — Primary key — NOT NULL
  • SOURCE_DATABASE — VARCHAR(256) — NOT NULL
  • SOURCE_NAME — VARCHAR(256) — NOT NULL
  • TARGET_DATABASE — VARCHAR(256) — NOT NULL
  • SOURCE_IP — VARCHAR(256) — NOT NULL
  • SOURCE_PORT — NUMBER(20) — NOT NULL
  • SOURCE_USER — VARCHAR(256) — NOT NULL
  • STATE — VARCHAR(15) — NOT NULL
  • MODE — VARCHAR(256)
  • T_UP_VERSION — VARCHAR(256)
  • RATIO — VARCHAR(256)
  • SUPPORT_COUNT — NUMBER(20)
  • ASSESS_COUNT — NUMBER(20)
  • TABLESPACE_RATIO — VARCHAR(256)
  • TABLESPACE_SUPPORT_COUNT — NUMBER(20)
  • TABLESPACE_ASSESS_COUNT — NUMBER(20)
  • TABLE_RATIO — VARCHAR(256)
  • TABLE_SUPPORT_COUNT — NUMBER(20)
  • TABLE_ASSESS_COUNT — NUMBER(20)
  • INDEX_RATIO — VARCHAR(256)
  • INDEX_SUPPORT_COUNT — NUMBER(20)
  • INDEX_ASSESS_COUNT — NUMBER(20)
  • VIEW_RATIO — VARCHAR(256)
  • VIEW_SUPPORT_COUNT — NUMBER(20)
  • VIEW_ASSESS_COUNT — NUMBER(20)
  • TRIGGER_RATIO — VARCHAR(256)
  • TRIGGER_SUPPORT_COUNT — NUMBER(20)
  • TRIGGER_ASSESS_COUNT — NUMBER(20)
  • PROCEDURE_RATIO — VARCHAR(256)
  • PROCEDURE_SUPPORT_COUNT — NUMBER(20)
  • PROCEDURE_ASSESS_COUNT — NUMBER(20)
  • CHARSET — VARCHAR(256)
  • DATAFILE — VARCHAR(256)
  • BLOCK_SIZE — VARCHAR(256)
  • SCHEDULE — VARCHAR(256)
  • USER_SCHEMA — VARCHAR(256)
  • TABLE — VARCHAR(256)
  • FUNCTION — VARCHAR(256)
  • DB_LINK — VARCHAR(256)
  • CLUSTERED_TABLE — VARCHAR(256)
  • VIEW — VARCHAR(256)
  • INDEX — VARCHAR(256)
  • BITMAP_INDEX — VARCHAR(256)
  • SYNONYM — VARCHAR(256)
  • UDT — VARCHAR(256)
  • BLOB — VARCHAR(256)
  • NCLOB — VARCHAR(256)
  • LONG_RAW — VARCHAR(256)
  • LOG_MODE — VARCHAR(256)
  • DATAFILE_SIZE — VARCHAR(256)
  • MAX_ROWS — VARCHAR(256)
  • JOB — VARCHAR(256)
  • TABLE_SPACE — VARCHAR(256)
  • PROCEDURE — VARCHAR(256)
  • PACKAGES — VARCHAR(256)
  • IOT — VARCHAR(256)
  • PARTITIONED_TABLE — VARCHAR(256)
  • M_VIEW — VARCHAR(256)
  • FUNCTION_BASED_INDEX — VARCHAR(256)
  • TRIGGER — VARCHAR(256)
  • … +7

BACKUP_HISTORY

  • ID — NUMBER(20)
  • TYPE — VARCHAR(10)
  • EVENT — VARCHAR(10)
  • NAME — VARCHAR(40)
  • BACKUP_ID — VARCHAR(40)
  • STARTED_AT — NUMBER(20)
  • EXPIRED_AT — NUMBER(20)
  • STATUS — VARCHAR(10)
  • AUTO_CREATION — VARCHAR(10)
  • DATABASE_ID — VARCHAR(40) — Foreign key → DATABASE.ID

BOOT_DOWN_LOG

  • LOG_ID — NUMBER(20)
  • LOG_TIME — NUMBER(20) — NOT NULL
  • INSTANCE_ID — VARCHAR(40) — Foreign key → INSTANCE.ID — NOT NULL
  • DATABASE_ID — VARCHAR(40) — Foreign key → INSTANCE.DATABASE_ID — NOT NULL
  • EVENT — VARCHAR(10) — NOT NULL
  • OPERATION_MODE — VARCHAR(10) — NOT NULL
  • MSG — VARCHAR(1000) — NOT NULL
  • STATUS — VARCHAR(10) — NOT NULL

CURRENT_PARAMETER

  • NAME — VARCHAR(64)
  • TYPE — VARCHAR(8)
  • DEFAULT_VALUE — VARCHAR(1024)
  • CURRENT_VALUE — VARCHAR(1024)
  • TIP_VALUE — VARCHAR(1024)
  • IS_OPTIONAL — CHAR(1)
  • IS_ADJUSTABLE — CHAR(1)
  • IS_DYNAMIC — CHAR(1)
  • BOUND — VARCHAR(8)
  • GLOBAL — VARCHAR(8)
  • STATUS — VARCHAR(16)
  • INSTANCE_ID — VARCHAR(40) — Foreign key → INSTANCE.ID
  • DATABASE_ID — VARCHAR(40) — Foreign key → INSTANCE.DATABASE_ID

DATABASE

  • ID — VARCHAR(40) — Primary key — NOT NULL
  • ALIAS — VARCHAR(40) — NOT NULL
  • DB_NAME — VARCHAR(40) — NOT NULL
  • DB_TYPE — VARCHAR(15) — NOT NULL
  • IS_ACTIVE_CLUSTER — CHAR(1) — NOT NULL
  • IS_STANDBY_CLUSTER — CHAR(1) — NOT NULL
  • DESCRIPTION — VARCHAR(1000)
  • USERNAME — VARCHAR(128) — NOT NULL
  • PASSWORD — VARCHAR(128) — NOT NULL
  • CREATED_AT — NUMBER(20)
  • ORDER_ID — NUMBER(20) — Foreign key → ORDER_INFO.ORDER_ID — NOT NULL

DB_COUNT

  • LOG_TIME — NUMBER(20) — Primary key — NOT NULL
  • DATABASE_ID — VARCHAR(40) — Foreign key → INSTANCE.DATABASE_ID — NOT NULL
  • INSTANCE_ID — VARCHAR(40) — Foreign key → INSTANCE.ID — NOT NULL
  • LOCK_COUNT — NUMBER(10)
  • ACTIVE_SESSION_COUNT — NUMBER(10)
  • TOTAL_SESSION_COUNT — NUMBER(10)

DB_DATAFILE

  • LOG_TIME — NUMBER(20) — Primary key — NOT NULL
  • TABLESPACE_ID — NUMBER(20) — Primary key — NOT NULL
  • ID — NUMBER(20) — Primary key — NOT NULL
  • DATABASE_ID — VARCHAR(40) — Foreign key → DATABASE.ID — NOT NULL
  • TABLESPACE_NAME — VARCHAR(40) — NOT NULL
  • NAME — VARCHAR(200) — NOT NULL
  • STATUS — VARCHAR(10)
  • CURRENT_SIZE — NUMBER(20)
  • USED_SIZE — NUMBER(20)
  • FREE_SIZE — NUMBER(20)
  • MAX_SIZE — NUMBER(20)
  • USED — VARCHAR(8)
  • USED_SIZE_BY_MAX_SIZE — VARCHAR(8)
  • AUTO_EXTEND — VARCHAR(1)
  • NEXT — NUMBER(20)
  • PHYSICAL_READS — NUMBER(20)
  • PHYSICAL_WRITES — NUMBER(20)
  • SINGLE_BLOCK_READS — NUMBER(20)

DB_D_TX

  • LOG_TIME — NUMBER(20) — Primary key — NOT NULL
  • INSTANCE_ID — VARCHAR(40) — Primary key — NOT NULL
  • DATABASE_ID — VARCHAR(40) — Primary key — NOT NULL
  • SID — NUMBER(20) — Primary key — NOT NULL
  • UNDO_SEGMENT — NUMBER(20) — NOT NULL
  • STATE — NUMBER(20) — NOT NULL
  • TYPE — NUMBER(20) — NOT NULL
  • START_ROW — NUMBER(20) — NOT NULL
  • START_SEQ — NUMBER(20) — NOT NULL
  • EXP_RB_TIME — NUMBER(20) — NOT NULL

DB_MEMORY

  • LOG_TIME — NUMBER(20) — Primary key — NOT NULL
  • DATABASE_ID — VARCHAR(40) — Foreign key → INSTANCE.DATABASE_ID — NOT NULL
  • INSTANCE_ID — VARCHAR(40) — Foreign key → INSTANCE.ID — NOT NULL
  • PGA_USAGE — NUMBER(20)
  • PGA_MAX_MEMORY — NUMBER(20)
  • SGA_USAGE — NUMBER(20)
  • SGA_MAX_MEMORY — NUMBER(20)
  • TOTAL_MEMORY — NUMBER(20)

DB_PROCESS

  • LOG_TIME — NUMBER(20) — Primary key — NOT NULL
  • INSTANCE_ID — VARCHAR(40) — Primary key — NOT NULL
  • DATABASE_ID — VARCHAR(40) — Primary key — NOT NULL
  • PROCESS_ID — NUMBER(5) — Primary key — NOT NULL
  • PROCESS_NAME — VARCHAR(40)
  • CPU_TIME — NUMBER(20)
  • CPU_USAGE — NUMBER(2)
  • ALLOCATED_PGA — NUMBER(20)
  • USED_PGA — NUMBER(20)

DB_SCHEMA_OBJECT

  • LOG_TIME — NUMBER(20) — Primary key — NOT NULL
  • INSTANCE_ID — VARCHAR(40) — Primary key — NOT NULL
  • DATABASE_ID — VARCHAR(40) — Primary key — NOT NULL
  • OBJECT_ID — VARCHAR(255) — Primary key — NOT NULL
  • OBJECT_NAME — VARCHAR(255) — NOT NULL
  • TYPE — VARCHAR(255) — NOT NULL
  • STATUS — VARCHAR(255) — NOT NULL
  • CREATED — VARCHAR(255) — NOT NULL
  • LAST_DDL_TIME — VARCHAR(255) — NOT NULL

DB_SEGMENT

  • LOG_TIME — NUMBER(20) — Primary key — NOT NULL
  • DATABASE_ID — VARCHAR(40) — Primary key — NOT NULL
  • OWNER — VARCHAR(128)
  • SEGMENT_NAME — VARCHAR(128)
  • PARTITION_NAME — VARCHAR(128)
  • SEGMENT_TYPE — VARCHAR(18)
  • TABLESPACE_NAME — VARCHAR(128)
  • HEADER_FILE — NUMBER
  • HEADER_BLOCK — NUMBER
  • BLOCKS — NUMBER
  • EXTENTS — NUMBER
  • RELATIVE_FNO — NUMBER
  • BUFFER_POOL — VARCHAR(7)
  • MAX_EXTENTS — NUMBER
  • BYTES — NUMBER
  • INITIAL_EXTENT — NUMBER
  • NEXT_EXTENT — NUMBER
  • PARTITIONED — CHAR(1)
  • LOGGING — CHAR(1)
  • MIN_EXTENTS — NUMBER

DB_SESSION

  • ID — NUMBER(20)
  • LOG_TIME — NUMBER(20) — NOT NULL
  • SID — NUMBER(10)
  • SERIAL_NUMBER — NUMBER(10)
  • INSTANCE_ID — VARCHAR(40) — NOT NULL
  • DATABASE_ID — VARCHAR(40) — NOT NULL
  • ACTION — VARCHAR(255)
  • AUDSID — NUMBER(10)
  • CLIENT_IDENTIFIER — VARCHAR(255)
  • CLIENT_INFO — VARCHAR(255)
  • CLIENT_PID — NUMBER(10)
  • COMMAND — VARCHAR(255)
  • CONSUMED_CPU_TIME — NUMBER(20)
  • CONSUMER_GROUP — VARCHAR(255)
  • IP_ADDR — VARCHAR(255)
  • LOGON_TIME — NUMBER
  • CLIENT_HOSTNAME — VARCHAR(255)
  • MODULE — VARCHAR(255)
  • OS_USER — VARCHAR(255)
  • OS_THR_ID — NUMBER(10)
  • PDDL_STATUS — VARCHAR(255)
  • PDML_ENABLED — VARCHAR(255)
  • PDML_STATUS — VARCHAR(255)
  • PGA_USED_MEM — NUMBER(20)
  • PID — NUMBER(10)
  • PQ_STATUS — VARCHAR(255)
  • PREV_CHILD_NUMBER — VARCHAR(255)
  • PREV_SQL_ID — VARCHAR(255)
  • PROG_NAME — VARCHAR(255)
  • ROW_WAIT_OBJ_ID — NUMBER(10)
  • ROW_WAIT_ROW_NO — NUMBER(10)
  • SCHEMA_NAME — VARCHAR(255)
  • SCHEMA_NUMBER — NUMBER(10)
  • SQL_CHILD_NUMBER — VARCHAR(255)
  • SQL_ET — NUMBER(20)
  • SQL_ID — VARCHAR(255)
  • SQL_TRACE — VARCHAR(255)
  • STATE — VARCHAR(255)
  • STATUS — VARCHAR(255)
  • TERMINAL — VARCHAR(255)
  • TYPE — VARCHAR(255)
  • USERNAME — VARCHAR(255)
  • USER_ID — NUMBER(20)
  • WAIT_EVENT — VARCHAR(255)
  • WAIT_TIME — NUMBER(20)
  • WLOCK_WAIT — VARCHAR(255)
  • WTHR_ID — NUMBER(10)
  • LEADER_PID — NUMBER(10)
  • CLIENT_PORT — NUMBER(10)
  • XACT_START — NUMBER(20)
  • STATE_CHANGE — NUMBER(20)
  • WAIT_EVENT_TYPE — VARCHAR(255)
  • BACKEND_XID — NUMBER(20)
  • BACKEND_XMIN — NUMBER(20)
  • QUERY — VARCHAR(8095)

DB_STAT

  • ID — NUMBER(20)
  • LOG_TIME — NUMBER(20) — NOT NULL
  • INSTANCE_ID — VARCHAR(40) — NOT NULL
  • DATABASE_ID — VARCHAR(40) — NOT NULL
  • BLOCK_DISK_READ — NUMBER(20)
  • MULTI_BLOCK_DISK_READ — NUMBER(20)
  • CONSISTENT_MULTI_BLOCK_GETS — NUMBER(20)
  • CONSISTENT_BLOCK_GETS — NUMBER(20)
  • CONSISTENT_BLOCK_GETS_READONLY_PIN — NUMBER(20)
  • CONSISTENT_BLOCK_GETS_EXAMINE — NUMBER(20)
  • CONSISTENT_BLOCK_GETS_EXAMINE_NOWAIT — NUMBER(20)
  • CURRENT_BLOCK_GETS — NUMBER(20)
  • CURRENT_BLOCK_GETS_NOWAIT — NUMBER(20)
  • CURRENT_BLOCK_GETS_EXAMINE — NUMBER(20)
  • CURRENT_BLOCK_GETS_EXAMINE_NOWAIT — NUMBER(20)
  • TOTAL_PARSE_COUNT — NUMBER(20)
  • HARD_PARSE_COUNT — NUMBER(20)
  • REDO_ENTRIES — NUMBER(20)
  • REDO_LOG_SIZE — NUMBER(20)
  • REDO_WRITE — NUMBER(20)
  • REDO_WRITE_MULTI — NUMBER(20)
  • PHYSICAL_WRITE — NUMBER(20)
  • REQ_SERVICE_TIME — NUMBER(20)
  • DB_CPU_TIME — NUMBER(20)
  • COMMITS — NUMBER(20)
  • ROLLBACKS — NUMBER(20)
  • EXECUTE_COUNT — NUMBER(20)
  • NUMBER_OF_WAIT_LOCKS_GRANTED_FROM_THE_MASTER — NUMBER(20)
  • TOTAL_ROUND_TRIP_TIMES_TO_GRANT_WAIT_LOCK — NUMBER(20)
  • CURRENT_BLOCK_RECEIVED — NUMBER(20)
  • CURRENT_BLOCK_RECEIVED_RTT — NUMBER(20)
  • CR_BLOCK_RECEIVED — NUMBER(20)
  • CR_BLOCK_RECEIVED_RTT — NUMBER(20)
  • CURRENT_BLOCK_SEND — NUMBER(20)
  • CURRENT_BLOCK_SEND_FAIL — NUMBER(20)
  • CURRENT_BLOCK_SEND_TIME — NUMBER(20)
  • CR_BLOCK_SEND — NUMBER(20)
  • CR_BLOCK_SEND_FAIL — NUMBER(20)
  • CR_BLOCK_SEND_TIME — NUMBER(20)
  • INC_MESSAGES_RECEIVED — NUMBER(20)
  • INC_MESSAGES_RECEIVED_TIME — NUMBER(20)
  • INC_MESSAGES_RECEIVED_SIZE — NUMBER(20)
  • INC_MESSAGES_RECEIVED_BY_RETRY — NUMBER(20)
  • INC_MESSAGES_RECEIVED_BY_RETRY_DELAY_TIME — NUMBER(20)
  • INC_MESSAGES_RECEIVED_BY_BATCH — NUMBER(20)
  • INC_MESSAGES_RECEIVED_BY_BATCH_TIME — NUMBER(20)
  • INC_PACKETS_RECEIVED — NUMBER(20)
  • INC_PACKETS_RECEIVED_SIZE — NUMBER(20)
  • INC_MESSAGES_SENT — NUMBER(20)
  • INC_MESSAGES_SENT_TIME — NUMBER(20)
  • INC_MESSAGES_SENT_SIZE — NUMBER(20)
  • INC_MESSAGES_SENT_BY_RETRY — NUMBER(20)
  • INC_MESSAGES_SENT_BY_RETRY_DELAY_TIME — NUMBER(20)
  • INC_MESSAGES_SENT_BY_BATCH — NUMBER(20)
  • INC_MESSAGES_SENT_BY_BATCH_SUCCESS_MESSAGES — NUMBER(20)
  • INC_MESSAGES_SENT_FROM_SEND_QUEUE_TIME — NUMBER(20)
  • INC_PACKETS_SENT — NUMBER(20)
  • INC_PACKETS_SENT_SIZE — NUMBER(20)
  • LOGICAL_READS — NUMBER(20)
  • PHYSICAL_READS — NUMBER(20)
  • … +14

DB_TABLESPACE

  • LOG_TIME — NUMBER(20) — Primary key — NOT NULL
  • DATABASE_ID — VARCHAR(40) — Primary key — NOT NULL
  • ID — NUMBER(20) — Primary key — NOT NULL
  • NAME — VARCHAR(40) — NOT NULL
  • DATAFILE_COUNT — NUMBER(2)
  • BLOCK_SIZE — NUMBER(5)
  • TYPE — VARCHAR(40)
  • STATUS — VARCHAR(10)
  • USED_SIZE — NUMBER(20)
  • FREE_SIZE — NUMBER(20)
  • TOTAL_SIZE — NUMBER(20)
  • MAX_SIZE — NUMBER(20)
  • USED — VARCHAR(8)
  • USED_SIZE_BY_MAX_SIZE — VARCHAR(8)
  • IS_LOGGING — VARCHAR(1)
  • IS_FORCE_LOGGING — VARCHAR(1)
  • ALLOCATION_TYPE — VARCHAR(7)
  • ENCRYPTED — VARCHAR(1)
  • INITIAL_EXTENT — NUMBER(15)
  • MIN_EXTENTS — NUMBER(2)
  • MAX_EXTENTS — NUMBER(20)
  • EXTENT_MANAGEMENT — VARCHAR(5)
  • SEGMENT_SPACE_MANAGEMENT — VARCHAR(4)
  • BIGFILE — VARCHAR(1)
  • DEF_INMEMORY — VARCHAR(8)
  • DEF_INMEMORY_PRIORITY — VARCHAR(8)
  • DEF_INMEMORY_DISTRIBUTE — VARCHAR(15)
  • DEF_INMEMORY_COMPRESSION — VARCHAR(14)
  • DEF_INMEMORY_DUPLICATE — VARCHAR(13)
  • NEXT_EXTENT — NUMBER(20)

DB_THREAD

  • THREAD_ID — NUMBER(5) — Primary key — NOT NULL
  • LOG_TIME — NUMBER(20) — Foreign key → DB_PROCESS.LOG_TIME — NOT NULL
  • INSTANCE_ID — VARCHAR(40) — Foreign key → DB_PROCESS.INSTANCE_ID — NOT NULL
  • DATABASE_ID — VARCHAR(40) — Foreign key → DB_PROCESS.DATABASE_ID — NOT NULL
  • PROCESS_ID — NUMBER(5) — Foreign key → DB_PROCESS.PROCESS_ID — NOT NULL
  • THREAD_NAME — VARCHAR(8)
  • THREAD_TYPE — CHAR(2)
  • STATUS — VARCHAR(32)
  • CPU_TIME — NUMBER(20)
  • CPU_USAGE — NUMBER(2)
  • USED_PGA — NUMBER(20)

INSTANCE

  • ID — VARCHAR(40) — Primary key — NOT NULL
  • DATABASE_ID — VARCHAR(40) — Foreign key → DATABASE.ID — NOT NULL
  • OS_ID — NUMBER(20) — NOT NULL
  • ALIAS — VARCHAR(40)
  • DESCRIPTION — VARCHAR(1000)
  • SID — VARCHAR(40)
  • HOST — VARCHAR(100)
  • PRIVATE_IP — VARCHAR(40)
  • JDBC_PORT — NUMBER(6)
  • MANAGER_PORT — NUMBER(6)
  • IS_STANDBY — CHAR(1)
  • STATUS — VARCHAR(20)
  • CREATED_AT — NUMBER(20)
  • STATUS_UPDATED_AT — NUMBER(20)
  • IS_RECOVERY — CHAR(1)

INSTANCE_PROPERTY

  • ID — NUMBER(20)
  • PROPERTY_NAME — VARCHAR(100) — NOT NULL
  • PROPERTY_VALUE — VARCHAR(200) — NOT NULL
  • INSTANCE_ID — VARCHAR(40) — Foreign key → INSTANCE.ID — NOT NULL
  • DATABASE_ID — VARCHAR(40) — Foreign key → INSTANCE.DATABASE_ID — NOT NULL

MIGRATION_HISTORY

  • ID — NUMBER(20) — Primary key — NOT NULL
  • SUCCESS_RATE — VARCHAR(20)
  • SOURCE_DB_HOST — VARCHAR(100) — NOT NULL
  • SOURCE_DB_PORT — NUMBER(10) — NOT NULL
  • SOURCE_DB_TYPE — VARCHAR(20) — NOT NULL
  • TARGET_DB_TYPE — VARCHAR(20) — NOT NULL
  • STATE — VARCHAR(15) — NOT NULL
  • ERROR_MSG — VARCHAR(10)
  • CREATED_AT — NUMBER(20) — NOT NULL
  • END_TIME — NUMBER(20)
  • DATABASE_ID — VARCHAR(40) — Foreign key → DATABASE.ID — NOT NULL

MIGRATION_RESULT

  • OBJECT_TYPE — NUMBER(10) — Primary key — NOT NULL
  • MIGRATION_HISTORY_ID — NUMBER(20) — Foreign key → MIGRATION_HISTORY.ID — NOT NULL
  • OBJECT_COUNT — NUMBER(20) — NOT NULL
  • SUCCESS_COUNT — NUMBER(20) — NOT NULL
  • FAIL_COUNT — NUMBER(20) — NOT NULL
  • WARNING_COUNT — NUMBER(20) — NOT NULL

MIGRATION_RESULT_LOG

  • ID — NUMBER(20) — Primary key — NOT NULL
  • MIGRATION_HISTORY_ID — NUMBER(20) — Foreign key → MIGRATION_RESULT.MIGRATION_HISTORY_ID — NOT NULL
  • OBJECT_TYPE — NUMBER(10) — Foreign key → MIGRATION_RESULT.OBJECT_TYPE — NOT NULL
  • LOG — VARCHAR(255) — NOT NULL
  • IS_ERROR — CHAR(1) — NOT NULL

ORDER_INFO

  • ORDER_ID — NUMBER(20) — Primary key — NOT NULL
  • PERSONA_ID — NUMBER(20) — NOT NULL
  • ITEM_ID — NUMBER(20) — NOT NULL
  • ITEM_NAME — VARCHAR(255) — NOT NULL
  • ITEM_CATEGORY_NAME — VARCHAR(255) — NOT NULL
  • PRODUCT_TYPE — VARCHAR(255) — NOT NULL
  • PROVISIONING_STATE — VARCHAR(100) — NOT NULL
  • SUBSCRIPTION_STATE — VARCHAR(100) — NOT NULL
  • VPC_ID — VARCHAR(100) — NOT NULL
  • MWM_PRIVATE_IP — VARCHAR(100) — NOT NULL
  • SUBNET_ID — VARCHAR(100) — NOT NULL
  • REGION — VARCHAR(100) — NOT NULL
  • ORDERED_AT — NUMBER(20) — NOT NULL

ORDER_OPTION_CONFIG

  • ID — NUMBER(20)
  • GROUP_NAME — VARCHAR(255) — NOT NULL
  • OPTION_NAME — VARCHAR(255) — NOT NULL
  • ITEM_ID — NUMBER(20) — NOT NULL
  • ORDER_LINE_ITEM_ID — NUMBER(20) — NOT NULL
  • ORDER_ID — NUMBER(20) — Foreign key → ORDER_INFO.ORDER_ID — NOT NULL

PARAMETER_HISTORY

  • DATABASE_ID — VARCHAR(40) — Foreign key → INSTANCE.DATABASE_ID — NOT NULL
  • INSTANCE_ID — VARCHAR(40) — Foreign key → INSTANCE.ID — NOT NULL
  • ID — NUMBER(20)
  • PARAMETER_NAME — VARCHAR(64) — NOT NULL
  • PREV_VALUE — VARCHAR(1024)
  • UPDATE_VALUE — VARCHAR(1024) — NOT NULL
  • UPDATE_TYPE — VARCHAR(20) — NOT NULL
  • CREATED_AT — NUMBER(20) — NOT NULL

PARAMETER_SYSTEM_TEMPLATE

  • TEMPLATE_NAME — VARCHAR(64)
  • PARAMETER_NAME — VARCHAR(64)
  • RECOMMEND_VALUE — VARCHAR(1024)

PARTITION_POLICY

  • ID — NUMBER(2)
  • TABLE_NAME — VARCHAR(256)
  • RETENTION_PERIOD — NUMBER(3)

PROVISIONING_STATUS

  • ID — NUMBER(20)
  • NETWORK_CONFIGURATION — VARCHAR(20) — NOT NULL
  • INSTANCE_CREATION — VARCHAR(20) — NOT NULL
  • VOLUME_CREATION — VARCHAR(20) — NOT NULL
  • INSTANCE_VOLUME_MAPPING — VARCHAR(20) — NOT NULL
  • DB_INSTALLATION — VARCHAR(20) — NOT NULL
  • AGENT_INSTALLATION — VARCHAR(20) — NOT NULL
  • DB_REGISTRATION — VARCHAR(20) — NOT NULL
  • CREATED_AT — NUMBER(20)
  • UPDATED_AT — NUMBER(20)
  • ORDER_ID — NUMBER(20) — Foreign key → ORDER_INFO.ORDER_ID — NOT NULL

RECOVERY_HISTORY

  • ID — NUMBER(20)
  • TYPE — VARCHAR(10)
  • BACKUP_ID — VARCHAR(40)
  • NAME — VARCHAR(40)
  • STARTED_AT — NUMBER(20)
  • FINISHED_AT — NUMBER(20)
  • STATUS — VARCHAR(10)
  • DATABASE_ID — VARCHAR(40) — Foreign key → DATABASE.ID
  • SCHEDULE_ID — VARCHAR(40)

SNAPSHOT

  • ID — VARCHAR(40)
  • DATABASE_ID — VARCHAR(40) — Foreign key → DATABASE.ID
  • NAME — VARCHAR(40)
  • EXPIRED_AT — NUMBER(20)
  • AUTO_CREATION — VARCHAR(10)
  • START_SEQUENCE — NUMBER(10)
  • END_SEQUENCE — NUMBER(10)
  • CREATED_AT — NUMBER(20)
  • END_TSN — NUMBER(20)
  • STATUS — VARCHAR(10)

SNAPSHOT_POLICY

  • DATABASE_ID — VARCHAR(40) — Foreign key → DATABASE.ID
  • CYCLE_TYPE — VARCHAR(10)
  • CYCLE_PERIOD — NUMBER(5)
  • EXPIRE_TYPE — VARCHAR(10)
  • EXPIRE_PERIOD — NUMBER(5)
  • START_TIME — NUMBER(20)
  • AUTO_CREATION — VARCHAR(10)

SYSTEM_LOG

  • LOG_TIME — NUMBER(20) — Primary key — NOT NULL
  • DATABASE_ID — VARCHAR(40) — Foreign key → INSTANCE.DATABASE_ID — NOT NULL
  • INSTANCE_ID — VARCHAR(40) — Foreign key → INSTANCE.ID — NOT NULL
  • LOG_ID — NUMBER(20)
  • MODULE — VARCHAR(10)
  • LOG_LEVEL — VARCHAR(10)
  • MSG — VARCHAR(8095) — NOT NULL
  • EC — NUMBER
  • EC_NAME — VARCHAR(100)
  • EC_MSG — VARCHAR(1000)
  • CSR_ID — NUMBER
  • OCCURRED_FILE — VARCHAR(50)
  • OCCURRED_LINE — NUMBER
  • OCCURRED_FUNC — VARCHAR(50)
  • PROCESS_ID — NUMBER(20)
  • SEVERITY — VARCHAR(40)

TOTAL_DB_STAT

  • DATABASE_ID — VARCHAR(40) — Primary key — NOT NULL
  • INSTANCE_ID — VARCHAR(40) — Primary key — NOT NULL
  • LOG_TIME — NUMBER(20) — NOT NULL
  • REDO_ENTRIES — NUMBER(20)
  • EXECUTE_COUNT — NUMBER(20)
  • LOGICAL_READS — NUMBER(20)
  • PHYSICAL_READS — NUMBER(20)
  • REPLICATION_LAG — NUMBER(20)
  • COMMITS — NUMBER(20)
  • ROLLBACKS — NUMBER(20)
  • TRANSACTIONS — NUMBER(20)
  • BLK_READ_TIME — NUMBER(20, 3)
  • BLK_WRITE_TIME — NUMBER(20, 3)
  • WAL_SIZE — NUMBER(20)
  • TOTAL_DB_SIZE — NUMBER(20)
  • DEAD_TUPLE_COUNT — NUMBER(20)
  • LIVE_TUPLE_COUNT — NUMBER(20)
  • SWAP_TOTAL_MEMORY — NUMBER(20)
  • SWAP_USED_MEMORY — NUMBER(20)
  • SWAP_FREE_MEMORY — NUMBER(20)
  • DISK_READ_RATE — NUMBER(20)
  • DISK_WRITE_RATE — NUMBER(20)

TSN_TIME_MAPPING

  • TIME — NUMBER(20)
  • DATABASE_ID — VARCHAR(40) — Foreign key → DATABASE.ID
  • TSN — NUMBER(20)

경매 이력 (AUCTION_HISTORY)

  • PK (Key) — NOT NULL — Primary key — NOT NULL
  • 입찰 금액 (bid_amount) — NOT NULL
  • 생성 시간 (created_at) — NOT NULL
  • 상품 (product_id) — NOT NULL — Foreign key → 상품.PK — NOT NULL
  • 입찰자 (bidder_id) — NOT NULL — Foreign key → 사용자.PK — NOT NULL

사용자 (User)

  • PK (id) — NOT NULL — Primary key — NOT NULL
  • 이름 (name) — NOT NULL
  • 생성 시간 (created_at) — NOT NULL

상품 (Product)

  • PK (id) — NOT NULL — Primary key — NOT NULL
  • 이름 (name) — NOT NULL
  • 최소 금액 (minimum_amount) — NOT NULL
  • 경매 기간 (auction_period) — NOT NULL
  • 생성 시간 (created_at) — NOT NULL
  • 입찰 금액 (bid_amount) — NOT NULL
  • 판매자 (seller_id) — NOT NULL — Foreign key → 사용자.PK — NOT NULL

알림 (Alarm)

  • PK (Id) — NOT NULL — Primary key
  • 금액 (bid_amount) — NOT NULL
  • 종류 (type) — NOT NULL
  • 사용자 (user_id) — NOT NULL — Foreign key → 사용자.PK — NOT NULL
  • 상품 (product_id) — NOT NULL — Foreign key → 상품.PK — NOT NULL

주문 (Order)

  • PK (Id) — NOT NULL — Primary key
  • 판매 금액 (sales_amount) — NOT NULL
  • 생성 시간 (created_at) — NOT NULL
  • 구매자 (buyer_id) — NOT NULL — Foreign key → 사용자.PK — NOT NULL
  • 판매자 (seller_id) — NOT NULL — Foreign key → 사용자.PK — NOT NULL
  • 상품 (product_id) — NOT NULL — Foreign key → 상품.PK — NOT NULL