Spring boot based roles hierarchy project with spring security
Spring Security is a security framework that provides declarative security for Spring-based applications.
Based on the Spring Framework, Spring Security takes full advantage of dependency injection (DI) and aspect-oriented techniques.
| CREATE SCHEMA IF NOT EXISTS tourism_management_system; | |
| ---------- ENTITY 1 ---------- | |
| CREATE SEQUENCE tourism_management_system.user_Account_id_seq | |
| AS INTEGER MINVALUE 1 NO CYCLE; | |
| CREATE TYPE tourism_management_system.uAcc_role_enum AS ENUM ( | |
| 'USER', | |
| 'MANAGER', |
| Employee_Name,EmpID,MarriedID,MaritalStatusID,GenderID,EmpStatusID,DeptID,PerfScoreID,FromDiversityJobFairID,PayRate,Termd,PositionID,Position,State,Zip,DOB,Sex,MaritalDesc,CitizenDesc,HispanicLatino,RaceDesc,DateofHire,DateofTermination,TermReason,EmploymentStatus,Department,ManagerName,ManagerID,RecruitmentSource,PerformanceScore,EngagementSurvey,EmpSatisfaction,SpecialProjectsCount,LastPerformanceReview_Date,DaysLateLast30 | |
| "Brown, Mia",1103024456,1,1,0,1,1,3,1,28.5,0,1,Accountant I,MA,1450,11/24/1987,F,Married,US Citizen,No,Black or African American,10/27/2008,,N/A - still employed,Active,Admin Offices,Brandon R. LeBlanc,1,Diversity Job Fair,Fully Meets,2.04,2,6,1/15/2019,0 | |
| "LaRotonda, William ",1106026572,0,2,1,1,1,3,0,23,0,1,Accountant I,MA,1460,4/26/1984,M ,Divorced,US Citizen,No,Black or African American,1/6/2014,,N/A - still employed,Active,Admin Offices,Brandon R. LeBlanc,1,Website Banner Ads,Fully Meets,5,4,4,1/17/2019,0 | |
| "Steans, Tyrone ",1302053333,0,0,1,1,1,3,0,29,0,1,Accountant I,MA,2703,9/1/19 |
