#223 Wrong definition for autonumeric fields in double and triple tables

M22
Finished
Emili Miedes
DS.sql (10) Database (2)
None
False
2016-11-10
2016-08-12
Roberto C.
No
0 up votes | 0 down votes | 0%
5 comments

Discussion

  • Roberto C.
    Roberto C.
    2016-08-12

    • status: open --> unread
     
    Link

    • Raul Poler
      Raul Poler
      2016-08-30

      Yes, the IDs of tables doubles or triples should be of type INT or BIGINT (not autonumeric)

       
      Link

  • Emili Miedes
    Emili Miedes
    2016-09-01

    • Description has changed:

    Diff:

    --- old
+++ new
@@ -1,2 +0,0 @@
-In some tables that are called "double" or "triple tables", the IDs used to refer to the corresponding simple tables are autonumeric. Are they wrong?
-Maybe, the autonumeric type should be used in "simple tables", and the generated identifiers should be used in the single table and the other ones (to use the same ID in all of them, to stablish the relationship among them).
    • status: unread --> closed
     
    Link

  • Ruben de Juan
    Ruben de Juan
    2016-11-10

    Ticket moved from /p/c2net/cpl/paas4man/dst/dssql/tickets/2/

     
    Link

  • Ruben de Juan
    Ruben de Juan
    2016-11-10

    • labels: --> DS.sql, Database
    • status: closed --> Finished
    • is_usable: --> False
    • milestone: 1.0 --> M22
     
    Link