VELEICAO

11 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
VCANDIDATOSCIPA.CODCOLIGADA FKVCANDIDATOSCIPA_VELEICAOR
VELEICAOSEC.CODCOLIGADA FKVELEICAOSEC_VELEICAOR
VELEICAOVOTOMANUAL.CODCOLIGADA FKVELEICAOVOTOMANUAL_VELEICAOR
VRESPOSTACANDIDATURACIPA.CODCOLIGADA FKVRESPCANDIDATCIPA_VELEICAOR
VVOTACAOCIPA.CODCOLIGADA FKVVOTACAOCIPA_VELEICAOR
VCOMISSAO.CODCOLIGADA FKVELEICAO_VCOMISSAOR
CODCOMISSAO varchar 10 null
VCANDIDATOSCIPA.CODCOMISSAO FKVCANDIDATOSCIPA_VELEICAOR
VELEICAOSEC.CODCOMISSAO FKVELEICAOSEC_VELEICAOR
VELEICAOVOTOMANUAL.CODCOMISSAO FKVELEICAOVOTOMANUAL_VELEICAOR
VRESPOSTACANDIDATURACIPA.CODCOMISSAO FKVRESPCANDIDATCIPA_VELEICAOR
VVOTACAOCIPA.CODCOMISSAO FKVVOTACAOCIPA_VELEICAOR
VCOMISSAO.CODCOMISSAO FKVELEICAO_VCOMISSAOR
CODELEICAO varchar 10 null
VCANDIDATOSCIPA.CODELEICAO FKVCANDIDATOSCIPA_VELEICAOR
VELEICAOSEC.CODELEICAO FKVELEICAOSEC_VELEICAOR
VELEICAOVOTOMANUAL.CODELEICAO FKVELEICAOVOTOMANUAL_VELEICAOR
VRESPOSTACANDIDATURACIPA.CODELEICAO FKVRESPCANDIDATCIPA_VELEICAOR
VVOTACAOCIPA.CODELEICAO FKVVOTACAOCIPA_VELEICAOR
DATAHORA datetime 16,3 √ null
LOCAL varchar 40 √ null
ATA MEMO 2147483647 √ null
DATAHORAFIM datetime 16,3 √ null
CANDIDATURAPORTAL DLOGICO 2 √ (0)
DATAINICIOCAND datetime 16,3 √ null
DATAFIMCAND datetime 16,3 √ null
ELEICAOPORTAL DLOGICO 2 √ (0)
FINALIZADA DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
CANCELADA DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
JUSTIFICATIVACANCELAMENTO MEMO 2147483647 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
PERMITEVOTOMULTIPLOVINCULO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0

Indexes

Constraint Name Type Sort Column(s)
PKVELEICAO Primary key Asc/Asc/Asc CODCOLIGADA + CODCOMISSAO + CODELEICAO

Relationships

Close relationships within degrees of separation