Archive:Database Schema 4.0/a - Revision history

Karellen at 06:30, 1 August 2020

2020-08-01T06:30:49Z

← Older revision		Revision as of 06:30, 1 August 2020
Line 1:		Line 1:
	~~{{mininav\|[[Development]]\|[[Database Schema 4.0]]}}~~		This is the version of [[Archive:Database Schema 4.0]] before the EAV/CR schema modification. It's being retained for comparison, and because there are concerns ''this'' revision has some great EAV/CR abstractions -- such as content and attributes (sets, actors, directors, etc.) -- that the 4.0 revision abstracts too far and essentially builds a database with/within a database, leaving the C++ client to do the work of a DBMS.

	~~{{DISPLAYTITLE:Database Schema 4.0a}}~~
	This is the version of [[Database Schema 4.0]] before the EAV/CR schema modification. It's being retained for comparison, and because there are concerns ''this'' revision has some great EAV/CR abstractions -- such as content and attributes (sets, actors, directors, etc.) -- that the 4.0 revision abstracts too far and essentially builds a database with/within a database, leaving the C++ client to do the work of a DBMS.

	== Introduction ==		== Introduction ==
Line 530:		Line 527:
	</pre>		</pre>

	[[Category:Development]]		[[Category:Development-Archived]]

2020-08-01T06:29:41Z

Karellen moved page Database Schema 4.0/a to Archive:Database Schema 4.0/a without leaving a redirect: Proposed 2010 design

← Older revision	Revision as of 06:29, 1 August 2020
(No difference)

2013-09-02T08:13:33Z

← Older revision		Revision as of 08:13, 2 September 2013
Line 1:		Line 1:
	{{mininav\|[[Development]]}}		{{mininav\|[[Development]]\|[[Database Schema 4.0]]}}

	{{DISPLAYTITLE:Database Schema 4.0a}}		{{DISPLAYTITLE:Database Schema 4.0a}}

2013-09-02T08:12:06Z

← Older revision		Revision as of 08:12, 2 September 2013
Line 1:		Line 1:
			{{mininav\|[[Development]]}}

	{{DISPLAYTITLE:Database Schema 4.0a}}		{{DISPLAYTITLE:Database Schema 4.0a}}
	This is the version of [[Database Schema 4.0]] before the EAV/CR schema modification. It's being retained for comparison, and because there are concerns ''this'' revision has some great EAV/CR abstractions -- such as content and attributes (sets, actors, directors, etc.) -- that the 4.0 revision abstracts too far and essentially builds a database with/within a database, leaving the C++ client to do the work of a DBMS.		This is the version of [[Database Schema 4.0]] before the EAV/CR schema modification. It's being retained for comparison, and because there are concerns ''this'' revision has some great EAV/CR abstractions -- such as content and attributes (sets, actors, directors, etc.) -- that the 4.0 revision abstracts too far and essentially builds a database with/within a database, leaving the C++ client to do the work of a DBMS.

2012-04-09T07:23:58Z

← Older revision		Revision as of 07:23, 9 April 2012
Line 8:		Line 8:
	The current state of the schema (which we are currently happiest with) is being released for a community review to ensure any potential "gotchas" are caught and addressed early.		The current state of the schema (which we are currently happiest with) is being released for a community review to ensure any potential "gotchas" are caught and addressed early.

			Below you can find a diagram of the Database Scheme (mostly based on 4.0a)

			[[File:DatabaseSchemeBasedOn4.0a.png]]

2011-11-27T02:30:10Z

← Older revision		Revision as of 02:30, 27 November 2011
Line 1:		Line 1:
			{{DISPLAYTITLE:Database Schema 4.0a}}
	This is the version of [[Database Schema 4.0]] before the EAV/CR schema modification. It's being retained for comparison, and because there are concerns ''this'' revision has some great EAV/CR abstractions -- such as content and attributes (sets, actors, directors, etc.) -- that the 4.0 revision abstracts too far and essentially builds a database with/within a database, leaving the C++ client to do the work of a DBMS.		This is the version of [[Database Schema 4.0]] before the EAV/CR schema modification. It's being retained for comparison, and because there are concerns ''this'' revision has some great EAV/CR abstractions -- such as content and attributes (sets, actors, directors, etc.) -- that the 4.0 revision abstracts too far and essentially builds a database with/within a database, leaving the C++ client to do the work of a DBMS.

2011-11-27T02:29:43Z

← Older revision	Revision as of 02:29, 27 November 2011
(No difference)

2011-11-27T02:29:32Z

2011-09-07T16:08:42Z

Robot: Cosmetic changes

← Older revision		Revision as of 16:08, 7 September 2011
Line 23:		Line 23:
	ALSO		ALSO

	# Classification should be expandable to add new values making possible finer grouping/classification of media.		# Classification should be expandable to add new values making possible finer grouping/classification of media.
	# Classification is achieved by the classification table whereby an official list of classifications already exists but can be expanded by the user.		# Classification is achieved by the classification table whereby an official list of classifications already exists but can be expanded by the user.
	# The official classifications are "Movies", "Tv Shows", "Music Videos", and "Documentaries".		# The official classifications are "Movies", "Tv Shows", "Music Videos", and "Documentaries".

2010-09-24T19:05:55Z

Update foreign keys: fix syntax, add on delete/on update.