서비스_영역
테이블 (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)