Database Design Document - Database Core


Tables

Core.Produt dbo.Ref_Enumeration dbo.Ref_EnumerationMember

Views

dbo.Produt_View

Stored Procedures

Core.Produt_GetList

Tables Detail Information

[Core].[Produt] é Back to top
Name Data Type Nulls PK FK Default Description
Id int ü
Name varchar (50) ü
Price decimal ü
[dbo].[Ref_Enumeration] é Back to top
Enum type data.
Name Data Type Nulls PK FK Default Description
Name varchar (64) ü Name of enum.
BaseType varchar (32) 'int' Base class of enum.
HasFlagsAttribute bit If enum has FlagsAttribute.
Description nvarchar (128) ü Description of enum
[dbo].[Ref_EnumerationMember] é Back to top
Enmu member data.
Name Data Type Nulls PK FK Default Description
EnumerationName varchar (64) ü ü Name of enum.
Name varchar (64) ü Name of enum member.
Value bigint Value of enum member.
Description nvarchar (128) Description of enum member.

Views Detail Information

[dbo].[Produt_View] é Back to top
Name Data Type Nulls Description
Id int
Name varchar (50) ü
Price decimal ü

Stored Procedures Detail Information

[Core].[Produt_GetList] é Back to top
No parameters.