<div class="posts"> <PostCard v-for="p in posts" :key="p.id" :post="p" @react="handleReact" @vote="handleVote"/> </div>
-- Votes (daily) CREATE TABLE votes ( post_id BIGINT REFERENCES posts(id), user_id BIGINT REFERENCES users(vk_id), vote_date DATE, PRIMARY KEY (user_id, vote_date) ); nevernight vk
-- Posts CREATE TABLE posts ( id BIGSERIAL PRIMARY KEY, user_id BIGINT REFERENCES users(vk_id), type TEXT CHECK (type IN ('photo','video','text')), media_url TEXT, text_body TEXT, created_at TIMESTAMP DEFAULT now(), theme_id BIGINT REFERENCES themes(id) ); user_id BIGINT REFERENCES users(vk_id)
