Table iliasRelease_3_9_x_branch.payment_bill_vendor 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
pobject_id int 10 0
payment_objects.pobject_id Implied Constraint R
payment_prices.pobject_id Implied Constraint R
payment_shopping_cart.pobject_id Implied Constraint R
payment_statistic.pobject_id Implied Constraint R
gender tinyint 3  √  null
firstname char 64  √  null
lastname char 64  √  null
title char 64  √  null
institution char 64  √  null
department char 64  √  null
street char 64  √  null
zipcode char 16  √  null
city char 64  √  null
country char 64  √  null
phone char 32  √  null
fax char 32  √  null
email char 64  √  null
account_number char 32  √  null
bankcode char 32  √  null
iban char 64  √  null
bic char 64  √  null
bankname char 64  √  null

Table contained 0 rows at Fri Dec 13 20:19 CET 2013

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

Close relationships: