Table zot.site Generated by
SchemaSpy
Legend: SourceForge.net
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
site_url char 255
site_access int 10 0
site_flags int 10 0
site_update datetime 19 0000-00-00 00:00:00
site_pull datetime 19 0000-00-00 00:00:00
site_sync datetime 19 0000-00-00 00:00:00
site_directory char 255
site_register int 10 0
site_sellpage char 255
site_location char 255
site_realm char 255
site_valid smallint 5 0
site_dead smallint 5 0
site_type smallint 5 0
site_project char 255

Table contained 224 rows at fr nov 06 17:11 CET 2015

Indexes:
Column(s) Type Sort Constraint Name
site_url Primary key Asc PRIMARY
site_access Performance Asc site_access
site_dead Performance Asc site_dead
site_directory Performance Asc site_directory
site_flags Performance Asc site_flags
site_project Performance Asc site_project
site_pull Performance Asc site_pull
site_realm Performance Asc site_realm
site_register Performance Asc site_register
site_sellpage Performance Asc site_sellpage
site_type Performance Asc site_type
site_update Performance Asc site_update
site_valid Performance Asc site_valid