연습

테이블 (10)

CUSTOMER_KT (Untitled4)

  • SERVICE_ACCOUNT (Key) — NUMBER — 기본 키 — NOT NULL
  • SERVICE_TYPE (Field) — NUMBER
  • SOC (Field2) — VARCHAR2(60)
  • ENTER_DATE (Field3) — VARCHAR2(60)
  • ..... (Field4) — ......

CUSTOMER_LGT (Untitled3)

  • SERVICE_ACCOUNT — NUMBER — 기본 키 — NOT NULL
  • SOC — VARCHAR2(60)
  • ENTER_DATE — NUMBER
  • SERVICE_TYPE — NUMBER
  • STOP_DT (Field) — DATE
  • CANCEL_DT (Field2) — DATE
  • AGENT_ID (Field3) — VARCHAR2(20)
  • ..... (Field4) — ......

CUSTOMER_SKT (Untitled2)

  • SERVICE_ACCOUNT — NUMBER — 기본 키 — NOT NULL
  • STATUS — VARCHAR2(10)
  • BALANCE — NUMBER
  • ENTER_DATE — DATE
  • CANCEL_DT — DATE
  • STOP_DT — DATE
  • AGENT_ID — VARCHAR2(20)
  • SALE_ID — VARCHAR2(20)
  • ...... — ......

KT_JUO_ADD (Untitled7)

  • CONTRACT_NUM (Key) — NUMBER — 기본 키 — NOT NULL
  • MODEL_ID (Field) — VARCHAR2(60)
  • MODEL_NM (Field2) — VARCHAR2(60)
  • TRTM_PRSN_ID (Field3) — VARCHAR2(60)
  • DVC_OFW_AMNT (Field4) — NUMBER
  • ........ (Field5) — .............

KT_JUO_CUS (Untitled6)

  • CUSTOMER_ID (Key) — NUMBER — 기본 키 — NOT NULL
  • CUSTOMER_TYPE (Field) — VARCHAR2(10)
  • CUSTOMER_SSN (Field2) — VARCHAR2(60)
  • CUSTOMER_ADR_ZIP (Field3) — NUMBER
  • ......... (Field4) — .........

KT_JUO_SUB (Untitled5)

  • CONTRACT_NUM (Key) — NUMBER — 기본 키 — NOT NULL
  • SUBSCRIBER_NO (Field2) — NUMBER
  • CUSTOMER_BAN (Field) — NUMBER
  • SUB_STATUS (Field3) — VARCHAR2(10)
  • SUB_ADR_ZIP (Field4) — NUMBER
  • SUB_ADR_PRIMARY_LN (Field5) — VARCHAR(70)
  • ...... (Field6) — ..........
  • CUSTOMER_ID (FIELD) — NUMBER — NOT NULL

LGT_CUS (CopyOfUntitled3)

  • CUSTOMER_ID — NUMBER — 기본 키 — NOT NULL
  • CSSN (Field) — VARCHAR2(70)
  • CADDRZIP (Field2) — NUMBER
  • CPRMADDRLN (Field3) — VARCHAR2(60)
  • CSECADDRLN (Field4) — VARCHAR2(60)
  • ........ (Field5) — ......

LGT_SUB (CopyOfCopyOfUntitled3)

  • CONTRACT_NUM — NUMBER — 기본 키 — NOT NULL
  • SERVICE_NUMBER (Field) — NUMBER
  • USSN (Field2) — VARCHAR2(60)
  • STATUS (Field3) — VARCAHR2(10)
  • ,,,,, (Field4) — ,,,,,,
  • CUSTOMER_ID — NUMBER — NOT NULL

SKT_CUSTOMER (Untitled)

  • SERIVCE_ACCOUNT (SERVICE_ACCOUNT) — NUMBER — 기본 키 — NOT NULL
  • SERVICE_TYPE — NUMBER
  • SERVICE_NUMBER — NUMBER
  • PROC_ID — VARCHAR2(20)
  • PROD_CD — VARCHAR2(20)
  • OPEN_DATE — DATE
  • SCRB_REQ_RSN_CD — VARCHAR2(20)
  • ADDR — VARCHAR2(60)
  • CUST_FRST_NM — VARCHAR2(60)
  • ....... (......) — ......

개통실적 (Untitled8)

  • 서비스계정 (Key) — 기본 키 — NOT NULL
  • SERIVCE_ACCOUNT (SERVICE_ACCOUNT) — NUMBER — 외래 키 → SKT_CUSTOMER.SERIVCE_ACCOUNT — NOT NULL
  • SERVICE_ACCOUNT (SERVICE_ACCOUNT2) — NUMBER — 외래 키 → CUSTOMER_SKT.SERVICE_ACCOUNT — NOT NULL
  • SERVICE_ACCOUNT (Key2) — NUMBER — 외래 키 → CUSTOMER_KT.SERVICE_ACCOUNT — NOT NULL
  • CONTRACT_NUM (Key3) — NUMBER — 외래 키 → KT_JUO_SUB.CONTRACT_NUM — NOT NULL
  • CONTRACT_NUM — NUMBER — 외래 키 → LGT_SUB.CONTRACT_NUM — NOT NULL
  • CUSTOMER_ID (CUSTOMER_ID2) — NUMBER — 외래 키 → LGT_CUS.CUSTOMER_ID — NOT NULL
  • CUSTOMER_ID (Key4) — NUMBER — 외래 키 → KT_JUO_CUS.CUSTOMER_ID — NOT NULL
  • CONTRACT_NUM (Key5) — NUMBER — 외래 키 → KT_JUO_ADD.CONTRACT_NUM — NOT NULL
  • 선후불 (Field)
  • 요금제 (Field2)
  • 통신사 (Field3)
  • 이메일주소 (Field4)
  • 청구서종류 (Field5)
  • 약정여부 (Field6)
  • 약정기간 (Field7)
  • 단말할부기간 (Field8)
  • 할인코드 (Field9)
  • 주소 (Field10)
  • 가입구분 (Field11)