it융합
테이블 (6)
Admin
- admin_id — INT
- name — VARCHAR(100) — NOT NULL
- role — ENUM('inbound','outbound','super')
- password — VARCHAR(100) — NOT NULL
Customer
- customer_id — INT
- name — VARCHAR(100) — NOT NULL
- phone — VARCHAR(50)
- email — VARCHAR(100)
- address — VARCHAR(200)
Inbound
- inbound_id — INT
- supplier_id — INT — NOT NULL
- product_id — INT — NOT NULL
- quantity — INT — NOT NULL
- inbound_date — DATE — NOT NULL
- approved_by — INT
Outbound
- outbound_id — INT
- product_id — INT — NOT NULL
- customer_id — INT — NOT NULL
- quantity — INT — NOT NULL
- destination — VARCHAR(200)
- outbound_date — DATE — NOT NULL
- approved_by — INT
Product
- product_id — INT
- name — VARCHAR(100) — NOT NULL
- price — DECIMAL(10,2)
- stock_qty — INT
- storage_loc — VARCHAR(100)
Supplier
- supplier_id — INT
- name — VARCHAR(100) — NOT NULL
- contact — VARCHAR(50)
- address — VARCHAR(200)