이상비용탐지 - 2023-11-22 06:10:15
테이블 (3)
T_ACCUMSUAGE_DAILY
- ACCUM_USAGE_ID — NUMBER(38) — 기본 키 — NOT NULL
- YYYYMMDD — VARCHAR2(8) — NOT NULL
- COMPANY_ID — VARCHAR2(10) — NOT NULL
- CSP_ID — VARCHAR2(10) — NOT NULL
- BUSINESS_ID — NUMBER — NOT NULL
- PAYER_ACCOUNT_ID — VARCHAR2(256)
- ACCOUNT_ID — VARCHAR2(256) — NOT NULL
- PROJECT_ID — NUMBER — NOT NULL
- PROJECT_NAME — VARCHAR2(256)
- TAG_TYPE — VARCHAR2(20)
- TAG_APPLICATION — VARCHAR2(256)
- TAG_SERVICE — VARCHAR2(256)
- PRODUCT_CODE — VARCHAR2(128)
- PRODUCT_CATEGORY — VARCHAR2(256)
- UNBLENDED_COST — NUMBER(38, 16) — NOT NULL
- THRESHOLD_RATE — NUMBER(38, 16)
- PREV_DAY_UNBLENDED_COST — NUMBER(38, 16)
- COMPARE_UNBLENDED_COST — NUMBER(38, 16)
- INCREASE_RATE — NUMBER(38, 16)
- CREATED_AT — DATE — NOT NULL
- CREATED_BY — VARCHAR2(256)
- UPDATED_AT — DATE
- UPDATED_BY — VARCHAR2(256)
t_accumsuage_daily
- ACCUM_USAGE_ID — NUMBER(38) — 기본 키 — NOT NULL
- YYYYMMDD — VARCHAR2(8) — NOT NULL
- COMPANY_ID — VARCHAR2(10) — NOT NULL
- CSP_ID — VARCHAR2(10) — NOT NULL
- BUSINESS_ID — NUMBER — NOT NULL
- PAYER_ACCOUNT_ID — VARCHAR2(256)
- ACCOUNT_ID — VARCHAR2(256) — NOT NULL
- PROJECT_ID — NUMBER — NOT NULL
- PROJECT_NAME — VARCHAR2(256)
- TAG_TYPE — VARCHAR2(20)
- TAG_APPLICATION — VARCHAR2(256)
- TAG_SERVICE — VARCHAR2(256)
- PRODUCT_CODE — VARCHAR2(128)
- PRODUCT_CATEGORY — VARCHAR2(256)
- UNBLENDED_COST — NUMBER(38, 16) — NOT NULL
- THRESHOLD_RATE — NUMBER(38, 16)
- PREV_DAY_UNBLENDED_COST — NUMBER(38, 16)
- COMPARE_UNBLENDED_COST — NUMBER(38, 16)
- INCREASE_RATE — NUMBER(38, 16)
- CREATED_AT — DATE — NOT NULL
- CREATED_BY — VARCHAR2(256)
- UPDATED_AT — DATE
- UPDATED_BY — VARCHAR2(256)
t_awsusage_202311_daily
- lineitemid — varchar(256)
- timeinterval — varchar(256)
- invoiceid — varchar(32)
- billingentity — varchar(128)
- billtype — varchar(128)
- payeraccountid — varchar(32)
- billingperiodstartdate — timestamp
- billingperiodenddate — timestamp
- usageaccountid — varchar(32)
- lineitemtype — varchar(32)
- usagestartdate — timestamp
- usageenddate — timestamp
- productcode — varchar(128)
- productname — varchar(512)
- usagetype — varchar(128)
- operation — varchar(128)
- availabilityzone — varchar(32)
- resourceid — varchar(512)
- usageamount — numeric(38, 16)
- normalizationfactor — numeric(38, 16)
- normalizedusageamount — numeric(38, 16)
- currencycode — varchar(4)
- unblendedrate — numeric(38, 16)
- unblendedcost — numeric(38, 16)
- lineitemdescription — varchar(512)
- sku — varchar(128)
- leasecontractlength — varchar(128)
- offeringclass — varchar(128)
- purchaseoption — varchar(128)
- publicondemandcost — numeric(38, 16)
- publicondemandrate — numeric(38, 16)
- term — varchar(32)
- unit — varchar(128)
- reservationavailabilityzone — varchar(32)
- normalizedunitsperreservation — numeric(38, 16)
- numberofreservations — numeric(38, 16)
- reservedaccountid — varchar(32)
- reservedinstancesid — varchar(128)
- totalreservednormalizedunits — numeric(38, 16)
- totalreservedunits — numeric(38, 16)
- unitsperreservation — numeric(38, 16)
- starttime — timestamp
- endtime — timestamp
- amortizedupfrontcostforusage — numeric(38, 16)
- amortizedupfrontfeeforbillingperiod — numeric(38, 16)
- effectivecost — numeric(38, 16)
- modificationstatus — varchar(128)
- recurringfeeforusage — numeric(38, 16)
- unusedamortizedupfrontfeeforbillingperiod — numeric(38, 16)
- unusednormalizedunitquantity — numeric(38, 16)
- unusedquantity — numeric(38, 16)
- unusedrecurringfee — numeric(38, 16)
- upfrontvalue — numeric(38, 16)
- productcategory — varchar(256)
- region — varchar(32)
- instancetype — varchar(32)
- savingsplan_amortizedupfrontcommitmentforbillingperiod — numeric(38, 16)
- savingsplan_endtime — timestamp
- savingsplan_instancetypefamily — varchar(128)
- savingsplan_offeringtype — varchar(128)
- … +17