iStock

Tables (9)

BOM

  • location_num (로케이션 번호) — Primary key — NOT NULL
  • itemID (item ID2) — AUTO_INCREMENT — Foreign key → item_detail.itemID — NOT NULL
  • sID (규격 ID) — Foreign key → standard.sID — NOT NULL
  • part_name (구분) — Foreign key → standard.part_name — NOT NULL
  • number
  • memo (비고)
  • code_num (코드번호)

company (거래처 정보-삭제)

  • com_id (company id) — AUTO_INCREMENT — Primary key — NOT NULL
  • com_name (company name) — Primary key — NOT NULL

in_out (구입, 생산-파악필요)

  • com_name (company name) — Primary key — NOT NULL
  • itemID (item ID) — AUTO_INCREMENT — Foreign key → item_detail.itemID — NOT NULL
  • in_num (구매 수량)
  • out_num (생산 수량)

item

  • itemName (item 이름) — Primary key — NOT NULL
  • item_num (item 재고수량)

item_detail (item 세부정보)

  • itemID (item ID) — AUTO_INCREMENT — Primary key — NOT NULL
  • pro_num (Field)
  • pro_name (자재 제조회사)
  • code_num (코드번호)
  • item_stock (item 재고수량)
  • itemName (item 이름) — Foreign key → item.itemName — NOT NULL

log (로그)

  • date_time (시간) — Primary key — NOT NULL
  • sID (규격 ID) — Foreign key → standard.sID — NOT NULL
  • part_name (구분) — Foreign key → standard.part_name — NOT NULL
  • pro_num (Field)
  • buy_num
  • in_num (구매수량)
  • out_num (생산수량)
  • itemID (item ID)
  • memo

parts (구분)

  • part_name (구분) — Primary key — NOT NULL

product

  • pro_num (product number) — Primary key — NOT NULL
  • pro_name (product name) — Primary key — NOT NULL

standard (규격)

  • sID (규격 ID) — Primary key — NOT NULL
  • part_name (구분) — Foreign key → parts.part_name — NOT NULL
  • s_price (가격)
  • stock_number (재고 수량)