-- create_pref_cust.sql

CREATE TABLE preferred_customer
( id NUMERIC PRIMARY KEY REFERENCES person(id),
   discount NUMERIC(3, 3) DEFAULT 0.05,
   description VARCHAR(78));
