Asset AWS Resource

Tables (5)

TASM_USE_AWS_EC2_D

  • CMPN_ID — varchar(50) — Primary key — NOT NULL — 고객사 아이디
  • ACC_ID — varchar(50) — Primary key — NOT NULL — 클라우드 Account ID
  • RGN_ID — varchar(50) — Primary key — NOT NULL — Region
  • RSRC_TYPE — varchar(50) — Primary key — NOT NULL — Resource Type
  • INST_ID — varchar(100) — Primary key — NOT NULL — Instance ID
  • SITE_CD — varchar(50) — Primary key — NOT NULL — Site Code
  • ACS_KEY_ID — varchar(50) — NOT NULL — 클라우드 Access Key
  • AMI_LNCH_IDX — bigint(20) — AmiLaunchIndex
  • ARCH — varchar(100) — Architecture
  • BLOK_DEVICE_MAPP — text — BlockDeviceMappings
  • LAST_BLOK_DEVICE_MAPP — text
  • ATCH_CNT — int(11) — BlockDeviceMappings Attached Count
  • CLNT_TOKN — varchar(100) — ClientToken
  • EBS_OTMZ — varchar(5) — EbsOptimized
  • ENA_SPRT — varchar(100) — EnaSupport
  • HPVSR — varchar(100) — Hypervisor
  • IAM_INST_PRFL — text — IamInstanceProfile
  • IMG_ID — varchar(100) — ImageId
  • INST_LIFE_CYCL — text — InstanceLifecycle
  • KERNEL_ID — varchar(100) — KernelId
  • KEY_NAME — varchar(255) — KeyName
  • LNCH_TIME — varchar(100) — LaunchTime
  • LNCH_TIME_FRM_STR — varchar(30) — LaunchTime Format to String
  • MONI — text — Monitoring
  • NW_IF — text — NetworkInterfaces
  • PLCM — text — Placement
  • AVAIL_ZONE — varchar(100) — AvailabilityZone
  • PF — varchar(100) — Platform
  • PRV_DNS_NM — varchar(100) — PrivateDnsName
  • PRV_IP_ADDR — varchar(100) — PrivateIpAddress
  • PROD_CD — text — ProductCodes
  • PBL_DNS_NM — varchar(100) — PublicDnsName
  • PBL_IP_ADDR — varchar(100) — PublicIpAddress
  • RAM_DISK_ID — varchar(100) — RamdiskId
  • ROOT_DEVICE_NM — varchar(100) — RootDeviceName
  • ROOT_DEVICE_TYPE — varchar(100) — RootDeviceType
  • SECR_GRP — text — SecurityGroups
  • SRC_DEST_CHK — varchar(5) — SourceDestCheck
  • SPOT_INST_REQ_ID — varchar(100) — SpotInstanceRequestId
  • SR_IOV_NET_SPRT — varchar(100) — SriovNetSupport
  • STATE_RSN — text — StateReason
  • STATE_TRSTN_RSN — varchar(100) — StateTransitionReason
  • SBNET_ID — varchar(100) — SubnetId
  • VTZTN_TYPE — varchar(100) — VirtualizationType
  • VPC_ID — varchar(100) — VpcId
  • OWNER_ID — varchar(100) — OwnerId
  • RSRV_ID — varchar(100) — ReservationId
  • TENANCY — varchar(30) — Placement-Tenancy
  • ROOT_VOL_ID — varchar(50)
  • INST_LIFE_CYCLE — varchar(30)
  • TAGS — text
  • THREADS_PER_CORE — double — ThreadsPerCore
  • CORE_COUNT — double — CoreCount
  • CREA_DT — datetime — NOT NULL — 등록일시
  • UPDT_DT — datetime — 갱신일시

TASM_USE_AWS_L

  • CMPN_ID — varchar(50) — Primary key — NOT NULL — 고객사 아이디
  • SITE_CD — varchar(50) — Primary key — NOT NULL — Site Code
  • RSRC_TYPE — varchar(50) — Primary key — NOT NULL — Resource Type
  • ACC_ID — varchar(50) — Primary key — NOT NULL — 클라우드 Account ID
  • RGN_ID — varchar(50) — Primary key — NOT NULL — Region
  • INST_ID — varchar(255) — Primary key — NOT NULL — Instance ID
  • ARN — varchar(500) — Amazon Resource Naming
  • ACS_KEY_ID — varchar(50) — 클라우드 Access Key
  • ACC_ALIAS — varchar(40) — 클라우드 Account Alias
  • SVC_GRP_ID — varchar(50) — 서비스 그룹 ID
  • STATE_CODE — varchar(30) — State Code
  • STATE_NAME — varchar(100) — State Name
  • INST_TYPE — varchar(30) — Instance Type
  • CLCT_TIME — datetime — 수집일시
  • NM_VAL — varchar(255) — Tag Name Value
  • DEL_YN — varchar(1) — NOT NULL — 삭제여부
  • DEL_DT — datetime — 삭제일시
  • PERF_CURR_DATE — datetime — Performance Current Date
  • CREA_DT — datetime — NOT NULL — 등록일시
  • UPDT_DT — datetime — 갱신일시
  • SITE_CD) — USING

