SchemaSpy - Table iliasRelease_4_2_x_branch.payment

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column	Type	Size	Nulls	Default
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	double	22		0
discount	double	22		0
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
currency_unit	varchar	16	√	null
email_extern	varchar	80	√	null
name_extern	varchar	80	√	null
access_enddate	datetime	19	√	null
access_startdate	datetime	19	√	null

Table contained 0 rows at Fri Apr 22 21:41 CEST 2016

Indexes:

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