用sql语句创建一个物流表、包含id、订单id、物流公司、运单号、收件人姓名、收件人电话、状态、备注等字段
时间: 2023-10-05 17:07:52 浏览: 51
CREATE TABLE logistics (
id INT NOT NULL AUTO_INCREMENT,
order_id INT NOT NULL,
logistics_company VARCHAR(50) NOT NULL,
waybill_number VARCHAR(50) NOT NULL,
receiver_name VARCHAR(50) NOT NULL,
receiver_phone VARCHAR(20) NOT NULL,
status VARCHAR(20) NOT NULL,
remark TEXT,
PRIMARY KEY (id)
);