flav r03-2.accdb friday, november 17, 2017 · c:\users\erin.antognoli\downloads\flav_r03-2.accdb...

35
C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017 Page: 1 Table: DATA_SRC Properties AlternateBackShade: 100 AlternateBackThemeColorInd -1 AlternateBackTint: 100 BackShade: 100 BackTint: 100 DatasheetForeThemeColorIn -1 DatasheetGridlinesThemeCol -1 DateCreated: 8/3/2012 9:19:37 AM DefaultView: 2 DisplayViewsOnSharePointSit 1 FilterOnLoad: False GUID: {guid {61BE4878-5970-4D09- B32D-D52F201C7E15}} HideNewField: False LastUpdated: 11/20/2015 10:51:22 AM NameMap: Long binary data OrderBy: [DATA_SRC].[DataSrc_ID] OrderByOn: False OrderByOnLoad: True Orientation: Left-to-Right RecordCount: 309 ThemeFontIndex: -1 TotalsRow: False Updatable: True Columns Name Type Size DataSrc_ID Short Text 5 AggregateType: -1 AllowZeroLength: True AppendOnly: False Attributes: Variable Length CollatingOrder: General ColumnHidden: False ColumnOrder: Default ColumnWidth: 1188 CurrencyLCID: 0 DataUpdatable: False DisplayControl: Text Box GUID: {guid {7DBD32A0-3EBB-414D-BC75-9F72396A5718}} IMEMode: 0 IMESentenceMode: 3 OrdinalPosition: 0 Required: True ResultType: 0 SourceField: DataSrc_ID SourceTable: DATA_SRC TextAlign: General UnicodeCompression: False Authors Short Text 255 AggregateType: -1 AllowZeroLength: True AppendOnly: False Attributes: Variable Length CollatingOrder: General ColumnHidden: False ColumnOrder: Default ColumnWidth: 7644 CurrencyLCID: 0 DataUpdatable: False

Upload: others

Post on 07-Aug-2020

0 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: Flav R03-2.accdb Friday, November 17, 2017 · C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017 Table: DATA_SRC Page: 1 Properties AlternateBackShade: 100

C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017

Page: 1Table: DATA_SRC

Properties

AlternateBackShade: 100 AlternateBackThemeColorInd -1

AlternateBackTint: 100 BackShade: 100

BackTint: 100 DatasheetForeThemeColorIn -1

DatasheetGridlinesThemeCol -1 DateCreated: 8/3/2012 9:19:37 AM

DefaultView: 2 DisplayViewsOnSharePointSit 1

FilterOnLoad: False GUID: {guid {61BE4878-5970-4D09-B32D-D52F201C7E15}}

HideNewField: False LastUpdated: 11/20/2015 10:51:22 AM

NameMap: Long binary data OrderBy: [DATA_SRC].[DataSrc_ID]

OrderByOn: False OrderByOnLoad: True

Orientation: Left-to-Right RecordCount: 309

ThemeFontIndex: -1 TotalsRow: False

Updatable: True

Columns

Name Type Size

DataSrc_ID Short Text 5

AggregateType: -1

AllowZeroLength: True

AppendOnly: False

Attributes: Variable Length

CollatingOrder: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: 1188

CurrencyLCID: 0

DataUpdatable: False

DisplayControl: Text Box

GUID: {guid {7DBD32A0-3EBB-414D-BC75-9F72396A5718}}

IMEMode: 0

IMESentenceMode: 3

OrdinalPosition: 0

Required: True

ResultType: 0

SourceField: DataSrc_ID

SourceTable: DATA_SRC

TextAlign: General

UnicodeCompression: False

Authors Short Text 255

AggregateType: -1

AllowZeroLength: True

AppendOnly: False

Attributes: Variable Length

CollatingOrder: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: 7644

CurrencyLCID: 0

DataUpdatable: False

Page 2: Flav R03-2.accdb Friday, November 17, 2017 · C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017 Table: DATA_SRC Page: 1 Properties AlternateBackShade: 100

C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017

Page: 2Table: DATA_SRC

DisplayControl: Text Box

Format: @

GUID: {guid {6AF0E346-B8B6-428D-AA7D-0CA7372130AA}}

IMEMode: 0

IMESentenceMode: 3

OrdinalPosition: 1

Required: False

ResultType: 0

SourceField: Authors

SourceTable: DATA_SRC

TextAlign: General

UnicodeCompression: False

Title Short Text 255

AggregateType: -1

AllowZeroLength: True

AppendOnly: False

Attributes: Variable Length

CollatingOrder: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: 8328

CurrencyLCID: 0

DataUpdatable: False

DisplayControl: Text Box

Format: @

GUID: {guid {56794A1F-B58D-4B67-A32E-410E9EEC4A49}}

IMEMode: 0

IMESentenceMode: 3

OrdinalPosition: 2

Required: False

ResultType: 0

SourceField: Title

SourceTable: DATA_SRC

TextAlign: General

UnicodeCompression: False

Jorunal Short Text 255

AggregateType: -1

AllowZeroLength: True

AppendOnly: False

Attributes: Variable Length

CollatingOrder: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: 2628

CurrencyLCID: 0

DataUpdatable: False

DisplayControl: Text Box

Format: @

GUID: {guid {9E8071DF-3A11-48F1-B465-7A5E47EAFCF9}}

IMEMode: 0

IMESentenceMode: 3

OrdinalPosition: 3

Required: False

Page 3: Flav R03-2.accdb Friday, November 17, 2017 · C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017 Table: DATA_SRC Page: 1 Properties AlternateBackShade: 100

C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017

Page: 3Table: DATA_SRC

ResultType: 0

SourceField: Jorunal

SourceTable: DATA_SRC

TextAlign: General

UnicodeCompression: False

Year Short Text 255

AggregateType: -1

AllowZeroLength: True

AppendOnly: False

Attributes: Variable Length

CollatingOrder: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: Default

CurrencyLCID: 0

DataUpdatable: False

DisplayControl: Text Box

GUID: {guid {E102359B-551C-4796-992B-66A73F780D1C}}

IMEMode: 0

IMESentenceMode: 3

OrdinalPosition: 4

Required: False

ResultType: 0

SourceField: Year

SourceTable: DATA_SRC

TextAlign: 1

UnicodeCompression: False

