Hello:
Soon I will need to have my foriegn keys working. I have tried to set them up with no luck.
Could someone show me how to set the payee_uid below? I am using an Apache Derby Embbeded Db 10.5.3.
Thanks
<entry key="createStudentTable"> CREATE TABLE student (
stu_uid VARCHAR(11) PRIMARY KEY,
stu_password VARCHAR(11),
stu_lname VARCHAR(20),
stu_mname VARCHAR(20),
stu_fname VARCHAR(20),
stu_gender VARCHAR(1),
stu_dob DATE,
stu_start_date DATE,
stu_end_date DATE,
stu_area_code VARCHAR(3),
stu_phone VARCHAR(10),
stu_address VARCHAR(20),
stu_state VARCHAR(2),
stu_zip VARCHAR(5),
<!--
payee_uid VARCHAR(11),
-->
stu_email VARCHAR(90)
) </entry>