Affective Tips

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.

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/

Affective Tips

Search This Blog

DataBase Objects Created by Serenity on Default Migration

List of Government Departments in Pakistan