and Subject: Message.
Pic 2
Thus we have the final form of the scheme:
Pic 3
4. Application development
4.1 Description of tables, fields, input conditions
· Table users:
- ID-key field, the counter
- name - type string
- country - the type of country that refers to the reference countries. Not a required field.
- Nickname - type string.
- Password - type string.
- E-mail - type string.
- date - the type of date.
- Address - type string, not required.
- Status - refers to the directory. Not a required field.
· Table of Topics:
- ID - key field meter.
- name - type string.
- Author - field to link the user to the table, the type of user.
- The number of responses - the type integer.
- open / closed - type string.
- Time - the type of date ..
· Table of Messages
- ID - key field meter.
- topic - Type topic.
- Author - field for communication with the user, type user.
- Time - the date / time.
- content - the text message, as a string field.
· Table of Punishment
- topic - Type topic.
- Author - field for communication with the user, type user.
- time violation - Type date.
- Closing punishment - Type date.
- Descriptions violations - text.
· Table of user s online history
- ID - integer. Indexed.
- Start time - date / time.
- End time - date / time.
- User - type user.
· Table of Friends
- The man - the type of user
- A friend - the type of string. Contains friend s nickname.
· Table of Country
- ID - Key field. Counter.
- country - text box ..
· Table of Status
- ID - Key field. Counter.
- List status - the text box ..
4.2 Development of screens
The base consists of 8 simple screens and 6 additional screens. Simple screens serve as the table for change the information, but you can create reports and sort through the fields, here is an example of this screen:
Pic 4
the database there are 2 more difficult screen:" Topics List Detail» and «Members List Detail». Pic 5 and Pic 6.
Pic 5
Pic 6
form «Topics List Detail» shows information about a topic, the list of violations in this topic.form the »Members List Detail» shows informatio...
