diff options
| author | zwlucas <lucas.oliveira1676@etec.sp.gov.br> | 2025-04-01 17:30:52 +0000 |
|---|---|---|
| committer | zwlucas <lucas.oliveira1676@etec.sp.gov.br> | 2025-04-01 17:30:52 +0000 |
| commit | a7a6e965979f7c46c2511a33cb601172573f3c84 (patch) | |
| tree | fafef5889ca77346cdcbd1c4a3db9cc34268c82f /database.sql | |
| parent | e99de28b064275cdd0b04b98c6c3f50e85c01d7c (diff) | |
| download | eleicoes-a7a6e965979f7c46c2511a33cb601172573f3c84.tar.gz eleicoes-a7a6e965979f7c46c2511a33cb601172573f3c84.zip | |
removed cpf
Diffstat (limited to 'database.sql')
| -rw-r--r-- | database.sql | 10 |
1 files changed, 4 insertions, 6 deletions
diff --git a/database.sql b/database.sql index 78b23cf..226fa2f 100644 --- a/database.sql +++ b/database.sql @@ -1,11 +1,9 @@ CREATE TABLE votes ( - id SERIAL PRIMARY KEY, - rm VARCHAR(5) NOT NULL, + rm VARCHAR(5) PRIMARY KEY, name VARCHAR(100) NOT NULL, - cpf VARCHAR(11) NOT NULL, - option_voted VARCHAR(50), + option VARCHAR(50), voted_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(), - UNIQUE(rm, cpf) + UNIQUE(rm, name) ); -CREATE INDEX idx_votes_rm_cpf ON votes(rm, cpf);
\ No newline at end of file +CREATE INDEX idx_votes_rm_name ON votes(rm, name);
\ No newline at end of file |