gistfile1.txt

Hunters-MacBook-Air:ea2 hunter$ mdb-ver ./db/PAIS.mdb 
JET4
Hunters-MacBook-Air:ea2 hunter$ mdb-schema ./db/PAIS.mdb 
-- ----------------------------------------------------------
-- MDB Tools - A library for reading MS Access database files
-- Copyright (C) 2000-2011 Brian Bruns and others.
-- Files in libmdb are licensed under LGPL and the utilities under
-- the GPL, see COPYING.LIB and COPYING files respectively.
-- Check out http://mdbtools.sourceforge.net
-- ----------------------------------------------------------

-- That file uses encoding UTF-8

CREATE TABLE [Account]
 (
	[AccountID]			Long Integer, 
	[Name]			Text (100) NOT NULL, 
	[IsTemplate]			Text (2), 
	[ContactID]			Long Integer, 
	[ContactReceivesReport]			Text (2), 
	[AccountManagerID]			Long Integer, 
	[EnableReports]			Text (2), 
	[ReportDistributionList]			Text (510), 
	[Deleted]			Text (2) NOT NULL, 
	[CreatedUserID]			Long Integer NOT NULL, 
	[CreatedDateTime]			DateTime NOT NULL, 
	[UpdatedUserID]			Long Integer, 
	[UpdatedDateTime]			DateTime, 
	[OptLock]			Text (100)
);

CREATE TABLE [AuditLog]
 (
	[AuditLogID]			Long Integer, 
	[PracticeAreaAssociationID]			Long Integer, 
	[ObjectID]			Text (100), 
	[ObjectType]			Text (200), 
	[ObjectLevelID]			Long Integer, 
	[LevelTypeCode]			Long Integer, 
	[DataTypeCode]			Long Integer, 
	[ActionCode]			Long Integer, 
	[AttributeName]			Text (100), 
	[OldValue]			Memo/Hyperlink (255), 
	[NewValue]			Memo/Hyperlink (255), 
	[AuditDescription]			Text (200), 
	[CreatedUserID]			Long Integer NOT NULL, 
	[CreatedDateTime]			DateTime NOT NULL, 
	[UpdatedUserID]			Long Integer, 
	[UpdatedDateTime]			DateTime, 
	[OptLock]			Text (100)
);

CREATE TABLE [Building]
 (
	[BuildingID]			Long Integer, 
	[SiteID]			Long Integer, 
	[ContactID]			Long Integer, 
	[ContactReceivesReport]			Text (2), 
	[Name]			Text (100) NOT NULL, 
	[Street1]			Text (100) NOT NULL, 
	[Street2]			Text (100), 
	[City]			Text (100) NOT NULL, 
	[State]			Text (4) NOT NULL, 
	[Postal]			Text (20) NOT NULL, 
	[Country]			Text (4) NOT NULL, 
	[SquareFootage]			Long Integer, 
	[Notes]			Memo/Hyperlink (255), 
	[Deleted]			Text (2) NOT NULL, 
	[CreatedUserID]			Long Integer NOT NULL, 
	[CreatedDateTime]			DateTime NOT NULL, 
	[UpdatedUserID]			Long Integer, 
	[UpdatedDateTime]			DateTime, 
	[OptLock]			Text (100), 
	[BuildingCode]			Text (40)
);

CREATE TABLE [Condition]
 (
	[ConditionID]			Long Integer, 
	[Name]			Text (100) NOT NULL, 
	[Sequence]			Long Integer, 
	[CategoryID]			Long Integer, 
	[Threshold]			Numeric (4), 
	[Deleted]			Text (2) NOT NULL, 
	[CreatedUserID]			Long Integer NOT NULL, 
	[CreatedDateTime]			DateTime NOT NULL, 
	[UpdatedUserID]			Long Integer, 
	[UpdatedDateTime]			DateTime, 
	[OptLock]			Text (100), 
	[ConditionCode]			Text (100)
);

CREATE TABLE [ConditionAssociation]
 (
	[ConditionAssociationID]			Long Integer, 
	[PracticeAreaAssociationID]			Long Integer NOT NULL, 
	[ConditionID]			Long Integer NOT NULL, 
	[PracticeAreaID]			Long Integer NOT NULL, 
	[CreatedUserID]			Long Integer NOT NULL, 
	[CreatedDateTime]			DateTime NOT NULL, 
	[UpdatedUserID]			Long Integer, 
	[UpdatedDateTime]			DateTime, 
	[OptLock]			Text (100), 
	[CategoryID]			Long Integer NOT NULL
);

CREATE TABLE [ConsumerTypeAssociation]
 (
	[ConsumerTypeAssociationID]			Long Integer, 
	[ObjectLevelID]			Long Integer, 
	[LevelTypeCode]			Long Integer, 
	[ConsumerTypeID]			Long Integer, 
	[CreatedUserID]			Long Integer NOT NULL, 
	[CreatedDateTime]			DateTime NOT NULL, 
	[UpdatedUserID]			Long Integer, 
	[UpdatedDateTime]			DateTime, 
	[OptLock]			Text (100), 
	[DefaultObject]			Boolean NOT NULL
);

