선번장_물리
테이블 (8)
TB_CATV
- ORDR — NUMBER — 기본 키 — NOT NULL
- WORK_SE — VARCHAR2(50)
- RCPT_NO — VARCHAR2(50)
- OPTR_DT — VARCHAR2(20)
- PROP — VARCHAR2(20)
- SSCO — VARCHAR2(50)
- AUSR — VARCHAR2(50)
- OPERTOR — VARCHAR2(50)
- PATH — CLOB
- LC — VARCHAR2(50)
- STBOX — VARCHAR2(50)
- TAP_NM — VARCHAR2(50)
- TAP_LNNO — VARCHAR2(50)
- BILL_YN — VARCHAR2(2)
- NOTE — VARCHAR2(256)
- UPT_DT — VARCHAR2(20)
TB_COAXIAL
- ORDR — NUMBER — 기본 키 — NOT NULL
- WORK_SE — VARCHAR2(50)
- RCPT_NO — VARCHAR2(50)
- MGMT_NO — VARCHAR2(50)
- OPTR_DT — VARCHAR2(20)
- PROP — VARCHAR2(20)
- SSCO — VARCHAR2(50)
- AUSR — VARCHAR2(50)
- OPERTOR — VARCHAR2(50)
- PATH — CLOB
- FROM_BULD_NM — VARCHAR2(50)
- FROM_COMM_ROOM_NM — VARCHAR2(50)
- FROM_MNN — VARCHAR2(50)
- FROM_PPB — VARCHAR2(50)
- FROM_PPB_PORT — VARCHAR2(20)
- FROM_LC — VARCHAR2(100)
- FROM_STBOX — VARCHAR2(50)
- TO_BULD_NM — VARCHAR2(50)
- TO_COMM_ROOM_NM — VARCHAR2(50)
- TO_MNN — VARCHAR2(50)
- TO_PPB — VARCHAR2(50)
- TO_PPB_PORT — VARCHAR2(20)
- TO_LC — VARCHAR2(100)
- TO_STBOX — VARCHAR2(50)
- NOTE — VARCHAR2(256)
- UPT_DT — VARCHAR2(20)
TB_INTERNET
- ORDR — NUMBER — 기본 키 — NOT NULL
- RCPT_NO — VARCHAR2(50)
- EQPM_NM — VARCHAR2(50)
- EQPM_PORT — VARCHAR2(20)
- BULD — VARCHAR2(50)
- COMM_ROOM — VARCHAR2(50)
- IP — VARCHAR2(15)
- SSCO — VARCHAR2(50)
- AUSR — VARCHAR2(50)
- STBOX — VARCHAR2(50)
- PPB — VARCHAR2(50)
- PPB_PORT — VARCHAR2(20)
- WORK_SE — VARCHAR2(50)
- OPTR_DT — VARCHAR2(20)
- PROP — VARCHAR2(20)
- OPERTOR — VARCHAR2(50)
- PATH — CLOB
- LC — VARCHAR2(50)
- VLAN — VARCHAR2(50)
- BIT — VARCHAR2(50)
- TRML_KND — VARCHAR2(20)
- RENT_EQPM — VARCHAR2(50)
- RENT_EQPM_SL — VARCHAR2(50)
- NOTE — VARCHAR2(256)
- UPT_DT — VARCHAR2(20)
TB_INTERNETPHONE
- ORDR — NUMBER — 기본 키 — NOT NULL
- TEL_NO — VARCHAR2(20)
- BULD — VARCHAR2(50)
- COMM_ROOM — VARCHAR2(50)
- EQPM_NM — VARCHAR2(50)
- EQPM_PORT — VARCHAR2(20)
- RCPT_NO — VARCHAR2(50)
- SSCO — VARCHAR2(50)
- AUSR — VARCHAR2(50)
- PROP — VARCHAR2(20)
- USER — VARCHAR2(50)
- IP — VARCHAR2(15)
- STBOX — VARCHAR2(50)
- WORK_SE — VARCHAR2(50)
- PPB — VARCHAR2(50)
- PPB_PORT — VARCHAR2(20)
- OPTR_DT — VARCHAR2(20)
- NOTE — VARCHAR2(256)
- OPERTOR — VARCHAR2(50)
- PATH — CLOB
- LC — VARCHAR2(50)
- PHONE — VARCHAR2(50)
- PHONE_SL — VARCHAR2(50)
- RENT_EQPM — VARCHAR2(50)
- RENT_EQPM_SL — VARCHAR2(50)
- UPT_DT — VARCHAR2(20)
TB_INTERNETPHONEUSER
- IP — VARCHAR2(15) — 기본 키 — NOT NULL
- ORDR (ORDR2) — NUMBER — 외래 키 → TB_INTERNETPHONE.ORDR — NOT NULL
TB_INTERNETUSER
- IP — VARCHAR2(15) — 기본 키 — NOT NULL
- ORDR (ORDR2) — NUMBER — 외래 키 → TB_INTERNET.ORDR — NOT NULL
TB_OPTICAL
- ORDR — NUMBER — 기본 키 — NOT NULL
- WORK_SE — VARCHAR2(50)
- RCPT_NO — VARCHAR2(50)
- MGMT_NO — VARCHAR2(50)
- DSTNC — VARCHAR2(20)
- OPTR_DT — VARCHAR2(20)
- PROP — VARCHAR2(20)
- SSCO — VARCHAR2(50)
- AUSR — VARCHAR2(50)
- OPERTOR — VARCHAR2(50)
- PATH — CLOB
- NOTE — VARCHAR2(256)
- UPT_DT — VARCHAR2(20)
TB_PHONE
- ORDR — NUMBER — 기본 키 — NOT NULL
- TELNO — VARCHAR2(20)
- AGMG — VARCHAR2(20)
- EN — VARCHAR2(20)
- AUSR — VARCHAR2(50)
- BULD — VARCHAR2(50)
- COMM_ROOM — VARCHAR2(50)
- MNN — VARCHAR2(50)
- PPB_ONE — VARCHAR2(50)
- PPB_TWO — VARCHAR2(50)
- STBOX_ONE — VARCHAR2(50)
- STBOX_TWO — VARCHAR2(50)
- WORK_SE — VARCHAR2(50)
- OPTR_DT — VARCHAR2(20)
- NOTE — VARCHAR2(256)
- PROP — VARCHAR2(20)
- SSCO — VARCHAR2(50)
- RCPT_NO — VARCHAR2(50)
- OPERTOR — VARCHAR2(50)
- PATH — CLOB
- LC — VARCHAR2(50)
- UPT_DT — VARCHAR2(20)