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!
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!