|
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 |
|
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. |
|
|
|
Data |
NOT |
F |
|
|
subsystem |
varchar(30) |
X |
X |
|
|
|
ss_label |
varchar(15) |
X |
|
|
|
|
major |
|
smallint |
X |
|
|
|
middle |
|
smallint |
X |
|
|
|
minor |
|
smallint |
X |
|
|
|
Name |
Columns |
Options |
PK |
|
pk_ap_sla |
subsystem, ss_label | clustered |
X |
|
ap_sla_numbers |
subsystem, major, middle, minor | nonclustered |
|
|
Child Table |
Foreign Key Columns |
|
subsystem; ss_label |
|
Parent Table |
Foreign Key Columns |
|
subsystem |
|
|
|