SPIID
Tables (15)
wms_access_record
- RECORD_ID — int
- USER_ID — int — NOT NULL
- USER_NAME — varchar(50) — NOT NULL
- ACCESS_TYPE — varchar(30) — NOT NULL
- ACCESS_TIME — datetime — NOT NULL
- ACCESS_IP — varchar(45) — NOT NULL
wms_action
- ACTION_ID — int — Primary key — NOT NULL
- ACTION_NAME — varchar(30) — NOT NULL
- ACTION_DESC — varchar(30)
- ACTION_PARAM — varchar(50) — NOT NULL
wms_customer
- CUSTOMER_ID — int — Primary key — NOT NULL
- CUSTOMER_NAME — varchar(30) — NOT NULL
- CUSTOMER_PERSON — varchar(10) — NOT NULL
- CUSTOMER_TEL — varchar(20) — NOT NULL
- CUSTOMER_EMAIL — varchar(20) — NOT NULL
- CUSTOMER_ADDRESS — varchar(100) — NOT NULL
wms_goods
- GOOD_ID — int — Primary key — NOT NULL
- GOOD_NAME — varChar(30) — NOT NULL
- GOOD_RYPE — varchar(20)
- GOOD_SIZE — varchar(40)
- GOOD_VALUE — double — NOT NULL
wms_operation_record
- RECORD_ID — int
- USER_ID — int — NOT NULL
- USER_NAME — varchar(50) — NOT NULL
- OPERATION_NAME — varchar(30) — NOT NULL
- OPERATION_TIME — datetime — NOT NULL
- OPERATION_RESULT — varchar(15) — NOT NULL
wms_record_in
- RECORD_ID — int — Primary key — NOT NULL
- RECORD_SUPPLIERID — int — NOT NULL
- RECORD_GOODID — int — NOT NULL
- RECORD_NUMBER — int — NOT NULL
- RECORD_TIME — datetime — NOT NULL
- RECORD_PERSON — varchar(10) — NOT NULL
- RECORD_REPOSITORYID — int — NOT NULL
wms_record_out
- RECORD_ID — int — Primary key — NOT NULL
- RECORD_CUSTOMERID — int — NOT NULL
- RECORD_GOODID — int — NOT NULL
- RECORD_NUMBER — int — NOT NULL
- RECORD_TIME — datetime — NOT NULL
- RECORD_PERSON — varchar(10) — NOT NULL
- RECORD_REPOSITORYID — int — NOT NULL
wms_record_storage
- RECORD_GOODID — int — Primary key — NOT NULL
- RECORD_REPOSITORY — int — NOT NULL
- RECORD_NUMBER — int — NOT NULL
wms_repo_admin
- REPO_ADMIN_ID — int — Primary key — NOT NULL
- REPO_ADMIN_NAME — varchar(10) — NOT NULL
- REPO_ADMIN_SEX — varchar(10) — NOT NULL
- REPO_ADMIN_TEL — varchar(20) — NOT NULL
- REPO_ADMIN_ADDRESS — varchar(100) — NOT NULL
- REPO_ADMIN_BIRTH — datetime — NOT NULL
- REPO_ADMIN_REPOID — int
wms_respository
- REPO_ID — int — Primary key — NOT NULL
- REPO_ADDRESS — varchar(100) — NOT NULL
- REPO_STATUS — varchar(20) — NOT NULL
- REPO_AREA — varchar(20) — NOT NULL
- REPO_DESC — varchar(50)
wms_role_action
- ACTION_ID — int — Primary key — NOT NULL
- ROLE_ID — int — Primary key — NOT NULL
wms_roles
- ROLE_ID — int — Primary key — NOT NULL
- ROLE_NAME — varchar(20) — NOT NULL
- ROLE_DESC — varchar(30)
- ROLE_URL_PREFIX — varchar(20) — NOT NULL
wms_supplier
- SUPPLIER_ID — int — Primary key — NOT NULL
- SUPPLIER_NAME — varchar(30) — NOT NULL
- SUPPLIER_PERSON — varchar(10) — NOT NULL
- SUPPLIER_TEL — varchar(20) — NOT NULL
- SUPPLIER_EMAIL — varchar(20) — NOT NULL
- SUPPLIER_ADDRESS — varchar(100) — NOT NULL
wms_user
- USER_ID — int — Primary key — NOT NULL
- USER_USERNAME — varchar(30) — NOT NULL
- USER_PASSWORD — varchar(40) — NOT NULL
wms_user_role
- ROLE_ID — int — Primary key — NOT NULL
- USER_ID — int — Primary key — NOT NULL