Notes
Notes - notes.io |
Use VeterinerDB
Go
Create table Musteri
(
MusteriId Int Identity,
Musteriadi varchar(50),
Musterisoyadi varchar(50),
Musteritelefon varchar(11),
Musteriadres varchar(250),
constraint PK_Musteri_MusteriId primary key (MusteriId)
)
Go
Create table Veteriner
(
VeterinerId Int Identity,
VeterinerAdi varchar(50),
VeterinerSoyadi varchar(50),
GSM varchar(11),
HastaHayvanId Int,
KlinikId Int,
Constraint AN_Klinik_GSM Unique (GSM),
Constraint PK_Veteriner_VeterinerId primary key (VeterinerId),
Constraint FK_Veteriner_HastaHayvanId foreign key (HastaHayvanId) references HastaHayvan(HastaHayvanId),
Constraint FK_Veteriner_KlinikId foreign key (KlinikId) references Klinik(KlinikId),
)
Go
Create table Klinik
(
KlinikId Int Identity,
Klinikadi varchar(50),
KlinikAdresi varchar(250),
Websitesi varchar(50),
KlinikTelefonu varchar(11),
KlinikFax varchar(11),
MusteriId Int,
VeterinerId Int,
Constraint PK_Klinik_KlinikId primary key (KlinikId),
Constraint AN_Klinik_KlinikTelefonu Unique (KlinikTelefonu),
Constraint AN_Klinik_KlinikFax Unique (KlinikFax),
Constraint FK_Klinik_MusteriId foreign key (MusteriId) references Musteri (MusteriId),
Constraint FK_Klinik_MusteriId foreign key (VeterinerId) references Veteriner(VeterinerId)
)
Go
Create table HastaHayvan
(
HastaHayvanId Int Identity,
HastaHayvanAdi varchar(50),
DoğumTarihi date,
Cinsiyet varchar(10),
Sahibi varchar(50),
Constraint PK_HastaHayvan_HastaHayvanId primary key (HastaHayvanId)
)
Go
Create table HayvanAsı
(
AsıId Int Identity,
AsıTürü varchar(25),
AsıTarihi Date,
Constraint PK_HayvanAsı_AsıId primary key (AsıId)
)
Go
Create table HayvanMuayne
(
HayvanMuayneId Int Identity,
HastaHayvanId Int,
VeterinerId Int,
AsıId Int,
TaniKoyan varchar(50),
TaniHayvan varchar(50),
Aciklama varchar(250),
MuayneTarih date
Constraint PK_HayvanMuayne_HayvanMuayneId primary key (HayvanMuayneId),
Constraint FK_HayvanMuayne_HastaHayvanId foreign key (HastaHayvanId) references HastaHayvan (HastaHayvanId),
Constraint FK_HayvanMuayne_VeterinerId foreign key (VeterinerId) references Veteriner (VeterinerId),
Constraint FK_HayvanMuayne_AsıId foreign key (AsıId) references HayvanAsı (AsıId)
)
Go
Create table Muhasebe
(
MusteriId Int,
HastaHayvanId Int,
HayvanMuayneId Int,
Tani varchar(50),
Hayvanadi varchar(50),
Musteriadi varchar(50),
Ucret money,
Tarih date,
Constraint FK_Muhasebe_MusteriId foreign key (MusteriId) references Musteri (MusteriId),
Constraint FK_Muhasebe_HastaHayvanId foreign key (HastaHayvanId) references HastaHayvan (HastaHayvanId),
Constraint FK_Muhasebe_HayvanMuayneId foreign key (HayvanMuayneId) references HayvanMuayne (HayvanMuayneId)
)
|
|
Notes.io is a web-based application for taking notes. You can take your notes and share with others people. If you like taking long notes, notes.io is designed for you. To date, over 8,000,000,000 notes created and continuing...
With notes.io;
- * You can take a note from anywhere and any device with internet connection.
- * You can share the notes in social platforms (YouTube, Facebook, Twitter, instagram etc.).
- * You can quickly share your contents without website, blog and e-mail.
- * You don't need to create any Account to share a note. As you wish you can use quick, easy and best shortened notes with sms, websites, e-mail, or messaging services (WhatsApp, iMessage, Telegram, Signal).
- * Notes.io has fabulous infrastructure design for a short link and allows you to share the note as an easy and understandable link.
Fast: Notes.io is built for speed and performance. You can take a notes quickly and browse your archive.
Easy: Notes.io doesn’t require installation. Just write and share note!
Short: Notes.io’s url just 8 character. You’ll get shorten link of your note when you want to share. (Ex: notes.io/q )
Free: Notes.io works for 12 years and has been free since the day it was started.
You immediately create your first note and start sharing with the ones you wish. If you want to contact us, you can use the following communication channels;
Email: [email protected]
Twitter: http://twitter.com/notesio
Instagram: http://instagram.com/notes.io
Facebook: http://facebook.com/notesio
Regards;
Notes.io Team
