Search This Blog

DataBase Objects Created by Serenity on Default Migration

Following Database objects are created automatically when serenity runs its default migration

#

Tables

Triggers

Sequences

Indexes

1

EXCEPTIONS

EXCEPTIONS_SEQ_TRG

EXCEPTIONS_SEQ

PK_EXCEPTIONS

2

LANGUAGES

LANGUAGES_SEQ_TRG

LANGUAGES_SEQ

PK_LANGUAGES

3

ROLEPERMISSIONS

ROLEPERMISSIONS_SEQ_TRG

ROLEPERMISSIONS_SEQ

PK_ROLEPERMISSIONS

4

ROLES

ROLES_SEQ_TRG

ROLES_SEQ

PK_ROLES

5

USERPERMISSIONS

USERPERMISSIONS_SEQ_TRG

USERPERMISSIONS_SEQ

PK_USERPERMISSIONS

6

USERPREFERENCES

USERPREFERENCES_SEQ_TRG

USERPREFERENCES_SEQ

PK_USERPREFERENCES

7

USERROLES

USERROLES_SEQ_TRG

USERROLES_SEQ

PK_USERROLES

8

USERS

USERS_SEQ_TRG

USERS_SEQ

PK_USERS

9

VERSIONINFO

 

 

 

        
Moreover it also creates the following indexes.

SrNO.

Indexes

1

IX_EXCEPTIONS_APP_DEL_CRE

2

IX_EXCEPTIONS_GUID_APP_DEL_CRE

3

IX_EXCEPTIONS_HASH_APP_CRE_DEL

4

IX_USERPREF_UID_PREFTYPE_NAME

5

IX_USERROLES_ROLEID_USERID

6

SYS_IL0000083438C00005$$

7

SYS_IL0000083445C00014$$

8

SYS_IL0000083445C00016$$

9

SYS_IL0000083445C00018$$

10

UC_VERSION

11

UQ_ROLEPERM_ROLEID_PERMKEY

12

UQ_USERPERM_USERID_PERMKEY

13

UQ_USERROLES_USERID_ROLEID


Note: If we drop tables with cascade options, indexes and triggers will be dropped automatically. But we will need to drop the sequences.

List of Government Departments in Pakistan

Name

Total Employees

Reference

National Highway Authority

 

https://en.wikipedia.org/wiki/National_Highway_Authority

Trading Corporation of Pakistan

 

https://en.wikipedia.org/wiki/Trading_Corporation_of_Pakistan

Pakistan International Airlines

14800

https://en.wikipedia.org/wiki/Pakistan_International_Airlines

Pakistan National Shipping Corporation

 

https://en.wikipedia.org/wiki/Pakistan_National_Shipping_Corporation

Pakistan Railway

72078

https://en.wikipedia.org/wiki/Pakistan_Railways

PAEC

120000

https://en.wikipedia.org/wiki/Pakistan_Atomic_Energy_Commission

NESCOM

36000

https://en.wikipedia.org/wiki/National_Engineering_and_Scientific_Commission

KRL

 

https://en.wikipedia.org/wiki/Khan_Research_Laboratories

Pakistan Army

1241000

https://en.wikipedia.org/wiki/Pakistan_Army

Pakistan Navy

35200

https://en.wikipedia.org/wiki/Pakistan_Navy

Air Force

78128

https://en.wikipedia.org/wiki/Pakistan_Air_Force

Wapda

 

 

Teachers

 

 

Pakistan Post

44000

https://en.wikipedia.org/wiki/Pakistan_Post

State Bank of Pakistan

 

 

National Bank of Pakistan

 

 

Bank of Punjab

6092

https://en.wikipedia.org/wiki/Bank_of_Punjab

Bank of Khyber

 

https://en.wikipedia.org/wiki/Bank_of_Khyber

FBR

21500

https://en.wikipedia.org/wiki/Federal_Board_of_Revenue

NADRA

17000

https://en.wikipedia.org/wiki/Nadra

Doctors

 

 

Zarai Taraqiati Bank Limited

5500

https://en.wikipedia.org/wiki/Zarai_Taraqiati_Bank_Limited

SUPARCO

 

https://en.wikipedia.org/wiki/Space_%26_Upper_Atmosphere_Research_Commission

Pakistan Television Corporation

6000

https://en.wikipedia.org/wiki/Pakistan_Television_Corporation

PEPCO

 

 

Sindh Bank

 

https://en.wikipedia.org/wiki/Sindh_Bank

Punjab Police

180000

https://en.wikipedia.org/wiki/Punjab_Police_(Pakistan)

Sindh Police

128500

https://en.wikipedia.org/wiki/Sindh_Police

KPK Police

83000

https://en.wikipedia.org/wiki/Khyber_Pakhtunkhwa_Police

Balochistan Police

38000

https://en.wikipedia.org/wiki/Balochistan_Police

Islamabad Police

 

https://en.wikipedia.org/wiki/Capital_Territory_Police

PSO

3000

https://en.wikipedia.org/wiki/Pakistan_State_Oil

Rescue 1122

 

https://en.wikipedia.org/wiki/Rescue_1122

OGDCL

11000

https://en.wikipedia.org/wiki/Oil_%26_Gas_Development_Company

SSGC

7000

https://en.wikipedia.org/wiki/Sui_Southern_Gas_Company

SNGPL

 

https://en.wikipedia.org/wiki/Sui_Northern_Gas_Pipelines_Limited

FBISE

 

https://en.wikipedia.org/wiki/Federal_Board_of_Intermediate_and_Secondary_Education

PBS

 

https://en.wikipedia.org/wiki/Pakistan_Bureau_of_Statistics

HEC

 

https://en.wikipedia.org/wiki/Higher_Education_Commission_(Pakistan)

Punjab teachers

391799

https://schoolportal.punjab.gov.pk/sed_census/

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Web Statistics