WGAportaal - Laravel Schema Designer

companies

id increments
parent_company_id integer
company_name string (255)
CompanyType_id ^FK integer
LHnumber string (255)
CompanyAddress string (255)
CompanyZipcode string (20)
CompanyCity string (255)
Contactperson string (255)
ContactTelephone string (50)
ContactEmail string (255)

employees

id increments
EmployeeGender integer
EmployeeName string (255)
EmployeeInsertion string (255)
EmployeeLastName string (255)
DateOfBirth date
BSN string (20)

company_employees

id increments
company_id ^FK integer
employee_id ^FK integer

company_types

id increments
description string (50)
active boolean

communications

id increments
ReferenceTable string (255)
CommunicationType_id ^FK integer
CommunicationValue string (255)

users

id increments
UserName string (255)
UserEmail string (255)
Active boolean

company_employee_employments

id increments
CompanyEmployee_id ^FK integer
EmploymentStart date
EmploymentEnd date
EmploymentHours float

company_employee_illnesses

id increments
CompanyEmployee_id ^FK integer
DateOfIllness date
CompanyEmployeeInsurance_id ^FK integer
DateClose date
ReportDate date
StatusIllness_id ^FK integer

company_insurances

id increments
Company_id ^FK integer
InsuredItem_id ^FK integer
InsuranceCompany_id ^FK integer
InsurancePolicyNumber string (50)
ContractNumber string (50)
InsuranceStart date
InsuranceEnd date
ReportTerm string (20)
ContactPerson string (100)
TelephoneNumber string (30)
EMail string (255)
CompanyInsuranceRemark text

company_employee_insurance

id increments
CompanyInsurance_id ^FK integer
CompanyEmployee_id ^FK integer
InsuranceStart date
InsuranceEnd date

invoices

id increments
Company_id ^FK integer
InvoiceMonth string (20)
PaymentIdentification string (255)
TotalAmount float
ImportedByUser_id ^FK integer
Validated boolean
ValidatedByUser_id ^FK integer
StatusInvoice_id ^FK integer
OriginalFile binary

invoice_lines

id increments
Invoice_id ^FK integer
Declaration_id ^FK integer
BSN string (20)
EmployeeName string (255)
Kind string (50)
PeriodFrom date
PeriodTo date
Amount float
WE float
WA float
WAO float
WGA float
ZVW float
TotalAmount float
Validated boolean
ValidatedByUser_id ^FK integer

declarations

id increments
InsuranceCompany_id ^FK integer
Released tinyInteger
ReleasedBy_id ^FK integer
ViewedDate datetime
ViewedBy_id ^FK integer

invoice_line_originals

id increments
timestamps timestamps
Invoice_id ^FK integer
BSN string (20)
EmployeeName string (255)
Kind string (50)
PeriodFrom date
PeriodTo date
Amount float
WE float
WA float
WAO float
WGA float
ZVW float
TotalAmount float
ImportedBy_id ^FK integer

insured_items

id increments
InsuredCodeUWV string (50)
Active boolean

insurance_companies

id increments
InsuranceCompanyName string (100)
Company_id ^FK integer
Active boolean

communication_types

id increments
CommunicationDescription string (255)
Active boolean

status_illnesses

id increments
StatusDescription string (30)
Active boolean

company_employee_uwvdecisions

id increments
CompanyEmployee_id ^FK integer
DateDecisionUWV date
DateLGU date
DateVVU date
DateStart date
DateEnd date
PercAO float
WIAAmount float

invoice_states

id increments
StatusDescription string (30)
Active boolean

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