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)