<?xml version="1.0" encoding="utf-8" ?>
<!-- SQL XML created by WWW SQL Designer, https://github.com/ondras/wwwsqldesigner/ -->
<!-- Active URL: https://sql.toad.cz/?keyword=default -->
<sql>
<datatypes db="mssql">
<group label="Integer" color="rgb(238,238,170)">
<type label="TinyInt" length="0" sql="tinyint" re="INT" quote="" bytes="1" note="Integer data: 0 to 255"/>
<type label="SmallInt" length="0" sql="smallint" re="INT" quote="" bytes="2" note="Integer data: -32,768 to 32,767"/>
<type label="Int" length="0" sql="int" re="INT" quote="" bytes="4" note="Integer data: -2,147,483,648 to 2,147,483,647"/>
<type label="BigInt" length="0" sql="bigint" re="INT" quote="" bytes="8" note="Integer data: -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807"/>
</group>
<group label="Monetary" color="rgb(238,238,170)">
<type label="Money" length="0" sql="money" re="FLOAT" quote="" bytes="8" note="Integer data: -922,337,203,685,477.5808 to 922,337,203,685,477.5807"/>
<type label="SmallMoney" length="0" sql="smallmoney" re="FLOAT" quote="" bytes="4" note="-214,748.3648 to 214,748.3647"/>
</group>
<group label="Numeric" color="rgb(238,238,170)">
<type label="Real" length="0" sql="real" re="FLOAT" quote="" bytes="4" note="Floating precision number data: -3.402823E+38 to 3.402823E+38"/>
<type label="Float" length="0" sql="float" re="FLOAT" quote="" bytes="8" note="Floating precision number data: -4.94E+324 to 4.94E+324"/>
<type label="Decimal" length="1" sql="decimal" re="DEC" quote="" bytes="n*" note="Fixed precision and scale numeric data: -10^38 +1 to 10^38 -1 (decimal and numeric are synonyms)"/>
<type label="Numeric" length="1" sql="numeric" re="DEC" quote="" bytes="n*" note="Fixed precision and scale numeric data: -10^38 +1 to 10^38 -1 (decimal and numeric are synonyms)"/>
</group>
<group label="Character" color="rgb(255,200,200)">
<type label="Char" length="0" sql="char" quote="'" bytes="n" note="Fixed-length character data with a maximum length of 8,000 characters"/>
<type label="Varchar" length="1" sql="varchar" quote="'" bytes="m <= n" note="Variable-length data with a maximum of 8,000 characters"/>
<type label="Text" length="1" sql="text" quote="'" bytes="<= 2,147,483,647" note="Variable-length data with a maximum length of 2,147,483,647 characters"/>
<type label="XML" length="0" sql="xml" quote="'" bytes="n" note="XML"/>
</group>
<group label="Unicode Character" color="rgb(255,200,200)">
<type label="nChar" length="0" sql="nchar" quote="'" bytes="n" note="Fixed-length Unicode data with a maximum length of 4,000 characters"/>
<type label="nVarchar" length="1" sql="nvarchar" quote="'" bytes="m <= n" note="Variable-length Unicode data with a maximum length of 4,000 characters"/>
<type label="nText" length="1" sql="ntext" quote="'" bytes="<= 2,147,483,647" note="Variable-length Unicode data with a maximum length of 1,073,741,823 characters"/>
</group>
<group label="Date & Time" color="rgb(200,255,200)">
<type label="Datetime" length="0" sql="datetime" quote="" bytes="8" note="Jan 1, 1753 to Dec 31, 9999"/>
<type label="SmallDateTime" length="0" sql="smalldatetime" quote="" bytes="4" note="Jan 1, 1900 to Dec 31, 2079"/>
</group>
<group label="Binary" color="rgb(200,200,255)">
<type label="Binary" length="0" sql="binary" quote="'" bytes="n" note="Fixed-length binary data with a maximum length of 8,000 bytes"/>
<type label="Varbinary" length="1" sql="varbinary" quote="'" bytes="m <= n" note="Variable-length binary data with a maximum length of 8,000 bytes"/>
</group>
<group label="Miscellaneous" color="rgb(200,220,255)">
<type label="Bit" length="0" sql="bit" quote="" bytes="1" note="Boolean: 1 or 0"/>
<type label="Image" length="1" sql="image" re="BLOB" quote="" bytes="0 to 2,147,483,647" note="Variable-length binary data with a maximum length of 2,147,483,647 bytes"/>
<type label="Timestamp" length="0" sql="timestamp" quote="" bytes="8" note="Locally unique binary number updated as a row gets updated"/>
<type label="SQL Variant" length="1" sql="sql_variant" quote="" bytes="" note="Stores any datatype except text, ntext, image, timestamp"/>
<type label="Uniqueidentifier" length="1" sql="uniqueidentifier" quote="" bytes="16" note="GUID"/>
</group>
</datatypes>
<table x="25" y="137" name="Partner">
<row name="id" null="0" autoincrement="1">
<datatype>tinyint</datatype>
<default>NULL</default>
</row>
<row name="Name" null="0" autoincrement="0">
<datatype>nvarchar(100)</datatype>
<default>'NULL'</default>
</row>
<key type="PRIMARY" name="">
<part>id</part>
</key>
</table>
<table x="289" y="115" name="Users">
<row name="id" null="0" autoincrement="1">
<datatype>smallint</datatype>
<default>NULL</default>
</row>
<row name="Name" null="1" autoincrement="0">
<datatype>nvarchar(50)</datatype>
<default>NULL</default>
</row>
<row name="PartnerID" null="1" autoincrement="0">
<datatype>tinyint</datatype>
<default>NULL</default>
<relation table="Partner" row="id" />
</row>
<key type="PRIMARY" name="">
<part>id</part>
</key>
</table>
<table x="572" y="31" name="Event">
<row name="id" null="0" autoincrement="1">
<datatype>int</datatype>
<default>NULL</default>
</row>
<row name="UploadCompleted" null="1" autoincrement="0">
<datatype>smalldatetime</datatype>
<default>NULL</default>
</row>
<row name="Notification" null="1" autoincrement="0">
<datatype>nvarchar(50)</datatype>
<default>NULL</default>
</row>
<row name="UserID" null="1" autoincrement="0">
<datatype>smallint</datatype>
<default>NULL</default>
<relation table="Users" row="id" />
</row>
<row name="Latitude" null="1" autoincrement="0">
<datatype>real</datatype>
<default>NULL</default>
</row>
<row name="Longitude" null="1" autoincrement="0">
<datatype>real</datatype>
<default>NULL</default>
</row>
<row name="Altitude" null="1" autoincrement="0">
<datatype>real</datatype>
<default>NULL</default>
</row>
<row name="BeneficiariesID" null="0" autoincrement="0">
<datatype>int</datatype>
<default>NULL</default>
<relation table="Beneficiaries" row="id" />
</row>
<key type="PRIMARY" name="">
<part>id</part>
</key>
</table>
<table x="570" y="293" name="Beneficiaries">
<row name="id" null="0" autoincrement="1">
<datatype>int</datatype>
<default>NULL</default>
</row>
<row name="SubmissionID" null="1" autoincrement="0">
<datatype>int</datatype>
<default>NULL</default>
</row>
<row name="FirstName" null="1" autoincrement="0">
<datatype>varchar(20)</datatype>
<default>NULL</default>
</row>
<row name="SecondName" null="1" autoincrement="0">
<datatype>varchar(25)</datatype>
<default>NULL</default>
</row>
<row name="MiddleName" null="1" autoincrement="0">
<datatype>varchar(25)</datatype>
<default>NULL</default>
</row>
<row name="Settlement" null="1" autoincrement="0">
<datatype>smallint</datatype>
<default>NULL</default>
<relation table="Settlements" row="id" />
</row>
<row name="AddressTypeID" null="1" autoincrement="0">
<datatype>tinyint</datatype>
<default>NULL</default>
<relation table="AddressType" row="id" />
</row>
<row name="StreetID" null="1" autoincrement="0">
<datatype>smallint</datatype>
<default>NULL</default>
<relation table="Streets" row="id" />
</row>
<row name="Building" null="1" autoincrement="0">
<datatype>tinyint</datatype>
<default>NULL</default>
</row>
<row name="Apartment" null="1" autoincrement="0">
<datatype>tinyint</datatype>
<default>NULL</default>
</row>
<row name="BirthDate" null="1" autoincrement="0">
<datatype>smalldatetime</datatype>
<default>NULL</default>
</row>
<row name="PhoneNumber" null="1" autoincrement="0">
<datatype>int</datatype>
<default>NULL</default>
</row>
<row name="HeadOfHousehold" null="1" autoincrement="0">
<datatype>bit</datatype>
<default>NULL</default>
</row>
<row name="HouseholdCategoriesID" null="1" autoincrement="0">
<datatype>tinyint</datatype>
<default>NULL</default>
<relation table="HousholdCategories" row="id" />
</row>
<row name="HouseholdTypeID" null="1" autoincrement="0">
<datatype>tinyint</datatype>
<default>NULL</default>
<relation table="HouseholdType" row="id" />
</row>
<row name="HouseholdMembersCount" null="0" autoincrement="0">
<datatype>tinyint</datatype>
<default>NULL</default>
</row>
<row name="HouseholdCompositionID" null="1" autoincrement="0">
<datatype>tinyint</datatype>
<default>NULL</default>
<relation table="HouseholdCompositions" row="id" />
</row>
<row name="AmountOfChildren5" null="1" autoincrement="0">
<datatype>tinyint</datatype>
<default>NULL</default>
</row>
<row name="AmountOfChildren6_12" null="1" autoincrement="0">
<datatype>tinyint</datatype>
<default>NULL</default>
</row>
<row name="AmountOfChildren13_17" null="1" autoincrement="0">
<datatype>tinyint</datatype>
<default>NULL</default>
</row>
<row name="Sex" null="1" autoincrement="0">
<datatype>nchar(1)</datatype>
<default>NULL</default>
</row>
<key type="PRIMARY" name="">
<part>id</part>
</key>
</table>
<table x="68" y="303" name="Oblasts">
<row name="id" null="0" autoincrement="1">
<datatype>tinyint</datatype>
<default>NULL</default>
</row>
<row name="Name" null="0" autoincrement="0">
<datatype>nvarchar(30)</datatype>
<default>'NULL'</default>
</row>
<key type="PRIMARY" name="">
<part>id</part>
</key>
</table>
<table x="71" y="409" name="Districts">
<row name="id" null="0" autoincrement="1">
<datatype>tinyint</datatype>
<default>NULL</default>
</row>
<row name="Name" null="0" autoincrement="0">
<datatype>varchar(20)</datatype>
<default>'NULL'</default>
</row>
<key type="PRIMARY" name="">
<part>id</part>
</key>
</table>
<table x="62" y="527" name="Communities">
<row name="id" null="0" autoincrement="1">
<datatype>tinyint</datatype>
<default>NULL</default>
</row>
<row name="Name" null="0" autoincrement="0">
<datatype>varchar(20)</datatype>
<default>'NULL'</default>
</row>
<key type="PRIMARY" name="">
<part>id</part>
</key>
</table>
<table x="308" y="352" name="Settlements">
<row name="id" null="1" autoincrement="1">
<datatype>smallint</datatype>
<default>NULL</default>
</row>
<row name="Name" null="0" autoincrement="0">
<datatype>nvarchar</datatype>
<default>'NULL'</default>
</row>
<row name="OblastID" null="0" autoincrement="0">
<datatype>tinyint</datatype>
<default>NULL</default>
<relation table="Oblasts" row="id" />
</row>
<row name="DistrictID" null="0" autoincrement="0">
<datatype>tinyint</datatype>
<default>NULL</default>
<relation table="Districts" row="id" />
</row>
<row name="CommunityID" null="0" autoincrement="0">
<datatype>tinyint</datatype>
<default>NULL</default>
<relation table="Communities" row="id" />
</row>
<key type="PRIMARY" name="">
<part>id</part>
</key>
</table>
<table x="252" y="675" name="AddressType">
<row name="id" null="1" autoincrement="1">
<datatype>tinyint</datatype>
<default>NULL</default>
</row>
<row name="Name" null="0" autoincrement="0">
<datatype>varchar(10)</datatype>
<default>'NULL'</default>
</row>
<key type="PRIMARY" name="">
<part>id</part>
</key>
</table>
<table x="509" y="823" name="Streets">
<row name="id" null="1" autoincrement="1">
<datatype>smallint</datatype>
<default>NULL</default>
</row>
<row name="Name" null="0" autoincrement="0">
<datatype>varchar(30)</datatype>
<default>'NULL'</default>
</row>
<row name="AddressTypeID" null="0" autoincrement="0">
<datatype>tinyint</datatype>
<default>NULL</default>
<relation table="AddressType" row="id" />
</row>
<key type="PRIMARY" name="">
<part>id</part>
</key>
</table>
<table x="890" y="270" name="TempAdress">
<row name="id" null="0" autoincrement="1">
<datatype>int</datatype>
<default>NULL</default>
</row>
<row name="BeneficiariesID" null="1" autoincrement="0">
<datatype>int</datatype>
<default>NULL</default>
<relation table="Beneficiaries" row="id" />
</row>
<key type="PRIMARY" name="">
<part>id</part>
</key>
</table>
<table x="907" y="523" name="HousholdCategories">
<row name="id" null="1" autoincrement="1">
<datatype>tinyint</datatype>
<default>NULL</default>
</row>
<row name="Name" null="1" autoincrement="0">
<datatype>varchar(150)</datatype>
<default>NULL</default>
</row>
<key type="PRIMARY" name="">
<part>id</part>
</key>
</table>
<table x="907" y="615" name="HouseholdType">
<row name="id" null="1" autoincrement="1">
<datatype>tinyint</datatype>
<default>NULL</default>
</row>
<row name="Name" null="1" autoincrement="0">
<datatype>varchar(50)</datatype>
<default>NULL</default>
</row>
<key type="PRIMARY" name="">
<part>id</part>
</key>
</table>
<table x="909" y="709" name="HouseholdCompositions">
<row name="id" null="1" autoincrement="1">
<datatype>tinyint</datatype>
<default>NULL</default>
</row>
<row name="Name" null="1" autoincrement="0">
<datatype>varchar(30)</datatype>
<default>NULL</default>
</row>
<key type="PRIMARY" name="">
<part>id</part>
</key>
</table>
<table x="1077" y="31" name="Questions">
<row name="id" null="1" autoincrement="1">
<datatype>smallint</datatype>
<default>NULL</default>
</row>
<row name="QuestionText" null="1" autoincrement="0">
<datatype>tinyint</datatype>
<default>NULL</default>
</row>
<key type="PRIMARY" name="">
<part>id</part>
</key>
</table>
<table x="1056" y="150" name="Answers">
<row name="id" null="1" autoincrement="1">
<datatype>smallint</datatype>
<default>NULL</default>
</row>
<row name="QuestionID" null="1" autoincrement="0">
<datatype>smallint</datatype>
<default>NULL</default>
<relation table="Questions" row="id" />
</row>
<row name="AnswerText" null="1" autoincrement="0">
<datatype>varchar(200)</datatype>
<default>NULL</default>
</row>
<key type="PRIMARY" name="">
<part>id</part>
</key>
</table>
<table x="870" y="85" name="LinkTable">
<row name="EventID" null="0" autoincrement="0">
<datatype>int</datatype>
<default>NULL</default>
<relation table="Event" row="id" />
</row>
<row name="QuestionID" null="0" autoincrement="0">
<datatype>smallint</datatype>
<default>NULL</default>
<relation table="Questions" row="id" />
</row>
<row name="AnswerID" null="0" autoincrement="0">
<datatype>smallint</datatype>
<default>NULL</default>
<relation table="Answers" row="id" />
</row>
<key type="PRIMARY" name=""></key>
</table>
</sql>
Комментарии
Отправить комментарий