Something went wrong. Try again.
AECC database project.
Something went wrong. Try again.
1234567891011CREATE TABLE IF NOT EXISTS transaction ( t_id INT NOT NULL AUTO_INCREMENT, type ENUM("Expense", "Income") NOT NULL, date DATETIME DEFAULT CURRENT_TIMESTAMP, quantity NUMERIC(5,0) NOT NULL, p_id INT,
PRIMARY KEY (t_id), FOREIGN KEY (p_id) REFERENCES product(p_id) ON DELETE SET NULL);