이상비용탐지 - 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