Assignment1/.vs/Assignment1-1720/DesignTimeBuild/.dtbcache
Assignment1/.vs/Assignment1-1720/v15/.suo
Assignment1/.vs/Assignment1-1720/v15/Serve
sqlite3/db.lock
Assignment1/.vs/Assignment1-1720/v15/Serve
sqlite3/storage.ide
Assignment1/.vs/Assignment1-1720/v15/Serve
sqlite3/storage.ide-shm
Assignment1/.vs/Assignment1-1720/v15/Serve
sqlite3/storage.ide-wal
Assignment1/.vs/Assignment1/v15/.suo
Assignment1/.vs/Assignment1/v15/Serve
sqlite3/db.lock
Assignment1/.vs/Assignment1/v15/Serve
sqlite3/storage.ide
Assignment1/.vs/Assignment1/v15/Serve
sqlite3/storage.ide-shm
Assignment1/.vs/Assignment1/v15/Serve
sqlite3/storage.ide-wal
Assignment1/Assignment1.sln
Microsoft Visual Studio Solution File, Format Version 12.00
# Visual Studio 15
VisualStudioVersion = 15.0.27703.2042
MinimumVisualStudioVersion = 10.0.40219.1
Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "Assignment1", "Assignment1\Assignment1.csproj", "{B24CA810-B8D8-499E-8D91-DA2DC672D033}"
EndProject
Global
GlobalSection(SolutionConfigurationPlatforms) = preSolution
Debug|Any CPU = Debug|Any CPU
Release|Any CPU = Release|Any CPU
EndGlobalSection
GlobalSection(ProjectConfigurationPlatforms) = postSolution
{B24CA810-B8D8-499E-8D91-DA2DC672D033}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
{B24CA810-B8D8-499E-8D91-DA2DC672D033}.Debug|Any CPU.Build.0 = Debug|Any CPU
{B24CA810-B8D8-499E-8D91-DA2DC672D033}.Release|Any CPU.ActiveCfg = Release|Any CPU
{B24CA810-B8D8-499E-8D91-DA2DC672D033}.Release|Any CPU.Build.0 = Release|Any CPU
EndGlobalSection
GlobalSection(SolutionProperties) = preSolution
HideSolutionNode = FALSE
EndGlobalSection
GlobalSection(ExtensibilityGlobals) = postSolution
SolutionGuid = {390CBD4A-CA37-4C8C-ADCF-FDDE8019E4CA}
EndGlobalSection
EndGlobal
Assignment1/Assignment1/.vs/Assignment1/v15/Serve
sqlite3/db.lock
Assignment1/Assignment1/.vs/Assignment1/v15/Serve
sqlite3/storage.ide
Assignment1/Assignment1/.vs/Assignment1/v15/Serve
sqlite3/storage.ide-shm
Assignment1/Assignment1/.vs/Assignment1/v15/Serve
sqlite3/storage.ide-wal
Assignment1/Assignment1/Adoption.cs
using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace Assignment1_1720
{
class Adoption
{
public Client AdoptingClient { get; set; }
public bool Confirmed { get; set; } = true;
public double AdoptionFee { get; set; }
public A
ayList AdoptedPets { get; set; }
public Animal AdoptedPet { get; set; }
public Adoption(Client adoptingClient, bool confirmed)
{
AdoptingClient = adoptingClient;
Confirmed = confirmed;
}
public Adoption(Client adoptingClient, double adoptionFee, Animal adoptedPet)
{
AdoptingClient = adoptingClient;
AdoptionFee = adoptionFee;
AdoptedPet = adoptedPet;
}
public Adoption(Client adoptingClient, double adoptionFee, A
ayList adoptedPets)
{
AdoptingClient = adoptingClient;
AdoptionFee = adoptionFee;
AdoptedPets = adoptedPets;
}
}
}
Assignment1/Assignment1/Animal.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace Assignment1_1720
{
class Animal
{
public double AdoptionFee { get; set; }
public string AnimalID { get; set; }
public bool Adopted { get; set; } = false;
public Animal(double adoptionFee, string animalID)
{
AdoptionFee = adoptionFee;
AnimalID = animalID;
}
}
}
Assignment1/Assignment1/AniMate.cs
using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace Assignment1_1720
{
class AniMate
{
Branch thisBranch;
public AniMate()
{
SetupBranch();
}
public void SetupBranch()
{
thisBranch = new Branch("AniMate Ballarat");
thisBranch.AddAdoptionList("dog", CreateDogs());
thisBranch.AddAdoptionList("cat", CreateCats());
thisBranch.AddAdoptionList("mouse", CreateMice());
thisBranch.AddAdoptionList("hamster", CreateHamsters());
thisBranch.AddAdoptionList("bird", CreateBords());
thisBranch.AddAdoptionList("weasel", CreateWeasels());
}
private A
ayList CreateWeasels()
{
A
ayList weasels = new A
ayList();
CreateAnimalList(weasels, 110.00, "W-PUP", 3);
CreateAnimalList(weasels, 100.00, "W-ADU", 1);
CreateAnimalList(weasels, 50.75, "W-SEN", 4);
return weasels;
}
private A
ayList CreateBords()
{
A
ayList birds = new A
ayList();
CreateAnimalList(birds, 60.00, "B-CHI", 3);
CreateAnimalList(birds, 45.50, "B-ADU", 8);
return birds;
}
private A
ayList CreateHamsters()
{
A
ayList hamsters = new A
ayList();
CreateAnimalList(hamsters, 10.50, "H-PUP", 4);
CreateAnimalList(hamsters, 7.50, "H-ADU", 15);
return hamsters;
}
private A
ayList CreateMice()
{
A
ayList mice = new A
ayList();
CreateAnimalList(mice, 7.90, "M-PUP", 15);
CreateAnimalList(mice, 5.00, "M-ADU", 15);
return mice;
}
private A
ayList CreateCats()
{
A
ayList cats = new A
ayList();
CreateAnimalList(cats, 250.00, "C-KIT", 15);
CreateAnimalList(cats, 210.50, "C-JUN", 26);
CreateAnimalList(cats, 175.90, "C-ADU", 8);
CreateAnimalList(cats, 50.75, "C-SEN", 12);
return cats;
}
private A
ayList CreateDogs()
{
A
ayList dogs = new A
ayList();
CreateAnimalList(dogs, 220.00, "D-PUP", 15);
CreateAnimalList(dogs, 180.00, "D-JUN", 20);
CreateAnimalList(dogs, 150.00, "D-ADU", 12);
CreateAnimalList(dogs, 40.50, "D-SEN", 8);
return dogs;
}
public Adoption AdoptAnimal(string animalType, Client theClient, int numberToAdopt)
{
A
ayList animalList;
animalList = thisBranch.GetAdoptionList(animalType.ToLower());
if (animalList!=null && numberToAdopt>0 && Available(animalList, numberToAdopt))
{
A
ayList adoptedAnimals = new A
ayList();
int cu
entAnimal = 0;
double adoptionFee = 0;
while (numberToAdopt > 0)
{
Animal thisAnimal = (Animal)animalList[cu
entAnimal];
if (!thisAnimal.Adopted)
{
adoptedAnimals.Add(thisAnimal);
adoptionFee += thisAnimal.AdoptionFee;
thisAnimal.Adopted = true;
numberToAdopt--;
}
cu
entAnimal++;
}
return new Adoption(theClient, adoptionFee, adoptedAnimals);
}
else
{
return new Adoption(theClient, false);
}
}
void CreateAnimalList(A
ayList animals, double animalFee, string animalID, int amount)
{
for (int i = 0; i < amount; i++)
{
animals.Add(new Animal(animalFee, animalID + i));
}
}
public bool Available(A
ayList animalList, int number)
{
int availableCount = 0;
for (int i = 0; i < animalList.Count; i++)
{
if (!((Animal)animalList[i]).Adopted)
availableCount++;
}
return number <= availableCount;
}
}
}
Assignment1/Assignment1/App.config
Assignment1/Assignment1/Assignment1.csproj
Debug
AnyCPU
{B24CA810-B8D8-499E-8D91-DA2DC672D033}
Exe
Assignment1_1720
Assignment1-1720
v4.5.2
512
true
AnyCPU
true
full
false
bin\Debug\
DEBUG;TRACE
prompt
4
AnyCPU
pdbonly
true
bin\Release\
TRACE
prompt
4
Assignment1/Assignment1
in/Debug/Assignment1-1720.exe
Assignment1/Assignment1
in/Debug/Assignment1-1720.exe.config
Assignment1/Assignment1
in/Debug/Assignment1-1720.pd
Assignment1/Assignment1/Branch.cs
using System;
using System.Collections.Generic;
using System.Collections;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace Assignment1_1720
{
class Branch
{
Dictionary
ayList> adoptionList = new Dictionary
ayList>();
string name;
public Branch(string name)
{
this.name = name;
}
public void AddAdoptionList(string animalType, A
ayList animals)
{
adoptionList.Add(animalType, animals);
}
public A
ayList GetAdoptionList(string animalType)
{
return adoptionList.ContainsKey(animalType)?adoptionList[animalType]:null;
}
}
}
Assignment1/Assignment1/Client.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace Assignment1_1720
{
class Client
{
public string Lastname { get; set; }
public string Firstname { get; set; }
public string ClientID { get; set; }
public string Address { get; set; }
public string ContactPhone { get; set; }
public string EmailAddress { get; set; }
public Client(string firstname, string lastname, string clientID, string address, string contactPhone, string emailAddress)
{
Firstname = firstname;
Lastname = lastname;
ClientID = clientID;
Address = address;
ContactPhone = contactPhone;
EmailAddress = emailAddress;
}
}
}
Assignment1/Assignment1/obj/Debug/Assignment1-1720.csproj.CoreCompileInputs.cache
ed4adc8f68117860c407585e939f5ee4f05cd46c
Assignment1/Assignment1/obj/Debug/Assignment1-1720.csproj.FileListAbsolute.txt
C:\Users\ameade\Desktop\Work\Courses\ITECH3201\1717-20\Assignment 1\Assignment1-1720\Assignment1-1720\obj\Debug\Assignment1-1720.csprojResolveAssemblyReference.cache
C:\Users\ameade\Desktop\Work\Courses\ITECH3201\1717-20\Assignment 1\Assignment1-1720\Assignment1-1720\bin\Debug\Assignment1-1720.exe.config
C:\Users\ameade\Desktop\Work\Courses\ITECH3201\1717-20\Assignment 1\Assignment1-1720\Assignment1-1720\bin\Debug\Assignment1-1720.exe
C:\Users\ameade\Desktop\Work\Courses\ITECH3201\1717-20\Assignment 1\Assignment1-1720\Assignment1-1720\bin\Debug\Assignment1-1720.pd
C:\Users\ameade\Desktop\Work\Courses\ITECH3201\1717-20\Assignment 1\Assignment1-1720\Assignment1-1720\obj\Debug\Assignment1-1720.exe
C:\Users\ameade\Desktop\Work\Courses\ITECH3201\1717-20\Assignment 1\Assignment1-1720\Assignment1-1720\obj\Debug\Assignment1-1720.pd
C:\Users\visha\Downloads\Assignment1-1720\Assignment1-1720\bin\Debug\Assignment1-1720.exe.config
C:\Users\visha\Downloads\Assignment1-1720\Assignment1-1720\bin\Debug\Assignment1-1720.exe
C:\Users\visha\Downloads\Assignment1-1720\Assignment1-1720\bin\Debug\Assignment1-1720.pd
C:\Users\visha\Downloads\Assignment1-1720\Assignment1-1720\obj\Debug\Assignment1-1720.csprojAssemblyReference.cache
C:\Users\visha\Downloads\Assignment1-1720\Assignment1-1720\obj\Debug\Assignment1-1720.csproj.CoreCompileInputs.cache
C:\Users\visha\Downloads\Assignment1-1720\Assignment1-1720\obj\Debug\Assignment1-1720.exe
C:\Users\visha\Downloads\Assignment1-1720\Assignment1-1720\obj\Debug\Assignment1-1720.pd
Assignment1/Assignment1/obj/Debug/Assignment1-1720.csprojAssemblyReference.cache
Assignment1/Assignment1/obj/Debug/Assignment1-1720.csprojResolveAssemblyReference.cache
Assignment1/Assignment1/obj/Debug/Assignment1-1720.exe
Assignment1/Assignment1/obj/Debug/Assignment1-1720.pd
Assignment1/Assignment1/obj/Debug/Assignment1.csproj.CoreCompileInputs.cache
26e81726588d0809681eb2eefcc5ad8ff6520787
Assignment1/Assignment1/obj/Debug/Assignment1.csproj.FileListAbsolute.txt
C:\Programming\TFTH\33017\My Work\Assignment1\Assignment1\Assignment1\bin\Debug\Assignment1-1720.exe.config
C:\Programming\TFTH\33017\My Work\Assignment1\Assignment1\Assignment1\bin\Debug\Assignment1-1720.exe
C:\Programming\TFTH\33017\My Work\Assignment1\Assignment1\Assignment1\bin\Debug\Assignment1-1720.pd
C:\Programming\TFTH\33017\My Work\Assignment1\Assignment1\Assignment1\obj\Debug\Assignment1.csprojAssemblyReference.cache
C:\Programming\TFTH\33017\My Work\Assignment1\Assignment1\Assignment1\obj\Debug\Assignment1.csproj.CoreCompileInputs.cache
C:\Programming\TFTH\33017\My Work\Assignment1\Assignment1\Assignment1\obj\Debug\Assignment1-1720.exe
C:\Programming\TFTH\33017\My Work\Assignment1\Assignment1\Assignment1\obj\Debug\Assignment1-1720.pd
C:\Programming\TFTH\33091\My Work\Assignment1\Assignment1\obj\Debug\Assignment1.csprojAssemblyReference.cache
C:\Programming\TFTH\33091\My Work\Assignment1\Assignment1\obj\Debug\Assignment1.csproj.CoreCompileInputs.cache
C:\Programming\TFTH\33091\My Work\Assignment1\Assignment1\obj\Debug\Assignment1-1720.exe
C:\Programming\TFTH\33091\My Work\Assignment1\Assignment1\obj\Debug\Assignment1-1720.pd
C:\Programming\TFTH\33091\My Work\Assignment1\Assignment1\bin\Debug\Assignment1-1720.exe.config
C:\Programming\TFTH\33091\My Work\Assignment1\Assignment1\bin\Debug\Assignment1-1720.exe
C:\Programming\TFTH\33091\My Work\Assignment1\Assignment1\bin\Debug\Assignment1-1720.pd
Assignment1/Assignment1/obj/Debug/Assignment1.csprojAssemblyReference.cache
Assignment1/Assignment1/obj/Debug/CoreCompileInputs.cache
97469e789a4e
cc9bdc8725907d9c4c4ca76750
Assignment1/Assignment1/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache
Assignment1/Assignment1/obj/Debug/TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs
Assignment1/Assignment1/obj/Debug/TemporaryGeneratedFile_5937a670-0e60-4077-877b-f7221da3dda1.cs
Assignment1/Assignment1/obj/Debug/TemporaryGeneratedFile_E7A71F73-0F8D-4B9B-B56E-8E70B10BC5D3.cs
Assignment1/Assignment1/Program.cs
using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace Assignment1_1720
{
class Program
{
static void Main(string[] args)
{
AniMate homeFinder = new AniMate();
Client client1 = new Client("Scarlett", "Fields", "C192837", "23 Hiplon Street", "0400111222", "
[email protected]");
Adoption adoption1 = homeFinder.AdoptAnimal("dog", client1, 2);
Console.Write("Congratulations! For the adoption fee of ${0}", adoption1.AdoptionFee);
Console.WriteLine(", Client 1 has been allocated: ");
A
ayList animalList = adoption1.AdoptedPets;
for (int i = 0; i < animalList.Count; i++)
Console.Write("{0}\t", ((Animal)animalList[i]).AnimalID);
Console.WriteLine();
Console.WriteLine();
Client client2 = new Client("Daniel", "Junyard", "309R25Z", "1 Lipold Road", "0400987345", "
[email protected]");
Adoption adoption2 = homeFinder.AdoptAnimal("mouse", client2, 1);
Console.Write("Congratulations! For the adoption fee of ${0}", adoption2.AdoptionFee);
Console.WriteLine(", Client 2 has been allocated: ");
animalList = adoption2.AdoptedPets;
for (int i = 0; i < animalList.Count; i++)
Console.Write("{0}\t", ((Animal)animalList[i]).AnimalID);
Console.WriteLine();
Console.WriteLine();
Client client3 = new Client("Wilma", "Ridley", "BI30192C", "1/16 Caliper Close", "0401825476", "
[email protected]");
Adoption adoption3 = homeFinder.AdoptAnimal("cat", client3, 6);
Console.Write("Congratulations! For the adoption fee of ${0}", adoption3.AdoptionFee);
Console.WriteLine(", Client 3 has been allocated: ");
animalList = adoption3.AdoptedPets;
for (int i = 0; i < animalList.Count; i++)
Console.Write("{0}\t", ((Animal)animalList[i]).AnimalID);
Console.WriteLine();
Console.WriteLine();
Client client4 = new Client("Bo
y", "Reynes", "G3029A2V", "8 Main Road", "0421965328", "
[email protected]");
Adoption adoption4 = homeFinder.AdoptAnimal("dog", client3, 1);
Console.Write("Congratulations! For the adoption fee of ${0}", adoption4.AdoptionFee);
Console.WriteLine(", Client 4 has been allocated: ");
animalList = adoption4.AdoptedPets;
for (int i = 0; i < animalList.Count; i++)
Console.Write("{0}\t", ((Animal)animalList[i]).AnimalID);
Console.WriteLine();
Console.WriteLine();
Console.ReadLine();
}
}
}
Assignment1/Assignment1/Properties/AssemblyInfo.cs
using System.Reflection;
using System.Runtime.CompilerServices;
using System.Runtime.InteropServices;
General Information about an assembly is controlled through the following
set of attributes. Change these attribute values to modify the information
associated with an assembly.
[assembly: AssemblyTitle("Assignment1-1720")]
[assembly: AssemblyDescription("")]
[assembly: AssemblyConfiguration("")]
[assembly: AssemblyCompany("")]
[assembly: AssemblyProduct("Assignment1-1720")]
[assembly: AssemblyCopyright("Copyright © 2017")]
[assembly: AssemblyTrademark("")]
[assembly: AssemblyCulture("")]
Setting ComVisible to false makes the types in this assembly not visible
to COM components. If you need to access a type in this assembly from
COM, set the ComVisible attribute to true on that type.
[assembly: ComVisible(false)]
The following GUID is for the ID of the typelib if this project is exposed to COM
[assembly: Guid("b24ca810-b8d8-499e-8d91-da2dc672d033")]
Version information for an assembly consists of the following four values:
Major Version
Minor Version
Build Numbe
Revision
You can specify all the values or you can default the Build and Revision Numbers
by using the '*' as shown below:
[assembly: AssemblyVersion("1.0.*")]
[assembly: AssemblyVersion("1.0.0.0")]
[assembly: AssemblyFileVersion("1.0.0.0")]
final code base.eapx
Object_ID Name Scope Stereotype Containment IsStatic IsCollection IsOrdered AllowDuplicates LowerBound UpperBound Container Notes Derived ID Pos GenOption Length Precision Scale Const Style Classifier Default Type ea_guid StyleEx
40 thisBranch Private Not Specified 0 0 0 0 1 1 0 27 0 0 0 41 Branch {231B2DE1-75F1-451d-8E8E-84E6D82803AD} volatile=0;union=0;
41 adoptionList Private Not Specified 0 0 0 0 1 1 0 28 0 0 0 0 new Dictionary
ayList>() Dictionary
ayList> {F49C441A-F3A5-42f1-833C-A369B543964E} volatile=0;union=0;
41 name Private Not Specified 0 0 0 0 1 1 0 29 1 0 0 0 string {D1D47D5B-0EED-48b9-9022-156933CE1537} volatile=0;union=0;
Object_ID Constraint AttName Type Notes ID
PropertyID ElementID Property VALUE NOTES ea_guid
AuthorName Roles Notes
Cardinality
*
0
0..*
0..1
1
1..
1..*
CategoryID Name Type NOTES
Name Organisation Phone1 Phone2 Mobile Fax Email Roles Notes
Complexity NumericWeight
Extreme 6
High 4
Low 2
Medium 3
V.High 5
V.Low 1
Connector_ID Name Direction Notes Connector_Type SubType SourceCard SourceAccess SourceElement DestCard DestAccess DestElement SourceRole SourceRoleType SourceRoleNote SourceContainment SourceIsAggregate SourceIsOrdered SourceQualifier DestRole DestRoleType DestRoleNote DestContainment DestIsAggregate DestIsOrdered DestQualifier Start_Object_ID End_Object_ID Top_Start_Label Top_Mid_Label Top_End_Label Btm_Start_Label Btm_Mid_Label Btm_End_Label Start_Edge End_Edge PtStartX PtStartY PtEndX PtEndY SeqNo HeadStyle LineStyle RouteStyle IsBold LineColor Stereotype VirtualInheritance LinkAccess PDATA1 PDATA2 PDATA3 PDATA4 PDATA5 DiagramID ea_guid SourceConstraint DestConstraint SourceIsNavigable DestIsNavigable IsRoot IsLeaf IsSpec SourceChangeable DestChangeable SourceTS DestTS StateFlags ActionFlags IsSignal IsStimulus DispatchAction Target2 StyleEx SourceStereotype DestStereotype SourceStyle DestStyle EventFlags
19 Source -> Destination Association Public Private Private Unspecified 0 0 thisBranch Unspecified 0 0 40 41 thisBranch 0 0 0 0 0 0 0 0 0 3 0 -1 0 0 {38FE557E-E39C-43ec-ACF8-017E649B48A3} false false false false false none none instance instance false false 793967912 Union=0;Derived=0;AllowDuplicates=0;Owned=0;Navigable=Non-Navigable; Union=0;Derived=0;AllowDuplicates=0;Owned=0;Navigable=Navigable;
24 +adoptedPet Source -> Destination Association Public Public Unspecified 0 0 Unspecified 0 0 38 39 +Animal 1 3 269 -221 199 -140 0 0 0 3 0 -1 0 SX=2;SY=0;EX=2;EY=0; 0 {234205C7-355F-4bc4-BD45-6E50CC8E9E37} false false false false false none none instance instance false false 7274566 Union=0;Derived=0;AllowDuplicates=0;Owned=0;Navigable=Unspecified; Union=0;Derived=0;AllowDuplicates=0;Owned=0;Navigable=Navigable;
25 +adoptingClient Source -> Destination Association Public Public Unspecified 0 0 Unspecified 0 0 38 42 +client 3 1 286 -378 220 -485 0 0 0 3 0 -1 0 SX=0;SY=0;EX=0;EY=0; 0 {8C7EA57B-484F-4097-8CCE-12BA075C21F4} false false false false false none none instance instance false false 7012463 Union=0;Derived=0;AllowDuplicates=0;Owned=0;Navigable=Unspecified; Union=0;Derived=0;AllowDuplicates=0;Owned=0;Navigable=Navigable;
12 Returns list of adopted animals Source -> Destination Sequence Public Public Unspecified 0 0 Unspecified 0 0 32 31 Return result of adoption request() 4 2 589 -358 353 -358 5 0 0 1 0 -1 0 Synchronous retval=void; Call 0 SX=0;SY=-49;EX=0;EY=0;$LLB=;LLT=;LMT=CX=153:CY=13:OX=0:OY=0:HDN=0:BLD=0:ITA=0:UND=0:CLR=-1:ALN=0:DIR=0:ROT=0;LMB=;LRT=;LRB=;IRHS=;ILHS=; 5 {535EA95B-45F1-4ede-9FE3-6BA781E42A08} false true false false false none none instance instance false false 0 Union=0;Derived=0;AllowDuplicates=0;Owned=0;Navigable=Non-Navigable; Union=0;Derived=0;AllowDuplicates=0;Owned=0;Navigable=Navigable;
13 Request for required amount and type of animal Source -> Destination Sequence Public Public Unspecified 0 0 Unspecified 0 0 31 32 Request to adopt Animals() 2 4 348 -205 589 -205 2 0 0 1 0 -1 0 Synchronous retval=void; Call 0 SX=0;SY=0;EX=0;EY=0;$LLB=;LLT=;LMT=CX=99:CY=39:OX=60:OY=-27:HDN=0:BLD=0:ITA=0:UND=0:CLR=-1:ALN=0:DIR=0:ROT=0;LMB=;LRT=;LRB=;IRHS=;ILHS=; 5 {523E18E1-C3E5-4816-BBA9-F101C976B3E9} false true false false false none none instance instance Activation=0; false false 0 Union=0;Derived=0;AllowDuplicates=0;Owned=0;Navigable=Non-Navigable; Union=0;Derived=0;AllowDuplicates=0;Owned=0;Navigable=Navigable;
14 Return list of requested animals Source -> Destination Sequence Public Public Unspecified 0 0 Unspecified 0 0 29 32 Return list of requested animals() 4 2 838 -274 604 -274 4 0 0 1 0 -1 0 Synchronous retval=void; Call 0 SX=0;SY=1;EX=0;EY=0;$LLB=;LLT=;LMT=CX=157:CY=13:OX=0:OY=0:HDN=0:BLD=0:ITA=0:UND=0:CLR=-1:ALN=0:DIR=0:ROT=0;LMB=;LRT=;LRB=;IRHS=;ILHS=; 5 {658312E6-99DE-4cc2-AB23-C0A5EC875C9F} false true false false false none none instance instance Activation=0; false false 0 Union=0;Derived=0;AllowDuplicates=0;Owned=0;Navigable=Non-Navigable; Union=0;Derived=0;AllowDuplicates=0;Owned=0;Navigable=Navigable;
15 Request list of required animal Source -> Destination Sequence Public Public Unspecified 0 0 Unspecified 0 0 32 29 Request list of animals() 2 4 599 -240 838 -240 3 0 0 1 0 -1 0 Synchronous retval=void; Call 0 SX=0;SY=0;EX=0;EY=0;$LLB=;LLT=;LMT=CX=112:CY=26:OX=22:OY=-18:HDN=0:BLD=0:ITA=0:UND=0:CLR=-1:ALN=0:DIR=0:ROT=0;LMB=;LRT=;LRB=;IRHS=;ILHS=; 5 {10C11463-831F-4574-AC8B-7FF63E4911C8} false true false false false none none instance instance Activation=0; false false 0 Union=0;Derived=0;AllowDuplicates=0;Owned=0;Navigable=Non-Navigable; Union=0;Derived=0;AllowDuplicates=0;Owned=0;Navigable=Navigable;
16 Return if adoption successful Source -> Destination Sequence Public Public Unspecified 0 0 Unspecified 0 0 31 22 Return the adoption information() 4 2 338 -400 84 -400 6 0 0 1 0 -1 0 Synchronous retval=void; Call 0 SX=0;SY=-7;EX=0;EY=0;$LLB=;LLT=;LMT=CX=142:CY=13:OX=0:OY=0:HDN=0:BLD=0:ITA=0:UND=0:CLR=-1:ALN=0:DIR=0:ROT=0;LMB=;LRT=;LRB=;IRHS=;ILHS=; 5 {BD89406B-73F1-4175-8EA3-77B2C5C3980C} false true false false false none none instance instance false false 0 Union=0;Derived=0;AllowDuplicates=0;Owned=0;Navigable=Non-Navigable; Union=0;Derived=0;AllowDuplicates=0;Owned=0;Navigable=Navigable;
17 Start Process Source -> Destination Sequence Public Public Unspecified 0 0 Unspecified 0 0 22 31 Request to adopt animals() 2 4 79 -170 338 -170 1 0 0 1 0 -1 0 Synchronous retval=void; Call 0 SX=0;SY=-35;EX=0;EY=0;$LLB=;LLT=;LMT=CX=68:CY=13:OX=14:OY=-27:HDN=0:BLD=0:ITA=0:UND=0:CLR=-1:ALN=0:DIR=0:ROT=0;LMB=;LRT=;LRB=;IRHS=;ILHS=; 5 {C79DD8EB-E2A8-4f45-9209-E80C8F0FDEEB} false true false false false none none instance instance Activation=0;ExtendActivationUp=0; false false 0 Union=0;Derived=0;AllowDuplicates=0;Owned=0;Navigable=Non-Navigable; Union=0;Derived=0;AllowDuplicates=0;Owned=0;Navigable=Navigable;
ConnectorID Constraint ConstraintType Notes
PropertyID ElementID Property VALUE NOTES ea_guid
Connector_Type Description
Abstraction Abstraction
Aggregation Aggregation
Assembly Assembly
Association Association
Collaboration Collaboration
CommunicationPath CommunicationPath
Connector Composite Connecto
ControlFlow ControlFlow
Delegate Delegate
Dependency Dependency
Deployment Deployment
ERLink ERLink
Extension Extension
Generalization Generalization
InformationFlow InformationFlow
Instantiation Instantiation
Inte
uptFlow Inte
uptFlow
Manifest Manifest
Nesting Nesting
NoteLink NoteLink
ObjectFlow ObjectFlow
Package Package
ProtocolConformance ProtocolConformance
ProtocolTransition ProtocolTransition
Realisation Realisation
Sequence Sequence
StateFlow StateFlow
Substitution Substitution
Usage Usage
UseCase UseCase
ConstantName ConstantValue
CompanyName Sparx Systems
ECF_EC 1.4
ECF_EWF -0.03
HoursPerUCP 20
ProjectName DOJ
TCF_TC 0.6
TCF_TWF 0.01
Constraint Description Notes
Invariant A state the object must always be in
Post-condition An ending state that must be met
Pre-condition A starting state that must be met
Process A process that must occur
Type ProductName DataType Size MaxLen MaxPrec MaxScale DefaultLen DefaultPrec DefaultScale User PDATA1 PDATA2 PDATA3 PDATA4 HasLength GenericType DatatypeID
DDL Oracle CHAR 1 2000 0 0 1 0 0 0 char 1
DDL Oracle VARCHAR2 1 4000 0 0 50 0 0 0 varchar 2
DDL Oracle VARCHAR 1 4000 0 0 50 0 0 0 varchar 3
DDL Oracle NCHAR 1 2000 0 0 50 0 0 0 nchar 4
DDL Oracle NVARCHAR 1 4000 0 0 50 0 0 0 nvarchar 5
DDL Oracle FLOAT 1 126 0 0 126 0 0 0 float 6
DDL Oracle NUMBER 2 0 38 0 0 8 2 0 number 7
DDL Oracle DATE 0 0 0 0 0 0 0 0 datetime 8
DDL Oracle ROWID 0 0 0 0 0 0 0 0 uniqueidentifier 9
DDL Oracle RAW 1 2000 0 0 2000 0 0 0 binary 10
DDL Oracle LONG RAW 0 0 0 0 0 0 0 0 binary 11
DDL Oracle CLOB 0 0 0 0 0 0 0 0 text 12
DDL Oracle LONG 0 0 0 0 0 0 0 0 long 13
DDL Oracle NCLOB 0 0 0 0 0 0 0 0 ntext 15
DDL Oracle BLOB 0 0 0 0 0 0 0 0 blob 16
DDL Oracle BFILE 0 0 0 0 0 0 0 0 blob 17
DDL SQLServer7 binary 1 8000 0 0 10 0 0 0 binary 18
DDL SQLServer7 bit 0 0 0 0 0 0 0 0 boolean 19
DDL SQLServer7 char 1 8000 0 0 1 0 0 0 char 20
DDL SQLServer7 datetime 0 0 0 0 0 0 0 0 DateTime 21
DDL SQLServer7 decimal 2 0 38 0 0 18 0 0 decimal 22
DDL SQLServer7 float 1 53 0 0 53 0 0 0 float 23
DDL SQLServer7 image 0 0 0 0 0 0 0 0 binary 24
DDL SQLServer7 int 0 0 0 0 0 0 0 0 integer 25
DDL SQLServer7 money 0 0 0 0 0 0 0 0 cu
ency 26
DDL SQLServer7 nchar 1 4000 0 0 10 0 0 0 nchar 27
DDL SQLServer7 ntext 0 0 0 0 0 0 0 0 ntext 28
DDL SQLServer7 nvarchar 1 4000 0 0 50 0 0 0 nvarchar 29
DDL SQLServer7 numeric 2 0 38 0 0 18 0 0 numeric 30
DDL SQLServer7 real 0 0 0 0 0 0 0 0 real 31
DDL SQLServer7 smalldatetime 0 0 0 0 0 0 0 0 datetime 32
DDL SQLServer7 smallint 0 0 0 0 0 0 0 0 smallint 33
DDL SQLServer7 smallmoney 0 0 0 0 0 0 0 0 money 34
DDL SQLServer7 text 0 0 0 0 0 0 0 0 text 35
DDL SQLServer7 timestamp 0 0 0 0 0 0 0 0 timestamp 36
DDL SQLServer7 tinyint 0 0 0 0 0 0 0 0 tinyint 37
DDL SQLServer7 varchar 1 8000 0 0 50 0 0 0 varchar 38
DDL SQLServer7 va
inary 1 8000 0 0 50 0 0 0 va
inary 39
DDL SQLServer7 uniqueidentifier 0 0 0 0 0 0 0 0 uniqueidentifier 40
DDL MSAccess Text 1 255 0 0 50 0 0 0 char 41
DDL MSAccess Memo 0 65535 0 0 0 0 0 0 text 42
DDL MSAccess DateTime 0 0 0 0 0 0 0 0 datetime 43
DDL MSAccess Integer 0 0 0 0 0 0 0 0 integer 45
DDL MSAccess Long 0 0 0 0 0 0 0 0 long 46
DDL MSAccess Single 0 0 7 0 0 0 7 0 float 47
DDL MSAccess Double 0 0 0 0 0 0 0 0 double 48
DDL MSAccess Counter 0 0 0 0 0 0 0 0 counter 49
DDL MSAccess YesNo 0 0 0 0 0 0 0 0 boolean 50
Code Visual Basic Boolean 0 0 0 0 0 0 0 0 Boolean 51
Code Visual Basic Byte 0 0 0 0 0 0 0 0 Byte 52
Code Visual Basic Cu
ency 0 0 0 0 0 0 0 0 Cu
ency 53
Code Visual Basic Date 0 0 0 0 0 0 0 0 DateTime 54
Code Visual Basic Double 0 0 0 0 0 0 0 0 Double 55
Code Visual Basic Integer 0 0 0 0 0 0 0 0 Integer 56
Code Visual Basic Long 0 0 0 0 0 0 0 0 Long 57
Code Visual Basic Object 0 0 0 0 0 0 0 0 58
Code Visual Basic Single 0 0 0 0 0 0 0 0 59
Code Visual Basic String 0 0 0 0 0 0 0 0 String 60
Code Visual Basic Variant 0 0 0 0 0 0 0 0 Variant 61
Code C++ char 0 0 0 0 0 0 0 0 Char 62
Code C++ int 0 0 0 0 0 0 0 0 Integer 63
Code C++ short 0 0 0 0 0 0 0 0 Short 64
Code C++ long 0 0 0 0 0 0 0 0 Long 65
Code C++ float 0 0 0 0 0 0 0 0 Float 66
Code C++ double 0 0 0 0 0 0 0 0 Double 67
Code C++ void 0 0 0 0 0 0 0 0 68
Code C++ unsigned char 0 0 0 0 0 0 0 0 69
Code C++ unsigned int 0 0 0 0 0 0 0 0 Uint 70
Code C++ unsigned short 0 0 0 0 0 0 0 0 71
Code C++ unsigned long 0 0 0 0 0 0 0 0 Ulong 72
Code Java byte 0 0 0 0 0 0 0 0 Byte 73
Code Java char 0 0 0 0 0 0 0 0 Char 74
Code Java int 0 0 0 0 0 0 0 0 Integer 75
Code Java short 0 0 0 0 0 0 0 0 Short 76
Code Java boolean 0 0 0 0 0 0 0 0 Boolean 77
Code Java long 0 0 0 0 0 0 0 0 Long 78
Code Java float 0 0 0 0 0 0 0 0 Float 79
Code Java double 0 0 0 0 0 0 0 0 Double 80
Code Delphi Boolean 0 0 0 0 0 0 0 0 Boolean 81
Code Delphi Byte 0 0 0 0 0 0 0 0 Byte 82
Code Delphi Cardinal 0 0 0 0 0 0 0 0 83
Code Delphi Char 0 0 0 0 0 0 0 0 Char 84
Code Delphi Cu
ency 0 0 0 0 0 0 0 0 Cu
ency 85
Code Delphi Double 0 0 0 0 0 0 0 0 Double 86
Code Delphi Extended 0 0 0 0 0 0 0 0 87
Code Delphi Integer 0 0 0 0 0 0 0 0 Integer 88
Code Delphi LongInt 0 0 0 0 0 0 0 0 89
Code Delphi LongWord 0 0 0 0 0 0 0 0 Ulong 90
Code Delphi Single 0 0 0 0 0 0 0 0 91
Code Delphi ShortInt 0 0 0 0 0 0 0 0 92
Code Delphi SmallInt 0 0 0 0 0 0 0 0 93
Code Delphi String 0 0 0 0 0 0 0 0 String 94
Code Delphi Real 0 0 0 0 0 0 0 0 95
Code Delphi Variant 0 0 0 0 0 0 0 0 Variant 96
Code Delphi Word 0 0 0 0 0 0 0 0 Word 98
Code C# void 0 0 0 0 0 0 0 0 99
Code C# sbyte 0 0 0 0 0 0 0 0 100
Code C# byte 0 0 0 0 0 0 0 0 Byte 101
Code C# short 0 0 0 0 0 0 0 0 Short 102
Code C# ushort 0 0 0 0 0 0 0 0 Ushort 103
Code C# int 0 0 0 0 0 0 0 0 Integer 104
Code C# uint 0 0 0 0 0 0 0 0 Uint 105
Code C# long 0 0 0 0 0 0 0 0 Long 106
Code C# ulong 0 0 0 0 0 0 0 0 Ulong 107
Code C# char 0 0 0 0 0 0 0 0 Char 108
Code C# float 0 0 0 0 0 0 0 0 Float 109
Code C# double 0 0 0 0 0 0 0 0 Double 110
Code C# bool 0 0 0 0 0 0 0 0 Boolean 111
Code C# decimal 0 0 0 0 0 0 0 0 Float 112
Code VBNet Integer 0 0 0 0 0 0 0 0 Integer 113
Code VBNet String 0 0 0 0 0 0 0 0 String 114
Code VBNet Short 0 0 0 0 0 0 0 0 Short 115
Code VBNet Long 0 0 0 0 0 0 0 0 Long 116
Code VBNet Char 0 0 0 0 0 0 0 0 Char 117
Code VBNet Byte 0 0 0 0 0 0 0 0 Byte 118
Code VBNet Boolean 0 0 0 0 0 0 0 0 Boolean 119
Code VBNet Double 0 0 0 0 0 0 0 0 Double 120
Code VBNet Date 0 0 0 0 0 0 0 0 Date 121
Code VBNet Object 0 0 0 0 0 0 0 0 122
Code VBNet Single 0 0 0 0 0 0 0 0 Single 123
Code VBNet Datetime 0 0 0 0 0 0 0 0 DateTime 124
Code VBNet Decimal 0 0 0 0 0 0 0 0 125
DDL DB2 BIGINT 0 0 0 0 0 0 0 0 bigint 126
DDL DB2 CHARACTER 1 254 0 0 10 0 0 0 char 128
DDL DB2 DATE 0 0 0 0 0 0 0 0 date 130
DDL DB2 DECIMAL 2 31 31 0 0 5 0 0 decimal 131
DDL DB2 DOUBLE 0 0 0 0 0 0 0 0 double 132
DDL DB2 INTEGER 0 0 0 0 0 0 0 0 integer 133
DDL DB2 LONG VARCHAR 0 0 0 0 0 0 0 0 text 134
DDL DB2 REAL 0 0 0 0 0 0 0 0 real 135
DDL DB2 TIME 0 0 0 0 0 0 0 0 time 137
DDL DB2 TIMESTAMP 0 0 0 0 0 0 0 0 timestamp 138
DDL MySql BIT 1 64 0 0 1 0 0 0 bit 140
DDL MySql BOOL 0 0 0 0 0 0 0 0 boolean 141
DDL MySql TINYINT 0 0 0 0 0 0 0 0 tinyint 142
DDL MySql SMALLINT 0 0 0 0 0 0 0 0 smallint 143
DDL MySql INTEGER 0 0 0 0 0 0 0 0 integer 144
DDL MySql MEDIUMINT 0 0 0 0 0 0 0 0 mediumint 145
DDL MySql BIGINT 0 0 0 0 0 0 0 0 bigint 146
DDL MySql FLOAT 2 0 24 0 0 0 0 0 float 147
DDL MySql DOUBLE 2 0 53 30 0 10 2 0 double 148
DDL MySql DOUBLE PRECISION 2 0 53 30 0 10 2 0 double 149
DDL MySql REAL 2 0 53 30 0 10 2 0 real 150
DDL MySql NUMERIC 2 0 65 30 0 10 2 0 numeric 151
DDL MySql DECIMAL 2 0 65 30 0 10 2 0 decimal 152
DDL MySql DATE 0 0 0 0 0 0 0 0 date 153
DDL MySql DATETIME 1 6 0 0 0 0 0 0 datetime 154
DDL MySql TIME 1 6 0 0 0 0 0 0 time 155
DDL MySql TIMESTAMP 1 6 0 0 0 0 0 0 timestamp 156
DDL MySql CHAR 1 255 0 0 10 0 0 0 char 157
DDL MySql VARCHAR 1 65535 0 0 50 0 0 0 varchar 158
DDL MySql BLOB 0 0 0 0 0 0 0 0 blob 159
DDL MySql TEXT 0 0 0 0 0 0 0 0 text 160
DDL SQL Server 2000 decimal 2 38 38 38 0 10 2 0 decimal 161
DDL SQL Server 2000 sql_variant 0 0 0 0 0 0 0 0 sqlvariant 162
DDL SQL Server 2000 numeric 2 38 38 38 0 10 2 0 numeric 163
DDL SQL Server 2000 va
inary 1 8000 0 0 50 0 0 0 va
inary 164
DDL SQL Server 2000 bit 0 0 0 0 0 0 0 0 boolean 165
DDL InterBase integer 0 0 0 0 10 0 0 0 integer 167
DDL InterBase smallint 0 0 0 0 10 0 0 0 smallint 168
DDL MySql NCHAR 1 255 0 0 10 0 0 0 nchar 169
DDL InterBase timestamp 0 0 0 0 0 0 0 0 datetime 170
DDL PostgreSQL real 1 53 0 0 53 0 0 0 real 171
DDL SQL Server 2000 char 1 8000 0 0 10 0 0 0 char 174
DDL SQL Server 2000 timestamp 0 0 0 0 0 0 0 0 timestamp 175
DDL InterBase double precision 0 0 0 0 0 0 0 0 double 178
DDL SQL Server 2000 binary 1 8000 0 0 10 0 0 0 Binary 179
DDL SQL Server 2000 image 0 0 0 0 0 0 0 0 blob 180
DDL SQL Server 2000 nvarchar 1 4000 0 0 50 0 0 0 nvarchar 181
DDL SQL Server 2000 smalldatetime 0 0 0 0 0 0 0 0 datetime 182
DDL PostgreSQL numeric 2 0 1000 1000 0 0 0 0 numeric 183
DDL DB2 FLOAT 0 0 0 0 0 0 0 0 float 184
DDL PostgreSQL integer 0 0 0 0 0 0 0 0 integer 185
DDL PostgreSQL varchar 1 1048576 0 0 50 0 0 0 varchar 186
DDL InterBase blob sub_type 0 0 0 0 0 0 0 0 0 blob 188
DDL SQL Server 2000 money 0 0 0 0 0 19 4 0 cu
ency 190
DDL SQL Server 2000 ntext 0 0 0 0 0 0 0 0 ntext 191
DDL SQL Server 2000 uniqueidentifier 0 0 0 0 0 0 0 0 guid 192
DDL PostgreSQL bigint 0 0 0 0 0 0 0 0 bigint 195
DDL DB2 SMALLINT 0 0 0 0 0 0 0 0 smallint 196
DDL MSAccess OLEObject 0 0 0 0 0 0 0 0 blob 199
DDL SQL Server 2000 int 0 0 0 0 0 0 0 0 integer 201
DDL SQL Server 2000 datetime 0 0 0 0 0 0 0 0 datetime 203
DDL SQL Server 2000 float 0 53 0 0 53 0 0 0 float 204
DDL SQL Server 2000 nchar 1 4000 0 0 10 0 0 0 nchar 205
DDL Oracle NVARCHAR2 1 4000 0 0 50 0 0 0 nvarchar 206
DDL InterBase varchar 1 32767 0 0 50 0 0 0 varchar 209
DDL MSAccess Byte 0 0 0 0 0 0 0 0 tinyint 210
DDL SQL Server 2000 real 0 53 0 0 53 0 0 0 double 211
DDL SQL Server 2000 text 0 0 0 0 0 0 0 0 text 212
DDL SQL Server 2000 tinyint 0 0 0 0 0 0 0 0 tinyint 213
DDL PostgreSQL smallint 0 0 0 0 0 0 0 0 smallint 214
DDL SQL Server 2000 smallint 0 0 0 0 0 0 0 0 smallint 216
DDL SQL Server 2000 varchar 1 8000 0 0 50 0 0 0 varchar 217
DDL DB2 CHAR 1 254 0 0 10 0 0 0 char 218
DDL PostgreSQL char 1 1048576 0 0 1 0 0 0 char 219
DDL PostgreSQL decimal 2 0 1000 1000 0 0 0 0 decimal 220
DDL PostgreSQL text 0 0 0 0 0 0 0 0 text 221
DDL SQL Server 2000 bigint 0 0 0 0 0 0 0 0 bigint 222
DDL SQL Server 2000 smallmoney 0 0 0 0 0 0 0 0 money 226
DDL InterBase blob sub_type 1 0 0 0 0 0 0 0 0 text 227
DDL InterBase char 1 32767 0 0 10 0 0 0 char 228
DDL PostgreSQL boolean 0 0 0 0 0 0 0 0 boolean 230
DDL PostgreSQL timestamp 1 6 0 0 0 0 0 0 datetime 231
DDL MySql NVARCHAR 1 65535 0 0 50 0 0 0 nvarchar 232
DDL PostgreSQL bytea 0 0 0 0 0 0 0 0 blob 233
DDL InterBase decimal 2 0 64 64 0 10 2 0 decimal 235
Code PHP var 0 0 1 var 236
Code C# string 0 0 1 String 237
Code C++ wchar_t 0 0 1 Char 238
Code C++ bool 0 0 1 Boolean 239
DDL Sybase ASE tinyint 0 0 0 0 0 0 0 0 tinyint 240
DDL Sybase ASE smallint 0 0 0 0 0 0 0 0 smallint 241
DDL Sybase ASE int 0 0 0 0 0 0 0 0 integer 242
DDL Sybase ASE numeric 2 0 38 38 0 18 0 0 numeric 243
DDL Sybase ASE decimal 2 0 38 38 0 18 0 0 decimal 244
DDL Sybase ASE float 0 0 0 0 0 0 0 0 float 245
DDL Sybase ASE double precision 0 0 0 0 0 0 0 0 double 246
DDL Sybase ASE real 0 0 0 0 0 0 0 0 real 247
DDL Sybase ASE smallmoney 0 0 0 0 0 0 0 0 money 248
DDL Sybase ASE money 0 0 0 0 0 0 0 0 money 249
DDL Sybase ASE smalldatetime 0 0 0 0 0 0 0 0 datetime 250
DDL Sybase ASE datetime 0 0 0 0 0 0 0 0 datetime 251
DDL Sybase ASE char 1 16384 0 0 50 0 0 0 char 252
DDL Sybase ASE varchar 1 16384 0 0 100 0 0 0 varchar 253
DDL Sybase ASE unichar 1 0 0 0 50 0 0 0 char 254
DDL Sybase ASE univarchar 1 0 0 0 50 0 0 0 varchar 255
DDL Sybase ASE nchar 1 16384 0 0 50 0 0 0 nchar 256
DDL Sybase ASE nvarchar 1 16384 0 0 50 0 0 0 nvarchar 257
DDL Sybase ASE text 0 0 0 0 50 0 0 0 text 258
DDL Sybase ASE binary 1 255 0 0 1 0 0 0 binary 259
DDL Sybase ASE image 0 0 0 0 0 0 0 0 blob 261
DDL Sybase ASE bit 0 0 0 0 0 0 0 0 boolean 262
DDL Informix INTEGER 0 0 0 0 0 0 0 0 integer 263
DDL Informix INT 0 0 0 0 0 0 0 0 integer 264
DDL Informix SMALLINT 0 0 0 0 0 0 0 0 smallint 265
DDL Informix INT8 0 0 0 0 0 0 0 0 bigint 266
DDL Informix SERIAL 0 0 0 0 0 0 0 0 integer 267
DDL Informix SERIAL8 0 0 0 0 0 0 0 0 integer 268
DDL Informix FLOAT 0 0 0 0 0 0 0 0 float 269
DDL Informix SMALLFLOAT 0 4 0 0 4 0 0 0 float 270
DDL Informix DECIMAL 2 0 32 32 0 8 3 0 decimal 271
DDL Informix DEC 2 0 32 32 0 8 3 0 decimal 272
DDL Informix MONEY 2 0 32 3 0 8 3 0 money 273
DDL Informix DATE 0 0 0 0 0 0 0 0 date 274
DDL Informix DATETIME HOUR TO MINUTE 0 0 0 0 0 0 0 0 datetime 275
DDL Informix DATETIME YEAR TO YEAR 0 0 0 0 0 0 0 0 datetime 276
DDL Informix DATETIME YEAR TO MONTH 0 0 0 0 0 0 0 0 datetime 277
DDL Informix DATETIME YEAR TO DAY 0 0 0 0 0 0 0 0 datetime 278
DDL Informix DATETIME YEAR TO HOUR 0 0 0 0 0 0 0 0 datetime 279
DDL Informix DATETIME YEAR TO MINUTE 0 0 0 0 0 0 0 0 datetime 280
DDL Informix DATETIME YEAR TO SECOND 0 0 0 0 0 0 0 0 datetime 281
DDL Informix DATETIME YEAR TO FRACTION 1 5 0 0 3 0 0 0 datetime 282
DDL Informix DATETIME MONTH TO MONTH 0 0 0 0 0 0 0 0 datetime 283
DDL Informix DATETIME MONTH TO DAY 0 0 0 0 0 0 0 0 datetime 284
DDL Informix DATETIME MONTH TO HOUR 0 0 0 0 0 0 0 0 datetime 285
DDL Informix DATETIME MONTH TO MINUTE 0 0 0 0 0 0 0 0 datetime 286
DDL Informix DATETIME MONTH TO SECOND 0 0 0 0 0 0 0 0 datetime 287
DDL Informix DATETIME MONTH TO FRACTION 1 5 0 0 3 0 0 0 datetime 288
DDL Informix DATETIME DAY TO DAY 0 0 0 0 0 0 0 0 datetime 289
DDL Informix DATETIME DAY TO HOUR 0 0 0 0 0 0 0 0 datetime 290
DDL Informix DATETIME DAY TO MINUTE 0 0 0 0 0 0 0 0 datetime 291
DDL Informix DATETIME DAY TO SECOND 0 0 0 0 0 0 0 0 datetime 292
DDL Informix DATETIME DAY TO FRACTION 1 5 0 0 3 0 0 0 datetime 293
DDL Informix DATETIME HOUR TO HOUR 0 0 0 0 0 0 0 0 datetime 294
DDL Informix DATETIME HOUR TO FRACTION 1 5 0 0 3 0 0 0 datetime 295
DDL Informix DATETIME HOUR TO SECOND 0 0 0 0 0 0 0 0 datetime 296
DDL Informix DATETIME MINUTE TO MINUTE 0 0 0 0 0 0 0 0 datetime 297
DDL Informix DATETIME MINUTE TO SECOND 0 0 0 0 0 0 0 0 datetime 298
DDL Informix DATETIME MINUTE TO FRACTION 1 5 0 0 3 0 0 0 datetime 299
DDL Informix DATETIME SECOND TO SECOND 0 0 0 0 0 0 0 0 datetime 300
DDL Informix DATETIME SECOND TO FRACTION 1 5 0 0 3 0 0 0 datetime 301
DDL Informix DATETIME FRACTION TO FRACTION 1 5 0 0 3 0 0 0 datetime 302
DDL Informix BOOLEAN 0 0 0 0 0 0 0 0 boolean 303
DDL Informix CHAR 1 32767 0 0 10 0 0 0 char 304
DDL Informix CHARACTER 1 32767 0 0 10 0 0 0 char 305
DDL Informix NCHAR 1 32767 0 0 50 0 0 0 nchar 306
DDL Informix CHARACTER VARYING 1 255 0 0 0 0 0 0 char 307
DDL Informix VARCHAR 1 255 0 0 10 0 0 0 varchar 308
DDL Informix NVARCHAR 1 255 0 0 50 0 0 0 nvarchar 309
DDL Informix LVARCHAR 1 32767 0 0 2048 0 0 0 char 310
DDL Informix TEXT 0 0 0 0 0 0 0 0 text 311
DDL Informix BYTE 0 0 0 0 0 0 0 0 Binary 312
DDL Informix BLOB 0 0 0 0 0 0 0 0 blob 313
DDL Informix CLOB 0 0 0 0 0 0 0 0 ntext 314
DDL Ingres ansidate 0 0 0 0 0 0 0 0 ansidate 315
DDL Ingres bigint 0 0 0 0 0 0 0 0 bigint 316
DDL Ingres byte 1 32000 0 0 0 0 0 0 Binary 317
DDL Ingres byte var 1 32000 0 0 0 0 0 0 Binary 318
DDL Ingres c 1 32000 0 0 0 0 0 0 char 319
DDL Ingres char 1 32000 0 0 0 0 0 0 char 320
DDL Ingres date 0 0 0 0 0 0 0 0 date 321
DDL Ingres decimal 2 0 31 10 0 5 0 0 decimal 322
DDL Ingres float 1 53 0 0 8 0 0 0 float 323
DDL Ingres float4 0 0 0 0 0 0 0 0 real 324
DDL Ingres float8 0 0 0 0 0 0 0 0 float 325
DDL Ingres ingresdate 0 0 0 0 0 0 0 0 date 326
DDL Ingres int1 0 0 0 0 0 0 0 0 integer1 327
DDL Ingres int2 0 0 0 0 0 0 0 0 smallint 328
DDL Ingres int4 0 0 0 0 0 0 0 0 int 329
DDL Ingres int8 0 0 0 0 0 0 0 0 bigint 330
DDL Ingres integer 0 0 0 0 0 0 0 0 integer 331
DDL Ingres interval day to second 0 0 0 0 0 0 0 0 interval day to second 332
DDL Ingres interval year to month 0 0 0 0 0 0 0 0 interval year to month 333
DDL Ingres long byte 0 0 0 0 0 0 0 0 long byte 334
DDL Ingres long nvarchar 0 0 0 0 0 0 0 0 long nvarchar 335
DDL Ingres long varchar 0 0 0 0 0 0 0 0 long varchar 336
DDL Ingres money 0 0 0 0 0 0 0 0 money 337
DDL Ingres nchar 1 16000 0 0 0 0 0 0 nchar 338
DDL Ingres nvarchar 1 16000 0 0 0 0 0 0 nvarchar 339
DDL Ingres Object Key 0 0 0 0 0 0 0 0 OBJECT_KEY 340
DDL Ingres Table Key 0 0 0 0 0 0 0 0 TABLE_KEY 341
DDL Ingres text 1 32000 0 0 0 0 0 0 text 342
DDL Ingres time with local time zone 0 0 0 0 0 0 0 0 time 343
DDL Ingres time with time zone 0 0 0 0 0 0 0 0 time 344
DDL Ingres time without time zone 0 0 0 0 0 0 0 0 TABLE_KEY 345
DDL Ingres timestamp with local time zone 0 0 0 0 0 0 0 0 timestampt 346
DDL Ingres timestamp with time zone 0 0 0 0 0 0 0 0 timestampt 347
DDL Ingres timestamp without time zone 0 0 0 0 0 0 0 0 timestampt 348
DDL Ingres varchar 1 32000 0 0 0 0 0 0 varchar 349
DDL SQL Server 2005 bigint 0 0 0 0 0 0 0 0 bigint 350
DDL SQL Server 2005 int 0 0 0 0 0 0 0 0 integer 351
DDL SQL Server 2005 smallint 0 0 0 0 0 0 0 0 smallint 352
DDL SQL Server 2005 tinyint 0 0 0 0 0 0 0 0 tinyint 353
DDL SQL Server 2005 bit 0 0 0 0 0 0 0 0 boolean 354
DDL SQL Server 2005 decimal 2 38 38 38 0 10 2 0 decimal 355
DDL SQL Server 2005 numeric 2 38 38 38 0 10 2 0 numeric 356
DDL SQL Server 2005 money 0 0 0 0 0 19 4 0 cu
ency 357
DDL SQL Server 2005 smallmoney 0 0 0 0 0 0 0 0 money 358
DDL SQL Server 2005 float 0 53 0 0 53 0 0 0 float 359
DDL SQL Server 2005 real 0 53 0 0 53 0 0 0 double 360
DDL SQL Server 2005 datetime 0 0 0 0 0 0 0 0 datetime 361
DDL SQL Server 2005 smalldatetime 0 0 0 0 0 0 0 0 datetime 362
DDL SQL Server 2005 char 1 8000 0 0 10 0 0 0 char 363
DDL SQL Server 2005 varchar 1 8000 0 0 50 0 0 0 varchar 364
DDL SQL Server 2005 text 0 0 0 0 0 0 0 0 text 365
DDL SQL Server 2005 nchar 1 4000 0 0 10 0 0 0 nchar 366
DDL SQL Server 2005 nvarchar 1 4000 0 0 50 0 0 0 nvarchar 367
DDL SQL Server 2005 ntext 0 0 0 0 0 0 0 0 ntext 368
DDL SQL Server 2005 binary 1 8000 0 0 10 0 0 0 Binary 369
DDL SQL Server 2005 va
inary 1 8000 0 0 50 0 0 0 va
inary 370
DDL SQL Server 2005 image 0 0 0 0 0 0 0 0 blob 371
DDL SQL Server 2005 sql_variant 0 0 0 0 0 0 0 0 sqlvariant 372
DDL SQL Server 2005 timestamp 0 0 0 0 0 0 0 0 timestamp 373
DDL SQL Server 2005 uniqueidentifier 0 0 0 0 0 0 0 0 guid 374
DDL SQL Server 2005 xml 0 0 0 0 0 0 0 0 text 375
DDL Informix INTERVAL YEAR TO YEAR 0 9 0 0 0 0 0 0 interval 376
DDL Informix INTERVAL YEAR TO MONTH 0 9 0 0 0 0 0 0 interval 377
DDL Informix INTERVAL MONTH TO MONTH 0 9 0 0 0 0 0 0 interval 378
DDL Informix INTERVAL DAY TO DAY 0 9 0 0 0 0 0 0 interval 379
DDL Informix INTERVAL DAY TO HOUR 0 9 0 0 0 0 0 0 interval 380
DDL Informix INTERVAL DAY TO MINUTE 0 9 0 0 0 0 0 0 interval 381
DDL Informix INTERVAL DAY TO SECOND 0 9 0 0 0 0 0 0 interval 382
DDL Informix INTERVAL DAY TO FRACTION 1 5 0 0 0 0 0 0 interval 383
DDL Informix INTERVAL HOUR TO HOUR 0 9 0 0 0 0 0 0 interval 384
DDL Informix INTERVAL HOUR TO MINUTE 0 9 0 0 0 0 0 0 interval 385
DDL Informix INTERVAL HOUR TO SECOND 0 9 0 0 0 0 0 0 interval 386
DDL Informix INTERVAL HOUR TO FRACTION 1 5 0 0 0 0 0 0 interval 387
DDL Informix INTERVAL MINUTE TO MINUTE 0 9 0 0 0 0 0 0 interval 388
DDL Informix INTERVAL MINUTE TO SECOND 0 9 0 0 0 0 0 0 interval 389
DDL Informix INTERVAL MINUTE TO FRACTION 1 5 0 0 0 0 0 0 interval 390
DDL Informix INTERVAL SECOND TO SECOND 0 9 0 0 0 0 0 0 interval 391
DDL Informix INTERVAL SECOND TO FRACTION 1 5 0 0 0 0 0 0 interval 392
DDL Informix INTERVAL FRACTION TO FRACTION 1 5 0 0 0 0 0 0 interval 393
DDL SQL Server 2005 varchar(max) 0 0 0 0 0 0 0 0 varchar 394
DDL SQL Server 2005 va
inary(max) 0 0 0 0 0 0 0 0 va
inary 395
DDL SQL Server 2008 bigint 0 0 0 0 0 0 0 0 bigint 396
DDL SQL Server 2008 bit 0 0 0 0 0 0 0 0 boolean 397
DDL SQL Server 2008 decimal 2 38 38 38 0 10 2 0 decimal 398
DDL SQL Server 2008 int 0 0 0 0 0 0 0 0 integer 399
DDL SQL Server 2008 money 0 0 0 0 0 19 4 0 cu
ency 400
DDL SQL Server 2008 numeric 2 38 38 38 0 10 2 0 numeric 401
DDL SQL Server 2008 smallint 0 0 0 0 0 0 0 0 smallint 402
DDL SQL Server 2008 smallmoney 0 0 0 0 0 0 0 0 money 403
DDL SQL Server 2008 tinyint 0 0 0 0 0 0 0 0 tinyint 404
DDL SQL Server 2008 float 0 53 0 0 53 0 0 0 float 405
DDL SQL Server 2008 real 0 53 0 0 53 0 0 0 double 406
DDL SQL Server 2008 date 0 0 0 0 0 0 0 0 date 407
DDL SQL Server 2008 datetime2 1 7 0 0 7 0 0 0 datetime 408
DDL SQL Server 2008 datetime 0 0 0 0 0 0 0 0 datetime 409
DDL SQL Server 2008 datetimeoffset 1 7 0 0 7 0 0 0 datetime 410
DDL SQL Server 2008 smalldatetime 0 0 0 0 0 0 0 0 datetime 411
DDL SQL Server 2008 time 1 7 0 0 7 0 0 0 time 412
DDL SQL Server 2008 char 1 8000 0 0 10 0 0 0 char 413
DDL SQL Server 2008 varchar 1 8000 0 0 50 0 0 0 varchar 414
DDL SQL Server 2008 varchar(max) 0 0 0 0 0 0 0 0 varchar 415
DDL SQL Server 2008 text 0 0 0 0 0 0 0 0 text 416
DDL SQL Server 2008 nchar 1 4000 0 0 10 0 0 0 nchar 417
DDL SQL Server 2008 nvarchar 1 4000 0 0 50 0 0 0 nvarchar 418
DDL SQL Server 2008 nvarchar(max) 0 0 0 0 0 0 0 0 varchar 419
DDL SQL Server 2008 ntext 0 0 0 0 0 0 0 0 ntext 420
DDL SQL Server 2008 binary 1 8000 0 0 10 0 0 0 Binary 421
DDL SQL Server 2008 va
inary 1 8000 0 0 50 0 0 0 va
inary 422
DDL SQL Server 2008 va
inary(max) 0 0 0 0 0 0 0 0 va
inary 423
DDL SQL Server 2008 image 0 0 0 0 0 0 0 0 blob 424
DDL SQL Server 2008 timestamp 0 0 0 0 0 0 0 0 timestamp 425
DDL SQL Server 2008 uniqueidentifier 0 0 0 0 0 0 0 0 guid 426
DDL SQL Server 2008 sql_variant 0 0 0 0 0 0 0 0 sqlvariant 427
DDL SQL Server 2008 xml 0 0 0 0 0 0 0 0 text 428
DDL SQL Server 2008 hierarchyid 0 0 0 0 0 0 0 0 text 429
DDL SQL Server 2008 geometry 0 0 0 0 0 0 0 0 text 430
DDL SQL Server 2008 geography 0 0 0 0 0 0 0 0 text 431
DDL MSAccess 2007 Text 1 255 0 0 50 0 0 0 char 432
DDL MSAccess 2007 Memo 0 0 0 0 0 0 0 0 text 433
DDL MSAccess 2007 DateTime 0 0 0 0 0 0 0 0 datetime 434
DDL MSAccess 2007 Cu
ency 0 0 0 0 0 0 0 0 cu
ency 435
DDL MSAccess 2007 Integer 0 0 0 0 0 0 0 0 integer 436
DDL MSAccess 2007 Long 0 0 0 0 0 0 0 0 long 437
DDL MSAccess 2007 Single 0 0 0 0 0 0 0 0 float 438
DDL MSAccess 2007 Double 0 0 0 0 0 0 0 0 double 439
DDL MSAccess 2007 Counter 0 0 0 0 0 0 0 0 counter 440
DDL MSAccess 2007 YesNo 0 0 0 0 0 0 0 0 boolean 441
DDL MSAccess 2007 OLEObject 0 0 0 0 0 0 0 0 blob 442
DDL MSAccess 2007 Byte 0 0 0 0 0 0 0 0 tinyint 443
DDL MSAccess 2007 Decimal 0 0 0 0 0 0 0 0 decimal 445
DDL SQLite INTEGER 0 0 0 0 0 0 0 0 integer 447
DDL SQLite NUMERIC 0 0 0 0 0 0 0 0 numeric 448
DDL SQLite TEXT 0 0 0 0 0 0 0 0 text 449
DDL SQLite NONE 0 0 0 0 0 0 0 0 blob 450
DDL SQLite REAL 0 0 0 0 0 0 0 0 real 451
DDL InterBase numeric 2 0 64 64 0 10 2 0 numeric 452
DDL InterBase float 0 0 0 0 0 0 0 0 float 453
DDL Oracle BINARY_FLOAT 0 0 0 0 0 0 0 0 float 454
DDL Oracle BINARY_DOUBLE 0 0 0 0 0 0 0 0 double 455
DDL Oracle TIMESTAMP 1 9 0 0 6 0 0 0 timestamp 456
DDL Oracle TIMESTAMP WITH TIME ZONE 1 9 0 0 6 0 0 0 timestamp with time zone 457
DDL Oracle TIMESTAMP WITH LOCAL TIME ZONE 1 9 0 0 6 0 0 0 timestamp with local time zone 458
DDL Oracle INTERVAL YEAR TO MONTH 1 9 0 0 2 0 0 0 interval year to month 459
DDL Oracle INTERVAL DAY TO SECOND 2 0 9 9 0 2 6 0 interval day to second 460
DDL Oracle ANYDATA 0 0 0 0 0 0 0 0 text 461
DDL Oracle ANYTYPE 0 0 0 0 0 0 0 0 text 462
DDL Oracle ANYDATASET 0 0 0 0 0 0 0 0 text 463
DDL Oracle URITYPE 0 0 0 0 0 0 0 0 uri 464
DDL Oracle DBURITYPE 0 0 0 0 0 0 0 0 uri 465
DDL Oracle XDBURITYPE 0 0 0 0 0 0 0 0 uri 466
DDL Oracle HTTPURITYPE 0 0 0 0 0 0 0 0 uri 467
DDL Oracle XMLTYPE 0 0 0 0 0 0 0 0 xml 468
DDL Oracle SDO_GEOMETRY 0 0 0 0 0 0 0 0 spatial 469
DDL Oracle SDO_TOPO_GEOMETRY 0 0 0 0 0 0 0 0 spatial 470
DDL Oracle SDO_GEORASTER 0 0 0 0 0 0 0 0 spatial 471
DDL Oracle ORDAUDIO 0 0 0 0 0 0 0 0 media 472
DDL Oracle ORDIMAGE 0 0 0 0 0 0 0 0 media 473
DDL Oracle ORDVIDEO 0 0 0 0 0 0 0 0 media 474
DDL Oracle ORDDOC 0 0 0 0 0 0 0 0 media 475
DDL Oracle ORDDICOM 0 0 0 0 0 0 0 0 media 476
DDL Oracle SI_STILLIMAGE 0 0 0 0 0 0 0 0 image 477
DDL Oracle SI_COLOR 0 0 0 0 0 0 0 0 image 478
DDL Oracle SI_AVERAGECOLOR 0 0 0 0 0 0 0 0 image 479
DDL Oracle SI_COLORHISTOGRAM 0 0 0 0 0 0 0 0 image 480
DDL Oracle SI_POSITIONALCOLOR 0 0 0 0 0 0 0 0 image 481
DDL Oracle SI_TEXTURE 0 0 0 0 0 0 0 0 image 482
DDL Oracle SI_FEATURELIST 0 0 0 0 0 0 0 0 image 483
DDL MySql BINARY 1 255 0 0 50 0 0 0 binary 484
DDL MySql ENUM 0 0 0 0 0 0 0 0 enum 485
DDL MySql GEOMETRY 0 0 0 0 0 0 0 0 geometry 486
DDL MySql GEOMETRYCOLLECTION 0 0 0 0 0 0 0 0 geometrycollection 487
DDL MySql INT 0 0 0 0 0 0 0 0 integer 488
DDL MySql LINESTRING 0 0 0 0 0 0 0 0 linestring 489
DDL MySql LONGBLOB 0 0 0 0 0 0 0 0 longblob 490
DDL MySql LONGTEXT 0 0 0 0 0 0 0 0 longtext 491
DDL MySql MEDIUMBLOB 0 0 0 0 0 0 0 0 mediumblob 492
DDL MySql MEDIUMTEXT 0 0 0 0 0 0 0 0 mediumtext 493
DDL MySql MULTILINESTRING 0 0 0 0 0 0 0 0 multilinestring 494
DDL MySql MULTIPOINT 0 0 0 0 0 0 0 0 multipoint 495
DDL MySql MULTIPOLYGON 0 0 0 0 0 0 0 0 multipolygon 496
DDL MySql POINT 0 0 0 0 0 0 0 0 point 497
DDL MySql POLYGON 0 0 0 0 0 0 0 0 polygon 498
DDL MySql SET 0 0 0 0 0 0 0 0 set 499
DDL MySql TINYBLOB 0 0 0 0 0 0 0 0 tinyblob 500
DDL MySql TINYTEXT 0 0 0 0 0 0 0 0 tinytext 501
DDL MySql VARBINARY 1 65535 0 0 50 0 0 0 va
inary 502
DDL MySql YEAR 1 4 0 0 4 0 0 0 date 503
DDL PostgreSQL xml 0 0 0 0 0 0 0 0 xml 504
DDL PostgreSQL uuid 0 0 0 0 0 0 0 0 guid 505
DDL PostgreSQL date 0 0 0 0 0 0 0 0 date 506
DDL PostgreSQL interval 1 6 0 0 0 0 0 0 interval 507
DDL PostgreSQL time 1 6 0 0 0 0 0 0 time 508
DDL PostgreSQL time with time zone 1 6 0 0 0 0 0 0 time 509
DDL PostgreSQL time without time zone 1 6 0 0 0 0 0 0 time 510
DDL PostgreSQL timestamp with time zone 1 6 0 0 0 0 0 0 datetime 511
DDL PostgreSQL timestamp without time zone 1 6 0 0 0 0 0 0 datetime 512
DDL PostgreSQL inet 0 0 0 0 0 0 0 0 inet 513
DDL PostgreSQL cidr 0 0 0 0 0 0 0 0 cidr 514
DDL PostgreSQL macaddr 0 0 0 0 0 0 0 0 macaddr 515
DDL PostgreSQL money 0 0 0 0 0 0 0 0 cu
ency 516
DDL PostgreSQL bit 1 83886080 0 0 1 0 0 0 bit 517
DDL PostgreSQL bit varying 1 83886080 0 0 0 0 0 0 va
it 518
DDL PostgreSQL double precision 0 0 0 0 0 0 0 0 double 519
DDL PostgreSQL serial 0 0 0 0 0 0 0 0 serial 520
DDL PostgreSQL bigserial 0 0 0 0 0 0 0 0 serial 521
DDL PostgreSQL smallserial 0 0 0 0 0 0 0 0 smallserial 522
DDL PostgreSQL point 0 0 0 0 0 0 0 0 point 523
DDL PostgreSQL line 0 0 0 0 0 0 0 0 line 524
DDL PostgreSQL lseg 0 0 0 0 0 0 0 0 lseg 525
DDL PostgreSQL box 0 0 0 0 0 0 0 0 box 526
DDL PostgreSQL path 0 0 0 0 0 0 0 0 path 527
DDL PostgreSQL polygon 0 0 0 0 0 0 0 0 polygon 528
DDL PostgreSQL circle 0 0 0 0 0 0 0 0 circle 529
DDL SQL Server 2012 bigint 0 0 0 0 0 0 0 0 bigint 549
DDL SQL Server 2012 binary 1 8000 0 0 10 0 0 0 binary 550
DDL SQL Server 2012 bit 0 0 0 0 0 0 0 0 boolean 551
DDL SQL Server 2012 char 1 8000 0 0 10 0 0 0 char 552
DDL SQL Server 2012 date 0 0 0 0 0 0 0 0 date 553
DDL SQL Server 2012 datetime 0 0 0 0 0 0 0 0 datetime 554
DDL SQL Server 2012 datetime2 1 7 0 0 7 0 0 0 datetime 555
DDL SQL Server 2012 datetimeoffset 1 7 0 0 7 0 0 0 datetime 556
DDL SQL Server 2012 decimal 2 38 38 38 0 18 0 0 decimal 557
DDL SQL Server 2012 float 0 53 0 0 53 0 0 0 float 558
DDL SQL Server 2012 geography 0 0 0 0 0 0 0 0 text 559
DDL SQL Server 2012 geometry 0 0 0 0 0 0 0 0 text 560
DDL SQL Server 2012 hierarchyid 0 0 0 0 0 0 0 0 text 561
DDL SQL Server 2012 image 0 0 0 0 0 0 0 0 blob 562
DDL SQL Server 2012 int 0 0 0 0 0 0 0 0 integer 563
DDL SQL Server 2012 money 0 0 0 0 0 19 4 0 cu
ency 564
DDL SQL Server 2012 nchar 1 4000 0 0 10 0 0 0 nchar 565
DDL SQL Server 2012 ntext 0 0 0 0 0 0 0 0 ntext 566
DDL SQL Server 2012 numeric 2 38 38 38 0 18 0 0 numeric 567
DDL SQL Server 2012 nvarchar 1 4000 0 0 50 0 0 0 nvarchar 568
DDL SQL Server 2012 nvarchar(max) 0 0 0 0 0 0 0 0 varchar 569
DDL SQL Server 2012 real 0 53 0 0 53 0 0 0 double 570
DDL SQL Server 2012 smalldatetime 0 0 0 0 0 0 0 0 datetime 571
DDL SQL Server 2012 smallint 0 0 0 0 0 0 0 0 smallint 572
DDL SQL Server 2012 smallmoney 0 0 0 0 0 0 0 0 money 573
DDL SQL Server 2012 sql_variant 0 0 0 0 0 0 0 0 sqlvariant 574
DDL SQL Server 2012 text 0 0 0 0 0 0 0 0 text 575
DDL SQL Server 2012 time 1 7 0 0 7 0 0 0 time 576
DDL SQL Server 2012 timestamp 0 0 0 0 0 0 0 0 timestamp 577
DDL SQL Server 2012 tinyint 0 0 0 0 0 0 0 0 tinyint 578
DDL SQL Server 2012 uniqueidentifier 0 0 0 0 0 0 0 0 guid 579
DDL SQL Server 2012 va
inary 1 8000 0 0 50 0 0 0 va
inary 580
DDL SQL Server 2012 va
inary(max) 0 0 0 0 0 0 0 0 va
inary 581
DDL SQL Server 2012 varchar 1 8000 0 0 50 0 0 0 varchar 582
DDL SQL Server 2012 varchar(max) 0 0 0 0 0 0 0 0 varchar 583
DDL SQL Server 2012 xml 0 0 0 0 0 0 0 0 text 584
DDL Oracle MDSYS.ST_GEOMETRY 0 0 0 0 0 0 0 0 geometry 793
DDL Oracle MDSYS.ST_GEOMCOLLECTION 0 0 0 0 0 0 0 0 geometrycollection 794
DDL Oracle MDSYS.ST_POINT 0 0 0 0 0 0 0 0 point 795
DDL Oracle MDSYS.ST_POLYGON 0 0 0 0 0 0 0 0 polygon 796
DDL Oracle MDSYS.ST_LINESTRING 0 0 0 0 0 0 0 0 linestring 797
DDL Oracle MDSYS.ST_MULTILINESTRING 0 0 0 0 0 0 0 0 multilinestring 798
DDL Oracle MDSYS.ST_MULTIPOINT 0 0 0 0 0 0 0 0 multipoint 799
DDL Oracle MDSYS.ST_MULTIPOLYGON 0 0 0 0 0 0 0 0 multipolygon 800
DDL PostgreSQL box2d 0 0 0 0 0 0 0 0 box 801
DDL PostgreSQL box3d 0 0 0 0 0 0 0 0 box3d 802
DDL PostgreSQL geometry 0 0 0 0 0 0 0 0 geometry 803
DDL PostgreSQL geometry(point) 0 0 0 0 0 0 0 0 point 804
DDL PostgreSQL geometry(polygon) 0 0 0 0 0 0 0 0 polygon 805
DDL PostgreSQL geometry(linestring) 0 0 0 0 0 0 0 0 linestring 806
DDL PostgreSQL geometry(geometrycollection) 0 0 0 0 0 0 0 0 geometrycollection 807
DDL PostgreSQL geometry(multipoint) 0 0 0 0 0 0 0 0 multipoint 808
DDL PostgreSQL geometry(multipolygon) 0 0 0 0 0 0 0 0 multipolygon 809
DDL PostgreSQL geometry(multilinestring) 0 0 0 0 0 0 0 0 multilinestring 810
DDL PostgreSQL geometry_dump 0 0 0 0 0 0 0 0 geometry_dump 811
DDL PostgreSQL geography 0 0 0 0 0 0 0 0 geography 812
DDL PostgreSQL geography(point) 0 0 0 0 0 0 0 0 point2 813
DDL PostgreSQL geography(polygon) 0 0 0 0 0 0 0 0 polygon2 814
DDL PostgreSQL geography(linestring) 0 0 0 0 0 0 0 0 linestring2 815
DDL PostgreSQL geography(geometrycollection) 0 0 0 0 0 0 0 0 geometrycollection2 816
DDL PostgreSQL geography(multipoint) 0 0 0 0 0 0 0 0 multipoint2 817
DDL PostgreSQL geography(multipolygon) 0 0 0 0 0 0 0 0 multipolygon2 818
DDL PostgreSQL geography(multilinestring) 0 0 0 0 0 0 0 0 multilinestring2 819
DDL MSAccess GUID 0 0 0 0 0 0 0 0 guid 820
DDL MSAccess 2007 GUID 0 0 0 0 0 0 0 0 guid 821
DDL Sybase ASE va
inary 1 255 0 0 1 0 0 0 va
inary 826
DDL Sybase bigint 0 0 0 0 0 0 0 0 int8 827
DDL Sybase binary 1 32767 0 0 50 0 0 0 binary 828
DDL Sybase bit 0 0 0 0 0 0 0 0 bit 829
DDL Sybase char 1 32767 0 0 10 0 0 0 char 830
DDL Sybase date 0 0 0 0 0 0 0 0 date4 831
DDL Sybase datetime 0 0 0 0 0 0 0 0 datetime8 832
DDL Sybase datetimeoffset 0 0 0 0 0 0 0 0 datetimeoffset 833
DDL Sybase decimal 2 0 127 127 0 30 6 0 decimal 834
DDL Sybase double 0 0 0 0 0 0 0 0 double 835
DDL Sybase float 0 0 0 0 4 0 0 0 float 836
DDL Sybase integer 0 0 0 0 0 0 0 0 int4 837
DDL Sybase image 0 0 0 0 0 0 0 0 long binary 838
DDL Sybase long binary 0 0 0 0 0 0 0 0 long binary 839
DDL Sybase long nvarchar 0 0 0 0 0 0 0 0 longnvarchar 840
DDL Sybase long va
it 0 0 0 0 0 0 0 0 va
it 841
DDL Sybase long varchar 0 0 0 0 0 0 0 0 longvarchar 842
DDL Sybase money 0 0 0 0 0 0 0 0 money 843
DDL Sybase nchar 1 32767 0 0 10 0 0 0 nchar 844
DDL Sybase ntext 0 0 0 0 0 0 0 0 ntext 845
DDL Sybase numeric 2 0 127 127 0 30 6 0 numeric 846
DDL Sybase nvarchar 1 32767 0 0 50 0 0 0 nvarchar 847
DDL Sybase real 0 0 0 0 4 0 0 0 float 848
DDL Sybase smalldatetime 0 0 0 0 0 0 0 0 datetime4 849
DDL Sybase smallint 0 0 0 0 0 0 0 0 int2 850
DDL Sybase smallmoney 0 0 0 0 0 0 0 0 smallmoney 851
DDL Sybase ST_Geometry 0 0 0 0 0 0 0 0 geometry 852
DDL Sybase ST_GeomCollection 0 0 0 0 0 0 0 0 geometrycollection 853
DDL Sybase ST_Point 0 0 0 0 0 0 0 0 point 854
DDL Sybase ST_Polygon 0 0 0 0 0 0 0 0 polygon 855
DDL Sybase ST_LineString 0 0 0 0 0 0 0 0 linestring 856
DDL Sybase ST_MultiLineString 0 0 0 0 0 0 0 0 multilinestring 857
DDL Sybase ST_MultiPoint 0 0 0 0 0 0 0 0 multipoint 858
DDL Sybase ST_MultiPolygon 0 0 0 0 0 0 0 0 multipolygon 859
DDL Sybase text 0 0 0 0 0 0 0 0 text 860
DDL Sybase tinyint 0 0 0 0 0 0 0 0 int1 861
DDL Sybase time 0 0 0 0 0 0 0 0 time 862
DDL Sybase timestamp 0 0 0 0 0 0 0 0 timestamp8 863
DDL Sybase timestamp with time zone 0 0 0 0 0 0 0 0 timestamptz 864
DDL Sybase uniqueidentifier 0 0 0 0 0 0 0 0 uniqueidentifier 865
DDL Sybase uniqueidentifierstr 0 0 0 0 0 0 0 0 uniqueidentifier 866
DDL Sybase va
inary 1 32767 0 0 1 0 0 0 va
inary 867
DDL Sybase va
it 1 32767 0 0 1 0 0 0 va
it 868
DDL Sybase varchar 1 32767 0 0 50 0 0 0 varchar 869
DDL Sybase xml 0 0 0 0 0 0 0 0 xml 870
DDL Firebird smallint 0 0 0 0 0 0 0 0 smallint 871
DDL Firebird integer 0 0 0 0 0 0 0 0 integer 872
DDL Firebird bigint 0 0 0 0 0 0 0 0 bigint 873
DDL Firebird date 0 0 0 0 0 0 0 0 date 874
DDL Firebird time 0 0 0 0 0 0 0 0 time 875
DDL Firebird timestamp 0 0 0 0 0 0 0 0 datetime 876
DDL Firebird double precision 0 0 0 0 0 0 0 0 double 877
DDL Firebird blob sub_type 0 0 0 0 0 0 0 0 0 blob 878
DDL Firebird blob sub_type 1 0 0 0 0 0 0 0 0 text 879
DDL Firebird varchar 1 32767 0 0 50 0 0 0 varchar 880
DDL Firebird char 1 32767 0 0 50 0 0 0 char 881
DDL Firebird decimal 2 0 64 64 0 10 2 0 decimal 882
DDL Firebird numeric 2 0 64 64 0 10 2 0 numeric 883
DDL Firebird float 0 0 0 0 0 0 0 0 float 884
DDL DB2 ST_MULTISURFACE 0 0 0 0 0 0 0 0 multisurface 912
DDL DB2 ST_MULTISURFACE 0 0 0 0 0 0 0 0 multisurface 932
DDL DB2 BLOB 1 2147483647 0 0 1048576 0 0 0 blob 934
DDL DB2 CLOB 1 2147483647 0 0 1048576 0 0 0 clob 935
DDL DB2 DBCLOB 1 1073741823 0 0 1 0 0 0 dbclob 936
DDL DB2 GRAPHIC 1 127 0 0 1 0 0 0 graphic 937
DDL DB2 LONG VARGRAPHIC 0 0 0 0 0 0 0 0 longvargraphic 938
DDL DB2 VARGRAPHIC 1 16336 0 0 1 0 0 0 vargraphic 939
DDL DB2 VARCHAR 1 32672 0 0 10 0 0 0 varchar 940
DDL DB2 XML 0 0 0 0 0 0 0 0 xml 941
DDL DB2 ST_CURVE 0 0 0 0 0 0 0 0 curve 942
DDL DB2 ST_GEOMCOLLECTION 0 0 0 0 0 0 0 0 geometrycollection 943
DDL DB2 ST_GEOMETRY 0 0 0 0 0 0 0 0 geometry 944
DDL DB2 ST_LINESTRING 0 0 0 0 0 0 0 0 linestring 945
DDL DB2 ST_POINT 0 0 0 0 0 0 0 0 point 946
DDL DB2 ST_POLYGON 0 0 0 0 0 0 0 0 polygon 947
DDL DB2 ST_SURFACE 0 0 0 0 0 0 0 0 surface 948
DDL DB2 ST_MULTICURVE 0 0 0 0 0 0 0 0 multicurve 949
DDL DB2 ST_MULTILINESTRING 0 0 0 0 0 0 0 0 multilinestring 950
DDL DB2 ST_MULTIPOINT 0 0 0 0 0 0 0 0 multipoint 951
DDL DB2 ST_MULTIPOLYGON 0 0 0 0 0 0 0 0 multipolygon 952
DDL DB2 ST_MULTISURFACE 0 0 0 0 0 0 0 0 multisurface 953
DDL MSAccess Cu
ency 0 0 0 0 0 0 0 0 cu
ency 954
Diagram_ID Package_ID ParentID Diagram_Type Name Version Author ShowDetails Notes Stereotype AttPub AttPri AttPro Orientation cx cy Scale CreatedDate ModifiedDate HTMLPath ShowForeign ShowBorder ShowPackageContents PDATA Locked ea_guid TPos Swimlanes StyleEx
1 2 0 Logical class diagram 1.0 Waste 0 true true true P 850 1098 100 8/31/18 8/31/18 true true true HideRel=0;ShowTags=0;ShowReqs=0;ShowCons=0;OpParams=1;ShowSN=0;ScalePI=0;PPgs.cx=1;PPgs.cy=1;PSize=1;ShowIcons=1;SuppCN=0;HideProps=0;HideParents=0;UseAlias=0;HideAtts=0;HideOps=0;HideStereo=0;HideEStereo=0;ShowRec=1;ShowRes=0;ShowShape=1;FormName=; false {FC2F6E89-111D-4d39-A561-8A03CEDCC1C4} locked=false;orientation=0;width=0;inbar=false;names=false;color=-1;bold=false;fcol=0;tcol=-1;ofCol=-1;ufCol=-1;hl=0;ufh=0;hh=0;cls=0;bw=0;hli=0; ExcludeRTF=0;DocAll=0;HideQuals=0;AttPkg=1;ShowTests=0;ShowMaint=0;SuppressFOC=1;MatrixActive=0;SwimlanesActive=1;KanbanActive=0;MatrixLineWidth=1;MatrixLineClr=0;MatrixLocked=0;TConnectorNotation=UML 2.1;TExplicitNavigability=0;AdvancedElementProps=1;AdvancedFeatureProps=1;AdvancedConnectorProps=1;m_bElementClassifier=1;SPT=1;MDGDgm=;STBLDgm=;ShowNotes=0;VisibleAttributeDetail=0;ShowOpRetType=1;SuppressBrackets=0;SuppConnectorLabels=0;PrintPageHeadFoot=0;ShowAsList=0;SuppressedCompartments=;Theme=:119;SaveTag=839FA2AF;
5 2 0 Sequence Sequence Diagram 1.0 Waste 0 true true true P 850 1098 100 8/31/18 8/31/18 true true true HideRel=0;ShowTags=0;ShowReqs=0;ShowCons=0;OpParams=1;ShowSN=0;ScalePI=0;PPgs.cx=2;PPgs.cy=1;PSize=1;ShowIcons=1;SuppCN=0;HideProps=0;HideParents=0;UseAlias=0;HideAtts=0;HideOps=0;HideStereo=0;HideEStereo=0;ShowRec=1;ShowRes=0;ShowShape=1;FormName=; false {D151DBC3-037C-4071-994B-9F84A6F5E294} locked=false;orientation=0;width=0;inbar=false;names=false;color=-1;bold=false;fcol=0;tcol=-1;ofCol=-1;ufCol=-1;hl=0;ufh=0;hh=0;cls=0;bw=0;hli=0; ExcludeRTF=0;DocAll=0;HideQuals=0;AttPkg=1;ShowTests=0;ShowMaint=0;SuppressFOC=0;INT_ARGS=;INT_RET=;INT_ATT=;SeqTopMargin=50;MatrixActive=0;SwimlanesActive=1;KanbanActive=0;MatrixLineWidth=1;MatrixLineClr=0;MatrixLocked=0;TConnectorNotation=UML...