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)