You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
CREATE TABLE suppliers_list(SupplierID INT NOT NULL, SupplierName VARCHAR(50) NOT NULL, PRIMARY KEY(SupplierID));
CREATE TABLE expenses_list(ExpenseID INT NOT NULL, SupplierID INT NOT NULL, ExpensesDate DATE NOT NULL, Expenses FLOAT(8,2) NOT NULL,Description VARCHAR(30),PRIMARY KEY(ExpenseID), FOREIGN KEY(SupplierID) REFERENCES suppliers_list(SupplierID));
CREATE TABLE income_list(IncomeID INT NOT NULL, IncomeDate DATE NOT NULL, Income FLOAT(8,2) NOT NULL, PRIMARY KEY(IncomeID));