aws_default

Tables (49)

abnormal_check

  • id — bigint — Primary key — NOT NULL
  • account_id — varchar(30) — NOT NULL
  • check_type — varchar(30) — NOT NULL
  • check_condition — varchar(255) — NOT NULL
  • abnormal_check_date — varchar(20) — NOT NULL
  • abnormal_check_date_number — int — NOT NULL
  • base_value — double(15, 2) — NOT NULL
  • abnormal_value — double(15, 2) — NOT NULL
  • alarm_status — varchar(30) — NOT NULL
  • alarm_fail_reason — varchar(255) — NOT NULL
  • insert_time — timestamp — NOT NULL
  • update_time — timestamp — NOT NULL

abnormal_check_ems_log

  • id — bigint — Primary key — NOT NULL
  • abnormal_check_id (id2) — bigint — Foreign key → abnormal_check.id — NOT NULL
  • cpidx — varchar(255) — NOT NULL
  • insert_time — timestamp — NOT NULL

aws_agent_data

  • account_id — varchar(30) — Primary key — NOT NULL
  • device_seq — varchar(16) — Primary key — NOT NULL
  • metrics_seq — varchar(8) — Primary key — NOT NULL
  • data_seq — varchar(4) — Primary key — NOT NULL
  • monitoring_date — datetime — Primary key — NOT NULL
  • l_item_usage_account_id — varchar(30) — Foreign key → aws_gabia_account.l_item_usage_account_id — NOT NULL — linked accout id
  • avg — double
  • cur — double
  • min — double
  • max — double
  • fields — varchar(100)

aws_agent_list

  • account_id — varchar(30) — Primary key — NOT NULL
  • device_seq — varchar(16) — Primary key — NOT NULL
  • monitoring_month — varchar(8) — Primary key — NOT NULL
  • l_item_usage_account_id — varchar(30) — Foreign key → aws_gabia_account.l_item_usage_account_id — NOT NULL — linked accout id
  • agent_key — varchar(128)
  • agent_ver — varchar(16)
  • as_flag — varchar(8)
  • host_name — varchar(64)
  • ip_num — varchar(255)
  • key_seq — varchar(8)
  • last_update — varchar(24)
  • mac_addr — varchar(24)
  • os_type — varchar(4)
  • os_name — varchar(128)
  • status — varchar(4)

aws_agent_metrics

  • account_id — varchar(30) — Primary key — NOT NULL
  • device_seq — varchar(16) — Primary key — NOT NULL
  • seqno — varchar(16) — Primary key — NOT NULL
  • metrics_seq — varchar(8) — Primary key — NOT NULL
  • monitoring_month — varchar(8) — Primary key — NOT NULL
  • l_item_usage_account_id — varchar(30) — Foreign key → aws_gabia_account.l_item_usage_account_id — NOT NULL — linked accout id
  • chart_type — varchar(8)
  • cycle — varchar(20)
  • data_unit — varchar(16)
  • metrics_type — varchar(8)
  • name — varchar(32)

aws_credentials

  • seqno — int — Primary key — NOT NULL
  • bucket_name — varchar(20) — NOT NULL — 시퀀스 키
  • access_key_id — varchar(50) — NOT NULL — aws bucket 이름
  • secret_access_key — varchar(100) — NOT NULL — aws bucket 접속 ID
  • aws_name — varchar(20) — aws bucket 접속 KEY
  • payer_account_id — varchar(20)
  • bucket_description — varchar(100)
  • account_email — varchar(50)
  • savings_plans — char(2) — Savings Plans 할인 반영 여부(N:할인요금가비아귀속)
  • root_id — varchar(100) — 조직 콘솔 Root id

aws_device_event

  • account_id — varchar(30) — Primary key — NOT NULL
  • device_seq — varchar(16) — Primary key — NOT NULL
  • metrics_seq — varchar(8) — Primary key — NOT NULL
  • hist_seq — varchar(16) — Primary key — NOT NULL
  • monitoring_date — datetime — Primary key — NOT NULL
  • l_item_usage_account_id — varchar(30) — Foreign key → aws_gabia_account.l_item_usage_account_id — NOT NULL — linked accout id
  • dt_e — varchar(12)
  • dt_h — varchar(12)
  • dt_s — varchar(12)
  • severity — varchar(16)
  • msg — varchar(1024)

aws_device_info

  • account_id — varchar(30) — Primary key — NOT NULL
  • instance_id — varchar(64) — Primary key — NOT NULL
  • device_seq — varchar(16) — Primary key — NOT NULL
  • monitoring_month — varchar(8) — Primary key — NOT NULL
  • l_item_usage_account_id — varchar(30) — Foreign key → aws_gabia_account.l_item_usage_account_id — NOT NULL — linked accout id

aws_device_iplist

  • account_id — varchar(30) — Primary key — NOT NULL
  • device_seq — varchar(16) — Primary key — NOT NULL
  • monitoring_month — varchar(8) — Primary key — NOT NULL
  • l_item_usage_account_id — varchar(30) — Foreign key → aws_gabia_account.l_item_usage_account_id — NOT NULL — linked accout id
  • gid — varchar(8)
  • hostname — varchar(128)
  • ipnum — varchar(256)
  • keyseq — varchar(16)
  • status — varchar(8)

aws_ems_log

  • id — bigint — Primary key — NOT NULL
  • domain — varchar(30) — NOT NULL
  • account_id — varchar(30) — NOT NULL
  • email — varchar(255) — NOT NULL
  • cpidx — varchar(255) — NOT NULL
  • mail_title — varchar(255) — NOT NULL
  • insert_time — timestamp — NOT NULL

aws_exchange_rate

  • seqno — int — Primary key — NOT NULL
  • notice_month — int — NOT NULL
  • exchange_code — varchar(20) — NOT NULL
  • notice_time — datetime — NOT NULL
  • openingprice — decimal(10,5) — NOT NULL
  • regist_date — datetime — NOT NULL

aws_gabia_account

  • l_item_usage_account_id — varchar(30) — Primary key — NOT NULL — linked accout id
  • hosting_seq — int — NOT NULL — 서버번호
  • user_id — varchar(50) — NOT NULL — gabia 사용자 id
  • aws_account_name — varchar(80) — NOT NULL — 계정 이름
  • aws_email — varchar(80) — NOT NULL — 사용자 이메일
  • regist_date — datetime — AWS ACCOUNT 등록일
  • account_stats — char(1) — 계정 상태
  • payer_account_id — varchar(20) — payer account id
  • invoice_status — char(1) — NOT NULL — (구) 이용내역서 자동/수동 발송 체크
  • start_date — date — 계정 시작일
  • end_date — date — 계정 해지일
  • access_key — varchar(129) — account id 인증키
  • secret_key — varchar(129)
  • update_date — datetime — 마지막 업데이트 날짜
  • usage_report — char(1) — (신) 이용내역서 자동/수동 발송 체크
  • monitoring_report — char(1) — 모니터링 보고서 자동/수동 발송 체크
  • key_log — varchar(256) — 인증키 갱신 로그
  • support_level — varchar(40) — 서포트 플랜 레벨
  • support_start_date — date — 서포트 플랜 시작일
  • support_end_date — date — 서포트 플랜 종료일
  • taxbill_use — enum('Y', 'M', 'N') — NOT NULL — 청구세금계산서 설정. Y: 사용(자동발행), N: 사용안함, M: 수동발행
  • taxbill_seqno — bigint — 세금계산서 seqno
  • payer_account_id (seqno2) — int — Foreign key → aws_credentials.seqno — NOT NULL

aws_goods_price

  • goods_id — int — Primary key — NOT NULL
  • goods_category — varchar(50) — NOT NULL — A category that goods belong to. (ex AWS Support Plan)
  • goods_type — varchar(50) — NOT NULL — A type of goods (ex Developer, Business, Enterprice, ...)
  • goods_name — varchar(50) — NOT NULL — A name of goods (commited, interval1, interval2, ...)
  • goods_price — float — NOT NULL — Price (dollars)
  • interval_start — float — Start of cost interval
  • interval_end — float — End of cost interval
  • regist_date — timestamp
  • update_date — timestamp

