mint/api-v8/public/db/postgresql/migrations/2021-12-06-185900_sent_prs/up.sql

CREATE TABLE sent_prs 
(
    id SERIAL PRIMARY KEY,
	book_id INTEGER NOT NULL, 
	paragraph INTEGER NOT NULL, 
	word_start INTEGER NOT NULL, 
	word_end INTEGER NOT NULL, 
	channel_uid VARCHAR (36),
	author VARCHAR (40), 
	editor_uid VARCHAR (36), 
	content TEXT, 
	language VARCHAR (16), 
	status INTEGER DEFAULT (1), 
	strlen INTEGER, 
	create_time BIGINT NOT NULL, 
	modify_time BIGINT NOT NULL,
	created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
	updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
);

CREATE INDEX sent_prs_channel_book_para_start_end ON sent_prs (channel_uid,book_id,paragraph,word_start,word_end);