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 (재고 수량)