ex6

Tables (9)

BOOK (Untitled)

  • bookid (Key) — char(13) — Primary key — NOT NULL
  • ISBN (Field) — char(13)
  • title (Field2) — text
  • issue (Field3) — date
  • price (Field4) — integer
  • type (Field5) — char(10)
  • kdc(6th) (Field6) — char(20)
  • publisherid (Key2) — char(13) — Foreign key → publisher.publisherid — NOT NULL

author (Untitled2)

  • authorid (Key) — char(13) — Primary key — NOT NULL
  • ssn (Field8) — char(13)
  • name (Field) — char(10)
  • alternativeName (Field5) — char(10)
  • phone (Field2) — char(11)
  • address (Field3) — text
  • email (Field6) — char(30)
  • majorWorks (Field7) — text
  • description (Field4) — text

award (Untitled6)

  • awardid (Key) — char(13) — Primary key — NOT NULL
  • field (Field) — char(10)
  • ranking (Field2) — char(10)
  • agency (Field3) — char(10)
  • description (Field4) — text

award_author (Untitled8)

  • award_authorid (Key) — char(13) — Primary key — NOT NULL
  • date (Field) — date
  • additional prize. (Field2) — text
  • description (Field3) — text
  • awardid (Key2) — char(13) — Foreign key → award.awardid — NOT NULL
  • authorid (Key3) — char(13) — Foreign key → author.authorid — NOT NULL

award_book (Untitled7)

  • award_bookid (Key) — char(13) — Primary key — NOT NULL
  • date (Field) — date
  • additional prize (Field2) — text
  • description (Field3) — text
  • awardid (Key2) — char(13) — Foreign key → award.awardid — NOT NULL
  • bookid (Key3) — char(13) — Foreign key → BOOK.bookid — NOT NULL

book_author (Untitled9)

  • book_authorid (Key) — char(13) — Primary key — NOT NULL
  • bookid (Key2) — char(13) — Foreign key → BOOK.bookid — NOT NULL
  • authorid (Key3) — char(13) — Foreign key → author.authorid — NOT NULL

contract (Untitled5)

  • contractid (Key) — char(13) — Primary key — NOT NULL
  • volume (Field) — integer
  • deadline (Field2) — date
  • payment (Field3) — integer
  • publisherid (Key2) — char(13) — Foreign key → publisher.publisherid — NOT NULL
  • printerid (Key3) — char(13) — Foreign key → printer.printerid — NOT NULL
  • bookid (Key4) — char(13) — Foreign key → BOOK.bookid — NOT NULL

printer (Untitled4)

  • printerid (Key) — char(13) — Primary key — NOT NULL
  • name (Field) — char(10)
  • address (Field2) — text
  • phone (Field3) — char(11)

publisher (Untitled3)

  • publisherid (Key) — char(13) — Primary key — NOT NULL
  • CBR (Field4) — char(20)
  • name (Field) — char(10)
  • address (Field2) — text
  • phone (Field3) — char(11)