Star Trek Database

Check-in [fb1c9eba38]
Login

Check-in [fb1c9eba38]

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Change stardate affinity type to FLOAT, so that “.0” stardates get stored and displayed exactly as such.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: fb1c9eba382e4424b8ec782cc597d7cde72201fb73592e87138a4b57240eed41
User & Date: chungy 2026-03-19 13:38:16.262
Context
2026-03-19
14:05
Change stardate affinity (again) to TEXT.

In thinking about the last check-in, this database is Star Trek metadata rather than the in-universe canonical representations. For stardates, it looks close, but it is more appropriate to represent what is stated exactly on-screen than treating them as actual numbers. check-in: 81aefc40d0 user: chungy tags: trunk

13:38
Change stardate affinity type to FLOAT, so that “.0” stardates get stored and displayed exactly as such. check-in: fb1c9eba38 user: chungy tags: trunk
2026-03-13
01:07
Finish data for Starfleet Academy season 1. Renumbered the episode IDs to properly account for the remaining episodes of Strange New Worlds. check-in: addc6220f2 user: chungy tags: trunk
Changes
Unified Diff Ignore Whitespace Patch
Changes to schema.sql.
︙︙
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49

       series_id INTEGER NOT NULL REFERENCES series,
       title TEXT NOT NULL,
       airdate DATE,
       remastered_airdate DATE,
       season INTEGER,
       episode_number INTEGER,
       production_code TEXT,
       stardate NUMERIC,
       date DATETIME,
       vignette BOOLEAN
);

CREATE TABLE media_set (
       media_set_id INTEGER PRIMARY KEY,
       series_id INTEGER NOT NULL REFERENCES series,








|








35
36
37
38
39
40
41
42
43
44
45
46
47
48
49

       series_id INTEGER NOT NULL REFERENCES series,
       title TEXT NOT NULL,
       airdate DATE,
       remastered_airdate DATE,
       season INTEGER,
       episode_number INTEGER,
       production_code TEXT,
       stardate FLOAT,
       date DATETIME,
       vignette BOOLEAN
);

CREATE TABLE media_set (
       media_set_id INTEGER PRIMARY KEY,
       series_id INTEGER NOT NULL REFERENCES series,
︙︙