composite PK which are FK

J

janet

hi...

i am creating a table :
create table student_content
(student_id varchar(10) references student_info
(student_id),
story_id numeric(4) references story_table(story_id),
status_student varchar(5),
story_original varchar(100),
story_status_date date,
story_word_count numeric(100),
composite primary key(student_id, story_id));

i have 3 tables:
1. student_info, PK -- > student_id
2. story_table, PK --> Story_id
3. student_content, PK--> (student_id, story_id)

can this be possible. i am getting error in this???

thanks a lot!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
474,265
Messages
2,571,069
Members
48,771
Latest member
ElysaD

Latest Threads

Top