2021.08.19 SmartFactory

Tables (13)

CONSUMER_TB

  • CONSUMER_ID — BIGINT — Primary key — NOT NULL
  • TIME_STAMP — DATETIME — NOT NULL
  • NAME — VARCHAR(50)
  • MANAGER — VARCHAR(50)
  • MANAGER_NUM — VARCHAR(50)
  • MANAGER_MAIL — VARCHAR(50)
  • CONSUMER_NUM — VARCHAR(50)
  • CONSUMER_MAIL — VARCHAR(50)
  • DIVISION — VARCHAR(50)

COUNTRY_TB

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

EXTRA_ELEMENT_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 — VARCHAR(50)
  • TIME — VARCHAR(50)
  • LOCATION — VARCHAR(50)
  • PRODUCT_NAME — VARCHAR(50)
  • SERIAL_NUM — VARCHAR(50)
  • DATA — VARCHAR(50)
  • DATA_DEVISION — VARCHAR(50)
  • DIVISION — VARCHAR(50)

ITEM_ADJUSTMENT_TB

  • ITEM_ID — BIGINT — Foreign key → ITEM_TB.ITEM_ID — NOT NULL
  • WORKER_ID — BIGINT — Foreign key → WORKER_TB.WORKER_ID
  • TIME_STAMP — DATETIME — NOT NULL
  • ADJUSTMENT_TIME — VARCHAR(50)
  • STOCK — VARCHAR(500)
  • ADJUSTMENT_STOCK — VARCHAR(500)
  • RESULT_STOCK — VARCHAR(500)
  • DESCRIPTION — VARCHAR(500)

ITEM_PLANNING_TB

  • ITEM_ID — BIGINT — Foreign key → ITEM_TB.ITEM_ID — NOT NULL
  • WORKER_ID — BIGINT — Foreign key → WORKER_TB.WORKER_ID
  • CONSUMER_ID — BIGINT — Foreign key → CONSUMER_TB.CONSUMER_ID
  • TIME_STAMP — DATETIME — NOT NULL
  • STATE — VARCHAR(20)
  • DEAD_LINE — VARCHAR(50)
  • BOM — JSON
  • MFR_METHOD — JSON
  • EXTRA_ELEMENT — JSON
  • UNIT_PRICE — VARCHAR(50)
  • DESCRIPTION — VARCHAR(500)

ITEM_STOCK_HISTORY_TB

  • ITEM_ID — BIGINT — Foreign key → ITEM_TB.ITEM_ID — NOT NULL
  • WORKER_ID — BIGINT — Foreign key → WORKER_TB.WORKER_ID
  • CONSUMER_ID — BIGINT — Foreign key → CONSUMER_TB.CONSUMER_ID
  • TIME_STAMP — DATETIME — NOT NULL
  • STATE — VARCHAR(20)
  • INCOMMING_WEIGHT — VARCHAR(50)
  • INCOMMING_TIME — VARCHAR(50)
  • INCOMMING_QTY — VARCHAR(50)
  • OUTGOING_WEIGHT — VARCHAR(50)
  • OUTGOING_TIME — VARCHAR(50)
  • OUTGOING_QTY — VARCHAR(50)
  • BOM — JSON
  • MFR_METHOD — JSON
  • EXTRA_ELEMENT — JSON
  • UNIT_PRICE — VARCHAR(50)
  • STOCK — VARCHAR(500)
  • DESCRIPTION — VARCHAR(500)

ITEM_STOCK_TB

  • ITEM_ID — BIGINT — Foreign key → ITEM_TB.ITEM_ID — NOT NULL
  • WORKER_ID — BIGINT — Foreign key → WORKER_TB.WORKER_ID
  • TIME_STAMP — DATETIME — NOT NULL
  • STOCK — VARCHAR(500)
  • EXPERTED_QTY — VARCHAR(500)
  • COMMITTED_QTY — VARCHAR(500)
  • SHORTAGE_QTY — VARCHAR(500)
  • BOM — JSON
  • MFR_METHOD — JSON
  • EXTRA_ELEMENT — JSON
  • UNIT_PRICE — VARCHAR(50)
  • 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)
  • BARCODE — VARCHAR(100)
  • UNIT — VARCHAR(20)
  • UNIT_PRICE — VARCHAR(50)
  • BOM — JSON
  • MFR_METHOD — JSON
  • EXTRA_ELEMENT — JSON
  • DESCRIPTION — VARCHAR(500)

MFR_METHOD_TB

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

TYPE_TB

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

UNIT_TB

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

WORKER_TB

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