Table tariqa3.ajax_call_urls 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
call_id int unsigned 10
ajax_calls.call_id fk_ajax_call_urls_ajax_calls C
Id of the Ajax Call
url_id smallint unsigned 5 Id of the URL in the current multi-call
url varchar 2048
post_fields longtext 2147483647  √  null the full data to post in an HTTP POST operation. You must make sure that the data is formatted the way you want the server to receive it
http_code smallint unsigned 5  √  null HTTP return code once the URL has been retrieved
call_content longblob 2147483647  √  null Data returned by the URL
call_content_length int unsigned 10  √  null Length of the data
call_content_type varchar 255  √  application/binary
call_header text 65535  √  null HTTP Header of the document at the given URL
call_error text 65535  √  null Error data or NULL
duration float 12  √  null Duration in seconds of the download
last_update datetime 19  √  null Date/time at which the URL process was ended
method enum 4 get Only GET is implemented at the moment
use_proxy enum 4 no If set to yes, uses the HTTP Proxy

Analyzed at Wed Apr 25 13:30 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
call_id + url_id Primary key Asc/Asc PRIMARY
call_content_length Performance Asc idx_content_length
call_content_type Performance Asc idx_content_type
duration Performance Asc idx_durations
method Performance Asc idx_method

Close relationships  within of separation: