ChocEtiq - Structure of the database

File CHOCETIQ.MDB is with the format Microsoft Access 2. Its structure is:

Table Categories

Name

Type

Length

Nom

characters

50

Index

Description

Single

Primary

PrimaryKey

+Nom

O

O

 
Table CompositionLot

Name

Type

Length

NomLot

characters

50

NomProduit

characters

50

Quantite

double number

8

Index

Description

Single

Primary

IProduit

+NomProduit



PrimaryKey

+NomLot;+NomProduit

O

O

Table Compositionproduit

Name

Type

Length

NomProduit

characters

50

NomIngredient

characters

50

Quantite

double number

8

Index

Description

Single

Primary

IIngredient

+NomIngredient



PrimaryKey

+NomProduit;+NomIngredient

O

O

Table Etiquettes

Name

Type

Length

Nom

characters

50

MargeHaute

double number

8

MargeGauche

double number

8

NbVertical

double number

8

NbHorizontal

double number

8

Hauteur

double number

8

Largeur

double number

8

EcartVertical

double number

8

EcartHorizontal

double number

8

Orientation

Boolean

1

RtfLogoVisible

Boolean

1

RtfLogoLeft

double number

8

RtfLogoTop

double number

8

RtfLogoWidth

double number

8

RtfLogoHeight

double number

8

RtfIdentiteVisible1

Boolean

1

RtfIdentiteLeft1

double number

8

RtfIdentiteTop1

double number

8

RtfIdentiteWidth1

double number

8

RtfIdentiteHeight1

double number

8

RtfLibelleVisible

Boolean

1

RtfLibelleTop

double number

8

RtfLibelleLeft

double number

8

RtfLibelleWidth

double number

8

RtfLibelleHeight

double number

8

RtfCompositionVisible

Boolean

1

RtfCompositionTop

double number

8

RtfCompositionLeft

double number

8

RtfCompositionWidth

double number

8

RtfCompositionHeight

double number

8

RtfDateVisible

Boolean

1

RtfDateLeft

double number

8

RtfDateTop

double number

8

RtfDateWidth

double number

8

RtfDateHeight

double number

8

RtfCodeCaisseVisible

Boolean

1

RtfCodeCaisseLeft

double number

8

RtfCodeCaisseTop

double number

8

RtfCodeCaisseWidth

double number

8

RtfCodeCaisseHeight

double number

8

RtfPoidsVisible

Boolean

1

RtfPoidsLeft

double number

8

RtfPoidsTop

double number

8

RtfPoidsHeight

double number

8

RtfPoidsWidth

double number

8

RtfPrixVisible

Boolean

1

RtfPrixLeft

double number

8

RtfPrixTop

double number

8

RtfPrixWidth

double number

8

RtfPrixHeight

double number

8

RtfLibelleFontName

characters

50

RtfLibelleFontSize

double number

8

RtfLibelleAlignment

integer

2

RtfLibelleFontColor

double number

8

RtfLibelleFontBold

Boolean

1

RtfLibelleFontItalic

Boolean

1

RtfLibelleFontUnderline

Boolean

1

RtfLibelleFontStrikeThru

Boolean

1

RtfCompositionFontName

characters

50

RtfCompositionFontSize

double number

8

RtfCompositionAlignment

integer

2

RtfCompositionFontColor

double number

8

RtfCompositionFontBold

Boolean

1

RtfCompositionFontItalic

Boolean

1

RtfCompositionFontUnderline

Boolean

1

RtfCompositionFontStrikeThru

Boolean

1

RtfDateFontName

characters

50

RtfDateFontSize

double number

8

RtfDateAlignment

integer

2

RtfDateFontColor

double number

8

RtfDateFontBold

Boolean

1

RtfDateFontItalic

Boolean

1

RtfDateFontUnderline

Boolean

1

RtfDateFontStrikeThru

Boolean

1

RtfCodeCaisseFontName

characters

50

RtfCodeCaisseFontSize

double number

8

RtfCodeCaisseAlignment

integer

2

RtfCodeCaisseFontColor

double number

8

RtfCodeCaisseFontBold

Boolean

1

RtfCodeCaisseFontItalic

Boolean

1

RtfCodeCaisseFontUnderline

Boolean

1

RtfCodeCaisseFontStrikeThru

Boolean

1

RtfPoidsFontName

characters

50

RtfPoidsFontSize

double number

8

RtfPoidsAlignment

integer

2

RtfPoidsFontColor

double number

8

RtfPoidsFontBold

Boolean

1

RtfPoidsFontItalic

Boolean

1

RtfPoidsFontUnderline

Boolean

1

RtfPoidsFontStrikeThru

Boolean

1

RtfPrixFontName

characters

50

RtfPrixFontSize

double number

8

RtfPrixAlignment

integer

2

RtfPrixFontColor

double number

8

RtfPrixFontBold

Boolean

1

RtfPrixFontItalic

Boolean

1

RtfPrixFontUnderline

Boolean

1

RtfPrixFontStrikeThru

Boolean

1

RtfPhotoVisible

Boolean

1

RtfPhotoLeft

double number

8

RtfPhotoTop

double number

8

RtfPhotoWidth

double number

8

RtfPhotoHeight

double number

8

RtfIdentiteVisible2

Boolean

1

RtfIdentiteLeft2

double number

8

RtfIdentiteTop2

double number

8

RtfIdentiteWidth2

double number

8

RtfIdentiteHeight2

double number

8

RtfPoidsRefVisible

Boolean

1

RtfPoidsRefLeft

double number

8

RtfPoidsRefTop

double number

8

RtfPoidsRefHeight

double number

8

RtfPoidsRefWidth

double number

8

RtfPoidsRefFontName

characters

50

RtfPoidsRefFontSize

double number

8

RtfPoidsRefAlignment

integer

2

RtfPoidsRefFontColor

double number

8

RtfPoidsRefFontBold

Boolean

1

RtfPoidsRefFontItalic

Boolean

1

RtfPoidsRefFontUnderline

Boolean

1

RtfPoidsRefFontStrikeThru

Boolean

1

RtfEAN13Visible

Boolean

1

RtfEAN13Top

double number

8

RtfEAN13Left

double number

8

RtfEAN13Width

double number

8

RtfEAN13Height

double number

8

RtfEAN13Fontname

characters

50

RtfEAN13Fontsize

double number

8

RtfEAN13Legende

Boolean

1

Imprimante

characters

100

RtfNutriLeft

double number

8

RtfNutriTop

double number

8

RtfNutriWidth

double number

8

RtfNutriHeight

double number

8

RtfNutriFontBold

Boolean

 

RtfNutriBlackcolor

double number

8

RtfNutriWhilteColor

double number

8

RtfNutriVisible

Boolean

 

RtfNutriModele

integer

2

RtfNoLotFontName

characters

50

RtfNoLotFontSize

double number

8

RtfNoLotAlignment

integer

2

RtfNoLotFontColor

double number

8

RtfNoLotFontBold

Boolean

 

RtfNoLotFontItalic

Boolean

 

RtfNoLotFontUnderline

Boolean

 

RtfNoLotFontStrikeThru

Boolean

 

RtfNoLotVisible

Boolean

 

RtfNoLotLeft

double number

8

RtfNoLotTop

double number

8

RtfNoLotWidth

double number

8

RtfNoLotHeight

double number

8

RtfDateFabFontBold

Boolean

 

RtfDateFabFontBold

Boolean

 

RtfDateFabFontBold

Boolean

 

RtfDateFabFontBold

Boolean

 

RtfDateFabVisible

Boolean

 

RtfDateFabLeft

double number

8

RtfDateFabTop

double number

8

RtfDateFabWidth

double number

8

RtfDateFabHeight

double number

8

RtfNutriFontName

characters

50

RtfZoneLibre1Visible