aws_invoice_pdf

  • seqno — int — Primary key — NOT NULL
  • hosting_seq — int — NOT NULL — 서버번호
  • basic_year — varchar(4) — NOT NULL — 정산 대상 년도
  • basic_month — varchar(2) — NOT NULL — 정산 대상 월
  • basic_date — datetime — NOT NULL — 정산 대상 일
  • usd_total_cost — decimal(30, 20) — NOT NULL — 발생비용 (달러)
  • kor_total_cost — decimal(30, 20) — NOT NULL — 발생비용 (원)
  • invoice_price — decimal(30, 20) — NOT NULL — 발생비용 + 부가세 (원)
  • file_path — varchar(50) — NOT NULL — 보고서 저장 경로
  • file_name — varchar(200) — NOT NULL — 보고서 이름
  • regist_date — datetime — NOT NULL — 보고서 저장일
  • change_file_name — varchar(50) — NOT NULL — 보고서 이름 (raw버전)
  • memo — varchar(100) — 메모
  • aws_monitoring_report_seqno — int — 모니터링 내역서 시퀀스 번호
  • aws_monthly_report_seqno — int — 신규 이용 내역서 시퀀스번호
  • status_monitoring_mail — varchar(4000) — 모니터링내역서 요약메일링 결과
  • status_service_mail — varchar(4000) — 신규이용내역서 요약메일링 결과
  • ordernum — varchar(30) — 주문번호
  • status — varchar(10) — 월간 정산 결과

aws_monthly_monitoring_report

  • seqno — int — Primary key — NOT NULL
  • account_id — varchar(30)
  • summary — mediumtext
  • event — mediumtext
  • detail — mediumtext
  • threshold — mediumtext
  • report_month — varchar(8)
  • regist_date — datetime
  • report_version — varchar(6)
  • file_path — varchar(1024) — NOT NULL
  • file_name — varchar(1024) — NOT NULL

aws_monthly_report

  • seqno — int — Primary key — NOT NULL
  • account_id — varchar(30)
  • report_kind — varchar(2)
  • summary — mediumtext
  • payment — mediumtext
  • resource_summary — mediumtext
  • resource_ec2 — mediumtext
  • resource_ebs — mediumtext
  • resource_vpc — mediumtext
  • resource_autoscaling — mediumtext
  • resource_elb — mediumtext
  • resource_rds — mediumtext
  • resource_ecc — mediumtext
  • resource_s3 — mediumtext
  • resource_lightsail — mediumtext
  • resource_lightsaillb — mediumtext
  • resource_lightsailrdb — mediumtext
  • idc_work — mediumtext
  • regist_date — datetime
  • report_month — varchar(8)
  • report_version — varchar(6)
  • usd_total_cost — decimal(30, 20) — NOT NULL — 발생비용 (달러)
  • kor_total_cost — decimal(30, 20) — NOT NULL — 발생비용 (원)
  • invoice_price — decimal(30, 20) — NOT NULL — 발생비용 + 부가세 (원)
  • file_path — varchar(1024) — NOT NULL
  • file_name — varchar(1024) — NOT NULL

aws_report

  • seqno — int — Primary key — NOT NULL — bucket report 시퀀스
  • bucket_name — varchar(20) — NOT NULL — aws bucket 이름
  • report_prefix — varchar(20) — NOT NULL — aws report 이름
  • report_name — varchar(50) — NOT NULL — aws report 세부 이름

aws_service_autoscaling_plans

  • account_id — varchar(30) — Primary key — NOT NULL — l_item_usage_account_id of aws_gabia_account table
  • cron_day — int — Primary key — NOT NULL — cron 실행 일자
  • scaling_plan_name — varchar(32) — Primary key — NOT NULL — auto scaling plans name
  • creation_time — datetime — Primary key — NOT NULL — auto scaling plans 생성 일시
  • account_id (l_item_usage_account_id) — varchar(30) — Foreign key → aws_gabia_account.l_item_usage_account_id — NOT NULL — linked accout id
  • predefined_scaling_metric_type — varchar(64) — -
  • region — varchar(32) — AWS region
  • regist_date — datetime — 최초 저장 일시(일일 기준)
  • last_update — datetime — NOT NULL — cron 실행 일시

