University of Houston-Clear Lake
School of Business
Management Information Systems Department
System Analysis and Design
Houston Business Locator
System Analysis Document
Cecil Ureña
Urooj Chaudry
Project Summary
The Houston Business Locator will be a web application that will allow small business owners in the Houston area to make their business known by creating a profile in our site. The customer will be able to search for businesses based on several categories and other useful criteria to find the business that will satisfy their need. This will give unprecedented accessibility to small businesses that would otherwise remain unknown to the majority of the Houston populace. The business profiles will contain information about the business, contact information, links to the business's web site if present, as well as maps powered by Google Maps, allowing the customer to have a precise idea of where the business is located.
System Request
Business Need
•Small businesses in the Houston area need to make themselves known to the public in order to compete with larger businesses.
•Clients need to know how and where to obtain certain services in a readily-accessible system.
Business Requirements
•Web-based system
•Online payment for service
•Email confirmation of payment
•Database for holding business profiles
•Administrative login page for business owner/representative
•Search capabilities using keywords for customers to find businesses
Business Value
•Businesses with profiles hosted at HBL are expected to experience up to 65% growth in customer calls and services.
•Customers will be able to find specific services offered by specific small businesses, making it a successful method of advertisement for these businesses.
Issues/Constraints
•The system should be implemented by the end of April of 2008.
•Businesses should be contacted before the system is released in order to start off with a good list of hosted profiles.
•The system must be targeted to both business owners/representatives and customers of these businesses.
Use-Case Analysis
Context Diagram
Level 0 Data Flow Diagram
Level 1 Data Flow Diagram – Customer
Level 1 Data Flow Diagram – Business
Level 1 Data Flow Diagram – Admin
Component Design
Entity-Relationship Diagram
Data Dictionary
Table: BusinessPage: 8
Properties
DateCreated: 3/2/2008 10:47:06 PMDefaultView: 2
DisplayViewsOnSharePointSi1FilterOnLoad: False
GUID: {guid {D87A6CDA-124F-4198-HideNewField: False
BA6B-0ABB47705AFA}}
LastUpdated: 4/21/2008 11:06:23 PMNameMap: Long binary data
OrderByOn: FalseOrderByOnLoad: True
Orientation: Left-to-RightRecordCount: 8
TotalsRow: FalseUpdatable: True
Columns
NameTypeSize
BusIdLong Integer4
AggregateType: -1
AllowZeroLength: False
AppendOnly: False
Attributes: Fixed Size, Auto-Increment
CollatingOrder: General
ColumnHidden: False
ColumnOrder: 1
ColumnWidth: Default
DataUpdatable: False
GUID: {guid {CB839AEB-3D73-48FE-BE1C-A2B5856FE010}}
OrdinalPosition: 0
Required: False
SourceField: BusId
SourceTable: Business
TextAlign: General
BusNameText50
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: 2220
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid {B78C5240-EA93-4344-B01E-7B7DA7BD8943}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 1
Required: False
SourceField: BusName
SourceTable: Business
TextAlign: General
UnicodeCompression: True
BusDescriptionText255
Table: BusinessPage: 9
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid {D4D670E7-A3FC-4662-BC98-27910BCEAC83}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 2
Required: False
SourceField: BusDescription
SourceTable: Business
TextAlign: General
UnicodeCompression: True
BusAddressText255
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid {797EBF3E-6079-45F3-8131-ABF75FDE54A1}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 3
Required: False
SourceField: BusAddress
SourceTable: Business
TextAlign: General
UnicodeCompression: True
BusCityText255
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid {09D6AEC3-50E7-402A-AC67-F73E024F7C66}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 4
Table: BusinessPage: 10
Required: False
SourceField: BusCity
SourceTable: Business
TextAlign: General
UnicodeCompression: True
BusStateText255
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid {21B699D1-C086-4586-AB85-721EF7AB77FA}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 5
Required: False
SourceField: BusState
SourceTable: Business
TextAlign: General
UnicodeCompression: True
BusZipCodeText255
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid {80CEF055-056C-40BE-B9C6-2630D6DA2D7A}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 6
Required: False
SourceField: BusZipCode
SourceTable: Business
TextAlign: General
UnicodeCompression: True
BusPhoneText14
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
Table: BusinessPage: 11
ColumnWidth: Default
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid {25FE973C-8E49-48E2-A5EC-B32730D7F8B5}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 7
Required: False
SourceField: BusPhone
SourceTable: Business
TextAlign: General
UnicodeCompression: True
BusFaxText14
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid {B56D1F1C-875F-4AD6-993A-DF189C3F5F1B}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 8
Required: False
SourceField: BusFax
SourceTable: Business
TextAlign: General
UnicodeCompression: True
BusEmailText50
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid {EA41C8E8-3A55-44B9-98FA-E9B94A3C885D}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 9
Required: False
SourceField: BusEmail
SourceTable: Business
TextAlign: General
UnicodeCompression: True
BusHoursText50
Table: BusinessPage: 12
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid {2D47CB61-F0FD-4D9A-8B9C-B054AEF5EBD2}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 10
Required: False
SourceField: BusHours
SourceTable: Business
TextAlign: General
UnicodeCompression: True
CategoryIdLong Integer4
AggregateType: -1
AllowZeroLength: False
AppendOnly: False
Attributes: Fixed Size
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
DataUpdatable: False
DecimalPlaces: Auto
DisplayControl: Text Box
GUID: {guid {263041F0-46A9-45AC-8551-6632058D8ED2}}
OrdinalPosition: 11
Required: False
SourceField: CategoryId
SourceTable: Business
TextAlign: General
PackageIdLong Integer4
AggregateType: -1
AllowZeroLength: False
AppendOnly: False
Attributes: Fixed Size
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
DataUpdatable: False
DecimalPlaces: Auto
DisplayControl: Text Box
GUID: {guid {F54B7915-A53C-4904-8CE1-A5C0082736D0}}
OrdinalPosition: 12
Required: False
SourceField: PackageId
SourceTable: Business
Table: BusinessPage: 13
TextAlign: General
PackageExpDateDate/Time8
AggregateType: -1
AllowZeroLength: False
AppendOnly: False
Attributes: Fixed Size
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
DataUpdatable: False
Format: Short Date
GUID: {guid {7D4F5303-3DA0-4504-9A6C-D25C81C4AF72}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 13
Required: False
ShowDatePicker: For dates
SourceField: PackageExpDate
SourceTable: Business
TextAlign: General
UserNameText255
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid {FCD284DC-DF48-459D-A9A0-BCC7DA0F4A6D}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 14
Required: False
SourceField: UserName
SourceTable: Business
TextAlign: General
UnicodeCompression: True
Relationships
BusinessFavoriteBR
BusinessFavoriteBR
BusId1BusId
Attributes: Enforced, Cascade Updates, Cascade Deletes
RelationshipType: One-To-Many
Table: BusinessPage: 14
LoginBusiness
LoginBusiness
UserNameUserName
Attributes: Not Enforced
RelationshipType: One-To-Many
PackageBusiness
PackageBusiness
PackageIdPackageId
Attributes: Not Enforced
RelationshipType: One-To-Many
Table Indexes
NameNumber of Fields
BusinessUserName1
Clustered: False
DistinctCount: 3
Foreign: False
IgnoreNulls: False
Name: BusinessUserName
Primary: False
Required: False
Unique: False
Fields:
UserNameAscending
BusZipCode1
Clustered: False
DistinctCount: 5
Foreign: False
IgnoreNulls: False
Name: BusZipCode
Primary: False
Required: False
Unique: False
Fields:
BusZipCodeAscending
PackageId1
Clustered: False
DistinctCount: 3
Foreign: False
IgnoreNulls: False
Name: PackageId
Primary: False
Required: False
Table: BusinessPage: 15
Unique: False
Fields:
PackageIdAscending
PrimaryKey1
Clustered: False
DistinctCount: 3
Foreign: False
IgnoreNulls: False
Name: PrimaryKey
Primary: True
Required: True
Unique: True
Fields:
BusIdAscending
User Permissions
adminDelete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write
Definition, Read Data, Insert Data, Update Data, Delete Data
Group Permissions
AdminsDelete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write
Definition, Read Data, Insert Data, Update Data, Delete Data
UsersDelete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write
Definition, Read Data, Insert Data, Update Data, Delete Data
Table: CategoryPage: 16
Properties
DateCreated: 3/2/2008 10:56:14 PMDefaultView: 2
DisplayViewsOnSharePointSi1FilterOnLoad: False
GUID: {guid {BDD7EF86-F43B-45A8-HideNewField: False
B1DA-10C11F59D038}}
LastUpdated: 3/2/2008 10:58:56 PMNameMap: Long binary data
OrderByOn: FalseOrderByOnLoad: True
Orientation: Left-to-RightRecordCount: 5
TotalsRow: FalseUpdatable: True
Columns
NameTypeSize
CategoryIdLong Integer4
AggregateType: -1
AllowZeroLength: False
AppendOnly: False
Attributes: Fixed Size, Auto-Increment
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
DataUpdatable: False
OrdinalPosition: 0
Required: False
SourceField: CategoryId
SourceTable: Category
TextAlign: General
CategoryNameText100
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
DataUpdatable: False
DisplayControl: Text Box
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 1
Required: False
SourceField: CategoryName
SourceTable: Category
TextAlign: General
UnicodeCompression: True
CategoryDescriptionText255
AggregateType: -1
AllowZeroLength: True
Table: CategoryPage: 17
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
DataUpdatable: False
DisplayControl: Text Box
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 2
Required: False
SourceField: CategoryDescription
SourceTable: Category
TextAlign: General
UnicodeCompression: True
Table Indexes
NameNumber of Fields
PrimaryKey1
Clustered: False
DistinctCount: 5
Foreign: False
IgnoreNulls: False
Name: PrimaryKey
Primary: True
Required: True
Unique: True
Fields:
CategoryIdAscending
User Permissions
adminDelete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write
Definition, Read Data, Insert Data, Update Data, Delete Data
Group Permissions
AdminsDelete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write
Definition, Read Data, Insert Data, Update Data, Delete Data
UsersDelete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write
Definition, Read Data, Insert Data, Update Data, Delete Data
Table: CustomerPage: 18
Properties
DateCreated: 3/2/2008 11:02:19 PMDefaultView: 2
DisplayViewsOnSharePointSi1FilterOnLoad: False
GUID: {guid {108F7FC9-84B6-4460-HideNewField: False
BEB4-9C4F731DB3F9}}
LastUpdated: 4/18/2008 3:12:38 PMNameMap: Long binary data
OrderByOn: FalseOrderByOnLoad: True
Orientation: Left-to-RightRecordCount: 5
TotalsRow: FalseUpdatable: True
Columns
NameTypeSize
CusIdLong Integer4
AggregateType: -1
AllowZeroLength: False
AppendOnly: False
Attributes: Fixed Size, Auto-Increment
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
DataUpdatable: False
GUID: {guid {689C9F1C-1485-439C-B2A0-4B13D9176399}}
OrdinalPosition: 0
Required: False
SourceField: CusId
SourceTable: Customer
TextAlign: General
CusFirstNameText50
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid {339B4CFE-0DB6-4679-B0A3-4E5430149CDB}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 1
Required: False
SourceField: CusFirstName
SourceTable: Customer
TextAlign: General
UnicodeCompression: True
CusLastNameText50
Table: CustomerPage: 19
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid {180FB93E-8FFB-4AD6-B939-8A8C1783A15A}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 2
Required: False
SourceField: CusLastName
SourceTable: Customer
TextAlign: General
UnicodeCompression: True
CusAddressText255
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid {D27BCFFA-CB04-49CD-822B-C4B929226169}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 3
Required: False
SourceField: CusAddress
SourceTable: Customer
TextAlign: General
UnicodeCompression: True
CusCityText255
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid {4C099697-7338-4440-BB65-69B7CC31ED7E}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 4
Table: CustomerPage: 20
Required: False
SourceField: CusCity
SourceTable: Customer
TextAlign: General
UnicodeCompression: True
CusStateText255
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid {06DD5D55-1851-44F6-8ABC-165B6DB6C733}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 5
Required: False
SourceField: CusState
SourceTable: Customer
TextAlign: General
UnicodeCompression: True
CusZipCodeLong Integer4
AggregateType: -1
AllowZeroLength: False
AppendOnly: False
Attributes: Fixed Size
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
DataUpdatable: False
DecimalPlaces: Auto
DisplayControl: Text Box
GUID: {guid {71A114D4-0341-4929-8E77-1B27525EE4A5}}
OrdinalPosition: 6
Required: False
SourceField: CusZipCode
SourceTable: Customer
TextAlign: General
CusPhoneText14
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
DataUpdatable: False
Table: CustomerPage: 21
DisplayControl: Text Box
GUID: {guid {35DCB9EC-97D9-40CA-86D6-0560C841DAB4}}
IMEMode: 0
IMESentenceMode: 3
InputMask: !\(999") "000\-0000;0;_
OrdinalPosition: 7
Required: False
SourceField: CusPhone
SourceTable: Customer
TextAlign: General
UnicodeCompression: True
CusEmailText255
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid {45B342B7-6AD3-47EF-8FB4-464A0B84B32C}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 8
Required: False
SourceField: CusEmail
SourceTable: Customer
TextAlign: General
UnicodeCompression: True
UserNameText255
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid {C7F103F0-A1A4-456E-9E88-99C98207C3BD}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 9
Required: False
SourceField: UserName
SourceTable: Customer
TextAlign: General
UnicodeCompression: True
Relationships
Table: CustomerPage: 22
CustomerFavoriteBR
CustomerFavoriteBR
CusId1CustId
Attributes: Enforced
RelationshipType: One-To-Many
LoginCustomer
LoginCustomer
UserNameUserName
Attributes: Not Enforced
RelationshipType: One-To-Many
Table Indexes
NameNumber of Fields
CustomerUserName1
Clustered: False
DistinctCount: 2
Foreign: False
IgnoreNulls: False
Name: CustomerUserName
Primary: False
Required: False
Unique: False
Fields:
UserNameAscending
PrimaryKey1
Clustered: False
DistinctCount: 3
Foreign: False
IgnoreNulls: False
Name: PrimaryKey
Primary: True
Required: True
Unique: True
Fields:
CusIdAscending
User Permissions
adminDelete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write
Definition, Read Data, Insert Data, Update Data, Delete Data
Table: CustomerPage: 23
Group Permissions
AdminsDelete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write
Definition, Read Data, Insert Data, Update Data, Delete Data
UsersDelete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write
Definition, Read Data, Insert Data, Update Data, Delete Data
Table: FavoriteBRPage: 24
Properties
DateCreated: 3/2/2008 11:06:50 PMDefaultView: 2
DisplayViewsOnSharePointSi1FilterOnLoad: False
GUID: {guid {7DDBDF2E-B489-4015-HideNewField: False
B655-4C4D7EEC062E}}
LastUpdated: 4/18/2008 3:12:38 PMNameMap: Long binary data
OrderByOn: FalseOrderByOnLoad: True
Orientation: Left-to-RightRecordCount: 7
TotalsRow: FalseUpdatable: True
Columns
NameTypeSize
CustIdLong Integer4
AggregateType: -1
AllowZeroLength: False
AppendOnly: False
Attributes: Fixed Size
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
DataUpdatable: False
DecimalPlaces: Auto
DisplayControl: Text Box
GUID: {guid {1C5C4610-EBA8-4399-8A29-3302D66FC783}}
OrdinalPosition: 0
Required: False
SourceField: CustId
SourceTable: FavoriteBR
TextAlign: General
BusIdLong Integer4
AggregateType: -1
AllowZeroLength: False
AppendOnly: False
Attributes: Fixed Size
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
DataUpdatable: False
DecimalPlaces: Auto
DisplayControl: Text Box
GUID: {guid {C99F464A-04D1-4D01-AA47-382BC4BBBE1D}}
OrdinalPosition: 1
Required: False
SourceField: BusId
SourceTable: FavoriteBR
TextAlign: General
dateaddDate/Time8
Table: FavoriteBRPage: 25
AggregateType: -1
AllowZeroLength: False
AppendOnly: False
Attributes: Fixed Size
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
DataUpdatable: False
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 2
Required: False
ShowDatePicker: For dates
SourceField: dateadd
SourceTable: FavoriteBR
TextAlign: General
Relationships
BusinessFavoriteBR
BusinessFavoriteBR
BusId1BusId
Attributes: Enforced, Cascade Updates, Cascade Deletes
RelationshipType: One-To-Many
CustomerFavoriteBR
CustomerFavoriteBR
CusId1CustId
Attributes: Enforced
RelationshipType: One-To-Many
Table Indexes
NameNumber of Fields
BusId1
Clustered: False
DistinctCount: 0
Foreign: False
IgnoreNulls: False
Name: BusId
Primary: False
Required: False
Unique: False
Fields:
BusIdAscending
Table: FavoriteBRPage: 26
BusinessFavoriteBR1
Clustered: False
DistinctCount: 0
Foreign: True
IgnoreNulls: False
Name: BusinessFavoriteBR
Primary: False
Required: False
Unique: False
Fields:
BusIdAscending
CustomerFavoriteBR1
Clustered: False
DistinctCount: 2
Foreign: True
IgnoreNulls: False
Name: CustomerFavoriteBR
Primary: False
Required: False
Unique: False
Fields:
CustIdAscending
PrimaryKey2
Clustered: False
DistinctCount: 1
Foreign: False
IgnoreNulls: False
Name: PrimaryKey
Primary: True
Required: True
Unique: True
Fields:
CustIdAscending
BusIdAscending
User Permissions
adminDelete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write
Definition, Read Data, Insert Data, Update Data, Delete Data
Group Permissions
AdminsDelete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write
Definition, Read Data, Insert Data, Update Data, Delete Data
UsersDelete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write
Definition, Read Data, Insert Data, Update Data, Delete Data
Table: LoginPage: 27
Properties
DateCreated: 3/2/2008 10:59:03 PMDefaultView: 2
DisplayViewsOnSharePointSi1FilterOnLoad: False
GUID: {guid {F5D5F189-1079-494D-HideNewField: False
9A8D-4844387EFCC3}}
LastUpdated: 4/22/2008 1:26:03 AMNameMap: Long binary data
OrderByOn: FalseOrderByOnLoad: True
Orientation: Left-to-RightRecordCount: 12
TotalsRow: FalseUpdatable: True
Columns
NameTypeSize
UserNameText255
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
DataUpdatable: False
DisplayControl: Text Box
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 0
Required: False
SourceField: UserName
SourceTable: Login
TextAlign: General
UnicodeCompression: False
PasswordText255
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
DataUpdatable: False
DisplayControl: Text Box
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 1
Required: False
SourceField: Password
SourceTable: Login
TextAlign: General
UnicodeCompression: True
Table: LoginPage: 28
UserTypeLong Integer4
AggregateType: -1
AllowZeroLength: False
AppendOnly: False
Attributes: Fixed Size
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
DataUpdatable: False
DecimalPlaces: Auto
DisplayControl: Text Box
OrdinalPosition: 2
Required: False
SourceField: UserType
SourceTable: Login
TextAlign: General
Relationships
LoginBusiness
LoginBusiness
UserNameUserName
Attributes: Not Enforced
RelationshipType: One-To-Many
LoginCustomer
LoginCustomer
UserNameUserName
Attributes: Not Enforced
RelationshipType: One-To-Many
Table Indexes
NameNumber of Fields
PrimaryKey1
Clustered: False
DistinctCount: 8
Foreign: False
IgnoreNulls: False
Name: PrimaryKey
Primary: True
Required: True
Unique: True
Fields:
UserNameAscending
Table: LoginPage: 29