Boolean

 

RtfZoneLibre1Left

double number

8

RtfZoneLibre1Top

double number

8

RtfZoneLibre1Width

double number

8

RtfZoneLibre1Height

double number

8

RtfZoneLibre1Memo

Memo

 

RtfZoneLibre2Visible

Boolean

 

RtfZoneLibre2Left

double number

8

RtfZoneLibre2Top

double number

8

RtfZoneLibre2Width

double number

8

RtfZoneLibre2Height

double number

8

RtfZoneLibre2Memo

Memo

 

Rtf5Cvisible

Boolean

 

Rtf5CLeft

double number

8

Rtf5CTop

double number

8

Rtf5CWidth

double number

8

Rtf5CHeight

double number

8

Rtf5CCouleur

double number

8

RtfQRcodeVisible

Boolean

 

RtfQRcodeLeft

double number

8

RtfQRcodeTop

double number

8

RtfQRcodeWidth

double number

8

RtfQRcodeHeight

double number

8

RtfQRcodeContenu

Memo

 

RtfQRcodeCouleur

double number

8

Index

Description

Single

Primary

PrimaryKey

+Nom

O

O

Table Ingredients

Name

Type

Length

Name

characters

100

LibelleEtiq

characters

50

Allergen

characters

100

SurEtiquette

Boolean

1

Category

characters

50

NoCiqual

double number

8

Code5c

characters

2

Index

Description

Single

Primary

ICategorie

+Categorie



PrimaryKey

+LibelleEtiq

O

O

Table Lots

Name

Type

Length

Nom

characters

50

Codecaisse

characters

20

LibelleEtiq

characters

50

Poids

double number

8

PoidsRef

characters

10

Prix

double number

8

DureeConservation

double number

8

Photo

binary object

0

TaillePhoto

double number

8

UniteDuree

integer

2

DLCDLUO

Boolean

1

Complement

memo

 

EAN13

characters

13

FormatEtiq

characters

50

NoLot

characters

20

DateFab

characters

20

FormatEtiq2

characters

50

FormatEtiq3

characters

50

NomEtiq

characters

50

NomEtiq2

characters

50

NomEtiq3

characters

50

ActiveEtiq

Boolean

1

ActiveEtiq2

Boolean

1

ActiveEtiq3

Boolean

1

Portion

double number

8

Code5C

characters

2

Index

Description

Single

Primary

PrimaryKey

+Nom

O

O

 
Table Produits

Name

Type

Length

Nom

characters

100

LibelleEtiq

characters

50

Photo

binary object

0

CodeCaisse

characters

20

Poids

double number

8

Poidsref

characters

10

Prix

double number

8

DureeConservation

double number

8

TaillePhoto

double number

8

UniteDuree

integer

2

DLCDLUO

Boolean

1

Complement

memo

 

EAN13

characters

13

FormatEtiq

characters

50

NoLot

characters

20

DateFab

characters

20

FormatEtiq2

characters

50

FormatEtiq3

characters

50

NomEtiq

characters

50

NomEtiq2

characters

50

NomEtiq3

characters

50

ActiveEtiq

Boolean

1

ActiveEtiq2

Boolean

1

ActiveEtiq3

Boolean

1

Portion

double number

8

Code5C

characters

2

Index

Description

Single

Primary

PrimaryKey

+Nom

O

O

 
Table Standards

Name

Type

Length

Nom

characters

50

MargeHaute

double number

8

MargeGauche

double number

8

NbVertical

double number

8

NbHorizontal

double number

8

Hauteur

double number

8

Largeur

double number

8

EcartVertical

double number

8

EcartHorizontal

double number

8

Index

Description

Single

Primary

INom

+Nom

O


PrimaryKey

+Nom

O

O

 
Table Vendeur

Name

Type

Length

LogoVendeur

binary object

 

TailleLogo

double number

8

Identite1

memo

 

Identite2

memo

 

VCardNom

characters

100

VCardPrenom

characters

