hi
anyone please help me
how to create a reference column for a table
i will send table structure please send me
physician:
employeeid – this is a unique ID of a physician(primary key it should be auto increment)
name – this is the name of a physician
position – this is the designation of a physician
ssn – this is a security number of a physician
department:
departmentid – this is a unique ID for a department(primary key it should be auto increment)
name – this is the name of a department
head – this is the ID of the physician who is the head of a department, referencing to the column employeeid of the table physician