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