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