Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: hmis »Table: employee_masters
Page-related settingsClick on the bar to scroll to top of page
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count: Time taken:
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
xxxxxxxxxx
 
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database: Queried time:

Table structure

Settings for the table structure (list of columns).

Documentation Whether the table structure actions should be hidden.
# Name Type Collation Attributes Null Default Extra Action
1 int(6) No None AUTO_INCREMENT
2 varchar(6) latin1_swedish_ci Yes NULL
3 varchar(20) latin1_swedish_ci Yes NULL
4 varchar(30) latin1_swedish_ci Yes NULL
5 date Yes NULL
6 varchar(20) latin1_swedish_ci Yes NULL
7 varchar(10) latin1_swedish_ci Yes NULL
8 varchar(4) latin1_swedish_ci Yes NULL
9 varchar(2) latin1_swedish_ci Yes NULL
10 varchar(2) latin1_swedish_ci Yes NULL
11 varchar(6) latin1_swedish_ci Yes NULL
12 date Yes NULL
13 varchar(2) latin1_swedish_ci Yes NULL
14 date Yes NULL
15 varchar(30) latin1_swedish_ci Yes NULL
16 varchar(20) latin1_swedish_ci Yes NULL
17 varchar(15) latin1_swedish_ci Yes NULL
18 varchar(20) latin1_swedish_ci Yes NULL
19 varchar(10) latin1_swedish_ci Yes NULL
20 int(6) Yes NULL
21 varchar(6) latin1_swedish_ci Yes NULL
22 varchar(50) latin1_swedish_ci Yes NULL
23 varchar(6) latin1_swedish_ci Yes NULL
24 varchar(6) latin1_swedish_ci Yes NULL
25 varchar(6) latin1_swedish_ci Yes NULL
26 varchar(50) latin1_swedish_ci Yes NULL
27 varchar(20) latin1_swedish_ci Yes NULL
28 varchar(20) latin1_swedish_ci Yes NULL
29 varchar(20) latin1_swedish_ci Yes NULL
30 varchar(20) latin1_swedish_ci Yes NULL
31 varchar(20) latin1_swedish_ci Yes NULL
32 varchar(20) latin1_swedish_ci Yes NULL
33 varchar(20) latin1_swedish_ci Yes NULL
34 int(6) Yes NULL
35 varchar(30) latin1_swedish_ci Yes NULL
36 varchar(15) latin1_swedish_ci Yes NULL
37 varchar(15) latin1_swedish_ci Yes NULL
38 varchar(15) latin1_swedish_ci Yes NULL
39 varchar(15) latin1_swedish_ci Yes NULL
40 varchar(15) latin1_swedish_ci Yes NULL
41 varchar(15) latin1_swedish_ci Yes NULL
42 timestamp No CURRENT_TIMESTAMP
43 int(6) Yes NULL
44 timestamp No 0000-00-00 00:00:00
45 int(6) Yes NULL
46 enum('yes', 'no') latin1_swedish_ci No no
47 float(10,2) Yes NULL
48 float(10,2) Yes NULL
49 enum('yes', 'no') latin1_swedish_ci Yes no
50 float(10,2) Yes NULL
51 float(10,2) Yes NULL
52 enum('no', 'yes') latin1_swedish_ci Yes no
53 int(11) Yes NULL
54 enum('no', 'yes') latin1_swedish_ci Yes no
55 enum('no', 'yes') latin1_swedish_ci Yes no
56 varchar(20) latin1_swedish_ci Yes NULL
57 varchar(20) latin1_swedish_ci No None

Add column  Add column(s)  
Information
Space usage
Data 112 KiB
Index 32 KiB
Total 144 KiB
Row statistics
Format Compact
Collation latin1_swedish_ci
Next autoindex 312
Creation Aug 28, 2024 at 12:35 PM