abasslabels (ap_sla)

Name

abasslabels

Code

ap_sla

Creation Date

13 december 2000 13:53:05

Modification Date

24 september 2012 09:43:33

Comment

All labels for a subsystem


Table description

This is a help table that stores all version-control labels that have been entered for a subsystem with DBBUILD or update scripts generated by DBUPDGEN. The purpose is twofold:

1) To provide a translation from string to version numbers. E.g, the label L4.70.0100 will have major = 4, middle = 70 and minor = 100. The label V1.3 will yield major = 1, middle = 3 and minor = 0.

2) To check that for the same subsytstem you are not using labels with the same major/middle/minor, for instance both L4.00.0020 and G4.0.20.

 

There is an ss_label column in abasysobjects and abahistsysobjects and they permit ad hoc labels such as "AB1V", but labels for a subsystem must be on the form LetterMajor.Middle.Minor.

 

Normally you have no reason to meddle in this table.


Column list


Column


Domain

Data
Type

NOT
NULL

F
K


Comment

subsystem

ap_subsystem

varchar(30)

X

X

 

ss_label

ap_sslabel

varchar(15)

X

 

 

major

 

smallint

X

 

 

middle

 

smallint

X

 

 

minor

 

smallint

X

 

 


Keys

Name

Columns

Options

PK

pk_ap_sla

subsystem, ss_label clustered

X

ap_sla_numbers

subsystem, major, middle, minor nonclustered

 


Tables referring to abasslabels

Child Table

Foreign Key Columns

abasubsystems

subsystem; ss_label


Tables abasslabels refers to

Parent Table

Foreign Key Columns

abasubsystems

subsystem