aws_service_ebs

  • account_id — varchar(30) — Primary key — NOT NULL — l_item_usage_account_id of aws_gabia_account table
  • cron_day — int — Primary key — NOT NULL — cron 실행 일자
  • volume_id — varchar(64) — Primary key — NOT NULL — EBS volume id
  • account_id (l_item_usage_account_id) — varchar(30) — Foreign key → aws_gabia_account.l_item_usage_account_id — NOT NULL — linked accout id
  • volume_type — varchar(16) — EBS volume_type
  • state — varchar(16) — 해당 EBS 서비스 상
  • ebs_size — varchar(16) — 해당 EBS 볼륨 size(G)
  • snapshot_id — varchar(64) — 해당 EBS snapshot_id
  • create_time — datetime — 해당 EBS 생성 일시
  • availability_zone — varchar(32) — 해당 EBS 서비스 가용 영역
  • instance_id — varchar(64) — EBS 볼륨에 연결된 EC2 Client 인스턴스 ID
  • region — varchar(32) — AWS region
  • regist_date — datetime — 최초 저장 일시(일일 기준)
  • last_update — datetime — NOT NULL — cron 실행 일시

aws_service_ec2

  • account_id — varchar(30) — Primary key — NOT NULL — l_item_usage_account_id of aws_gabia_account table
  • cron_day — int — Primary key — NOT NULL — cron 실행 일자
  • instance_id — varchar(64) — Primary key — NOT NULL — EC2 인스턴스 ID
  • account_id (l_item_usage_account_id) — varchar(30) — Foreign key → aws_gabia_account.l_item_usage_account_id — NOT NULL — linked accout id
  • instance_type — varchar(32) — EC instance type
  • public_ip_address — varchar(30) — EC2 public ip
  • private_ip_address — varchar(30) — EC2 private ip
  • availability_zone — varchar(32) — 해당 EC2 서비스 가용 영역
  • instance_state_name — varchar(16) — 해당 EC2 자원 상태
  • region — varchar(32) — AWS region
  • regist_date — datetime — 최초 저장 일시(일일 기준)
  • last_update — datetime — NOT NULL — cron 실행 일시

aws_service_elasticache

  • account_id — varchar(30) — Primary key — NOT NULL — l_item_usage_account_id of aws_gabia_account table
  • cron_day — int — Primary key — NOT NULL — cron 실행 일자
  • cache_cluster_id — varchar(20) — Primary key — NOT NULL — Elasticache
  • cache_cluster_create_time — datetime — Primary key — NOT NULL — Elasticache
  • account_id (l_item_usage_account_id) — varchar(30) — Foreign key → aws_gabia_account.l_item_usage_account_id — NOT NULL — linked accout id
  • cache_cluster_status — varchar(20) — Elasticache
  • port — varchar(8) — Elasticache
  • address — varchar(24) — Elasticache
  • cache_code_type — varchar(24) — Elasticache
  • engine — varchar(32) — Elasticache
  • region — varchar(32) — AWS region
  • regist_date — datetime — 최초 저장 일시(일일 기준)
  • last_update — datetime — NOT NULL — cron 실행 일시

aws_service_elb

  • account_id — varchar(30) — Primary key — NOT NULL — l_item_usage_account_id of aws_gabia_account table
  • cron_day — int — Primary key — NOT NULL — cron 실행 일자
  • dns_name — varchar(128) — Primary key — NOT NULL
  • created_time — datetime — Primary key — NOT NULL
  • account_id (l_item_usage_account_id) — varchar(30) — Foreign key → aws_gabia_account.l_item_usage_account_id — NOT NULL — linked accout id
  • load_balancer_name — varchar(64)
  • vpc_id — varchar(64)
  • availability_zones — varchar(255)
  • instance_ids — varchar(255)
  • region — varchar(32) — AWS region
  • regist_date — datetime — 최초 저장 일시(일일 기준)
  • last_update — datetime — NOT NULL — cron 실행 일시

