IAS

Tables (14)

ACQUISITION_CODE (Untitled9)

  • APP_OS (Field2) — VARCHAR2(100)
  • ACQUISITION_TYPE (Field3) — VARCHAR2(100)
  • Field
  • ACQUISION_CODE (Field4) — NUMBER

APP_DEL_TEST (Untitled7)

  • APP_D_ID (Key) — NUMBER — Foreign key → APP_VERSION.APP_V_ID — NOT NULL
  • APP_ID (Field19) — NUMBER — Foreign key → APP_VERSION.APP_ID
  • PACKAGE_NAME (Field) — VARCHAR2(1000)
  • APP_NAME (Field2) — VARCHAR2(1000)
  • APP_OS (Field3) — VARCHAR2(100)
  • ACQUISTION_TYPE (Field4) — VARCHAR2(50)
  • MODEL (Field5) — VARCHAR2(100)
  • MODEL_NAME (Field6) — VARCHAR2(100)
  • OS_VERSION (Field7) — VARCHAR2(100)
  • UDATE (Field8) — DATE
  • TDATE (Field9) — DATE
  • APP_VERSION (Field10) — VARCHAR2(100)
  • G_CHAT_ONLY_ME (Field11) — VARCHAR2(10)
  • G_CHAT_ALL (Field12) — VARCHAR2(10)
  • G_CHAT_CHAT_OUT (Field13) — VARCHAR2(10)
  • G_CHAT_MESSAGE_DEL (Field14) — VARCHAR2(10)
  • S_CHAT_DEL (Field15) — VARCHAR2(50)
  • S_CHAT_CHAT_OUT (Field16) — VARCHAR2(50)
  • S_CHAT_MESSAGE_DEL (Field17) — VARCHAR2(50)
  • Field18

APP_ENCYPTION (Untitled4)

  • APP_V_ID (Key) — NUMBER — Foreign key → APP_FILE.APP_V_ID — NOT NULL
  • APP_ID (Field22) — NUMBER — Foreign key → APP_FILE.APP_ID
  • APP_FILE_ID (Field32) — NUMBER — Foreign key → APP_FILE.APP_FILE_ID
  • PACKAGE_NAME (Field2) — VARCHAR2(1000)
  • APP_VERSION (Field3) — VARCHAR2(1000)
  • FILE_NAME (Field4) — VARCHAR2(1000)
  • ENCYPTION_TYPE (Field5) — VARCHAR2(100)
  • KEY_INFO (Field6) — VARCHAR2(1000)
  • Field7

APP_FILE (Untitled2)

  • APP_FILE_ID (Field3) — NUMBER — Primary key
  • APP_V_ID (Key) — NUMBER — Foreign key → APP_VERSION.APP_V_ID — NOT NULL
  • APP_ID (Field2) — NUMBER — Foreign key → APP_VERSION.APP_ID
  • PACKAGE_NAME (Field4) — VARCHAR2(1000)
  • APP_VERSION (Field5) — VARCHAR2(100)
  • FILE_PATH (Field6) — VARCHAR2(1000)
  • FILE_NAME (Field7) — VARCHAR2(1000)
  • FILE_TYPE (Field8) — VARCHAR2(50)
  • FILE_INFO (Field9) — VARCHAR2(3000)
  • SCHEMA (Field10) — NUMBER
  • ENCYPTION (Field11)

APP_SCHEMA (Untitled3)

  • APP_V_ID (Key) — NUMBER — Foreign key → APP_FILE.APP_V_ID — NOT NULL
  • APP_ID (Field2) — NUMBER — Foreign key → APP_FILE.APP_ID
  • APP_FILE_ID (Field3) — NUMBER — Foreign key → APP_FILE.APP_FILE_ID
  • PACKAGE_NAME (Field4) — VARCHAR2(1000)
  • APP_VERSION (Field5) — VARCHAR2(1000)
  • FILE_NAME (Field6) — VARCHAR2(1000)
  • TABLE_NAME (Field7) — VARCHAR2(1000)
  • TABLE_INFO (Field8) — VARCHAR2(50)
  • COLUMN_NAME (Field9) — VARCHAR2(50)
  • DATA_TYPE (Field10) — VARCHAR2(50)
  • COLUMN_INFO (Field11) — VARCHAR2(50)
  • ETC (Field12) — VARCHAR2(50)

APP_UPDATE (Untitled12)

  • APP_D_ID (Key) — NUMBER — Foreign key → APP_VERSION.APP_V_ID — NOT NULL
  • APP_ID (Field5) — NUMBER — Foreign key → APP_VERSION.APP_ID
  • APP_VERSION (Field) — VARCHAR2(100)
  • APP_OS (Field2) — VARCHAR2(100)
  • UDATE (Field3) — DATE
  • Field4

APP_VERSION (Untitled)

  • APP_V_ID (Key) — NUMBER — Primary key — NOT NULL
  • APP_ID (Field) — NUMBER — Primary key
  • PACKAGE_NAME (Field3) — VARCHAR2(1000)
  • APP_NAME (Field4) — VARCHAR2(1000)
  • APP_NAME2 (Field5) — VARCHAR2(1000)
  • APP_OS (Field6) — VARCHAR2(100)
  • APP_VERSION (Field7) — VARCHAR2(100)
  • UDATE (Field8) — DATE
  • APP_TYPE (Field9) — VARCHAR2(100)
  • INSTALL_PATH (Field10) — VARCHAR2(300)
  • ANALYSIS_STATUS (Field12) — VARCHAR2(10)

