>I can't help you with your main problem, as I usually use a tool for
>creating/altering tables, but I will say this: create a pk or identity
>for your entries table. For that matter, every table ever should have
>an identity.
I adjusted it to the following, but as you said, I'm left with my original
table creation problem for marathon_entries:
create table marathon_login (
marathon_id NUMBER Primary Key,
marathon_date_added date,
marathon_fname VARCHAR2(100),
marathon_lname VARCHAR2(100),
marathon_email VARCHAR2(100),
marathon_type VARCHAR2(100)
)
create table marathon_entries (
marathon_entry_id NUMBER Primary Key,
marathon_id NUMBER REFERENCES marathon_login(marathon_id),
marathon_date_added date,
marathon_type VARCHAR2(100) REFERENCES marathon_login(marathon_type),
marathon_data_date date,
marathon_entry VARCHAR2(10)
)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184284
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
