mysql table creation problem..
- by pradeep
Hi,
I have a small problem.
I am creating an appointment table where in the foreign key is patient id which is referenced from patient table.This table is for all registered patients.
there will be unregistered patients also, who will be seeking appointments.SO i just need to store the name,phone and few details.
I don't want to make these 2 as different tables.
So is there a way to skip the integrity check of foreign key when i ma inserting unregistered patient data