140 lines
28 KiB
Plaintext
140 lines
28 KiB
Plaintext
<data-model>
|
||
<table name="green_permission" id="402881e770d27ff80170d2821076002b" idMethod="assigned" isLinkTable="false" skipSql="false" abstract="false" chineseDescription="green_permission" generatePO="true" lazy="true" generatePK="true" generateFK="true">
|
||
<column name="id" id="402881e770d27ff80170d28210b2002c" javaName="id" description="id" primaryKey="true" required="true" type="INTEGER" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="code" id="402881e770d27ff80170d2821bea002d" javaName="code" description="权限编码" required="false" type="INTEGER" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="name" id="402881e770d27ff80170d2821bea002e" javaName="name" description="权限名称" required="false" type="VARCHAR" size="255" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="parent_code" id="402881e770d27ff80170d2821beb002f" javaName="parentCode" description="父级权限编码" required="false" type="INTEGER" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="page_url" id="402881e770d27ff80170d2821beb0030" javaName="pageUrl" description="页面跳转地址" required="false" type="VARCHAR" size="255" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="icon_url" id="402881e770d27ff80170d2821bec0031" javaName="iconUrl" description="icon图标地址" required="false" type="VARCHAR" size="255" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="type" id="402881e770d27ff80170d2821bec0032" javaName="type" description="权限类型 ： 1 .APP 2 .WEB" required="false" type="INTEGER" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="sort" id="402881e770d27ff80170d2821bed0033" javaName="sort" description="排序字段" required="false" type="INTEGER" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="is_open" id="402881e770d27ff80170d2821bed0034" javaName="isOpen" description="0 开启 1 关闭" required="true" type="INTEGER" editorType="text" default="0" inputSize="80" order="false" />
|
||
</table>
|
||
<table name="green_fault_repair_info" id="4028abd178e8efed0178e8f29ea80029" idMethod="assigned" isLinkTable="false" skipSql="false" abstract="false" chineseDescription="green_fault_repair_info" generatePO="true" lazy="true" generatePK="true" generateFK="true">
|
||
<column name="id" id="4028abd178e8efed0178e8f29ec0002a" javaName="id" description="主键ID" primaryKey="true" required="true" type="BIGINT" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="repair_dept_id" id="4028abd178e8efed0178e8f29f30002b" javaName="repairDeptId" description="报修部门id" required="false" type="BIGINT" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="repair_dept_name" id="4028abd178e8efed0178e8f29f57002c" javaName="repairDeptName" description="报修部门名称" required="false" type="VARCHAR" size="32" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="repair_person_id" id="4028abd178e8efed0178e8f29f79002d" javaName="repairPersonId" description="报修人id" required="false" type="VARCHAR" size="32" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="repair_person_name" id="4028abd178e8efed0178e8f29f9d002e" javaName="repairPersonName" description="报修人姓名" required="false" type="VARCHAR" size="20" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="repair_person_phone" id="4028abd178e8efed0178e8f29fbd002f" javaName="repairPersonPhone" description="repair_person_phone" required="false" type="VARCHAR" size="20" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="person_id" id="4028abd178e8efed0178e8f29fe90030" javaName="personId" description="处理人" required="false" type="VARCHAR" size="32" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="repair_option" id="4028abd178e8efed0178e8f2a0090031" javaName="repairOption" description="报修选项" required="false" type="VARCHAR" size="32" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="repair_addr" id="4028abd178e8efed0178e8f2a0310032" javaName="repairAddr" description="报修位置" required="false" type="VARCHAR" size="50" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="fault_detail" id="4028abd178e8efed0178e8f2a0530033" javaName="faultDetail" description="故障描述" required="false" type="VARCHAR" size="255" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="fault_pic1" id="4028abd178e8efed0178e8f2a0750034" javaName="faultPic1" description="故障图片1" required="false" type="VARCHAR" size="50" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="fault_pic2" id="4028abd178e8efed0178e8f2a0970035" javaName="faultPic2" description="故障图片2" required="false" type="VARCHAR" size="50" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="fault_pic3" id="4028abd178e8efed0178e8f2a0b50036" javaName="faultPic3" description="故障图片3" required="false" type="VARCHAR" size="50" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="repair_time" id="4028abd178e8efed0178e8f2a0e10037" javaName="repairTime" description="报修时间" required="true" type="VARCHAR" size="20" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="user_id" id="4028abd178e8efed0178e8f2a0ff0038" javaName="userId" description="用户ID" required="true" type="VARCHAR" size="32" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="creator" id="4028abd178e8efed0178e8f2a11f0039" javaName="creator" description="创建者" required="true" type="VARCHAR" size="50" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="modifier" id="4028abd178e8efed0178e8f2a140003a" javaName="modifier" description="修改者" required="true" type="VARCHAR" size="50" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="gmt_created" id="4028abd178e8efed0178e8f2a161003b" javaName="gmtCreated" description="创建时间" required="true" type="TIMESTAMP" editorType="text" default="CURRENT_TIMESTAMP" inputSize="80" order="false" />
|
||
<column name="gmt_modified" id="4028abd178e8efed0178e8f2a183003c" javaName="gmtModified" description="修改时间" required="true" type="TIMESTAMP" editorType="text" default="CURRENT_TIMESTAMP" inputSize="80" order="false" />
|
||
<column name="is_deleted" id="4028abd178e8efed0178e8f2a1a2003d" javaName="isDeleted" description="是否删除Y/N，默认N" required="true" type="CHAR" editorType="text" default="N" inputSize="80" order="false" />
|
||
<column name="fault_pic1_data" id="4028abd178e8efed0178e8f2a1be003e" javaName="faultPic1Data" description="fault_pic1_data" required="false" type="VARCHAR" size="50" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="fault_pic2_data" id="4028abd178e8efed0178e8f2a1dd003f" javaName="faultPic2Data" description="fault_pic2_data" required="false" type="VARCHAR" size="50" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="fault_pic3_data" id="4028abd178e8efed0178e8f2a1fc0040" javaName="faultPic3Data" description="fault_pic3_data" required="false" type="VARCHAR" size="50" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="img_status" id="4028abd178e8efed0178e8f2a21c0041" javaName="imgStatus" description="img_status" required="false" type="INTEGER" editorType="text" default="0" inputSize="80" order="false" />
|
||
<column name="repair_status" id="4028abd178e8efed0178e8f2a23c0042" javaName="repairStatus" description="0 未受理 1 维修中 2已维修" required="false" type="INTEGER" editorType="text" default="0" inputSize="80" order="false" />
|
||
<column name="repair_place" id="4028abd178e8efed0178e8f2a25a0043" javaName="repairPlace" description="大概位置" required="false" type="VARCHAR" size="50" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="urgent" id="4028abd178e8efed0178e8f2a27b0044" javaName="urgent" description="0不紧急 1紧急 2特急" required="false" type="INTEGER" editorType="text" default="0" inputSize="80" order="false" />
|
||
<column name="endRemind" id="4028abd178e8efed0178e8f2a2990045" javaName="endremind" description="通知次数：0未通知" required="false" type="INTEGER" editorType="text" default="0" inputSize="80" order="false" />
|
||
<column name="is_evaluate" id="4028abd178e8efed0178e8f2a2b50046" javaName="isEvaluate" description="评价次数 0 未评价" required="false" type="INTEGER" editorType="text" default="0" inputSize="80" order="false" />
|
||
<column name="is_inspection" id="4028abd178e8efed0178e8f2a2d50047" javaName="isInspection" description="0故障报修，1巡检考核 2,维保考核" required="false" type="INTEGER" editorType="text" default="0" inputSize="80" order="false" />
|
||
<column name="repair_floor" id="4028abd178e8efed0178e8f2a2f60048" javaName="repairFloor" description="repair_floor" required="false" type="VARCHAR" size="50" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="repair_room_no" id="4028abd178e8efed0178e8f2a3140049" javaName="repairRoomNo" description="repair_room_no" required="false" type="VARCHAR" size="50" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="repair_option_sub" id="4028abd178e8efed0178e8f2a332004a" javaName="repairOptionSub" description="repair_option_sub" required="false" type="VARCHAR" size="10" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="accept_date" id="4028abd178e8efed0178e8f2a350004b" javaName="acceptDate" description="accept_date" required="false" type="TIMESTAMP" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="finish_date" id="4028abd178e8efed0178e8f2a36d004c" javaName="finishDate" description="finish_date" required="false" type="TIMESTAMP" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="fault_type" id="4028abd178e8efed0178e8f2a38a004d" javaName="faultType" description="0报修 1报事" required="false" type="INTEGER" editorType="text" default="0" inputSize="80" order="false" />
|
||
<column name="reply_pic1" id="4028abd178e8efed0178e8f2a3ac004e" javaName="replyPic1" description="回复图片" required="false" type="VARCHAR" size="50" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="reply_pic2" id="4028abd178e8efed0178e8f2a3cd004f" javaName="replyPic2" description="回复图片" required="false" type="VARCHAR" size="50" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="reply_pic1_data" id="4028abd178e8efed0178e8f2a3ee0050" javaName="replyPic1Data" description="reply_pic1_data" required="false" type="VARCHAR" size="50" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="reply_pic2_data" id="4028abd178e8efed0178e8f2a4090051" javaName="replyPic2Data" description="reply_pic2_data" required="false" type="VARCHAR" size="50" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="reply_content" id="4028abd178e8efed0178e8f2a4250052" javaName="replyContent" description="回复内容" required="false" type="VARCHAR" size="255" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="reply_date" id="4028abd178e8efed0178e8f2a4400053" javaName="replyDate" description="回复时间" required="false" type="TIMESTAMP" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="reply_flag" id="4028abd178e8efed0178e8f2a45d0054" javaName="replyFlag" description="0未回复 1已回复 2已完结，3已取消" required="false" type="VARCHAR" editorType="text" default="0" inputSize="80" order="false" />
|
||
<column name="check_fraction" id="4028abd178e8efed0178e8f2a4780055" javaName="checkFraction" description="考核分数" required="false" type="INTEGER" editorType="text" default="0" inputSize="80" order="false" />
|
||
<column name="fault_proposal" id="4028abd178e8efed0178e8f2a4940056" javaName="faultProposal" description="巡检建议" required="false" type="VARCHAR" size="255" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="fault_evaluate" id="4028abd178e8efed0178e8f2a4b00057" javaName="faultEvaluate" description="巡检评价" required="false" type="VARCHAR" size="255" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="wb_types" id="4028abd178e8efed0178e8f2a4cc0058" javaName="wbTypes" description="维保类型" required="false" type="VARCHAR" size="50" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="elevator_no" id="4028abd178e8efed0178e8f2a4e90059" javaName="elevatorNo" description="维保电梯" required="false" type="VARCHAR" size="50" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="fault_pic4" id="4028abd178e8efed0178e8f2a505005a" javaName="faultPic4" description="fault_pic4" required="false" type="VARCHAR" size="50" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="fault_pic5" id="4028abd178e8efed0178e8f2a520005b" javaName="faultPic5" description="fault_pic5" required="false" type="VARCHAR" size="50" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="fault_pic6" id="4028abd178e8efed0178e8f2a53b005c" javaName="faultPic6" description="fault_pic6" required="false" type="VARCHAR" size="50" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="fault_pic4_data" id="4028abd178e8efed0178e8f2a557005d" javaName="faultPic4Data" description="fault_pic4_data" required="false" type="VARCHAR" size="50" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="fault_pic5_data" id="4028abd178e8efed0178e8f2a573005e" javaName="faultPic5Data" description="fault_pic5_data" required="false" type="VARCHAR" size="50" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="fault_pic6_data" id="4028abd178e8efed0178e8f2a58d005f" javaName="faultPic6Data" description="fault_pic6_data" required="false" type="VARCHAR" size="50" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="upload_file_ids" id="4028abd178e8efed0178e8f2a5aa0060" javaName="uploadFileIds" description="关联文件id，逗号分隔" required="false" type="VARCHAR" size="500" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="replace_parts" id="4028abd178e8efed0178e8f2a5c70061" javaName="replaceParts" description="是否更换配件 0否 1是" required="false" type="INTEGER" editorType="text" default="0" inputSize="80" order="false" />
|
||
<column name="device_name" id="4028abd178e8efed0178e8f2a5e30062" javaName="deviceName" description="设备名称" required="false" type="VARCHAR" size="50" editorType="text" default="" inputSize="80" order="false" />
|
||
</table>
|
||
<table name="green_week_kinds" id="8a0982f37949bcc9017949bd6af80063" idMethod="assigned" isLinkTable="false" sequenceName="" skipSql="false" abstract="false" chineseDescription="green_week_kinds" generatePO="true" lazy="true" generatePK="true" generateFK="true">
|
||
<column name="id" id="8a0982f37949bcc9017949bd6b160064" javaName="id" description="id" primaryKey="true" required="true" type="BIGINT" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="food_name" id="8a0982f37949bcc9017949bd6b8f0065" javaName="foodName" description="名称" required="false" type="VARCHAR" size="20" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="features" id="8a0982f37949bcc9017949bd6bb60066" javaName="features" description="特性" required="false" type="VARCHAR" size="100" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="main_materials" id="8a0982f37949bcc9017949bd6bd40067" javaName="mainMaterials" description="主料" required="false" type="VARCHAR" size="100" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="nutritive_value" id="8a0982f37949bcc9017949bd6bfc0068" javaName="nutritiveValue" description="营养价值" required="false" type="VARCHAR" size="200" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="diet_advice" id="8a0982f37949bcc9017949bd6c1a0069" javaName="dietAdvice" description="饮食建议" required="false" type="VARCHAR" size="100" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="picture" id="8a0982f37949bcc9017949bd6c42006a" javaName="picture" description="picture" required="false" type="VARCHAR" size="300" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="picture_date" id="8a0982f37949bcc9017949bd6c60006b" javaName="pictureDate" description="picture_date" required="false" type="VARCHAR" size="100" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="creator" id="8a0982f37949bcc9017949bd6c7e006c" javaName="creator" description="creator" required="false" type="VARCHAR" size="50" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="modifier" id="8a0982f37949bcc9017949bd6ca6006d" javaName="modifier" description="modifier" required="false" type="VARCHAR" size="50" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="gmt_created" id="8a0982f37949bcc9017949bd6cce006e" javaName="gmtCreated" description="gmt_created" required="false" type="TIMESTAMP" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="gmt_modified" id="8a0982f37949bcc9017949bd6cec006f" javaName="gmtModified" description="gmt_modified" required="false" type="TIMESTAMP" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="is_deleted" id="8a0982f37949bcc9017949bd6d0a0070" javaName="isDeleted" description="是否删除Y/N，默认N" required="false" type="CHAR" editorType="text" default="N" inputSize="80" order="false" />
|
||
<column name="raw_materials" id="297e059689f3bbc20189f3bc0dc80082" javaName="rawMaterials" description="原料" required="false" type="VARCHAR" size="20" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="label" id="297e059689f3bbc20189f3bd14630083" javaName="label" description="营养标签" required="false" type="VARCHAR" size="20" editorType="text" default="" inputSize="80" order="false" />
|
||
</table>
|
||
<table name="green_week_menu" id="8a0982f37949bcc901794aac041200f0" idMethod="assigned" isLinkTable="false" skipSql="false" abstract="false" chineseDescription="green_week_menu" generatePO="true" lazy="true" generatePK="true" generateFK="true">
|
||
<column name="id" id="8a0982f37949bcc901794aac041200f1" javaName="id" description="主键ID" primaryKey="true" required="true" type="BIGINT" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="location_id" id="8a0982f37949bcc901794aac046200f2" javaName="locationId" description="食堂Id" required="true" type="VARCHAR" size="32" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="sell_date" id="8a0982f37949bcc901794aac048000f3" javaName="sellDate" description="预售日期" required="false" type="VARCHAR" size="20" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="food_menu" id="8a0982f37949bcc901794aac049e00f4" javaName="foodMenu" description="菜品谱" required="true" type="VARCHAR" size="1000" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="menu_type" id="8a0982f37949bcc901794aac04c600f5" javaName="menuType" description="0早餐 1午餐 2晚餐" required="false" type="CHAR" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="status" id="8a0982f37949bcc901794aac04e400f6" javaName="status" description="外卖使用状态 0已发布 1待发布" required="true" type="CHAR" editorType="text" default="0" inputSize="80" order="false" />
|
||
<column name="creator" id="8a0982f37949bcc901794aac050200f7" javaName="creator" description="创建者" required="true" type="VARCHAR" size="50" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="modifier" id="8a0982f37949bcc901794aac052000f8" javaName="modifier" description="修改者" required="true" type="VARCHAR" size="50" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="gmt_created" id="8a0982f37949bcc901794aac054800f9" javaName="gmtCreated" description="创建时间" required="true" type="DATE" editorType="datetime" default="CURRENT_TIMESTAMP" inputSize="80" order="false" />
|
||
<column name="gmt_modified" id="8a0982f37949bcc901794aac056600fa" javaName="gmtModified" description="修改时间" required="true" type="DATE" editorType="datetime" default="CURRENT_TIMESTAMP" inputSize="80" order="false" />
|
||
<column name="is_deleted" id="8a0982f37949bcc901794aac058400fb" javaName="isDeleted" description="是否删除Y/N，默认N" required="true" type="CHAR" editorType="text" default="N" inputSize="80" order="false" />
|
||
</table>
|
||
<table name="green_week_variety" id="8a0982f37949bcc901794ab065250128" idMethod="assigned" isLinkTable="false" skipSql="false" abstract="false" chineseDescription="green_week_variety" generatePO="true" lazy="true" generatePK="true" generateFK="true">
|
||
<column name="id" id="8a0982f37949bcc901794ab065250129" javaName="id" description="主键ID" primaryKey="true" required="true" type="BIGINT" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="kinds_id" id="8a0982f37949bcc901794ab06561012a" javaName="kindsId" description="菜品ID" required="true" type="BIGINT" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="menu_id" id="8a0982f37949bcc901794ab0657f012b" javaName="menuId" description="外卖菜品谱ID" required="true" type="BIGINT" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="creator" id="8a0982f37949bcc901794ab0659d012c" javaName="creator" description="创建者" required="true" type="VARCHAR" size="50" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="modifier" id="8a0982f37949bcc901794ab065bb012d" javaName="modifier" description="修改者" required="true" type="VARCHAR" size="50" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="gmt_created" id="8a0982f37949bcc901794ab065d9012e" javaName="gmtCreated" description="创建时间" required="true" type="DATE" editorType="datetime" default="CURRENT_TIMESTAMP" inputSize="80" order="false" />
|
||
<column name="gmt_modified" id="8a0982f37949bcc901794ab065f7012f" javaName="gmtModified" description="修改时间" required="true" type="DATE" editorType="datetime" default="CURRENT_TIMESTAMP" inputSize="80" order="false" />
|
||
<column name="is_deleted" id="8a0982f37949bcc901794ab066150130" javaName="isDeleted" description="是否删除Y/N，默认N" required="true" type="CHAR" editorType="text" default="N" inputSize="80" order="false" />
|
||
</table>
|
||
<table name="green_week_carte" id="8a0982f379878b020179878b65470068" idMethod="assigned" isLinkTable="false" skipSql="false" abstract="false" chineseDescription="green_week_carte" generatePO="true" lazy="true" generatePK="true" generateFK="true">
|
||
<column name="id" id="8a0982f379878b020179878b65650069" javaName="id" description="id" primaryKey="true" required="true" type="BIGINT" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="start_date" id="8a0982f379878b020179878b65d3006a" javaName="startDate" description="开始日期" required="false" type="VARCHAR" size="10" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="end_date" id="8a0982f379878b020179878b65f1006b" javaName="endDate" description="结束日期" required="false" type="VARCHAR" size="10" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="breakfast" id="8a0982f379878b020179878b6619006c" javaName="breakfast" description="早餐" required="false" type="VARCHAR" size="2000" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="lunch" id="8a0982f379878b020179878b6637006d" javaName="lunch" description="午餐" required="false" type="VARCHAR" size="100" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="creator" id="8a0982f379878b020179878b665f006e" javaName="creator" description="creator" required="false" type="VARCHAR" size="50" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="modifier" id="8a0982f379878b020179878b667d006f" javaName="modifier" description="modifier" required="false" type="VARCHAR" size="50" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="gmt_created" id="8a0982f379878b020179878b669b0070" javaName="gmtCreated" description="gmt_created" required="false" type="DATE" editorType="datetime" default="" inputSize="80" order="false" />
|
||
<column name="gmt_modified" id="8a0982f379878b020179878b66b90071" javaName="gmtModified" description="gmt_modified" required="false" type="DATE" editorType="datetime" default="" inputSize="80" order="false" />
|
||
<column name="is_deleted" id="8a0982f379878b020179878b66d70072" javaName="isDeleted" description="是否删除Y/N，默认N" required="false" type="VARCHAR" size="32" editorType="text" default="N" inputSize="80" order="false" />
|
||
</table>
|
||
<table name="green_banner" id="8a0982f37a9dd6ae017a9dd72ea20073" idMethod="assigned" isLinkTable="false" skipSql="false" abstract="false" chineseDescription="green_banner" generatePO="true" lazy="true" generatePK="true" generateFK="true">
|
||
<column name="id" id="8a0982f37a9dd6ae017a9dd72eb50074" javaName="id" description="id" primaryKey="true" required="true" type="BIGINT" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="pic_path" id="8a0982f37a9dd6ae017a9dd72f250075" javaName="picPath" description="图片路劲" required="false" type="VARCHAR" size="100" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="url_path" id="8a0982f37a9dd6ae017a9dd72f4a0076" javaName="urlPath" description="跳转路劲" required="false" type="VARCHAR" size="50" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="category" id="8a0982f37a9dd6ae017a9dd72f6f0077" javaName="category" description="是否默认 0默认 1不默认" required="false" type="INTEGER" editorType="text" default="0" inputSize="80" order="false" />
|
||
<column name="roles" id="8a0982f37a9dd6ae017a9dd72f900078" javaName="roles" description="关联权限" required="false" type="VARCHAR" size="200" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="limit_time" id="8a0982f37a9dd6ae017a9dd72fb10079" javaName="limitTime" description="是否限时 0不限时，1限时" required="false" type="INTEGER" editorType="text" default="0" inputSize="80" order="false" />
|
||
<column name="start_date" id="8a0982f37a9dd6ae017a9dd72fd2007a" javaName="startDate" description="开始时间" required="false" type="VARCHAR" size="10" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="end_date" id="8a0982f37a9dd6ae017a9dd72ff5007b" javaName="endDate" description="结束日期" required="false" type="VARCHAR" size="10" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="creator" id="8a0982f37a9dd6ae017a9dd73020007c" javaName="creator" description="creator" required="false" type="VARCHAR" size="64" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="modifier" id="8a0982f37a9dd6ae017a9dd73049007d" javaName="modifier" description="modifier" required="false" type="VARCHAR" size="64" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="gmt_created" id="8a0982f37a9dd6ae017a9dd7306d007e" javaName="gmtCreated" description="gmt_created" required="false" type="DATE" editorType="datetime" default="" inputSize="80" order="false" />
|
||
<column name="gmt_modified" id="8a0982f37a9dd6ae017a9dd7308e007f" javaName="gmtModified" description="gmt_modified" required="false" type="DATE" editorType="datetime" default="" inputSize="80" order="false" />
|
||
<column name="sort" id="8a0982f37a9dd6ae017a9dd730ab0080" javaName="sort" description="排序" required="false" type="VARCHAR" size="5" editorType="text" default="" inputSize="80" order="false" />
|
||
<column name="is_deleted" id="8a0982f37a9dd6ae017a9dd730c90081" javaName="isDeleted" description="是否删除 N否 Y删除" required="false" type="VARCHAR" size="32" editorType="text" default="N" inputSize="80" order="false" />
|
||
</table>
|
||
</data-model> |