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 (상위상품)