@@ -1,9 +1,26 @@
 node_modules/
+*/node_modules/
+*/*/node_modules/
 dist/
+*/dist/
+*/*/dist/
+dist-*/
+*/dist-*/
+*/*/dist-*/
 .env
 .env.local
 *.log
 .DS_Store
+*/.DS_Store
+*/*/.DS_Store
 .a2api/
 coverage/
 apps/chat-demo/data/*.jsonl
+.idea
+/.idea
+*/.idea
+*/*/.idea
+/apps/admin/dist-client
+/apps/admin/dist-server
+/apps/chat-demo/dist-client
+/apps/chat-demo/dist-server
@@ -105,7 +105,7 @@ export APIJSON_BASE_URL=http://localhost:8080
 # or edit .env
 ```
 
-Ensure the Demo schema (User / Moment / Comment) is available on that server.
+Ensure the Demo schema is available on that server. Business layout tables are in `apps/chat-demo/sql/layout_demo_tables.sql` (User / Moment / Comment plus Employee, Activity, Message, News, Notice, Blog, Article, Video, Music, Product, …). After import, reload Access/Request.
 
 **Writes (POST/PUT/DELETE):** the Demo often requires a logged-in session (`@role` OWNER/LOGIN). The MVP still generates the request and shows the HITL Approve/Reject UI; if APIJSON returns "not logged in", log in via your Demo/APIAuto session cookies or relax Access for local testing. **Reads** work out of the box against the public Demo data.
 
 
@@ -93,7 +93,7 @@ export APIJSON_BASE_URL=http://localhost:8080
 # 或编辑 .env
 ```
 
-请确保 Demo 库表（User / Moment / Comment）在该服务上可用。
+请确保 Demo 库表在该服务上可用。业务表示例见 `apps/chat-demo/sql/layout_demo_tables.sql`（User / Moment / Comment 以及员工、活动、聊天、新闻、资讯、博客、文章、视频、音乐、商品等），导入后需重载 Access/Request。
 
 **写操作（POST/PUT/DELETE）：** Demo 常要求已登录会话（`@role` OWNER/LOGIN）。MVP 仍会生成请求并展示 HITL 批准/拒绝界面；若 APIJSON 返回未登录，请通过 Demo/APIAuto 会话 Cookie 登录，或在本地放宽 Access。**读操作**可直接使用公开 Demo 数据。
 
 
@@ -278,6 +278,14 @@ const KNOWN_NUMBER_METRICS: Record<string, string[]> = {
   Moment: ["commentCount"],
   User: [],
   Comment: [],
+  Employee: ["salary"],
+  Activity: ["signupCount"],
+  News: ["viewCount"],
+  Video: ["duration", "playCount"],
+  Music: ["duration", "playCount"],
+  Product: ["price", "stock", "sales"],
+  Cart: ["price", "qty"],
+  ShopOrder: ["total"],
 };
 
 const KNOWN_ARRAY_METRICS: Record<string, string[]> = {
 
@@ -22,13 +22,24 @@ export type FkJoinSpec = {
   onField?: string;
 };
 
+const USER_FK: FkEdge = { column: "userId", target: "User" };
+
 /** Primary table → outgoing FK edges. */
 export const TABLE_FK_EDGES: Record<string, FkEdge[]> = {
-  Moment: [{ column: "userId", target: "User" }],
-  Comment: [
-    { column: "userId", target: "User" },
-    { column: "momentId", target: "Moment" },
-  ],
+  Moment: [USER_FK],
+  Comment: [USER_FK, { column: "momentId", target: "Moment" }],
+  Employee: [USER_FK],
+  Activity: [USER_FK],
+  Message: [USER_FK, { column: "toUserId", target: "User" }],
+  News: [USER_FK],
+  Notice: [USER_FK],
+  Blog: [USER_FK],
+  Article: [USER_FK],
+  Video: [USER_FK],
+  Music: [USER_FK],
+  Product: [USER_FK],
+  Cart: [USER_FK, { column: "productId", target: "Product" }],
+  ShopOrder: [USER_FK],
 };
 
 /**
@@ -40,6 +51,18 @@ export const DEFAULT_FK_COLUMNS: Record<string, string[]> = {
   User: ["name", "tag", "head", "pictureList"],
   Moment: ["content"],
   Comment: ["content"],
+  Employee: ["name", "dept", "head"],
+  Activity: ["title", "cover"],
+  Message: ["content", "author", "head"],
+  News: ["title", "cover"],
+  Notice: ["title", "cover"],
+  Blog: ["title", "cover"],
+  Article: ["title", "cover"],
+  Video: ["title", "cover"],
+  Music: ["title", "cover", "artist"],
+  Product: ["name", "cover", "price"],
+  Cart: ["title", "cover", "price"],
+  ShopOrder: ["consignee", "total", "status"],
 };
 
 /** Extra columns offered in the multi-select UI (beyond the default text field). */
