Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Database & SysAdmin
  3. Database
  4. Name for Sql Table

Name for Sql Table

Scheduled Pinned Locked Moved Database
databasewpf
10 Posts 4 Posters 4 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • K Offline
    K Offline
    King Fisher
    wrote on last edited by
    #1

    Can you please suggest any meaningful name for new table. Purpose: Table will be used to store the email/sms template details like title, messagecontent,etc. This template title will be displayed in a dropdown list, users can choose templates from dropdown and send it. :rolleyes:

    நெஞ்சு பொறுக்கு திலையே-இந்த நிலைகெட்ட மனிதரை நினைந்துவிட்டால்

    J L J 4 Replies Last reply
    0
    • K King Fisher

      Can you please suggest any meaningful name for new table. Purpose: Table will be used to store the email/sms template details like title, messagecontent,etc. This template title will be displayed in a dropdown list, users can choose templates from dropdown and send it. :rolleyes:

      நெஞ்சு பொறுக்கு திலையே-இந்த நிலைகெட்ட மனிதரை நினைந்துவிட்டால்

      J Offline
      J Offline
      Jochen Arndt
      wrote on last edited by
      #2

      Why do you want to use the database table name as title for a dropdown list? Just name the table something like message_template. The list title belongs to the GUI and using the database table name makes no sense when you have to support multiple languages. Choose a title descriptive enough to be understand by the users.

      K 2 Replies Last reply
      0
      • J Jochen Arndt

        Why do you want to use the database table name as title for a dropdown list? Just name the table something like message_template. The list title belongs to the GUI and using the database table name makes no sense when you have to support multiple languages. Choose a title descriptive enough to be understand by the users.

        K Offline
        K Offline
        King Fisher
        wrote on last edited by
        #3

        No, I'll not display the table name in dropdown,only the title column from the table.

        நெஞ்சு பொறுக்கு திலையே-இந்த நிலைகெட்ட மனிதரை நினைந்துவிட்டால்

        J 1 Reply Last reply
        0
        • J Jochen Arndt

          Why do you want to use the database table name as title for a dropdown list? Just name the table something like message_template. The list title belongs to the GUI and using the database table name makes no sense when you have to support multiple languages. Choose a title descriptive enough to be understand by the users.

          K Offline
          K Offline
          King Fisher
          wrote on last edited by
          #4

          Can you suggest few more names which is more suitable for my table please ?

          நெஞ்சு பொறுக்கு திலையே-இந்த நிலைகெட்ட மனிதரை நினைந்துவிட்டால்

          J 1 Reply Last reply
          0
          • K King Fisher

            No, I'll not display the table name in dropdown,only the title column from the table.

            நெஞ்சு பொறுக்கு திலையே-இந்த நிலைகெட்ட மனிதரை நினைந்துவிட்டால்

            J Offline
            J Offline
            Jochen Arndt
            wrote on last edited by
            #5

            OK. But that is a value stored in the database and usually entered by the user (there would be no need to store that if it is a fixed title).

            K 1 Reply Last reply
            0
            • K King Fisher

              Can you suggest few more names which is more suitable for my table please ?

              நெஞ்சு பொறுக்கு திலையே-இந்த நிலைகெட்ட மனிதரை நினைந்துவிட்டால்

              J Offline
              J Offline
              Jochen Arndt
              wrote on last edited by
              #6

              Only you know what the table is storing and what would be a suitable name. Because the database design is usually not public, only the developers will use it. So I suggest to use the general rules for database names (and also variables and function names in programming languages): Use one that describes it, may be not confused with similar names in the same context (e.g. multiple tables containing some kind of templates), but is not too long.

              1 Reply Last reply
              0
              • J Jochen Arndt

                OK. But that is a value stored in the database and usually entered by the user (there would be no need to store that if it is a fixed title).

                K Offline
                K Offline
                King Fisher
                wrote on last edited by
                #7

                yeah, but there is a UI for user to create their own templates with template title, So, later when they want to send email/sms they will choose accordingly.

                நெஞ்சு பொறுக்கு திலையே-இந்த நிலைகெட்ட மனிதரை நினைந்துவிட்டால்

                1 Reply Last reply
                0
                • K King Fisher

                  Can you please suggest any meaningful name for new table. Purpose: Table will be used to store the email/sms template details like title, messagecontent,etc. This template title will be displayed in a dropdown list, users can choose templates from dropdown and send it. :rolleyes:

                  நெஞ்சு பொறுக்கு திலையே-இந்த நிலைகெட்ட மனிதரை நினைந்துவிட்டால்

                  L Offline
                  L Offline
                  Lost User
                  wrote on last edited by
                  #8

                  "Annie".

                  Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)

                  1 Reply Last reply
                  0
                  • K King Fisher

                    Can you please suggest any meaningful name for new table. Purpose: Table will be used to store the email/sms template details like title, messagecontent,etc. This template title will be displayed in a dropdown list, users can choose templates from dropdown and send it. :rolleyes:

                    நெஞ்சு பொறுக்கு திலையே-இந்த நிலைகெட்ட மனிதரை நினைந்துவிட்டால்

                    L Offline
                    L Offline
                    Lost User
                    wrote on last edited by
                    #9

                    "Templates"

                    1 Reply Last reply
                    0
                    • K King Fisher

                      Can you please suggest any meaningful name for new table. Purpose: Table will be used to store the email/sms template details like title, messagecontent,etc. This template title will be displayed in a dropdown list, users can choose templates from dropdown and send it. :rolleyes:

                      நெஞ்சு பொறுக்கு திலையே-இந்த நிலைகெட்ட மனிதரை நினைந்துவிட்டால்

                      J Offline
                      J Offline
                      jschell
                      wrote on last edited by
                      #10

                      notification_template 'notification' because it applies to email and sms. 'template' because although the are properties the group actual serves as a template for what the notification will be. Underscore to separate the two nouns. Should not be 'templates' plural because by definition a table is already a set. And there are cases where one wants a table to contain more than one row/record as a 'set'. In those cases the table might be better named with the plural.

                      1 Reply Last reply
                      0
                      Reply
                      • Reply as topic
                      Log in to reply
                      • Oldest to Newest
                      • Newest to Oldest
                      • Most Votes


                      • Login

                      • Don't have an account? Register

                      • Login or register to search.
                      • First post
                        Last post
                      0
                      • Categories
                      • Recent
                      • Tags
                      • Popular
                      • World
                      • Users
                      • Groups