RdsDiagram
Employees
EmployeeID: INTEGER
EmployeeFirstName: VARCHAR(0)
EmployeeLastName: VARCHAR(0)
EmployeeDOB: DATE
EmployeeYearsOfExperience: INTEGER
EmployeeContactNumber: CHARACTER(0)
Organizations_OrganizationName: VARCHAR(0)
EmployeeSkills
Skill Name: VARCHAR(0)
Skill Description: VARCHAR(0)
Skill level: VARCHAR(0)
EmployeeSkillsLines
Skills_Skill Name: VARCHAR(0)
Employees_EmployeeID: INTEGER
EmployeeOffences
EmployeeOffenceOffenceNumber: INTEGER
EmployeeOffenceDateCommited: DATE
EmployeeOffenceLocationCommitted: VARCHAR(0)
CriminalOffences_CriminalOffencesOffenceName: VARCHAR(0)
PrisonRecord_PrisonRecordID: INTEGER
Employees_EmployeeID: INTEGER
CriminalOffences
CriminalOffencesOffenceName: VARCHAR(0)
CriminalOffencesOffenceDescription: VARCHAR(0)
CriminalOffencesMinSentence: INTEGER
CriminalOffencesMaxSentence: INTEGER
CriminalOffencesFine: DOUBLE
Prisons
PrisonsName: VARCHAR(0)
PrisonsSecurityLevel: VARCHAR(0)
PrisonsType: VARCHAR(0)
PrisonsWardensFirstName: VARCHAR(0)
PrisonsWardensLastName: VARCHAR(0)
PrisonRecord_PrisonRecordID: INTEGER
PrisonRecords
PrisonRecordID: INTEGER
PrisonRecordNumberOfYearsServed: INTEGER
Prisons_PrisonsName: VARCHAR(0)
Organizations
OrganizationName: VARCHAR(0)
OrganizationDetails: VARCHAR(0)
OrganizationDateOfEstablishment: VARCHAR(0)
OrganizationRating: INTEGER
OrganizationAddress_OrganizationAddressCityName: VARCHAR(0)
OrganizationTypes_OrganizatioType: VARCHAR(0)
OrganizationTypes
OrganizatioType: VARCHAR(0)
OrganizationTypeDescription: VARCHAR(0)
OrganizationTypeMembership: VARCHAR(0)
OrganizationTypeMembershipFees: DOUBLE
OrganizationActivities
OrganizationActivitiesName: VARCHAR(0)
OrganizationActivitiesDescription: VARCHAR(0)
OrganizationTypes_OrganizatioType: VARCHAR(0)
OrganizationAddress
OrganizationAddressCityName: VARCHAR(0)
OrganizationAddressStateOrRegion: VARCHAR(0)
OrganizationAddressOtherDetails: VARCHAR(0)
Countries_CountryCode: VARCHAR(0)
Countries
CountryCode: VARCHAR(0)
CountryName: VARCHAR(0)
CountryCurrency: VARCHAR(0)
CountryMainLanguage: VARCHAR(0)
CountryUSDExchangeRate: DOUBLE
ProductsAndServices
ProductsAndServicesID: INTEGER
ProductsAndServicesDetails: VARCHAR(0)
ProductsAndServicesPrice: DOUBLE
ProductsAndServicesDiscount: DOUBLE
OrganizationActivities_OrganizationActivitiesName: VARCHAR(0)
Clients
ClientID: INTEGER
ClientFirstNameOrAlias: VARCHAR(0)
ClientBusinessType: INTEGER
ClientAuthenticated: CHARACTER(0)
Contract
ContractNumber: INTEGER
ContractDate: DATE
ContractShipmentCompleted: CHARACTER(0)
PayementType_PaymentType: VARCHAR(0)
Clients_ClientID: INTEGER
PayementType
PaymentType: VARCHAR(0)
PaymentDescription: VARCHAR(0)
PaymenyOtherDetails: VARCHAR(0)
ContractLines
ContractLinesUnits: INTEGER
Contract_ContractNumber: INTEGER
ProductsAndServices_ProductsAndServicesID: INTEGER