ac - Laravel Schema Designer

items

id integer
group_id ^FK integer
user_id ^FK integer
category_id ^FK integer
content_id ^FK integer
allow_comments tinyInteger
moderate_comments tinyInteger
pinned tinyInteger
published_at timestamp
timestamps timestamps
softDeletes softDeletes

items_categories

id integer
name string (255)
timestamps timestamps
softDeletes softDeletes

items_comments

id integer
commentcontent text
item_id ^FK integer
user_id ^FK integer
approved_by integer
published_at timestamp
timestamps timestamps
softDeletes softDeletes

items_contents

id integer
item_id ^FK integer
title string (255)
content text
description text
objectives text
return_type string
set datetime
expire datetime
state tinyInteger
grading_template string
softDeletes softDeletes
timestamps timestamps

group_parent

parent_id integer
group_id ^FK integer
parental_responsibility integer
timestamps timestamps
softDeletes softDeletes

group_site

group_id ^FK integer
site_id ^FK integer
timestamps timestamps
softDeletes softDeletes

group_user

id integer
user_id ^FK integer
group_id ^FK integer
default tinyInteger
timestamps timestamps
softDeletes softDeletes

groups

id integer
name string (150)
open tinyInteger
default tinyInteger
module_id integer
timestamps timestamps
softDeletes softDeletes

modules

id integer
name string (20)
timestamps timestamps
softDeletes softDeletes

permission_role

permission_id ^FK integer
role_id ^FK integer

permissions

id integer
name string (255)
label string (255)
timestamps timestamps
softDeletes softDeletes

profiles

id integer
timestamps timestamps
forename string (255)
surname string (255)
position string (255)
bio text
phone string
interest text
attend string
previous_attend string
user_id ^FK integer
profile_pic string
softDeletes softDeletes

items_resources

id increments
filename string
filesize string
item_id ^FK integer
published_at timestamp
timestamps timestamps
softDeletes softDeletes

role_user

role_id ^FK integer
user_id ^FK integer

roles

id integer
name string
label string
module_id integer
timestamps timestamps
softDeletes softDeletes

site_user

id integer
site_id ^FK integer
user_id ^FK integer

sites

id integer
name string
slug string (10)
hex_color string (6)
type string (10)
trust_id ^FK integer
sso tinyInteger
sso_ip_range_start string
sso_ip_range_end string
timestamps timestamps
softDeletes softDeletes

trusts

id integer
name string
timestamps timestamps
softDeletes softDeletes

password_resets

email string
token string
created_at timestamp

items_types

id integer
name string
timestamps timestamps
softDeletes softDeletes

social_accounts

id increments
timestamps timestamps
softDeletes softDeletes
site_id ^FK integer

users

id integer
timestamps timestamps
softDeletes softDeletes
name string
email string
password string
remember_token string
unique_id ^FK integer
active tinyInteger
impersonate integer
ad_groups text
sync datetime

group_infos

id integer
name string
description text
group_id ^FK integer
code string
primary_teacher_id string
subject string
timestamps timestamps

group_types

id integer
group_id ^FK integer
name string
timestamps timestamps

items_likes

items_id ^FK integer
user_id ^FK integer
timestamps timestamps

items_favourites

item_id ^FK integer
user_id ^FK integer
timestamps timestamps

user_notifications

id integer
user_id ^FK integer
item_id ^FK integer
valid timestamp
timestamps timestamps

passbanks

user_id ^FK integer
app_name string
username string
password string
note text
timestamps timestamps
softDeletes softDeletes

safeguarding_logs

id integer
site_id ^FK integer
user_id ^FK integer
student_name string
dob date
class string
time_of_incident string
incident_details text
further_info text
timestamps timestamps
softDeletes softDeletes

sessions

id integer
user_id ^FK integer
timestamps timestamps
hash string

upn_lookups

UPN string
unique_id integer
user_id ^FK integer
group_id ^FK integer
preferred_forename string
preferred_surname string
dob date
timestamps timestamps

devices

id integer
serial string
status tinyInteger
user_id ^FK integer
enrolled integer
site_id ^FK integer
case_supplied tinyInteger
date_added datetime
updated datetime
timestamps timestamps
softDeletes softDeletes

device_claims

id integer
timestamps timestamps
device_id integer
status tinyInteger
details text
date datetime
updated_by integer

logs

id integer
timestamps timestamps
user_id ^FK integer
url string
ip string
browser text

sites_slots

id integer
name string
site_id ^FK integer
order string (45)
start_time string
end_time string
timestamps timestamps
softDeletes softDeletes

sites_terms

id integer
site_id ^FK integer
name string
start_date date
end_date date
start_week_number tinyInteger
timestamps timestamps
softDeletes softDeletes