SQL: Create 'tab_outbound' Table with Outbound Goods Information
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.
原文地址: https://www.cveoy.top/t/topic/qqnf 著作权归作者所有。请勿转载和采集!