Database employee

Database mysql_oracle_database

Table structure for table current_benifit

Column

Type

Null

Default

emp_SSN

int(11)

No

salary_Level

int(11)

No

bonus

int(11)

No

stock_Option_Exercised

int(11)

No

effective_Since

date

No

Dumping data for table current_benifit

123456789

750000

100000

325000

0000-00-00

123456790

35000

10000

25000

2011-01-01

123456791

65000

10000

25000

2007-01-01

123456792

70000

10000

25000

1999-01-01

123456794

55000

10000

25000

2010-01-01

123456795

65000

10000

25000

2016-01-01

123456796

95000

10000

25000

2015-01-01

1234567931

75000

80000

125000

2008-01-01

1234567971

95000

190000

225000

2014-01-01

Table structure for table department

Column

Type

Null

Default

Dpt_ID

int(11)

No

Department_Name

varchar(255)

No

Dumping data for table department

0

President Office

11

Accounting

12

Productio

13

Marketing

Table structure for table employee

Column

Type

Null

Default

Emp_SSN

int(11)

No

First_Name

varchar(255)

No

Middle_Name

varchar(255)

No

Last_Name

varchar(255)

No

Date_Of_Birth

date

No

Dpt_Id

int(11)

No

Mngr_SSN

int(11)

No

Dumping data for table employee

123456789

Melvin

T

Sharply

1954-01-01

0

123456789

123456790

Mary

S

Jones

1974-07-02

11

123456797

123456791

Iim

T

Wilson

1986-07-03

12

123456793

123456792

Mike

F

Taylor

1990-07-04

13

123456797

123456793

Celia

M

Mayes

0000-00-00

12

123456789

123456794

Truedy

T

Browning

1963-07-06

13

123456797

123456795

Miguel

P

Brown

1984-09-07

11

123456797

123456796

Cindy

S

Beasley

1974-07-08

12

123456793

123456797

Melvin

Q

Dunne

1994-07-02

11

123456789

Table structure for table history_benefit

Column

Type

Null

Default

emp_SSN

int(11)

No

salary_Level

int(11)

No

bonus

int(11)

No

stock_Option_Exercised

int(11)

No

effective_Start

date

No

effective_End

date

No

Dumping data for table history_benefit

1234567892

25000

90000

325000

2006-01-01

2009-01-01

123456790

25000

10000

25000

2005-01-01

2009-01-01

123456791

42000

10000

25000

2004-01-01

2009-01-01

123456792

48000

10000

25000

2008-01-01

2009-01-01

123456793

130000

80000

125000

2003-01-01

2009-01-01

123456794

40000

10000

25000

1986-01-01

2009-01-17

123456795

45000

10000

25000

2006-01-01

2008-01-01

123456796

45000

10000

25000

2006-01-01

2007-01-01

123456797

125000

90000

225000

2006-01-01

2007-01-01

123456789

200000

100000

325000

2005-01-01

2006-01-01

123456790

25000

10000

25000

2005-01-01

2006-01-01

123456791

40000

10000

25000

2004-01-01

2005-01-01

123456792

40000

10000

25000

2005-01-01

2006-01-01

123456792

40000

10000

25000

2005-01-01

2006-01-01

123456794

30000

10000

25000

2008-01-01

2009-01-01

123456795

40000

10000

25000

2005-01-01

2006-01-01

123456796

40000

10000

25000

2005-01-01

2006-01-01

123456797

100000

90000

225000

2007-01-01

2008-01-01

Table structure for table phone_number

Column

Type

Null

Default

area_Code

int(11)

No

phone_Number

int(11)

No

extension

int(11)

No

emp_SSN

int(11)

No

type_Phone

varchar(225)

No

Dumping data for table phone_number

111

9991234

1112

123456789

OFFICE

111

9991235

1113

123456790

OFFICE

111

9991236

1114

123456791

OFFICE

111

9991237

1115

123456792

OFFICE

111

9991238

1116

123456793

OFFICE

111

9991239

1117

123456794

OFFICE

111

9991230

1118

123456795

OFFICE

111

9991231

1119

123456796

OFFICE

111

8991339

1118

123456789

HOME

111

8991332

1117

123456794

HOME

111

9991236

1114

123456792

HOME

Database phpmyadmin

Table structure for table pma__bookmark

Column

Type

Null

Default

id

int(11)

No

dbase

varchar(255)

No

user

varchar(255)

No

label

varchar(255)

No

query

text

No

Dumping data for table pma__bookmark

Table structure for table pma__central_columns

Column

Type

Null

Default

db_name

varchar(64)

No

col_name

varchar(64)

No

col_type

varchar(64)

No

col_length

text

Yes

NULL

col_collation

varchar(64)

No

col_isNull

tinyint(1)

No

col_extra

varchar(255)

Yes

col_default

text

Yes

NULL

Dumping data for table pma__central_columns

Table structure for table pma__column_info

Column

Type

Null

Default

id

int(5)

No

db_name

varchar(64)

No

table_name

varchar(64)

No

column_name

varchar(64)

No

comment

varchar(255)

No

mimetype

varchar(255)

No

transformation

varchar(255)

No

transformation_options

varchar(255)

No