CREATE TABLE [ExceptionReport]
 (
	[ExceptionReportID]			Text (100), 
	[ParentExceptionReportID]			Text (100), 
	[ExceptionType]			Text (200), 
	[ExceptionMessage]			Memo/Hyperlink (255), 
	[StackTrace]			Memo/Hyperlink (255), 
	[UserID]			Long Integer, 
	[ExceptionDateTime]			DateTime, 
	[OSVersion]			Text (100), 
	[MachineName]			Text (100), 
	[NETVersion]			Text (100), 
	[OtherInfo]			Memo/Hyperlink (255), 
	[ClientName]			Text (100), 
	[ClientVersion]			Text (100), 
	[PAISBusinessObjectVersion]			Text (100), 
	[TSIFrameworkVersion]			Text (100), 
	[CreatedUserID]			Long Integer, 
	[CreatedDateTime]			DateTime, 
	[UpdatedUserID]			Long Integer, 
	[UpdatedDateTime]			DateTime
);

CREATE TABLE [Floor]
 (
	[FloorID]			Long Integer, 
	[SectionID]			Long Integer NOT NULL, 
	[Name]			Text (40) NOT NULL, 
	[Sequence]			Long Integer, 
	[Deleted]			Text (2) NOT NULL, 
	[CreatedUserID]			Long Integer NOT NULL, 
	[CreatedDateTime]			DateTime NOT NULL, 
	[UpdatedUserID]			Long Integer, 
	[UpdatedDateTime]			DateTime, 
	[OptLock]			Text (100), 
	[FloorCode]			Text (100), 
	[DefaultObject]			Boolean NOT NULL
);

CREATE TABLE [Inspection]
 (
	[InspectionID]			Text (100), 
	[InspectorPeriodID]			Long Integer NOT NULL, 
	[SitePeriodDefinitionID]			Long Integer NOT NULL, 
	[SitePeriodID]			Long Integer NOT NULL, 
	[RoomTypeID]			Long Integer NOT NULL, 
	[ConsumerTypeID]			Long Integer, 
	[RoomName]			Text (100), 
	[WeightedScore]			Numeric (17), 
	[RawScore]			Numeric (17), 
	[ExperimentalScore]			Numeric (17), 
	[ConsumerRating]			Long Integer, 
	[ConsumerComment]			Memo/Hyperlink (255), 
	[RoomNote]			Memo/Hyperlink (255), 
	[FloorID]			Long Integer NOT NULL, 
	[SectionID]			Long Integer, 
	[BuildingID]			Long Integer, 
	[WorkZoneID]			Long Integer, 
	[PracticeAreaID]			Long Integer, 
	[ItemCount]			Long Integer, 
	[ItemCountWeighted]			Numeric (17), 
	[ItemCountExpWeighted]			Numeric (17), 
	[SatisfactoryItemCount]			Long Integer, 
	[SatisfactoryItemCountWeighted]			Numeric (17), 
	[SatisfactoryItemCountExpWghtd]			Numeric (17), 
	[BadItemCount]			Long Integer, 
	[BadItemCountWeighted]			Numeric (17), 
	[BadItemCountExpWeighted]			Numeric (17), 
	[IsTentative]			Text (2) NOT NULL, 
	[TentativeItemCount]			Long Integer, 
	[StartTime]			DateTime, 
	[EndTime]			DateTime, 
	[Duration]			Long Integer, 
	[CreatedUserID]			Long Integer NOT NULL, 
	[CreatedDateTime]			DateTime NOT NULL, 
	[UpdatedUserID]			Long Integer, 
	[UpdatedDateTime]			DateTime, 
	[OptLock]			Text (100), 
	[KeyEntered]			Text (100), 
	[NumericField]			Numeric (6)
);

CREATE TABLE [InspectionDetail]
 (
	[InspectionDetailID]			Text (100), 
	[InspectionID]			Text (100) NOT NULL, 
	[ItemID]			Long Integer NOT NULL, 
	[ConditionID]			Long Integer NOT NULL, 
	[IsTentative]			Text (2) NOT NULL, 
	[CreatedUserID]			Long Integer NOT NULL, 
	[CreatedDateTime]			DateTime NOT NULL, 
	[UpdatedUserID]			Long Integer, 
	[UpdatedDateTime]			DateTime, 
	[OptLock]			Text (100)
);

CREATE TABLE [InspectionExtDetail]
 (
	[InspectionExtDetailID]			Text (100), 
	[InspectionID]			Text (100), 
	[ItemID]			Long Integer, 
	[ItemNote]			Memo/Hyperlink (255), 
	[ProblemReport]			Memo/Hyperlink (255), 
	[Deleted]			Text (2) NOT NULL, 
	[CreatedUserID]			Long Integer, 
	[CreatedDateTime]			DateTime, 
	[UpdatedUserID]			Long Integer, 
	[UpdatedDateTime]			DateTime, 
	[OptLock]			Text (100), 
	[NumericField]			Numeric (6)
);

