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