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