Cost Information System

Only available on StudyMode
  • Topic: Plain text, Foreign key
  • Pages : 204 (21101 words )
  • Download(s) : 157
  • Published : February 3, 2013
Open Document
Text Preview
DESKTOP NORTHWIND SAMPLE DATABASE 2007 STRUCTURE REPORT

Brief Introduction:
Database Name: Northwind
Site/Server Name: Local
Data Stored of Year: 2006
Total Objects: 6 (Tables, Queries, Forms, Reports, Macros, Modules) Total Tables: 20
Total Queries: 27 ,(27 views)
Total Forms: 34
Total Reports: 15
Total Macros: 2
Total Modules: 6 modules and 2 class modules

A Complete Physical Schema of Tables

Table: Customers
Properties
DateCreated: 11/30/2012 2:39:00 AMDefaultView: 2
DisplayViewsOnSharePointSit1FilterOnLoad: False
GUID: {guid {34685D08-E805-496A-HideNewField: False
A5BF-A68CD3B0DADE}}
LastUpdated: 11/30/2012 2:39:22 AMNameMap: Long binary data
OrderByOn: FalseOrderByOnLoad: True
Orientation: Left-to-RightRecordCount: 29
StarColumnHidden: FalseTotalsRow: False
Updatable: TrueWSSTemplateID: 105
Columns
NameTypeSize
IDLong Integer4
AggregateType: -1
AllowValueListEdits: False
AllowZeroLength: False
AppendOnly: False
Attributes: Variable Length, Auto-Increment
BoundColumn: 1
CollatingOrder: Neutral
ColumnCount: 1
ColumnHeads: False
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: 960
DataUpdatable: False
GUID: {guid {C8C60EC3-4849-4B3F-967D-142281F967D6}}
OrdinalPosition: 0
Required: False
RowSourceType: Table/Query
ShowOnlyRowSourceValues: False
SourceField: ID
SourceTable: Customers
TextAlign: General
WSSFieldID: ID
CompanyText50
AggregateType: -1
AllowZeroLength: False
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid {E05DE7F7-517A-4970-9338-F90EFD2357A3}}
IMEMode: 0
IMESentenceMode: 0
OrdinalPosition: 1
Required: False
SourceField: Company
SourceTable: Customers
TextAlign: General
UnicodeCompression: True
WSSFieldID: Company
Last NameText50
AggregateType: -1
AllowZeroLength: False
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid {718F1EF5-AA89-4BAF-98FC-633426FF9699}}
IMEMode: 0
IMESentenceMode: 0
OrdinalPosition: 2
Required: False
SourceField: Last Name
SourceTable: Customers
TextAlign: General
UnicodeCompression: True
WSSFieldID: Title
First NameText50
AggregateType: -1
AllowZeroLength: False
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid {F9E1BF99-B018-49B0-A01B-593B973CE01D}}
IMEMode: 0
IMESentenceMode: 0
OrdinalPosition: 3
Required: False
SourceField: First Name
SourceTable: Customers
TextAlign: General
UnicodeCompression: True
WSSFieldID: FirstName
E-mail AddressText50
AggregateType: -1
AllowMultipleValues: False
AllowValueListEdits: False
AllowZeroLength: False
AppendOnly: False
Attributes: Variable Length
BoundColumn: 1
CollatingOrder: General
ColumnCount: 1
ColumnHeads: False
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: 2400
DataUpdatable: False
DisplayControl: Text Box
GUID: {guid {872206A4-FE85-4365-80B0-AFF60099BD16}}
IMEMode: 2
IMESentenceMode: 0
OrdinalPosition: 4
Required: False
RowSourceType: Table/Query
ShowOnlyRowSourceValues: False
SourceField: E-mail Address
SourceTable: Customers...
tracking img