input_transformation

varchar(255)

No

input_transformation_options

varchar(255)

No

Dumping data for table pma__column_info

Table structure for table pma__designer_settings

Column

Type

Null

Default

username

varchar(64)

No

settings_data

text

No

Dumping data for table pma__designer_settings

Table structure for table pma__export_templates

Column

Type

Null

Default

id

int(5)

No

username

varchar(64)

No

export_type

varchar(10)

No

template_name

varchar(64)

No

template_data

text

No

Dumping data for table pma__export_templates

Table structure for table pma__favorite

Column

Type

Null

Default

username

varchar(64)

No

tables

text

No

Dumping data for table pma__favorite

Table structure for table pma__history

Column

Type

Null

Default

id

bigint(20)

No

username

varchar(64)

No

db

varchar(64)

No

table

varchar(64)

No

timevalue

timestamp

No

CURRENT_TIMESTAMP

sqlquery

text

No

Dumping data for table pma__history

Table structure for table pma__navigationhiding

Column

Type

Null

Default

username

varchar(64)

No

item_name

varchar(64)

No

item_type

varchar(64)

No

db_name

varchar(64)

No

table_name

varchar(64)

No

Dumping data for table pma__navigationhiding

Table structure for table pma__pdf_pages

Column

Type

Null

Default

db_name

varchar(64)

No

page_nr

int(10)

No

page_descr

varchar(50)

No

Dumping data for table pma__pdf_pages

Table structure for table pma__recent

Column

Type

Null

Default

username

varchar(64)

No

tables

text

No

Dumping data for table pma__recent

root

[{"db":"mysql_oracle_database","table":"current_benifit"},{"db":"mysql_oracle_database","table":"department"},{"db":"mysql_oracle_database","table":"employee"},{"db":"mysql_oracle_database","table":"history_benefit"},{"db":"mysql_oracle_database","table":"phone_number"},{"db":"mysql_oracle_database","table":"history_Benefit"},{"db":"mysql_oracle_database","table":"current_Benifit"},{"db":"mysql_oracle_database","table":"phone_Number"},{"db":"mysql_oracle_database","table":"DEPARTMENT"},{"db":"mysql_Oracle_Database","table":"EMPLOYEE"}]

Table structure for table pma__relation

Column

Type

Null

Default

master_db

varchar(64)

No

master_table

varchar(64)

No

master_field

varchar(64)

No

foreign_db

varchar(64)

No

foreign_table

varchar(64)

No

foreign_field

varchar(64)

No

Dumping data for table pma__relation

Table structure for table pma__savedsearches

Column

Type

Null

Default

id

int(5)

No

username

varchar(64)

No

db_name

varchar(64)

No

search_name

varchar(64)

No

search_data

text

No

Dumping data for table pma__savedsearches

Table structure for table pma__table_coords

Column

Type

Null

Default

db_name

varchar(64)

No

table_name

varchar(64)

No

pdf_page_number

int(11)

No

0

x

float

No

0

y

float

No

0

Dumping data for table pma__table_coords

Table structure for table pma__table_info

Column

Type

Null

Default

db_name

varchar(64)

No

table_name

varchar(64)

No

display_field

varchar(64)

No

Dumping data for table pma__table_info

Table structure for table pma__table_uiprefs

Column

Type

Null

Default

username

varchar(64)

No

db_name

varchar(64)

No

table_name

varchar(64)

No

prefs

text

No

last_update

timestamp

No

CURRENT_TIMESTAMP

Dumping data for table pma__table_uiprefs

root

mysql_oracle_database

department

{"sorted_col":"`department`.`Department_Name` ASC"}

2018-04-05 10:46:32

Table structure for table pma__tracking

Column

Type

Null

Default

db_name

varchar(64)

No

table_name

varchar(64)

No

version

int(10)

No

date_created

datetime

No

date_updated

datetime

No

schema_snapshot

text

No

schema_sql

text

Yes

NULL

data_sql

longtext

Yes

NULL

tracking

set('UPDATE', 'REPLACE', 'INSERT', 'DELETE', 'TRUNCATE', 'CREATE DATABASE', 'ALTER DATABASE', 'DROP DATABASE', 'CREATE TABLE', 'ALTER TABLE', 'RENAME TABLE', 'DROP TABLE', 'CREATE INDEX', 'DROP INDEX', 'CREATE VIEW', 'ALTER VIEW', 'DROP VIEW')

Yes

NULL

tracking_active

int(1)

No

1

Dumping data for table pma__tracking

Table structure for table pma__userconfig

Column

Type

Null

Default

username

varchar(64)

No

timevalue

timestamp

No

CURRENT_TIMESTAMP

config_data

text

No

Dumping data for table pma__userconfig

root

2018-03-28 11:07:59

{"collation_connection":"utf8mb4_unicode_ci"}

Table structure for table pma__usergroups

Column

Type

Null

Default

usergroup

varchar(64)

No

tab

varchar(64)

No

allowed

enum('Y', 'N')

No

N

Dumping data for table pma__usergroups

Table structure for table pma__users

Column

Type

Null

Default

username

varchar(64)

No

usergroup

varchar(64)

No

Dumping data for table pma__users

Database test