Data structure
Schema
16 tables and 7 views from the pinned source fixture. Names and relationships retain the source database’s native shape.
Tables
16 native tables.
actor4 columns · 200 rows0 foreign-key relationshipsaddress9 columns · 603 rows1 foreign-key relationshipscategory3 columns · 16 rows0 foreign-key relationshipscity4 columns · 600 rows1 foreign-key relationshipscountry3 columns · 109 rows0 foreign-key relationshipscustomer9 columns · 599 rows2 foreign-key relationshipsfilm13 columns · 1,000 rows2 foreign-key relationshipsfilm_actor3 columns · 5,462 rows2 foreign-key relationshipsfilm_category3 columns · 1,000 rows2 foreign-key relationshipsfilm_text3 columns · 1,000 rows0 foreign-key relationshipsinventory4 columns · 4,581 rows2 foreign-key relationshipslanguage3 columns · 6 rows0 foreign-key relationshipspayment7 columns · 16,044 rows3 foreign-key relationshipsrental7 columns · 16,044 rows3 foreign-key relationshipsstaff11 columns · 2 rows2 foreign-key relationshipsstore4 columns · 2 rows2 foreign-key relationships
Views
7 database views.
actor_info4 columns · 200 rowsNative view definition preservedcustomer_list9 columns · 599 rowsNative view definition preservedfilm_list8 columns · 1,000 rowsNative view definition preservednicer_but_slower_film_list8 columns · 1,000 rowsNative view definition preservedsales_by_film_category2 columns · 16 rowsNative view definition preservedsales_by_store3 columns · 2 rowsNative view definition preservedstaff_list8 columns · 2 rowsNative view definition preserved
Foreign keys