SQL Proje
unknown
plain_text
5 months ago
2.0 kB
21
Indexable
CREATE TABLE SATICILAR( saticiID int identity(1,1) PRIMARY KEY, Ad nvarchar(25) CONSTRAINT df_saticiad DEFAULT 'Ad girilmemis', Soyad nvarchar(25) CONSTRAINT df_saticisoyad DEFAULT 'Soyad girilmemis', telNo nvarchar(10) not null CONSTRAINT ck_saticitelno CHECK(telNo like '[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'), Email nvarchar(100) CONSTRAINT df_saticiemail DEFAULT 'Email girilmemis' ) CREATE TABLE ADRESLER( adresID int identity(1,1) PRIMARY KEY, sehir nvarchar(25) not null, ilce nvarchar(25) not null, acikAdres nvarchar(250) not null ) CREATE TABLE MUSTERILER( musteriID int identity(1,1) PRIMARY KEY, Ad nvarchar(25) CONSTRAINT df_musteriad DEFAULT 'Ad girilmemis', Soyad nvarchar(25) CONSTRAINT df_musterisoyad DEFAULT 'Soyad girilmemis', telNo nvarchar(10) not null CONSTRAINT ck_musteritelno CHECK(telNo like '[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'), Email nvarchar(100) CONSTRAINT df_musteriemail DEFAULT 'Email girilmemis' ) CREATE TABLE ILANLAR( ilanID int identity(1,1) PRIMARY KEY, ilanIsim nvarchar(150) not null, adresID int CONSTRAINT fk_adresid FOREIGN KEY REFERENCES ADRESLER(adresID), emlakTipi nvarchar(50), Fiyat decimal(10,2) not null CONSTRAINT ck_ilanfiyat CHECK(Fiyat>0), ilanTarihi date CONSTRAINT df_ilantarihi DEFAULT getdate(), m2Brut smallint not null CONSTRAINT ck_m2brut CHECK(m2brut>0), m2Net smallint not null CONSTRAINT ck_m2net CHECK(m2net>0), odaSayisi varchar(5) not null CONSTRAINT ck_odasayisi CHECK(odaSayisi like '[0-9][+][0-9]'), saticiID int not null CONSTRAINT fk_saticiid FOREIGN KEY REFERENCES SATICILAR(saticiID) )
Editor is loading...
Leave a Comment