How do I creat relationships, here is some code to creat my tables
if(!$result = mysql_query('CREATE TABLE IF NOT Exists Class_Alias_Cla ( Cla_Act TINYINT(1) NOT NULL DEFAULT 1 , Cla_PK INT NOT NULL AUTO_INCREMENT , Cla_Cl_PK INT DEFAULT 0 , Cla_F_Name VARCHAR(25), PRIMARY KEY (Cla_PK) )')) { echo ' Error creating Table ' . mysql_error(); }
if(!$result = mysql_query('CREATE TABLE IF NOT Exists Class_Cl ( Cl_Act TINYINT(1) NOT NULL DEFAULT 1 , Cl_PK INT NOT NULL AUTO_INCREMENT , Cl_S_Name VARCHAR(15) , Cl_F_Name VARCHAR(25) , Cl_Notes VARCHAR(50) , Cl_R1 VARCHAR(50) , Cl_R2 VARCHAR(50) , Cl_R3 VARCHAR(50) , Cl_R4 VARCHAR(50) , Cl_R5 VARCHAR(50) , Cl_R6 VARCHAR(50) , Cl_R7 VARCHAR(50) , Cl_R8 VARCHAR(50) , Cl_R9 VARCHAR(50) , Cl_R10 VARCHAR(50) , CL_Unknown TINYINT(1) NOT NULL DEFAULT 0, PRIMARY KEY (Cl_PK) )')) { echo ' Error creating Table ' . mysql_error(); }
Table- Class_Cl and Table- Class_Alias_Cla
Cl_PK --Relationship--> Cla_Cl_PK
Attributes: Enforced, Cascade Deletes, Left Join
RelationshipType: One-To-Many
