Выберите правильный вариант SQL запроса для создания таблицы orderinfo

  • CREATE TABLE orderinfo(orderinfo_id integer, customer_id integer, date_placed date, date_shipped date, shipping numeric(7,2), CONSTRAINT fk_orderinfo_customer FOREIGN KEY(customer_id) REFERENCES customer(customer_id));
  • CREATE TABLE orderinfo(orderinfo_id serial, customer_id integer, date_placed date, date_shipped date, shipping numeric(7,2), CONSTRAINT orderinfo_pk PRIMARY KEY(orderinfo_id), CONSTRAINT fk_orderinfo_customer FOREIGN KEY(customer_id) REFERENCES customer(customer_id));
  • CREATE TABLE orderinfo(orderinfo_id serial, customer_id serial, date_placed date, date_shipped date, shipping numeric(7,2), CONSTRAINT orderinfo_pk PRIMARY KEY(customer_id), CONSTRAINT fk_orderinfo_customer FOREIGN KEY(customer_id) REFERENCES customer(customer_id));
Для просмотра статистики ответов нужно залогиниться.