[현대오토에버 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