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