test
Tables (4)
employee (직원)
- user_idx — int — Primary key — NOT NULL
- user_id — varchar(45) — NOT NULL — 아이디
- pass — varchar(45) — NOT NULL — 비밀번호
- user_name — varchar(45) — NOT NULL — 이름
- addr — varchar(200)
- email — varchar(45)
- phone — varchar(11)
- birth_date — varchar(6) — 생년월일
- create_date — datetime — NOT NULL — 생성일
- department — varchar(45) — NOT NULL
- position — int — NOT NULL
item (비품)
- item_idx — int — Primary key — NOT NULL
- warehouse_name — int — Foreign key → warehouse.warehouse_idx
- item_code — varchar(45) — NOT NULL — 매입회사 + 카테고리 기반
- item_name — varchar(45) — NOT NULL
- category_name — varchar(45) — NOT NULL
- vendor_name — varchar(45)
- quantity — int
- standard_stock — int
- item_qr — varchar(200) — NOT NULL
- approve — varchar(1) — NOT NULL — 승인여부
stock_transaction (입출고 이력)
- transaction_idx — int — Primary key — NOT NULL
- item_code — varchar(45) — Foreign key → item.item_code — NOT NULL
- user_id — varchar(45) — Foreign key → employee.user_id — NOT NULL
- incoming — int
- outgoing — int
- quantity — int — NOT NULL
- timestamp — datetime — NOT NULL
warehouse (창고)
- warehouse_idx — int — Primary key — NOT NULL
- name — varchar(45) — NOT NULL
- location — varchar(200) — NOT NULL
- warehouse_qr — varchar(45) — NOT NULL — 창고 QR 관리용