Database: 🎅🏻 Santa’s Logistics

🧒 Children

Fields

• Name (Text)

• Zip Code (Text)

• City (Text)

• Country (Text)

• Status (Single select)

• Notes (Text)

• Last Updated (Last modified)

• GPS Location (Text)

• Street + nr (Text)

• 🪄💫Wish Fulfilments (Link to table)

• ✉️ Letters (Link to table)

• 🪄 Wishlist (Link to table)

• All gifts match status (Rollup)

• Wishlist completion ratio (Formula)

• All gifts match wishlist (Rollup)

• Email (Email)

• Password (Password)

• Address (Formula)

• Count wish fulfilments (Count)

• Count letters (Count)

• Last Updated (format) (Formula)

• All gifts match status symbol (Formula)

• All gifts match wishlist symbol (Formula)

• ID (Formula)

Views

• All children (grid)

• All children grouped by country (grid)

• Children with letters (grid)

• Children without wishlist (grid)

• Children without 100% wishlist fulfilment (grid)

• Children where not all gifts match status (grid)

• All children stacked by status (kanban)

✉️ Letters

Fields

• Name (Formula)

• Child (Link to table)

• Message (Long text)

• Created on (Created on)

• Follow up (Single select)

• Reply (Long text)

• Follow up completed (Boolean)

• Created on (format) (Formula)

• Show reply (Formula)

• Child name (Rollup)

Views

• All letters (grid)

• All letters grouped by child (grid)

• All letters that are not followed up (grid)

🎁 Gifts

Fields

• Name (Text)

• Description (Text)

• Picture (File)

• 🪄💫 Assigned to (Link to table)

• Appropriate for (Single select)

• 🧒 On wishlist (Link to table)

• Count assignments (Count)

• Count wishlists (Count)

• Assigned to child (Formula)

• Production time (Number)

Views

• All gifts (grid)

• All gifts grouped by behavioural status (grid)

• All gifts sorted by production time (grid)

• All gifts sorted by number of assignments (grid)

• All gifts sorted by number of wishlists (grid)

• Gallery: all gifts (gallery)

• All gifts stacked by behavioural status (kanban)

🪄💫Wish Fulfilments

Fields

• Name (Formula)

• 🧒 Child (Link to table)

• 🎁 Gift (Link to table)

• 🧝 Assigned elf (Link to table)

• Sleigh Logistics (Link to table)

• Ready for delivery (Formula)

• Child status match (Formula)

• Scheduled (Date)

• Status (Single select)

• Issue description (Long text)

• Estimated completion time (Rollup)

• Actual completion time (Number)

• Child wishlist (Lookup)

• Is on wishlist (Formula)

• Issue category (Single select)

• 🏭 Store at (Link to table)

• Child position (Rollup)

• Child address (Rollup)

• Child ID (Rollup)

• Gift appropriate for (Formula)

• Gift name (Rollup)

• Child country (Rollup)

• Tomorrow (Formula)

• Today (Formula)

• Child name (Rollup)

• Elf name (Rollup)

• Store name (Rollup)

Views

• All wish fulfilments sorted by scheduled date (grid)

• All wish fulfilments grouped by scheduled date (grid)

• All wish fulfilments sorted by gift name (grid)

• All wish fulfilments grouped by gift (grid)

• All wish fulfilments grouped by child (grid)

• All wish fulfilments grouped by elf (grid)

• All wish fulfilments grouped by store (grid)

• All wish fulfilments grouped by status (grid)

• Wish fulfilments scheduled for today (grid)

• Wish fulfilments scheduled for tomorrow (grid)

• Completed wish fulfilments (grid)

• Completed wish fulfilments scheduled for today (grid)

• Open wish fulfilments (grid)

• Open wish fulfilments scheduled for today (grid)

• Wish fulfilments with incomplete data (grid)

• Wish fulfilments with issues (grid)

• All wish fulfilments stacked by status (kanban)

• Calendar: All wish fulfilments (calendar)

🧝 Elves

Fields

• Name (Text)

• 🪄💫Wish Fulfilments (Link to table)

• Total estimated open workload (Formula)

• Total actual hours (Rollup)

• Estimated workload for today (Formula)

• Open estimated workload for today (Formula)

• Completed actual workload for today (Formula)

• Email (Email)

• Password (Password)

• Total assigned gifts (Count)

• Total open gifts (Formula)

• Total open gifts for today (Formula)

• Total gifts for today (Formula)

• Total estimated hours (Rollup)

• Total completed gifts for today (Formula)

• Total completed gifts (Formula)

• Open estimated workload for tomorrow (Formula)

Views

• All elves (grid)

• Elves without open workload today (grid)

• Elves without workload for tomorrow (grid)

• All elves: workshop display summary data (grid)

🏭 Warehouses

Fields

• Name (Text)

• Capacity (Number)

• 🪄💫Wish Fulfilments (Link to table)

• Expected storage (Count)

• Current storage (Formula)

• Expected capacity utilization (Formula)

• Current capacity utilization (Formula)

Views

• All warehouses (grid)

• Warehouses with expected capacity > 100% (grid)

• Warehouses with expected capacity < 50% (grid)

🦌 Reindeers

Fields

• Name (Text)

• Age (Number)

• Speciality (Text)

• Job (Single select)

• Fun fact (Text)

• 🛷 Sleigh Routes (Link to table)

• Fitness level (Single select)

• Email (Email)

• Password (Password)

Views

• All reindeers (grid)

• All reindeers grouped by job (grid)

• All reindeers grouped by fitness level (grid)

• All reindeers stacked by fitness level (kanban)

🛷 Sleigh Routes

Fields

• Name (Text)

• Date (Date)

• 🎁🎄Joy Deliveries (Link to table)

• Count deliveries (Count)

• 🦌 Reindeers (Link to table)

• Date (format) (Formula)

• Count delivered (Formula)

• Count cancelled (Formula)

• Count scheduled (Formula)

• Waypoints (Formula)

• Markers (Formula)

• Delivery percentage (Formula)

Views

• All sleigh routes (grid)

• Sleigh routes with cancellations (grid)

• Sleigh routes with 100% completion (grid)

🎁🎄Joy Deliveries

Fields

• Name (Formula)

• 🪄💫 Wish Fulfilment (Link to table)

• Route (Link to table)

• Status (Single select)

• Waypoint (Formula)

• Marker (Formula)

• Address (Rollup)

• Delivery time (Rollup)

• Country (Rollup)

• Route name (Rollup)

Views

• All joy deliveries (grid)

• All joy deliveries grouped by country (grid)

• Joys without route (grid)

• All joy deliveries grouped by route (grid)

• All joy deliveries grouped by route and country (grid)

• Joys to be delivered (grid)

• Joys that are cancelled (grid)

• Joys that are delivered (grid)

Application: Child app

Login

Data sources

Actions (event)

• open_page (after_login)

Home

Data sources

• Child details

• Get child letters

• Get child wishlist

• All gifts

Actions (event)

• logout (click)

• create_row (submit)

• update_row (submit)

• notification (submit)

• refresh_data_source (submit)

• refresh_data_source (submit)