Re: Row / Record Versioning Design

I seem to remember being reprimanded for asking non-web related questions on this forum. Just saying.....

Sent from my iPad

On 16 Jan 2015, at 03:27, Booth Martin <booth@xxxxxxxxxxxx> wrote:

The primary keys are a description of an item and the version number?

That description thing worries me a bit. It leaves editing of the description as an on-going challenge, and could become messy for grouping.

I have no idea how many items you are keeping track of, but my own preferences are:
Key 1: location/department/bldg/floor/etc.
Key 2: type/name/category
Key 3: Unique ID
Key 4: Versioning

(As many or as few keys as needed to allow managing the database.)

On 1/15/2015 7:51 PM, Holm, Paul wrote:
Hi,

Looking for design ideas or experience with the following.

We are creating a DB to hold equipment where each record holds a
description of equipment. They want to have the ability to have 1 to many
"versions" of the record. For example, if a device firmware or
configuration is updated, they want to maintain the old record.

I'm thinking I can accomplish all this by simply adding a "Version" column
to the database. Version could have values such as "1.0", "1.2", or
*CURRENT if it's the latest. When a new version is needed, we simply copy
the record and update the VERSION field.

Feedback with this approach?

Thanks in advance, Paul

--
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.

________________________________

NOTICE: The information in this electronic mail transmission is intended by CoralTree Systems Ltd for the use of the named individuals or entity to which it is directed and may contain information that is privileged or otherwise confidential. If you have received this electronic mail transmission in error, please delete it from your system without copying or forwarding it, and notify the sender of the error by reply email or by telephone, so that the sender's address records can be corrected.



--------------------------------------------------------------------------------


CoralTree Systems Limited
Company Registration Number 5021022.
Registered Office:
12-14 Carlton Place
Southampton
Hampshire
SO15 2EA
VAT Registration Number 834 1020 74.