Mysql doubt in fk null (Blank candidate election)

Asked

Viewed 36 times

1

I’m doing a voting system and I need you to take blank votes what is the best option to do this? agree to pass a null value in the cd_candidate column?

inserir a descrição da imagem aqui

I can’t create a blank candidate in the candidate table

reason: they will have a lot of category and each category will have the white option the system picks the candidates of the category chosen by the voter

I could take a blank vote table and feed it in place of tb_votes but that would change everything in the count of votes by category.

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.