Notes
Notes - notes.io |
go
Use UniversiteDb
go
create Table UniversiteTuru
(
Id int identity primary key,
Adı varchar(50),
)
go
Create Table Universite
(
Id int identity Primary key,
TurId int,
Ad varchar(50)Unique,
Adresi varchar(50),
UTelNo varchar(11) ,
UFaxNo varchar(11),
WebSitesi varchar(50),
constraint CK_UTelNo_IdentityNumber check (UTelNo like'[1-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'),
constraint CK_UFaxNo_IdentityNumber check (UFaxNo like'[1-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'),
Constraint FK_Feym_TurId
Foreign Key(TurId) References UniversiteTuru(Id)
)
Go
Create Table Feym
(
Id int identity Primary key,
Adı Varchar(50),
FTelNo Varchar(11),
FFaxNo varchar (12),
WebSitesi Varchar(50),
UniversiteId int,
constraint CK_FTelNo_IdentityNumber check (FTelNo like'[1-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'),
constraint CK_FFaxNo_IdentityNumber check (FFaxNo like'[1-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'),
Constraint FK_Feym_UniversiteId
Foreign Key(UniversiteId) References Universite(Id)
)
go
Create Table Bolum
(
Id Int Identity Primary Key,
Ad Varchar(50),
BTelNo varchar(11),
FeymId Int,
constraint CK_BTelNo_IdentityNumber check (BTelNo like'[1-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'),
Constraint FK_Bolum_FeymId
Foreign Key(FeymId) References Feym(Id)
)
go
Create Table Iller
(
Id int identity Primary key,
Ad varchar(50),
)
go
Create Table Ogrenci
(
Id int Identity Primary Key,
Ad Varchar(50),
Soyad Varchar(50),
OgrenciTc varchar(11),
Cinsiyet varchar(5),
DogumYeri varchar(50),
Dogumtarihi datetime,
Adres varchar(50),
CepTel varchar(11),
EvTel varchar(11),
Eposta varchar(50),
KayıtTarihi datetime,
MezuniyetTarihi Datetime Default GETDATE(),
ÇalışmaDurumu Varchar(50),
IllerId int,
UniversiteId Int,
FeymId Int,
BolumId Int,
Constraint AN_Ogrenci_Eposta
Unique(Eposta),
constraint CK_OgrenciTc_IdentityNumber check (OgrenciTc like'[1-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'),
constraint CK_CepTel_IdentityNumber check (CepTel like'[1-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'),
constraint CK_EvTel_IdentityNumber check (EvTel like'[1-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'),
Constraint FK_Ogrenci_UniversiteId Foreign Key(UniversiteId)
References Universite(Id),
Constraint FK_Ogrenci_FeymId Foreign Key(FeymId)
References Feym(Id),
Constraint FK_Ogrenci_BolumId Foreign Key(BolumId)
References Bolum(Id),
Constraint FK_Ogrenci_illerID Foreign Key(IllerId)
References Iller(Id)
)
go
Create Table Kulup
(
Id int identity Primary key,
Ad Varchar(50),
Tur varchar(20),
Başkan varchar(50),
Ogranciıd int,
Feymıd int,
BolumId int,
Universiteıd int,
BaşkanY varchar(50),
Sayman varchar(50),
Danışman varchar(50),
Constraint FK_Kulup_FeymId Foreign Key(FeymId)
References Feym(Id),
Constraint FK_Kulup_BolumId Foreign Key(BolumId)
References Bolum(Id),
Constraint FK_Kulup_Universiteıd Foreign Key(Universiteıd)
References Universite(Id),
)
go
Create Table KulupUye
(
Id int identity Primary key,
UyeTuru varchar(20),
KyaıtTarihi Datetime Default GETDATE(),
Kulupıd int,
Constraint FK_KulupUye_Kulupıd Foreign Key(Kulupıd)
References Kulup(Id),
)
Create Table OgretimG
(
Id int identity Primary key,
Ad Varchar(50),
Soyad Varchar(50),
Eposta varchar(50),
Unvan varchar(50),
Universiteıd int,
BolumId int,
FeymId int,
BBUniversite varchar(50),
BBFakulte varchar(50),
BBBölüm varchar(50),
Constraint FK_OgretimG_FeymId Foreign Key(FeymId)
References Feym(Id),
Constraint FK_OgretimG_BolumId Foreign Key(BolumId)
References Bolum(Id),
Constraint FK_OgretimG_Universiteıd Foreign Key(Universiteıd)
References Universite(Id),
)
Go
Create Table KulupFaliyet
(
Id int identity Primary key,
FaliyetAd varchar(50),
FaliyetTarihi varchar(50),
FDüzenleyenKulup varchar(50),
FaliyetTuru varchar(50),
Kulupıd int,
Constraint FK_KulupFaliyet_Universiteıd Foreign Key(Kulupıd)
References Kulup(Id),
)
go
|
|
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
