2023_WebDB_ex6

Tables (6)

Untitled (BOOKS)

  • Key (ISBN) — char(13) — Primary key — NOT NULL
  • Field (booksTitle) — char(50)
  • Field (pubishDate) — date
  • Field (booksInfo) — text

Untitled (PUBLISHER)

  • Key (publisherNo) — char(30) — Primary key — NOT NULL
  • Field (publisherName) — char(30)
  • Field (publisherAddress) — char(50)

Untitled (WRITING)

  • Field (description) — text

Untitled (AUTHOR)

  • Key (authorSsn) — char(13) — Primary key — NOT NULL
  • Field (authorName) — char(30)
  • Field (authorAddress) — char(50)

Untitled (CONTRACT)

  • Key (contractNo) — char(30) — Primary key — NOT NULL
  • Field (quantity) — int
  • Field (duedate) — date

Untitled (PRINTER)

  • Key (printerNo) — char(30) — Primary key — NOT NULL
  • Field (printerName) — char(30)
  • Field (printerAddress) — char(50)
  • Field (capacity) — int