lzvo - Laravel Schema Designer

ur

id increments
regcode integer
name string (255)
address string (255)
closed string (1)

zva

id increments
reg_num bigInteger
object_inital_id integer
object_name string (255)
object_type string (255)
lic_code string (255)
lic_status tinyInteger
suspended_from date
object_addr_nice string (255)
pharm_manager boolean
object_email string (255)
object_phone string (255)

vi

id increments
aikods integer
fid integer
iestade string
address string
profils string (255)
tips string (1)
vards string (255)
uzvards string (255)
pievienota boolean

company

id increments
regcode_id integer
aikods string (255)
company_name string (255)
legal_address string (255)
postal_address string (255)
type_pharmacy boolean
type_wholesaler boolean
type_medical_institution boolean
status string

documents

id increments

users

id increments

signature_cont

id increments
company_id string (255)
first_name string (255)
last_name string (255)
phone string (255)
email string

company_zva

id increments
company_id integer
reg_num bigInteger
object_inital_id integer
object_name string (255)
object_type string (255)
lic_code string (255)
lic_status tinyInteger
suspended_from date
object_addr_nice string (255)
pharm_manager boolean
object_email string (255)
object_phone string (255)

company_vi

id increments
company_id integer
aikods integer
fid integer
iestade string
address string
profils string (255)
tips string (1)
vards string (255)
uzvards string (255)
pievienota boolean

it_system

id increments
developer string (255)
title string (255)
version string (255)
test_result string (255)
test_date date

it_system_contacts

id increments
it_system_id integer
first_name string (255)
last_name string (255)
phone string (255)
email string (255)

users_temp

id increments
company_id integer
first_name string (255)
last_name string (255)
phone string (255)
email string (255)

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