Goyang

Tables (4)

Untitled (GoyangAuthor)

  • Key (AuthorID) — int(12) — Primary key — NOT NULL
  • Field (name) — char(20)
  • Field (address) — char(50)
  • Field (phoneNo) — int(11)
  • Field (majorWorks) — text

Untitled (Book)

  • Key (ISBN) — char(13) — Primary key — NOT NULL
  • Field (title) — char(50)
  • Field (pubYear) — int(4)
  • Field (publisher) — char(20)
  • Key (AuthorID) — int(12) — Foreign key → Untitled.Key — NOT NULL

Untitled (Library)

  • Key (libraryID) — char(20) — Primary key — NOT NULL
  • Field (libraryName) — char(30)
  • Key (ISBN) — char(13) — Foreign key → Untitled.Key — NOT NULL
  • Key (ISBN2) — char(13) — Foreign key → Untitled.Key — NOT NULL

Untitled (RecommembedBook)

  • Key (ISBN) — char(13) — Primary key — NOT NULL
  • Field (title) — char(50)
  • Field (author) — char(30)
  • Field (publisher) — char(20)
  • Field (pubYear) — int(4)
  • Key (AuthorID) — int(12) — Foreign key → Untitled.Key — NOT NULL