school_project - Laravel Schema Designer

years

id increments
timestamps timestamps
softDeletes softDeletes
year string (60)
details string (256)

basic_settings

id increments
timestamps timestamps
name string (100)
phone string
cell string
email string
message text
vision text
goals text
logo string

settings

id increments
timestamps timestamps
leader string
agents integer
administrators integer
teachers integer
users integer
guards integer
years_id ^FK integer

categories

id increments
timestamps timestamps
name string

custodies

id increments
timestamps timestamps
custody_type_id ^FK integer
years_id ^FK integer
item_no integer
item_des string (255)
item_status enum
quantity integer
type enum
insert_date date
notebook_no integer
notebook_name integer
unit string
shortage integer
school_record_type_id ^FK integer
record_no integer
record_description string
notes string
serial_number integer
custody_name string
received_date string
received_signature string
recipient_signature string
retrieved_date string
public_number integer
private_number integer
receipt_number integer
book_supplier string
author string
book_title string
publisher string
place_of_publication string
date_of_publication string

class_rooms

id increments
timestamps timestamps
years_id ^FK integer
stage_id ^FK integer
classroom string (255)

custody_type

id increments
timestamps timestamps
category_id ^FK integer
name string

stage

id increments
timestamps timestamps
name string (255)

students_count

id increments
timestamps timestamps
class_room_id ^FK integer
count integer

documents

id increments
timestamps timestamps
custody_id ^FK integer
person enum
person_no integer
person_name string
reason_leaving string
documents text

school_records

id increments
timestamps timestamps
type string

school_record_types

id increments
timestamps timestamps
title string
school_record_id ^FK integer

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01