stg_taxpayer

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
staging_id bigserial 19 √ nextval('staging.stg_taxpayer_staging_id_seq'::regclass)
source_id int8 19 √ null
nif varchar 255 √ null
taxpayer_type varchar 255 √ null
first_name varchar 255 √ null
last_name varchar 255 √ null
company_name varchar 255 √ null
birth_date date 13 √ null
phone varchar 255 √ null
email varchar 255 √ null
address varchar 255 √ null
city varchar 255 √ null
country varchar 255 √ null
status varchar 255 √ 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_taxpayer_pkey Primary key Asc staging_id

Relationships

Close relationships within degrees of separation