stg_registration

-1 rows


Description

Table de staging des immatriculations fiscales des contribuables. Elle représente les informations d’identification, de situation juridique, d’activité, de régime fiscal, de localisation, de contact et de gestion administrative des contribuables provenant des systèmes sources.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
staging_id bigserial 19 √ nextval('staging.stg_registration_staging_id_seq'::regclass)
taxpayer_nif varchar 255 √ null
taxpayer_name varchar 255 √ null
acronym varchar 255 √ null
legal_form varchar 255 √ null
rccm_number varchar 255 √ null
capital_amount numeric 38,2 √ null
activity_code varchar 255 √ null
activity_label varchar 255 √ null
tax_regime varchar 255 √ null
managing_service varchar 255 √ null
registration_status varchar 255 √ null
registration_date date 13 √ null
region varchar 255 √ null
city varchar 255 √ null
address varchar 255 √ null
phone varchar 255 √ null
email varchar 255 √ null
primary_bank varchar 255 √ null
primary_account_number varchar 255 √ null
accounting_firm varchar 255 √ null
director_national_id varchar 255 √ null
source_id int8 19 √ null
import_batch_id uuid 2147483647 null
import_batch.batch_id Implied Constraint R
source_system varchar 255 √ null
source_table varchar 255 √ null
row_hash varchar 255 √ null
quality_score numeric 38,2 √ null
validation_status varchar 255 √ 'PENDING'::character varying
error_message varchar 255 √ null
created_at timestamp 29,6 √ CURRENT_TIMESTAMP

Indexes

Constraint Name Type Sort Column(s)
stg_registration_pkey Primary key Asc staging_id

Relationships

Close relationships within degrees of separation