| id |
int(11)
|
|
|
|
| title |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| slug |
varchar(180)
|
utf8mb4_unicode_ci
|
|
|
| organizer |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| venue |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| event_date |
date
|
|
|
|
| event_end_date |
date
|
|
|
|
| orientation |
enum('portrait', 'landscape')
|
utf8mb4_unicode_ci
|
|
|
| template_path |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| name_enabled |
tinyint(1)
|
|
|
|
| name_x |
decimal(5,2)
|
|
|
|
| name_y |
decimal(5,2)
|
|
|
|
| name_size |
int(11)
|
|
|
|
| name_color |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| name_font |
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
| name_bold |
tinyint(1)
|
|
|
|
| name_italic |
tinyint(1)
|
|
|
|
| date_enabled |
tinyint(1)
|
|
|
|
| date_x |
decimal(5,2)
|
|
|
|
| date_y |
decimal(5,2)
|
|
|
|
| date_size |
int(11)
|
|
|
|
| date_color |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| date_font |
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
| date_bold |
tinyint(1)
|
|
|
|
| date_italic |
tinyint(1)
|
|
|
|
| serial_enabled |
tinyint(1)
|
|
|
|
| serial_x |
decimal(5,2)
|
|
|
|
| serial_y |
decimal(5,2)
|
|
|
|
| serial_size |
int(11)
|
|
|
|
| serial_color |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| serial_font |
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
| serial_bold |
tinyint(1)
|
|
|
|
| serial_italic |
tinyint(1)
|
|
|
|
| venue_enabled |
tinyint(1)
|
|
|
|
| venue_x |
decimal(5,2)
|
|
|
|
| venue_y |
decimal(5,2)
|
|
|
|
| venue_size |
int(11)
|
|
|
|
| venue_color |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| venue_font |
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
| venue_bold |
tinyint(1)
|
|
|
|
| venue_italic |
tinyint(1)
|
|
|
|
| ic_x |
decimal(5,2)
|
|
|
|
| ic_y |
decimal(5,2)
|
|
|
|
| ic_size |
int(11)
|
|
|
|
| ic_color |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| ic_font |
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
| ic_bold |
tinyint(1)
|
|
|
|
| ic_italic |
tinyint(1)
|
|
|
|
| ic_enabled |
tinyint(1)
|
|
|
|
| org_enabled |
tinyint(1)
|
|
|
|
| org_x |
decimal(5,2)
|
|
|
|
| org_y |
decimal(5,2)
|
|
|
|
| org_size |
int(11)
|
|
|
|
| org_color |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| org_font |
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
| org_bold |
tinyint(1)
|
|
|
|
| org_italic |
tinyint(1)
|
|
|
|
| program_color |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| program_bold |
tinyint(1)
|
|
|
|
| program_italic |
tinyint(1)
|
|
|
|
| program_enabled |
tinyint(1)
|
|
|
|
| program_title_mode |
enum('text', 'image')
|
utf8mb4_unicode_ci
|
|
|
| program_image_path |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| program_image_width |
int(11)
|
|
|
|
| program_image_height |
int(11)
|
|
|
|
| program_image_scale |
int(11)
|
|
|
|
| qr_enabled |
tinyint(1)
|
|
|
|
| form_ic_required |
tinyint(1)
|
|
|
|
| form_phone_required |
tinyint(1)
|
|
|
|
| form_email_required |
tinyint(1)
|
|
|
|
| form_org_required |
tinyint(1)
|
|
|
|
| qr_x |
decimal(5,2)
|
|
|
|
| qr_y |
decimal(5,2)
|
|
|
|
| qr_size |
int(11)
|
|
|
|
| status |
enum('active', 'closed')
|
utf8mb4_unicode_ci
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|