diff options
| author | zwlucas <lucas.oliveira1676@etec.sp.gov.br> | 2025-04-01 02:34:04 +0000 |
|---|---|---|
| committer | zwlucas <lucas.oliveira1676@etec.sp.gov.br> | 2025-04-01 02:34:04 +0000 |
| commit | 79670b4c51ebbdd242b894a5f0678618054cc2ef (patch) | |
| tree | 654b351c13016b7d83137409b56031110cb46628 /database.sql | |
| parent | 0d54368efc5e91bf1beea8961655fa77f51b3074 (diff) | |
| download | eleicoes-79670b4c51ebbdd242b894a5f0678618054cc2ef.tar.gz eleicoes-79670b4c51ebbdd242b894a5f0678618054cc2ef.zip | |
create eletrocast-eleicoes
Diffstat (limited to 'database.sql')
| -rw-r--r-- | database.sql | 11 |
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 |