sql_files/schema.sql

CREATE TABLE Fruits (
  fruit_id INT PRIMARY KEY,
  name VARCHAR(255),
  type VARCHAR(100)
);

CREATE TABLE Tastes (
  taste_id INT PRIMARY KEY,
  description VARCHAR(255)
);

CREATE TABLE Fruit_Tastes (
  fruit_id INT NOT NULL,
  taste_id INT NOT NULL,
  CONSTRAINT fk_fruit FOREIGN KEY (fruit_id) REFERENCES Fruits(fruit_id),
  CONSTRAINT fk_taste FOREIGN KEY (taste_id) REFERENCES Tastes(taste_id)
);