|
id
|
int(11)
|
|
|
|
|
name
|
varchar(100)
|
|
|
|
|
card_type
|
enum
|
-- |
|
all
|
|
width_mm
|
decimal(6,2)
|
|
|
85.60
|
|
height_mm
|
decimal(6,2)
|
|
|
54.00
|
|
orientation
|
enum
|
-- |
|
landscape
|
|
cards_per_row
|
tinyint(4)
|
|
|
2
|
|
cards_per_page
|
tinyint(4)
|
|
|
4
|
|
margin_mm
|
decimal(5,2)
|
|
|
5.00
|
|
gap_mm
|
decimal(5,2)
|
|
|
5.00
|
|
show_photo
|
tinyint(1)
|
|
|
1
|
|
show_barcode
|
tinyint(1)
|
|
|
1
|
|
show_qr
|
tinyint(1)
|
|
|
1
|
|
show_back
|
tinyint(1)
|
|
|
0
|
|
show_natid
|
tinyint(1)
|
|
|
1
|
|
color_primary
|
varchar(20)
|
|
|
#28502d
|
|
color_secondary
|
varchar(20)
|
|
|
#cfa545
|
|
printer_name
|
varchar(100)
|
|
|
|
|
paper_size
|
enum
|
-- |
|
A4
|
|
is_default
|
tinyint(1)
|
|
|
0
|
|
created_by
|
int(11)
|
|
|
|
|
created_at
|
timestamp
|
|
|
current_timestamp()
|
|
font_name_size
|
tinyint(4)
|
|
|
13
|
|
font_natid_size
|
tinyint(4)
|
|
|
11
|
|
font_job_size
|
tinyint(4)
|
|
|
10
|
|
show_website
|
tinyint(1)
|
|
|
1
|
|
website_url
|
varchar(100)
|
|
|
https://cnu.cu.edu.eg
|
|
show_signature
|
tinyint(1)
|
|
|
1
|
|
barcode_height
|
tinyint(4)
|
|
|
45
|
|
photo_height
|
tinyint(4)
|
|
|
64
|
|
qr_size
|
tinyint(4)
|
|
|
58
|
|
card_gradient
|
varchar(200)
|
|
|
linear-gradient(135deg,#28502d 0%,#1e3d22 60%,#cfa545 100%)
|
|
text_color
|
varchar(20)
|
|
|
#000000
|
|
show_natid_label
|
tinyint(1)
|
|
|
1
|
|
website_bottom
|
tinyint(4)
|
|
|
3
|
|
website_font_size
|
tinyint(4)
|
|
|
6
|
|
website_color
|
varchar(30)
|
|
|
#ffffff
|
|
photo_width
|
tinyint(4)
|
|
|
58
|
|
show_dept
|
tinyint(1)
|
|
|
0
|
|
signature_height
|
tinyint(4)
|
|
|
16
|
|
signature_name
|
varchar(100)
|
|
|
أ.د/ محمد العطار
|
|
signature_title
|
varchar(200)
|
|
|
نائب رئيس الجامعة للشئون الأكاديمية
|
|
font_code_size
|
tinyint(4)
|
|
|
6
|
|
border_radius
|
tinyint(4)
|
|
|
14
|
|
logo_size
|
tinyint(4)
|
|
|
30
|
