Advertisement
Guest User

Untitled

a guest
Oct 17th, 2017
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE ipac_product_inquiry_response (
  2.     id bigint PRIMARY KEY,
  3.     version integer NOT NULL,
  4.     creation_date timestamp without time zone NOT NULL,
  5.     update_date timestamp without time zone,
  6.     creation_user_id varchar(255) NOT NULL,
  7.     update_user_id varchar(255),
  8.     deleted_flag boolean NOT NULL DEFAULT false,
  9.     product_conception_id bigint NOT NULL,
  10.     inquiry_id bigint NOT NULL,
  11.     inquiry_response_id bigint NOT NULL,
  12.     CONSTRAINT FK_IPIR__PC__product_conception_id FOREIGN KEY (product_conception_id) REFERENCES product_conception(id),
  13.     CONSTRAINT UN_IPIR__product_conception_id__inquiry_id UNIQUE(product_conception_id, inquiry_id)
  14. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement