<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE database>
<database name="*">
    <!--以下为测试表格，只供参考！-->
    <table name="fc_test" comment="测试表格">

        <column name="testId" comment="编号" type="int" length="11"
                primary="true" autoincrement="true" nullable="not null"/>

        <column name="testName" comment="测试文本" type="varchar"
                nullable="null" length="500"/>

        <column name="testNumber" comment="测试数字" type="double"
                nullable="null" length="11,4"/>

        <column name="testImage" comment="测试图片" type="varchar"
                nullable="null" length="500" render="Image"/>

        <column name="testImages" comment="测试多张图片" type="varchar"
                nullable="null" length="500" render="Image,Image"/>

        <column name="testFile" comment="测试单个其他文件" type="varchar"
                nullable="null" length="500" render="Excel"/>

        <column name="testFiles" comment="测试多个其他文件" type="varchar"
                nullable="null" length="500" render="Excel,Word,Text"/>

        <column name="testContent" comment="测试大文本" type="text"
                nullable="null" render="Content"/>

        <column name="testState" comment="测试枚举" type="int" length="11"
                nullable="null" render="Enum"/>

        <column name="testHtmlContent" comment="测试网页文本" type="text"
                nullable="null" render="HtmlContent"/>

        <column name="linkTestId" comment="测试关联表格" type="int"
                nullable="null" length="11" link="fc_test@testId@testName"/>

        <column name="testAddress" comment="测试地理位置" type="varchar"
                nullable="null" length="500" render="Map@testLng@testLat"/>

        <column name="testLng" comment="测试经度" type="decimal"
                nullable="null" length="20,11"/>

        <column name="testLat" comment="测试纬度" type="decimal"
                nullable="null" length="20,11"/>

        <column name="targetLinkId" comment="测试一对多表Id" type="int"
                       nullable="null" length="11" render="Target@targetLinkType"/>

         <column name="targetLinkType" comment="一对多表的类型" type="int"
                      nullable="null" length="11" render="Enum"/>

        <column name="testDateTime" comment="录入时间" type="datetime"
                nullable="null" length="6"/>
    </table>


        <table name="fc_test_more" comment="测试越级关联表格" >

            <column name="userId" comment="ID" type="int" length="11"
                    primary="true" autoincrement="true" nullable="not null"/>

            <!--  enable="false" 此列不会在表格中创建-->
            <column name="estateId" comment="所属小区" type="int"
                    nullable="null" length="11" enable="false"  link="fc_house_estate@estateId@estateName" on="buildingId"/>

            <!--  enable="false" 此列不会在表格中创建-->
            <column name="buildingId" comment="所属楼栋" type="int"
                    nullable="null" length="11" enable="false"  link="fc_house_building@buildingId@buildingName" on="houseId"/>

            <column name="houseId" comment="所属房屋" type="int"
                    nullable="null" length="11"  link="fc_house@houseId@houseName"/>

        </table>

</database>
