Table iliasRelease_3_10_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  √ 
usr_id bigint 19 0
pc_title varchar 255
pc_description text 65535
pc_type enum 7 fix
pc_value decimal 10,2 0.00
pc_from date 10 0000-00-00
pc_till date 10 0000-00-00
pc_from_enabled bit 0 0
pc_till_enabled bit 0 0
pc_uses int 10 0
pc_last_change_usr_id bigint 19 0
pc_last_changed datetime 19 0000-00-00 00:00:00

Table contained 0 rows at Tue Aug 26 10:32 CEST 2014

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