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