Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
SGRP_Group varchar (16) VARCHAR2 (16 CHAR) varchar(16) varchar (16) false Status group
SGRP_MainRange varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) false Main number range of status group
SGRP_SubRanges varchar(1024) VARCHAR2 (1024 CHAR) varchar(1024) varchar(1024) true Sub number ranges + single numbers
SGRP_ExcludeForTL varchar(512) VARCHAR2 (512 CHAR) varchar(512) varchar(512) true Numbers excluded for trafic lights e.g. 1700 in waiting blue


Name Fields Primary Unique Clustered Nonclustered
PK_SGRP SGRP_Group, SGRP_MainRange true true false false

Foreign Keys:

Name Local References Foreign References

Return to the Index File