CALL_MESSAGE_TEST (Untitled14)

  • APP_D_ID (Key) — NUMBER — Foreign key → APP_VERSION.APP_V_ID — NOT NULL
  • APP_ID (Field14) — NUMBER — Foreign key → APP_VERSION.APP_ID
  • PACKAGE_NAME (Field) — VARCHAR2(1000)
  • APP_NAME (Field2) — VARCHAR2(1000)
  • APP_OS (Field3) — VARCHAR2(100)
  • MODEL (Field4) — VARCHAR2(100)
  • MODEL_NAME (Field5) — VARCHAR2(100)
  • OS_VERSION (Field6) — VARCHAR2(100)
  • EACH (Field7) — VARCHAR2(10)
  • ALL_DEL (Field8) — VARCHAR2(10)
  • CHAT (Field9) — VARCHAR2(10)
  • M_RI_EACH (Field10) — VARCHAR2(10)
  • M_RI_ALL (Field11) — VARCHAR2(10)
  • M_RI_CHAT (Field12) — VARCHAR2(10)
  • Field13

KDF_UPDATE (Untitled8)

  • KDF_NO (Field) — NUMBER — Primary key
  • KDF_VERSION (Field2) — VARCHAR2(50)
  • UDATE (Field3) — DATE
  • INFO (Field4) — VARCHAR2(1000)
  • INFO2 (Field5) — VARCHAR2(1000)
  • Field6

KDF_UPDATE_APP (Untitled11)

  • KDF_NO (Field10) — NUMBER — Primary key
  • APP_D_ID (Key) — NUMBER — Foreign key → APP_VERSION.APP_V_ID — NOT NULL
  • APP_ID (Field11) — NUMBER — Foreign key → APP_VERSION.APP_ID
  • NO (Field) — NUMBER
  • APP_OS (Field2) — VARCHAR2(100)
  • APP_NAME (Field3) — VARCHAR2(1000)
  • APP_NAME (Field4) — VARCHAR2(1000)
  • PACKAGE_NAME (Field5) — VARCHAR2(1000)
  • APP_VERSION (Field6) — VARCHAR2(100)
  • INFO (Field7) — VARCHAR2(1000)
  • INFO2 (Field8) — VARCHAR2(1000)
  • Field9

KDF_UPDATE_MODEL (Untitled10)

  • KDF_NO (Field5) — NUMBER — Foreign key → KDF_UPDATE.KDF_NO
  • MOBILE_ID (Field) — NUMBER — Foreign key → MOBILE.MOBILE_ID
  • COMPANY (Field2) — VARCHAR2(100)
  • MODEL (Field3) — VARCHAR2(100)
  • Field4

MOBILE (Untitled15)

  • MOBILE_ID (Field) — NUMBER — Primary key
  • COMPANY (Field2) — VARCHAR2(100)
  • MODEL (Field3) — VARCHAR2(100)
  • MODEL_NAME (Field4) — VARCHAR2(1000)
  • MODEL_OS (Field5) — VARCHAR2(100)
  • INFO (Field6) — VARCHAR2(3000)
  • RDATE (Field7) — DATE
  • TYPE (Field8) — VARCHAR2(100)
  • ANALYSIS_COMPLETE (Field9) — VARCHAR2(100)
  • Field10

PROBLEM_REPORT (Untitled16)

  • KDF_NO (Field) — NUMBER — Foreign key → KDF_UPDATE.KDF_NO
  • NO (Field2) — NUMBER
  • WDATE (Field3) — DATE
  • REGIONAL (Field4) — VARCHAR2(100)
  • ANALYZER (Field5) — VARCHAR2(100)
  • QUESTION (Field6) — VARCHAR2(3000)
  • CAUSE (Field7) — VARCHAR2(3000)
  • SOLUTION (Field8) — VARCHAR2(3000)
  • COMPLETED (Field9) — VARCHAR2(10)
  • Field10

SCRIPT_INFO (Untitled5)

  • APP_V_ID (Key) — NUMBER — Foreign key → APP_VERSION.APP_V_ID — NOT NULL
  • APP_ID (Field13) — NUMBER — Foreign key → APP_VERSION.APP_ID
  • NO (Field) — NUMBER
  • OS_TYPE (Field2) — VARCHAR2(100)
  • NAME (Field3) — VARCHAR2(1000)
  • CATEGORY (Field4) — VARCHAR2(1000)
  • LIVECATEGORY (Field5) — VARCHAR2(1000)
  • RESULTTYPE (Field6) — VARCHAR2(3000)
  • PATH (Field7) — VARCHAR2(1000)
  • PACKAGE_NAME (Field8) — VARCHAR2(1000)
  • LOGICALPATHS (Field9) — VARCHAR2(1000)
  • VERSION (Field10) — VARCHAR2(100)
  • CRYPTO (Field11) — CARCHAR2(100)
  • Field12