en-USnl-NL
Goal:
Defining your datamodel in the DatabaseBuilder.

Execution:
Open Your DatabaseBuilder Template named My Pleasure; Lesson 1.

Step 1:
Locate and open the tab: "Conventions".


Rename the fields: "CompanyName" (YourCompany -> another name); "Primary Prefix" (YC -> another Prefix) and "Secundary Prefix" (TUT -> another Prefix).
Optionally: Rename the application name.
You're done with this tab.

Step 2:
Locate and open the tab: "Tables".


Observe that the tablenames are: YCSociety, YCActivities, YC Officers and YCMembers. The first two characters are the same as the primary prefix. this is optional, however.
Normally you would fill in the tablenames here in the column " Table Name".
Leave the TemplateTable 00 as it is. The ApplicationBuilder recognizes this and will ignore the TemplateTable.
You're done with this tab.

Step 3:
Locate and open the tab: "YC_TUT_01_YCSociety".
You will now set the tablenames that you have defined in the datadefinition phase (see lesson 1).
A SQL field has propertie too, and the two most important ones are: Field Name and Field Property.
The fieldname in the DatabaseBuilder is stored in subsequent rowcells in column "D" starting in row 14; Fieldnumber 8.
(The first seven SQL tablefields are reserved for the mopdules house keeping. You must not change these in any way.)
Now determine the property of your SQL tablefield.
The ApplicationBuilder can distinguish 4 types: Varchar, Integer, Money and Decimal.
Copy-paste the fieldnames (SName and SFee) from here into the tablenamecells, and select the SQL fieldtype in your TableTab:

 The Society table contains at least the fields:
    Society name                      SName                     SQL fieldname                         Type  VarChar(50)   
    Scociety contribution fee      SFee                           "F" column                            Type  Money



    SQL Types           Common  Use:
    VarChar(6)            Yes/No and gender fields
    VarChar(10)          Date fields
    VarChar(15)          Small text data (Names or small info) 
    VarChar(50)          The "standard" VarChar" setting
    VarChar(500)        Desription fields
    Int                         All integer data
    Money                   All valuta data (= special kind of decimal type)
    Decimal(3,2)         Small decimal data(percentages or value parts)
    Decimal(18,10)     The "standard" decimal setting

    Observe that the column " FieldName" (F-column) contains
     the SQL fieldnames that will be used in your application.
    The DatabaseBuilder automatically attaches the fieldextention "_MDEC"
    to the "SFee" field. This is done because the ApplicationBuilder has to know
    how to treat this field during building the module.

Your done for now.
Step 7:
Upload the databaseBuilder into the ApplicationBuilder on www.vd-jumpstart.com (i.e. this portal) on the "JumpStart" page.

---->>  To Lesson 4: Upload your DatabaseBuilder