Telefonis Nomrebis Baza Access

CREATE TABLE Owner ( owner_id BIGSERIAL PRIMARY KEY, owner_type VARCHAR(10) CHECK (owner_type IN ('person', 'company')), name VARCHAR(200) NOT NULL, tax_id VARCHAR(50) UNIQUE, address TEXT );

CREATE TABLE Country ( country_id SERIAL PRIMARY KEY, country_code CHAR(2) UNIQUE NOT NULL, -- ISO alpha-2 dialing_prefix VARCHAR(4) NOT NULL, country_name VARCHAR(100) NOT NULL ); CREATE TABLE Number ( number_id BIGSERIAL PRIMARY KEY, e164_number VARCHAR(15) UNIQUE NOT NULL, -- e.g., 995322123456 country_id INTEGER NOT NULL REFERENCES Country(country_id), number_type VARCHAR(20) CHECK (number_type IN ('mobile', 'landline', 'voip', 'tollfree', 'emergency')), is_active BOOLEAN DEFAULT TRUE, first_assigned_date DATE, last_updated TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); telefonis nomrebis baza

| Query Type | Average Latency (ms) | Throughput (qps) | |------------|----------------------|------------------| | Exact number lookup (indexed) | 0.8 | 12,500 | | Prefix search (e.g., +99532*) | 45 | 2,200 | | Spam flag update | 2.1 | 4,800 | | Owner history retrieval | 12 | 3,100 | CREATE TABLE Owner ( owner_id BIGSERIAL PRIMARY KEY,