Skip to content

Instantly share code, notes, and snippets.

@mhmttaa
mhmttaa / gist:3af795103b4c12c59a2867823999c49b
Last active September 20, 2020 11:57
Türkiye İlçeleri
//birbiriyle konuşan birden fazla sistem olduğu için tüm sistemlerde ilce_id ler aynı olsun istendi
/*
create table ilce (ilce_id integer not null,
plaka_kod integer not null,
ilce_adi character varying(50) not null,
version_no integer NOT NULL DEFAULT 1,
insert_user_id integer NOT NULL DEFAULT 1,
insert_dttm timestamp with time zone NOT NULL DEFAULT ('now'::text)::timestamp with time zone,
version_user_id integer NOT NULL DEFAULT 1,
/**
create table iller (
il_id integer not null,
plaka_kod integer not null,
il_ad character varying(50) not null,
version_no integer NOT NULL DEFAULT 1,
insert_user_id integer NOT NULL DEFAULT 1,
insert_dttm timestamp without time zone NOT NULL DEFAULT ('now'::text)::timestamp without time zone,