database.sql


1
2
3
4
5
6
7
8
9
10
11

CREATE TABLE votes (
  id SERIAL PRIMARY KEY,
  rm VARCHAR(5) NOT NULL,
  name VARCHAR(100) NOT NULL,
  cpf VARCHAR(11) NOT NULL,
  option_voted VARCHAR(50),
  voted_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
  UNIQUE(rm, cpf)
);

CREATE INDEX idx_votes_rm_cpf ON votes(rm, cpf);