서비스_영역

테이블 (6)

서비스 변경 (CopyOfUntitled)

  • job_id (Key) — string — 기본 키 — NOT NULL
  • app_key (Field) — string — NOT NULL
  • member_no (Field2) — string — NOT NULL
  • old_contract_no (Field4) — string — NOT NULL
  • new_contract_no (Field5) — string — NOT NULL
  • old_svc_name (Field6) — string — NOT NULL
  • new_svc_name (Field7) — string — NOT NULL
  • old_display_name (Field8) — INT — NOT NULL
  • new_display_name (Field9) — INT — NOT NULL
  • old_bill_plan (Field10) — INT — NOT NULL
  • new_bill_plan (Field11) — INT — NOT NULL
  • total_price (Field12) — INT — NOT NULL
  • old_month_price (Field13) — string — NOT NULL
  • new_month_price (Field14) — array
  • old_year_month_price (Field15) — array
  • new_year_month_price (Field3)
  • old_year_penalty_rate (Field16)
  • new_year_penalty_rate (Field17)
  • old_service_key (Field18)
  • new_service_key (Field19)
  • options (Field20)
  • userdata (Field21)

서비스 설치 (Untitled)

  • job_id (Key) — string — 기본 키 — NOT NULL
  • app_key (Field) — string — NOT NULL
  • member_no (Field2) — string — NOT NULL
  • username (Field3) — string — NOT NULL
  • contract_no (Field4) — string — NOT NULL
  • svc_name (Field5) — string — NOT NULL
  • display_name (Field6) — string — NOT NULL
  • bill_plan (Field7) — string — NOT NULL
  • total_price (Field8) — INT — NOT NULL
  • install_cost (Field9) — INT — NOT NULL
  • month_price (Field10) — INT — NOT NULL
  • year_month_price (Field11) — INT — NOT NULL
  • year_penalty_rate (Field12) — INT — NOT NULL
  • service_key (Field13) — string — NOT NULL
  • options (Field14) — array
  • userdata (Field15) — array

서비스 연장 (CopyOfCopyOfUntitled2)

  • job_id (Key) — string — 기본 키 — NOT NULL
  • app_key (Field) — string — NOT NULL
  • member_no (Field2) — string — NOT NULL
  • svc_name (Field5) — string — NOT NULL
  • display_name (Field6) — string — NOT NULL
  • service_key (Field13) — string — NOT NULL
  • new_contract_no (Field4)
  • old_contract_no (Field3)
  • total_price (Field7)
  • options (Field14) — array
  • userdata (Field15) — array

서비스 요금제 변경 (CopyOfCopyOfCopyOfUntitled2)

  • job_id (Key) — string — 기본 키 — NOT NULL
  • app_key (Field) — string — NOT NULL
  • member_no (Field2) — string — NOT NULL
  • old_contract_no (Field5) — string — NOT NULL
  • new_contract_no (Field6) — string — NOT NULL
  • old_bill_plan (Field13) — string — NOT NULL
  • new_bill_plan (Field4)
  • old_month_price (Field3)
  • new_month_price (Field7)
  • old_year_month_price (Field14) — array
  • new_year_month_price (Field15) — array
  • old_year_penalty_rate (Field8)
  • new_year_penalty_rate (Field9)

서비스 중지 (CopyOfUntitled2)

  • job_id (Key) — string — 기본 키 — NOT NULL
  • app_key (Field) — string — NOT NULL
  • member_no (Field2) — string — NOT NULL
  • contract_no (Field4) — string — NOT NULL
  • svc_name (Field5) — string — NOT NULL
  • display_name (Field6) — string — NOT NULL
  • service_key (Field13) — string — NOT NULL
  • options (Field14) — array
  • userdata (Field15) — array

서비스 해지 (CopyOfCopyOfCopyOfCopyOfUntitled2)

  • job_id (Key) — string — 기본 키 — NOT NULL
  • app_key (Field) — string — NOT NULL
  • member_no (Field2) — string — NOT NULL
  • old_contract_no (Field5) — string — NOT NULL
  • new_contract_no (Field6) — string — NOT NULL
  • old_bill_plan (Field13) — string — NOT NULL
  • new_bill_plan (Field4)
  • old_month_price (Field3)
  • new_month_price (Field7)
  • old_year_month_price (Field14) — array
  • new_year_month_price (Field15) — array
  • old_year_penalty_rate (Field8)
  • new_year_penalty_rate (Field9)