Table sem5.dbo.SEM_OS_INFO
Maps the operatioing system text to its version and flavor

Generated by
SchemaSpy
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
OPERATING_SYSTEM nvarchar 256
OS_NAME nvarchar 128 Operating system name
OS_TYPE nvarchar 128  √  ('') Operating system type
SPC_OS_NAME nvarchar 128  √  ('') Operating system name in SPC
SPC_OS_TYPE nvarchar 128  √  ('') Operating system type in SPC
OS_MAJOR int 4  √  ('') Operating system major version
OS_MINOR int 4  √  ('') Operating system minor version
SPC_OS_VERSION nvarchar 128  √  ('') Operating system version in SPC
OS_FAMILY int 4 Operating system family
DELETED tinyint 1 ((0)) The deleted flag of the schema object:
1 = Deleted
0 = Not Deleted
USN bigint 8 ((1)) Update serial number; used by replication
TIME_STAMP bigint 8 ((0)) Time that the record was modified; used to resolve merge conflict
I18N_KEY varchar 64 ('') Key value for i18n display

Analyzed at Mon Oct 29 12:07 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
OPERATING_SYSTEM Primary key Asc PK_SEM_OS_INFO
USN Performance Asc I_SEM_OS_INFO_USN