Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2011
    Posts
    8

    Unanswered: Number of foreign keys in a single table

    Is it fine to have a table like the one below where "prv_id" is the primary key and the rest of the fields are foreign keys? My main concern is about the number of foreign keys.

    prv_id serial
    prv_user_id inetger
    prv_client_id integer
    prv_customs_id integer
    prv_patent_id integer
    prv_doctype_id integer

    Thanks in advance for your feedback.

  2. #2
    Join Date
    Oct 2014
    Posts
    2

    Your fine.

    I don't see why having a table of only foreign keys would be a problem. As for *the number of fields*, I am unaware of a limit, and by your example, your not using an exceeding number of fields. Besides, the DBMS won't let you create more fields then it allows.

  3. #3
    Join Date
    Apr 2011
    Posts
    8
    Quote Originally Posted by GregValcourt View Post
    I don't see why having a table of only foreign keys would be a problem. As for *the number of fields*, I am unaware of a limit, and by your example, your not using an exceeding number of fields. Besides, the DBMS won't let you create more fields then it allows.
    I appreciate your response.
    Is there any issue from the normalization point of view?
    Is this an acceptable DB design?

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •