1231

Tables (6)

EAI_CATV_RCV

  • UNISYSTEM_ID — VARCHAR2(4) — Primary key — NOT NULL
  • MESSAGE_ID — VARCHAR2(32) — Primary key — NOT NULL
  • DATE_TIME — VARCHAR2(18) — Primary key — NOT NULL
  • ORDR — VARCHAR2(50)
  • 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 — VARCHAR2(5000)
  • 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)
  • MSG_TY — VARCHAR2(1)
  • RECV_TIME — CHAR(17) — NOT NULL
  • DEAL_STAT — CHAR(1) — NOT NULL
  • DEAL_DESC — VARCHAR2(1000)

EAI_COAXIAL_RCV

  • UNISYSTEM_ID — VARCHAR2(4) — Primary key — NOT NULL
  • MESSAGE_ID — VARCHAR2(32) — Primary key — NOT NULL
  • DATE_TIME — VARCHAR2(18) — Primary key — NOT NULL
  • ORDR — VARCHAR2(50)
  • 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 — VARCHAR2(5000)
  • 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)
  • MSG_TY — VARCHAR2(1)
  • RECV_TIME — CHAR(17) — NOT NULL
  • DEAL_STAT — CHAR(1) — NOT NULL
  • DEAL_DESC — VARCHAR2(1000)

EAI_INTERNETPHONE_RCV

  • UNISYSTEM_ID — VARCHAR2(4) — Primary key — NOT NULL
  • MESSAGE_ID — VARCHAR2(32) — Primary key — NOT NULL
  • DATE_TIME — VARCHAR2(18) — Primary key — NOT NULL
  • ORDR — VARCHAR2(50)
  • 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 — VARCHAR2(5000)
  • LC — VARCHAR2(50)
  • PHONE — VARCHAR2(50)
  • PHONE_SL — VARCHAR2(50)
  • RENT_EQPM — VARCHAR2(50)
  • RENT_EQPM_SL — VARCHAR2(50)
  • USER_IP — VARCHAR2(300)
  • UPT_DT — VARCHAR2(20)
  • MSG_TY — VARCHAR2(1)
  • RECV_TIME — CHAR(17) — NOT NULL
  • DEAL_STAT — CHAR(1) — NOT NULL
  • DEAL_DESC — VARCHAR2(1000)

EAI_INTERNET_RCV

  • UNISYSTEM_ID — VARCHAR2(4) — Primary key — NOT NULL
  • MESSAGE_ID — VARCHAR2(32) — Primary key — NOT NULL
  • DATE_TIME — VARCHAR2(18) — Primary key — NOT NULL
  • ORDR — VARCHAR2(50)
  • 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 — VARCHAR2(5000)
  • 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)
  • USER_IP — VARCHAR2(300)
  • UPT_DT — VARCHAR2(20)
  • MSG_TY — VARCHAR2(1)
  • RECV_TIME — CHAR(17) — NOT NULL
  • DEAL_STAT — CHAR(1) — NOT NULL
  • DEAL_DESC — VARCHAR2(1000)

EAI_OPTICAL_RCV

  • UNISYSTEM_ID — VARCHAR2(4) — Primary key — NOT NULL
  • MESSAGE_ID — VARCHAR2(32) — Primary key — NOT NULL
  • DATE_TIME — VARCHAR2(18) — Primary key — NOT NULL
  • ORDR — VARCHAR2(50)
  • 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 — VARCHAR2(5000)
  • NOTE — VARCHAR2(256)
  • UPT_DT — VARCHAR2(20)
  • MSG_TY — VARCHAR2(1)
  • RECV_TIME — CHAR(17) — NOT NULL
  • DEAL_STAT — CHAR(1) — NOT NULL
  • DEAL_DESC — VARCHAR2(1000)

EAI_PHONE_RCV

  • UNISYSTEM_ID — VARCHAR2(4) — Primary key — NOT NULL
  • MESSAGE_ID — VARCHAR2(32) — Primary key — NOT NULL
  • DATE_TIME — VARCHAR2(18) — Primary key — NOT NULL
  • ORDR — VARCHAR2(50)
  • 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 — VARCHAR2(5000)
  • LC — VARCHAR2(50)
  • UPT_DT — VARCHAR2(20)
  • MSG_TY — VARCHAR2(1)
  • RECV_TIME — CHAR(17) — NOT NULL
  • DEAL_STAT — CHAR(1) — NOT NULL
  • DEAL_DESC — VARCHAR2(1000)