riyadh-institute - Laravel Schema Designer

settings

id increments
timestamps timestamps
key string
value string
type string

faqs

id increments
timestamps timestamps
question json
anwser json

members

id increments
timestamps timestamps
name json
bio json
position json
role enum

companies

id increments
timestamps timestamps
name json
type enum
sponsorship_type_id ^FK integer

sponsorship_types

id increments
timestamps timestamps
name json
description json

programs

id increments
timestamps timestamps
name json
description json
credit_hours integer
cooperative_hours integer
duration json
work_fields json
program_type_id ^FK integer
certificate_type_id ^FK integer

certificates

id increments
timestamps timestamps
ssn string
number string
academic_number string
phone string
certificate_type_id ^FK integer

program_types

id increments
timestamps timestamps
name json
description json

certificate_types

id increments
timestamps timestamps
name json

training_strategies

id increments
timestamps timestamps
name json
description json

coures

id increments
timestamps timestamps
name json
number string
term enum
hour_count integer

course_program

id increments
timestamps timestamps
course_id ^FK integer
program_id ^FK integer

seminars

id increments
timestamps timestamps
name json
description json
date_time datetime

certifiers

id increments
timestamps timestamps
name json
description json
web_url string (255)

services

id increments
timestamps timestamps
name json
rate integer
description json
price double
requirments json
date date
language_id ^FK integer
category_id ^FK integer

languages

id increments
timestamps timestamps
name json
code string

categories

id increments
timestamps timestamps
name json

jobs

id increments
timestamps timestamps
name json
description json
end_date date

job_applications

id increments
timestamps timestamps
job_id ^FK integer
name string
email string
phone string
linkedin_url string
city_id ^FK integer
status enum

cities

id increments
timestamps timestamps
name json

districts

id increments
timestamps timestamps
name json
city_id ^FK integer

contacts

id increments
timestamps timestamps
name string
email string
phone string
type enum
title string
body text

training_applications

id increments
timestamps timestamps
name json
email string
phone string
relevant_phone string
ipan string
gender json
birthdate date
ssn string
ssn_issue_date date
number string
ssn_district_id ^FK integer
school_district_id ^FK integer
school_name string
school_city_id ^FK integer
secondary_certificate_type_id ^FK integer
secondary_gpa decimal (5,2)
aptitude_test_score decimal (5,2)
comment text
company_id ^FK integer
status enum

secondary_certificate_types

id increments
timestamps timestamps
name json

program_training_application

id increments
timestamps timestamps
training_application_id ^FK integer
program_id ^FK integer

activites

id increments
timestamps timestamps
title string
date date
description text
type enum

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