SQL

CREATE TABLE writtenBy (
  ISBN VARCHAR(40),
  TaxNo VARCHAR,
  PRIMARY KEY (ISBN, TaxNo),
  FOREIGN KEY (ISBN) REFERENCES Book(ISBN),
  FOREIGN KEY (TaxNo) REFERENCES Author(TaxNo)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
ISBN VARCHAR(40) ✓ ✓ Rename | Drop
TaxNo VARCHAR ✓ ✓ Rename | Drop

Foreign Keys

Column Destination
TaxNo Author.TaxNo
ISBN Book.ISBN

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_writtenBy_1
  • ISBN
  • TaxNo
 ✓ SQL
-- no sql found --
 Drop