I am creating a DB to monitor the number of steps our faculty uses on
their pedometers.
I have two tables, one for login and the other for the step entries.
I can't get the table for the step entries to CREATE. It gives me
the error, "no matching unique or primary key for this column-list."
It references the login table.
Here are the two tables.
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_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)
)
btw, any other comments on these tables or their structure is
welcome. I'm pretty new to all this.
--
Daniel Kessler
Department of Public and Community Health
University of Maryland
Suite 2387 Valley Drive
College Park, MD 20742-2611
301-405-2545 Phone
www.phi.umd.edu
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:184278
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=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
