CREATE Or Replace TYPE ProductType AS OBJECT (
    id          NUMBER,
    name        VARCHAR2(15),
    description VARCHAR2(22),
    price       NUMBER(5, 2),
    days_valid  NUMBER,

    MEMBER FUNCTION getByDate RETURN DATE
  );

CREATE Or Replace TYPE AddressType AS OBJECT (
    street VARCHAR2(15),
    city   VARCHAR2(15),
    state  CHAR(2),
    zip    VARCHAR2(5)
  );

CREATE Or Replace TYPE PersonType AS OBJECT (
    id         NUMBER,
    first_name VARCHAR2(10),
    last_name  VARCHAR2(10),
    dob        DATE,
    phone      VARCHAR2(12),
    address    AddressType
  );

CREATE TABLE object_employee OF PersonType;

CREATE TABLE object_products OF ProductType;

CREATE TABLE purchases (
    id       NUMBER PRIMARY KEY,
    customer REF PersonType  SCOPE IS object_employee,
    product  REF ProductType SCOPE IS object_products
  );