Outline a possible database schema for a company specializing in consumer UAV drones and related accessories
Here is an example of a potential schema for the DroneDeals dataset:

```sql
CREATE TABLE companies (
    id SERIAL PRIMARY KEY,
    name TEXT NOT NULL UNIQUE,
    address TEXT,
    city TEXT,
    state TEXT,
    zip INTEGER DEFAULT 0,
    phone_number TEXT,
    email VARCHAR(255) UNIQUE,
    website URL
);

CREATE TABLE products (
    id SERIAL PRIMARY KEY,
    company_id INTEGER REFERENCES companies(id),
    product_name TEXT NOT NULL UNIQUE,
    category TEXT,
    price REAL,
    stock INT DEFAULT 1,
    FOREIGN KEY (company_id) REFERENCES companies(id) ON DELETE CASCADE
);

CREATE TABLE orders (
    id SERIAL PRIMARY KEY,
    order_date TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT now(), -- date when order was placed
    customer_id INTEGER REFERENCES customers(id),  -- ID of customer placing the order
    status ENUM('open', 'closed') NOT NULL DEFAULT 'open',
    total REAL,
    FOREIGN KEY (customer_id) REFERENCES customers(id) ON DELETE RESTRICT
);

CREATE TABLE shipments (
    id SERIAL PRIMARY KEY,
    order_id INTEGER REFERENCES orders(id),  -- ID of associated order
    shipped_to INTEGER REFERENCES customers(id),   -- ID of recipient of shipment
    STATUS ENUM('processing', 'completed') NOT NULL DEFAULT 'pending',
    FOREIGN KEY (shipped_to) REFERENCES customers(id) ON DELETE SETNULL
);

CREATE TABLE customers (
    id SERIAL PRIMARY KEY,
    username TEXT