Inbound
테이블 (8)
Approval(입고승인) (Untitled4)
- approval_id — int — 기본 키 — NOT NULL
- approval_date — date
- approver — varchar(20)
- approval_status — varchar(10)
- request_id (request_id2) — int — 외래 키 → InboundRequest(입고요청).request_id — NOT NULL — Auto_increment
InboundRequest(입고요청) (Untitled)
- request_id — int — 기본 키 — NOT NULL — Auto_increment
- request_date — Date
- status — varchar(50)
- member_id — varchar(15) — 외래 키 → Member.member_id — NOT NULL
InboundRequestItem(입고요청품목) (Untitled2)
- item_id — int — 기본 키 — NOT NULL — Auto_increment
- quantity — int
- received_quantity — int
- instpection_status — varchar(50)
- request_id — int — 외래 키 → InboundRequest(입고요청).request_id — NOT NULL — Auto_increment
- product_id (product_id2) — int — 외래 키 → Product(제품/품목).product_id — NOT NULL
Inspection( 검수) (Untitled3)
- inspection_id — int — 기본 키 — NOT NULL
- inspection_date — Date
- inspector — varchar(20)
- inspection_result — varchar(50)
- request_id (request_id2) — int — 외래 키 → InboundRequest(입고요청).request_id — NOT NULL — Auto_increment
Inventory(재고) (Untitled5)
- inventory_id — int — 기본 키 — NOT NULL
- quantity — int
- location — varchar(50)
- product_id (product_id2) — varchar(10) — 외래 키 → Product(제품/품목).product_id — NOT NULL
- warehouse_id (warehouse_id2) — int — 외래 키 → Warehous(창고).warehouse_id — NOT NULL
Member (Untitled6)
- member_id — varchar(15) — 기본 키 — NOT NULL
- Field
- Field2
Product(제품/품목) (Untitled8)
- product_id — varchar(10) — 기본 키 — NOT NULL
- product_name — varchar(30)
- price — int
- brand — varchar(30)
- Field
- Field2
- Field3
- Field4
- Field5
Warehous(창고) (Untitled7)
- warehouse_id — int — 기본 키 — NOT NULL
- location — varhcar(20)