SQL Proje

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)
)