@@ -63,6 +86,18 @@ export const FK_OPTIONAL_COLUMNS: Record<string, string[]> = {
     "pictureList",
   ],
   Comment: ["id", "content", "userId", "momentId", "toId", "date"],
+  Employee: ["id", "name", "dept", "title", "sex", "salary", "status", "head"],
+  Activity: ["id", "title", "cover", "status", "startTime", "endTime"],
+  Message: ["id", "content", "author", "head", "toUserId", "date"],
+  News: ["id", "title", "cover", "source", "author", "date"],
+  Notice: ["id", "title", "cover", "status", "date"],
+  Blog: ["id", "title", "cover", "author", "date"],
+  Article: ["id", "title", "cover", "author", "date"],
+  Video: ["id", "title", "cover", "author", "videoUrl", "playCount"],
+  Music: ["id", "title", "cover", "artist", "audioUrl", "playCount"],
+  Product: ["id", "name", "cover", "price", "stock", "status"],
+  Cart: ["id", "title", "cover", "price", "qty", "productId"],
+  ShopOrder: ["id", "consignee", "phone", "address", "total", "status"],
 };
 
 export function defaultFkColumns(table: string): string[] {
 
@@ -26,6 +26,26 @@ export const en = {
     msgComments: "List comments",
     msgNewMoment: "Create moment",
     msgAddComment: "Create comment",
+    employees: "Employees",
+    campaigns: "Campaigns",
+    messages: "Messages",
+    news: "News",
+    notices: "Notices",
+    blogs: "Blogs",
+    articles: "Articles",
+    videos: "Videos",
+    music: "Music",
+    products: "Products",
+    msgEmployees: "List employees",
+    msgCampaigns: "List campaigns",
+    msgMessages: "List chat messages",
+    msgNews: "List news",
+    msgNotices: "List notices",
+    msgBlogs: "List blogs",
+    msgArticles: "List articles",
+    msgVideos: "List videos",
+    msgMusic: "List music",
+    msgProducts: "List products",
     placeholder: "e.g. List the latest 10 moments",
     send: "Send",
   },
@@ -206,6 +226,71 @@ export const en = {
     analyzeTitle: "AI analyzes this page and generates a report",
     pageZeroBased: "Page (0-based)",
     rowsPerPage: "Rows per page",
+    selectLayout: "Page layout",
+  },
+  layout: {
+    data: "Data",
+    campaign: "Campaigns",
+    social: "Social",
+    chat: "Chat",
+    news: "News",
+    info: "Info",
+    blog: "Blog",
+    article: "Articles",
+    video: "Video",
+    music: "Music",
+    commerce: "Shop",
+    cart: "Cart",
+    order: "Checkout",
+    addToCart: "Add to cart",
+    buyNow: "Buy now",
+    addedToCart: "Added to cart",
+    cartEmpty: "Cart is empty",
+    checkout: "Checkout",
+    placeOrder: "Place order",
+    orderPlaced: "Order placed",
+    consignee: "Name",
+    phone: "Phone",
+    address: "Address",
+    remark: "Remark",
+    stock: "Stock",
+    play: "Play",
+    pickTrack: "Choose a track",
+    noMedia: "No media URL on this row",
+    editFields: "Edit fields",
+    hideFields: "Hide fields",
+    subscribe: "Subscribe",
+    like: "Like",
+    dislike: "Dislike",
+    share: "Share",
+    save: "Save",
+    related: "Up next",
+    comments: "Comments",
+    views: "views",
+    plays: "plays",
+    sold: "sold",
+    lyrics: "Lyrics",
+    queue: "Queue",
+    nowPlaying: "Now playing",
+    follow: "Follow",
+    message: "Message",
+    toc: "Contents",
+    authorCard: "Author",
+    articles: "Articles",
+    fans: "Fans",
+    reads: "Reads",
+    signup: "Sign up",
+    hotNews: "Headlines",
+    relatedNews: "Related",
+    description: "Description",
+    specs: "Details",
+    qty: "Qty",
+    buyBox: "Buy",
+    inStock: "In stock",
+    outOfStock: "Out of stock",
+    send: "Send",
+    composerHint: "Message…",
+    moreFrom: "More from this list",
   },
   result: {
     noMatching: "No matching records",
 
@@ -28,6 +28,26 @@ export const zhCN: TranslationSchema = {
     msgComments: "列出评论",
     msgNewMoment: "创建动态",
     msgAddComment: "创建评论",
+    employees: "员工",
+    campaigns: "活动",
+    messages: "聊天",
+    news: "新闻",
+    notices: "资讯",
+    blogs: "博客",
+    articles: "文章",
+    videos: "视频",
+    music: "音乐",
+    products: "商品",
+    msgEmployees: "列出员工",
+    msgCampaigns: "列出运营活动",
+    msgMessages: "列出聊天消息",
+    msgNews: "列出新闻",
+    msgNotices: "列出资讯",
+    msgBlogs: "列出博客",
+    msgArticles: "列出文章",
+    msgVideos: "列出视频",
+    msgMusic: "列出音乐",
+    msgProducts: "列出商品",
     placeholder: "例如：列出最新 10 条动态",
     send: "发送",
   },
@@ -205,6 +225,71 @@ export const zhCN: TranslationSchema = {
     analyzeTitle: "用 AI 分析本页数据并生成报告",
     pageZeroBased: "页码（从 0 起）",
     rowsPerPage: "每页行数",
+    selectLayout: "页面布局",
+  },
+  layout: {
+    data: "数据管理",
+    campaign: "运营活动",
+    social: "社交",
+    chat: "聊天",
+    news: "新闻",
+    info: "资讯",
+    blog: "博客",
+    article: "文章",
+    video: "视频",
+    music: "音乐",
+    commerce: "电商",
+    cart: "购物车",
+    order: "下单页",
+    addToCart: "加入购物车",
+    buyNow: "立即购买",
+    addedToCart: "已加入购物车",
+    cartEmpty: "购物车是空的",
+    checkout: "去结算",
+    placeOrder: "提交订单",
+    orderPlaced: "下单成功",
+    consignee: "收货人",
+    phone: "手机号",
+    address: "地址",
+    remark: "备注",
+    stock: "库存",
+    play: "播放",
+    pickTrack: "选择曲目",
+    noMedia: "该行没有可播放的媒体地址",
+    editFields: "编辑字段",
+    hideFields: "收起字段",
+    subscribe: "订阅",
+    like: "点赞",
+    dislike: "不喜欢",
+    share: "分享",
+    save: "保存",
+    related: "接下来播放",
+    comments: "评论",
+    views: "次观看",
+    plays: "次播放",
+    sold: "已售",
+    lyrics: "歌词",
+    queue: "播放队列",
+    nowPlaying: "正在播放",
+    follow: "关注",
+    message: "私信",
+    toc: "目录",
+    authorCard: "作者",
+    articles: "文章",
+    fans: "粉丝",
+    reads: "阅读",
+    signup: "立即报名",
+    hotNews: "要闻",
+    relatedNews: "相关资讯",
+    description: "商品介绍",
+    specs: "规格参数",
+    qty: "数量",
+    buyBox: "购买",
+    inStock: "有货",
+    outOfStock: "缺货",
+    send: "发送",
+    composerHint: "发消息…",
+    moreFrom: "本页其它内容",
   },
   result: {
     noMatching: "无匹配记录",
 
@@ -92,6 +92,16 @@
             <button type="button" data-i18n="chat.comments" data-i18n-msg="chat.msgComments" data-msg="List comments">Comments</button>
             <button type="button" data-i18n="chat.newMoment" data-i18n-msg="chat.msgNewMoment" data-msg="Create moment">New moment</button>
             <button type="button" data-i18n="chat.addComment" data-i18n-msg="chat.msgAddComment" data-msg="Create comment">Add Comment</button>
+            <button type="button" data-i18n="chat.employees" data-i18n-msg="chat.msgEmployees" data-msg="List employees">Employees</button>
+            <button type="button" data-i18n="chat.campaigns" data-i18n-msg="chat.msgCampaigns" data-msg="List campaigns">Campaigns</button>
+            <button type="button" data-i18n="chat.messages" data-i18n-msg="chat.msgMessages" data-msg="List chat messages">Messages</button>
+            <button type="button" data-i18n="chat.news" data-i18n-msg="chat.msgNews" data-msg="List news">News</button>
+            <button type="button" data-i18n="chat.notices" data-i18n-msg="chat.msgNotices" data-msg="List notices">Notices</button>
+            <button type="button" data-i18n="chat.blogs" data-i18n-msg="chat.msgBlogs" data-msg="List blogs">Blogs</button>
+            <button type="button" data-i18n="chat.articles" data-i18n-msg="chat.msgArticles" data-msg="List articles">Articles</button>
+            <button type="button" data-i18n="chat.videos" data-i18n-msg="chat.msgVideos" data-msg="List videos">Videos</button>
+            <button type="button" data-i18n="chat.music" data-i18n-msg="chat.msgMusic" data-msg="List music">Music</button>
+            <button type="button" data-i18n="chat.products" data-i18n-msg="chat.msgProducts" data-msg="List products">Products</button>
           </div>
           <form id="chat-form" class="chat-form">
             <input