AECC database project.
stau.space
1CREATE TABLE IF NOT EXISTS transaction (
2 t_id INT NOT NULL AUTO_INCREMENT,
3 type ENUM("Expense", "Income") NOT NULL,
4 date DATETIME DEFAULT CURRENT_TIMESTAMP,
5 quantity NUMERIC(5,0) NOT NULL,
6 p_id INT,
7
8 PRIMARY KEY (t_id),
9 FOREIGN KEY (p_id) REFERENCES product(p_id) ON DELETE SET NULL
10);