[/left]
[left]create table zaezd (idzaezd int not null,
beginzaezd date,
endzaezd date,
primary key(idzaezd));

create table putevka (num_putevka int not null,
p_index int,
p_napr varchar(20),
p_vid varchar(20),
p_price int,
p_doplata int,
primary key(num_putevka));

create table krai (krai varchar(50) not null,
k_krai varchar(50),
primary key(krai));

create table pacient (IDpacient int not null,
num_putevka int,
IDzaezd int,
pac_fam varcahr(30),
pac_name varchar(30),
pac_ot4 varchar(30),
pac_sexy varchar(20),
pac_dategeb date,
krai varchar(30),
pac_raion varchar(30),
pac_city varchar(30),
pac_street varchar (30),
pac_home int,
pac_korp int,
pac_float int,
pac_phone varchar(30),
primary key(IDpacient));

create table medkarta ( num_medkarta int not null,
psiholog varchar(100),
hirurg varchar (100),
primary key (num_medkarta));



[/left]
[left]