-- ecommerce_3tables / seed=20261122 generated by supubao deliver.py CREATE TABLE users ( user_id INTEGER PRIMARY KEY, name VARCHAR(30), city VARCHAR(20), phone VARCHAR(20), email VARCHAR(60), created_at DATETIME ); CREATE TABLE orders ( order_id INTEGER PRIMARY KEY, user_id INTEGER, goods_code VARCHAR(30), amount DECIMAL(10,2), channel VARCHAR(30), status VARCHAR(30), created_at DATETIME , FOREIGN KEY (user_id) REFERENCES users(user_id) ); CREATE TABLE payments ( payment_id INTEGER PRIMARY KEY, order_id INTEGER, pay_status VARCHAR(30), paid_amount DECIMAL(10,2), paid_at DATETIME , FOREIGN KEY (order_id) REFERENCES orders(order_id) );