RdsDiagram
template
id: UUID
createdAt: TIMESTAMP
updatedAt: TIMESTAMP
deletedAt: TIMESTAMP
origen
common
iam
cci
vinipadLicense
oAuth
auditing
CommonLang
id: UUID
name: VARCHAR(255)
image: VARCHAR(255)
iso6392: CHARACTER(2)
iso6393: CHARACTER(3)
ietf: CHARACTER(5)
customCode: VARCHAR(10)
dir: ENUM[LTR,RTL]
sort: SMALLINT.UNSIGNED(6)
isActive: BOOLEAN
createdAt: TIMESTAMP
updatedAt: TIMESTAMP
deletedAt: TIMESTAMP
CommonCountry
id: UUID
iso3166Alpha2: CHARACTER(2)
iso3166Alpha3: CHARACTER(3)
iso3166Numeric: CHARACTER(3)
customCode: VARCHAR(10)
prefix: VARCHAR(5)
image: VARCHAR(1024)
sort: SMALLINT.UNSIGNED(6)
administrativeAreas: JSON
latitude: DECIMAL(17,4)
longitude: DECIMAL(17,4)
zoom: INTEGER.UNSIGNED(2)
dataLang: JSON
createdAt: TIMESTAMP
updatedAt: TIMESTAMP
deletedAt: TIMESTAMP
CommonAdministrativeAreaLevel1
id: UUID
countryId: UUID
code: VARCHAR(8)
customCode: VARCHAR(10)
name: VARCHAR(255)
slug: VARCHAR(255)
latitude: DECIMAL(17,4)
longitude: DECIMAL(17,4)
zoom: INTEGER.UNSIGNED(2)
createdAt: TIMESTAMP
updatedAt: TIMESTAMP
deletedAt: TIMESTAMP
CommonAdministrativeAreaLevel2
id: UUID
countryId: UUID
administrativeAreaLevel1Id: UUID
code: VARCHAR(8)
customCcode: VARCHAR(10)
name: VARCHAR(255)
slug: VARCHAR(255)
latitude: DECIMAL(17,4)
longitude: DECIMAL(17,4)
zoom: INTEGER.UNSIGNED(2)
createdAt: TIMESTAMP
updatedAt: TIMESTAMP
deletedAt: TIMESTAMP
CommonAdministrativeAreaLevel3
id: UUID
countryId: UUID
administrativeAreaLevel1Id: UUID
administrativeAreaLevel2Id: UUID
code: VARCHAR(8)
customCode: VARCHAR(10)
name: VARCHAR(255)
slug: VARCHAR(255)
latitude: DECIMAL(17,4)
longitude: DECIMAL(17,4)
zoom: INTEGER.UNSIGNED(2)
createdAt: TIMESTAMP
updatedAt: TIMESTAMP
deletedAt: TIMESTAMP
AdminResource
id: UUID
boundedContextId: UUID
name: VARCHAR(255)
hasCustomFields: BOOLEAN
hasAttachments: BOOLEAN
createdAt: TIMESTAMP
updatedAt: TIMESTAMP
deletedAt: TIMESTAMP
AdminAttachmentLibrary
id: UUID
name: VARCHAR(255)
pathname: VARCHAR(1024)
filename: VARCHAR(255)
url: VARCHAR(1024)
mime: VARCHAR(50)
extension: VARCHAR(50)
size: INTEGER.UNSIGNED(10)
width: SMALLINT.UNSIGNED(6)
height: SMALLINT.UNSIGNED(6)
data: JSON
createdAt: TIMESTAMP
updatedAt: TIMESTAMP
deletedAt: TIMESTAMP
AdminAttachmentFamily
id: UUID
name: VARCHAR(255)
width: SMALLINT.UNSIGNED(6)
height: SMALLINT.UNSIGNED(6)
fit: ENUM[CROP,WIDTH,HEIGHT,WIDTH_FREE,HEIGHT_FREE]
sizes: JSON
quality: SMALLINT.UNSIGNED(2)
format: ENUM[JPG,PNG,GIF,TIF,BMP,DATA_URL]
createdAt: TIMESTAMP
updatedAt: TIMESTAMP
deletedAt: TIMESTAMP
AdminAttachmentFamiliesResources
attachmentFamilyId: UUID
resourceId: UUID
AdminAttachment
id: UUID
attachableAggregate: VARCHAR(120)
attachableId: UUID
familyId: UUID
sort: SMALLINT.UNSIGNED(6)
libraryId: UUID
libraryFilename: VARCHAR(255)
dataLang: JSON
createdAt: TIMESTAMP
updatedAt: TIMESTAMP
deletedAt: TIMESTAMP
CommonCountryI18N
id: UUID
countryId: UUID
langId: UUID
name: VARCHAR(255)
slug: VARCHAR(1024)
administrativeAreaLevel1: VARCHAR(50)
administrativeAreaLevel2: VARCHAR(50)
administrativeAreaLevel3: VARCHAR(50)
createdAt: TIMESTAMP
updatedAt: TIMESTAMP
deletedAt: TIMESTAMP
origen_partner
id: UUID
name: VARCHAR(255)
social_networks: JSON
description: TEXT
excerpt: TEXT
email: VARCHAR(120)
phone: VARCHAR(120)
fax: VARCHAR(120)
country_common_id: UUID
administrative_area_level_1: UUID
administrative_area_level_2: UUID
administrative_area_level_3: UUID
zip: VARCHAR(10)
locality: VARCHAR(125)
address: VARCHAR(255)
latitude: DECIMAL(17,14)
longitude: DECIMAL(17,14)
created_at: TIMESTAMP
updated_at: TIMESTAMP
deleted_at: TIMESTAMP
IamBoundedContext
id: UUID
name: VARCHAR(255)
root: VARCHAR(30)
sort: SMALLINT.UNSIGNED(6)
isActive: BOOLEAN
createdAt: TIMESTAMP
updatedAt: TIMESTAMP
deletedAt: TIMESTAMP
IamPermission
id: ID
name: VARCHAR(255)
boundedContextId: UUID
createdAt: TIMESTAMP
updatedAt: TIMESTAMP
deletedAt: TIMESTAMP
IamPermissionsRoles
permissionId: UUID
roleId: UUID
IamRole
id: UUID
name: VARCHAR(255)
isMaster: BOOLEAN
createdAt: TIMESTAMP
updatedAt: TIMESTAMP
deletedAt: TIMESTAMP
CciSystem
id: UUID
tenantId: INTEGER.UNSIGNED(0)
tenantCode: VARCHAR(50)
name: VARCHAR(20)
environment: VARCHAR(20)
technology: VARCHAR(20)
isActive: BOOLEAN
cancelledAt: TIMESTAMP
createdAt: TIMESTAMP
updatedAt: TIMESTAMP
deletedAt: TIMESTAMP
AdminAttachmentI18n
id: UUID
attachmentId: UUID
langId: UUID
alt: VARCHAR(255)
title: VARCHAR(255)
description: TEXT
excerpt: TEXT
name: VARCHAR(255)
pathname: VARCHAR(1024)
filename: VARCHAR(255)
url: VARCHAR(1024)
mime: VARCHAR(50)
extension: VARCHAR(50)
size: INTEGER.UNSIGNED(10)
width: SMALLINT.UNSIGNED(6)
height: SMALLINT.UNSIGNED(6)
libraryId: UUID
libraryFilename: VARCHAR(255)
data: JSON
createdAt: TIMESTAMP
updatedAt: TIMESTAMP
deletedAt: TIMESTAMP
IamAccount
id: UUID
type: ENUM[USER,SERVICE]
code: VARCHAR(50)
email: VARCHAR(100)
isActive: BOOLEAN
clientId: UUID
scopes: JSON
dApplicationCodes: JSON
dPermissions: JSON
dTenants: JSON
meta: JSON
createdAt: TIMESTAMP
updatedAt: TIMESTAMP
deletedAt: TIMESTAMP
IamTenant
id: UUID
name: VARCHAR(255)
code: VARCHAR(50)
logo: VARCHAR(255)
isActive: BOOLEAN
meta: JSON
createdAt: TIMESTAMP
updatedAt: TIMESTAMP
deletedAt: TIMESTAMP
VinipadLicenseCustomer
id: ID
code: VARCHAR(50)
tenantId!: ID
name!: VARCHAR(255)
logo: VARCHAR(255)
countryId: ID
administrativeAreaLevel1Id: ID
administrativeAreaLevel2Id: ID
administrativeAreaLevel3Id: ID
locality: VARCHAR(127)
zip: VARCHAR(31)
address: VARCHAR(255)
isActive: BOOLEAN
data: JSON
createdAt: TIMESTAMP
updatedAt: TIMESTAMP
deletedAt: TIMESTAMP
VinipadLicenseLicense
id: ID
code: VARCHAR(50)
customerId: ID
name: VARCHAR(255)
license: VARCHAR(127)
logo: VARCHAR(255)
shortDescription: JSON
description: JSON
awards: JSON
countryId: ID
administrativeAreaLevel1Id: ID
administrativeAreaLevel2Id: ID
administrativeAreaLevel3Id: ID
locality: VARCHAR(127)
zip: VARCHAR(31)
address: VARCHAR(255)
longitude: DECIMAL(9,6)
latitude: DECIMAL(8,6)
zoom: TINYINT(2)
isActive: BOOLEAN
startAt: TIMESTAMP
endAt: TIMESTAMP
data: JSON
createdAt: TIMESTAMP
updatedAt: TIMESTAMP
deletedAt: TIMESTAMP
IamUser
id: UUID
accountId: UUID
name: VARCHAR(50)
surname: VARCHAR(100)
avatar: VARCHAR(255)
mobile: VARCHAR(50)
langId: UUID
username: VARCHAR(100)
password: VARCHAR(255)
rememberToken: VARCHAR(255)
data: JSON
createdAt: TIMESTAMP
updatedAt: TIMESTAMP
deletedAt: TIMESTAMP
OAuthApplication
id: UUID
code: VARCHAR(50)
name: VARCHAR(255)
secret: VARCHAR(90)
isMaster: BOOLEAN
createdAt: TIMESTAMP
updatedAt: TIMESTAMP
deletedAt: TIMESTAMP
IamTenantsAccounts
tenantId: UUID
accountId: UUID
IamRolesAccounts
roleId: UUID
accountId: UUID
OAuthClient
id: UUID
grantType: VARCHAR(50)
name: VARCHAR(255)
secret: VARCHAR(90)
authUrl: VARCHAR(2048)
redirect: VARCHAR(2048)
scopeOptions: JSON
expiredAccessToken: INTEGER.UNSIGNED(10)
expiredRefreshToken: INTEGER.UNSIGNED(10)
isActive: BOOLEAN
isMaster: BOOLEAN
createdAt: TIMESTAMP
updatedAt: TIMESTAMP
deletedAt: TIMESTAMP
VinipadLicenseUserLicense
id: ID
userId: VARCHAR(50)
licenseId: ID
OAuthAccessToken
id: UUID
clientId: UUID
accountId: UUID
token: TEXT
name: VARCHAR(255)
isRevoked: BOOLEAN
expiresAt: TIMESTAMP
createdAt: TIMESTAMP
updatedAt: TIMESTAMP
deletedAt: TIMESTAMP
OAuthRefreshToken
id: UUID
accessTokenId: UUID
token: TEXT
isRevoked: BOOLEAN
expiresAt: TIMESTAMP
created_at: TIMESTAMP
updated_at: TIMESTAMP
deleted_at: TIMESTAMP
OAuthApplicationsClients
applicationId: UUID
clientId: UUID
OAuthScope
id: UUID
code: VARCHAR(20)
name: VARCHAR(255)
audit
id: UUID
accountId: UUID
accountEmail: VARCHAR(100)
event: VARCHAR(255)
url: TEXT
ipAddress: VARCHAR(15)
oldValues: JSON
newValues: JSON
userAgent: VARCHAR(1023)
created_at: TIMESTAMP
updated_at: TIMESTAMP
deleted_at: TIMESTAMP