amz_books_authors

15691 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
amzbook_id int8 19 null
amz_books.id amz_books_authors_amzbook_id_43f6a1b6_fk_amz_books_id R
amzauthor_id int8 19 null
amz_authors.id amz_books_authors_amzauthor_id_74467c1f_fk_amz_authors_id R

Indexes

Constraint Name Type Sort Column(s)
amz_books_authors_pkey Primary key Asc id
amz_books_authors_amzauthor_id_74467c1f Performance Asc amzauthor_id
amz_books_authors_amzbook_id_43f6a1b6 Performance Asc amzbook_id
amz_books_authors_amzbook_id_amzauthor_id_11147b2b_uniq Must be unique Asc/Asc amzbook_id + amzauthor_id

Relationships

Close relationships within degrees of separation