Baza danych wykorzystana w projekcie to PostgreSQL v.9, a do jej wykonania posłużono się środowiskiem SQL Manager Lite for PostgreSQL

SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;

CREATE DATABASE project WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'Polish, Poland' LC_CTYPE = 'Polish, Poland';

ALTER DATABASE project OWNER TO project;

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;

COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';

SET search_path = public, pg_catalog;
SET default_tablespace = '';
SET default_with_oids = false;

CREATE TABLE users
(
  id_user serial NOT NULL,
  id_name integer,
  id_surname integer,
  user_nic character varying(100),
  email character varying(50) NOT NULL,
  password character varying(50) NOT NULL,
  description character varying(150),
  type_accound character varying,
  is_root boolean,
  is_blocked boolean,
  CONSTRAINT users_pkey PRIMARY KEY (id_user )
)
WITH (
  OIDS=FALSE
);
/////////////////////////////////

CREATE TABLE user_group
(
  id_group serial NOT NULL,
  group_name character varying(50),
  description character varying(200),
  status integer,
  superuser character varying(1),
  CONSTRAINT user_group_pkey PRIMARY KEY (id_group )
)
WITH (
  OIDS=FALSE
);
////////////////////////////////////////////////

CREATE TABLE user_conn_group
(
  id_user integer NOT NULL,
  id_group integer NOT NULL,
  status character varying(1)
)
WITH (
  OIDS=FALSE
);
//////////////////////////////////////////
CREATE TABLE table_surname
(
  id_surname serial NOT NULL,
  surname character varying(100),
  CONSTRAINT table_surname_pkey PRIMARY KEY (id_surname )
)
WITH (
  OIDS=FALSE
);
/////////////////////////////////////////


CREATE TABLE table_names
(
  id_name serial NOT NULL,
  name character varying(100) NOT NULL,
  CONSTRAINT table_names_pkey PRIMARY KEY (id_name ),
  CONSTRAINT table_names_name_key UNIQUE (name )
)
WITH (
  OIDS=FALSE
);
///////////////////////////////////
CREATE TABLE table_referee
(
  id_referre serial NOT NULL,
  name_referee integer NOT NULL,
  surname_referee integer NOT NULL,
  id_games integer NOT NULL,
  status_referee character varying,
  CONSTRAINT table_referee_pkey PRIMARY KEY (id_referre )
)
WITH (
  OIDS=FALSE
);
///////////////////////////////////

CREATE TABLE games
(
  id_game serial NOT NULL,
  id_module integer,
  id_user_prod integer,
  date_create timestamp without time zone,
  date_start timestamp without time zone,
  date_close_list timestamp without time zone,
  subject character varying(100),
  description text,
  active character varying(1),
  localization character varying(150),
  CONSTRAINT games_pkey PRIMARY KEY (id_game )
)
WITH (
  OIDS=FALSE
);
/////////////////////////
CREATE TABLE game_conn_user
(
  id_game_conn_user serial NOT NULL,
  id_game integer NOT NULL,
  id_user integer NOT NULL,
  date_time_add timestamp without time zone,
  CONSTRAINT game_conn_user_pkey PRIMARY KEY (id_game_conn_user )
)
WITH (
  OIDS=FALSE
);
////////////////////////////
CREATE TABLE competitor
(
  id_competitor serial NOT NULL,
  id_name integer NOT NULL,
  id_surname integer NOT NULL,
  date_birth date,
  id_user integer DEFAULT 0,
  id_game_conn_users integer,
  level integer,
  url_picture character varying(250),
  id_klub integer,
  CONSTRAINT competitor_pkey PRIMARY KEY (id_competitor )
)
WITH (
  OIDS=FALSE
);
/////////////////////////////////////////////////
CREATE TABLE category_games
(
  id_cat_games serial NOT NULL,
  id_game integer NOT NULL,
  cat_game_name character varying(100),
  text_game_cat character varying(500),
  age_min integer,
  age_max integer,
  level_min double precision,
  level_max double precision,
  weight_comp double precision,
  age_accept character varying(1), -- typ akceptowanego wieku- dokładna data, rocznikowo
  status character varying(1),
  referee_id character varying(100),
  module_name character varying(50),
  module_id integer,
  CONSTRAINT category_games_pkey PRIMARY KEY (id_cat_games )
)
WITH (
  OIDS=FALSE
);
/////////////////////////////////////////////
CREATE TABLE kumite
(
  id_kumite serial NOT NULL,
  id_cat_game integer,
  id_competitor_1 integer,
  id_copmetitor_2 integer,
  next_kumite_id integer,
  referee_id character varying(100),
  points character varying(200),
  status character varying(1),
  id_winer integer,
  CONSTRAINT kumite_pkey PRIMARY KEY (id_kumite )
)
WITH (
  OIDS=FALSE
);
//////////////////////////////////////////////////////////
CREATE TABLE kata_table
(
  id_kata serial NOT NULL,
  id_competitor integer NOT NULL,
  referre_id character varying(100),
  referre_points character varying(200),
  number_series integer,
  suma double precision,
  CONSTRAINT kata_table_pkey PRIMARY KEY (id_kata )
)
WITH (
  OIDS=FALSE
);
////////////////////////////////////////////////////////////
CREATE TABLE tamashiwari
(
  id_tamashiwari serial NOT NULL,
  id_category_games integer,
  id_competitor integer,
  id_materials integer,
  point double precision,
  level integer,
  "number" integer,
  CONSTRAINT tamashiwari_pkey PRIMARY KEY (id_tamashiwari )
)
WITH (
  OIDS=FALSE
);
////////////////////////////////////////////////////////////
CREATE TABLE materials
(
  id_material serial NOT NULL,
  name character varying(100),
  id_category_games integer,
  points double precision,
  CONSTRAINT materials_pkey PRIMARY KEY (id_material )
)
WITH (
  OIDS=FALSE
);
///////////////////////////////////////////////////////////
CREATE TABLE modules
(
  id_module serial NOT NULL,
  name character varying(50),
  description character varying(300),
  url character varying(100),
  to_menu character varying,
  status character varying(1),
  CONSTRAINT modules_pkey PRIMARY KEY (id_module )
)
WITH (
  OIDS=FALSE
);
///////////////////////////////////////////////////

logowanie:

rejestracja:

tworzenie nowych zawodów:

tworzenie nowej kategorii:

Sterowanie aplikacją odbywa się poprzez panel administracyjny:

System był przez nas wielokrotnie testowany, w trakcie prac nad projektem jak i po ich zakończeniu.

Wprowadzanie danych odbywa się za pomocą odpowiednich pól i formularzy znajdujących się na poszczególnych stronach serwisu.

Po ukończeniu wszelkich prac związanych z projektem oraz sfinalizowaniu transakcji, proces wdrożenia planujemy wykonać jednorazowo.

Chociaż obsługa serwisu jest prosta i intuicyjna, zamierzamy przeprowadzić krótkie szkolenie dla naszego klienta.

Ze względu na planowane szkolenie, dokumentacja nie jest wymagana przez naszego odbiorcę.

Punkt ten będzie zależny od woli naszego zleceniodawcy.

@up

Efektem prac nad projektem było powtórzenie jak i poszerzenie wiedzy na temat wykorzystanych technologi. Nauczyliśmy się rozwiązywać i radzić sobie z wieloma problemami oraz pracować w zespole.

http://www.php.net/

http://www.postgresql.org/