Table zot.channel 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
channel_id int unsigned 10  √ 
likes.channel_id Implied Constraint R
mail.channel_id Implied Constraint R
profext.channel_id Implied Constraint R
channel_account_id int unsigned 10 0
channel_primary bit 0 0
channel_name char 255
channel_address char 255
channel_guid char 255
channel_guid_sig text 65535
channel_hash char 255
channel_timezone char 128 UTC
channel_location char 255
channel_theme char 255
channel_startpage char 255
channel_pubkey text 65535
channel_prvkey text 65535
channel_notifyflags int unsigned 10 65535
channel_pageflags int unsigned 10 0
channel_dirdate datetime 19 0000-00-00 00:00:00
channel_lastpost datetime 19 0000-00-00 00:00:00
channel_deleted datetime 19 0000-00-00 00:00:00
channel_max_anon_mail int unsigned 10 10
channel_max_friend_req int unsigned 10 10
channel_expire_days int 10 0
channel_passwd_reset char 255
channel_default_group char 255
channel_allow_cid mediumtext 16777215
channel_allow_gid mediumtext 16777215
channel_deny_cid mediumtext 16777215
channel_deny_gid mediumtext 16777215
channel_r_stream int unsigned 10 0
channel_r_profile int unsigned 10 0
channel_r_photos int unsigned 10 0
channel_r_abook int unsigned 10 0
channel_w_stream int unsigned 10 0
channel_w_wall int unsigned 10 0
channel_w_tagwall int unsigned 10 0
channel_w_comment int unsigned 10 0
channel_w_mail int unsigned 10 0
channel_w_photos int unsigned 10 0
channel_w_chat int unsigned 10 0
channel_a_delegate int unsigned 10 0
channel_r_storage int unsigned 10 0
channel_w_storage int unsigned 10 0
channel_r_pages int unsigned 10 0
channel_w_pages int unsigned 10 0
channel_a_republish int unsigned 10 0
channel_w_like int unsigned 10 0
channel_removed bit 0 0
channel_system bit 0 0

Table contained 5 rows at on aug 19 21:08 CEST 2015

Indexes:
Column(s) Type Sort Constraint Name
channel_id Primary key Asc PRIMARY
channel_a_delegate Performance Asc channel_a_delegate
channel_a_republish Performance Asc channel_a_republish
channel_account_id Performance Asc channel_account_id
channel_address Must be unique Asc channel_address_unique
channel_default_group Performance Asc channel_default_gid
channel_deleted Performance Asc channel_deleted
channel_dirdate Performance Asc channel_dirdate
channel_expire_days Performance Asc channel_expire_days
channel_guid Performance Asc channel_guid
channel_hash Performance Asc channel_hash
channel_lastpost Performance Asc channel_lastpost
channel_location Performance Asc channel_location
channel_max_anon_mail Performance Asc channel_max_anon_mail
channel_max_friend_req Performance Asc channel_max_friend_req
channel_name Performance Asc channel_name
channel_notifyflags Performance Asc channel_notifyflags
channel_pageflags Performance Asc channel_pageflags
channel_primary Performance Asc channel_primary
channel_r_abook Performance Asc channel_r_abook
channel_r_pages Performance Asc channel_r_pages
channel_r_photos Performance Asc channel_r_photos
channel_r_profile Performance Asc channel_r_profile
channel_r_storage Performance Asc channel_r_storage
channel_r_stream Performance Asc channel_r_stream
channel_removed Performance Asc channel_removed
channel_system Performance Asc channel_system
channel_theme Performance Asc channel_theme
channel_timezone Performance Asc channel_timezone
channel_w_chat Performance Asc channel_w_chat
channel_w_comment Performance Asc channel_w_comment
channel_w_like Performance Asc channel_w_like
channel_w_mail Performance Asc channel_w_mail
channel_w_pages Performance Asc channel_w_pages
channel_w_photos Performance Asc channel_w_photos
channel_w_storage Performance Asc channel_w_storage
channel_w_stream Performance Asc channel_w_stream
channel_w_tagwall Performance Asc channel_w_tagwall
channel_w_wall Performance Asc channel_w_wall

Close relationships: