Table iliasRelease_4_1_x_branch.payment_coupons 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
pc_pk bigint 19 0
usr_id int 10 0
pc_title varchar 255  √  null
pc_description varchar 4000  √  null
pc_type char 8  √  fix
pc_value double 22 0
pc_from date 10  √  null
pc_till date 10  √  null
pc_from_enabled tinyint 3 0
pc_till_enabled tinyint 3 0
pc_uses int 10 0
pc_last_change_usr_id int 10 0
pc_last_changed datetime 19  √  null

Table contained 0 rows at Thu Apr 21 21:00 CEST 2016

Indexes:
Column(s) Type Sort Constraint Name
pc_pk Primary key Asc PRIMARY
usr_id Performance Asc i1_idx