mdm - Laravel Schema Designer

companies

id increments
timestamps timestamps
softDeletes softDeletes
type_id integer
membership_type string (50)
payment_type_id integer
name string (150)
code string (20)
status integer
is_bank boolean
channel_id integer
is_whitelist boolean

company_details

id increments
timestamps timestamps
company_id integer
address text
city_id integer
phone string (30)
fax string (30)
email string (50)
status integer
npwp string (30)

company_insurances

id increments
timestamps timestamps
company_id integer
insurance_id integer
status integer

company_settings

id increments
timestamps timestamps
logo string (255)
header string (255)
title text
sub_title text
caption text
footer text

payment_types

id increments
timestamps timestamps
name string (50)
fee_charge float (8,2)
is_active boolean
is_primary boolean
fee_type enum

channels

id increments
timestamps timestamps
name string (100)
type char (50)
is_active boolean

insurances

timestamps timestamps
id increments
name string (255)
code string (15)
slug string (20)
logo string (255)
city_id integer
status integer
npwp string (30)
jv_type enum
type_id integer

company_bank_details

id increments
timestamps timestamps
company_id integer
branch_id integer
city_id integer

branches

id increments
timestamps timestamps
name string (100)

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