SchemaSpy - Table studip30.dokumente

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

dokument_id

varchar

32

range_id

varchar

32

user_id

varchar

32

auth_user_md5.user_id

Implied Constraint R

seminar_id

varchar

32

0

archiv.seminar_id

Implied Constraint R

name

varchar

255

√

null

description

text

65535

filename

varchar

255

mkdate

int

10

0

chdate

int

10

0

filesize

int

10

0

autor_host

varchar

20

downloads

int

10

0

url

varchar

255

opengraphdata.url

Implied Constraint R

protected

tinyint

3

0

priority

smallint unsigned

5

0

author_name

varchar

255

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

Indexes:

Column(s)	Type	Sort	Constraint Name
dokument_id	Primary key	Asc	PRIMARY
chdate	Performance	Asc	chdate
mkdate	Performance	Asc	mkdate
range_id	Performance	Asc	range_id
seminar_id	Performance	Asc	seminar_id
user_id	Performance	Asc	user_id