SchemaSpy - Table studip30.his_abstgv

Generated by
SchemaSpy

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

ktxt

varchar

50

√

null

dtxt

varchar

50

√

null

ltxt

varchar

100

√

null

fb

char

2

√

null

kzfa

char

1

kzfaarray

char

3

√

null

abschl

char

2

stg

char

3

his_stg.stg

Implied Constraint R

pversion

int

10

0

regelstz

tinyint

3

√

null

login_part

char

2

√

null

studip_studiengang

varchar

32

Table contained 0 rows at Do Aug 02 15:05 GMT+01:00 2018

Indexes:

Column(s)	Type	Sort	Constraint Name
abschl + stg + kzfa + pversion	Primary key	Asc/Asc/Asc/Asc	PRIMARY
studip_studiengang	Performance	Asc	studip_studiengang