You are here

Data Dictionary

The data dictionary is Web-D-Zine's( WDZ ) key building block. As you build your tables, all you need to select the information that you want to include. A data dictionary can really help with data that needs to be stanardized and it can also help you to get a project off the ground quickly.

Managing Data dictionary

    • Edit
    • Value
    • Title
    • Bundle
    • Field name
    • Desc
    • Form Type
    • Edit - 40
    • Salutation
    • Mr, Mrs etc.
    • Contact details
    • salutation
    • Salutation such as Mr. Mrs etc.
    • select
    • Edit - 41
    • First Name(Plain)
    • The first name of somebody. This is used as a search criteria and can be used to sort the data
    • Contact details
    • firstName
    • First name, initials etc.
    • text
    • Edit - 44
    • First Name(Enc.)
    • The first name of somebody encryped plus search facility
    • Contact details
    • firstName
    • First name, initials etc.
    • text
    • Edit - 42
    • Surname(Plain)
    • Last name of person, used for sort and search facility
    • Contact details
    • surname
    • Last name of person
    • text
    • Edit - 45
    • Surname(Enc.)
    • Last name of person encrypted, with searchable facility
    • Contact details
    • surname
    • Last name of person
    • text
    • Edit - 79
    • Password SQL
    • Password
    • Contact details
    • password
    • The password is modified so that it is unreadable in the data base. The SQL function password is used for this type
    • password
    • Edit - 80
    • Password User
    • Password
    • Contact details
    • password
    • The password is modified so that it is unreadable in the data base. The user must define a function called userPassword for this option
    • password
    • Edit - 43
    • Email(Enc)
    • Email address. This is encrypted
    • Contact details
    • email
    • Email address
    • text
    • Edit - 46
    • Email(Plain)
    • Email address
    • Contact details
    • email
    • Email address
    • text
    • Edit - 47
    • Telephone(plain)
    • Telephone - General
    • Contact details
    • telephone
    • Plain telephone number can be used for fax, or company telephone numbers
    • text
    • Edit - 48
    • Telephone(enc)
    • Telephone - Encrypted
    • Contact details
    • telephone
    • Encrypted telephone number can be used for personal telephone numbers
    • text
    • Edit - 49
    • Mobile(enc)
    • Mobile - Encrypted
    • Contact details
    • mobile
    • Encrypted mobile number can be used for personal telephone numbers
    • text
    • Edit - 50
    • Organisation Name
    • Name 64 characters in length
    • Contact details
    • organisationName
    • Name of organisation
    • text
    • Edit - 57
    • Trading Name
    • Name 64 characters in length
    • Contact details
    • tradingName
    • Trading Name
    • text
    • Edit - 51
    • Address Line 1
    • Name 64 characters in length
    • Contact details
    • address1
    • Address - Line 1
    • text
    • Edit - 82
    • Address Line 1(enc)
    • Name 64 characters in length
    • Contact details
    • address1
    • Address - Line 1(Encrypted)
    • text
    • Edit - 52
    • Address Line 2
    • Name 64 characters in length
    • Contact details
    • address2
    • Address - Line 2
    • text
    • Edit - 83
    • Address Line 2(enc)
    • Name 64 characters in length
    • Contact details
    • address2
    • Address - Line 2(Encrypted for security)
    • text
    • Edit - 53
    • Address Line 3
    • Name 64 characters in length
    • Contact details
    • address3
    • Address - Line 3
    • text
    • Edit - 54
    • Address Line 4
    • Name 64 characters in length
    • Contact details
    • address4
    • Address - Line 4
    • text
    • Edit - 55
    • Address Line 5
    • Name 64 characters in length
    • Contact details
    • address5
    • Address - Line 5
    • text
    • Edit - 56
    • Postcode/code
    • Postcode or other postal code 64 characters in length
    • Contact details
    • postCode
    • Address - Postcode
    • text
    • Edit - 84
    • Country
    • Country
    • Contact details
    • country
    • Country
    • select
    • Edit - 13
    • Simple Yes, No Flag
    • Toggle display; combo in form
    • Flags
    • flag
    • Simple flag to change selection
    • select
    • Edit - 36
    • Simple Yes, No flag
    • Toggle display; checkbox in form
    • Flags
    • flag
    • Simple flag to change selection
    • checkbox
    • Edit - 37
    • Protected Yes/No flag
    • Protected in display; combo in form
    • Flags
    • flag
    • Simple flag to change selection
    • select
    • Edit - 14
    • Simple On, Off switch
    • Toggle display; combo in form
    • Flags
    • switch
    • Switches are either on or off
    • select
    • Edit - 38
    • Simple On, Off switch
    • Toggle display; checkbox in form
    • Flags
    • switch
    • Switches are either on or off
    • checkbox
    • Edit - 39
    • Protected On, Off flag
    • Protected in display; combo in form
    • Flags
    • switch
    • Switches are either on or off
    • select
    • Edit - 15
    • Boolean
    • Simple boolean with 0 for false and 1 for true; Toggle display; Checkbox in form
    • Flags
    • boolean
    • Simple boolean that indicates if things are true of false
    • checkbox
    • Edit - 16
    • Full text boolean
    • Full text boolean uses true for true and false for false; Toggle display; Select in form
    • Flags
    • ftBoolean
    • Full text boolean uses true for true and false for false
    • select
    • Edit - 21
    • Description
    • Description field 255 characters in length
    • General
    • description
    • Description
    • textarea
    • Edit - 34
    • css Class
    • Css class is 255 characters in length but comes with a regex so that only alphanumeric characters plus a space are allowed
    • General
    • cssClass
    • Governs how the information will look
    • text
    • Edit - 28
    • Name
    • Name 64 characters in length
    • General
    • name
    • Name of object
    • text
    • Edit - 29
    • Number
    • Integer to be used for your own need
    • General
    • number
    • Integer for general use
    • text
    • Edit - 35
    • Icon
    • Small image such as an icon
    • General
    • icon
    • Small image
    • fileImage
    • Edit - 30
    • Link
    • Link to a web address - uses URL validation and has a form type of url
    • General
    • link
    • Link to some information
    • url
    • Edit - 76
    • Colour/Color
    • Colour of item
    • General
    • Colour
    • Colour of item
    • color
    • Edit - 32
    • Text
    • Text field with no limit on the characters
    • General
    • text
    • textarea
    • Edit - 58
    • Date
    • Date
    • General
    • date
    • Date
    • date
    • Edit - 73
    • Start date
    • Start date
    • General
    • startDate
    • Start date
    • date
    • Edit - 74
    • End date
    • End date
    • General
    • endDate
    • text
    • Edit - 75
    • Price
    • The price of the item
    • General
    • price
    • Price of item
    • text
    • Edit - 1
    • Less than four billion records
    • For the vast majority of database applications, four billion records is usually more than adequate
    • Id
    • id
    • The Primary Id is used in back end systems to retrieve the record
    • hidden
    • Edit - 2
    • Over four billion records
    • There is a upper limit of eighteen quintillion records, but if you need to store more than that then WDZ is not the right product for you.
    • Id
    • id
    • The primary id is used in back end systems to retrieve a record
    • hidden
    • Edit - 25
    • Code
    • Codes are written by the user and are only alphanumeric characters plus an '_' or '-'. They are great when you need to access the data by application code
    • Indexed items
    • code
    • Code that needs to be accessed via the application code
    • text
    • Edit - 26
    • Short Unique Key
    • Unique keys are generated by the system. They are great for records where the code is not to be used by the application code. This code is 11 characters which is the same length as used by you-tube for the videos that they have on record
    • Indexed items
    • key
    • The key for a particular record
    • text
    • Edit - 27
    • Long Unique Key
    • Unique key 24 characters in length, which is the same length as You tube's customer records
    • Indexed items
    • key
    • Key used to access record
    • text
    • Edit - 12
    • Sequence
    • Put data in the order that you require - Sequence is a specialist piece of code in that it governs the order in which code appears. Code to move up a record or move down a record is automatically generated with this option
    • Indexed items
    • sequence
    • Sequences allow you to put data in the order that you want
    • text
    • Edit - 17
    • Major
    • Major search term
    • Indexed items
    • major
    • Major Search term
    • text
    • Edit - 18
    • Minor
    • Minor key with which to select information
    • Indexed items
    • minor
    • Minor key with which to select information
    • text
    • Edit - 19
    • Qualifier
    • The qualifier is the final word required in the three word system
    • Indexed items
    • Qualifier
    • Qualifies the three words
    • text
    • Edit - 62
    • Image
    • Image
    • Objects
    • image
    • Image name
    • text
    • Edit - 71
    • Image Path
    • Path to the image
    • Objects
    • imagePath
    • Path to image
    • text
    • Edit - 63
    • Image Title
    • Image Title
    • Objects
    • imageTitle
    • Image Title
    • text
    • Edit - 64
    • Image Link
    • Image Link
    • Objects
    • imageLink
    • Link for the image
    • text
    • Edit - 72
    • Image link new window
    • New Window
    • Objects
    • imageLinkNewWindow
    • Link to a new window, default Yes
    • select
    • Edit - 65
    • Image position
    • Indicates the position of the image
    • Objects
    • imagePosition
    • Position of the image
    • select
    • Edit - 66
    • Image Height
    • Height of the image
    • Objects
    • imageHeight
    • Height of image
    • text
    • Edit - 67
    • Image Width
    • Width of the image
    • Objects
    • imageWidth
    • Width of image
    • text
    • Edit - 68
    • Meta Description
    • Meta description - used by google to describe the item
    • Objects
    • metaDescription
    • Description of the object used by Google and other search engines
    • textarea
    • Edit - 69
    • Meta Keywords
    • Keywords used by Google and other search engines to describe the object
    • Objects
    • metaKeywords
    • Keywords used by Google and other search engines to describe the objects
    • text
    • Edit - 70
    • Link Text
    • When creating a link then you need somethink to link, and this is the link text
    • Objects
    • linkText
    • Text that is used in links
    • text
    • Edit - 59
    • xxxId
    • External Id
    • Parent
    • xxxId
    • External Id by which a record can be retrieved but not edited
    • text
    • Edit - 8
    • Code
    • Codes are written by the user and are only alphanumeric characters plus an '_' or '-'. They are great when you need to access the data by application code
    • Parent
    • code
    • Code that groups children together
    • text
    • Edit - 9
    • Short Unique key
    • Unique keys are generated by the system. They are great for records where the code is not to be used by the application code. This code is 11 characters which is the same length as used by you-tube for the videos that they have on record
    • Parent
    • key
    • The key is used to group children records together
    • text
    • Edit - 10
    • Long Unique Key
    • This parent key is 24 characters in length, which is the same length as You tube's customer records
    • Parent
    • key
    • Parent key used to group children together
    • text
    • Edit - 20
    • Language
    • Allows multiple language support
    • Select
    • lang
    • The language of the data
    • select
    • Edit - 31
    • Access
    • Access can restrict the users who are allowed to see a code
    • Select
    • access
    • Access allows you to restrict which users can use the code
    • select
    • Edit - 85
    • Profile
    • Determins the profile of the user
    • Select
    • profile
    • The profile of the user
    • select
    • Edit - 33
    • Display
    • Display governs how information is displayed
    • Select
    • display
    • Governs how information is displayed
    • select
    • Edit - 60
    • pageType
    • Page Type
    • Select
    • pageType
    • Page Type dictated the template that is to be used to create the page
    • select
    • Edit - 81
    • pageType
    • Page Type
    • Select
    • pageType
    • Page Type dictated the template that is to be used to create the page
    • select
    • Edit - 61
    • Category
    • Category
    • Select
    • category
    • Allows pages to be grouped together using a category
    • select