0 Business 0 Categories 0 CategoryID CategoryID 4 true 1 CategoryName CategName 12 50 1 Products 0 ProductID ProductID 4 true 1 ProductName ProdName 12 50 2 ProductDescription ProdDescr 12 250 3 CategoryID CategoryID 4 4 SupplierID SupplierID 4 5 Serialnumber SerialNo 12 50 6 UnitsInStock UnitsStock 4 7 UnitsOnOrder UnitsOrder 4 8 UnitPrice UnitPrice 3 17 2 9 ReorderLevel ReordLevel 4 10 Discontinued Discontin -7 11 LeadTime LeadTime 12 50 2 Suppliers 0 SupplierID SupplierID 4 true 1 SupplierName SupplName 12 50 2 ContactName ContctName 12 50 3 ContactTitle ContctTitl 12 50 4 Address Address 12 200 5 City City 12 50 6 PostalCode PostalCode 12 20 7 StateOrProvince StateProvi 12 50 8 CountryOrRegion CountryReg 12 50 9 PhoneNumber PhoneNo 12 30 10 FaxNumber FaxNo 12 30 11 PaymentTerms PaymntTerm 12 250 12 EmailAddress EmailAddr 12 50 13 Notes Notes -1 65000 3 MailingList 0 MailingListID MailingID 4 true 1 Prefix Prefix 12 20 2 FirstName FirstName 12 50 3 MiddleName MiddleName 12 50 4 LastName LastName 12 50 5 Suffix Suffix 12 20 6 Title Title 12 50 7 OrganizationName OrgName 12 50 8 Address Address 12 200 9 City City 12 50 10 PostalCode PostalCode 12 20 11 StateOrProvince StateProvi 12 50 12 CountryOrRegion CountryReg 12 50 13 PhoneNumber PhoneNo 12 30 14 FaxNumber FaxNo 12 30 15 MobileNumber MobileNo 12 30 16 EmailAddress EmailAddr 12 50 17 Birthdate Birthdate 91 18 Nationality Nationality 12 50 19 DateUpdated DateUpdate 91 20 DateJoined DateJoined 91 21 MembershipStatus MemberStat 12 50 22 PledgeAmount PledgeAmnt 3 10 2 23 PledgePaidDate PldgPdDate 91 24 DuesAmount DuesAmount 3 10 2 25 DuesPaidDate DuesPdDate 91 26 Photo Photo -4 27 Notes Notes -1 65000 4 Contacts 0 ContactID ContactID 4 true 1 FirstName FirstName 12 50 2 LastName LastName 12 50 3 Title Title 12 50 4 Address Address 12 200 5 City City 12 50 6 PostalCode PostalCode 12 20 7 StateOrProvince StateProvi 12 50 8 CountryOrRegion CountryReg 12 50 9 PhoneNumber PhoneNo 12 30 10 FaxNumber FaxNo 12 30 11 MobileNumber MobileNo 12 30 12 EmailAddress EmailAddr 12 50 13 Salutation Salutation 12 50 14 Birthdate Birthdate 91 15 ContactTypeID CntctTypID 4 16 MaritalStatus MaritlStat 12 50 17 SpouseName SpouseName 12 50 18 SpousesInterests SpouseIntr 12 250 19 ContactsInterests CntctInter 12 250 20 ChildrenNames ChildName 12 250 21 Photo Photo -4 22 Notes Notes -1 65000 5 Customers 0 CustomerID CustomerID 4 true 1 CompanyName CompnyName 12 50 2 FirstName FirstName 12 50 3 LastName LastName 12 50 4 Department Department 12 50 5 Address Address 12 200 6 City City 12 50 7 PostalCode PostalCode 12 20 8 StateOrProvince StateProvi 12 50 9 CountryOrRegion CountryReg 12 50 10 PhoneNumber PhoneNo 12 30 11 FaxNumber FaxNo 12 30 12 MobileNumber MobileNo 12 30 13 EmailAddress EmailAddr 12 50 14 Title Title 12 50 15 Notes Notes -1 65000 6 Employees 0 EmployeeID EmployeeID 4 true 1 FirstName FirstName 12 50 2 MiddleName MiddleName 12 50 3 LastName LastName 12 50 4 Title Title 12 50 5 Department Department 12 50 6 SocialSecurityNumber SocSecNo 12 50 7 EmployeeNumber EmployeeNo 12 50 8 EmailAddress EmailAddr 12 50 9 Extension Extension 12 30 10 Address Address 12 200 11 City City 12 50 12 PostalCode PostalCode 12 20 13 StateOrProvince StateProvi 12 50 14 CountryOrRegion CountryReg 12 50 15 PhoneNumber PhoneNo 12 30 16 FaxNumber FaxNo 12 30 17 MobileNumber MobileNo 12 30 18 Birthdate Birthdate 91 19 DateHired DateHired 91 20 DepartmentID DeprtmntID 4 21 Salary Salary 3 10 2 22 BillingRate BillngRate 3 10 2 23 Deductions Deductions 4 24 SupervisorID SupervisID 4 25 SpouseName SpouseName 12 50 26 OfficeLocation OfficeLoc 12 50 27 Photo Photo -4 28 Notes Notes -1 65000 7 Orders 0 OrderID OrderID 4 true 1 CustomerID CustomerID 4 2 EmployeeID EmployeeID 4 3 OrderDate OrderDate 91 4 PurchaseOrderNumber PurchOrdNo 12 50 5 RequiredByDate RequirDate 91 6 PromisedByDate PromisDate 91 7 ShipName ShipName 12 50 8 ShipAddress ShipAddres 12 200 9 ShipCity ShipCity 12 50 10 ShipStateOrProvince ShpStatPro 12 50 11 ShipPostalCode ShipPostlC 12 20 12 ShipCountryOrRegion ShipCouReg 12 50 13 ShipPhoneNumber ShipPhonNo 12 30 14 ShipDate ShipDate 91 15 ShippingMethodID ShipMethID 4 16 FreightCharge FreightCharge 3 10 2 17 SalesTaxRate SalesTaxRt 3 4 2 8 OrderDetails 0 OrderDetailID OrderDetID 4 true 1 OrderID OrderID 4 2 ProductID ProductID 4 3 DateSold DateSold 91 4 Quantity Quantity 4 5 UnitPrice UnitPrice 3 10 2 6 Discount Discount 3 4 2 7 SalePrice SalePrice 3 10 2 8 SalesTax SalesTax 3 9 2 9 LineTotal LineTotal 3 10 2 9 Payments 0 PaymentID PaymentID 4 true 1 CustomerID CustomerID 4 2 WorkorderID WorkordrID 4 3 OrderID OrderID 4 4 ReservationID ReservID 4 5 MemberID MemberID 4 6 RegistrationID RegistraID 4 7 ProjectID ProjectID 4 8 PaymentAmount PaymntAmnt 3 10 2 9 PaymentDate PaymntDate 91 10 PaymentMethod PaymntMeth 12 50 11 CheckNumber CheckNo 4 12 CreditCardType CCardType 12 50 13 CreditCardNumber CCardNo 12 50 14 Cardholder Cardholder 12 50 15 CreditCardExpDate CCExpDate 91 16 CreditCardAuthorizationNumber CCAuthorNo 12 50 17 PaymentTerms PaymntTerm 12 250 18 PaymentMethodID PaymMethID 4 19 Notes Notes -1 65000 10 Invoices 0 InvoiceID InvoiceID 4 true 1 CustomerID CustomerID 4 2 EmployeeID EmployeeID 4 3 DeliveryID DeliveryID 4 4 Status Status 12 50 5 InvoiceDate InvoiceDat 91 6 Salesperson Salespersn 12 50 7 ShipDate ShipDate 91 8 ShippedTo ShippedTo 12 50 9 ShippedVia ShippedVia 12 50 10 ShippingCost ShipCost 3 10 2 11 Notes Notes -1 65000 11 InvoiceDetails 0 InvoiceDetailID InvoiDetID 4 true 1 InvoiceID InvoiceID 4 2 OrderID OrderID 4 3 ProductID ProductID 4 4 Quantity Quantity 4 5 UnitPrice UnitPrice 3 10 2 6 Discount Discount 3 4 2 7 PaymentTerms PaymntTerm 12 250 12 Projects 0 ProjectID ProjectID 4 true 1 ProjectName ProjctName 12 50 2 ProjectDescription ProjctDscr -1 65000 3 ClientID ClientID 4 4 PurchaseOrderNumber PurchOrdNo 12 50 5 TotalBillingEstimate TotBillEst 3 10 2 6 EmployeeID EmployeeID 4 7 BeginDate BeginDate 91 8 EndDate EndDate 91 13 Events 0 EventID EventID 4 true 1 EventName EventName 12 50 2 EventDescription EventDescr -1 65000 3 EventTypeID EventTypID 4 4 EmployeeID EmployeeID 4 5 Status Status 12 50 6 Location Location 12 50 7 BeginDate BeginDate 91 8 BeginTime BeginTime 92 9 EndDate EndDate 91 10 EndTime EndTime 92 11 RequiredStaffing ReqStaffng 4 12 Confirmation Confirmation -7 13 AvailableSpaces AvailSpace 4 14 CostPerPerson CostPPersn 3 10 2 15 Notes Notes -1 65000 14 Reservations 0 ReservationID ReservID 4 true 1 CustomerID CustomerID 4 2 EventID EventID 4 3 EmployeeID EmployeeID 4 4 QuantityReserved QuntityRes 4 5 ReservationDate ReservDate 91 6 ReservationTime ReservTime 92 7 DepositDue DepositDue 3 10 2 8 TotalDue TotalDue 3 10 2 9 AmountPaid AmountPaid 3 10 2 10 Confirmation Confirmation -7 11 Notes Notes -1 65000 15 TimeBilled 0 TimeBilledID TimeBillID 4 true 1 CustomerID CustomerID 4 2 ProjectID ProjectID 4 3 EmployeeID EmployeeID 4 4 BillingDate BillingDate 91 5 RatePerHour RatePrHour 3 10 2 6 BillableHours BillablHrs 3 6 2 7 Notes Notes -1 65000 16 Expenses 0 ExpenseID ExpenseID 4 true 1 ExpenseType ExpensType 12 50 2 Purpose Purpose 12 50 3 EmployeeID EmployeeID 4 4 DatePurchased DatePurchd 91 5 DateSubmitted DateSubmit 91 6 AmountSpent AmountSpnt 3 10 2 7 AdvanceAmount AdvnceAmnt 3 10 2 8 PaymentMethod PaymntMeth 12 50 9 Notes Notes -1 65000 17 Deliveries 0 DeliveryID DeliveryID 4 true 1 CustomerID CustomerID 4 2 OrderID OrderID 4 3 EmployeeID EmployeeID 4 4 ShippedFrom ShippedFrm 12 50 5 ShippedVia ShippedVia 12 50 6 TrackingCode TrckngCode 12 50 7 ShipDate ShipDate 91 8 ShipperPhoneNumber ShipPhonNo 12 30 9 DestinationAddress DestAddres 12 50 10 DestinationCity DestinCity 12 50 11 DestinationStateProvince DestStaPro 12 50 12 DestinationPostalCode DestPstCde 12 20 13 DestinationCountryRegion DestCouReg 12 50 14 ArrivalDate ArrivlDate 91 15 ArrivalTime ArrivlTime 92 16 CurrentLocation CurrLocatn 12 250 17 PackageDimensions PackDimens 12 50 18 PackageWeight PackWeight 12 50 19 PickUpLocation PickUpLoca 12 50 20 PickUpDate PickUpDate 91 50 21 PickUpTime PickUpTime 92 50 22 ReceivedBy ReceivedBy 12 50 23 FreightCharge FrghtChrge 12 6 2 24 Notes Notes -1 65000 18 Assets 0 AssetID AssetID 4 true 1 Description Descrption 12 250 2 EmployeeID EmployeeID 4 3 AssetCategoryID AssetCatID 4 4 StatusID StatusID 4 5 DepartmentID DeprtmntID 4 6 VendorID VendorID 4 7 Make Make 12 50 8 Model Model 12 50 9 ModelNumber ModelNo 12 50 10 SerialNumber SerialNo 12 50 11 BarcodeNumber BarcodeNo 12 50 12 DateAcquired DateAcquir 91 13 DateSold DateSold 91 14 PurchasePrice PurchPrice 3 10 2 15 DepreciationMethod DeprecMeth 12 50 16 DepreciableLife DeprecLife 4 17 SalvageValue SalvageVal 3 10 2 17 CurrentValue CurrentVal 3 10 2 18 Comments Comments -1 65000 19 NextScheduledMaintenance NtSchMaint 91 19 Transactions 0 TransactionID TrnsactnID 4 true 1 PaymentID PaymentID 4 2 TransactionNumber TrnsactnNo 4 3 Date Date 91 4 Description Descrption 12 250 5 Amount Amount 3 10 2 6 AccountID AccountID 4 7 ReferenceNumber RefrenceNo 12 50 8 NumberofUnits NumberUnit 4 9 WithdrawalAmount WithdrwAmt 3 10 2 10 DepositAmount DepositAmt 3 10 2 11 InterestEarned IntrstEarn 3 9 2 12 BuySellDate BuySellDat 91 13 BuySellPrice BuySellPrc 3 10 2 14 ServiceCharge ServiChrge 3 10 2 15 Taxable Taxable -7 16 Notes Notes -1 65000 20 Tasks 0 TaskID TaskID 4 true 1 Description Descrption -1 65000 2 StartDate StartDate 91 3 EndDate EndDate 91 4 Notes Notes -1 65000 21 EmployeesTasks 0 EmployeeTaskID EmplTaskID 4 true 1 EmployeeID EmployeeID 4 2 TaskID TaskID 4 1 Private 0 Categories 0 CategoryID CategoryID 4 true 1 CategoryName CategName 12 50 1 Addresses 0 AddressID AddressID 4 true 1 FirstName FirstName 12 50 2 LastName LastName 12 50 3 Title Title 12 50 4 Address Address 12 200 5 City City 12 50 6 PostalCode PostalCode 12 20 7 StateOrProvince StateProvi 12 50 8 CountryOrRegion CountryReg 12 50 9 PhoneNumber PhoneNo 12 30 10 FaxNumber FaxNo 12 30 11 MobileNumber MobileNo 12 30 12 EmailAddress EmailAddr 12 50 13 Salutation Salutation 12 50 14 Birthdate Birthdate 91 15 SendCard SendCard -7 16 MaritalStatus MaritlStat 12 50 17 SpouseName SpouseName 12 50 18 Nickname Nickname 12 50 19 Hobbies Hobbies 12 250 20 ChildrenNames ChildName 12 250 21 Photo Photo -4 22 Notes Notes -1 65000 23 DateUpdated DatUpdated 91 2 HouseholdInventory 0 InventoryID InventryID 4 true 1 CategoryID CategoryID 4 2 RoomID RoomID 4 3 Item Item 12 50 4 ItemType ItemType 12 50 5 Description Descrption 12 50 6 Manufacturer Manufactur 12 50 7 Model Model 12 50 8 ModelNumber ModelNo 12 50 9 SerialNumber SerialNo 12 50 10 DatePurchased DatePurch 91 11 PlacePurchased PlacePurch 12 50 12 PurchasePrice PurchPrice 3 7 2 13 AppraisedValue AppraisVal 3 7 2 14 Insured Insured -7 15 Notes Notes -1 65000 3 Recipes 0 RecipeID RecipeID 4 true 1 Name Name 12 50 2 Description Descrption 12 250 3 Source Source 12 50 4 WhichMeal WhichMeal 12 50 5 Vegetarian Vegetarian -7 6 TimeToPrepare TimePrepar 12 50 7 NumberofServings NoofServng 4 8 CaloriesPerServing CalPerServ 4 9 NutritionalInformation NutriInfo -1 65000 10 Ingredients Ingredient -1 65000 11 Instructions Instrction -1 65000 12 Utensils Utensils 12 250 13 Notes Notes -1 65000 4 Plants 0 PlantID PlantID 4 true 1 CommonName CommonName 12 50 2 Genus Genus 12 50 3 Species Species 12 50 4 Flowering Flowering -7 5 LightPreference LightPref 12 50 6 TemperaturePreference TempPref 12 50 7 FertilizeFrequency FertilFreq 12 50 8 WateringFrequency WaterFreq 12 50 9 DatePurchased DatePurch 91 10 PlacePurchased PlacePurch 12 50 11 DatePlanted DatPlanted 91 12 DateRepotted DatRepottd 91 13 DatePruned DatePruned 91 14 DateWatered DateWaterd 91 15 Photo Photo -4 16 Notes Notes -1 65000 5 Photographs 0 PhotoID PhotoID 4 true 1 FilmID FilmID 4 2 DateTaken DateTaken 91 3 TimeTaken TimeTaken 92 4 PlaceTaken PlaceTaken 12 50 5 LensUsed LensUsed 12 50 6 Aperture Aperture 12 50 7 ShutterSpeed ShutterSpd 12 50 8 FilterUsed FilterUsed 12 50 9 Flash Flash -7 10 PrintSize PrintSize 12 50 11 Notes Notes -1 65000 6 MiniatureFilms 0 FilmID FilmID 4 true 1 Make Make 12 100 2 Photosensitivity Photosensi 12 50 3 NumberOfPhotos NumPhotos 4 4 ColorFilm ColorFilm -7 5 FilmExpirationDate FlmExpDate 91 6 DateDeveloped DateDevelp 91 7 DevelopedBy DevelopdBy 12 50 8 Camera Camera 12 50 9 Notes Notes -1 65000 7 DVD-Collection 0 CollectionID CollectnID 4 true 1 MovieTitle MovieTitle 12 100 2 Genre Genre 12 100 3 Actor Actor 12 100 4 Director Director 12 100 5 Producer Producer 12 100 6 ReleaseYear ReleasYear 91 7 Rating Rating 12 50 8 Subject Subject 12 50 9 Length Length 12 50 10 DateAcquired DateAcquir 91 11 PurchasedAt PurchaseAt 12 50 12 PurchasePrice PurchPrice 3 17 2 13 Review Review -1 65000 14 Notes Notes -1 65000 8 CD-Collection 0 CollectionID CollectnID 4 true 1 AlbumTitle AlbumTitle 12 100 2 Artist Artist 12 100 3 MusicCategoryID MusicCatID 4 4 RecordLabel RecordLabl 12 50 5 Producer Producer 12 100 6 ReleaseYear ReleasYear 4 7 Rating Rating 12 50 8 Format Format 12 50 9 NumberofTracks NoofTracks 4 10 DatePurchased DatePurch 91 11 PurchasedAt PurchaseAt 12 50 12 PurchasePrice PurchPrice 3 17 2 13 Review Review -1 65000 14 Notes Notes -1 65000 9 Library 0 BookID BookID 4 true 1 Title Title 12 100 2 Genre Genre 12 100 3 AuthorID AuthorID 4 4 CopyrightYear CpyrightYr 4 5 ISBNNumber ISBNNumber 12 50 6 Publisher Publisher 12 50 7 Rating Rating 12 50 8 Translator Translator 12 100 9 Pages Pages 4 10 DatePurchased DatePurch 91 11 PurchasedAt PurchaseAt 12 50 12 PurchasePrice PurchPrice 3 17 2 13 CoverType CoverType 12 50 14 EditionNumber EditionNo 4 15 Notes Notes -1 65000 10 Authors 0 AuthorID AuthorID 4 true 1 FirstName FirstName 12 50 2 LastName LastName 12 50 3 Nationality Nationlity 12 50 4 Birthdate Birthdate 91 5 Birthplace Birthplace 12 50 6 DateofDeath DatofDeath 91 7 TrainingLocation TraininLoc 12 50 8 MajorInfluences MajrInflue -1 65000 9 Photo Photo -4 10 Notes Notes -1 65000 11 Accounts 0 AccountID AccountID 4 true 1 AccountNumber AccountNo 12 50 2 AccountName AcountName 12 50 3 AccountTypeID AccTypeID 4 4 AccountType AccountTyp 12 50 5 Description Descrption 12 250 6 Notes Notes -1 65000 12 Investments 0 InvestmentID InvestmtID 4 true 1 AccountID AccountID 4 2 SecurityName SecuriName 12 50 3 SecuritySymbol SecuriSymb 12 20 4 SecurityType SecuriType 12 50 5 SharesOwned ShareOwned 4 6 Notes Notes -1 65000 13 ExerciseLog 0 LogID LogID 4 true 1 PersonID PersonID 4 2 Activity Activity 12 50 3 WorkoutDate WorkoutDat 91 4 ExerciseType ExercisTyp 12 50 5 TimeExercised TimeExerci 12 50 6 DistanceTraveled DistTravel 12 50 7 RestingPulse RestngPuls 4 8 MaximumPulse MaxPulse 4 9 CaloriesBurned CalsBurned 4 10 HoursSleep HoursSleep 4 11 Notes Notes -1 65000 14 DietLog 0 LogID LogID 4 true 1 PersonID PersonID 4 2 DietType DietType 12 50 3 DateAcquired DateAcquir 91 4 WhichMeal WhichMeal 12 50 5 GramsCarbohydrates GrCarbohyd 4 6 GramsProtein GrsProtein 4 7 GramsFat GramsFat 4 8 TotalCalories TotalCals 4 9 MilligramsSodium MilligrSod 4 10 Vitamins Vitamins 12 250 11 Notes Notes -1 65000