Chronicles of Apocalyptica - Database Download

🎭 Relational Database for Complex Story Tracking

This database is the ONLY proper way to track the intricate relationships, identity twists, and interconnected storylines across all 25 books of Chronicles of Apocalyptica.

📊 SQLite Database (Recommended)

Complete database ready for direct import into Microsoft Access. Includes all tables, relationships, events, and family trees. This is the primary file you need.

Download Database (132 KB)

📄 SQL DDL Scripts

SQL statements for manual database creation and import. Use this if you prefer to manually create the database structure.

Download SQL Scripts (25 KB)

📖 Database Guide

Complete documentation including table structure, import instructions, example queries, and recommended forms/reports to create.

Download Guide (7 KB)

📋 Database Tables (18 Total)

tblCharacters - Main character data (40 records)

tblCharacterAliases - Identity transformations (7 records)

tblFamilyTree - NEW! Genealogy & bloodlines (9 family links)

tblSeries - The 6 series (6 records)

tblBooks - Individual book tracking

tblRelationships - Character connections (32 records)

tblCharacterAppearances - Appearances across series

tblFactions - Groups & organizations (5 records)

tblCharacterFactions - Character memberships

tblLocations - Places, kingdoms, realms

tblMysteries - Plot twists & reveals (6 records)

tblMysteryCharacters - Mystery involvement

tblEvents - NEW! Timeline events (42 records - DOUBLED!)

tblEventCharacters - Event involvement (63 character links)

tblMagicTypes - Magic systems

tblCharacterMagic - Magic abilities

tblSpecies - Species catalog

🔑 Key Features

Identity Twist Tracking: Nodran = Severen, Raziel = Windraven = Fendarious
Relationship Mapping: 32 character relationships with types (mate, father, enemy, etc)
Family Trees: NEW! 9 genealogy links tracking bloodlines and parentage
Story Events: NEW! 42 detailed events (DOUBLED!) across all timelines
Character Event Links: NEW! 63 connections showing who was involved in which events
Series Structure: All 6 series with book ranges and main characters
Mystery Tracker: Plot twists and when they're revealed
Faction Management: Track Obsidian Cabal, Keepers, kingdoms
Pre-built Views: 5 views including FamilyTree and EventsWithCharacters
Expandable Structure: Ready for locations, magic types, species details

📥 How to Import Into Microsoft Access

1. Download chronicles_of_apocalyptica.db
2. Open Microsoft Access
3. Click External Data tab
4. Click New Data Source → From Database → SQLite Database
5. Select the downloaded .db file
6. Choose Import tables option
7. Click Select All to import all 17 tables
8. Click OK - Done!

📚 Chronicles of Apocalyptica