HCPLANOHIST

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDPLANO int 4 null
HCPLANOITEM.IDPLANO FKHCPLANOHIST_HCPLANOITEMR
IDPLANOITEM int 4 null
HCPLANOITEM.IDPLANOITEM FKHCPLANOHIST_HCPLANOITEMR
IDPLANOHIST int 4 null
TABLESTAGE varchar 3 √ null
LOG MEMO 2147483647 √ null
STATUS smallint 2 null
PERIODOINICIAL DDATETIME 16,3 √ null
PERIODOFINAL DDATETIME 16,3 √ null
DTINICIALEXEC DDATETIME 16,3 √ null
DTFINALEXEC DDATETIME 16,3 √ 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)
PKHCPLANOHIST Primary key Asc/Asc/Asc IDPLANO + IDPLANOITEM + IDPLANOHIST

Relationships

Close relationships within degrees of separation