pottokids - Laravel Schema Designer

users

login_id string (100)
status enum
timestamps timestamps

logs

id increments
login_id string (100)
ip_address string (100)
channel enum
action enum
target_table string (100)
target_id integer
description string (255)
created_at timestamp

children

id increments
login_id string (100)
name string (50)
photo string (500)
birthday date
gender enum
postcode string (10)
address string (255)
address_detail string (255)
timestamps timestamps

user_role

login_id string (100)
ac_id ^FK integer
role enum

students

id integer
ch_id ^FK integer
ac_id integer
gp_id integer
name string (100)
nickname string (100)
photo string (500)
birthday date
gender enum
postcode string (10)
address string (255)
address_detail string (255)
memo string (500)
status enum
join_date date
leave_date date
timestamps timestamps
softDeletes softDeletes

academies

id increments
owner_id string (100)
type enum
name string (255)
nickname string (255)
rep_name string (255)
mgr_name string (255)
mgr_mobile string (255)
mgr_email string (255)
phone string (50)
postcode string (10)
address string (255)
address_detail string (255)
status enum
timestamps timestamps

teachers

id increments
ac_id ^FK integer
login_id string (100)
name string (100)
nickname string (100)
photo string (500)
gender enum
birthday date
phone string (50)
email string (255)
memo string (500)
status enum
join_date date
leave_date date
timestamps timestamps
softDeletes softDeletes

groups

id increments
ac_id ^FK integer
tc_id ^FK integer
year integer
name string (100)
nickname string (100)
age integer
memo string (255)
status enum
timestamps timestamps

edit_authority

tc_id ^FK integer
gp_id ^FK integer

families

id increments
st_id ^FK integer
relation string (50)
name string (100)
phone string (50)
email string (255)
job string (100)
memo string (500)
timestamps timestamps

counselings

id increments
ac_id ^FK integer
st_id ^FK integer
st_name string (100)
pt_name string (100)
phone string (50)
email string (255)
cs_at timestamp
title string (255)
content text
timestamps timestamps

schedules

id increments
ac_id ^FK integer
scope enum
start_at timestamp
is_allday tinyInteger
is_holiday tinyInteger
name string (100)
nickname string (100)
place string (100)
description string (255)
timestamps timestamps

schedule_class

sc_id ^FK integer
gp_id ^FK integer

mealplans

id increments
ac_id ^FK integer
meal_date date
content1 string (500)
content2 string (500)
content3 string (500)
content4 string (500)
timestamps timestamps

attendances

id integer
gp_id ^FK integer
ac_id ^FK integer
tc_id ^FK integer
year_month date
gp_name string (100)
gp_age integer
tc_name string (100)
start_date date
end_date date
timestamps timestamps

attendance_student

at_id ^FK integer
st_id ^FK integer

attendance_records

at_id ^FK integer
st_id ^FK integer
rec_date date
status enum
timestamps timestamps
memo string (255)

body_records

id increments
st_id ^FK integer
rec_date date
height integer
weight integer
timestamps timestamps

diary_activity_records

id increments
timestamps timestamps
content text
grade string (100)
photo string (500)

diaries

id increments
type enum
rec_date date
absent_students string (500)
injured_students string (500)
birthday_students string (500)
event string (500)
note string (500)
feedback string (500)
timestamps timestamps

diary_activities

id increments
scope string (100)
category string (100)
subcategory string (100)
title string (255)
criteria string (100)
subcriteria string (100)
place string (255)
timestamps timestamps

degree_intros

id increments
ac_id ^FK integer
year_month date
title string (255)
content string (500)
image string
timestamps timestamps

degree_schedules

id increments
timestamps timestamps

degree_edumaterials

id increments
timestamps timestamps

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