Arep - Laravel Schema Designer

requests

id increments
client_id ^FK integer
name string (50)
internalCategory_id ^FK integer
clientCategory_id ^FK integer
requesterUser_id ^FK integer
technicalUser_id ^FK integer
financeUser_id ^FK integer
clientUser_id ^FK integer
requestStatus_id ^FK integer
budgetPeriod_id ^FK integer
description string (50)
created date
requested date
closed date
department string (50)
statusComment string (50)
businessApprovalSent date
businessApprovalReceived date
businessApprovalComment string (50)
financeApprovalSent date
financeApprovalReceived date
financeApprovalComment string (50)
clientApprovalSent date
clientApprovalReceived date
clientApprovalComment string (50)
clientReference string (20)
ticket string
timestamps timestamps
softDeletes softDeletes

contracts

id increments
client_id ^FK integer
request_id ^FK integer
internalCategory_id ^FK integer
clientCategory_id ^FK integer
supplier_id ^FK integer
contractType_id ^FK integer
contractStatus_id ^FK integer
budgetPeriod_id ^FK integer
clientReference string (20)
supplierReference string (20)
approvedAmount decimal
approvedExcess decimal (5,2)
estimatedYearlyAmount decimal
estimatedMonthlyAmount decimal
period integer
creation date
start date
planned date
real date
cancellation date
finalAmount decimal (8,2)
paymentDays string
paymentTerms string
requireCertification boolean
timestamps timestamps
softDeletes softDeletes

invoices

id increments
client_id ^FK integer
contract_id ^FK integer
internalCategory_id ^FK integer
clientCategory_id ^FK integer
invoiceStatus_id ^FK integer
invoiceIssueCategory_id ^FK integer
clientUser_id ^FK integer
budgetPeriod_id ^FK integer
prepayment_id ^FK integer
ticketInvoice string (10)
number string (50)
concept string (200)
netAmount decimal (8,2)
taxAmount decimal (8,2)
otherAmount decimal
otherConcept string (50)
withholdedAmount decimal (8,2)
totalAmount decimal (8,2)
issued date
received date
periodStart date
periodEnd date
statusComment string (50)
reviewed date
approved date
paymentSent date
paymentDone date
ticketPayment string (10)
issueDescription string (50)
issueReported date
issueClosed date
timestamps timestamps
softDeletes softDeletes

suppliers

id increments
client_id ^FK integer
supplierType_id ^FK integer
county_id ^FK integer
mainContact ^FK integer
paymentMethod_id ^FK integer
legalName string (100)
commercialName string (100)
taxId string (20)
homologated date
expiration date
address_2 string (150)
zip string (10)
city string (50)
ban string (30)
activityDescription string (100)
activityCode string (8)
withholdingTax boolean
withholdingTaxPercentage decimal (4,2)
timestamps timestamps
softDeletes softDeletes
address_1 string (150)

budgets

id increments
request_id ^FK integer
supplier_id ^FK integer
supplierReference string (50)
amount decimal (8,2)
vat decimal (4,2)
requested date
comment string (50)
won boolean
received date
timestamps timestamps
softDeletes softDeletes

clientCategories

id increments
client_id ^FK integer
description string
timestamps timestamps
softDeletes softDeletes

clients

id increments
billingCounty_id ^FK integer
description string (50)
acronym string (3)
billingName string (50)
billingAddress_1 string (50)
billingAddress_2 string (50)
billingCity string (50)
billingZip string (10)
taxId string (20)
timestamps timestamps
softDeletes softDeletes

contacts

id increments
fullName string (50)
role string (50)
landPhone string (30)
mobilePhone string (30)
email string (100)
timestamps timestamps
softDeletes softDeletes

APPUSER

APPUSER_ID increments
APPUSER_NumEmpregado integer
APPUSER_USERNAME string
APPUSER_DISPLAYNAME string
APPUSER_EmailAddress string
APPUSER_Signature string

internalCategories

id increments
description string
timestamps timestamps
softDeletes softDeletes

requestStatuses

id increments
description string (50)
timestamps timestamps
softDeletes softDeletes

PROCESS

PROCESS_ID increments
PROCESS_INVENTARY string (50)
PROCESS_ACQUISITION_VALUE float
CATEGORY_ID integer
PROCESS_OWNERSHIP ^FK integer
DISTRICT_ID ^FK integer
CONCELHO_ID ^FK integer
PROCESS_ADDRESS string (500)
PROPERTYTYPE_ID ^FK integer
PROCESS_PROPERTY_AREA float
Identificador_Processo string (50)

