PHP Classes

File: ver.0.4/model.xml

Recommend this page to a friend!
  Classes of Tom Schaefer   QDataObject   ver.0.4/model.xml   Download  
File: ver.0.4/model.xml
Role: Auxiliary data
Content type: text/plain
Description: Sample XML out of database scheme nothwind
Class: QDataObject
Access MySQL query results as objects
Author: By
Last change:
Date: 15 years ago
Size: 7,481 bytes
 

Contents

Class file image Download
<?xml version='1.0' encoding='utf-8'?> <businessmodels> <model name="NorthwindCategories"> <attributes database="northwind" table="Categories" qualified="northwind.categories"> <attribute name="CategoryID" type="int" size="11" required="true" primary_key="true"></attribute> <attribute name="CategoryName" type="varchar" size="15"></attribute> <attribute name="Description" type="text" maxLength="65535"></attribute> <attribute name="Picture" type="varchar" size="40"></attribute> </attributes> </model> <model name="NorthwindCountry"> <attributes database="northwind" table="Country" qualified="northwind.country"> <attribute name="id" type="int" size="11" required="true" primary_key="true"></attribute> <attribute name="Code" type="char" size="3" required="true"></attribute> <attribute name="Name" type="char" size="52" required="true"></attribute> <attribute name="Continent" type="enum" required="true" default="'Asia','Europe','North America','Africa','Oceania','Antarctica','South America'"></attribute> <attribute name="SurfaceArea" type="float" size="10" required="true" default="1"></attribute> <attribute name="Population" type="int" size="11" required="true" default="1"></attribute> <attribute name="LocalName" type="char" size="45" required="true"></attribute> </attributes> </model> <model name="NorthwindCustomers"> <attributes database="northwind" table="Customers" qualified="northwind.customers"> <attribute name="CustomerID" type="varchar" size="5" required="true" primary_key="true"></attribute> <attribute name="CompanyName" type="varchar" size="40"></attribute> <attribute name="ContactName" type="varchar" size="30"></attribute> <attribute name="ContactTitle" type="varchar" size="30"></attribute> <attribute name="Address" type="varchar" size="60"></attribute> <attribute name="City" type="varchar" size="15"></attribute> <attribute name="Region" type="varchar" size="15"></attribute> <attribute name="PostalCode" type="varchar" size="10"></attribute> <attribute name="Country" type="varchar" size="15"></attribute> <attribute name="Phone" type="varchar" size="24"></attribute> <attribute name="Fax" type="varchar" size="24"></attribute> </attributes> </model> <model name="NorthwindEmployees"> <attributes database="northwind" table="Employees" qualified="northwind.employees"> <attribute name="EmployeeID" type="int" size="11" required="true" primary_key="true"></attribute> <attribute name="LastName" type="varchar" size="20"></attribute> <attribute name="FirstName" type="varchar" size="10"></attribute> <attribute name="Title" type="varchar" size="30"></attribute> <attribute name="TitleOfCourtesy" type="varchar" size="25"></attribute> <attribute name="BirthDate" type="date"></attribute> <attribute name="HireDate" type="date"></attribute> <attribute name="Address" type="varchar" size="60"></attribute> <attribute name="City" type="varchar" size="15"></attribute> <attribute name="Region" type="varchar" size="15"></attribute> <attribute name="PostalCode" type="varchar" size="10"></attribute> <attribute name="Country" type="varchar" size="15"></attribute> <attribute name="HomePhone" type="varchar" size="24"></attribute> <attribute name="Extension" type="varchar" size="4"></attribute> <attribute name="Photo" type="varchar" size="40"></attribute> <attribute name="Notes" type="text" maxLength="65535"></attribute> <attribute name="ReportsTo" type="int" size="11"></attribute> </attributes> </model> <model name="NorthwindOrderDetails"> <attributes database="northwind" table="OrderDetails" qualified="northwind.order_details"> <attribute name="odID" type="int" size="10" required="true" primary_key="true"></attribute> <attribute name="OrderID" type="int" size="11" default="1"></attribute> <attribute name="ProductID" type="int" size="11" default="1"></attribute> <attribute name="UnitPrice" type="float" size="1" default="1"></attribute> <attribute name="Quantity" type="smallint" size="6" default="1"></attribute> <attribute name="Discount" type="float" size="1" default="1"></attribute> </attributes> </model> <model name="NorthwindOrders"> <attributes database="northwind" table="Orders" qualified="northwind.orders"> <attribute name="OrderID" type="int" size="11" required="true" primary_key="true"></attribute> <attribute name="CustomerID" type="varchar" size="5"></attribute> <attribute name="EmployeeID" type="int" size="11"></attribute> <attribute name="OrderDate" type="date"></attribute> <attribute name="RequiredDate" type="date"></attribute> <attribute name="ShippedDate" type="date"></attribute> <attribute name="ShipVia" type="int" size="11"></attribute> <attribute name="Freight" type="float" size="1" default="1"></attribute> <attribute name="ShipName" type="varchar" size="40"></attribute> <attribute name="ShipAddress" type="varchar" size="60"></attribute> <attribute name="ShipCity" type="varchar" size="15"></attribute> <attribute name="ShipRegion" type="varchar" size="15"></attribute> <attribute name="ShipPostalCode" type="varchar" size="10"></attribute> <attribute name="ShipCountry" type="varchar" size="15"></attribute> </attributes> </model> <model name="NorthwindProducts"> <attributes database="northwind" table="Products" qualified="northwind.products"> <attribute name="ProductID" type="int" size="11" required="true" primary_key="true"></attribute> <attribute name="ProductName" type="varchar" size="40"></attribute> <attribute name="SupplierID" type="int" size="11"></attribute> <attribute name="CategoryID" type="int" size="11"></attribute> <attribute name="QuantityPerUnit" type="varchar" size="20"></attribute> <attribute name="UnitPrice" type="float" size="1" default="1"></attribute> <attribute name="UnitsInStock" type="smallint" size="6" default="1"></attribute> <attribute name="UnitsOnOrder" type="smallint" size="6" default="1"></attribute> <attribute name="ReorderLevel" type="smallint" size="6" default="1"></attribute> <attribute name="Discontinued" type="tinyint" size="1" default="1"></attribute> </attributes> </model> <model name="NorthwindShippers"> <attributes database="northwind" table="Shippers" qualified="northwind.shippers"> <attribute name="ShipperID" type="int" size="11" required="true" primary_key="true"></attribute> <attribute name="CompanyName" type="varchar" size="40"></attribute> <attribute name="Phone" type="varchar" size="24"></attribute> </attributes> </model> <model name="NorthwindSuppliers"> <attributes database="northwind" table="Suppliers" qualified="northwind.suppliers"> <attribute name="SupplierID" type="int" size="11" required="true" primary_key="true"></attribute> <attribute name="CompanyName" type="varchar" size="40"></attribute> <attribute name="ContactName" type="varchar" size="30"></attribute> <attribute name="ContactTitle" type="varchar" size="30"></attribute> <attribute name="Address" type="varchar" size="60"></attribute> <attribute name="City" type="varchar" size="15"></attribute> <attribute name="Region" type="varchar" size="15"></attribute> <attribute name="PostalCode" type="varchar" size="10"></attribute> <attribute name="Country" type="varchar" size="15"></attribute> <attribute name="Phone" type="varchar" size="24"></attribute> <attribute name="Fax" type="varchar" size="24"></attribute> <attribute name="HomePage" type="text" maxLength="65535"></attribute> </attributes> </model> </businessmodels>