75 lines
3.2 KiB
Markdown
75 lines
3.2 KiB
Markdown
|
# 小红书数据库表结构
|
||
|
|
|
||
|
|
## xhs_notes
|
||
|
|
```sql
|
||
|
|
CREATE TABLE `xhs_notes` (
|
||
|
|
`id` INT NOT NULL AUTO_INCREMENT,
|
||
|
|
`note_id` VARCHAR(50) NOT NULL COLLATE 'utf8mb4_unicode_ci',
|
||
|
|
`type` VARCHAR(20) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
|
||
|
|
`title` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
|
||
|
|
`description` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
|
||
|
|
`video_url` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
|
||
|
|
`time` BIGINT NULL DEFAULT NULL,
|
||
|
|
`last_update_time` BIGINT NULL DEFAULT NULL,
|
||
|
|
`user_id` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
|
||
|
|
`nickname` VARCHAR(100) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
|
||
|
|
`avatar` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
|
||
|
|
`liked_count` VARCHAR(20) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
|
||
|
|
`collected_count` VARCHAR(20) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
|
||
|
|
`comment_count` VARCHAR(20) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
|
||
|
|
`share_count` VARCHAR(20) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
|
||
|
|
`ip_location` VARCHAR(100) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
|
||
|
|
`image_list` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
|
||
|
|
`tag_list` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
|
||
|
|
`last_modify_ts` BIGINT NULL DEFAULT NULL,
|
||
|
|
`note_url` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
|
||
|
|
`source_keyword` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
|
||
|
|
`created_at` TIMESTAMP NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
`download_flag` TINYINT NULL DEFAULT '0',
|
||
|
|
`sheet_name` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
|
||
|
|
PRIMARY KEY (`id`) USING BTREE,
|
||
|
|
UNIQUE INDEX `note_id` (`note_id`) USING BTREE
|
||
|
|
)
|
||
|
|
```
|
||
|
|
|
||
|
|
## clean_note_store
|
||
|
|
```sql
|
||
|
|
CREATE TABLE `clean_note_store` (
|
||
|
|
`id` INT NOT NULL AUTO_INCREMENT,
|
||
|
|
`note_id` INT NULL DEFAULT NULL,
|
||
|
|
`content_type` ENUM('guide','mindmap','summary') NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
|
||
|
|
`content` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
|
||
|
|
`content_hash` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
|
||
|
|
`vector_id` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
|
||
|
|
`recall_times` INT NULL DEFAULT '0',
|
||
|
|
`created_at` TIMESTAMP NULL DEFAULT (CURRENT_TIMESTAMP),
|
||
|
|
PRIMARY KEY (`id`) USING BTREE,
|
||
|
|
INDEX `idx_note_id` (`note_id`) USING BTREE,
|
||
|
|
INDEX `idx_content_hash` (`content_hash`) USING BTREE,
|
||
|
|
INDEX `idx_content_type` (`content_type`) USING BTREE,
|
||
|
|
CONSTRAINT `fk_clean_note_store_note_id` FOREIGN KEY (`note_id`) REFERENCES `xhs_notes` (`id`) ON UPDATE NO ACTION ON DELETE NO ACTION
|
||
|
|
)
|
||
|
|
COLLATE='utf8mb4_unicode_ci'
|
||
|
|
ENGINE=InnoDB
|
||
|
|
AUTO_INCREMENT=1453
|
||
|
|
;
|
||
|
|
```
|
||
|
|
|
||
|
|
## vector_store
|
||
|
|
```sql
|
||
|
|
CREATE TABLE `vector_store` (
|
||
|
|
`id` INT NOT NULL AUTO_INCREMENT,
|
||
|
|
`note_id` INT NULL DEFAULT NULL,
|
||
|
|
`vector_id` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
|
||
|
|
`content` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
|
||
|
|
`recall_times` INT NULL DEFAULT NULL,
|
||
|
|
`content_hash` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
|
||
|
|
PRIMARY KEY (`id`) USING BTREE,
|
||
|
|
INDEX `idx_note_id` (`note_id`) USING BTREE,
|
||
|
|
CONSTRAINT `fk_note_id` FOREIGN KEY (`note_id`) REFERENCES `xhs_notes` (`id`) ON UPDATE NO ACTION ON DELETE NO ACTION
|
||
|
|
)
|
||
|
|
COLLATE='utf8mb4_unicode_ci'
|
||
|
|
ENGINE=InnoDB
|
||
|
|
AUTO_INCREMENT=2591
|
||
|
|
;
|
||
|
|
```
|