aws_service_lightsail

  • account_id — varchar(30) — Primary key — NOT NULL — l_item_usage_account_id of aws_gabia_account table
  • cron_day — int — Primary key — NOT NULL — cron 실행 일자
  • arn — varchar(255) — Primary key — NOT NULL
  • account_id (l_item_usage_account_id) — varchar(30) — Foreign key → aws_gabia_account.l_item_usage_account_id — NOT NULL — linked accout id
  • lightsail_name — varchar(128)
  • availability_zone — varchar(32)
  • created_at — datetime
  • public_ip_address — varchar(20)
  • private_ip_address — varchar(20)
  • cpu_count — varchar(4)
  • ram_size_in_gb — varchar(8)
  • ports — varchar(32)
  • created_date — datetime
  • modified_date — datetime
  • region — varchar(32) — AWS region
  • regist_date — datetime — 최초 저장 일시(일일 기준)
  • last_update — datetime — NOT NULL — cron 실행 일시

aws_service_lightsail_lb

  • account_id — varchar(30) — Primary key — NOT NULL
  • cron_day — int — Primary key — NOT NULL
  • arn — varchar(255) — Primary key — NOT NULL
  • account_id (l_item_usage_account_id) — varchar(30) — Foreign key → aws_gabia_account.l_item_usage_account_id — NOT NULL — linked accout id
  • lightsail_lb_name — varchar(128)
  • created_at — datetime
  • availability_zone — varchar(32)
  • dns_name — varchar(128)
  • state — varchar(24)
  • protocol — varchar(16)
  • public_ports — varchar(8)
  • instance_port — varchar(8)
  • region — varchar(32)
  • regist_date — datetime
  • last_update — datetime — NOT NULL

aws_service_lightsail_rdb

  • account_id — varchar(30) — Primary key — NOT NULL
  • cron_day — int — Primary key — NOT NULL
  • arn — varchar(255) — Primary key — NOT NULL
  • account_id (l_item_usage_account_id) — varchar(30) — Foreign key → aws_gabia_account.l_item_usage_account_id — NOT NULL — linked accout id
  • lightsail_name — varchar(128)
  • availability_zone — varchar(32)
  • created_at — datetime
  • master_database_name — varchar(128)
  • state — varchar(32)
  • engine — varchar(32)
  • engine_version — varchar(24)
  • region — varchar(32)
  • regist_date — datetime
  • last_update — datetime — NOT NULL

aws_service_rds

  • account_id — varchar(30) — Primary key — NOT NULL — _item_usage_account_id of aws_gabia_account table
  • cron_day — int — Primary key — NOT NULL — cron 실행 일자
  • db_instance_identifier — varchar(64) — Primary key — NOT NULL
  • instance_create_time — datetime — Primary key — NOT NULL
  • account_id (l_item_usage_account_id) — varchar(30) — Foreign key → aws_gabia_account.l_item_usage_account_id — NOT NULL — linked accout id
  • db_name — varchar(64)
  • engine — varchar(64)
  • availability_zone — varchar(32)
  • db_instance_status — varchar(50)
  • backup_retention_period — varchar(8)
  • vpc_id — varchar(64) — NOT NULL
  • db_instance_class — varchar(32)
  • allocated_storage — varchar(16)
  • subnets — varchar(255)
  • region — varchar(32) — AWS region
  • regist_date — datetime — 최초 저장 일시(일일 기준)
  • last_update — datetime — NOT NULL — cron 실행 일시

aws_service_s3

  • account_id — varchar(30) — Primary key — NOT NULL — l_item_usage_account_id of aws_gabia_account table
  • cron_day — int — Primary key — NOT NULL — cron 실행 일자
  • name — varchar(64) — Primary key — NOT NULL
  • creation_date — datetime — Primary key — NOT NULL
  • account_id (l_item_usage_account_id) — varchar(30) — Foreign key → aws_gabia_account.l_item_usage_account_id — NOT NULL — linked accout id
  • display_name — varchar(64)
  • region — varchar(32) — AWS region
  • regist_date — datetime — 최초 저장 일시(일일 기준)
  • last_update — datetime — NOT NULL — cron 실행 일시