CREATE TABLE [InspectionParticlesReading]
 (
	[InspectionParticlesReadingID]			Text (100), 
	[InspectionID]			Text (100) NOT NULL, 
	[Location]			Text (100), 
	[ParticleCount0_3]			Long Integer, 
	[ParticleCount0_5]			Long Integer, 
	[ParticleCount1_0]			Long Integer, 
	[ParticleCount2_5]			Long Integer, 
	[ParticleCount5_0]			Long Integer, 
	[ParticleCount10_0]			Long Integer, 
	[Temperature]			Numeric (3), 
	[Humidity]			Numeric (3), 
	[CreatedUserID]			Long Integer NOT NULL, 
	[CreatedDateTime]			DateTime NOT NULL, 
	[UpdatedUserID]			Long Integer, 
	[UpdatedDateTime]			DateTime, 
	[OptLock]			Text (100), 
	[MeasurementNumber]			Long Integer, 
	[ReadingDateTime]			DateTime, 
	[EstimatedReadingDateTime]			DateTime
);

CREATE TABLE [InspectorAssignment]
 (
	[InspectorAssignmentID]			Long Integer, 
	[InspectorID]			Long Integer, 
	[SitePeriodDefinitionID]			Long Integer, 
	[PracticeAreaAssociationID]			Long Integer, 
	[TargetBuildingCount]			Long Integer, 
	[TargetInspectionCount]			Long Integer, 
	[LastSyncDeltaIDPAA]			Long Integer, 
	[LastSyncDeltaIDPAA2]			Long Integer, 
	[CreatedUserID]			Long Integer NOT NULL, 
	[CreatedDateTime]			DateTime NOT NULL, 
	[UpdatedUserID]			Long Integer, 
	[UpdatedDateTime]			DateTime, 
	[OptLock]			Text (100)
);

CREATE TABLE [InspectorPeriod]
 (
	[InspectorPeriodID]			Long Integer, 
	[SitePeriodID]			Long Integer, 
	[SitePeriodDefinitionID]			Long Integer, 
	[PracticeAreaAssociationID]			Long Integer, 
	[InspectorID]			Long Integer, 
	[StatusCode]			Long Integer, 
	[BuildingCount]			Long Integer, 
	[TargetBuildingCount]			Long Integer, 
	[TargetCloseDate]			DateTime, 
	[CloseDate]			DateTime, 
	[TargetInspectionCount]			Long Integer, 
	[InspectionCount]			Long Integer, 
	[TargetOpenDate]			DateTime, 
	[OpenDate]			DateTime, 
	[LastSyncDate]			DateTime, 
	[ConsumerCount]			Long Integer, 
	[CurrentScore]			Numeric (17), 
	[Deleted]			Text (2) NOT NULL, 
	[CreatedUserID]			Long Integer NOT NULL, 
	[CreatedDateTime]			DateTime NOT NULL, 
	[UpdatedUserID]			Long Integer, 
	[UpdatedDateTime]			DateTime, 
	[OptLock]			Text (100), 
	[DeletedInspectionCount]			Long Integer
);

CREATE TABLE [Item]
 (
	[ItemID]			Long Integer, 
	[Name]			Text (100) NOT NULL, 
	[ShortName]			Text (40), 
	[PluralName]			Text (100), 
	[Deleted]			Text (2) NOT NULL, 
	[CreatedUserID]			Long Integer NOT NULL, 
	[CreatedDateTime]			DateTime NOT NULL, 
	[UpdatedUserID]			Long Integer, 
	[UpdatedDateTime]			DateTime, 
	[OptLock]			Text (100)
);

CREATE TABLE [ItemSequence]
 (
	[ItemSequenceID]			Long Integer, 
	[InspectorID]			Long Integer, 
	[ItemID]			Long Integer, 
	[Sequence]			Long Integer, 
	[Deleted]			Text (2) NOT NULL, 
	[CreatedUserID]			Long Integer NOT NULL, 
	[CreatedDateTime]			DateTime NOT NULL, 
	[UpdatedUserID]			Long Integer, 
	[UpdatedDateTime]			DateTime, 
	[OptLock]			Text (100)
);

CREATE TABLE [KeyGroup]
 (
	[KeyGroupID]			Long Integer, 
	[PracticeAreaAssociationID]			Long Integer, 
	[Name]			Text (100) NOT NULL, 
	[LevelTypeCode]			Long Integer, 
	[InspectionRatingHigh]			Long Integer, 
	[InspectionRatingLow]			Long Integer, 
	[ConsumerRatingHigh]			Long Integer, 
	[ConsumerRatingLow]			Long Integer, 
	[Deleted]			Text (2) NOT NULL, 
	[CreatedUserID]			Long Integer NOT NULL, 
	[CreatedDateTime]			DateTime NOT NULL, 
	[UpdatedUserID]			Long Integer, 
	[UpdatedDateTime]			DateTime, 
	[OptLock]			Text (100)
);

CREATE TABLE [KeyGroupAssociation]
 (
	[KeyGroupAssociationID]			Long Integer, 
	[PracticeAreaAssociationID]			Long Integer, 
	[KeyGroupID]			Long Integer, 
	[ObjectLevelID]			Long Integer, 
	[LevelTypeCode]			Long Integer, 
	[CreatedUserID]			Long Integer NOT NULL, 
	[CreatedDateTime]			DateTime NOT NULL, 
	[UpdatedUserID]			Long Integer, 
	[UpdatedDateTime]			DateTime, 
	[OptLock]			Text (100)
);

