Scribd
Upload
20 views2 pages

GDIC

The document outlines the schema for a database table, detailing the column names, data types, lengths, and nullability constraints. It includes various data types such as varchar, smallint, and bit, along with collation information. Key columns include identifiers for different countries and actions, as well as timestamps for record creation and modification.

Uploaded by

João Santos
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
20 views2 pages

GDIC

The document outlines the schema for a database table, detailing the column names, data types, lengths, and nullability constraints. It includes various data types such as varchar, smallint, and bit, along with collation information. Key columns include identifiers for different countries and actions, as well as timestamps for record creation and modification.

Uploaded by

João Santos
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Column_n Type Computed Length Prec Scale Nullable TrimTrailinFixedLenNuCollation

TABELA varchar no 30 no no no Latin1_General_CI_AS


COLUNA varchar no 30 no no no Latin1_General_CI_AS
DESCRICAOvarchar no 150 yes no yes Latin1_General_CI_AS
RELATORIOsmallint no 2 5 0 yes (n/a) (n/a) NULL
APLICACOEvarchar no 100 yes no yes Latin1_General_CI_AS
PORTUGALvarchar no 40 yes no yes Latin1_General_CI_AS
RELPTG smallint no 2 5 0 yes (n/a) (n/a) NULL
MEXICO varchar no 40 yes no yes Latin1_General_CI_AS
RELMEX smallint no 2 5 0 yes (n/a) (n/a) NULL
CONSULTADLOGICONno 2 5 0 yes (n/a) (n/a) NULL
PODECONSDLOGICONno 2 5 0 yes (n/a) (n/a) NULL
ACTION varchar no 120 yes yes yes Latin1_General_CI_AS
ACTIONKEYvarchar no 255 yes yes yes Latin1_General_CI_AS
ACTIONSEAvarchar no 255 yes yes yes Latin1_General_CI_AS
SECCOLNAvarchar no 120 yes yes yes Latin1_General_CI_AS
SECCOLIG varchar no 120 yes yes yes Latin1_General_CI_AS
STATUS bit no 1 yes (n/a) (n/a) NULL
RECCREAT varchar no 50 yes yes yes Latin1_General_CI_AS
RECCREAT datetime no 8 yes (n/a) (n/a) NULL
RECMODIFvarchar no 50 yes yes yes Latin1_General_CI_AS
RECMODIFdatetime no 8 yes (n/a) (n/a) NULL
APINAME nvarchar no 240 yes (n/a) (n/a) Latin1_General_CI_AS
ANONIMIZbit no 1 no (n/a) (n/a) NULL
CODCLASSIsmallint no 2 5 0 no (n/a) (n/a) NULL
PESSOAL bit no 1 no (n/a) (n/a) NULL
SENSIVEL bit no 1 no (n/a) (n/a) NULL
CODCLASS smallint no 2 5 0 no (n/a) (n/a) NULL
ral_CI_AS
ral_CI_AS
ral_CI_AS

ral_CI_AS
ral_CI_AS

ral_CI_AS

ral_CI_AS
ral_CI_AS
ral_CI_AS
ral_CI_AS
ral_CI_AS

ral_CI_AS

ral_CI_AS

ral_CI_AS

You might also like