123

Tables (6)

AUTHOR (Untitled3)

  • proNo (Key) — int(12) — Primary key — NOT NULL
  • name (Field) — char(8)
  • address (Field2) — char(11)
  • ID (Key2) — int(10) — Foreign key → PUBILISHING HOUSE.ID — NOT NULL

BOOK (Untitled)

  • bookNo (Key) — int(10) — Primary key — NOT NULL
  • name (Field) — char(8)
  • pubDate (Field2) — int(8)

BOOK1 (Untitled4)

  • bookNo (Key) — int(10) — Foreign key → BOOK.bookNo — NOT NULL
  • proNo (Key2) — int(12) — Foreign key → AUTHOR.proNo — NOT NULL
  • ID (Key3) — int(10) — Foreign key → PUBILISHING HOUSE.ID — NOT NULL
  • name (Key32) — char(8) — Foreign key → KEYWORD.name — NOT NULL

CHARACTER (Untitled6)

  • nameNo (Key) — char(8) — Primary key — NOT NULL

KEYWORD (Untitled5)

  • name (Key3) — char(8) — Primary key — NOT NULL
  • bookNo (Key) — int(10) — Foreign key → BOOK.bookNo — NOT NULL
  • nameNo (Key2) — char(8) — Foreign key → CHARACTER.nameNo — NOT NULL

PUBILISHING HOUSE (Untitled2)

  • ID (Key) — int(10) — Primary key — NOT NULL
  • name (Field) — char(8)
  • address (Field2) — char(11)