Table Design Patterns

Overview

Learn effective design patterns to get the most out of Memoreru's table features.

---

Basic Design Patterns

Pattern 1: Task Management

Column structure:

Use cases:

• Project task management
• To-do lists
• Work tracking

---

Pattern 2: Database (CRM / Product Management)

Column structure:

Use cases:

• Customer management
• Product catalog
• Inventory management

---

Pattern 3: Records and Logs

Column structure:

Use cases:

• Sales records
• Daily reports
• Activity logs

---

Pattern 4: Lists and Catalogs

Column structure:

Use cases:

• Reading lists
• Movie lists
• Link collections

---

Pattern 5: Linking Tables Together (Parent-Child / Related Tables)

The patterns above each work within a single table, but you can also link multiple tables together — for example, a customer table and an order table. This combines three column types: Reference (a select column whose choices come from another table), Rollup (aggregates values from a related table), and Mirror (displays a value from a related table as-is).

Column structure:

Use cases:

• Linking customer management with order management
• Parent-child management of projects and tasks
• Linking a category master with a product list

---

Choosing the Right Data Type

Common Data Types

string (Text):

• Short text
• Examples: Names, titles

rich_text (Rich Text):

• Long-form text and descriptions
• Examples: Notes, detailed explanations

select (Selection):

• Choose one option from a list
• Examples: Status, category

user_select (User Selection):

• Select a user
• Examples: Assignee, creator

date (Date):

• Date values
• Examples: Due date, completion date

number (Number):

• Numeric values
• Examples: Amount, quantity

progress (Progress):

• Progress percentage
• Examples: Completion rate, achievement rate

rating (Rating):

• Star rating
• Examples: Satisfaction, review score

---

Best Practices

1. Start with Minimal Columns

---

2. Choose Appropriate Data Types

---

3. Use Consistent Naming