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