test

Tables (4)

Untitled (Book)

  • Key (BookKey) — int — Primary key — NOT NULL
  • Key (AuthorNo) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (BookSign) — char(10)
  • Field (BookDay) — date
  • Key (BookSubKdc) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (BookName) — text

Untitled (Publisher)

  • Key (PubID) — int — Primary key — NOT NULL
  • Key (BookKey) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (AuthorNo) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (PubName) — char(20)
  • Field (PubAd) — char(50)

Untitled (Author)

  • Key (AuthorNo) — int — Primary key — NOT NULL
  • Field (AuthorName) — char(10)
  • Field (AuthorAd) — char(50)

Untitled (BookSubject)

  • Key (BookSubKdc) — int — Primary key — NOT NULL
  • Field (BookSubKey) — char(10)