CREATE TABLE tab_outbound o_gid int11 NOT NULL o_wid int11 NOT NULL odate date DEFAULT NULL outbound int11 DEFAULT NULL outmoney double DEFAULT NULL PRIMARY KEY o_gido_wid KEY o_wid o_wid CON

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