41 lines
1.8 KiB
SQL
41 lines
1.8 KiB
SQL
-- ============================================================
|
|
-- 036_ceidg_extended_data.sql
|
|
-- Rozszerzone dane z CEIDG API
|
|
-- ============================================================
|
|
|
|
-- CEIDG ID (GUID z rejestru)
|
|
ALTER TABLE companies ADD COLUMN IF NOT EXISTS ceidg_id VARCHAR(50);
|
|
|
|
-- Status z CEIDG (AKTYWNY, ZAWIESZONY, WYKREŚLONY, etc.)
|
|
ALTER TABLE companies ADD COLUMN IF NOT EXISTS ceidg_status VARCHAR(50);
|
|
|
|
-- Pełny adres korespondencyjny
|
|
ALTER TABLE companies ADD COLUMN IF NOT EXISTS correspondence_street VARCHAR(255);
|
|
ALTER TABLE companies ADD COLUMN IF NOT EXISTS correspondence_city VARCHAR(100);
|
|
ALTER TABLE companies ADD COLUMN IF NOT EXISTS correspondence_postal VARCHAR(10);
|
|
|
|
-- PKD - wszystkie kody z CEIDG (JSONB array)
|
|
ALTER TABLE companies ADD COLUMN IF NOT EXISTS ceidg_pkd_list JSONB DEFAULT '[]';
|
|
|
|
-- Obywatelstwa właściciela (JSONB array)
|
|
ALTER TABLE companies ADD COLUMN IF NOT EXISTS owner_citizenships JSONB DEFAULT '[]';
|
|
|
|
-- Surowe dane z API (dla przyszłych potrzeb)
|
|
ALTER TABLE companies ADD COLUMN IF NOT EXISTS ceidg_raw_data JSONB;
|
|
|
|
-- Timestamp ostatniego pobrania z CEIDG
|
|
ALTER TABLE companies ADD COLUMN IF NOT EXISTS ceidg_fetched_at TIMESTAMP;
|
|
|
|
-- Indeks na ceidg_id dla szybkiego wyszukiwania
|
|
CREATE INDEX IF NOT EXISTS idx_companies_ceidg_id ON companies(ceidg_id);
|
|
|
|
-- Komentarze
|
|
COMMENT ON COLUMN companies.ceidg_id IS 'GUID firmy w rejestrze CEIDG';
|
|
COMMENT ON COLUMN companies.ceidg_status IS 'Status z CEIDG: AKTYWNY, ZAWIESZONY, WYKREŚLONY';
|
|
COMMENT ON COLUMN companies.ceidg_pkd_list IS 'Wszystkie kody PKD z CEIDG jako JSON array [{kod, nazwa}]';
|
|
COMMENT ON COLUMN companies.ceidg_raw_data IS 'Pełna odpowiedź z API CEIDG (JSON)';
|
|
COMMENT ON COLUMN companies.ceidg_fetched_at IS 'Data ostatniego pobrania danych z CEIDG';
|
|
|
|
-- Grant permissions
|
|
GRANT ALL ON TABLE companies TO nordabiz_app;
|