stg_company

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
staging_id bigserial 19 √ nextval('staging.stg_company_staging_id_seq'::regclass)
source_id int8 19 √ null
company_code varchar 255 √ null
company_name varchar 255 √ null
registration_number varchar 255 √ null
nif varchar 255 √ null
activity_code varchar 255 √ null
legal_form varchar 255 √ null
creation_date date 13 √ null
address varchar 255 √ null
city varchar 255 √ null
country 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_company_pkey Primary key Asc staging_id

Relationships

Close relationships within degrees of separation