aws_service_vpc

  • account_id — varchar(30) — Primary key — NOT NULL — l_item_usage_account_id of aws_gabia_account table
  • cron_day — int — Primary key — NOT NULL — cron 실행 일자
  • vpc_id — varchar(64) — Primary key — NOT NULL
  • account_id (l_item_usage_account_id) — varchar(30) — Foreign key → aws_gabia_account.l_item_usage_account_id — NOT NULL — linked accout id
  • state — varchar(16)
  • cidr_block — varchar(20)
  • region — varchar(32) — AWS region
  • regist_date — datetime — NOT NULL — 최초 저장 일시(일일 기준)
  • last_update — datetime — NOT NULL — cron 실행 일시

aws_service_vpc_cidrs

  • account_id — varchar(30) — Primary key — NOT NULL
  • cron_day — int — Primary key — NOT NULL
  • vpc_id — varchar(64) — Primary key — NOT NULL
  • association_id — varchar(64) — Primary key — NOT NULL
  • association_id (l_item_usage_account_id) — varchar(30) — Foreign key → aws_gabia_account.l_item_usage_account_id — NOT NULL — linked accout id
  • cidr_block — varchar(20)
  • cidr_block_state — varchar(16)
  • regist_date — datetime — 최초 저장 일시(일일 기준)
  • last_update — datetime — NOT NULL

aws_supportplan_history

  • history_id — int — Primary key — NOT NULL
  • history_level — varchar(50) — NOT NULL — Support Plan Level name
  • history_startdate — datetime — Start date of support plan
  • history_enddate — datetime — End date of support plan
  • history_status — enum('Y', 'N') — NOT NULL — Support plan history status (Y: active, N: inactive)
  • account_id — varchar(30) — NOT NULL — AWS account id
  • regist_date — timestamp
  • update_date — timestamp

aws_threshold_policy

  • seqno — int — Primary key — NOT NULL
  • l_item_usage_account_id — varchar(30) — Foreign key → aws_gabia_account.l_item_usage_account_id — NOT NULL — linked accout id
  • account_id — varchar(30) — NOT NULL
  • policy_name — varchar(256)
  • description — varchar(256)
  • pseq — varchar(8)
  • scnt — varchar(8)
  • svrs — varchar(1024)
  • type — varchar(8)
  • monitoring_month — varchar(8) — NOT NULL

aws_user_notice

  • seqno — int — Primary key — NOT NULL
  • hosting_seq — int — NOT NULL
  • notice_type — varchar(10) — NOT NULL
  • notice_contents — varchar(50) — NOT NULL

budget

  • id — bigint — Primary key — NOT NULL — Primary Key
  • account_id (l_item_usage_account_id) — varchar(30) — Foreign key → aws_gabia_account.l_item_usage_account_id — NOT NULL — linked accout id
  • name — varchar(201) — NOT NULL — 예산 명
  • cycle — enum('daily', 'monthly') — NOT NULL — 예산 주기
  • budget — int — NOT NULL — 예산 금액
  • status — enum('register', 'delete') — NOT NULL — 예산 상태
  • email_alarm — enum('yes', 'no') — NOT NULL — 알림 타입
  • regist_id — varchar(100) — NOT NULL — 등록자(유저 본인일 경우 self)
  • regist_date — timestamp — NOT NULL — 등록 날자
  • update_date — timestamp — NOT NULL — 수정 날짜

budget_alarm_email

  • id — bigint — Primary key — NOT NULL — Primary Key
  • budget_id (id2) — bigint — Foreign key → budget.id — NOT NULL — Primary Key
  • email_address — varchar(200) — NOT NULL — email 주소
  • regist_date — timestamp — NOT NULL — 등록 날자
  • update_date — timestamp — NOT NULL — 수정 날짜

budget_alarm_log

  • id — bigint — Primary key — NOT NULL — Primary Key
  • budget_id (id2) — bigint — Foreign key → budget.id — NOT NULL — Primary Key
  • cost_date — date — NOT NULL — 비용 발생 날짜 (ex 2022-05-10)
  • email_campaign_no — varchar(100) — 이메일 발송 캠페인 번호
  • status — enum('register', 'delete') — NOT NULL — 로그 상태
  • regist_date — timestamp — NOT NULL — 등록 날자
  • update_date — timestamp — NOT NULL — 수정 날짜

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
  • usage_cost — double(15, 2) — Primary key — NOT NULL — 사용 금액 (SP, RI 구입 가격 포함)
  • 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 — 청구 금액
  • 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

