test

Tables (6)

bil_tccbs_daily_usage

  • so_id — CHAR(2)
  • ctrt_id — VARCHAR(10) — NOT NULL
  • usg_type — VARCHAR(10)
  • usg_strt_dt — TIMESTAMP — NOT NULL
  • usg_end_dt — TIMESTAMP — NOT NULL
  • rated_chrg — NUMERIC(10,2)
  • bus_name — VARCHAR(100) — NOT NULL
  • max_usage — VARCHAR(100)
  • avg_usage — VARCHAR(100)
  • timezone — VARCHAR(60)
  • currency — VARCHAR(3)
  • sub_prod_cd — VARCHAR(10)
  • chrg_itm_cd — VARCHAR(10)
  • svc_rate_itm_typ_nm — VARCHAR(100)
  • cpu_core — REAL
  • memory_gb — NUMERIC(10,2)
  • disk_gb — INTEGER
  • svc_lvl — VARCHAR(5)
  • system_id — VARCHAR(60)
  • code — VARCHAR(4)
  • basic_prod_fl — VARCHAR(1)
  • created_by — VARCHAR(60) — NOT NULL
  • created_dt — TIMESTAMP — NOT NULL
  • modified_by — VARCHAR(60) — NOT NULL
  • modified_dt — TIMESTAMP — NOT NULL

billing_d_batch (청구내역)

  • sub_product_cd (상품코드)
  • start_dt (배치구동일)
  • project_id (프로젝트아이디)
  • ctrt_id (계약아이디)
  • cost (금액)

billing_summary (청구월합계)

  • product_cd (Field)
  • month (Field2)
  • project_id (Field3)
  • ctrt_id (Field4)
  • cost (Field5)

contract_info (원장정보)

  • CONTRACT_ID (Field2) — Primary key
  • PRODUCT_CODE (Field)
  • PROJECT_ID (Field3)

product_meta (상품정보)

  • PRODUCT_CODE (상품정보)
  • PRODUCT_NAME (상품레벨)
  • PRODUCT_TYPE_CODE (상위상품)

project_info (프로젝트 정보)

  • project_id (Field)