大美餐饮收银系统


dOrderDetail 订单明细表

<p>dOrderDetail 订单明细表</p> <pre><code class="language-sql">CREATE TABLE IF NOT EXISTS dOrderDetail ( Id TEXT PRIMARY KEY COMMENT '订单明细ID', CreateDate TEXT DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期', UpdateDate TEXT COMMENT '数据更新时间', ShopId TEXT COMMENT '所属店铺ID', SortOrder INTEGER COMMENT '排序号,数值越大越靠前', OrderId TEXT COMMENT '订单ID', DishId TEXT COMMENT '菜品ID', Price REAL COMMENT '单价', Quantity INTEGER COMMENT '数量' ); </code></pre>

页面列表

ITEM_HTML