aws_billing

Tables (10)

cost_daily

  • id — bigint — Primary key — NOT NULL
  • account_id — varchar(30) — NOT NULL
  • bill_date_number — int — NOT NULL — 청구 금액 발생 날짜 int형변환
  • bill_date — date — NOT NULL — 청구 금액 발생 날
  • bill_cost — double(15, 2) — NOT NULL — 청구 금액
  • usage_cost — double(15, 2) — NOT NULL — 사용 금액 (SP, RI 구입 가격 포함)
  • sp_discount — double(15, 2) — NOT NULL — SP 할인 (본인이 직접 산 SP 할인)
  • ri_discount — double(15, 2) — NOT NULL — RI 할인 (본인이 직접 산 RI 할인)
  • ri_false_discount — double(15, 2) — NOT NULL — RI 할인 보정 (본인이 직접 사지 않은 RI 할인)
  • insert_time — timestamp — NOT NULL
  • update_time — timestamp — NOT NULL

cost_daily_product

  • id — bigint — Primary key — NOT NULL
  • account_id — varchar(30) — NOT NULL
  • bill_date_number — int — NOT NULL — 청구 금액 발생 날짜 int형변환
  • bill_date — date — NOT NULL — 청구 금액 발생 날
  • product_name — varchar(50) — NOT NULL
  • bill_cost — double(15, 2) — NOT NULL — 청구 금액
  • usage_cost — double(15, 2) — NOT NULL — 사용 금액 (SP, RI 구입 가격 포함)
  • sp_discount — double(15, 2) — NOT NULL — SP 할인 (본인이 직접 산 SP 할인)
  • ri_discount — double(15, 2) — NOT NULL — RI 할인 (본인이 직접 산 RI 할인)
  • ri_false_discount — double(15, 2) — NOT NULL — RI 할인 보정 (본인이 직접 사지 않은 RI 할인)
  • insert_time — timestamp — NOT NULL
  • update_time — timestamp — NOT NULL

cost_daily_region_product

  • id — bigint — Primary key — NOT NULL
  • account_id — varchar(30) — NOT NULL
  • bill_date_number — int — NOT NULL — 청구 금액 발생 날짜 int형변환
  • bill_date — date — NOT NULL — 청구 금액 발생 날
  • region — varchar(30) — NOT NULL — 리전 정보
  • product_name — varchar(50) — NOT NULL
  • bill_cost — double(15, 2) — NOT NULL — 청구 금액
  • usage_cost — double(15, 2) — NOT NULL — 사용 금액 (SP, RI 구입 가격 포함)
  • sp_discount — double(15, 2) — NOT NULL — SP 할인 (본인이 직접 산 SP 할인)
  • ri_discount — double(15, 2) — NOT NULL — RI 할인 (본인이 직접 산 RI 할인)
  • ri_false_discount — double(15, 2) — NOT NULL — RI 할인 보정 (본인이 직접 사지 않은 RI 할인)
  • insert_time — timestamp — NOT NULL
  • update_time — timestamp — NOT NULL

cost_daily_traffic

  • id — bigint — Primary key — NOT NULL
  • account_id — varchar(30) — NOT NULL
  • bill_date_number — int — NOT NULL — 청구 금액 발생 날짜 int형변환
  • bill_date — date — NOT NULL — 청구 금액 발생 날
  • total_usage — double(15, 2) — NOT NULL — 총 트래픽 사용량
  • total_cost — double(15, 2) — NOT NULL — 총 사용 금액
  • inbound_usage — double(15, 2) — NOT NULL — inbound 트래픽 사용량
  • inbound_cost — double(15, 2) — NOT NULL — inbound 트래픽 금액
  • outbound_usage — double(15, 2) — NOT NULL — outbound 트래픽 사용량
  • outbound_cost — double(15, 2) — NOT NULL — outbound 트래픽 금액
  • etcbound_usage — double(15, 2) — NOT NULL — etc 트래픽 사용량
  • etcbound_cost — double(15, 2) — NOT NULL — etc 트래픽 금액
  • insert_time — timestamp — NOT NULL
  • update_time — timestamp — NOT NULL

