T-SQL

Microsoft SQL Server bazı alınarak bu döküman oluşturulmuştur.
PostgreSQL içinde benzer standartlar uygulanacaktır.

İsimlendirme

Aşağıdaki tabloda yer alan formatta isimlendirmeler yapılmaktadır.

1. Prefix nesnenin başında kullanılacağını ifade eder.
2. Suffix nesnenin sonunda kullanılacağını ifade eder.
3. Türkçe harfler kullanılmaz.
4. Türkçe kelime ve ifadeler kullanılmaz.

View Yazma

CREATE VIEW RptServiceInfo
as 
SELECT     
     srv.Id                 as Id
    ,srv.Code               as ServiceCode
    ,srv.Name               as ServiceName
    ,srv.AddresLine1            as AddresLine1
    ,city.Code              as CityCode
    ,city.Name              as CityName
    ,dist.Code              as DistrictCode
    ,dist.Name              as DistrictName
    ,rgn.Code               as RegionCode
    ,rgn.Name               as RegionName
    ,emp.FirstName+' '+emp.LastName     as ServiceResponsibleEmployee
    ,rgn.ResponsiblePersonForServices_Id    as ServiceResponsibleEmployee_Id
    ,srv.City_Id
    ,srv.District_Id
    ,srv.Locality
    ,case 
        when srv.WorkPhone is null then srv.MobilePhone 
        else srv.WorkPhone 
     end                    as PrimaryPhone
    ,srv.FoundedDate        
    ,srv.ClosureDate
    ,srv.ContractDate
    ,srv.IsActive
    ,case when srv.IsActive = 1 then 'Aktif' else 'Pasif' end StatusText
    ,srv.Region_Id
FROM
    Service                 as srv 
    left outer join District        as dist on srv.District_Id = dist.Id
    left outer join City            as city on srv.City_Id = city.Id
    left outer join OrganizationRegion  as rgn  on srv.Region_Id = rgn.Id
    left outer join Employee        as emp  on rgn.ResponsiblePersonForServices_Id = emp.Id
    left outer join [User]          as usr  on emp.User_Id = usr.Id
GO

Procedure ve Function Yazma

–hazırlanıyor