创建订单表,地址表,订单项目表的sql语句如下:
CREATE TABLE `project_crowd`.`t_order` (
`id` INT NOT NULL AUTO_INCREMENT COMMENT '主键',
`order_num` CHAR(100) COMMENT '订单号',
`pay_order_num` CHAR(100) COMMENT '支付宝流水号',
`order_amount` DOUBLE
创建订单表,地址表,订单项目表的sql语句如下:
CREATE TABLE `project_crowd`.`t_order` (
`id` INT NOT NULL AUTO_INCREMENT COMMENT '主键',
`order_num` CHAR(100) COMMENT '订单号',
`pay_order_num` CHAR(100) COMMENT '支付宝流水号',
`order_amount` DOUBLE