Search Help Show/Hide Menu
Summary
Item Identification
Data Attributes
Catalog Details

Summary

Entity Information

Data Attribute / Type Description
NAME
NVARCHAR
PRINCIPAL_ID
INT
DIAGRAM_ID
INT
VERSION
INT
DEFINITION
VARBINARY

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (PIRO) for inquiries on this record.

Item Identification

Title: Table: sysdiagrams
Short Name: sysdiagrams
Status: In Work

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
67
NAME NVARCHAR
67
PRINCIPAL_ID INT
67
Primary Key DIAGRAM_ID INT
67
VERSION INT
67
DEFINITION VARBINARY

Attribute Details

NAME

CC ID: 178927
Seq. Order: 1
Data Storage Type: NVARCHAR
Max Length: 128
Required: Yes
Primary Key: No
Status: Active

PRINCIPAL_ID

CC ID: 178928
Seq. Order: 2
Data Storage Type: INT
Max Length: 4
Required: Yes
Primary Key: No
Precision: 10
Status: Active

DIAGRAM_ID

CC ID: 178929
Seq. Order: 3
Data Storage Type: INT
Max Length: 4
Required: Yes
Primary Key: Yes
Precision: 10
Status: Active

VERSION

CC ID: 178930
Seq. Order: 4
Data Storage Type: INT
Max Length: 4
Required: No
Primary Key: No
Precision: 10
Status: Active

DEFINITION

CC ID: 178931
Seq. Order: 5
Data Storage Type: VARBINARY
Max Length: -1
Required: No
Primary Key: No
Status: Active

Catalog Details

Catalog Item ID: 21898
GUID: gov.noaa.nmfs.inport:21898
Metadata Record Created By: Eric Forney
Metadata Record Created: 2014-07-11 18:03+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2015-12-03
Owner Org: PIRO
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2015-12-03
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2016-12-03