Advanced Guide

Who this is for

For users who can already complete regular table creation and now need to handle complex scenarios such as importing existing SQL, AI collaboration, schema change control, partitioning/sharding strategy, foreign keys and ER diagrams, and ORM generation.

What this solves

Advanced Guide helps you move from "can generate SQL" to "stable reuse, collaborative review, controlled change risk, and downstream project integration".

Prerequisites

• You have completed the regular table creation flow in Basic Guide.
• You know how to view DDL, DCL, ORM, and View/Routine output in the page.

Recommended reading order

1. Import and Parse SQL
2. AI-Assisted Table Design Workflow
3. Review and Explain SQL
4. Partitioning and Sharding Configuration
5. Change Diff and Rollback
6. Foreign Key Configuration and ER Diagram
7. ORM Model Generation
8. View and Routine Configuration
9. Schema Lint
10. Mock Data and Logical Enums
11. Table Blueprint Templates

Boundary vs Basic Guide

• Basic Guide focuses on how to complete standard configuration and output for one table.
• Advanced Guide focuses on improving quality, controlling risk, increasing collaboration efficiency, and integrating with downstream development in complex scenarios.