food-ordering-system-database

What problem does it solve?

Developers and admins working on the SangKorn food ordering system often lack a centralized, accurate reference for the database schema, leading to errors when building features, writing queries, or debugging data issues. This Skill provides a complete, structured overview of the entire database structure to eliminate guesswork.

Core Features & Use Cases

• Full Table Schema Documentation: Detailed field names, data types, and descriptions for all 7 core tables including shop_settings, admins, categories, menu_items, orders, and order_items.
• Relationship & Performance Reference: Clear visual relation diagrams, listed indexes, and documented triggers to help write efficient queries and understand data flow.
• Use Case: When building a custom admin feature to generate daily sales reports, use this Skill to quickly identify the correct tables, fields, and relationships needed to construct accurate aggregate queries.

Quick Start

Use the food-ordering-system-database skill to look up the field definitions and relationships for the orders and order_items tables when building a custom order reporting feature.