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