Notes
Notes - notes.io |
GO
USE AKSS
GO
CREATE TABLE ARACLAR
(
AracNo INT IDENTITY PRIMARY KEY,
Plaka NCHAR(10),
Marka NVARCHAR(50),
Model NVARCHAR(50)
)
GO
CREATE TABLE SIGORTA
(
TSigNo INT IDENTITY PRIMARY KEY,
FirmaAdi NVARCHAR(50)
)
GO
CREATE TABLE SIGORTATUR
(
SigTurNo INT IDENTITY PRIMARY KEY,
Aciklama NVARCHAR(500)
)
GO
CREATE TABLE TAHSILATTURU
(
TahsilatNo INT IDENTITY PRIMARY KEY,
Aciklama NVARCHAR(500)
)
GO
CREATE TABLE BANKALAR
(
BankaNo INT IDENTITY PRIMARY KEY,
Aciklama NVARCHAR(500)
)
GO
CREATE TABLE GIDERTIPI
(
GTipNo INT IDENTITY PRIMARY KEY,
Aciklama NVARCHAR(500)
)
GO
CREATE TABLE MUSTERITIPI
(
MTipNo INT IDENTITY PRIMARY KEY,
Aciklama NVARCHAR(500)
)
GO
CREATE TABLE MUSTERILER
(
MustNo INT IDENTITY PRIMARY KEY,
Unvan NVARCHAR(50),
vDairesi NVARCHAR(50),
VHNo INT,
YetkiliAdi NVARCHAR(50),
YetkiliSoyadi NVARCHAR(50),
Adres NVARCHAR(500),
Tel NCHAR(11),
MustTip INT FOREIGN KEY REFERENCES MUSTERITIPI(MTipNo)
)
GO
CREATE TABLE KASA
(
IslemNo INT IDENTITY PRIMARY KEY,
Tarih DATETIME,
GTipiNo INT FOREIGN KEY REFERENCES GIDERTIPI(GTipNo),
MusNo INT FOREIGN KEY REFERENCES MUSTERILER(MustNo)
)
GO
CREATE TABLE TARIFE
(
TarifeNo INT IDENTITY PRIMARY KEY,
AracNo INT FOREIGN KEY REFERENCES ARACLAR(AracNo),
Fiyat DECIMAL(18,2),
BasTarih DATETIME,
BitTarih DATETIME
)
GO
CREATE TABLE ODEMELER
(
OdemeNo INT IDENTITY PRIMARY KEY,
TahsilatNo INT FOREIGN KEY REFERENCES TAHSILATTURU(TahsilatNo),
CekSenetNo INT,
Vade NVARCHAR(50),
BankaNo INT FOREIGN KEY REFERENCES BANKALAR(BankaNo),
Tutar DECIMAL(18,2)
)
GO
CREATE TABLE ARACSIGORTA
(
AracSigNo INT IDENTITY PRIMARY KEY,
AracNo INT FOREIGN KEY REFERENCES ARACLAR(AracNo),
TSigNo INT FOREIGN KEY REFERENCES SIGORTA(TSigNo),
SigTurNo INT FOREIGN KEY REFERENCES SIGORTATUR(SigTurNo),
BasTarih DATETIME,
BitTarih DATETIME
)
GO
CREATE TABLE SOZLESME
(
SozlesmeNo INT IDENTITY PRIMARY KEY,
MusNo INT FOREIGN KEY REFERENCES MUSTERILER(MustNo),
AracNo INT FOREIGN KEY REFERENCES ARACLAR(AracNo),
BasTarih DATETIME,
BitTarih DATETIME,
GFiyat DECIMAL(18,2),
OdemeNo INT FOREIGN KEY REFERENCES ODEMELER(OdemeNo)
)
GO
CREATE TABLE PUANTAJ
(
PuanTajNo INT IDENTITY PRIMARY KEY,
MusNo INT FOREIGN KEY REFERENCES MUSTERILER(MustNo),
Tarih DATETIME,
GirisSaati DATETIME,
CikisSaati DATETIME
)
GO
|
|
Notes is a web-based application for online 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 14 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
