2023_0328_EX06

Tables (6)

Untitled (BOOKS)

  • Key (bookIIsbn) — char(18) — Primary key — NOT NULL
  • Field (booktitle) — char(30)
  • Field (publicationDate) — date
  • Field (description) — test
  • Field (award) — test

Untitled (PUBLISHER)

  • Key (publiId) — char(10) — Primary key — NOT NULL
  • Key (bookIIsbn) — char(18) — Foreign key → Untitled.Key — NOT NULL
  • Field (pusnliName) — char(30)
  • Field (address) — char(30)
  • Field (phone) — char(11)

Untitled (WRITER)

  • Key (witerNo) — char(16) — Primary key — NOT NULL
  • Field (name) — char(30)
  • Field (address) — char(30)
  • Field (phone) — char(11)
  • Field (birthDate) — char(8)
  • Field (gender) — char(1)
  • Field (award) — test

Untitled (PRINTER)

  • Key (printerId) — int(1000) — Primary key — NOT NULL
  • Field (name) — char(30)
  • Field (address) — char(30)
  • Field (printDate) — date
  • Key (publiId) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (bookIIsbn) — char(18) — Foreign key → Untitled.Key — NOT NULL

Untitled (ROLE)

  • Key (roleId) — int(30) — Primary key — NOT NULL
  • Key (bookIIsbn) — char(18) — Foreign key → Untitled.Key — NOT NULL
  • Key (witerNo) — char(16) — Foreign key → Untitled.Key — NOT NULL

Untitled (SALES)

  • Key (saleId) — int(30) — Primary key — NOT NULL
  • Key (publiId) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (bookIIsbn) — char(18) — Foreign key → Untitled.Key — NOT NULL
  • Key (witerNo) — char(16) — Foreign key → Untitled.Key — NOT NULL