mysql adding id

Out of context: Reply #7

  • Started
  • Last post
  • 10 Responses
  • flavorful0

    Not on link tables maximillion, you can go overkill on Identity fields, however, more often than not they are needed.

    They help with querying as well as they link better together with other tables (link tables) to reduce text searching to a mininum.

    t_Thread.cde_Thread (Unqiue ID)
    t_Thread.txt_Thread (Title of Thread)

    t_Post.cde_Post (Unique ID)
    t_Post.txt_Post (Content of Post)

    t_Thread_Post_Link.cde_Thread
    t_Thread_Post_Link.cde_Post

    How the two are connected, which house each uniquely.

View thread