istock

Tables (8)

BOM (자재 리스트)

  • id (Key) — UNSIGNED INT — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • memo (비고) — VARCHAR(50)
  • created_at (생성일) — TIMESTAMP — NOT NULL
  • updated_at (갱신일) — TIMESTAMP — NOT NULL
  • product_id (제품아이디) — UNSIGNED INT — Foreign key → Product.id — NOT NULL
  • part_id (파트 아이디) — UNSIGNED INT — Foreign key → Part.id — NOT NULL

Category (카테고리)

  • id (카테고리아이디) — UNSIGNED INT — Primary key — NOT NULL — AUTO_INCREMENT
  • name (이름) — VARCHAR(15) — NOT NULL
  • created_at (생성일) — TIMESTAMP — NOT NULL
  • updated_at (갱신일) — TIMESTAMP — NOT NULL

Log (전체 작업 기록)

  • Key — Primary key — NOT NULL
  • Field
  • page_name (페이지 이름) — VARCHAR(50) — NOT NULL
  • user_id (유저 아이디) — VARCHAR(50) — NOT NULL
  • created_at (생성일) — TIMESTAMP — NOT NULL

Manager (관리자)

  • id (Key) — UNSIGNED INT — Primary key — NOT NULL
  • username (유저 아이디) — NOT NULL
  • password (패스워드) — NOT NULL
  • role (역할) — NOT NULL
  • created_at (생성일) — TIMESTAMP — NOT NULL
  • updated_at (갱신일) — TIMESTAMP — NOT NULL

Part (부품)

  • id (부품아이디) — UNSIGNED INT — Primary key — NOT NULL
  • name (품명) — VATCHAR(100) — NOT NULL
  • spec (규격) — VARCHAR(255) — NOT NULL
  • created_at (생성일) — TIMESTAMP — NOT NULL
  • updated_at (갱신일) — TIMESTAMP — NOT NULL

Part IO (부품 주문 기록)

  • id (Key) — UNSIGNED INT — Primary key — NOT NULL
  • number (수량) — INTEGER — NOT NULL
  • status (주문상태) — VARCHAR(100) — NOT NULL — 입고대기, 입고완료, 생산대기, 생산완료
  • created_at (생성일) — TIMESTAMP — NOT NULL
  • updated_at (갱신일) — TIMESTAMP — NOT NULL
  • part_id (파트 아이디) — UNSIGNED INT — Foreign key → Part.id — NOT NULL

Product (제품)

  • id (제품아이디) — UNSIGNED INT — Primary key — NOT NULL
  • product_number (프로덕트 번호)
  • name (이름)
  • code_number (코드 번호) — 11, 2
  • stock (재고 수량)
  • created_at (생성일) — TIMESTAMP — NOT NULL
  • updated_at (갱신일) — TIMESTAMP — NOT NULL
  • category_id (아이디) — UNSIGNED INT — Foreign key → Category.id — NOT NULL

Product IO (제품 주문 기록)

  • id (Key) — UNSIGNED INT — Primary key — NOT NULL
  • number (수량) — INTEGER — NOT NULL
  • status (주문상태) — VARCHAR(100) — NOT NULL — 생산대기, 생산완료, 출고대기, 출고완료
  • created_at (생성일) — TIMESTAMP — NOT NULL
  • updated_at (갱신일) — TIMESTAMP — NOT NULL
  • product_id (제품아이디) — UNSIGNED INT — Foreign key → Product.id — NOT NULL