· 7 years ago · Dec 26, 2018, 10:22 PM
1CREATE TABLE IF NOT EXISTS Checks (
2id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
3seller_id INT(6) UNSIGNED NOT NULL,
4total_price INT UNSIGNED NOT NULL,
5amount_of_items TINYINT UNSIGNED NOT NULL,
6cashbox_id TINYINT UNSIGNED NOT NULL,
7checkout_date DATETIME NOT NULL,
8FOREIGN KEY(seller_id) REFERENCES Sellers(id)
9);