You are here

Data Tables

In the examples below a variety of tables have been defined for a shop. For a real shop, more details will be required, but the purpose of these tables are to show a variety of aspects of Web-D-Zine(WDZ). These aspects are:-

  • Data structure - There are several tables here, showing various aspects of data structure. If you decide that you want to copy information from one table to another, for example user address and the delivery address in the basket, it will make your life easier if you use the same field names for both so a field called postCode in user address relates to postCode in the delivery address.
  • Encryption - Some details for the user are encrypted in the data base, but from the users point of view, they can still edit their details as if the data was in plain text. However, the details will be encrypted when they are stored in the data base
  • Parent, Child links - There are several parent - child links, shown. The product linked to pictures, the user and their addresses and the user linked to a basket which is in turn is the parent of several basket items. This last set of links identifies the limit of what the code will produce automatically for you, because you will need to add code manually for looking at the basket items.
  • Xref links - There are two types of xref links
    • Two different parents - This is shown in the comments where the user and the product are both parents to the comment.
    • A Xref link - A link has been created between two different products
  • Pressing the Go WDZ Button - The data structures below are used to create all the code, the forms and the display lists automatically for you. Look at Press the Go WDZ button to see what will be generated automatically.

Managing fields for exUser

    • Edit
    • Table name
    • Field name
    • Seq.
    • Name
    • Desc
    • Sch
    • Sort
    • Enc.
    • Rtv
    • Edit - 376
    • exUser
    • id
    • 0
    • Primary Id
    • The Primary Id is used in back end systems to retrieve the record
    • true
    • false
    • false
    • true
    • Edit - 377
    • exUser
    • key
    • 5
    • Key
    • The key is used to group children records together, such as the address, the customers baskets and comments.
    • true
    • false
    • false
    • true
    • Edit - 378
    • exUser
    • salutation
    • 10
    • Salutation
    • Salutation such as Mr. Mrs etc.
    • false
    • false
    • false
    • false
    • Edit - 380
    • exUser
    • surname
    • 15
    • Surname
    • Last name of person. In this case the information is encrypted so that the name is not readable in the data base. So that you can search the record, a separate field is created which is encrypted in such a way, that it is still encrypted, but is also searchable.
    • true
    • true
    • false
    • false
    • Edit - 379
    • exUser
    • firstName
    • 20
    • First Name
    • First name, initials etc. In this case the information is encrypted so that the name is not readable in the data base. So that you can search the record, a separate field is created which is encrypted in such a way, that it is still encrypted, but is also searchable.
    • true
    • true
    • false
    • false
    • Edit - 381
    • exUser
    • email
    • 25
    • Email
    • Email address - In this example the the email address is being used to retrieve the record, but is also encrypted. There is one disadvantage of using a retrieve on an encrypted field and that is you can not make the field unique. So you will need to add external code to make sure that you only have one user with that email address.
    • false
    • false
    • true
    • true
    • Edit - 402
    • exUser
    • telephone
    • 30
    • Telephone
    • Encrypted telephone number can be used for personal telephone numbers
    • false
    • false
    • true
    • false
    • Edit - 516
    • exUser
    • userPassword
    • 40
    • Password(User)
    • The password is modified so that it is unreadable in the data base. The user must define a function called userPassword for this option
    • false
    • false
    • false
    • true
    • Edit - 383
    • exUser
    • date
    • 45
    • Date
    • Date, the default for this date is today, which is a special instruction that puts today's date in as the default
    • false
    • false
    • false
    • false
    • Edit - 382
    • exUser
    • startDate
    • 50
    • Start Date
    • Start date, the default for this date is today, which is a special instruction that puts today's date in as the default
    • false
    • false
    • false
    • false