executions

id increments
invoice_id ^FK integer
contract_id ^FK integer
validatorUser_id ^FK integer
certfied date
start date
end date
closed boolean
comment string (50)
timestamps timestamps
softDeletes softDeletes
amount decimal (8,2)

prepayments

id increments
client_id ^FK integer
requesterUser_id ^FK integer
approverUser_id ^FK integer
internalCategory_id ^FK integer
clientCategory_id ^FK integer
supplier_id ^FK integer
prepaymentStatus_id ^FK integer
paymentMethod_id ^FK integer
budgetPeriod_id ^FK integer
clientReference string (20)
description string (50)
requested date
statusComment string (50)
amount decimal (8,2)
proof_required boolean
payment_reference string (50)
ticket string
clientTicketSent date
clientTicketRejected date
paid date
timestamps timestamps
softDeletes softDeletes

FREGUESIA

FREGUESIA_ID integer
FREGUESIA_DESCRIPTION string
CONCELHO_ID ^FK integer

asset_contract

asset_id ^FK integer
contract_id ^FK integer
percentage decimal (5,2)

contractTypes

id increments
description string (50)
timestamps timestamps
softDeletes softDeletes

contractStatuses

id increments
description string (50)
timestamps timestamps
softDeletes softDeletes

invoiceStatuses

id increments
description string (50)
timestamps timestamps
softDeletes softDeletes

invoiceIssueCategories

id increments
description string (50)
timestamps timestamps
softDeletes softDeletes

request_supplier

request_id ^FK integer
supplier_id ^FK integer

asset_request

request_id ^FK integer
asset_id ^FK integer

contact_supplier

contact_id ^FK integer
supplier_id ^FK integer

asset_prepayment

prepayment_id ^FK integer
asset_id ^FK integer
amount decimal

prepaymentStatuses

id increments
description string (50)
timestamps timestamps
softDeletes softDeletes

PROPERTYTYPE

PROPERTYTYPE_ID increments
PROPERTYTYPE_DESCRIPTION string (255)

DISTRICT

DISTRIC_ID increments
DISTRIC_DESCRIPTION string
DCODE string (2)

CONCELHO

CONCELHO_ID integer
CONCELHO_DESCRIPTION string
CCODE string (4)
DISTRICT_ID ^FK integer

OWNER

OWNER_ID increments
OWNER_DESCR string (100)
OWNER_NIF string (10)
ordenacao integer
OWNER_FOOTER1 string (200)
OWNER_FOOTER2 string (200)
OWNER_LOGOPREFIX string (50)
OWNER_SOCIALCAPITAL string (30)
OWNER_NAME string (300)
PostalCode_id integer
OWNER_NPC string (30)
OWNER_CAE string (30)
OWNER_LOGO binary
OWNER_SIGN_RENTRECEIPTS boolean
nibPagamento string (21)
Eliminado boolean
Telefone string (20)
Fax string (20)
client_id ^FK integer

rentalContractVersions

id increments
rentalContract_id ^FK integer
versionNumber integer
versionReason_id ^FK integer
versionDescription string (50)
contractStatus_id ^FK integer
contractSubstatus_id ^FK integer
contractType_id ^FK integer
rentType_id ^FK integer
frequency_id ^FK integer
mainTenant_id ^FK integer
description string (255)
depositOption_id ^FK integer
comment string (1024)
signature date
start date
end date
activate date
deactivate date
cancel date
tenantCommunication date
advanceNotice integer
anticipatedMonths integer
anticipatedCollected boolean
anticipatedDepositary string (50)
feeUpdatePeriod integer
feeUpdateNext date
renewalNext date
billingAddress_1 string (50)
billingAddress_2 string (50)
billingZip string (10)
billingCity string (50)
billingCounty_id ^FK integer
billingEMail string (50)
billingPhone string (20)
billingText string
billingStartDate date
billingDate date
ban string (30)
paymentEntity string (5)
paymentReference string (20)
isBillingSuspended boolean
suspensionReason string (255)
electronicBilling boolean
isStampDutyPaid boolean
isLitigation boolean
stampDutyDate date
terminationDate date
terminationNoticeDate date
terminationRepoDate date
isRepossessed boolean
isDamaged boolean
damageComment string (1024)
terminationDebt decimal (8,2)
terminationComment string (1024)
depositReturnDate date
depositReturnAmount decimal (8,2)
renewedContract boolean
clientApproval date
softDeletes softDeletes
timestamps timestamps
ticket string (50)

