Notes
Notes - notes.io |
GO
CREATE TABLE Departmanlar (
id int IDENTITY,
Departman nvarchar(50) NOT NULL
PRIMARY KEY (id)
);
CREATE TABLE Yetkilendirme (
id int IDENTITY,
Yetki nvarchar(15) NOT NULL
PRIMARY KEY (id)
);
CREATE TABLE Personeller(
id int IDENTITY,
PersonelAdi nvarchar(50) NOT NULL,
PersonelSoyadi nvarchar(50) NOT NULL,
PersonelMail nvarchar(50),
PersonelTelefon nvarchar(50),
Sifre nvarchar(20) NOT NULL,
YetkiID int,
DepartmanID int,
Durum bit,
PRIMARY KEY (id),
CONSTRAINT FK_Personeller_YetkiID FOREIGN KEY (YetkiID) REFERENCES Yetkilendirme(id),
CONSTRAINT FK_Personeller_DepartmanID FOREIGN KEY (DepartmanID) REFERENCES Departmanlar(id)
);
CREATE TABLE Gorevler(
id int IDENTITY,
GorevTanimi nvarchar(50) NOT NULL,
Aciklama nvarchar(MAX),
Durum bit,
TanimlayanPersonelID int,
TanimlananPersonelID int,
TanimlananDepartmanID int,
OlusturulanTarih datetime,
PlanlananSonTarih datetime,
PRIMARY KEY (id),
CONSTRAINT FK_Gorevler_TanimlayanPersonelID FOREIGN KEY (TanimlayanPersonelID) REFERENCES Personeller(id),
CONSTRAINT FK_Gorevler_TanimlananPersonelID FOREIGN KEY (TanimlananPersonelID) REFERENCES Personeller(id),
CONSTRAINT FK_Gorevler_TanimlananDepartmanID FOREIGN KEY (TanimlananDepartmanID) REFERENCES Departmanlar(id)
);
CREATE TABLE GorevGuncellemeleri(
id int IDENTITY,
Aciklama nvarchar(MAX),
GorevID int,
PersonelID int,
PRIMARY KEY (id),
CONSTRAINT FK_GorevGuncellemeleri_GorevID FOREIGN KEY (GorevID) REFERENCES Gorevler(id),
CONSTRAINT FK_GorevGuncellemeleri_PersonelID FOREIGN KEY (PersonelID) REFERENCES Personeller(id)
);
CREATE TABLE GorevYonlendirmeleri(
id int IDENTITY,
GorevID int,
YonlendirenPersonelID int,
YonlendirilenPersonelID int,
YonlendirmeTarihi datetime,
PRIMARY KEY (id),
CONSTRAINT FK_GorevYonlendirmeleri_GorevID FOREIGN KEY (GorevID) REFERENCES Gorevler(id),
CONSTRAINT FK_GorevYonlendirmeleri_YonlendirenPersonelID FOREIGN KEY (YonlendirenPersonelID) REFERENCES Personeller(id),
CONSTRAINT FK_GorevYonlendirmeleri_YonlendirilenPersonelID FOREIGN KEY (YonlendirilenPersonelID) REFERENCES Personeller(id)
);
|
|
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
