sql data

Tables (3)

AUTHOR

  • authorID — int(10) — Primary key — NOT NULL
  • autName — char(30)
  • (autnation) — char(3)

BOOK

  • bookID — int(10) — Primary key — NOT NULL
  • kdc — char(50)
  • title — char(50)
  • pubyear — int(4)
  • ISBN — char(13)
  • Exkdc — char(3)
  • Field (price) — int(10)

Book_Author

  • authorID — int(10) — Foreign key → AUTHOR.authorID — NOT NULL
  • bookID — int(10) — Foreign key → BOOK.bookID — NOT NULL