Volume Short Text 6

AggregateType: -1

AllowZeroLength: True

AppendOnly: False

Attributes: Variable Length

CollatingOrder: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: Default

CurrencyLCID: 0

DataUpdatable: False

DisplayControl: Text Box

GUID: {guid {E830ED75-20CF-4FBC-971E-04CC44CBEF6D}}

IMEMode: 0

IMESentenceMode: 3

OrdinalPosition: 5

Required: False

ResultType: 0

SourceField: Volume

SourceTable: DATA_SRC

TextAlign: 1

UnicodeCompression: False

Issue Short Text 6

AggregateType: -1

AllowZeroLength: True

Page 4: Flav R03-2.accdb Friday, November 17, 2017 · C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017 Table: DATA_SRC Page: 1 Properties AlternateBackShade: 100

C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017

Page: 4Table: DATA_SRC

AppendOnly: False

Attributes: Variable Length

CollatingOrder: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: Default

CurrencyLCID: 0

DataUpdatable: False

DisplayControl: Text Box

Format: @

GUID: {guid {1DCAF91F-54C4-4390-8EA1-504A9AEA6938}}

IMEMode: 0

IMESentenceMode: 3

OrdinalPosition: 6

Required: False

ResultType: 0

SourceField: Issue

SourceTable: DATA_SRC

TextAlign: 1

UnicodeCompression: False

Start_Page Short Text 6

AggregateType: -1

AllowZeroLength: True

AppendOnly: False

Attributes: Variable Length

CollatingOrder: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: Default

CurrencyLCID: 0

DataUpdatable: False

DisplayControl: Text Box

GUID: {guid {0F80E10C-469D-4F66-9F03-671E0038A521}}

IMEMode: 0

IMESentenceMode: 3

OrdinalPosition: 7

Required: False

ResultType: 0

SourceField: Start_Page

SourceTable: DATA_SRC

TextAlign: 1

UnicodeCompression: False

Emd_Page Short Text 6

AggregateType: -1

AllowZeroLength: True

AppendOnly: False

Attributes: Variable Length

CollatingOrder: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: Default

CurrencyLCID: 0

DataUpdatable: False

Page 5: Flav R03-2.accdb Friday, November 17, 2017 · C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017 Table: DATA_SRC Page: 1 Properties AlternateBackShade: 100

C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017

Page: 5Table: DATA_SRC

DisplayControl: Text Box

GUID: {guid {5E6C1EBD-F837-44C7-B94E-82AE77922523}}

IMEMode: 0

IMESentenceMode: 3

OrdinalPosition: 8

Required: False

ResultType: 0

SourceField: Emd_Page

SourceTable: DATA_SRC

TextAlign: 1

UnicodeCompression: False

User Permissions

admin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete Data

Group Permissions

Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete Data

Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete Data

Relationships

DATA_SRCDATSRCLN

DATA_SRC DATSRCLN

1DataSrc_ID DataSrc_ID

Attributes: Enforced

RelationshipType: One-To-Many

Table Indexes

Name Number of Fields

PrimaryKey 1

Clustered: False

DistinctCount: 309

Foreign: False

IgnoreNulls: False

Name: PrimaryKey

Primary: True

Required: True

Unique: True

Fields:

AscendingDataSrc_ID

Page 6: Flav R03-2.accdb Friday, November 17, 2017 · C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017 Table: DATA_SRC Page: 1 Properties AlternateBackShade: 100

C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017

Page: 6Table: DATSRCLN

Properties

AlternateBackShade: 100 AlternateBackThemeColorInd -1

AlternateBackTint: 100 BackShade: 100

BackTint: 100 DatasheetForeThemeColorIn -1

DatasheetGridlinesThemeCol -1 DateCreated: 12/18/2013 3:36:36 PM

DefaultView: 2 DisplayViewsOnSharePointSit 1

Filter: ([DATSRCLN].[NDB_No]="16108")

FilterOnLoad: False

GUID: {guid {5FAD85BB-F7EB-4386-

BC62-E0543784FEBD}}

HideNewField: False

LastUpdated: 11/20/2015 10:51:22 AM NameMap: Long binary data

OrderByOn: False OrderByOnLoad: True

Orientation: Left-to-Right PublishToWeb: 1

RecordCount: 6059 ThemeFontIndex: -1

TotalsRow: False Updatable: True

Columns

Name Type Size

NDB_No Short Text 5

AggregateType: -1

AllowZeroLength: True

AppendOnly: False

Attributes: Variable Length

CollatingOrder: General

ColumnHidden: False

ColumnOrder: 1

ColumnWidth: Default

CurrencyLCID: 0

DataUpdatable: False

DisplayControl: Text Box

GUID: {guid {143A6F0D-093D-4667-AE2F-98A746DB7664}}

IMEMode: 0

IMESentenceMode: 3

OrdinalPosition: 0

Required: False

SourceField: NDB_No

SourceTable: DATSRCLN

TextAlign: General

UnicodeCompression: True

Nutr_no Short Text 3

AggregateType: -1

AllowZeroLength: True

AppendOnly: False

Attributes: Variable Length

CollatingOrder: General

ColumnHidden: False

ColumnOrder: 2

ColumnWidth: Default

CurrencyLCID: 0

DataUpdatable: False

Page 7: Flav R03-2.accdb Friday, November 17, 2017 · C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017 Table: DATA_SRC Page: 1 Properties AlternateBackShade: 100

C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017

Page: 7Table: DATSRCLN

DisplayControl: Text Box

GUID: {guid {3A2C47F3-2EB5-4ACF-ADD0-71CD7A97731C}}

IMEMode: 0

IMESentenceMode: 3

OrdinalPosition: 1

Required: False

SourceField: Nutr_no

SourceTable: DATSRCLN

TextAlign: General

UnicodeCompression: True

DataSrc_ID Short Text 255

AggregateType: -1

AllowZeroLength: True

AppendOnly: False

Attributes: Variable Length

CollatingOrder: General

ColumnHidden: False

ColumnOrder: 3

ColumnWidth: Default

CurrencyLCID: 0

DataUpdatable: False

DisplayControl: Text Box

GUID: {guid {92CCC6AD-F111-4103-BACE-6324805A97D3}}

IMEMode: 0

IMESentenceMode: 3

