wms_pr_personal
Tables (12)
Admins
- mID — int
- adminRole — varchar(50) — NOT NULL
- adminID — varchar(50) — NOT NULL
- adminPW — varchar(50) — NOT NULL
- adminName — varchar(50) — NOT NULL
- adminPhone — varchar(50) — NOT NULL
InvenLog
- logID — int
- eID — int — NOT NULL
- log_quantity — int — NOT NULL
- warehouseID — int — NOT NULL
- itemID — int — NOT NULL
- stockingQuantity — int — NOT NULL
- stockingDate — date
- shippingQuantity — int — NOT NULL
- shippingDate — date
- logTime — date — NOT NULL
Inventory
- eID — int
- quantity — int — NOT NULL
- warehouseID — int — NOT NULL
- sectionID — int — NOT NULL
- itemID — int — NOT NULL
- stockDate — date
- shipDate — date
Item
- itemID — int
- itemName — varchar(100) — NOT NULL
- itemPrice — int — NOT NULL
- weight — int — NOT NULL
- assemble — varchar(50) — NOT NULL
- customerName — varchar(50) — NOT NULL
- material — varchar(50) — NOT NULL
- width — decimal(10, 2) — NOT NULL
- height — decimal(10, 2) — NOT NULL
- levelHeight — decimal(10, 2) — NOT NULL
- volume — decimal(10, 3)
- spaceName — varchar(50) — NOT NULL
- category — varchar(50) — NOT NULL
Notice
- noticeID — int
- n_title — varchar(100) — NOT NULL
- n_content — varchar(255) — NOT NULL
- n_createAt — datetime — NOT NULL
- n_updateAt — datetime — NOT NULL
- n_priority — int — NOT NULL
- mid — int — NOT NULL
Request
- requestID — int
- uid — int — NOT NULL
- r_title — varchar(255) — NOT NULL
- r_content — text — NOT NULL
- r_response — text
- r_createdAt — datetime
- r_updatedAt — datetime
- r_status — varchar(50)
- r_type — enum — NOT NULL
Stock
- stockID — int
- stockingDate — date
- stockingProcess — varchar(20) — NOT NULL
- stock_p_quantity — int — NOT NULL
- itemID — int — NOT NULL
- warehouseID — int
- sectionID — int
- uID — int — NOT NULL
Users
- uID — int
- name — varchar(50) — NOT NULL
- userID — varchar(50) — NOT NULL
- userPW — varchar(50) — NOT NULL
- phone — varchar(50) — NOT NULL
- account — varchar(50) — NOT NULL
- createAt — date — NOT NULL
- adminCheck — varchar(50) — NOT NULL
Warehouse
- warehouseID — int
- warehouseName — varchar(50) — NOT NULL
- warehouseAddress — varchar(255) — NOT NULL
- warehouseStatus — varchar(20) — NOT NULL
- warehouseCityName — varchar(50) — NOT NULL
- maxCapacity — int — 창고 최대 수용량
- warehouseArea — int — NOT NULL
- regDate — date — NOT NULL
- floorHeight — int — NOT NULL
- mid — int — NOT NULL
WarehouseFee
- feeID — int
- startDate — date — NOT NULL
- endDate — date — NOT NULL
- warehouseID — int — NOT NULL
WarehouseSection
- sectionID — int
- sectionName — varchar(50) — NOT NULL
- maxVol — int — NOT NULL
- currentVol — int
- warehouseID — int — NOT NULL
shipment
- shipmentID — int
- shippingDate — date
- Shipping_p_quantity — int
- shippingProcess — varchar(20)
- waybill — varchar(50)
- uid — int
- itemID — int
- warehouseID — int