Create table Musteriler
(
MusteriID int identity(1,1) primary key not null,
SirketAdi nvarchar(30) not null,
Telefonu nvarchar(24) not null
)
Create table Siparisler
(
SiparisId int identity(1,1) primary key not null,
SiparisTarihi date not null,
SiparisiVerenMusteriID int foreign key references Musteriler(MusteriID) not null,
SiparisAlanPersonelID int foreign key references Personeller(PersonelID) not null
)
Hiç yorum yok:
Yorum Gönder