CREATE TABLE [LookupCode]
 (
	[LookupID]			Long Integer, 
	[Name]			Text (100), 
	[Code]			Long Integer, 
	[Meaning]			Text (300)
);

CREATE TABLE [Message]
 (
	[MessageID]			Long Integer, 
	[PracticeAreaAssociationID]			Long Integer NOT NULL, 
	[MessageText]			Memo/Hyperlink (255) NOT NULL, 
	[PriorityCode]			Long Integer, 
	[Deleted]			Text (2) NOT NULL, 
	[CreatedUserID]			Long Integer NOT NULL, 
	[CreatedDateTime]			DateTime NOT NULL, 
	[UpdatedUserID]			Long Integer, 
	[UpdatedDateTime]			DateTime, 
	[OptLock]			Text (100)
);

CREATE TABLE [MessageOpened]
 (
	[MessageOpenedID]			Long Integer, 
	[MessageID]			Long Integer, 
	[UserID]			Long Integer, 
	[PracticeAreaAssociationID]			Long Integer, 
	[OpenedDateTime]			DateTime, 
	[CreatedUserID]			Long Integer, 
	[CreatedDateTime]			DateTime, 
	[UpdatedUserID]			Long Integer, 
	[UpdatedDateTime]			DateTime, 
	[OptLock]			Text (100)
);

CREATE TABLE [PAISUser]
 (
	[UserID]			Long Integer, 
	[Email]			Text (100), 
	[FirstName]			Text (100), 
	[LastName]			Text (100), 
	[Street1]			Text (100), 
	[Street2]			Text (100), 
	[City]			Text (100), 
	[State]			Text (4), 
	[Postal]			Text (20), 
	[Country]			Text (4), 
	[PhoneAreaCode]			Text (6), 
	[Phone]			Text (20), 
	[PhoneExt]			Text (10), 
	[MobileAreaCode]			Text (6), 
	[Mobile]			Text (20), 
	[FaxAreaCode]			Text (6), 
	[Fax]			Text (20), 
	[Password]			Text (200), 
	[AccountID]			Long Integer, 
	[ServiceProviderID]			Long Integer, 
	[ItemsPerPage]			Long Integer, 
	[ReceivesReports]			Text (2) NOT NULL, 
	[AssignmentCount]			Long Integer, 
	[IsAdmin]			Text (2) NOT NULL, 
	[IsAccountAdmin]			Text (2) NOT NULL, 
	[IsCSR]			Text (2) NOT NULL, 
	[IsProjectAdmin]			Text (2) NOT NULL, 
	[IsSiteAdmin]			Text (2) NOT NULL, 
	[IsEAInspector]			Text (2) NOT NULL, 
	[IsClientAdmin]			Text (2) NOT NULL, 
	[IsClientInspector]			Text (2) NOT NULL, 
	[IsServiceProvider]			Text (2) NOT NULL, 
	[LastSyncDeltaIDInspection]			Long Integer, 
	[LastSyncDeltaIDAssignment]			Long Integer, 
	[LastSyncDeltaIDGlobal]			Long Integer, 
	[LastSyncDeltaIDInspection2]			Long Integer, 
	[LastSyncDeltaIDAssignment2]			Long Integer, 
	[LastSyncDeltaIDGlobal2]			Long Integer, 
	[LastLoginDate]			DateTime, 
	[LoginCount]			Long Integer, 
	[Deleted]			Text (2) NOT NULL, 
	[CreatedUserID]			Long Integer NOT NULL, 
	[CreatedDateTime]			DateTime NOT NULL, 
	[UpdatedUserID]			Long Integer, 
	[UpdatedDateTime]			DateTime, 
	[OptLock]			Text (100)
);

CREATE TABLE [Period]
 (
	[PeriodID]			Long Integer, 
	[PeriodDefinitionID]			Long Integer NOT NULL, 
	[ObjectLevelID]			Long Integer, 
	[LevelTypeCode]			Long Integer, 
	[PracticeAreaID]			Long Integer, 
	[CloseDate]			DateTime, 
	[OpenDate]			DateTime, 
	[ReportStatusCode]			Long Integer, 
	[ReportName]			Text (200), 
	[ReportDateTime]			DateTime, 
	[Deleted]			Text (2) NOT NULL, 
	[Converted]			Text (2), 
	[CreatedUserID]			Long Integer NOT NULL, 
	[CreatedDateTime]			DateTime NOT NULL, 
	[UpdatedUserID]			Long Integer, 
	[UpdatedDateTime]			DateTime, 
	[OptLock]			Text (100)
);

