HACCP MESSI
테이블 (9)
INFO_BOM(BOM정보) (Untitled2)
- BOM_PARENT_NO (Key) — INT — 기본 키 — NOT NULL
- BOM_CODE (Key2) — INT — 기본 키 — NOT NULL
- BOM_COUNT (Field) — INT — NOT NULL
INFO_COMPANY (거래처정보) (Untitled5)
- COM_NO (Key) — INT — 기본 키 — NOT NULL
- COM_TYPE (Field) — VARCHAR(10) — NOT NULL
- COM_NAME (Field2) — VARCHAR(20) — NOT NULL
- COM_LICENSENO (Field3) — VARCHAR(15)
- COM_PHONENO (Field4) — VARCHAR(15)
- COM_REP_NAME (Field5) — VARCHAR(20)
INFO_MATERIAL(품목정보) (Untitled3)
- MAT_NO (Key) — INT — 기본 키 — NOT NULL
- MAT_NAME (Field) — VARCHAR(30) — NOT NULL
- MAT_TYPE (Field2) — VARCHAR(20) — NOT NULL
- MAT_SPEC (Field3) — VARCHAR(20)
INFO_USER(회원정보) (Untitled)
- USER_ID (Key) — VARCHAR(20) — 기본 키 — NOT NULL
- USER_PW (Field) — VARCHAR(20) — NOT NULL
- USER_NAME (Field2) — VARCHAR(10) — NOT NULL
- USER_GRADE (Field3) — VARCHAR(10) — NOT NULL
INFO_WAREHOUSE (창고정보) (Untitled4)
- WARE_NO (Key) — INT — 기본 키 — NOT NULL
- WARE_NAME (Field) — VARCHAR(20) — NOT NULL
- WARE_TYPE (Field2) — VARCHAR(20) — NOT NULL
- WARE_USE (Field3) — VARCHAR(10)
- WARE_ETC (Field4) — VARCHAR(30)
MANAGE_CURMAT (재고현황) (Untitled9)
- WARE_NO (Key) — INT — 기본 키 — NOT NULL
- MAT_NO (Field) — INT
- CURMAT_COUNT (Field2) — INT
MANAGE_INPUT (제품입고관리) (Untitled8)
- INPUT_IDX (Key) — INT — 기본 키 — NOT NULL
- WARE_NO (Field) — INT — NOT NULL
- MAT_NO (Field2) — INT — NOT NULL
- INPUT_COUNT (Field3) — INT — NOT NULL
- COM_NO (Field4) — INT — NOT NULL
- INPUT_INSPEC (Field5) — VARCHAR(20)
- USER_ID (Field6) — VARCHAR(20) — NOT NULL
- INPUT_DATE (Field7) — DATETIME — NOT NULL
MANAGE_OUT (제품출고관리) (Untitled7)
- OUTPUT_INDEX (Key) — INT — 기본 키 — NOT NULL
- WARE_NO (Field) — INT — NOT NULL
- MAT_NO (Field2) — INT — NOT NULL
- OUTPUT_COUNT (Field3) — INT
- COM_NO (Field4) — INT — NOT NULL
- USER_ID (Field5) — VARCHAR(20) — NOT NULL
- OUTPUT_DATE (Field6) — DATETIME — NOT NULL
PRODUCTION_MNGODR (작업지시관리) (Untitled6)
- MNGODR_NO (Key) — INT — 기본 키 — NOT NULL
- MNGODR_DATE (Field) — DATETIME — NOT NULL
- MAT_NO (Field2) — INT — NOT NULL
- MNGODR_COUNT (Field3) — INT — NOT NULL
- USER_ID (Field4) — VARCHAR(20) — NOT NULL
- MNGODR_GOOD (Field5) — INT
- MNGODR_ERR (Field6) — INT