content table

- id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,

- channel_id (BIGINT) NOT NULL
- account_id (BIGINT) NOT NULL

- content (TEXT) DEFAULT NULL
- content_type (varchar(255)) {post, story} NOT NULL
- media_type (varchar(255)) {image, video, audio, gif, none} DEFAULT none

- thumbnail (text) DEFAULT NULL
- content_url (text) DEFAULT NULL

- tags (JSON) DEFAULT NULL
- mentions (JSON) DEFAULT NULL

- language VARCHAR(255) DEFAULT NULL
- image_description (TEXT) DEFAULT NULL
- audio_transcription (TEXT) DEFAULT NULL

- sbi DECIMAL(6, 5) DEFAULT 0.00000
- created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP



tags table

- id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
- tag_name VARCHAR(255) NOT NULL










SBI = Shadowban Index