Notes
Notes - notes.io |
--go
--use odevv3
--go
create table klinikBilgisi(
klinik_adi varchar(50),
klinik_adresi varchar(250),
klinik_webSitesi varchar(50),
klinik_telefonu varchar(15),
klinik_fax varchar(15),
Constraint AN_klinikBilgisi_klinik_telefonu Unique(klinik_telefonu)
)
go
create table veterinerBilgisi(
veterinerId int identity,
veteriner_adi varchar(50),
veteriner_soyadi varchar(250),
veteriner_gsm varchar(50),
Constraint PK_veterinerBilgisi_veterinerId Primary Key(veterinerId),
Constraint AN_veterinerBilgisi_veteriner_gsm Unique(veteriner_gsm)
)
go
create table musteri(
musteriId int identity,
musteri_adi varchar(50),
musteri_soyadi varchar(50),
musteri_telefon varchar(15),
musteri_adresi varchar(250),
Constraint PK_musteri_musteriId Primary Key(musteriId),
Constraint AN_musteri_musteri_telefon Unique(musteri_telefon)
)
go
create table hayvanTurleri(
turId int identity,
Hayvanin_türü varchar(50)
Constraint PK_hayvanTurleri_turId Primary Key(turId)
)
go
create table HastaHayvanBilgisi(
hastaHayvanId int identity,
adi varchar(50),
dogum_tarihi date,
cinsiyet varchar(50),
musteriId int,
turId int,
Constraint PK_HastaHayvanBilgisi_hastaHayvanId Primary Key(hastaHayvanId),
Constraint FK_HastaHayvanBilgisi_musteriId Foreign Key(musteriId)
References musteri(musteriId),
Constraint FK_HastaHayvanBilgisi_turId Foreign Key(turId)
References hayvanTurleri(turId)
)
go
create table TedaviTürleri(
tedavitürId int identity,
tür_adi varchar(50),
ucret money,
Constraint FK_TedaviTürleri_tedavitürId Primary Key(tedavitürId),
)
go
create table HayvanAsiKarnesi(
karneId int identity,
hastaHayvanId int,
asiTürü varchar(50),
asi_tarihi date,
tedavitürId int,
Constraint PK_HayvanAsiKarnesi_karneId Primary Key(karneId),
Constraint FK_HayvanAsiKarnesi_hastaHayvanId Foreign Key(hastaHayvanId)
References HastaHayvanBilgisi(hastaHayvanId),
Constraint FK_HayvanAsiKarnesi_tedavitürId Foreign Key(tedavitürId)
References TedaviTürleri(tedavitürId)
)
go
create table HayvanTeshisBilgileri(
teshisId int identity,
veterinerId int,
hastaHayvanId int,
aciklama varchar(300),
Tarih date,
Constraint PK_HayvanTeshisBilgileri_teshisId Primary Key(teshisId),
Constraint FK_HayvanTeshisBilgileri_veterinerId Foreign Key(veterinerId)
References veterinerBilgisi(veterinerId),
Constraint FK_HayvanTeshisBilgileri_hastaHayvanId Foreign Key(hastaHayvanId)
References HastaHayvanBilgisi(hastaHayvanId)
)
go
create table muhasebe(
Id int identity,
karneId int,
hastaHayvanId int,
musteriId int,
ucret money,
Tarih date,
Constraint PK_muhasebe_teshisId Primary Key(Id),
Constraint FK_muhasebe_karneId Foreign Key(karneId)
References HayvanAsiKarnesi(karneId),
Constraint FK_muhasebe_hastaHayvanId Foreign Key(hastaHayvanId)
References HastaHayvanBilgisi(hastaHayvanId),
Constraint FK_muhasebe_musteriId Foreign Key(musteriId)
References musteri(musteriId)
)
|
|
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
