-- countries tablosu
CREATE TABLE countries (
id INT IDENTITY(1,1) PRIMARY KEY,
phone_code INT NOT NULL,
name NVARCHAR(255) NOT NULL,
code NVARCHAR(5) NOT NULL,
continent NVARCHAR(25) NOT NULL
);

-- provinces tablosu
CREATE TABLE provinces (
id INT IDENTITY(1,1) PRIMARY KEY,
country_id INT NOT NULL,
name NVARCHAR(255) NOT NULL,
phone_code INT NOT NULL,
province_code NVARCHAR(3) NOT NULL,
FOREIGN KEY (country_id) REFERENCES countries(id)
);

-- districts tablosu
CREATE TABLE districts (
id INT IDENTITY(1,1) PRIMARY KEY,
province_id INT NOT NULL,
name NVARCHAR(255) NOT NULL,
district_code NVARCHAR(3) NOT NULL,
FOREIGN KEY (province_id) REFERENCES provinces(id)
);

-- tax_offices tablosu
CREATE TABLE tax_offices (
id INT IDENTITY(1,1) PRIMARY KEY,
province_id INT NOT NULL,
name NVARCHAR(255) NOT NULL,
office_code NVARCHAR(255) NOT NULL,
FOREIGN KEY (province_id) REFERENCES provinces(id)
);

Bu kodlar işinizi çözüyor sanırım.