--- tags: Cycle 2, Cycle 2 Team C --- # Cycle 2 Design Priorities ## 2022-06-21 discussion Cycle 2 priorities - Data Explorer Layout (show existing work to Pavish) - Record Page - Record Summary - Parameterized Queries - in Data Explorer - Embedded Queries - in Record Page - Schema Navigation - covers navigating to and between Tables, Queries, Parametrized Queries, Records - Column Migration - Table Inspector - includes data type configuration - Mathesar Homepage - Schema Homepage - Table Import ## High Priority ### Adding Tables and Setting Relationships Design tasks related to adding new tables to a schema via import or by extracting columns from existing tables. This includes the setting of table links during the data modeling process. ### Table Record Creation Design tasks related to optimizing record creation user experience and interactions. This includes exploration of interfaces that are more suitable for data entry tasks as well as improved access to the functionality. It also includes the retrieval of records from linked tables. ### Setting Table and Column Constraints Design tasks related to setting and modifying table and column constraints. This includes scenarios for dealing with constraints while creating records and resolving conflicts when applying constraints to non-empty tables. ### New Query Starting Points Design tasks related to the various contexts from which a query can be started. This includes any global updates to navigation that might be required. ## Medium Priority ### Schema Navigation Design tasks related to the interactions needed for users to navigate across schema objects based on relationships between them. ### Virtual Columns and Dynamic Defaults Design tasks related to improving the user experience of linked records and data entry by providing ancillary features to these flows. This includes the evaluation of multiple design alternatives. ## Low Priority ### Guiding Users from Query Building to Saving Views Design tasks related to view creation and the various interactions that are associated with views throughout the product like saving queries as views, saving tables as views, understanding view sources and others. ### Schema Creation and Adding Queries and Views Design tasks related to creating new schemas or updating existing schema details such as names of schema objects. This includes the creation of other objects such as queries or views. ## To be defined/Notes - Table summmary (Expression-based) - Page of single record with all related tables/views (Record Page) - How it is accessed - From table row - - Reuse record selector - Can we access a view row (potentially) - Navigating to other records - Persist filters when retrieving records (data explorer configuration) - No clear need for this feature - UI with competing components, better to consolidate all in one - Better specify what the overlap might be - How data explorer is accessed - Consider accessing data explorer from row page (page showing a single view's row)