CREATE TABLE [PeriodDefinition]
 (
	[PeriodDefinitionID]			Long Integer, 
	[ObjectLevelID]			Long Integer, 
	[LevelTypeCode]			Long Integer, 
	[PracticeAreaID]			Long Integer, 
	[FrequencyCode]			Long Integer, 
	[PeriodStartDate]			DateTime NOT NULL, 
	[InspectionRatingHigh]			Long Integer, 
	[InspectionRatingLow]			Long Integer, 
	[ConsumerRatingHigh]			Long Integer, 
	[ConsumerRatingLow]			Long Integer, 
	[AutoGenerateReport]			Text (2), 
	[RequireClosedSitePeriods]			Text (2), 
	[WorkZoneThresholdTop]			Long Integer, 
	[WorkZoneThresholdBottom]			Long Integer, 
	[CreatedUserID]			Long Integer NOT NULL, 
	[CreatedDateTime]			DateTime NOT NULL, 
	[UpdatedUserID]			Long Integer, 
	[UpdatedDateTime]			DateTime, 
	[OptLock]			Text (100)
);

CREATE TABLE [PracticeArea]
 (
	[PracticeAreaID]			Long Integer, 
	[Name]			Text (100) NOT NULL, 
	[Level4Label]			Text (100) NOT NULL, 
	[Level4LabelPlural]			Text (100), 
	[Level5Label]			Text (100) NOT NULL, 
	[Level5LabelPlural]			Text (100), 
	[Level6Label]			Text (100) NOT NULL, 
	[Level6LabelPlural]			Text (100), 
	[ReportLabel1]			Text (100), 
	[ReportLabel2]			Text (100), 
	[ReportLabel3]			Text (100), 
	[Deleted]			Text (2) NOT NULL, 
	[CreatedUserID]			Long Integer NOT NULL, 
	[CreatedDateTime]			DateTime NOT NULL, 
	[UpdatedUserID]			Long Integer, 
	[UpdatedDateTime]			DateTime, 
	[OptLock]			Text (100), 
	[Level7label]			Text (100), 
	[Level7labelPlural]			Text (100), 
	[Level8label]			Text (100), 
	[Level8labelPlural]			Text (100), 
	[Level9label]			Text (100), 
	[Level9labelPlural]			Text (100), 
	[NumericFieldLabel]			Text (100)
);

CREATE TABLE [PracticeAreaAssociation]
 (
	[PracticeAreaAssociationID]			Long Integer, 
	[ObjectLevelID]			Long Integer NOT NULL, 
	[LevelTypeCode]			Long Integer NOT NULL, 
	[PracticeAreaID]			Long Integer, 
	[InspectionRatingHigh]			Long Integer, 
	[InspectionRatingLow]			Long Integer, 
	[ConsumerRatingHigh]			Long Integer, 
	[ConsumerRatingLow]			Long Integer, 
	[SitePracticeAreaAssociationID]			Long Integer, 
	[Deleted]			Text (2) NOT NULL, 
	[CreatedUserID]			Long Integer NOT NULL, 
	[CreatedDateTime]			DateTime NOT NULL, 
	[UpdatedUserID]			Long Integer, 
	[UpdatedDateTime]			DateTime, 
	[OptLock]			Text (100), 
	[DefaultObject]			Boolean NOT NULL
);

CREATE TABLE [Procedure]
 (
	[ProcedureID]			Long Integer, 
	[ItemID]			Long Integer, 
	[ConditionID]			Long Integer, 
	[ProcedureFileName]			Text (200), 
	[Description]			Memo/Hyperlink (255), 
	[CreatedUserID]			Long Integer, 
	[CreatedDateTime]			DateTime, 
	[UpdatedUserID]			Long Integer, 
	[UpdatedDateTime]			DateTime, 
	[OptLock]			Text (100)
);

CREATE TABLE [Project]
 (
	[ProjectID]			Long Integer, 
	[AccountID]			Long Integer NOT NULL, 
	[ContactID]			Long Integer, 
	[ContactReceivesReport]			Text (2), 
	[Name]			Text (100) NOT NULL, 
	[ProjectManagerID]			Long Integer, 
	[ReportDistributionList]			Text (510), 
	[EnableReports]			Text (2), 
	[Deleted]			Text (2) NOT NULL, 
	[CreatedUserID]			Long Integer NOT NULL, 
	[CreatedDateTime]			DateTime NOT NULL, 
	[UpdatedUserID]			Long Integer, 
	[UpdatedDateTime]			DateTime, 
	[OptLock]			Text (100)
);

CREATE TABLE [Report]
 (
	[ReportID]			Long Integer, 
	[Name]			Text (200), 
	[ReportFileName]			Text (500), 
	[Sequence]			Long Integer, 
	[AdditionalParms]			Text (510), 
	[CreatedUserID]			Long Integer, 
	[CreatedDateTime]			DateTime, 
	[UpdatedUserID]			Long Integer, 
	[UpdatedDateTime]			DateTime, 
	[OptLock]			Text (100), 
	[IsDefault]			Boolean NOT NULL, 
	[DefaultSequence]			Long Integer, 
	[ReportLargeImagePath]			Text (200), 
	[ReportSmallImagePath]			Text (200), 
	[Description]			Text (510)
);

