Memory Alpha:Episode data project/fields

The fields in the database, most of them also appear in the sidebar.

Notation
Basically it is.

Prefixes

 * a:article link. The name of an article at MA.
 * n:number.
 * s:string. a plain string of text.
 * ws:string of wiki format text. (has links, for instance)
 * b:boolean. 0 or 1.

Basic

 * aSelf:The name of the article that the template appears in, or appeared in when the data was updated.


 * sTitle:The title of the episode.
 * sSeries:one of (TOS, TAS, TNG, DS9, VOY, ENT, FLM)
 * nSeason:The season number
 * nEpisode:The episode number in the season. These are based on airdate, except for in TOS. bFeatureLength uses up two of these.
 * nNthProducedInSeries:The order in production.
 * nNthReleasedInSeries:The order of release in sSeries series.
 * nNthReleasedInAll:The order of release in all episodes.
 * sProductionSerialNumber:The production number of the episode.
 * nAirdateYear:The year the episode was released.
 * sAirdateMonth:The name of the month in nAirdateYear that the episode was released.
 * nAirdateDay:The day of sAirdateMonth of nAirdateYear that the episode was released.
 * sImage:The name of the image that will be placed in the sidebar without the namespace.
 * bFeatureLength:Set if the episode was feature-length. Unset for films. See Memory Alpha:Episode data project/feature-length for the list of episodes.
 * nSerialAirdate:Original release date in the YYYMMDD format.

Credits

 * wsWrittenBy:The credit "Written by."
 * wsTeleplayBy:The credit "Teleplay by" or "Screenplay by."
 * wsStoryBy:The credit "Story by."
 * wsDirectedBy:The director.
 * wsProducedBy:The producer or executive producer(s).

In-episode dates

 * wsDate:The date string in the form "stardates (Gregorian dates)"

Article links

 * aNextReleasedInAll:
 * aPrevReleasedInAll:
 * aNextReleasedInSeries:
 * aPrevReleasedInSeries:
 * aNextProducedInSeries:
 * aPrevProducedInSeries:
 * aNextInUniverseTimeline:
 * aPrevInUniverseTimeline:

Arcs
See Memory Alpha:Episode data project/arcs for the list. There are 3 slots for an arc browser to be in the template, Arc0, Arc1, Arc2. That means an episode can be part of three different continuities.
 * aArc0PrevPart:
 * aArc0NextPart:
 * nArc0PartNumber:
 * nArc0PartCount:
 * wsArc0Desc:

Remastered
A group of data added for remastered episodes.


 * nNthReleasedInSeries_Remastered:
 * nAirdateYear_Remastered:
 * sAirdateMonth_Remastered:
 * nAirdateDay_Remastered:
 * aNextReleasedInSeries_Remastered:
 * aPrevReleasedInSeries_Remastered:
 * nSerialAirdate_Remastered: