| id |
int(11)
|
|
|
|
| name |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| card_type |
enum('employee', 'academic', 'all')
|
utf8mb4_unicode_ci
|
|
|
| width_mm |
decimal(6,2)
|
|
|
|
| height_mm |
decimal(6,2)
|
|
|
|
| orientation |
enum('landscape', 'portrait')
|
utf8mb4_unicode_ci
|
|
|
| cards_per_row |
tinyint(4)
|
|
|
|
| cards_per_page |
tinyint(4)
|
|
|
|
| margin_mm |
decimal(5,2)
|
|
|
|
| gap_mm |
decimal(5,2)
|
|
|
|
| show_photo |
tinyint(1)
|
|
|
|
| show_barcode |
tinyint(1)
|
|
|
|
| show_qr |
tinyint(1)
|
|
|
|
| show_back |
tinyint(1)
|
|
|
|
| show_natid |
tinyint(1)
|
|
|
|
| color_primary |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| color_secondary |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| printer_name |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| paper_size |
enum('A4', 'A5', 'Letter', 'Custom')
|
utf8mb4_unicode_ci
|
|
|
| is_default |
tinyint(1)
|
|
|
|
| created_by |
int(11)
|
|
|
|
| created_at |
timestamp
|
|
|
|
| font_name_size |
tinyint(4)
|
|
|
|
| font_natid_size |
tinyint(4)
|
|
|
|
| font_job_size |
tinyint(4)
|
|
|
|
| show_website |
tinyint(1)
|
|
|
|
| website_url |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| show_signature |
tinyint(1)
|
|
|
|
| barcode_height |
tinyint(4)
|
|
|
|
| photo_height |
tinyint(4)
|
|
|
|
| qr_size |
tinyint(4)
|
|
|
|
| card_gradient |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| text_color |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| show_natid_label |
tinyint(1)
|
|
|
|
| website_bottom |
tinyint(4)
|
|
|
|
| website_font_size |
tinyint(4)
|
|
|
|
| website_color |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| photo_width |
tinyint(4)
|
|
|
|
| show_dept |
tinyint(1)
|
|
|
|
| signature_height |
tinyint(4)
|
|
|
|
| signature_name |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| signature_title |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| font_code_size |
tinyint(4)
|
|
|
|
| border_radius |
tinyint(4)
|
|
|
|
| logo_size |
tinyint(4)
|
|
|
|
