Navigation

    APPDRAG Community

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Popular

    REMINDER

    Please be respectful of all AppDragers! Keep it really civil so that we can make the AppDrag community of builders as embracing, positive and inspiring as possible.

    SOLVED What is AI, PK, UQ when creating new column?

    Cloud Backend (Cloud DB, API Builder)
    3
    6
    556
    Loading More Posts
    • 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.
    • T
      Thomas D last edited by

      There's nothing in help and nothing in the app showing what it is and what it does?

      1 Reply Last reply Reply Quote 0
      • Daniel Mulroy
        Daniel Mulroy last edited by

        Hello Thomas!

        These are SQL parameters.

        AI: Auto Increments the field on each new insertion
        PK: Primary Key - this is the field that will be used when doing joins (like linked fields)
        UQ: Unique - the SQL operation will fail it would cause two rows to have the same value in this column. This is best used for things like social security numbers, customer id numbers, and other things that are VERY IMPORTANT never to have conflict or duplicated.

        Hope this helps!

        @Wassim-Samad or @Joseph-Benguira, it'd be really nice to have these as tooltips.

        1 Reply Last reply Reply Quote 3
        • Daniel Mulroy
          Daniel Mulroy last edited by

          Hello Thomas!

          These are SQL parameters.

          AI: Auto Increments the field on each new insertion
          PK: Primary Key - this is the field that will be used when doing joins (like linked fields)
          UQ: Unique - the SQL operation will fail it would cause two rows to have the same value in this column. This is best used for things like social security numbers, customer id numbers, and other things that are VERY IMPORTANT never to have conflict or duplicated.

          Hope this helps!

          @Wassim-Samad or @Joseph-Benguira, it'd be really nice to have these as tooltips.

          1 Reply Last reply Reply Quote 3
          • Wassim
            Wassim last edited by

            @Daniel-Mulroy said in What is AI, PK, UQ when creating new column?:

            to have these as tooltips.

            Actually I wanted to add the tooltips, and.. they are already here if you put your cursor on AI, PK or UQ..

            T 1 Reply Last reply Reply Quote 0
            • T
              Thomas D @Wassim last edited by Thomas D

              @wassim Hm, that's odd, I checked for tool-tips twice, but now they appear 😛

              Daniel Mulroy 1 Reply Last reply Reply Quote 1
              • Daniel Mulroy
                Daniel Mulroy @Thomas D last edited by

                @ThomasD I also checked for tooltips before answering and didn't find them.

                1 Reply Last reply Reply Quote 0
                • Wassim
                  Wassim last edited by

                  Is this a conspiracy?

                  alt text

                  1 Reply Last reply Reply Quote 4
                  • First post
                    Last post