cost_monthly

  • id — bigint — Primary key — NOT NULL
  • account_id — varchar(30) — NOT NULL
  • bill_month — varchar(10) — NOT NULL
  • bill_month_number — int — NOT NULL — 2022-11 -> 202211
  • bill_cost — double(15, 2) — NOT NULL — 청구 금액
  • usage_cost — double(15, 2) — NOT NULL — 사용 금액 (SP, RI 가격 포함)
  • sp_discount — double(15, 2) — NOT NULL — SP 할인 (본인이 직접 산 SP 할인)
  • ri_discount — double(15, 2) — NOT NULL — RI 할인 (본인이 직접 산 RI 할인)
  • ri_false_discount — double(15, 2) — NOT NULL — RI 할인 보정 (본인이 직접 사지 않은 RI 할인)
  • insert_time — timestamp — NOT NULL
  • update_time — timestamp — NOT NULL

cost_monthly_product

  • id — bigint — Primary key — NOT NULL
  • account_id — varchar(30) — NOT NULL
  • bill_month — varchar(10) — NOT NULL
  • bill_month_number — int — NOT NULL — 2022-11 -> 202211
  • product_name — varchar(50) — NOT NULL
  • bill_cost — double(15, 2) — NOT NULL — 청구 금액
  • usage_cost — double(15, 2) — NOT NULL — 사용 금액 (SP, RI 구입 가격 포함)
  • sp_discount — double(15, 2) — NOT NULL — SP 할인 (본인이 직접 산 SP 할인)
  • ri_discount — double(15, 2) — NOT NULL — RI 할인 (본인이 직접 산 RI 할인)
  • ri_false_discount — double(15, 2) — NOT NULL — RI 할인 보정 (본인이 직접 사지 않은 RI 할인)
  • insert_time — timestamp — NOT NULL
  • update_time — timestamp — NOT NULL

cost_monthly_region_product

  • id — bigint — Primary key — NOT NULL
  • account_id — varchar(30) — NOT NULL
  • bill_month — varchar(10) — NOT NULL
  • bill_month_number — int — NOT NULL — 2022-11 -> 202211
  • region — varchar(30) — NOT NULL — 리전 정보
  • product_name — varchar(50) — NOT NULL
  • bill_cost — double(15, 2) — NOT NULL — 청구 금액
  • usage_cost — double(15, 2) — NOT NULL — 사용 금액 (SP, RI 구입 가격 포함)
  • sp_discount — double(15, 2) — NOT NULL — SP 할인 (본인이 직접 산 SP 할인)
  • ri_discount — double(15, 2) — NOT NULL — RI 할인 (본인이 직접 산 RI 할인)
  • ri_false_discount — double(15, 2) — NOT NULL — RI 할인 보정 (본인이 직접 사지 않은 RI 할인)
  • insert_time — timestamp — NOT NULL
  • update_time — timestamp — NOT NULL

cost_monthly_traffic

  • id — bigint — Primary key — NOT NULL
  • account_id — varchar(30) — NOT NULL
  • bill_month — varchar(10) — NOT NULL
  • bill_month_number — int — NOT NULL — 2022-11 -> 202211
  • total_usage — double(15, 2) — NOT NULL — 총 트래픽 사용량
  • total_cost — double(15, 2) — NOT NULL — 총 사용 금액
  • inbound_usage — double(15, 2) — NOT NULL — inbound 트래픽 사용량
  • inbound_cost — double(15, 2) — NOT NULL — inbound 트래픽 금액
  • outbound_usage — double(15, 2) — NOT NULL — outbound 트래픽 사용량
  • outbound_cost — double(15, 2) — NOT NULL — outbound 트래픽 금액
  • etcbound_usage — double(15, 2) — NOT NULL — etc 트래픽 사용량
  • etcbound_cost — double(15, 2) — NOT NULL — etc 트래픽 금액
  • insert_time — timestamp — NOT NULL
  • update_time — timestamp — NOT NULL

cur_last_month

  • id — bigint — Primary key — NOT NULL
  • assembly_id — varchar(500)
  • i_item_id — varchar(500)
  • i_time_interval — varchar(500) — NOT NULL
  • i_bill_date_number — int — NOT NULL — i_time_interval 가공 ex) 2022-11-10 -> 20221110
  • l_item_usage_account_id — varchar(500)
  • l_item_usage_start_date — varchar(500)
  • l_item_usage_end_date — varchar(500)
  • l_item_line_item_type — varchar(500)
  • l_item_product_code — varchar(500)
  • l_item_usage_type — varchar(500)
  • l_item_availability_zone — varchar(500)
  • l_item_resource_id — varchar(500)
  • l_item_usage_amount — decimal(30, 20)
  • l_item_unblended_rate — decimal(20, 10)
  • l_item_unblended_cost — decimal(30, 20)
  • l_item_line_item_description — varchar(500)
  • b_payer_account_id — varchar(500)
  • b_bill_type — varchar(500)
  • b_billing_entity — varchar(500)
  • p_product_name — varchar(500)
  • p_region — varchar(500)
  • p_servicecode — varchar(500)
  • p_transfer_type — varchar(500)
  • s_savingplanarn — varchar(500)
  • s_savingplan_check — tinyint(1)
  • s_starttime — varchar(500) — 세이빙 플랜의 계약 시작 날짜
  • s_endtime — varchar(500) — 세이빙 플랜의 계약 종료 날짜
  • s_offeringtype — varchar(500)
  • s_paymentoption — varchar(500)
  • s_purchaseterm — varchar(500)
  • s_region — varchar(500)
  • r_reservationarn — varchar(500)
  • r_reservation_check — tinyint(1)
  • demand_cost — decimal(20, 10)
  • insert_time — timestamp — NOT NULL

cur_this_month

  • id — bigint — Primary key — NOT NULL
  • assembly_id — varchar(500)
  • i_item_id — varchar(500)
  • i_time_interval — varchar(500) — NOT NULL
  • i_bill_date_number — int — NOT NULL — i_time_interval 가공 ex) 2022-11-10 -> 20221110
  • l_item_usage_account_id — varchar(500)
  • l_item_usage_start_date — varchar(500)
  • l_item_usage_end_date — varchar(500)
  • l_item_line_item_type — varchar(500)
  • l_item_product_code — varchar(500)
  • l_item_usage_type — varchar(500)
  • l_item_availability_zone — varchar(500)
  • l_item_resource_id — varchar(500)
  • l_item_usage_amount — decimal(30, 20)
  • l_item_unblended_rate — decimal(20, 10)
  • l_item_unblended_cost — decimal(30, 20)
  • l_item_line_item_description — varchar(500)
  • b_payer_account_id — varchar(500)
  • b_bill_type — varchar(500)
  • b_billing_entity — varchar(500)
  • p_product_name — varchar(500)
  • p_region — varchar(500)
  • p_servicecode — varchar(500)
  • p_transfer_type — varchar(500)
  • s_savingplanarn — varchar(500)
  • s_savingplan_check — tinyint(1)
  • s_starttime — varchar(500) — 세이빙 플랜의 계약 시작 날짜
  • s_endtime — varchar(500) — 세이빙 플랜의 계약 종료 날짜
  • s_offeringtype — varchar(500)
  • s_paymentoption — varchar(500)
  • s_purchaseterm — varchar(500)
  • s_region — varchar(500)
  • r_reservationarn — varchar(500)
  • r_reservation_check — tinyint(1)
  • demand_cost — decimal(20, 10)
  • insert_time — timestamp — NOT NULL