stg_assujetissement

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
staging_id bigserial 19 √ nextval('staging.stg_assujetissement_staging_id_seq'::regclass)
source_id int8 19 √ null
taxpayer_nif varchar 255 null
taxpayer_type varchar 255 √ null
tax_type_code varchar 255 √ null
tax_type_label varchar 255 √ null
regime_fiscal_code varchar 255 √ null
regime_fiscal_label varchar 255 √ null
activity_code varchar 255 √ null
activity_label varchar 255 √ null
effective_start_date date 13 √ null
effective_end_date date 13 √ null
status varchar 255 √ null
exemption_flag bool 1 √ false
exemption_reason varchar 255 √ null
registration_date date 13 √ null
cancellation_date date 13 √ 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_assujetissement_pkey Primary key Asc staging_id

Relationships

Close relationships within degrees of separation