Table d47civi_0z3xa.civicrm_timezone 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
id int unsigned 10  √  Timezone Id
name varchar 64  √  null Timezone full name
abbreviation char 3  √  null ISO Code for timezone abbreviation
gmt varchar 64  √  null GMT name of the timezone
offset int 10  √  null
country_id int unsigned 10
civicrm_country.id FK_civicrm_timezone_country_id R
Country Id

Table contained 0 rows at mer. avr. 13 16:52 EDT 2016

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
country_id Performance Asc FK_civicrm_timezone_country_id

Close relationships  within of separation: