XSERP Home Forums BatchMaster Users Group SQL Server (Database) User1, User2, User3 etc in tables

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #3143
    104rtuit
    Participant

    In the database, most tables I have looked at have 12 columns labeled User1 – User12. None of these have any data under them. What are they for?

    #3144

    These columns are user-defined columns. They allow for you to store extra data you may want to track that isn’t stored by BatchMaster out of the box. The type of data you want to store will determine which of these columns you want to choose. The datatypes of these columns are as follows:

    – User1,2,3: nvarchar(225)
    – User4,5: nvarchar(50)
    – User6: datetime
    – User7,8: float
    – User9,10: decimal(22, 6)
    – User11,12: int

Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.