rentalContractStatuses

id increments
description string (50)
timestamps timestamps
softDeletes softDeletes

rentalBillingConcepts

id increments
parent_id ^FK integer
contractVersion_id ^FK integer
unit_id ^FK integer
rentType_id ^FK integer
billingConceptType_id ^FK integer
feeUpdateType_id ^FK integer
tax_id ^FK integer
billingGroup integer
validFrom date
validUntil date
description string (50)
month integer
amount decimal (8,2)
timestamps timestamps
softDeletes softDeletes

rentalBillingConceptTypes

id increments
description string (50)
showDescription boolean
isRental boolean
isParking boolean
timestamps timestamps
softDeletes softDeletes

rentalUnits

id increments
asset_id ^FK integer
surface decimal (10,2)
parking_surface decimal (10,2)
description string (50)
timestamps timestamps
softDeletes softDeletes

rentalContractFrecuencies

id increments
description string (50)
months integer
timestamps timestamps
softDeletes softDeletes

rentalTaxes

id increments
description string (50)
percentage decimal (5,2)
timestamps timestamps
softDeletes softDeletes

rentalTenants

id increments
contact_id ^FK integer
taxId string (20)
name string (50)
commercialName string (50)
address_1 string (50)
address_2 string (50)
zip string (10)
city string (50)
county_id ^FK integer
landPhone string (20)
mobilePhone string (20)
email string (100)
ban string (30)
paymentEntity string (5)
paymentReference string (20)
activityCode string (8)
activityDescription string (50)
timestamps timestamps
softDeletes softDeletes
surname string (50)

rentalContractVersion_rentalTenant

contractVersion_id ^FK integer
tenant_id ^FK integer

rentalTenantTurnovers

id increments
tenant_id ^FK integer
period integer
start date
end date
amount decimal (10,2)
updatedPercentage decimal (5,2)
updatedFrom date
timestamps timestamps
softDeletes softDeletes

rentalFeeUpdateTypes

id increments
description string (50)
isTurnover boolean
timestamps timestamps
softDeletes softDeletes

rentalLegalIndexValues

id increments
feeUpdateType_id ^FK integer
start date
end date
value decimal (7,4)
timestamps timestamps
softDeletes softDeletes

rentalTurnoverIndexValues

id increments
feeUpdateType_id ^FK integer
upperLimit decimal (5,2)
value decimal (7,4)
timestamps timestamps
softDeletes softDeletes

TblDocumentosPrediais

Id integer
process_Id integer
Id_Documento ^FK integer
Ficheiro string (1000)
Caminho string (1500)
AppUser_Id integer
Data datetime
Removido string (2)
Movido boolean
Nexiste string
CopyFailed boolean
Agencia string (50)
AppUser_Numemp string (50)
comment string (255)
sign date
issuing date
payment date
expiration date
delivery date

TblDocumentosPrediais_ID

Id integer
Descricao_Documento string (500)
mandatory boolean
require_sign_date boolean
require_issuing_date boolean
require_payment_date boolean
require_expiration_date boolean
require_delivery_date boolean
direction boolean
multiple boolean
updatable boolean
template_id integer
documentCategory_id ^FK integer

documentCategories

id increments
table string (32)
stage string
timestamps timestamps
softDeletes softDeletes

asset_execution

execution_id ^FK integer
asset_id ^FK integer

paymentMethods

id increments
description string (50)
timestamps timestamps
softDeletes softDeletes

asset_invoice

asset_id ^FK integer
invoice_id ^FK integer
amount decimal (8,2)

rentalContractVersion_rentalUnit

contractVersion_id ^FK integer
unit_id ^FK integer

budgetPeriods

id increments
description string (50)
client_id ^FK integer
start date
end date
timestamps timestamps
softDeletes softDeletes

categoryBudgets

id increments
budgetPeriod_id ^FK integer
client_id ^FK integer
clientCategory_id ^FK integer
amount decimal (10,2)
timestamps timestamps
softDeletes softDeletes

assetBudgets

id increments
budgetPeriod_id ^FK integer
client_id ^FK integer
clientCategory_id ^FK integer
asset_id ^FK integer
amount decimal (10,2)
timestamps timestamps
softDeletes softDeletes

systemParameters

id increments
client_id ^FK integer
module string (20)
name string (10)
value string (255)
description string (255)
timestamps timestamps
softDeletes softDeletes

rentalContractTypes

id increments
description string (50)
timestamps timestamps
softDeletes softDeletes

rentalInternalInvoices

id increments
contractVersion_id ^FK integer
status_id ^FK integer
tenant_id ^FK integer
serie_id ^FK integer
counterpart_id ^FK integer
tenantTaxId string (20)
tenantName string (50)
invoicePeriod integer
processPeriod integer
issued date
due date
manualExpenses boolean
tenantAddress_1 string (50)
tenantAddress_2 string (50)
tenantZip string (10)
tenantCity string (50)
rentAmount decimal (8,2)
otherAmount decimal (8,2)
taxAmount decimal (8,2)
totalAmount decimal (8,2)
timestamps timestamps
softDeletes softDeletes

rentalInvoiceTypes

id increments
description string (50)
timestamps timestamps
softDeletes softDeletes

rentalInvoiceSeries

id increments
owner_id ^FK integer
invoiceType_id ^FK integer
year integer
series string (10)
description string (50)
current integer
timestamps timestamps
softDeletes softDeletes

rentalContracts

id increments
owner_id ^FK integer
description string (255)
start date
end date
timestamps timestamps
softDeletes softDeletes

rentalContractSubstatuses

id increments
description string (50)
timestamps timestamps
softDeletes softDeletes

contact_rentalTenant

tenant_id ^FK integer
contact_id ^FK integer

rentalContractVersionReasons

id increments
description string (50)
timestamps timestamps
softDeletes softDeletes

rentalRentTypes

id increments
description string (50)
timestamps timestamps
softDeletes softDeletes

rentalGuarantees

id increments
contractVersion_id ^FK integer
guaranteeType_id ^FK integer
depositaryType_id ^FK integer
guarantor_id ^FK integer
description string (50)
depositary string (50)
deposit date
expiration date
amount decimal (8,2)
timestamps timestamps
softDeletes softDeletes

rentalGuaranteeTypes

id increments
description string (50)
timestamps timestamps
softDeletes softDeletes

rentalDepositaryTypes

id increments
description string (50)
timestamps timestamps
softDeletes softDeletes

rentalGuarantors

id increments
name string (50)
address_1 string (50)
address_2 string (50)
zip string (10)
city string (50)
county_id ^FK integer
landPhone string (20)
mobilePhone string (20)
email string (100)
timestamps timestamps
softDeletes softDeletes

supplierTypes

id increments
timestamps timestamps
softDeletes softDeletes
description string (50)

rentalInternalInvoiceStatuses

id increments
description string (50)
timestamps timestamps
softDeletes softDeletes

rentalInternalInvoiceLines

id increments
billingConcept_id ^FK integer
invoice_id ^FK integer
description string (50)
amount decimal (8,2)
taxAmount decimal (8,2)
totalAmount decimal (8,2)
timestamps timestamps
softDeletes softDeletes

rentalClientInvoices

id increments
contractVersion_id ^FK integer
internalInvoice_id ^FK integer
issued date
clientInvoiceId string (20)
due date
printed date
printedUser_id ^FK integer
tenantTaxid string (20)
invoicePeriod integer
processPeriod integer
netAmount decimal (8,2)
taxAmount decimal (8,2)
totalAmount decimal (8,2)
paidAmount decimal (8,2)
clearedAmount decimal (8,2)
clearedComment string (250)
timestamps timestamps
softDeletes softDeletes

PROCESS_DETALHES

det_id increments
process_id ^FK integer
det_area_garagem float

TblOutsourcersRelateSGI

process_id increments
Estagio_id integer

rentalPaymentFiles

id increments
paymentFileType_id ^FK integer
description string (250)
timestamps timestamps
softDeletes softDeletes

rentalPaymentFileTypes

id increments
description string (50)
owner_id ^FK integer
timestamps timestamps
softDeletes softDeletes

rentalPayments

id increments
paymentFile_id ^FK integer
received date
paymentAmount decimal (8,2)
paymentEntity string (5)
paymentReference string (20)
conciliatedAmount decimal (8,2)
description string (50)
isPayment boolean
timestamps timestamps
softDeletes softDeletes

rentalClientInvoice_rentalPayment

clientInvoice_id ^FK integer
payment_id ^FK integer
amount decimal (8,2)
description string (250)
conciliated date

rentalPrintDocuments

id increments
document_id ^FK integer
addedUser_id ^FK integer
printedUser_id ^FK integer
addedDate date
printedDate date
timestamps timestamps
softDeletes softDeletes

rentalDepositOptions

id increments
timestamps timestamps
softDeletes softDeletes
description string (50)