### Recommended AI Product Development Workflow Diagram

Source: https://github.com/nurettincoban/ai-prd-workflow/blob/main/README.md

Visual representation of the recommended steps in the AI product development workflow. This diagram illustrates the sequence from creating a PRD to final testing.

```text
┌──────────┐   ┌──────────┐   ┌──────────┐   ┌──────────┐   ┌──────────┐   ┌──────────┐   ┌──────────┐   ┌──────────┐
│  Create  │   │  Verify  │   │ Extract  │   │  Create  │   │ Generate │   │Implement │   │  Code    │   │ Testing  │
│   PRD    │──>│   PRD    │──>│ Features │──>│  Rules   │──>│   RFCs   │──>│   RFCs   │──>│  Review  │──>│ Strategy │
└──────────┘   └──────────┘   └──────────┘   └──────────┘   └──────────┘   └──────────┘   └──────────┘   └──────────┘
```

--------------------------------

### Copy Prompt Script Usage

Source: https://github.com/nurettincoban/ai-prd-workflow/blob/main/README.md

Bash script commands for managing and copying AI prompts. Use '--list' to see available prompts or copy a specific prompt to your clipboard.

```bash
# Make the script executable (first time only)
chmod +x copy-prompt.sh

# List all available prompts
./copy-prompt.sh --list

# Copy a prompt to clipboard
./copy-prompt.sh interactive-prd-creation-prompt.md
```

--------------------------------

### Database Schema for URL Shortener

Source: https://github.com/nurettincoban/ai-prd-workflow/blob/main/examples/url-shortener/RFCs/RFC-001-Core-URL-Shortening.md

Defines the SQL schema for the 'urls' table, including fields for short code, original URL, creation/expiration timestamps, and active status. An index on 'short_code' is included for efficient lookups.

```sql
CREATE TABLE urls (
  id SERIAL PRIMARY KEY,
  short_code VARCHAR(30) UNIQUE NOT NULL,
  original_url TEXT NOT NULL,
  created_at TIMESTAMP DEFAULT NOW(),
  expires_at TIMESTAMP NULL,
  is_active BOOLEAN DEFAULT TRUE
);
CREATE INDEX idx_urls_short_code ON urls(short_code);
```

--------------------------------

### SQL Schema for Click Tracking

Source: https://github.com/nurettincoban/ai-prd-workflow/blob/main/examples/url-shortener/RFCs/RFC-002-Click-Analytics.md

Defines the 'clicks' table to store analytics data for each URL click, including timestamp, referrer, user agent, and country code. Indexes are included for efficient querying.

```sql
CREATE TABLE clicks (
  id SERIAL PRIMARY KEY,
  url_id INTEGER REFERENCES urls(id) ON DELETE CASCADE,
  clicked_at TIMESTAMP DEFAULT NOW(),
  referrer VARCHAR(2048),
  user_agent VARCHAR(1024),
  country_code CHAR(2)
);
CREATE INDEX idx_clicks_url_id ON clicks(url_id);
CREATE INDEX idx_clicks_clicked_at ON clicks(clicked_at);
```

--------------------------------

### JSON Response Format for Analytics API

Source: https://github.com/nurettincoban/ai-prd-workflow/blob/main/examples/url-shortener/RFCs/RFC-002-Click-Analytics.md

Illustrates the expected JSON structure for analytics data returned by the API endpoints, including total clicks, timeline, top referrers, and country-based click distribution.

```json
{
  "data": {
    "totalClicks": 1234,
    "timeline": [{ "date": "2026-03-01", "clicks": 45 }],
    "topReferrers": [{ "referrer": "twitter.com", "clicks": 200 }],
    "countries": [{ "country": "US", "clicks": 500 }]
  }
}
```

=== COMPLETE CONTENT === This response contains all available snippets from this library. No additional content exists. Do not make further requests.