CREATE TABLE [ReportAssociation]
 (
	[ReportAssociationID]			Long Integer, 
	[PracticeAreaAssociationID]			Long Integer, 
	[ReportID]			Long Integer, 
	[Sequence]			Long Integer, 
	[CreatedUserID]			Long Integer, 
	[CreatedDateTime]			DateTime, 
	[UpdatedUserID]			Long Integer, 
	[UpdatedDateTime]			DateTime, 
	[OptLock]			Text (100), 
	[LevelTypeCode]			Long Integer, 
	[PeriodDefinitionID]			Long Integer
);

CREATE TABLE [RoomType]
 (
	[RoomTypeID]			Long Integer, 
	[Name]			Text (100) NOT NULL, 
	[ShortName]			Text (40), 
	[PluralName]			Text (100), 
	[InspectionRatingHigh]			Long Integer, 
	[InspectionRatingLow]			Long Integer, 
	[ConsumerRatingHigh]			Long Integer, 
	[ConsumerRatingLow]			Long Integer, 
	[Deleted]			Text (2) NOT NULL, 
	[CreatedUserID]			Long Integer NOT NULL, 
	[CreatedDateTime]			DateTime NOT NULL, 
	[UpdatedUserID]			Long Integer, 
	[UpdatedDateTime]			DateTime, 
	[OptLock]			Text (100), 
	[RoomTypeCode]			Text (40)
);

CREATE TABLE [RoomTypeAssociation]
 (
	[RoomTypeAssociationID]			Long Integer, 
	[PracticeAreaAssociationID]			Long Integer NOT NULL, 
	[ObjectLevelID]			Long Integer NOT NULL, 
	[LevelTypeCode]			Long Integer NOT NULL, 
	[RoomTypeID]			Long Integer NOT NULL, 
	[InspectionRatingHigh]			Long Integer, 
	[InspectionRatingLow]			Long Integer, 
	[ConsumerRatingHigh]			Long Integer, 
	[ConsumerRatingLow]			Long Integer, 
	[Exclude]			Text (2) NOT NULL, 
	[Deleted]			Text (2) NOT NULL, 
	[CreatedUserID]			Long Integer NOT NULL, 
	[CreatedDateTime]			DateTime NOT NULL, 
	[UpdatedUserID]			Long Integer, 
	[UpdatedDateTime]			DateTime, 
	[OptLock]			Text (100), 
	[DefaultObject]			Boolean NOT NULL
);

CREATE TABLE [Section]
 (
	[SectionID]			Long Integer, 
	[BuildingID]			Long Integer NOT NULL, 
	[Name]			Text (100) NOT NULL, 
	[Deleted]			Text (2) NOT NULL, 
	[CreatedUserID]			Long Integer NOT NULL, 
	[CreatedDateTime]			DateTime NOT NULL, 
	[UpdatedUserID]			Long Integer, 
	[UpdatedDateTime]			DateTime, 
	[OptLock]			Text (100), 
	[SectionCode]			Text (40), 
	[DefaultObject]			Boolean NOT NULL
);

CREATE TABLE [SecurityToken]
 (
	[SecurityTokenID]			Long Integer, 
	[AccountID]			Long Integer, 
	[ProjectID]			Long Integer, 
	[SiteID]			Long Integer, 
	[PracticeAreaAssociationID]			Long Integer, 
	[ServiceProviderID]			Long Integer
);

CREATE TABLE [ServiceProvider]
 (
	[ServiceProviderID]			Long Integer, 
	[Name]			Text (100) NOT NULL, 
	[Street1]			Text (100), 
	[Street2]			Text (100), 
	[City]			Text (100), 
	[State]			Text (4), 
	[Postal]			Text (20), 
	[Country]			Text (20), 
	[PhoneAreaCode]			Text (6), 
	[Phone]			Text (20), 
	[FaxAreaCode]			Text (100), 
	[Fax]			Text (100), 
	[Deleted]			Text (2) NOT NULL, 
	[CreatedUserID]			Long Integer NOT NULL, 
	[CreatedDateTime]			DateTime NOT NULL, 
	[UpdatedUserID]			Long Integer, 
	[UpdatedDateTime]			DateTime, 
	[OptLock]			Text (100)
);

CREATE TABLE [ServiceProviderAssociation]
 (
	[ServiceProviderAssociationID]			Long Integer, 
	[ServiceProviderID]			Long Integer, 
	[PracticeAreaAssociationID]			Long Integer, 
	[IsSub]			Text (2) NOT NULL, 
	[PrimeServiceProviderID]			Long Integer, 
	[InspectionRatingHigh]			Long Integer, 
	[InspectionRatingLow]			Long Integer, 
	[ConsumerRatingHigh]			Long Integer, 
	[ConsumerRatingLow]			Long Integer, 
	[ServiceProviderContactID]			Long Integer, 
	[ContactReceivesReports]			Text (2), 
	[CreatedUserID]			Long Integer NOT NULL, 
	[CreatedDateTime]			DateTime NOT NULL, 
	[UpdatedUserID]			Long Integer, 
	[UpdatedDateTime]			DateTime, 
	[OptLock]			Text (100)
);

