Creating SQL table, foreign_key confusion

Question

schema

One question, I have supervisor set as foreign key. He collect information through Activity Participant and take it from person ID.

Question:

How should I create the Activity table? what do I have to write down about supervisor?

CREATE TABLE activity
(
act_id VARCHAR(8) CONSTRAINT activity_pk PRIMARY KEY,
act_type VARCHAR2(20),
act_desc VARCHAR2(30),
act_date DATE,
mor_aft VARCHAR2(9),
CONSTRAINT activity_sup_fk FOREIGN KEY (act_supVisor) REFERENCES person()
);

score 2 · Accepted Answer · answered Mar 10 '13 at 15:07

2

A foreign key must reference a unique key of the referenced table. Either the table's primary key, or else a secondary unique key.

CONSTRAINT activity_sup_fk FOREIGN KEY (act_supVisor) 
  REFERENCES person(Person_id)

answered Mar 10 '13 at 15:07

Bill Karwin

538,548
86
673
828

It just like this? Hah...... will try, I just start to confuse my self and imagine that this will much harder)) – Denis Nurasy Mar 10 '13 at 15:10

Creating SQL table, foreign_key confusion

1 Answers1