• 홈페이지 코드

CREATE TABLE IF NOT EXISTS history (
  id INT PRIMARY KEY AUTO_INCREMENT,
  date DATE,
  is_income BOOLEAN,
	category INT,
  content VARCHAR(150),
	payment_method INT,  
  amount INT,
	FOREIGN KEY (category) REFERENCES category(id) ON UPDATE CASCADE,
	FOREIGN KEY (payment_method) REFERENCES payment_method(id) ON UPDATE CASCADE
);

CREATE TABLE IF NOT EXISTS payment_method (
  id int PRIMARY KEY AUTO_INCREMENT,
  name VARCHAR(30)
);

CREATE TABLE IF NOT EXISTS category (
  id int PRIMARY KEY AUTO_INCREMENT,
  name VARCHAR(30),
  color VARCHAR(9),
  is_income BOOLEAN
);