shahidhk · August 14, 2018 09:28
diff --git a/fk_rel_book_author_schema.sql b/fk_rel_book_author_schema.sql
 CREATE TABLE book (
  id        SERIAL NOT NULL,
  title     TEXT   NOT NULL,
  author    TEXT   NOT NULL,
  genre     TEXT,
  PRIMARY KEY (id)
 );

 CREATE TABLE author (
  name     TEXT NOT NULL,
  country  TEXT,
  born     INTEGER,
  died     INTEGER,
  PRIMARY KEY (name)
 );
	CREATE TABLE book (
	id SERIAL NOT NULL,
	title TEXT NOT NULL,
	author TEXT NOT NULL,
	genre TEXT,
	PRIMARY KEY (id)
	);

	CREATE TABLE author (
	name TEXT NOT NULL,
	country TEXT,
	born INTEGER,
	died INTEGER,
	PRIMARY KEY (name)
	);
No results found