Notes
Notes - notes.io |
use eticugur
Create table Ulkeler
(
UlkeId int identity (1,1) NOT NULL primary key,
IkiliKod nvarchar(2) NOT NULL,
UcluKod nvarchar(3) NOT NULL
)
*******************************************************************************
use eticugur
Create table Sehirler
(
SehirId int identity (1,1) NOT NULL primary key,
SehirAdı nvarchar(30) ,
PlakaNo int ,
TelefonKodu int ,
RowNumber int
)
*******************************************************************************
use eticugur
Create table SemtMah
(
SemtMahId int identity (1,1) NOT NULL primary key,
SemtAdı varchar(30) ,
MahalleAdı varchar(30) ,
PostaKodu int ,
IlceId int
)
************************************************************************************
use eticugur
Create table Musteri
(
MusteriId int identity (1,1) NOT NULL primary key,
Adı varchar(30) ,
SoyAdı varchar(30) ,
Adres varchar(40) ,
Sehir int,
Bolge int ,
PostaKodu int,
Ulke int,
Telefon varchar(20),
KulllaniciAdi varchar(40),
Sifre varchar(20),
GrupID int,
Email varchar(20),
Faks varchar(40)
)
************************************************************************************
use eticugur
Create table KullaniciGrup
(
GrupId int identity (1,1) NOT NULL primary key,
GrupAdi varchar(20)
)
**************************************************************************************
use eticugur
Create table Siparis
(
SiparisId int identity (1,1) NOT NULL primary key,
MusteriID int ,
SiparisTarihi datetime2,
UlasmasıGerekenTarih varchar(20),
KargolanmaTarihi varchar(20),
KargoSirketi int,
Toplamtutar money,
TeslimEdilecekAd int,
TeslimEdilecekAdres int,
TeslimEdilecekSehir int,
TeslimEdilecekPostaKodu int,
TeslimEdilecekUlke int,
TeslimEdilecekBolge int
)
****************************************************************************************
use eticugur
Create table SiparisDetay
(
SiparisId int,
urunid int,
fiyat money,
adet int,
İndirimOranı int,
primary key ( SiparisId , urunid)
)
****************************************************************************************
use eticugur
Create table Urun
(
UrunId int identity (1,1) NOT NULL primary key,
Urunadı varchar(30) ,
Tedarikciİd int ,
Kategori int ,
Markaİd int,
Fiyat money ,
StokMiktari int,
SiparisMiktari int,
YeniSiprarisDerecesi varchar(20),
Satiliyormu varchar(20),
BirimBasinaAdet int,
Silindimi varchar(20) ,
Resim varchar(20),
BüyükResim varchar(20)
)
****************************************************************************************
use eticugur
Create table Markalar
(
MarkaId int identity (1,1) NOT NULL primary key,
UrunId int ,
Markaadi varchar(30) ,
MarkaİndirimOrani int ,
MarkaResmi varchar(30)
)
****************************************************************************************
use eticugur
Create table Tedarikçi
(
TedarikciId int identity (1,1) NOT NULL primary key,
Sirketadı varchar(40) ,
Yetkiligorevi varchar(30) ,
Adres varchar(40) ,
Markaİd int,
Sehir int ,
Bolge int,
PostaKodu int,
Ulke int,
Telefon varchar(11),
Faks varchar(20),
Sirketinwebsitesi varchar(20) ,
Silindimi varchar(20)
)
|
|
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