CREATE TABLE [Site]
 (
	[SiteID]			Long Integer, 
	[ProjectID]			Long Integer NOT NULL, 
	[ContactID]			Long Integer, 
	[ContactReceivesReport]			Text (2) NOT NULL, 
	[Name]			Text (200) NOT NULL, 
	[ConsumerRatingMax]			Long Integer, 
	[SiteManagerID]			Long Integer, 
	[IsTemplate]			Text (2), 
	[ReportDistributionList]			Text (510), 
	[Deleted]			Text (2), 
	[CreatedUserID]			Long Integer NOT NULL, 
	[CreatedDateTime]			DateTime NOT NULL, 
	[UpdatedUserID]			Long Integer, 
	[UpdatedDateTime]			DateTime, 
	[OptLock]			Text (100)
);

CREATE TABLE [SitePeriod]
 (
	[SitePeriodID]			Long Integer, 
	[SitePeriodDefinitionID]			Long Integer NOT NULL, 
	[SiteID]			Long Integer, 
	[PracticeAreaAssociationID]			Long Integer, 
	[PracticeAreaID]			Long Integer, 
	[StatusCode]			Long Integer, 
	[TargetBuildingCount]			Long Integer NOT NULL, 
	[BuildingCount]			Long Integer, 
	[TargetCloseDate]			DateTime, 
	[CloseDate]			DateTime, 
	[TargetInspectionCount]			Long Integer NOT NULL, 
	[InspectionCount]			Long Integer, 
	[TargetOpenDate]			DateTime, 
	[OpenDate]			DateTime, 
	[AssignedInspectorCount]			Long Integer, 
	[OpenInspectorPeriodCount]			Long Integer, 
	[InspectorPeriodCount]			Long Integer, 
	[TentativeRoomTypeCount]			Long Integer, 
	[TentativeItemCount]			Long Integer, 
	[ReportStatusCode]			Long Integer, 
	[ReportName]			Text (200), 
	[ReportDateTime]			DateTime, 
	[Deleted]			Text (2) NOT NULL, 
	[Converted]			Text (2), 
	[CreatedUserID]			Long Integer NOT NULL, 
	[CreatedDateTime]			DateTime NOT NULL, 
	[UpdatedUserID]			Long Integer, 
	[UpdatedDateTime]			DateTime, 
	[OptLock]			Text (100)
);

CREATE TABLE [SitePeriodDefinition]
 (
	[SitePeriodDefinitionID]			Long Integer, 
	[PracticeAreaAssociationID]			Long Integer, 
	[SiteID]			Long Integer, 
	[TargetBuildingCount]			Long Integer NOT NULL, 
	[TargetInspectionCount]			Long Integer NOT NULL, 
	[FrequencyCode]			Long Integer, 
	[PeriodStartDate]			DateTime NOT NULL, 
	[AutoGenerateReport]			Text (2), 
	[MinNumInspections]			Text (2), 
	[MinNumBuildings]			Text (2), 
	[RequireAllInspectors]			Text (2), 
	[NarrativeReportName]			Text (200), 
	[WorkZoneThresholdTop]			Long Integer, 
	[WorkZoneThresholdBottom]			Long Integer, 
	[IsSelfService]			Text (2), 
	[Deleted]			Text (2) NOT NULL, 
	[CreatedUserID]			Long Integer NOT NULL, 
	[CreatedDateTime]			DateTime NOT NULL, 
	[UpdatedUserID]			Long Integer, 
	[UpdatedDateTime]			DateTime, 
	[OptLock]			Text (100), 
	[Level4label]			Text (100), 
	[Level4labelPlural]			Text (100), 
	[Level5label]			Text (100), 
	[Level5labelPlural]			Text (100), 
	[Level6label]			Text (100), 
	[Level6labelPlural]			Text (100), 
	[Level7label]			Text (100), 
	[Level7labelPlural]			Text (100), 
	[Level8label]			Text (100), 
	[Level8labelPlural]			Text (100), 
	[Level9label]			Text (100), 
	[Level9labelPlural]			Text (100), 
	[ReportLabel1]			Text (100), 
	[ReportLabel2]			Text (100), 
	[ReportLabel3]			Text (100), 
	[NumericFieldLabel]			Text (100)
);

CREATE TABLE [Supervisor]
 (
	[SupervisorID]			Long Integer, 
	[PracticeAreaAssociationID]			Long Integer NOT NULL, 
	[ServiceProviderID]			Long Integer NOT NULL, 
	[PrimeServiceProviderID]			Long Integer, 
	[FirstName]			Text (100) NOT NULL, 
	[LastName]			Text (100) NOT NULL, 
	[PhoneAreaCode]			Text (6), 
	[Phone]			Text (16), 
	[CellAreaCode]			Text (6), 
	[Cell]			Text (16), 
	[PagerAreaCode]			Text (6), 
	[Pager]			Text (16), 
	[Email]			Text (200), 
	[Deleted]			Text (2) NOT NULL, 
	[CreatedUserID]			Long Integer NOT NULL, 
	[CreatedDateTime]			DateTime NOT NULL, 
	[UpdatedUserID]			Long Integer, 
	[UpdatedDateTime]			DateTime, 
	[OptLock]			Text (100)
);

CREATE TABLE [SyncDelta]
 (
	[SyncDeltaID]			Long Integer, 
	[ObjectID]			Text (100), 
	[ObjectType]			Text (100), 
	[ObjectMgrType]			Text (100), 
	[ActionCode]			Long Integer, 
	[PracticeAreaAssociationID]			Long Integer, 
	[IsGlobal]			Text (2), 
	[CreatedDateTime]			DateTime NOT NULL, 
	[CreatedUserID]			Long Integer NOT NULL, 
	[UpdatedDateTime]			DateTime, 
	[UpdatedUserID]			Long Integer, 
	[OptLock]			Text (100)
);

CREATE TABLE [WorkZoneLocation]
 (
	[WorkZoneLocationID]			Long Integer, 
	[WorkZoneID]			Long Integer NOT NULL, 
	[PracticeAreaAssociationID]			Long Integer, 
	[ObjectLevelID]			Long Integer NOT NULL, 
	[LevelTypeCode]			Long Integer NOT NULL, 
	[CreatedUserID]			Long Integer NOT NULL, 
	[CreatedDateTime]			DateTime NOT NULL, 
	[UpdatedUserID]			Long Integer, 
	[UpdatedDateTime]			DateTime, 
	[OptLock]			Text (100)
);

CREATE TABLE [WorkZoneRoomType]
 (
	[WorkZoneRoomTypeID]			Long Integer, 
	[WorkZoneID]			Long Integer NOT NULL, 
	[PracticeAreaAssociationID]			Long Integer, 
	[RoomTypeID]			Long Integer NOT NULL, 
	[AllRoomTypes]			Text (2) NOT NULL, 
	[CreatedUserID]			Long Integer NOT NULL, 
	[CreatedDateTime]			DateTime NOT NULL, 
	[UpdatedUserID]			Long Integer, 
	[UpdatedDateTime]			DateTime, 
	[OptLock]			Text (100)
);

CREATE TABLE [ConsumerType]
 (
	[ConsumerTypeID]			Long Integer, 
	[Name]			Text (100) NOT NULL, 
	[Sequence]			Long Integer, 
	[Deleted]			Text (2) NOT NULL, 
	[CreatedUserID]			Long Integer NOT NULL, 
	[CreatedDateTime]			DateTime NOT NULL, 
	[UpdatedUserID]			Long Integer, 
	[UpdatedDateTime]			DateTime, 
	[OptLock]			Text (100), 
	[ConsumerTypeCode]			Text (40)
);

CREATE TABLE [ItemAssociation]
 (
	[ItemAssociationID]			Long Integer, 
	[PracticeAreaAssociationID]			Long Integer, 
	[ObjectLevelID]			Long Integer NOT NULL, 
	[LevelTypeCode]			Long Integer NOT NULL, 
	[ItemID]			Long Integer NOT NULL, 
	[Exclude]			Text (2) NOT NULL, 
	[Experimental]			Numeric (4), 
	[Weight]			Numeric (4), 
	[Deleted]			Text (2) NOT NULL, 
	[CreatedUserID]			Long Integer NOT NULL, 
	[CreatedDateTime]			DateTime NOT NULL, 
	[UpdatedUserID]			Long Integer, 
	[UpdatedDateTime]			DateTime, 
	[OptLock]			Text (100), 
	[DefaultObject]			Boolean NOT NULL
);

CREATE TABLE [WorkZone]
 (
	[WorkZoneID]			Long Integer, 
	[PracticeAreaAssociationID]			Long Integer NOT NULL, 
	[ServiceProviderID]			Long Integer NOT NULL, 
	[PrimeServiceProviderID]			Long Integer, 
	[SupervisorID]			Long Integer, 
	[Name]			Text (100) NOT NULL, 
	[Deleted]			Text (2) NOT NULL, 
	[CreatedUserID]			Long Integer NOT NULL, 
	[CreatedDateTime]			DateTime NOT NULL, 
	[UpdatedUserID]			Long Integer, 
	[UpdatedDateTime]			DateTime, 
	[OptLock]			Text (100)
);

Hunters-MacBook-Air:ea2 hunter$ mdb-array ./db/PAIS.mdb Account
/******************************************************************/
/* THIS IS AN AUTOMATICALLY GENERATED FILE.  DO NOT EDIT IT!!!!!! */
/******************************************************************/

#include <stdio.h>
#include "types.h"
#include "dump.h"

const Account Account_array [] = {
{				/*      0 */
		2010, 
	"PECO Energy Company", 
	"", 
	0, 
	"0", 
	4002, 
	"0", 
	"1004", 
	"0", 
	1004, 
	06/13/05 08:45:30, 
	1004, 
	11/18/05 12:08:15, 
	""
},
{				/*      1 */
		2011, 
	"Lehigh University", 
	"", 
	0, 
	"0", 
	1005, 
	"0", 
	"1004", 
	"0", 
	1004, 
	06/13/05 15:55:58, 
	1004, 
	11/18/05 15:13:48, 
	""
},
{				/*      2 */
		2031, 
	"NOVA Southeastern University", 
	"", 
	0, 
	"0", 
	4006, 
	"0", 
	"1004", 
	"0", 
	1004, 
	08/04/10 15:23:02, 
	, 
	, 
	""
}
};