Konomis

Tables (5)

Author

  • Name — char(16) — Primary key — NOT NULL
  • BirhDate — date
  • DebutDate — date
  • DebutWork — char(32)
  • BirthPlace — char(64)
  • Description — char(200)
  • AwardedHistory — char(200)

AwardedWork

  • title — char(16) — Primary key — NOT NULL
  • Name — char(16) — Foreign key → Author.Name — NOT NULL
  • PublicationDate — date
  • AwardedYear — date
  • Rank — int(10)
  • Genre — char(32)
  • Despcription — char(200)
  • MagazineID — char(8) — Foreign key → Magazine.MagazineID — NOT NULL

Magazine

  • MagazineID — char(8) — Primary key — NOT NULL
  • MagazineName — char(16)
  • SerialCycle — char(8)
  • FirstDate — date
  • Description — char(200)
  • PublisherID — char(8) — Foreign key → Publisher.PublisherID — NOT NULL

Publisher

  • PublisherID — char(8) — Primary key — NOT NULL
  • PublisherName — char(16)
  • PublisherWebsite — char(64)
  • EstablishDate — date
  • Description — char(200)

Publishing

  • PublisherID — char(8) — Foreign key → Publisher.PublisherID — NOT NULL
  • title — char(16) — Foreign key → AwardedWork.title — NOT NULL