, . , . , , . , , , , . (. 4.7)
. (), (). UML- (. 4.8)
: INT 4 , TINYTEXT 28 , FLOAT 4 .
UML- tedia2sql SQL- .
-- group
--
create table group (
id int auto_increment primary key, --
name tinytext, --
teacher tinytext, -- .
students int, -- -
speciality int --
);
-- specialities
--
create table specialities (
id int auto_increment primary key, --
name tinytext --
);
-- years
--
create table years (
id int auto_increment primary key, --
year tinytext --
);
-- rates
--
create table rates (
id int auto_increment primary key, --
group int, --
year int, --
poor int, -- -
unattested int, -- -
quality float, -- .
average float --
);
5.
Kshema, , , , . .
- :
|-- libs
| `-- xmlrpc
|-- modules
| |-- auth
| | `-- templates
| |-- base
| | `-- templates
| |-- counter
| | `-- templates
| |-- db
| | `-- templates
| |-- modules
| | `-- templates
| |-- performance
| |-- redirect
| | `-- templates
| `-- results_analysis
| `-- templates
| |-- templater
| |-- themes
| | `-- templates
| |-- updater
| | `-- templates
| |-- uploads
| | `-- templates
| |-- users
| | `-- templates
|-- themes
| |-- default
| | |-- css
| | |-- flash
| | |-- images
| | |-- js
|
|
| | |-- pages
| | | `-- includes
| | `-- templates
| `-- results_analysis
| |-- css
| |-- flash
| |-- images
| |-- js
| |-- pages
| | `-- includes
| `-- templates
| |-- auth
| |-- base
| `-- users
|-- updates
| `-- themes
`-- uploads
libs . updates , uploads . themes , modules , vedomost .
(. 5.1).
. (. 5.2)
. .
(. 5.3).
. , . . (. 5.4).
, . . , . (. 5.5).
, , . . . .
, . (. 5.6).
, . .
. (. 5.7).
. , , , , , .
. , , , . , . , , - Apache, MySQL PHP, - , . , .
|
|