amz_author_df

2261 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
amz_author_all_books_df.author_id amz_author_all_books_df_author_id_49c7e774_fk_amz_author_df_id R
amz_author_best_titles_df.author_id amz_author_best_titl_author_id_76e11c8b_fk_amz_autho R
amz_author_media_df.author_id amz_author_media_df_author_id_6cbfb70f_fk_amz_author_df_id R
amz_author_other_authors_purchase_df.author_id amz_author_other_aut_author_id_fe6555e1_fk_amz_autho R
amz_author_other_authors_purchase_df.official_home_author_id amz_author_other_aut_official_home_author_59e9c644_fk_amz_autho R
amz_book_authors_df.author_id amz_book_authors_df_author_id_75f7a6c8_fk_amz_author_df_id R
amz_books_df_authors.dfamzauthor_id amz_books_df_authors_dfamzauthor_id_77be3632_fk_amz_autho R
amz_profile_following_df.author_id amz_profile_following_df_author_id_f428b8cb_fk_amz_author_df_id R
amz_profile_following_df.profile_id amz_profile_followin_profile_id_bd9c0d79_fk_amz_autho R
name varchar 255 null
description text 2147483647 √ null
author_id varchar 12 √ null
status bool 1 null
status_code int2 5 √ null
updated_at timestamptz 35,6 null
created_at timestamptz 35,6 null
source_id int4 10 √ null
is_valid bool 1 √ null
error_flag bool 1 √ null
simulated bool 1 √ null
validation_run_id int4 10 √ null
media_url_id int8 19 √ null
amz_media_url_df.id amz_author_df_media_url_id_7dfa4f61_fk_amz_media_url_df_id R

Indexes

Constraint Name Type Sort Column(s)
amz_author_df_pkey Primary key Asc id
amz_author_df_media_url_id_7dfa4f61 Performance Asc media_url_id

Relationships

Close relationships within degrees of separation