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 — 갱신일시