OF-Scraper
  • Welcome
  • Requirements
  • Install
    • Pre-Install Guides
      • Linux
      • Windows
      • Mac
    • PIPX Install
    • PIP Install
    • Binary Releases
    • Docker
    • Release Info
    • Managing Multiple Python Versions
  • Getting Started and Settings
    • Config Options
      • Config Location
      • General Options
      • File Output Options
        • Placeholders
        • Responsetype Placeholders
      • Download Options
        • Download Toggles
        • Media Filtering Options
        • Advanced Download Options
      • Setting metadata path
      • Binaries Options
      • CDM Options
      • Performance Options
        • Values to Pick
      • Script Options
      • Advanced config options
        • Changing Const Values
        • Mediatype overwrites
    • Depreciated Options
    • Auth
    • Controlling Output/Logs
    • Migrating from Digitalcriminal's script
  • Using the Scraper
    • Using Prompts
      • Old Menu
      • Page 2
    • Username selection or Fuzzy Search
    • Basic Automation with command-line
      • Basic Actions
        • Liking/Unliking Post
        • Downloading Content
          • Downloading Text Files
          • Downloading Purchases From Deleted Models
        • Multiple Actions
      • Model Filtering/Sorting
        • Price Filtering/Sort
      • Advanced Args
      • Scripting tips
      • Enable label scan
    • Recipes
      • Adding Proxy
      • Redownload Deleted Downloads
  • Content Check Modes
    • Table Columns
    • Table Management
      • Pre 3.10.7 filtering
  • Scraping Individual Posts or Media
  • Metadata
    • Schema
    • Creating Metadata
    • Metadata location
  • CDM Setup
    • CDM issues
  • FAQ/Common Issues
    • Page 1
  • Command Reference
    • Shared Options
      • General Program Options
        • Program Options
        • Logging Options
        • Filename Modification Options
        • Media Filters Options
        • Download Options
        • Advanced Program Options
      • Shared Scrape and Metadata Check Mode Options
        • User List Filter Options
          • Advanced User Filters
        • User Selection Options
        • Model Sorting & Processing Options
        • Content Options
        • Automation Options
        • Advanced Search & Processing Options
    • Main Scraper Options
    • Metadata Check Mode Options
    • Content Check Modes Options
    • Manual Mode Options
  • Request Change to Doc
  • Testing
Powered by GitBook
On this page
  • Schemas
  • Labels
  • Medias
  • Messages
  • Posts
  • Stories
  • Models
  • Profiles
  • Products
  • Others
  • Schema_flags
  1. Metadata

Schema

Schemas

The schema may be extended in future versions, but existing columns will remain for backwards compatibility.

Labels

  • id: INTEGER NOT NULL PRIMARY KEY

  • label_id: INTEGER

  • name: VARCHAR

  • type: VARCHAR

  • post_id: INTEGER

  • model_id: INTEGER

  • UNIQUE (post_id, label_id, model_id)

Medias

  • model_id: INTEGER

  • hash: VARCHAR

  • unlocked: BOOL

  • duration: VARCHAR

  • posted_at: TIMESTAMP

  • created_at: TIMESTAMP

  • downloaded: BOOL

  • linked: BOOL

  • preview: INTEGER

  • media_type: VARCHAR

  • api_type: VARCHAR

  • size: INTEGER

  • filename: VARCHAR

  • directory: VARCHAR

  • link: VARCHAR

  • post_id: INTEGER NOT NULL

  • media_id: INTEGER

  • id: INTEGER NOT NULL PRIMARY KEY

  • UNIQUE (media_id, model_id, post_id)

Messages

  • model_id: INTEGER

  • user_id: INTEGER

  • created_at: TIMESTAMP

  • archived: BOOLEAN

  • paid: BOOLEAN

  • price: INTEGER

  • text: VARCHAR

  • post_id: INTEGER NOT NULL

  • id: INTEGER NOT NULL PRIMARY KEY

  • UNIQUE (post_id, model_id)

Posts

  • model_id: INTEGER

  • created_at :TIMESTAMP

  • opened: BOOLEAN

  • stream: BOOLEAN

  • pinned: BOOLEAN

  • archived: BOOLEAN

  • paid: INTEGER

  • price: INTEGER

  • text: VARCHAR

  • post_id: INTEGER NOT NULL

  • id: INTEGER NOT NULL PRIMARY KEY

  • UNIQUE (post_id, model_id)

Stories

  • model_id: INTEGER

  • created_at: TIMESTAMP

  • archived: BOOLEAN

  • paid: INTEGER

  • price: INTEGER

  • text: VARCHAR

  • post_id: INTEGER NOT NULL

  • id: INTEGER NOT NULL PRIMARY KEY

  • UNIQUE (post_id, model_id)

Models

  • id: INTEGER NOT NULL PRIMARY KEY

  • model_id: INTEGER NOT NULL

  • UNIQUE model_id

Profiles

  • username: VARCHAR NOT NULL

  • user_id: INTEGER NOT NULL

  • id: INTEGER NOT NULL PRIMARY KEY

  • UNIQUE (user_id, username)

Products

  • id: INTEGER NOT NULL PRIMARY KEY

  • post_id: INTEGER NOT NULL

  • model_id: INTEGER

  • title: VARCHAR

  • created_at: TIMESTAMP

  • archived: BOOLEAN

  • paid: INTEGER

  • price: INTEGER

  • text: VARCHAR

  • UNIQUE (post_id, model_id)

Others

  • id: INTEGER, NOT NULL, PRIMARY KEY

  • post_id: INTEGER, NOT NULL

  • text: VARCHAR

  • price: INTEGER

  • paid: INTEGER

  • archived: BOOLEAN

  • created_at: TIMESTAMP

  • model_id: INTEGER

  • UNIQUE (post_id, model)

Schema_flags

  • flag_name: TEXT PRIMARY KEY

  • flag_value: TEXT

PreviousMetadataNextCreating Metadata

Last updated 10 months ago