Kasutajaliidesed lectures 2005 common theme - Redigeerimiste ajalugu

Tammet: /* Schema */

2006-02-06T13:55:28Z

Schema

←Vanem redaktsioon		Redaktsioon: 6. veebruar 2006, kell 15:55
15. rida:		15. rida:
	The underlying schema will contain these main tables plus a few more:		The underlying schema will contain these main tables plus a few more:

	* Party. The main table. Will have at least the following fields, of which only the name is obligatory, poster and posting datetime are automatic.		* '''Party'''. The main table. Will have at least the following fields, of which only the name is obligatory, poster and posting datetime are automatic:
	** Name		** Name
	** Description		** Description
	** Organiser (person known to organise party)		** Organiser (person known to organise party)
	** Date		** Date
	** Time		** Time
	** Duration (hours)		** Duration (hours)
	** Location (just text)		** Location (just text)
	** Xcoordinate (to show on the map)		** Xcoordinate (to show on the map)
	** Ycoordinate (to show on the map)		** Ycoordinate (to show on the map)
	** Type (what kind of a party)		** Type (what kind of a party)
	** Poster (person publishing information)		** Poster (person publishing information)
	** Postingdatetime		** Postingdatetime

	* Note. This is attached to the party. Will have at least the following fields, of which the poster and posting datetime are automatic).		* '''Note'''. This is attached to the party. Will have at least the following fields, of which the poster and posting datetime are automatic):
	** Partyid		** Partyid
	** Notetext		** Notetext
	** Notecategory		** Notecategory
	** Poster (person publishing information)		** Poster (person publishing information)
	** Postingdatetime		** Postingdatetime
	** Picturefile (if uploaded)		** Picturefile (if uploaded)

	* Person. People are not really identified, hence contains very little information, at least the following fields:		* '''Person'''. People are not really identified, hence contains very little information, at least the following fields:
	** Logincode		** Logincode
	** Email		** Email
	** Lastlogindatetime		** Lastlogindatetime


	NB! You are free to add any fields you like to these tables.		'''NB!''' You are free to add any fields you like to these tables.

Tammet: /* Schema */

2006-02-06T13:54:12Z

Schema

←Vanem redaktsioon		Redaktsioon: 6. veebruar 2006, kell 15:54
15. rida:		15. rida:
	The underlying schema will contain these main tables plus a few more:		The underlying schema will contain these main tables plus a few more:

	* Party. The main table. Will have at least the following fields, of which only the name is obligatory, poster and posting datetime		* Party. The main table. Will have at least the following fields, of which only the name is obligatory, poster and posting datetime are automatic.
	are automatic.
	** Name		** Name
	** Description		** Description

Tammet: /* Schema */

2006-02-06T13:53:53Z

Schema

←Vanem redaktsioon		Redaktsioon: 6. veebruar 2006, kell 15:53
17. rida:		17. rida:
	* Party. The main table. Will have at least the following fields, of which only the name is obligatory, poster and posting datetime		* Party. The main table. Will have at least the following fields, of which only the name is obligatory, poster and posting datetime
	are automatic.		are automatic.
	** Name		** Name
	** Description		** Description
	** Organiser (person known to organise party)		** Organiser (person known to organise party)
	** Date		** Date

Tammet – 6. veebruar 2006, kell 13:53

2006-02-06T13:53:40Z

←Vanem redaktsioon		Redaktsioon: 6. veebruar 2006, kell 15:53
1. rida:		1. rida:

	== Site idea: party information ==		== Site idea: party information ==

	The goal of the site is to help organising parties and providing people with		The goal of the site is to help organising parties and providing people with comments, stories and pictures about parties past. Create the interface either in Estonian or English.
	comments, stories and pictures about parties past. Create the interface either
	in Estonian or English.

	Anybody can post information about an upcoming (or passed) party.		Anybody can post information about an upcoming (or passed) party.
	After that, other people can add information about the party. A party may be either		After that, other people can add information about the party. A party may be either
	* public (everybody is free to see all the information, add comments/stories/pictures)		* public (everybody is free to see all the information, add comments/stories/pictures)
	* or private (information is sent out via email, only the email receivers will be		* or private (information is sent out via email, only the email receivers will be able to see/post information).
	able to see/post information).

	There will be no real authentication. Where login is neccessary, people		There will be no real authentication. Where login is neccessary, people should login in using a randomly assigned code (acts as a user id
	should login in using a randomly assigned code (acts as a user id		and password combo) which is passed as an ordinary cgi parameter code=... People will receive the code via email as a clicakble link already containing the correct cgi parameter assigned to them. Hence, no need to remember/know user id-s or passwords. Invited people will be invited via email.
	and password combo) which is passed as an ordinary cgi parameter code=...
	People will receive the code via email as a clicakble link already containing
	the correct cgi parameter assigned to them. Hence, no need to remember/know
	user id-s or passwords. Invited people will be invited via email.

	== Schema ==		== Schema ==
23. rida:		15. rida:
	The underlying schema will contain these main tables plus a few more:		The underlying schema will contain these main tables plus a few more:

	* Party. The main table. Will have at least the following fields,		* Party. The main table. Will have at least the following fields, of which only the name is obligatory, poster and posting datetime
	of which only the name is obligatory, poster and posting datetime
	are automatic.		are automatic.
	** Name		** Name
39. rida:		30. rida:
	** Postingdatetime		** Postingdatetime

	* Note. This is attached to the party. Will have at least the following fields,		* Note. This is attached to the party. Will have at least the following fields, of which the poster and posting datetime are automatic).
	of which the poster and posting datetime are automatic).
	** Partyid		** Partyid
	** Notetext		** Notetext
48. rida:		38. rida:
	** Picturefile (if uploaded)		** Picturefile (if uploaded)

	* Person. People are not really identified, hence contains very little information,		* Person. People are not really identified, hence contains very little information, at least the following fields:
	at least the following fields:
	** Logincode		** Logincode
	** Email		** Email

Tammet – 6. veebruar 2006, kell 13:52

2006-02-06T13:52:47Z

Uus lehekülg

== Site idea: party information ==

The goal of the site is to help organising parties and providing people with
comments, stories and pictures about parties past. Create the interface either
in Estonian or English.

Anybody can post information about an upcoming (or passed) party.
After that, other people can add information about the party. A party may be either
* public (everybody is free to see all the information, add comments/stories/pictures)
* or private (information is sent out via email, only the email receivers will be
able to see/post information).

There will be no real authentication. Where login is neccessary, people
should login in using a randomly assigned code (acts as a user id
and password combo) which is passed as an ordinary cgi parameter code=...
People will receive the code via email as a clicakble link already containing
the correct cgi parameter assigned to them. Hence, no need to remember/know
user id-s or passwords. Invited people will be invited via email.

== Schema ==

The underlying schema will contain these main tables plus a few more:

* Party. The main table. Will have at least the following fields,
of which only the name is obligatory, poster and posting datetime
are automatic.
** Name
** Description
** Organiser (person known to organise party)
** Date
** Time
** Duration (hours)
** Location (just text)
** Xcoordinate (to show on the map)
** Ycoordinate (to show on the map)
** Type (what kind of a party)
** Poster (person publishing information)
** Postingdatetime

* Note. This is attached to the party. Will have at least the following fields,
of which the poster and posting datetime are automatic).
** Partyid
** Notetext
** Notecategory
** Poster (person publishing information)
** Postingdatetime
** Picturefile (if uploaded)

* Person. People are not really identified, hence contains very little information,
at least the following fields:
** Logincode
** Email
** Lastlogindatetime

NB! You are free to add any fields you like to these tables.