100

VCardRue1

characters

200

VCardRue2

characters

200

VCardCodePost

characters

10

VCardVille

characters

100

VCardTel1

characters

50

VCardTel2

characters

50

VCardFax

characters

50

VCardEmail

characters

100

VCardUrl

characters

100

VCardResponsable

characters

100

Table Unités

Name

Type

Length

unite

characters

10

uniteref

characters

10

coeff

double number

8

texte

characters

50

texteref

characters

50

texteportion

characters

10

 

Index

Description

Single

Primary

PrimaryKey

+unite

O

O

Table Mentions

Name

Type

Length

NumeroMentier

Integer

2

Mention

characters

100

 

Index

Description

Single

Primary

PrimaryKey

+NumeroMention

O

O

Table Parametres

Nom

Type

Longueur

numerodeversion

caractères

10

 

 

NUTRI.MDB table, with the format Microsoft Access 2, is a reduction of Ciqual Table with only necessary data for ChocEtiq. It use fields name of Ciqual database2013 of Agence nationale de sécurité sanitaire de l'alimentation, de l'environnement et du travail (Anses).

Table Food

Name

Type

Longueur

ORIGFDCD

double number

8

ORIGFDNM

characters

250

ENGFDNAM

characters

150

 

Index

Description

Unique

Primaire

FOODORIGFDCD

+ORIGFDCD

N

N

Table Compiled_data

Name

Type

Longueur

ORIGFDCD

double number

8

ORIGCPCD

double number

8

SELVALtexte

characters

255

 

Index

Description

Unique

Primaire

COMPILED_DATAORIGCPCD

+ORIGCPCD

N

N

COMPILED_DATAORIGFDCD

+ORIGFDCD

N

N

 

Category :

328

Energy


25003

Protein


31000

Carbohydrate


32000

Sugars


40000

Fat


40302

FA saturated


34100

Fibers


10110

Sodium

 

 

Other files:

BOUTON.WAV: used by the parameter “sound Buttons”

CATEGORIES1.RPT, CATEGORIES2.RPT, INGREDIENT1.RPT, LOT1.RPT, LOTCOMPOSITION1.RPT, LOTCOMPOSITION2.RPT, PRODUIT1.RPT, PRODUITCOMPOSITION1.RPT: printed out in French (generated in Crystal Report 4)

CATEGORIES1EN.RPT, CATEGORIES2EN.RPT, INGREDIENT1EN.RPT, LOT1EN.RPT, LOTCOMPOSITION1EN.RPT, LOTCOMPOSITION2EN.RPT, PRODUIT1EN.RPT, PRODUITCOMPOSITION1EN.RPT: printed out in English (generated in Crystal report 4)

CHOCETIQ.EXE: ChocEtiq application

HISTORIQUE.TXT: description of the various evolutions of the application by numbers of version (free format text) in French

HISTORIQUEEN.TXT: description of the various evolutions of the application by numbers of version (free format text) in English

CHOCETIQ.CHM: this help file in French

CHOCETIQEN.CHM: the help file in English

Linguistic resources: Sub-directory \LANGUAGES

CHOCETIQ.FR French linguistic Resources

CHOCETIQ.EN English linguistic Resources

FR.RLE French Flag

EN.RLE English Flag

Sample files included in current application directory (by default C:\program files\chocetiq)

Ingredients.cei : french file of more than 1790 ingredients grouped in 69 categories

Categories.cei : french file of 69 categories

Standards.cei : file of 66 labels sheets formats.

Note : to import this file, double-click on file  Standards.cei at desktop, without launching before application

Exemplelot.cei : sample file of a package, including photos, products, ingredients and necessary categories

Eti... . cei : various files of labels formats


Help summary :


Presentation

Labels

Use

Formats of the labels

Categories

General parameters

Ingredients

Structure of the database

Products

Linguistic resources

Packages

Update

Units

Sending by mail


Regulation


© All rights reserved 2007/2015 - ADAGIO