SQL - Foreign key with references of multiple tables with same primary key field

[Chirag]

I want to create a table with

member id(primary key for Students,faculty and staff [Tables])

and now i want to create issues[Tables] with foreign key as member id
but in references i could not able to pass on reference as or
condition for students, faculty and staff.

Thank You,
Chirag

[Ed Murphy]

Chirag wrote:

I want to create a table with

member id(primary key for Students,faculty and staff [Tables])

and now i want to create issues[Tables] with foreign key as member id
but in references i could not able to pass on reference as or
condition for students, faculty and staff.

Create a Members table, then have all the other tables reference it.

[M A Srinivas]

On Apr 9, 9:48 am, "Chirag" <[e-mail]:

I want to create a table with

member id(primary key for Students,faculty and staff [Tables])

and now i want to create issues[Tables] with foreign key as member id
but in references i could not able to pass on reference as or
condition for students, faculty and staff.

Thank You,
Chirag

Two options

1. Create multiple member tables
member_student,member_faculty,member_staff and
issues_student,issues_faculty,issues_staff

2. Create a new column called flag in both the tables like
Create table member ( memberid iNT, Flag Char(1) --S - Student,
F- Faculty, T - Staff)

Primary Key (flag,memberid)
Create table Issues (memberid INT, Flag Char(1) -- S - Student, F-
Faculty, T- Staff)
Primary Key (flag,memberid)

Now Reference two tables with flag and memberid.

If you want to refernce member table with student,faculty,staff you
need to handle in trigger

[nehajain.cse]

On Apr 8, 11:34 pm, "M A Srinivas" <[e-mail]:

On Apr 9, 9:48 am, "Chirag" <[e-mail]:

I want to create a table with

member id(primary key for Students,faculty and staff [Tables])

and now i want to create issues[Tables] with foreign key as member id
but in references i could not able to pass on reference as or
condition for students, faculty and staff.

Thank You,
Chirag

Two options

1. Create multiple member tables
member_student,member_faculty,member_staff and
issues_student,issues_faculty,issues_staff

2. Create a new column called flag in both the tables like
Create table member ( memberid iNT, Flag Char(1) --S - Student,
F- Faculty, T - Staff)

Primary Key (flag,memberid)
Create table Issues (memberid INT, Flag Char(1) -- S - Student, F-
Faculty, T- Staff)
Primary Key (flag,memberid)

Now Reference two tables with flag and memberid.

If you want to refernce member table with student,faculty,staff you
need to handle in trigger

Hi,
cant be create one foreign key at column level and others at table
level