🐰스키마 정리

Organize Schema

• Unit (부대)

id

unitcode

name

picture

email

score (manner)

avr_score (manner)

n_decla (declaration)

n_notice (notice)

• User(유)

id

name

rank

email

picture

number

unitname (unit)

unitpicture (unit)

unitcode (unit)

score (manner)

ranking (manner)

n_reserv (reservation)

• Manner

id

userid (user)

unitcode (unit)

created

contents

score

• Reservation

id

userid (user)

name (user)

picture (user)

rank (user)

unitcode (unit)

name (facility)

picture (facility)

reason

created

limit

• Notice

id

unitcode (unit)

name (facility)

picture (facility)

created

contents

• Facility

id

unitcode (unit)

name (unit)

name

picture

detail

• Declaration

id

unitcode (unit)

userid (user)

name (user)

rank (user)

name (facility)

picture (facility)

contents

created