My Little Prison

Prison database

Database structure

• Prisoner — prisoners
• Criminal_Code_Article — criminal code articles
• Prisoner_Article — prisoner convictions (many-to-many with articles)
• Employee — prison staff
• Visit — prisoner visits
• Conscription — disciplinary violations
• Punishment — penalties for violations (one-to-one with Conscription)
• Duty_Schedule — employee duty schedules

ERD diagram

Installation

Create a database and import data

mysql -u root -p < src/init.sql