Skip to content

Gitubrr/MyLittlePrison_HW

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

12 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

My Little Prison

MySQL License: MIT Build

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

ERD

Installation

Create a database and import data

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

About

home work for mySQL course

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors

Languages