SHARE
TWEET

Untitled

a guest Jun 15th, 2019 60 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. ALTER TABLE order
  2. ADD CONSTRATINT fk_created_by FOREIGN KEY (instructor_created_by)
  3. REFERENCES instructor(instructor_id);
  4.  
  5. ALTER TABLE order
  6. ADD CONSTRATINT fk_touched_by FOREIGN KEY (student_touched_by)
  7. REFERENCES student(student_id);
  8.  
  9. ,CONSTRAINT pk_order_id PRIMARY KEY (order_id)
  10. REFERENCES order_id (order_id)
  11. ,CONSTRAINT fk_customer_id FOREIGN KEY (customer_id)
  12. REFERENCES customer_id (customer_id)
  13. CONSTRATINT fk_created_by FOREIGN KEY (instructor_created_by)
  14. REFERENCES instructor(instructor_id);
  15. CONSTRATINT fk_touched_by FOREIGN KEY (student_touched_by)
  16. REFERENCES student(student_id))
  17.  
  18. ,CONSTRAINT pk_order_id PRIMARY KEY (order_id)
  19. REFERENCES order_id (order_id)
  20. ,CONSTRAINT fk_customer_id FOREIGN KEY (customer_id)
  21. REFERENCES customer_id (customer_id)
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top