Table zooqini_checkin_dev.business 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
bid int 10  √ 
business_images.bid Implied Constraint R
business_payment.bid Implied Constraint R
business_urls.bid Implied Constraint R
group_types.bid Implied Constraint R
offline_checkin.bid Implied Constraint R
store_mapping.bid Implied Constraint R
bname text 65535
description text 65535
interest varchar 255
address_id int 10
phone varchar 14
logo int 10
owner int 10
timestamp timestamp 19 CURRENT_TIMESTAMP
active enum 2 Y

Table contained 6 rows at Thu Sep 13 12:16 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
bid Primary key Asc PRIMARY
bid Performance Asc bid


SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz version 2.2.1 or versions greater than 2.4 from www.graphviz.org.