SQL Tables for LO Part 36

DROP TABLE "Project" IF EXISTS;
DROP TABLE "TeamMember" IF EXISTS;

CREATE TABLE "TeamMember" (
   "ID" INTEGER generated BY DEFAULT AS IDENTITY
      (START WITH 1) NOT NULL PRIMARY KEY,
   "FirstName" VARCHAR(25) NOT NULL,
   "LastName" VARCHAR(25) NOT NULL
);

CREATE TABLE "Project" (
   "ID" INTEGER generated BY DEFAULT AS IDENTITY
      (START WITH 1) NOT NULL PRIMARY KEY,
   "Title" VARCHAR(50) NOT NULL,
   "Description" VARCHAR(250),
   "Due" DATE,
   "Member" INTEGER,
   CONSTRAINT FK_MEM FOREIGN KEY ("Member")
      REFERENCES "TeamMember" ("ID")
);