OrdinalPosition: 2

Required: False

SourceField: DataSrc_ID

SourceTable: DATSRCLN

TextAlign: General

UnicodeCompression: False

Relationships

DATA_SRCDATSRCLN

DATA_SRC DATSRCLN

1DataSrc_ID DataSrc_ID

Attributes: Enforced

RelationshipType: One-To-Many

Page 8: Flav R03-2.accdb Friday, November 17, 2017 · C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017 Table: DATA_SRC Page: 1 Properties AlternateBackShade: 100

C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017

Page: 8Table: DATSRCLN

FLAV_DATDATSRCLN

FLAV_DAT DATSRCLN

NDB_No NDB_No

Nutr_no Nutr_no

Attributes: Not Enforced

RelationshipType: One-To-Many

FLAV_INDDATSRCLN

FLAV_IND DATSRCLN

DataSrc ID DataSrc_ID

Attributes: Not Enforced

RelationshipType: Indeterminate

Table Indexes

Name Number of Fields

DATA_SRCDATSRCLN 1

Clustered: False

DistinctCount: 308

Foreign: True

IgnoreNulls: False

Name: DATA_SRCDATSRCLN

Primary: False

Required: False

Unique: False

Fields:

AscendingDataSrc_ID

DATSRCLNNDB_No 1

Clustered: False

DistinctCount: 506

Foreign: False

IgnoreNulls: False

Name: DATSRCLNNDB_No

Primary: False

Required: False

Unique: False

Fields:

AscendingNDB_No

PrimaryKey 3

Clustered: False

DistinctCount: 6059

Foreign: False

IgnoreNulls: False

Name: PrimaryKey

Primary: True

Page 9: Flav R03-2.accdb Friday, November 17, 2017 · C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017 Table: DATA_SRC Page: 1 Properties AlternateBackShade: 100

C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017

Page: 9Table: DATSRCLN

User Permissions

admin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete Data

Group Permissions

Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete Data

Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete Data

Required: True

Unique: True

Fields:

AscendingNDB_No

AscendingNutr_no

AscendingDataSrc_ID

Page 10: Flav R03-2.accdb Friday, November 17, 2017 · C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017 Table: DATA_SRC Page: 1 Properties AlternateBackShade: 100

C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017

Page: 10Table: FD_GROUP

Properties

DateCreated: 10/9/2012 1:32:33 PM DefaultView: 2

DisplayViewsOnSharePointSit 1 FilterOnLoad: False

GUID: {guid {7C764460-BAA7-4D29-A328-29BD268BAB1B}}

HideNewField: False

LastUpdated: 11/20/2015 10:51:22 AM NameMap: Long binary data

OrderByOn: False OrderByOnLoad: True

Orientation: Left-to-Right RecordCount: 12

TotalsRow: False Updatable: True

Columns

Name Type Size

FdGrp_CD Short Text 4

AggregateType: -1

AllowZeroLength: True

AppendOnly: False

Attributes: Variable Length

CollatingOrder: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: Default

DataUpdatable: False

DisplayControl: Text Box

GUID: {guid {D284C155-8EEF-45F5-9D17-F03465ED7A58}}

IMEMode: 0

IMESentenceMode: 3

OrdinalPosition: 0

Required: False

SourceField: FdGrp_CD

SourceTable: FD_GROUP

TextAlign: General

UnicodeCompression: False

FdGrp_Desc Short Text 60

AggregateType: -1

AllowZeroLength: True

AppendOnly: False

Attributes: Variable Length

CollatingOrder: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: 3744

DataUpdatable: False

DisplayControl: Text Box

GUID: {guid {B95598E6-92AE-4A5E-A8E3-64214E6BC521}}

IMEMode: 0

IMESentenceMode: 3

OrdinalPosition: 1

Required: False

SourceField: FdGrp_Desc

SourceTable: FD_GROUP

Page 11: Flav R03-2.accdb Friday, November 17, 2017 · C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017 Table: DATA_SRC Page: 1 Properties AlternateBackShade: 100

C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017

Page: 11Table: FD_GROUP

TextAlign: General

UnicodeCompression: False

User Permissions

admin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete Data

Group Permissions

Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete Data

Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete Data

Relationships

FD_GROUPFOOD_DES

FD_GROUP FOOD_DES

1FdGrp_CD FdGrp_Cd

Attributes: Enforced

RelationshipType: One-To-Many

Table Indexes

Name Number of Fields

PrimaryKey 1

Clustered: False

DistinctCount: 12

Foreign: False

IgnoreNulls: False

Name: PrimaryKey

Primary: True

Required: True

Unique: True

Fields:

AscendingFdGrp_CD

Page 12: Flav R03-2.accdb Friday, November 17, 2017 · C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017 Table: DATA_SRC Page: 1 Properties AlternateBackShade: 100

C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017

Page: 12Table: FLAV_DAT

Properties

AlternateBackShade: 100 AlternateBackThemeColorInd -1

AlternateBackTint: 100 BackShade: 100

BackTint: 100 DatasheetForeThemeColorIn -1

DatasheetGridlinesThemeCol -1 DateCreated: 8/8/2013 10:03:56 AM

DefaultView: 2 DisplayViewsOnSharePointSit 1

Filter: ([FLAV_DAT].[NDB_No]="16108")

FilterOnLoad: False

GUID: {guid {163C1CC3-0AE3-4D54-

8922-3A56DC7A0DAA}}

HideNewField: False

LastUpdated: 11/20/2015 10:51:22 AM NameMap: Long binary data

OrderByOn: False OrderByOnLoad: True

Orientation: Left-to-Right PublishToWeb: 1

RecordCount: 3621 ThemeFontIndex: -1

TotalsRow: False Updatable: True

Columns

Name Type Size

NDB_No Short Text 5

AggregateType: -1

AllowZeroLength: True

AppendOnly: False

Attributes: Variable Length

CollatingOrder: General

ColumnHidden: False

ColumnOrder: 1

ColumnWidth: Default

CurrencyLCID: 0

DataUpdatable: False

DisplayControl: Text Box

GUID: {guid {F3873834-6BF3-4261-A500-4FA9DA2CB36C}}

IMEMode: 0

IMESentenceMode: 3

OrdinalPosition: 0

Required: False

SourceField: NDB_No

SourceTable: FLAV_DAT

TextAlign: General

UnicodeCompression: True

Nutr_no Short Text 3

AggregateType: -1

AllowZeroLength: True

AppendOnly: False

Attributes: Variable Length

CollatingOrder: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: Default

CurrencyLCID: 0

DataUpdatable: False

Page 13: Flav R03-2.accdb Friday, November 17, 2017 · C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017 Table: DATA_SRC Page: 1 Properties AlternateBackShade: 100

C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017

Page: 13Table: FLAV_DAT

DisplayControl: Text Box

GUID: {guid {8B9BB37A-342E-41B3-9684-1D811BB35585}}

IMEMode: 0

IMESentenceMode: 3

OrdinalPosition: 1

Required: False

SourceField: Nutr_no

SourceTable: FLAV_DAT

TextAlign: General

UnicodeCompression: True

Flav_Val Double 8

AggregateType: -1

AllowZeroLength: False

AppendOnly: False

Attributes: Variable Length

CollatingOrder: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: Default

CurrencyLCID: 0

DataUpdatable: False

DecimalPlaces: 2

DisplayControl: Text Box

Format: Fixed

GUID: {guid {F053E686-DC2B-4ECC-9AE6-2B577A385755}}

OrdinalPosition: 3

Required: False

SourceField: Flav_Val

SourceTable: FLAV_DAT

TextAlign: General

SE Double 8

AggregateType: -1

AllowZeroLength: False

AppendOnly: False

Attributes: Variable Length

CollatingOrder: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: Default

CurrencyLCID: 0

DataUpdatable: False

DecimalPlaces: 2

DisplayControl: Text Box

Format: Fixed

GUID: {guid {459F616A-A898-4A69-8F7D-F2E8C38F875C}}

OrdinalPosition: 4

Required: False

SourceField: SE

SourceTable: FLAV_DAT

TextAlign: General

n Integer 2

AggregateType: -1

Page 14: Flav R03-2.accdb Friday, November 17, 2017 · C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017 Table: DATA_SRC Page: 1 Properties AlternateBackShade: 100

C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017

Page: 14Table: FLAV_DAT

AllowZeroLength: False

AppendOnly: False

Attributes: Fixed Size

CollatingOrder: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: Default

CurrencyLCID: 0

DataUpdatable: False

DecimalPlaces: Auto

DisplayControl: Text Box

GUID: {guid {7417DEAA-2F3D-474B-9ADC-A6B3853DA84F}}

OrdinalPosition: 5

Required: False

SourceField: n

SourceTable: FLAV_DAT

TextAlign: General

Min Double 8

AggregateType: -1

AllowZeroLength: False

AppendOnly: False

Attributes: Variable Length

CollatingOrder: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: Default

CurrencyLCID: 0

DataUpdatable: False

DecimalPlaces: 2

DisplayControl: Text Box

Format: Fixed

GUID: {guid {2E4C4BAE-754D-4E86-89E0-598155DC6359}}

OrdinalPosition: 6

Required: False

SourceField: Min

SourceTable: FLAV_DAT

TextAlign: General

Max Double 8

AggregateType: -1

AllowZeroLength: False

AppendOnly: False

Attributes: Variable Length

CollatingOrder: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: Default

CurrencyLCID: 0

DataUpdatable: False

DecimalPlaces: 2

DisplayControl: Text Box

Format: Fixed

GUID: {guid {9C305772-A251-44B2-849F-D6293E8BCFDE}}

OrdinalPosition: 7

Page 15: Flav R03-2.accdb Friday, November 17, 2017 · C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017 Table: DATA_SRC Page: 1 Properties AlternateBackShade: 100

C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017

Page: 15Table: FLAV_DAT

Required: False

SourceField: Max

SourceTable: FLAV_DAT

TextAlign: General

CC Short Text 2

AggregateType: -1

AllowZeroLength: True

AppendOnly: False

Attributes: Variable Length

CollatingOrder: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: Default

CurrencyLCID: 0

DataUpdatable: False

DisplayControl: Text Box

GUID: {guid {61B773C6-E80A-4964-A4D6-EC183A693002}}

IMEMode: 0

IMESentenceMode: 3

OrdinalPosition: 8

Required: False

SourceField: CC

SourceTable: FLAV_DAT

TextAlign: General

UnicodeCompression: False

Relationships

FLAV_DATDATSRCLN

FLAV_DAT DATSRCLN

NDB_No NDB_No

Nutr_no Nutr_no

Attributes: Not Enforced

RelationshipType: One-To-Many

FLAV_DATFLAV_IND

FLAV_DAT FLAV_IND

NDB_No NDB_No

Attributes: Not Enforced

RelationshipType: Indeterminate

Page 16: Flav R03-2.accdb Friday, November 17, 2017 · C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017 Table: DATA_SRC Page: 1 Properties AlternateBackShade: 100

C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017

Page: 16Table: FLAV_DAT

FOOD_DESFLAV_DAT

FOOD_DES FLAV_DAT

1NDB_No NDB_No

Attributes: Enforced

RelationshipType: One-To-Many

NUTR_DEFFLAV_DAT

NUTR_DEF FLAV_DAT

1Nutr_no Nutr_no

Attributes: Enforced

RelationshipType: One-To-Many

Table Indexes

Name Number of Fields

FOOD_DESFLAV_DAT 1

Clustered: False

DistinctCount: 506

Foreign: True

IgnoreNulls: False

Name: FOOD_DESFLAV_DAT

Primary: False

Required: False

Unique: False

Fields:

AscendingNDB_No

NUTR_DEFFLAV_DAT 1

Clustered: False

DistinctCount: 25

Foreign: True

IgnoreNulls: False

Name: NUTR_DEFFLAV_DAT

Primary: False

Required: False

Unique: False

Fields:

AscendingNutr_no

PrimaryKey 2

Clustered: False

DistinctCount: 3621

Foreign: False

IgnoreNulls: False

Name: PrimaryKey

Primary: True

Required: True

Page 17: Flav R03-2.accdb Friday, November 17, 2017 · C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017 Table: DATA_SRC Page: 1 Properties AlternateBackShade: 100

C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017

Page: 17Table: FLAV_DAT

User Permissions

admin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete Data

Group Permissions

Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete Data

Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete Data

Unique: True

Fields:

AscendingNDB_No

AscendingNutr_no

Page 18: Flav R03-2.accdb Friday, November 17, 2017 · C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017 Table: DATA_SRC Page: 1 Properties AlternateBackShade: 100

C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017

Page: 18Table: FLAV_IND

Properties

AlternateBackShade: 100 AlternateBackThemeColorInd -1

AlternateBackTint: 100 BackShade: 100

BackTint: 100 DatasheetForeThemeColorIn -1

DatasheetGridlinesThemeCol -1 DateCreated: 5/7/2013 11:04:18 AM

DefaultView: 2 DisplayViewsOnSharePointSit 1

Filter: ([FLAV_IND].[NDB_No]="16108")

FilterOnLoad: False

GUID: {guid {C7895156-5978-492B-

841C-A2C1CAB4F5DF}}

HideNewField: False

LastUpdated: 11/20/2015 10:41:54 AM NameMap: Long binary data

OrderByOn: False OrderByOnLoad: True

Orientation: Left-to-Right PublishToWeb: 1

RecordCount: 24130 ThemeFontIndex: -1

TotalsRow: False Updatable: True

Columns

Name Type Size

NDB_No Short Text 255

AggregateType: -1

AllowZeroLength: True

AppendOnly: False

Attributes: Variable Length

CollatingOrder: General

ColumnHidden: False

ColumnOrder: 1

ColumnWidth: 1152

CurrencyLCID: 0

DataUpdatable: False

DisplayControl: Text Box

Format: @

GUID: {guid {0E12F5BF-AB6D-497B-B816-2D65F3A7A150}}

IMEMode: 0

IMESentenceMode: 3

OrdinalPosition: 0

Required: False

ResultType: 0

SourceField: NDB_No

SourceTable: FLAV_IND

TextAlign: General

UnicodeCompression: False

DataSrc ID Short Text 5

AggregateType: -1

AllowZeroLength: True

AppendOnly: False

Attributes: Variable Length

CollatingOrder: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: 1308

Page 19: Flav R03-2.accdb Friday, November 17, 2017 · C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017 Table: DATA_SRC Page: 1 Properties AlternateBackShade: 100

C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017

Page: 19Table: FLAV_IND

CurrencyLCID: 0

DataUpdatable: False

DisplayControl: Text Box

Format: @

GUID: {guid {4095F642-B778-46A8-AA10-92300C6D0C8D}}

IMEMode: 0

IMESentenceMode: 3

OrdinalPosition: 1

Required: False

ResultType: 0

SourceField: DataSrc ID

SourceTable: FLAV_IND

TextAlign: General

UnicodeCompression: False

Food No Short Text 255

AggregateType: -1

AllowZeroLength: True

AppendOnly: False

Attributes: Variable Length

CollatingOrder: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: 1140

CurrencyLCID: 0

DataUpdatable: False

DisplayControl: Text Box

Format: @

GUID: {guid {77B30E0E-38A6-4B61-AF8B-81909766D289}}

IMEMode: 0

IMESentenceMode: 3

OrdinalPosition: 2

Required: False

ResultType: 0

SourceField: Food No

SourceTable: FLAV_IND

TextAlign: General

UnicodeCompression: False

FoodIndiv_Desc Short Text 255

AggregateType: -1

AllowZeroLength: True

AppendOnly: False

Attributes: Variable Length

CollatingOrder: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: 3912

CurrencyLCID: 0

DataUpdatable: False

DisplayControl: Text Box

Format: @

GUID: {guid {84AE7F96-4CED-4AA8-ADF7-73DF674A1E5D}}

IMEMode: 0

IMESentenceMode: 3

Page 20: Flav R03-2.accdb Friday, November 17, 2017 · C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017 Table: DATA_SRC Page: 1 Properties AlternateBackShade: 100

C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017

Page: 20Table: FLAV_IND

OrdinalPosition: 3

Required: False

ResultType: 0

SourceField: FoodIndiv_Desc

SourceTable: FLAV_IND

TextAlign: General

UnicodeCompression: False

Method Short Text 255

AggregateType: -1

AllowZeroLength: True

AppendOnly: False

Attributes: Variable Length

CollatingOrder: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: 1116

CurrencyLCID: 0

DataUpdatable: False

DisplayControl: Text Box

Format: @

GUID: {guid {55CAC864-956F-4FC7-B1A5-9F6E7814CEAC}}

IMEMode: 0

IMESentenceMode: 3

OrdinalPosition: 4

Required: False

ResultType: 0

SourceField: Method

SourceTable: FLAV_IND

TextAlign: General

UnicodeCompression: False

Cmpd_Name Short Text 255

AggregateType: -1

AllowZeroLength: True

AppendOnly: False

Attributes: Variable Length

CollatingOrder: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: 1644

CurrencyLCID: 0

DataUpdatable: False

DisplayControl: Text Box

Format: @

GUID: {guid {E332EC4B-2F96-45B9-9E5E-18F4FAFE9DCB}}

IMEMode: 0

IMESentenceMode: 3

OrdinalPosition: 5

Required: False

ResultType: 0

SourceField: Cmpd_Name

SourceTable: FLAV_IND

TextAlign: General

UnicodeCompression: False

Page 21: Flav R03-2.accdb Friday, November 17, 2017 · C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017 Table: DATA_SRC Page: 1 Properties AlternateBackShade: 100

C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017

Page: 21Table: FLAV_IND

Rptd CmpdVal Double 8

AggregateType: -1

AllowZeroLength: False

AppendOnly: False

Attributes: Variable Length

CollatingOrder: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: 1620

CurrencyLCID: 0

DataUpdatable: False

DecimalPlaces: Auto

DisplayControl: Text Box

Format: Fixed

GUID: {guid {4610F1EF-7E97-4914-90A9-E90A63D18F42}}

OrdinalPosition: 6

Required: False

ResultType: 0

SourceField: Rptd CmpdVal

SourceTable: FLAV_IND

TextAlign: General

Rptd_Std Dev Short Text 255

AggregateType: -1

AllowZeroLength: True

AppendOnly: False

Attributes: Variable Length

CollatingOrder: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: 1560

CurrencyLCID: 0

DataUpdatable: False

DisplayControl: Text Box

Format: @

GUID: {guid {D89EE128-6090-464B-B581-66CDAEFD58A5}}

IMEMode: 0

IMESentenceMode: 3

OrdinalPosition: 7

Required: False

ResultType: 0

SourceField: Rptd_Std Dev

SourceTable: FLAV_IND

TextAlign: General

UnicodeCompression: False

Num_Data_Pts Double 8

AggregateType: -1

AllowZeroLength: False

AppendOnly: False

Attributes: Variable Length

CollatingOrder: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: 1704

Page 22: Flav R03-2.accdb Friday, November 17, 2017 · C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017 Table: DATA_SRC Page: 1 Properties AlternateBackShade: 100

C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017

Page: 22Table: FLAV_IND

CurrencyLCID: 0

DataUpdatable: False

DecimalPlaces: Auto

DisplayControl: Text Box

Format: General Number

GUID: {guid {C0D1A1C8-B352-4715-9B08-454E513567B7}}

OrdinalPosition: 8

Required: False

ResultType: 0

SourceField: Num_Data_Pts

SourceTable: FLAV_IND

TextAlign: General

LT Short Text 255

AggregateType: -1

AllowZeroLength: True

AppendOnly: False

Attributes: Variable Length

CollatingOrder: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: 768

CurrencyLCID: 0

DataUpdatable: False

DisplayControl: Text Box

Format: @

GUID: {guid {EA123B77-D3F6-4917-A232-819D226BD468}}

IMEMode: 0

IMESentenceMode: 3

OrdinalPosition: 9

Required: False

ResultType: 0

SourceField: LT

SourceTable: FLAV_IND

TextAlign: General

UnicodeCompression: False

Rptd_Units Short Text 255

AggregateType: -1

AllowZeroLength: True

AppendOnly: False

Attributes: Variable Length

CollatingOrder: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: 1356

CurrencyLCID: 0

DataUpdatable: False

DisplayControl: Text Box

Format: @

GUID: {guid {F2AE1CBB-8F89-489C-981C-5BDEE507C48D}}

IMEMode: 0

IMESentenceMode: 3

OrdinalPosition: 10

Required: False

Page 23: Flav R03-2.accdb Friday, November 17, 2017 · C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017 Table: DATA_SRC Page: 1 Properties AlternateBackShade: 100

C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017

Page: 23Table: FLAV_IND

ResultType: 0

SourceField: Rptd_Units

SourceTable: FLAV_IND

TextAlign: General

UnicodeCompression: False

Fresh Dry_Wt Short Text 255

AggregateType: -1

AllowZeroLength: True

AppendOnly: False

Attributes: Variable Length

CollatingOrder: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: 1572

CurrencyLCID: 0

DataUpdatable: False

DisplayControl: Text Box

Format: @

GUID: {guid {A5CD5928-C219-4527-8282-3512F95D16CC}}

IMEMode: 0

IMESentenceMode: 3

OrdinalPosition: 11

Required: False

ResultType: 0

SourceField: Fresh Dry_Wt

SourceTable: FLAV_IND

TextAlign: General

UnicodeCompression: False

Quant_Std Short Text 255

AggregateType: -1

AllowZeroLength: True

AppendOnly: False

Attributes: Variable Length

CollatingOrder: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: 1308

CurrencyLCID: 0

DataUpdatable: False

DisplayControl: Text Box

Format: @

GUID: {guid {D2024DB5-A9EA-4212-81DD-C6738D91C621}}

IMEMode: 0

IMESentenceMode: 3

OrdinalPosition: 12

Required: False

ResultType: 0

SourceField: Quant_Std

SourceTable: FLAV_IND

TextAlign: General

UnicodeCompression: False

Conv_Factor_G Double 8

Page 24: Flav R03-2.accdb Friday, November 17, 2017 · C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017 Table: DATA_SRC Page: 1 Properties AlternateBackShade: 100

C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017

Page: 24Table: FLAV_IND

AggregateType: -1

AllowZeroLength: False

AppendOnly: False

Attributes: Variable Length

CollatingOrder: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: 1740

CurrencyLCID: 0

DataUpdatable: False

DecimalPlaces: Auto

DisplayControl: Text Box

Format: 0.0000

GUID: {guid {73ECE51A-D218-4016-BBD2-D348D8FF0A0D}}

OrdinalPosition: 13

Required: False

ResultType: 0

SourceField: Conv_Factor_G

SourceTable: FLAV_IND

TextAlign: General

Conv_Factor_M Short Text 255

AggregateType: -1

AllowZeroLength: True

AppendOnly: False

Attributes: Variable Length

CollatingOrder: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: 1788

CurrencyLCID: 0

DataUpdatable: False

DisplayControl: Text Box

Format: @

GUID: {guid {800CD0CE-51B6-457C-AB76-696A90EF3E64}}

IMEMode: 0

IMESentenceMode: 3

OrdinalPosition: 14

Required: False

ResultType: 0

SourceField: Conv_Factor_M

SourceTable: FLAV_IND

TextAlign: General

UnicodeCompression: False

Conv_Factor_SpGr Double 8

AggregateType: -1

AllowZeroLength: False

AppendOnly: False

Attributes: Variable Length

CollatingOrder: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: 2016

CurrencyLCID: 0

Page 25: Flav R03-2.accdb Friday, November 17, 2017 · C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017 Table: DATA_SRC Page: 1 Properties AlternateBackShade: 100

C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017

Page: 25Table: FLAV_IND

DataUpdatable: False

DecimalPlaces: Auto

DisplayControl: Text Box

Format: 0.0000

GUID: {guid {B1CEC6DD-3E32-4676-8937-068633B12473}}

OrdinalPosition: 15

Required: False

ResultType: 0

SourceField: Conv_Factor_SpGr

SourceTable: FLAV_IND

TextAlign: General

Cmpd_Val Double 8

AggregateType: -1

AllowZeroLength: False

AppendOnly: False

Attributes: Variable Length

CollatingOrder: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: 3168

CurrencyLCID: 0

DataUpdatable: False

DecimalPlaces: Auto

DisplayControl: Text Box

Format: Fixed

GUID: {guid {8A2757CA-3E78-4918-9722-2242008CBF3F}}

OrdinalPosition: 16

Required: False

ResultType: 0

SourceField: Cmpd_Val

SourceTable: FLAV_IND

TextAlign: General

Cmpt_StdDev Short Text 255

AggregateType: -1

AllowZeroLength: True

AppendOnly: False

Attributes: Variable Length

CollatingOrder: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: 3552

CurrencyLCID: 0

DataUpdatable: False

DisplayControl: Text Box

Format: @

GUID: {guid {BA7C554D-DF5F-4671-B1B9-8049292F0D10}}

IMEMode: 0

IMESentenceMode: 3

OrdinalPosition: 17

Required: False

ResultType: 0

SourceField: Cmpt_StdDev

SourceTable: FLAV_IND

Page 26: Flav R03-2.accdb Friday, November 17, 2017 · C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017 Table: DATA_SRC Page: 1 Properties AlternateBackShade: 100

C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017

Page: 26Table: FLAV_IND

TextAlign: General

UnicodeCompression: False

Relationships

FLAV_DATFLAV_IND

FLAV_DAT FLAV_IND

NDB_No NDB_No

Attributes: Not Enforced

RelationshipType: Indeterminate

FLAV_INDDATSRCLN

FLAV_IND DATSRCLN

DataSrc ID DataSrc_ID

Attributes: Not Enforced

RelationshipType: Indeterminate

Table Indexes

Name Number of Fields

DataSrc ID 1

Clustered: False

DistinctCount: 307

Foreign: False

IgnoreNulls: False

Name: DataSrc ID

Primary: False

Required: False

Unique: False

Fields:

AscendingDataSrc ID

FLAV_INDNDB_No 1

Clustered: False

DistinctCount: 503

Foreign: False

IgnoreNulls: False

Name: FLAV_INDNDB_No

Primary: False

Required: False

Unique: False

Fields:

AscendingNDB_No

Num_Data_Pts 1

Clustered: False

DistinctCount: 39

Page 27: Flav R03-2.accdb Friday, November 17, 2017 · C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017 Table: DATA_SRC Page: 1 Properties AlternateBackShade: 100

C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017

Page: 27Table: FLAV_IND

User Permissions

admin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete Data

Group Permissions

Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete Data

Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete Data

Foreign: False

IgnoreNulls: False

Name: Num_Data_Pts

Primary: False

Required: False

Unique: False

Fields:

AscendingNum_Data_Pts

Page 28: Flav R03-2.accdb Friday, November 17, 2017 · C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017 Table: DATA_SRC Page: 1 Properties AlternateBackShade: 100

C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017

Page: 28Table: FOOD_DES

Properties

AlternateBackShade: 100 AlternateBackThemeColorInd -1

AlternateBackTint: 100 BackShade: 100

BackTint: 100 DatasheetForeThemeColorIn -1

DatasheetGridlinesThemeCol -1 DateCreated: 10/9/2012 1:32:33 PM

DefaultView: 2 DisplayViewsOnSharePointSit 1

Filter: ([FOOD_DES].[NDB_No]="16108")

FilterOnLoad: False

GUID: {guid {037BB794-7477-4244-

9A33-278A3A442C22}}

HideNewField: False

LastUpdated: 11/20/2015 10:51:22 AM NameMap: Long binary data

OrderBy: [FOOD_DES].[NDB_No], [FOOD_DES].[FdGrp_Cd]

OrderByOn: True

OrderByOnLoad: True Orientation: Left-to-Right

PublishToWeb: 1 RecordCount: 506

ThemeFontIndex: -1 TotalsRow: False

Updatable: True

Columns

Name Type Size

NDB_No Short Text 5

AggregateType: -1

AllowZeroLength: True

AppendOnly: False

Attributes: Variable Length

CollatingOrder: General

ColumnHidden: False

ColumnOrder: 1

ColumnWidth: 1152

CurrencyLCID: 0

DataUpdatable: False

DisplayControl: Text Box

GUID: {guid {372FB668-9DB9-4566-ABE5-14685F24FD56}}

IMEMode: 0

IMESentenceMode: 3

OrdinalPosition: 0

Required: False

SourceField: NDB_No

SourceTable: FOOD_DES

TextAlign: General

UnicodeCompression: True

FdGrp_Cd Short Text 255

AggregateType: -1

AllowZeroLength: True

AppendOnly: False

Attributes: Variable Length

CollatingOrder: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: 1236

Page 29: Flav R03-2.accdb Friday, November 17, 2017 · C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017 Table: DATA_SRC Page: 1 Properties AlternateBackShade: 100

C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017

Page: 29Table: FOOD_DES

CurrencyLCID: 0

DataUpdatable: False

DisplayControl: Text Box

GUID: {guid {264AF811-56BF-45F2-8FC4-4A390EF3877C}}

IMEMode: 0

IMESentenceMode: 3

OrdinalPosition: 1

Required: False

SourceField: FdGrp_Cd

SourceTable: FOOD_DES

TextAlign: General

UnicodeCompression: False

Long_Desc Short Text 200

AggregateType: -1

AllowZeroLength: True

AppendOnly: False

Attributes: Variable Length

CollatingOrder: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: 8160

CurrencyLCID: 0

DataUpdatable: False

DisplayControl: Text Box

GUID: {guid {63ED0131-28A6-4A96-A4B1-3093BE1E4E4F}}

IMEMode: 0

IMESentenceMode: 3

OrdinalPosition: 2

Required: False

SourceField: Long_Desc

SourceTable: FOOD_DES

TextAlign: General

UnicodeCompression: False

SciName Short Text 65

AggregateType: -1

AllowZeroLength: True

AppendOnly: False

Attributes: Variable Length

CollatingOrder: General

ColumnHidden: False

ColumnOrder: Default

ColumnWidth: 3744

CurrencyLCID: 0

DataUpdatable: False

DisplayControl: Text Box

GUID: {guid {C28EDDF5-4A84-4E90-A194-B9322A7CDFC7}}

IMEMode: 0

IMESentenceMode: 3

OrdinalPosition: 3

Required: False

SourceField: SciName

SourceTable: FOOD_DES

TextAlign: General

Page 30: Flav R03-2.accdb Friday, November 17, 2017 · C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017 Table: DATA_SRC Page: 1 Properties AlternateBackShade: 100

C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017

Page: 30Table: FOOD_DES

UnicodeCompression: False

User Permissions

Relationships

FD_GROUPFOOD_DES

FD_GROUP FOOD_DES

1FdGrp_CD FdGrp_Cd

Attributes: Enforced

RelationshipType: One-To-Many

FOOD_DESFLAV_DAT

FOOD_DES FLAV_DAT

1NDB_No NDB_No

Attributes: Enforced

RelationshipType: One-To-Many

Table Indexes

Name Number of Fields

FD_GROUPFOOD_DES 1

Clustered: False

DistinctCount: 12

Foreign: True

IgnoreNulls: False

Name: FD_GROUPFOOD_DES

Primary: False

Required: False

Unique: False

Fields:

AscendingFdGrp_Cd

PrimaryKey 1

Clustered: False

DistinctCount: 506

Foreign: False

IgnoreNulls: False

Name: PrimaryKey

Primary: True

Required: True

Unique: True

Fields:

AscendingNDB_No

Page 31: Flav R03-2.accdb Friday, November 17, 2017 · C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017 Table: DATA_SRC Page: 1 Properties AlternateBackShade: 100

C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017

Page: 31Table: FOOD_DES

admin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete Data

Group Permissions

Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete Data

Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition,

Write Definition, Read Data, Insert Data, Update Data, Delete Data

Page 32: Flav R03-2.accdb Friday, November 17, 2017 · C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017 Table: DATA_SRC Page: 1 Properties AlternateBackShade: 100

C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017

Page: 32Table: NUTR_DEF

Properties

DateCreated: 10/9/2012 1:32:33 PM DefaultView: 2

DisplayViewsOnSharePointSit 1 Filter: (NUTR_DEF.Tagname Is Null Or NUTR_DEF.Tagname="")

FilterOnLoad: False GUID: {guid {DAC81794-65C4-4884-9941-95878839B9EC}}

HideNewField: False LastUpdated: 11/20/2015 10:51:22 AM

NameMap: Long binary data OrderByOn: False

OrderByOnLoad: True Orientation: Left-to-Right

RecordCount: 26 TotalsRow: False

Updatable: True

Columns

Name Type Size

Nutr_no Short Text 3

AggregateType: -1

AllowZeroLength: True

AppendOnly: False

Attributes: Variable Length

CollatingOrder: General

ColumnHidden: False

ColumnOrder: 1

ColumnWidth: 1188

DataUpdatable: False

DisplayControl: Text Box

GUID: {guid {46CB725E-18BE-47E4-B191-3D83F0809775}}

IMEMode: 0

IMESentenceMode: 3

OrdinalPosition: 0

Required: False

SourceField: Nutr_no

SourceTable: NUTR_DEF

TextAlign: General

UnicodeCompression: True

Nutrient name Short Text 45

AggregateType: -1

AllowZeroLength: True

AppendOnly: False

Attributes: Variable Length

CollatingOrder: General

ColumnHidden: False

ColumnOrder: 2

ColumnWidth: 3360

DataUpdatable: False

DisplayControl: Text Box

GUID: {guid {9D83BD49-3637-4F6A-98EC-24286523D5DE}}

IMEMode: 0

IMESentenceMode: 3

OrdinalPosition: 1

Required: False

Page 33: Flav R03-2.accdb Friday, November 17, 2017 · C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017 Table: DATA_SRC Page: 1 Properties AlternateBackShade: 100

C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017

Page: 33Table: NUTR_DEF

SourceField: Nutrient name

SourceTable: NUTR_DEF

TextAlign: General

UnicodeCompression: False

Flav_Class Short Text 50

AggregateType: -1

AllowZeroLength: True

AppendOnly: False

Attributes: Variable Length

CollatingOrder: General

ColumnHidden: False

ColumnOrder: 3

ColumnWidth: 1476

DataUpdatable: False

DisplayControl: Text Box

GUID: {guid {AA79C281-AF4C-4742-9537-D037989FCEFC}}

IMEMode: 0

IMESentenceMode: 3

OrdinalPosition: 2

Required: False

SourceField: Flav_Class

SourceTable: NUTR_DEF

TextAlign: General

UnicodeCompression: True

Tagname Short Text 20

AggregateType: -1

AllowZeroLength: True

AppendOnly: False

Attributes: Variable Length

CollatingOrder: General

ColumnHidden: False

ColumnOrder: 4

ColumnWidth: Default

DataUpdatable: False

DisplayControl: Text Box

GUID: {guid {9093752A-CD08-4B4B-A1B2-2A7AFDD33C4C}}

IMEMode: 0

IMESentenceMode: 3

OrdinalPosition: 3

Required: False

SourceField: Tagname

SourceTable: NUTR_DEF

TextAlign: General

UnicodeCompression: True

Unit Short Text 255

AggregateType: -1

AllowZeroLength: True

AppendOnly: False

Attributes: Variable Length

CollatingOrder: General

ColumnHidden: False

ColumnOrder: 5

Page 34: Flav R03-2.accdb Friday, November 17, 2017 · C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017 Table: DATA_SRC Page: 1 Properties AlternateBackShade: 100

C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017

Page: 34Table: NUTR_DEF

ColumnWidth: 756

DataUpdatable: False

DisplayControl: Text Box

GUID: {guid {12997567-ED4F-406F-BCDA-204124479773}}

IMEMode: 0

IMESentenceMode: 3

OrdinalPosition: 4

Required: False

SourceField: Unit

SourceTable: NUTR_DEF

TextAlign: General

UnicodeCompression: False

User Permissions

admin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete Data

Group Permissions

Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete Data

Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, Delete Data

Relationships

NUTR_DEFFLAV_DAT

NUTR_DEF FLAV_DAT

1Nutr_no Nutr_no

Attributes: Enforced

RelationshipType: One-To-Many

Table Indexes

Name Number of Fields

PrimaryKey 1

Clustered: False

DistinctCount: 26

Foreign: False

IgnoreNulls: False

Name: PrimaryKey

Primary: True

Required: True

Unique: True

Fields:

AscendingNutr_no

Page 35: Flav R03-2.accdb Friday, November 17, 2017 · C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017 Table: DATA_SRC Page: 1 Properties AlternateBackShade: 100

C:\Users\Erin.Antognoli\Downloads\Flav_R03-2.accdb Friday, November 17, 2017

Page: 35Table: NUTR_DEF