This SQL statement creates a table named 'tab_outbound' with the following columns:

  • o_gid: an integer that represents the outbound goods ID
  • o_wid: an integer that represents the outbound warehouse ID
  • odate: a date field that stores the date of the outbound
  • outbound: an integer that represents the quantity of goods outbound
  • outmoney: a double that represents the amount of money for the outbound

The primary key of the table is a combination of o_gid and o_wid, and there is an index on o_wid. The table also has two foreign key constraints referencing the 'tab_goods' table (using gid) and the 'tab_warehouse' table (using wid).

The table is using the InnoDB storage engine and the default character set is UTF-8.

SQL: Create 'tab_outbound' Table with Outbound Goods Information

原文地址: https://www.cveoy.top/t/topic/qqnf 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录