1 files changed, 11 insertions, 0 deletions
diff --git a/database.sql b/database.sql
new file mode 100644
index 0000000..78b23cf
--- /dev/null
+++ b/database.sql
@@ -0,0 +1,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);
+\ No newline at end of file