:
, , ;
;
:
;
;
;
.
:
;
;
;
.
:
;
;
:
;
;
:
;
;
.
, . , .
:
1) .
. , .
2) .
, . , , .
3) .
, .
4) .
. .
XAMPP 5.6.21 MySQL 5.6.21, phpMyAdmin 4.2.11, Apache 2.4.11 PHP 5.5.19
phpMyAdmin. , localhost/phpmyadmin
1. - localhost/phpmyadmin
Ļ, Salon3. utf8_geniral_ci.
SQL.
Client.
CREATE TABLE IF NOT EXISTS `client` (
`ID` int(11) NOT NULL,
`FIO_CL` varchar(15) CHARACTER SET utf8 NOT NULL,
`Adress` varchar(30) CHARACTER SET utf8 NOT NULL,
`Telephone` int(12) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
ID
FIO_CL
Adress
Telephone
, .
:
2. - Client.
Material
CREATE TABLE IF NOT EXISTS `material` (
|
|
`id` int(11) NOT NULL,
`Material` varchar(30) CHARACTER SET utf8 NOT NULL,
`Proizvoditel` varchar(11) CHARACTER SET utf8 NOT NULL,
`Postavchik` varchar(11) CHARACTER SET utf8 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
ID
Material
Proizvoditerl
Postavchik .
.
3. - Material.
Personal:
CREATE TABLE IF NOT EXISTS `personal` (
`ID` int(11) NOT NULL,
`FIO_MAS` varchar(15) CHARACTER SET utf8 NOT NULL,
`Doljnost` varchar(20) CHARACTER SET utf8 NOT NULL,
`Satj` varchar(30) CHARACTER SET utf8 NOT NULL,
`Telephone` int(12) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
ID
FIO_MAS
Staj
Telephone .
.
4. .
CREATE TABLE IF NOT EXISTS `preysqur` (
`ID` int(11) NOT NULL,
`Procedura` varchar(25) CHARACTER SET utf8 NOT NULL,
`Cena` decimal(10,0) NOT NULL,
`Material_id` varchar(30) CHARACTER SET utf8 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
ID
Procedura
Cena
Material_id .
5. .
:
CREATE TABLE IF NOT EXISTS `Zapis` (
`id` int(11) NOT NULL,
`data_ras` date DEFAULT NULL,
`time_ras` time DEFAULT NULL,
`FIO_CL` varchar(15) CHARACTER SET utf8 NOT NULL,
`Procedura_US` varchar(11) CHARACTER SET utf8 NOT NULL,
`FIO_MAS` varchar(15) CHARACTER SET utf8 NOT NULL,
`Oplacheno` decimal(10,0) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
ID
Data_ras
time_ras
FIO_CL
Procedura_US
FIO_MAS
Oplacheno .
Zapis , .
6. .
:
7.