[현대오토에버 PoC] CC 개발 ERD
테이블 (12)
CC_ACCOUNT (고객)
- ACCOUNT_UUID (PK) — UUID — 기본 키
- EXTERNAL_ID (Field1) — VARCHAR(20)
- NAME (Field2) — VARCHAR(40)
- CUSTOMER_GROUP (Field3) — VARCHAR(20)
- CREATEDAT (Field4) — DATE
- CREATEDBY (Field5) — VARCHAR(255)
- MODIFIEDAT (Field6) — DATE
- MODIFIEDBY (Field7) — VARCHAR(255)
- DELETE_FLAG (Field8) — BOOLEAN
CC_PRICE_PLAN_MST (가격 계획)
- PRICE_PLAN_MST_UUID (PK) — UUID — 기본 키
- DISPLAY_ID (Field1) — VARCHAR(20)
- ACTIVE_VER (Field2) — NUMC(3)
- CURRENT_VER (Field3) — NUMC(3)
- NAME (Field4) — VARCHAR(40)
- FROM_DATE (Field5) — DATE
- TO_DATE (Field6) — DATE
- STATUS (Field7) — VARCHAR(10)
- CREATEDAT (Field8) — DATE
- CREATEDBY (Field9) — VARCHAR(255)
- MODIFIEDAT (Field10) — DATE
- MODIFIEDBY (Field11) — VARCHAR(255)
- DELETE_FLAG (Field12) — BOOLEAN
CC_PRICE_PLAN_REL (가격 계획 관계)
- PRICE_PLAN_REL_UUID (PK) — UUID — 기본 키
- PRODUCT_UUID (FK) — UUID — 외래 키 → CC_PRODUCT.PRODUCT_UUID
- PRICE_PLAN_RULE_UUID (FK2) — UUID — 외래 키 → CC_PRICE_PLAN_RULE.PRICE_PLAN_RULE_UUID
- CUSTOMER_GROUP (Field1) — VARCHAR(20)
- CREATEDAT (Field2) — DATE
- CREATEDBY (Field3) — VARCHAR(255)
- MODIFIEDAT (Field4) — DATE
- MODIFIEDBY (Field5) — VARCHAR(255)
- DELETE_FLAG (Field6) — BOOLEAN
CC_PRICE_PLAN_RULE (가격 계획 규칙)
- PRICE_PLAN_RULE_UUID (PK) — UUID — 기본 키
- PRICE_PLAN_MST_UUID (FK) — UUID — 외래 키 → CC_PRICE_PLAN_MST.PRICE_PLAN_MST_UUID
- VER (Field1) — NUMC(3)
- PLAN_TYPE (Field2) — VARCHAR(10)
- DEFINE_PRICE (Field3) — VARCHAR(10)
- FROM_DATE (Field4) — DATE
- TO_DATE (Field5) — DATE
- ACTIVE_DATE (Field6) — DATE
- CREATEDAT (Field7) — DATE
- CREATEDBY (Field8) — VARCHAR(255)
- MODIFIEDAT (Field9) — DATE
- MODIFIEDBY (Field10) — VARCHAR(255)
- DELETE_FLAG (Field11) — BOOLEAN
CC_PRODUCT (상품)
- PRODUCT_UUID (PK) — UUID — 기본 키
- EXTERNAL_ID (Field1) — VARCHAR(20)
- CREATEDAT (Field2) — DATE
- CREATEDBY (Field3) — VARCHAR(255)
- MODIFIEDAT (Field4) — DATE
- MODIFIEDBY (Field5) — VARCHAR(255)
- DELETE_FLAG (Field6) — BOOLEAN
CC_SYS_INFO (시스템 설정)
- UUID (PK) — UUID — 기본 키
- NAME (Field1) — VARCHAR(40)
- DEFINE_PRICE (Field2) — VARCHAR(10)
- CREATEDAT (Field3) — DATE
- CREATEDBY (Field4) — VARCHAR(255)
- MODIFIEDAT (Field5) — DATE
- MODIFIEDBY (Field6) — VARCHAR(255)
- DELETE_FLAG (Field7) — BOOLEAN
CC_TECHNICAL_RESOURCE (계약)
- TECHNICAL_RESOURCE_UUID (PK) — UUID — 기본 키
- PRICE_PLAN_RULE_UUID (FK) — UUID — 외래 키 → CC_PRICE_PLAN_RULE.PRICE_PLAN_RULE_UUID
- TR_TYPE (Field1) — VARCHAR(10)
- TR_ID (Field2) — VARCHAR(20)
- CONTRACT_ID (Field3) — VARCHAR(10)
- PRODUCT_ID (Field4) — VARCHAR(10)
- CONTRACT_CREATE_DATE (Field5) — DATE
- CONTRACT_CREATE_FROM (Field6) — DATE
- CONTRACT_CREATE_TO (Field7) — DATE
- BILLING_CYCLE (Field8) — VARCHAR(4)
- ACCOUNT_ID (Field9) — VARCHAR(10)
- CREATEDAT (Field10) — DATE
- CREATEDBY (Field11) — VARCHAR(255)
- MODIFIEDAT (Field12) — DATE
- MODIFIEDBY (Field13) — VARCHAR(255)
- DELETE_FLAG (Field14) — BOOLEAN
CC_USAGE_PLAN_ITEM (상세 규칙)
- USAGE_PLAN_ITEM_UUID (PK) — UUID — 기본 키
- PRICE_PLAN_RULE_UUID (FK) — UUID — 외래 키 → CC_PRICE_PLAN_RULE.PRICE_PLAN_RULE_UUID
- TYPE (Field1) — VARCHAR(10)
- CONDITION (Field2) — VARCHAR(10)
- PARAMETER (Field3) — VARCHAR(10)
- VALUE (Field4) — DECIMAL(15, 2)
- UNIT (Field5) — UNIT(3)
- CURRENC Y (Field6) — CUKY(5)
- ORDER (Field7) — VARCHAR(10)
- CREATEDAT (Field8) — DATE
- CREATEDBY (Field9) — VARCHAR(255)
- MODIFIEDAT (Field10) — DATE
- MODIFIEDBY (Field11) — VARCHAR(255)
- DELETE_FLAG (Field12) — BOOLEAN
CC_USAGE_REQ (사용량 요청)
- USAGE_REQ_UUID (PK) — UUID — 기본 키
- REQ_ID (Field1) — VARCHAR(20)
- TR_TYPE (Field2) — VARCHAR(10)
- TR_ID (Field3) — VARCHAR(20)
- CONTRACT_ID (Field4) — VARCHAR(10)
- REQ_USAGE (Field5) — QUAN(15)
- UNIT (Field6) — UNIT(3)
- REQ_DATE (Field7) — DATE
- CREATEDAT (Field9) — DATE
- CREATEDBY (Field10) — VARCHAR(255)
- MODIFIEDAT (Field11) — DATE
- MODIFIEDBY (Field12) — VARCHAR(255)
- DELETE_FLAG (Field13) — BOOLEAN
CC_USAGE_RES (사용량 결과)
- USAGE_RES_UUID (PK) — UUID — 기본 키
- ACCOUNT_UUID (Field1) — UUID
- CONTRACT_ID (Field2) — VARCHAR(10)
- PRICE (Field3) — DECIMAL(15, 2)
- CURRENC Y (Field4) — CUKY(5)
- RES_DATE (Field5) — DATE
- BILLIABLE_ITEM_ID (Field6) — VARCHAR(10)
- CREATEDAT (Field7) — DATE
- CREATEDBY (Field8) — VARCHAR(255)
- MODIFIEDAT (Field9) — DATE
- MODIFIEDBY (Field10) — VARCHAR(255)
- DELETE_FLAG (Field11) — BOOLEAN
CC_USAGE_RES_CALC_RST (사용량 계산 결과)
- USAGE_RES_DTL_UUID (FK) — UUID — 외래 키 → CC_USAGE_RES_DTL.USAGE_RES_DTL_UUID
- PRICE_PLAN_RULE_UUID (FK2) — UUID — 외래 키 → CC_PRICE_PLAN_RULE.PRICE_PLAN_RULE_UUID
- CREATEDAT (Field) — DATE
- CREATEDBY (Field2) — VARCHAR(255)
- MODIFIEDAT (Field3) — DATE
- MODIFIEDBY (Field4) — VARCHAR(255)
- DELETE_FLAG (Field5) — BOOLEAN
CC_USAGE_RES_DTL (사용량 결과 상세)
- USAGE_RES_DTL_UUID (PK) — UUID — 기본 키
- USAGE_REQ_UUID (FK) — UUID — 외래 키 → CC_USAGE_REQ.USAGE_REQ_UUID
- USAGE_RES_UUID (FK2) — UUID — 외래 키 → CC_USAGE_RES.USAGE_RES_UUID
- PRICE_PLAN_RULE_UUID (FK3) — UUID — 외래 키 → CC_PRICE_PLAN_RULE.PRICE_PLAN_RULE_UUID
- RES_DATE (Field1) — DATE
- BILLIABLE_ITEM_ID (Field2) — VARCHAR(10)
- PRICE (Field3) — DECIMAL(15, 2)
- CURRENC Y (Field4) — CUKY(5)
- CREATEDAT (Field5) — DATE
- CREATEDBY (Field6) — VARCHAR(255)
- MODIFIEDAT (Field7) — DATE
- MODIFIEDBY (Field8) — VARCHAR(255)
- DELETE_FLAG (Field9) — BOOLEAN