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