MTRFSMARTCODE

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
MTAREFA.CODCOLIGADA FKMTRFSMARTCODE_MTRFR
IDPRJ int 4 null
MTAREFA.IDPRJ FKMTRFSMARTCODE_MTRFR
IDTRF int 4 null
MTAREFA.IDTRF FKMTRFSMARTCODE_MTRFR
SMARTCODEVALOR1 decimal 23,4 √ null
SMARTCODEVALOR2 decimal 23,4 √ null
SMARTCODEVALOR3 decimal 23,4 √ null
SMARTCODEVALOR4 decimal 23,4 √ null
SMARTCODEVALOR5 decimal 23,4 √ null
SMARTCODEVALOR6 decimal 23,4 √ null
SMARTCODEVALOR7 decimal 23,4 √ null
SMARTCODEVALOR8 decimal 23,4 √ null
SMARTCODEVALOR9 decimal 23,4 √ null
SMARTCODEVALOR10 decimal 23,4 √ null
SMARTCODEVALOR11 decimal 23,4 √ null
SMARTCODEVALOR12 decimal 23,4 √ null
SMARTCODEVALOR13 decimal 23,4 √ null
SMARTCODEVALOR14 decimal 23,4 √ null
SMARTCODEVALOR15 decimal 23,4 √ null
SMARTCODEVALOR16 decimal 23,4 √ null
SMARTCODEVALOR17 decimal 23,4 √ null
SMARTCODEVALOR18 decimal 23,4 √ null
SMARTCODEVALOR19 decimal 23,4 √ null
SMARTCODEVALOR20 decimal 23,4 √ null
SMARTCODEVALOR21 decimal 23,4 √ null
SMARTCODEVALOR22 decimal 23,4 √ null
SMARTCODEVALOR23 decimal 23,4 √ null
SMARTCODEVALOR24 decimal 23,4 √ null
SMARTCODEVALOR25 decimal 23,4 √ null
SMARTCODEVALOR26 decimal 23,4 √ null
SMARTCODEVALOR27 decimal 23,4 √ null
SMARTCODEVALOR28 decimal 23,4 √ null
SMARTCODEVALOR29 decimal 23,4 √ null
SMARTCODEVALOR30 decimal 23,4 √ null
SMARTCODEDATE1 datetime 16,3 √ null
SMARTCODEDATE2 datetime 16,3 √ null
SMARTCODEDATE3 datetime 16,3 √ null
SMARTCODEDATE4 datetime 16,3 √ null
SMARTCODEDATE5 datetime 16,3 √ null
SMARTCODEDATE6 datetime 16,3 √ null
SMARTCODEDATE7 datetime 16,3 √ null
SMARTCODEDATE8 datetime 16,3 √ null
SMARTCODEDATE9 datetime 16,3 √ null
SMARTCODEDATE10 datetime 16,3 √ null
SMARTCODEDATE11 datetime 16,3 √ null
SMARTCODEDATE12 datetime 16,3 √ null
SMARTCODEDATE13 datetime 16,3 √ null
SMARTCODEDATE14 datetime 16,3 √ null
SMARTCODEDATE15 datetime 16,3 √ null
SMARTCODEDATE16 datetime 16,3 √ null
SMARTCODEDATE17 datetime 16,3 √ null
SMARTCODEDATE18 datetime 16,3 √ null
SMARTCODEDATE19 datetime 16,3 √ null
SMARTCODEDATE20 datetime 16,3 √ null
SMARTCODETEXTO1 varchar 255 √ null
SMARTCODETEXTO2 varchar 255 √ null
SMARTCODETEXTO3 varchar 255 √ null
SMARTCODETEXTO4 varchar 255 √ null
SMARTCODETEXTO5 varchar 255 √ null
SMARTCODETEXTO6 varchar 255 √ null
SMARTCODETEXTO7 varchar 255 √ null
SMARTCODETEXTO8 varchar 255 √ null
SMARTCODETEXTO9 varchar 255 √ null
SMARTCODETEXTO10 varchar 255 √ null
SMARTCODETEXTO11 varchar 255 √ null
SMARTCODETEXTO12 varchar 255 √ null
SMARTCODETEXTO13 varchar 255 √ null
SMARTCODETEXTO14 varchar 255 √ null
SMARTCODETEXTO15 varchar 255 √ null
SMARTCODETEXTO16 varchar 255 √ null
SMARTCODETEXTO17 varchar 255 √ null
SMARTCODETEXTO18 varchar 255 √ null
SMARTCODETEXTO19 varchar 255 √ null
SMARTCODETEXTO20 varchar 255 √ null
SMARTCODETEXTO21 varchar 255 √ null
SMARTCODETEXTO22 varchar 255 √ null
SMARTCODETEXTO23 varchar 255 √ null
SMARTCODETEXTO24 varchar 255 √ null
SMARTCODETEXTO25 varchar 255 √ null
SMARTCODETEXTO26 varchar 255 √ null
SMARTCODETEXTO27 varchar 255 √ null
SMARTCODETEXTO28 varchar 255 √ null
SMARTCODETEXTO29 varchar 255 √ null
SMARTCODETEXTO30 varchar 255 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
PKMTRFSMARTCODE Primary key Asc/Asc/Asc CODCOLIGADA + IDPRJ + IDTRF

Relationships

Close relationships within degrees of separation