wvdigital-wave - Laravel Schema Designer

tenants

id increments
ref_id string
title string
portal_domain string
portal_enabled boolean
street string
postalcode string
city string
phone string
fax string
website string
email_general string
email_service string
enabled_connection_water boolean
enabled_connection_water_disposal boolean
enabled_discharger boolean
enabled_downpayment string
config_advancepayment_offset_days string
config_advancepayment_max_percent string
config_imprint_url string
config_privacy_statement_url string
config_privacy_statement string
config_mail_signature string
config_mail_sender_name string
config_mail_sender_email string
config_mail_sender_replyto string
config_mail_cc string
config_mail_bcc string
config_mail_server string
config_mail_username string
config_mail_password string
config_storage_tenant_folder string
config_custom_frontend json
config_custom_theme json
config_custom_system json
timestamps timestamps
softDeletes softDeletes

localities

id increments
tenant_id ^FK bigInteger
ref_id string
locality string
timestamps timestamps

streets

id increments
ref_id string
locality_id ^FK bigInteger
service_water boolean
service_water_disposal boolean
street string
timestamps timestamps

procedures

id increments
tenant_id ^FK bigInteger
user_id ^FK bigInteger
customer_id ^FK integer
status_id ^FK bigInteger
ref_id string
payload json
type string
submitted_at string
returned_at string
timestamps timestamps
softDeletes softDeletes

postbox

id increments
customer_id ^FK bigInteger
procedure_id ^FK bigInteger
payment_id ^FK bigInteger
consumption_unit_id ^FK bigInteger
message_id ^FK bigInteger
type string
read_at timestamp
subject string
message longText
timestamps timestamps
softDeletes softDeletes

messages

id increments
tenant_id ^FK bigInteger
procedure_id ^FK bigInteger
submitted_at timestamp
subject string
content longText
timestamps timestamps
softDeletes softDeletes

customers

id increments
tenant_id ^FK bigInteger
ref_id string
organization string
addition string
name string
postalcode smallInteger
locality string
street string
country string
payment_method string
sepa_iban string
sepa_bank string
sepa_bic string
sepa_reference string
sepa_applies_at string
sepa_accountholder string
billing_organization string
billing_addition string
billing_name string
billing_street string
billing_postalcode smallInteger
billing_locality string
billing_country string
timestamps timestamps
softDeletes softDeletes

customer_user

id increments
user_id bigInteger
customer_id bigInteger
approval_type string
approval_token string
approved_at timestamp
invited_at timestamp
invited_by string
timestamps timestamps
softDeletes softDeletes

status

id increments
tenant_id ^FK bigInteger
type string
title string
timestamps timestamps
softDeletes softDeletes

consumption_units

id increments
tenant_id ^FK bigInteger
ref_id string
services text
info text
street string
number string
unit string
postalcode smallInteger
locality string
timestamps timestamps
softDeletes softDeletes

payments

id increments
tenant_id ^FK bigInteger
customer_id ^FK bigInteger
consumption_unit_id ^FK bigInteger
ref_id string
invoice_reference string
designation string
transactional_info string
method string
amount_total double
amount_pending double
amount_currency string
due_at datetime
timestamps timestamps

meters

id increments
consumption_unit_id ^FK bigInteger
ref_id string
type string
meter_number string
active boolean
timestamps timestamps

customer_consumption_unit

id increments
customer_id ^FK bigInteger
consumption_unit_id ^FK bigInteger
granted_at timestamp
revoked_at timestamp
expires_at timestamp
downpayment_interval string
downpayment_amount double
downpayment_currency string
timestamps timestamps
softDeletes softDeletes

meter_counts

id increments
meter_id ^FK bigInteger
ref_id string
count integer
count_at timestamp
reading_type string
submitted_user_id ^FK bigInteger
submitted_user string
submitted_at timestamp
timestamps timestamps
softDeletes softDeletes

news

id increments
tenant_id ^FK bigInteger
title string
text string
abstract text
date datetime
published boolean
timestamps timestamps
softDeletes softDeletes

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