entities - Laravel Schema Designer

entities

id increments
type_id ^FK integer
country_id ^FK integer
name string
picture string (255)
user_id integer
obs text
timestamps timestamps
softDeletes softDeletes

entity_types

id increments
name string
status smallInteger
timestamps timestamps

entity_addresses

id increments
person_id ^FK integer
type ^FK integer
country_code string (2)
admin1_code string (20)
admin2_code string (20)
admin3_code string (20)
admin4_code string (20)
line1 string
line2 string
line3 string
city string
postal_code string (20)
phone string (25)
email string (100)
latitude decimal (10,8)
longitude decimal (11,8)
timezone string (40)
primary_contact smallInteger
timestamps timestamps

countries

id increments
culture_id ^FK integer
date_format_type_id ^FK integer
name string
code string (2)
nationality string
eu_member boolean
number_format string (25)
is_default boolean
calling_code string (5)
status smallInteger
timestamps timestamps

admin1_codes

id increments
name string
code string (20)
country_code string (2)
status smallInteger
timestamps timestamps

admin2_codes

id increments
name string
code string (20)
admin1_code string (20)
status smallInteger
timestamps timestamps

admin3_codes

id increments
name string
code string (20)
admin2_code string (20)
status smallInteger
timestamps timestamps

admin4_codes

id increments
name string
code string (20)
admin3_code string (20)
status smallInteger
timestamps timestamps

postal_codes

id increments
name string
code string (20)
country_code string (2)
admin1_code string (20)
admin2_code string (20)
admin3_code string (20)
latitude decimal (10,8)
longitude decimal (11,8)
status smallInteger
timestamps timestamps

address_types

id increments
name string
status smallInteger
timestamps timestamps

identification_types

id increments
name string
code string (10)
status smallInteger
timestamps timestamps

entity_natural_identifications

id increments
entity_natural_id ^FK integer
country_code string (2)
identification_type_id ^FK integer
number string (50)
from_at date
to_at date
issue_place string
lifetime smallInteger
timestamps timestamps

genders

id increments
name string
status smallInteger
timestamps timestamps

entity_legal_representatives

id increments
entity_id ^FK integer
natural_person_id ^FK integer
from_at date
to_at date
status smallInteger
timestamps timestamps

banks

id increments
entity_legal_id ^FK integer
swift string
code smallInteger
timestamps timestamps

insurance_companies

id increments
entity_legal_id ^FK integer
code smallInteger
timestamps timestamps

contact_groups

id increments
name string
status smallInteger
timestamps timestamps

entity_naturals

id increments
entity_id ^FK integer
gender_id ^FK integer
marital_status_id ^FK integer
birth_at date
birth_place string
timestamps timestamps

marital_statuses

id increments
name string
status smallInteger
timestamps timestamps

entity_legals

id increments
entity_id ^FK integer
business_name string
description string
domain_id integer
classification_code integer
establishment_at date
share_capital decimal
timestamps timestamps

entity_contacts

id increments
entity_id ^FK integer
contact_type_id ^FK integer
name string (255)
website string
phone string
email string
primary_contact boolean
timestamps timestamps
softDeletes softDeletes

category_types

id increments
name string
timestamps timestamps
softDeletes softDeletes

contact_types

id increments
name string
timestamps timestamps
softDeletes softDeletes

entity_category_type

id increments
entity_id ^FK integer
category_type_id ^FK integer
timestamps timestamps
softDeletes softDeletes

entity_contact_groups

id increments
entity_contact_id ^FK integer
contact_group_id ^FK integer
timestamps timestamps
softDeletes softDeletes

cultures

id increments
code string (5)
name string
status boolean
timestamps timestamps
softDeletes softDeletes

date_format_types

id increments
code string (25)
timestamps timestamps
softDeletes softDeletes