연습
테이블 (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)