GravityMES_2021.08.27

Tables (17)

COMPANY_INFO_TB

  • CODE — BIGINT — Primary key — NOT NULL
  • TIME_STAMP — DATETIME — NOT NULL
  • COMPANY_CODE — VARCHAR(50) — NOT NULL
  • KPI_INFO — JSON — NOT NULL

CONSUMER_TB

  • CODE — BIGINT — Primary key — NOT NULL
  • TIME_STAMP — DATETIME — NOT NULL
  • CONSUMER_NAME — VARCHAR(50)
  • CONSUMER_NUM — VARCHAR(50)
  • CONSUMER_MAIL — VARCHAR(50)
  • MANAGER_NAME — VARCHAR(50)
  • MANAGER_NUM — VARCHAR(50)
  • MANAGER_MAIL — VARCHAR(50)
  • ADDRESS — VARCHAR(100)
  • DIVISION — VARCHAR(50)

COUNTRY_TB

  • CODE — BIGINT — Primary key — NOT NULL
  • TIME_STAMP — DATETIME — NOT NULL
  • NAME — VARCHAR(50)

FACILITIES_DATA_TB

  • CODE — BIGINT — Primary key — NOT NULL
  • FACILITIES_ID — BIGINT — Foreign key → FACILITIES_TB.FACILITIES_ID — NOT NULL
  • TIME_STAMP — DATETIME — NOT NULL
  • DATA — VARCHAR(500)

FACILITIES_TB

  • FACILITIES_ID — BIGINT — Primary key — NOT NULL
  • TIME_STAMP — DATETIME — NOT NULL
  • NAME — VARCHAR(50)
  • SERIAL_NUM — VARCHAR(50)
  • DATA_DEVISION — VARCHAR(50)
  • DIVISION — VARCHAR(50)
  • LOCATION — VARCHAR(50)

ITEM_EXTRA_ELEMENT_TB

  • CODE — BIGINT — Primary key — NOT NULL
  • TIME_STAMP — DATETIME — NOT NULL
  • NAME — VARCHAR(50)

ITEM_MFR_METHOD_TB

  • CODE — BIGINT — Primary key — NOT NULL
  • TIME_STAMP — DATETIME — NOT NULL
  • NAME — VARCHAR(50)

ITEM_PLANNING_TB

  • CODE — BIGINT — Primary key — NOT NULL
  • ITEM_ID — BIGINT — Foreign key → ITEM_TB.ITEM_ID — NOT NULL
  • TIME_STAMP — DATETIME — NOT NULL
  • NAME — VARCHAR(50)
  • CONSUMER_NAME — VARCHAR(50)
  • WORKER_NAME — VARCHAR(50)
  • TYPE — VARCHAR(20)
  • COUNTRY — VARCHAR(50)
  • CATEGORY — VARCHAR(20)
  • DEAD_LINE — VARCHAR(50)
  • DUE_DATE — VARCHAR(50)
  • QTY — VARCHAR(500)
  • BOM — JSON
  • MFR_METHOD — JSON
  • EXTRA_ELEMENT — JSON
  • UNIT — VARCHAR(20)
  • UNIT_PRICE — VARCHAR(50)
  • DESCRIPTION — VARCHAR(500)

ITEM_STOCK_HISTORY_TB

  • CODE — BIGINT — Primary key — NOT NULL
  • ITEM_ID — BIGINT — NOT NULL
  • TIME_STAMP — DATETIME — NOT NULL
  • NAME — VARCHAR(50)
  • CONSUMER_NAME — VARCHAR(50)
  • WORKER_NAME — VARCHAR(50)
  • TYPE — VARCHAR(20)
  • COUNTRY — VARCHAR(50)
  • CATEGORY — VARCHAR(20)
  • DEAD_LINE — VARCHAR(50)
  • DUE_DATE — VARCHAR(50)
  • COMPLETE_DATE — VARCHAR(50)
  • QTY — DECIMAL(50,3)
  • PLANNED_QTY — DECIMAL(50,3)
  • STOCK — VARCHAR(500)
  • ADJUSTMENT_STOCK — VARCHAR(500)
  • STATE — VARCHAR(50)
  • CONFIRM_HISTORY — VARCHAR(500)
  • BOM — JSON
  • MFR_METHOD — JSON
  • EXTRA_ELEMENT — JSON
  • UNIT — VARCHAR(20)
  • UNIT_PRICE — VARCHAR(50)
  • MAN_HOURS — DECIMAL(50,3)
  • FOREIGN_SUBSTANCE — DECIMAL(50,3)
  • MANUFACTURING_TIME — VARCHAR(50)
  • LEAD_TIME — DECIMAL(50,3)
  • DESCRIPTION — VARCHAR(500)

ITEM_STOCK_TB

  • CODE — BIGINT — Primary key — NOT NULL
  • ITEM_ID — BIGINT — NOT NULL
  • TIME_STAMP — DATETIME — NOT NULL
  • NAME — VARCHAR(50)
  • TYPE — VARCHAR(20)
  • COUNTRY — VARCHAR(50)
  • STOCK — DECIMAL(50,3)
  • EXPECTED_QTY — DECIMAL(50,3)
  • COMMITED_QTY — DECIMAL(50,3)
  • UNIT — VARCHAR(20)
  • DESCRIPTION — VARCHAR(500)

ITEM_TB

  • ITEM_ID — BIGINT — Primary key — NOT NULL
  • TIME_STAMP — DATETIME — NOT NULL
  • TYPE — VARCHAR(20)
  • NAME — VARCHAR(50)
  • COUNTRY — VARCHAR(50)
  • UNIT — VARCHAR(20)
  • UNIT_PRICE — VARCHAR(50)
  • BOM — JSON
  • MFR_METHOD — JSON
  • DESCRIPTION — VARCHAR(500)
  • EXTRA_ELEMENT — JSON

ITEM_TYPE_TB

  • CODE — BIGINT — Primary key — NOT NULL
  • TIME_STAMP — DATETIME — NOT NULL
  • NAME — VARCHAR(50)

ITEM_UNIT_TB

  • CODE — BIGINT — Primary key — NOT NULL
  • TIME_STAMP — DATETIME — NOT NULL
  • NAME — VARCHAR(50)

MANUFACTURING_COUNT_TB

  • CODE — BIGINT — Primary key — NOT NULL
  • TIME_STAMP — DATETIME — NOT NULL
  • START_COUNT — VARCHAR(50)
  • STATE — VARCHAR(50)
  • COUNT — VARCHAR(50)

QUERY_INFO_TB

  • CODE — BIGINT — Primary key — NOT NULL
  • TIME_STAMP — DATETIME — NOT NULL
  • TOTAL_QUERIES — VARCHAR(50) — NOT NULL
  • UPTIME — DATETIME — NOT NULL

TEMPERATURE_INFO_TB

  • CODE — BIGINT — Primary key — NOT NULL
  • TIME_STAMP — DATETIME — NOT NULL
  • TEMPERATURE — VARCHAR(50)
  • HUMIDITY — VARCHAR(50)

WORKER_TB

  • CODE — BIGINT — Primary key — NOT NULL
  • TIME_STAMP — DATETIME — NOT NULL
  • NAME — VARCHAR(50)
  • POSITION — VARCHAR(50)
  • TEAM — VARCHAR(50)