BAREA

14 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
BAREAIDIOMA.CODCOLIGADA FKBAREAIDIOMA_BAREAR
BMATERIA.CODCOLIGADA FKBMATERIA_BAREAR
BREQUISITAAREA.CODCOLIGADA FKBREQUISITAAREA_BAREAR
VCONTROLESISTEMA.CODCOLIGADA FKVCONTROLESISTEMA_BAREAR
GCOLIGADA.CODCOLIGADA FKBAREA_GCOLIGADAR
CODAREA varchar 16 null
BAREAIDIOMA.CODAREA FKBAREAIDIOMA_BAREAR
BMATERIA.CODAREA FKBMATERIA_BAREAR
BREQUISITAAREA.CODAREA FKBREQUISITAAREA_BAREAR
VCONTROLESISTEMA.CODAREA FKVCONTROLESISTEMA_BAREAR
NOME varchar 65 √ null
DESCRICAO varchar 255 √ null
ID int identity 4 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
CODIDIOMA int 4 √ null
BIDIOMAS.CODIGO FKBAREA_BIDIOMASR

Indexes

Constraint Name Type Sort Column(s)
PKBAREA Primary key Asc/Asc CODCOLIGADA + CODAREA
BXAREAID Must be unique Asc ID

Relationships

Close relationships within degrees of separation