Ricardo J Vargas

Generate statements (ddl) to create all objects

The three tables with statments.

October 10, 2017 at 8:21 PM
Visible to public

CREATE TABLE students
(
  PRIMARY KEY(names),
  Jimbo CHAR(30) NOT NULL,
  Bobby CHAR(30) NOT NULL,
  Claire CHAR(30) NOT NULL,
  FOREIGN KEY (ID) REFERENCES Finishes(ID),
  FOREIGN KEY (Age) REFERENCES Finishes(Age),
  );

CREATE TABLE Age
(
    PRIMARY KEY (Age)
  16 INT NOT NULL,
  17 INT NOT NULL,
  18 INT NOT NULL,
  PRIMARY KEY (age)
);

CREATE TABLE ids
(
 PRIMARY KEY (ID)
 123 INT NOT NULL,
 321 INT NOT NULL,
 987 INT NOT NULL,
  
  
  
);