TASM_USE_AWS_RDS_CLST_D

  • INST_ID — varchar(255) — Primary key — NOT NULL — AWS Instance ID
  • RSRC_TYPE — varchar(50) — Primary key — NOT NULL — Resource Type
  • RGN_ID — varchar(50) — Primary key — NOT NULL — Region ID
  • ACC_ID — varchar(50) — Primary key — NOT NULL — AWS Account ID
  • CMPN_ID — varchar(50) — Primary key — NOT NULL — Company ID
  • SITE_CD — varchar(50) — Primary key — NOT NULL — Site Code
  • ACS_KEY_ID — varchar(50) — NOT NULL — 클라우드 Access Key
  • ALCT_STRG — int(11) — allocatedStorage
  • AVAIL_ZONE — text — availabilityZones
  • BAK_RTTN_PERI — int(11) — backupRetentionPeriod
  • CHA_SET_NM — varchar(50) — characterSetName
  • DB_NM — varchar(255) — databaseName
  • DB_CLST_IDTF — varchar(255) — dBClusterIdentifier
  • DB_CLST_PRMT_GRP — varchar(255) — dBClusterParameterGroup
  • DB_SBNET_GRP — varchar(255) — dBSubnetGroup
  • STAT — varchar(50) — status
  • PCNT_PROG — varchar(30) — percentProgress
  • ELST_RSTB_TIME — varchar(30) — earliestRestorableTime
  • EDPNT — varchar(512) — endpoint
  • RDR_EDPNT — varchar(512) — readerEndpoint
  • MULTI_AZ — varchar(10) — multiAZ
  • ENGN — varchar(50) — engine
  • ENGN_VER — varchar(50) — engineVersion
  • NWST_RSTB_TIME — varchar(30) — latestRestorableTime
  • PORT — int(11) — port
  • MSTR_USER_NM — varchar(50) — masterUsername
  • DB_CLST_OPTN_GRP_MBSP — text — dBClusterOptionGroupMemberships
  • PRFD_BAK_WND — varchar(50) — preferredBackupWindow
  • PRFD_MTNC_WND — varchar(50) — preferredMaintenanceWindow
  • RPCT_SRC_IDTF — varchar(255) — replicationSourceIdentifier
  • READ_RPCT_IDTF — text — readReplicaIdentifiers
  • DB_CLST_MBR — text — dBClusterMembers
  • VPC_SECR_GRP — text — vpcSecurityGroups
  • HSTD_ZONE_ID — varchar(50) — hostedZoneId
  • STRG_ECRT — varchar(10) — storageEncrypted
  • KMS_KEY_ID — varchar(512) — kmsKeyId
  • DB_CLST_RSRC_ID — varchar(50) — dbClusterResourceId
  • DB_CLST_ARN — varchar(512) — dBClusterArn
  • ASCTD_ROLE — text — associatedRoles
  • IAM_DB_ATHN_ENAD — varchar(10) — iAMDatabaseAuthenticationEnabled
  • CLN_GRP_ID — varchar(50) — cloneGroupId
  • CLST_CREA_TIME — varchar(30) — clusterCreateTime
  • ELST_BAK_TRACK_TIME — varchar(30) — earliestBacktrackTime
  • BAK_TRACK_WND — bigint(20) — backtrackWindow
  • BAK_TRACK_CNSMD_CHG_REC — bigint(20) — backtrackConsumedChangeRecords
  • ENAD_CW_LOG_EXPT — text — enabledCloudwatchLogsExports
  • CPCT — int(11) — capacity
  • ENGN_MODE — varchar(50) — engineMode
  • SCL_CNFG_INFO — text — scalingConfigurationInfo
  • DLTN_PTCT — varchar(10) — deletionProtection
  • CREA_DT — datetime — 생성일시
  • UPDT_DT — datetime — 갱신일시

TASM_USE_AWS_S3_D

  • CMPN_ID — varchar(50) — Primary key — NOT NULL — 고객사 아이디
  • ACC_ID — varchar(50) — Primary key — NOT NULL — 클라우드 Account ID
  • RGN_ID — varchar(50) — Primary key — NOT NULL — Region
  • RSRC_TYPE — varchar(50) — Primary key — NOT NULL — Resource Type
  • INST_ID — varchar(100) — Primary key — NOT NULL — Instance ID
  • SITE_CD — varchar(50) — Primary key — NOT NULL — Site Code
  • ACS_KEY_ID — varchar(50) — NOT NULL — 클라우드 Access Key
  • NM — varchar(100) — NOT NULL — Name
  • S3_CREA_DT — varchar(100) — CreationDate
  • OWNER_ID — varchar(150)
  • OWNER_DSP_NM — varchar(100)
  • ORG_RGN — varchar(100)
  • CREA_DT — datetime — NOT NULL — 등록일시
  • UPDT_DT — datetime — 갱신일시

TASM_USE_AWS_TAGS_L

  • CMPN_ID — varchar(50) — Primary key — NOT NULL — 고객사 아이디
  • SITE_CD — varchar(50) — Primary key — NOT NULL — Site Code
  • RSRC_TYPE — varchar(50) — Primary key — NOT NULL — Resource Type
  • ACC_ID — varchar(50) — Primary key — NOT NULL — 클라우드 Account ID
  • INST_ID — varchar(255) — Primary key — NOT NULL — Instance ID
  • KEY — varchar(255) — Primary key — NOT NULL — Key
  • RGN_ID — varchar(50) — Primary key — NOT NULL — Region
  • ACS_KEY_ID — varchar(50) — 클라우드 Access Key
  • VAL — varchar(300) — NOT NULL — Value
  • SYS_YN — varchar(1) — NOT NULL — System Tag 여부
  • CLCT_TIME — datetime — 수집일시
  • DEL_YN — varchar(1) — NOT NULL — 삭제여부
  • DEL_DT — datetime — 삭제일시
  • CREA_DT — datetime — NOT NULL — 등록일시
  • UPDT_DT — datetime — 갱신일시