Advertisement
Guest User

Untitled

a guest
Mar 21st, 2019
45
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.77 KB | None | 0 0
  1. CREATE TABLE [dbo].[AttributesList](
  2. [Id] INT IDENTITY(1,1) NOT NULL,
  3. [ObjectType] VARCHAR(32) NOT NULL, -- wich objects have the attribute
  4. [AttributeCode] VARCHAR(32) NOT NULL, -- short attr identifier
  5. [Kind] INT NOT NULL, -- kind of the attribute's value
  6. [Name] VARCHAR(80) NOT NULL
  7. )
  8.  
  9. CREATE TABLE [dbo].[AttributesValues](
  10. [Id] INT IDENTITY(1,1) NOT NULL,
  11. [ObjectId] INT NOT NULL, -- object.object_id
  12. [Kind] INT NOT NULL, -- AttributesList.Id
  13. [Code] VARCHAR(32) NULL, -- for short strings
  14. [Flag] VARCHAR(80) NULL, -- for int values
  15. [Info] VARCHAR(250) NULL, -- for long strings
  16. [Amount] MONEY NOT NULL
  17. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement