facturas - Laravel Schema Designer

users

id increments
role_id ^FK integer
username string (255)
password string (255)
first_name string (255)
last_name string (255)
email string (255)
timestamps timestamps
softDeletes softDeletes

role

id increments
name string (255)
timestamps timestamps
softDeletes softDeletes

client

id increments
ci string (255)
name string (255)
address text
phone string (100)
mobile string (100)
email string (255)
notes text
user_id ^FK integer
timestamps timestamps
softDeletes softDeletes

invoice

id increments
nit_ci string
tr string
notes text
total decimal
paid decimal
authorization_number string (255)
percentage_discount integer
total_discount decimal
percentage_taxes integer
total_taxes decimal
control_code string
total_literal string
status_id ^FK integer
client_id ^FK integer
user_id ^FK integer
student_id ^FK integer
group_id ^FK integer
patient_id ^FK integer
timestamps timestamps
softDeletes softDeletes

invoice_item

id increments
quantity integer
total decimal
invoice_id ^FK integer
service_id ^FK integer
period string
timestamps timestamps
softDeletes softDeletes

service

id increments
group_id ^FK integer
name string (255)
notes text
price decimal
iva tinyInteger
timestamps timestamps
softDeletes softDeletes

group

id increments
name string (255)
timestamps timestamps
softDeletes softDeletes

group_user

id increments
user_id ^FK integer
group_id ^FK integer
timestamps timestamps
softDeletes softDeletes

invoice_status

id increments
name string (255)
timestamps timestamps
softDeletes softDeletes

student

id increments
ci integer
first_name string
last_name_p string
last_name_m string
registry_number string
timestamps timestamps
softDeletes softDeletes

program

id increments
name string (255)
timestamps timestamps
softDeletes softDeletes

program_student

id increments
program_id ^FK integer
student_id ^FK integer
group string
timestamps timestamps
softDeletes softDeletes

settings

id increments
nit bigInteger
authorization_number bigInteger
sfc integer
emission_date_limit timestamp
dosage_key string (255)
invoice_law text
periods_nr integer
timestamps timestamps

patient

id increments
ci integer
name string (255)
timestamps timestamps
softDeletes softDeletes

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