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)