Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE [dbo].[AttributesList](
- [Id] INT IDENTITY(1,1) NOT NULL,
- [ObjectType] VARCHAR(32) NOT NULL, -- wich objects have the attribute
- [AttributeCode] VARCHAR(32) NOT NULL, -- short attr identifier
- [Kind] INT NOT NULL, -- kind of the attribute's value
- [Name] VARCHAR(80) NOT NULL
- )
- CREATE TABLE [dbo].[AttributesValues](
- [Id] INT IDENTITY(1,1) NOT NULL,
- [ObjectId] INT NOT NULL, -- object.object_id
- [Kind] INT NOT NULL, -- AttributesList.Id
- [Code] VARCHAR(32) NULL, -- for short strings
- [Flag] VARCHAR(80) NULL, -- for int values
- [Info] VARCHAR(250) NULL, -- for long strings
- [Amount] MONEY NOT NULL
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement