Table iliasRelease_4_0_x_branch.payment_statistic 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
booking_id int 10 0
transaction char 64  √  null
pobject_id int 10 0
customer_id int 10 0
b_vendor_id int 10  √  null
b_pay_method int 10  √  null
order_date int 10  √  null
duration char 16  √  null
price char 16  √  null
discount char 16  √  null
payed int 10 0
access_granted int 10 0
voucher char 64  √  null
transaction_extern char 64  √  null
street varchar 40  √  null
po_box varchar 40  √  null
zipcode varchar 40  √  null
city varchar 40  √  null
country varchar 40  √  null
vat_rate double 22 0
vat_unit double 22 0
object_title varchar 128  √  null

Table contained 0 rows at Wed Apr 27 19:42 CEST 2016

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