istoki - Laravel Schema Designer

Anketa

id increments
user_id ^FK integer
familia string (255)
imya string (128)
otchestvo string (128)
brithday date
phone_city string
phone_mob string
sniils string (14)
priostanovka timestamps
photo string
barcode string
note string
prichinas_id integer
prichinas_note string (255)
pricinas_date_ot date
prichinas_stop boolean
timestamps timestamps
softDeletes softDeletes
pricinas_date_do date
semeyka_id ^FK integer

spravka_client

id increments
spravka_id integer
client_id ^FK integer
seria string
number string
date_ot timestamp
date_do timestamp
timestamps timestamps

invalids

id increments
client_id ^FK integer
series string
number string
gruppa enum
date_ot timestamp
date_do timestamp
timestamps timestamps

journal

id increments
code string (255)
user_id ^FK integer
client_id ^FK integer
otdelenie_id ^FK integer
service_id ^FK integer
timestamps timestamps
softDeletes softDeletes

users

id increments
timestamps timestamps
familia string (255)
imya string (255)
otchestvo string (255)
dolgnost string
softDeletes softDeletes

user_client_pivots

id increments
timestamps timestamps
manger_id ^FK integer
client_id ^FK integer

services

id increments
name string
date_end date
timestamps timestamps

otdels

id increments
name string
timestamps timestamps

passports

id increments
client_id ^FK integer
timestamps timestamps
seria string
number string
date_vydachi string
kem_vydan string
propiska string (255)
progivanie string (255)

roles

id increments
name string (255)

permissions

id increments
name string (255)

role-user

id increments
user_id integer
role_id integer

permission_role

id increments
role_id integer
permission_id integer

spravkas

id increments
title string
is_limited boolean

semeyka

id increments
timestamps timestamps
title string (255)

prichinas

id increments
title string (255)

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