rs_current_instance ('')

  • id — bigint — Primary key — NOT NULL
  • account_id (l_item_usage_account_id) — varchar(30) — Foreign key → aws_gabia_account.l_item_usage_account_id — NOT NULL — linked accout id
  • resource_id — varchar(100) — NOT NULL
  • instance_name — varchar(100) — NOT NULL
  • monthly_cost — varchar(100) — NOT NULL
  • total_running_hours_in_lookback_period — varchar(100) — NOT NULL
  • on_demand_hours_in_lookback_period — varchar(100)
  • reservation_covered_hours_in_lookback_period — varchar(100)
  • savings_plans_covered_hours_in_lookback_period — varchar(100)
  • instance_type — varchar(100) — NOT NULL
  • memory — varchar(100) — NOT NULL
  • network_performance — varchar(100) — NOT NULL
  • platform — varchar(100) — NOT NULL
  • region — varchar(100) — NOT NULL
  • sku — varchar(100) — NOT NULL
  • storage — varchar(100) — NOT NULL
  • v_cpu — varchar(100) — NOT NULL
  • max_cpu_utilization_percentage — varchar(100) — NOT NULL
  • max_memory_utilization_percentage — varchar(100) — NOT NULL
  • max_storage_utilization_percentage — varchar(100) — NOT NULL
  • ebs_read_ops_per_second — varchar(100) — NOT NULL
  • ebs_write_ops_per_second — varchar(100) — NOT NULL
  • ebs_read_bytes_per_second — varchar(100) — NOT NULL
  • ebs_write_bytes_per_second — varchar(100) — NOT NULL
  • network_in_bytes_per_second — varchar(100) — NOT NULL
  • network_out_bytes_per_second — varchar(100) — NOT NULL
  • network_packets_in_per_second — varchar(100) — NOT NULL
  • network_packets_out_per_second — varchar(100) — NOT NULL
  • insert_time — timestamp — NOT NULL
  • update_time — timestamp — NOT NULL

rs_reco_finding_reason

  • id — bigint — Primary key — NOT NULL
  • rs_current_instance_id (id2) — bigint — Foreign key → rs_current_instance.id — NOT NULL
  • default — tinyint(1) — NOT NULL
  • finding_reason — varchar(100) — NOT NULL
  • insert_time — timestamp — NOT NULL
  • update_time — timestamp — NOT NULL

rs_reco_instance

  • id — bigint — Primary key — NOT NULL
  • rs_current_instance_id (id2) — bigint — Foreign key → rs_current_instance.id — NOT NULL
  • default — tinyint(1) — NOT NULL
  • rightsizing_type — varchar(20) — NOT NULL
  • estimated_monthly_savings — varchar(100) — NOT NULL
  • estimated_monthly_cost — varchar(100) — NOT NULL
  • instance_type — varchar(100) — NOT NULL
  • memory — varchar(100) — NOT NULL
  • network_performance — varchar(100) — NOT NULL
  • platform — varchar(100) — NOT NULL
  • region — varchar(100) — NOT NULL
  • sku — varchar(100) — NOT NULL
  • storage — varchar(100) — NOT NULL
  • v_cpu — varchar(100) — NOT NULL
  • max_cpu_utilization_percentage — varchar(100) — NOT NULL
  • max_memory_utilization_percentage — varchar(100) — NOT NULL
  • max_storage_utilization_percentage — varchar(100) — NOT NULL
  • insert_time — timestamp — NOT NULL
  • update_time — timestamp — NOT NULL

rs_reco_summary

  • id — bigint — Primary key — NOT NULL
  • account_id (l_item_usage_account_id) — varchar(30) — Foreign key → aws_gabia_account.l_item_usage_account_id — NOT NULL — linked accout id
  • generation_timestamp — varchar(30) — NOT NULL
  • total_recommendation_count — int — NOT NULL
  • estimated_total_monthly_savings_amount — varchar(255) — NOT NULL
  • savings_percentage — varchar(255) — NOT NULL
  • insert_time — timestamp — NOT NULL
  • update_time — timestamp — NOT NULL