Appbogado System

For development:

install dependencies

pnpm install

start the development server

pnpm run dev

build the project

pnpm run build

Publish the project

First add to the version in dockflow.json

pnpm run docker:publish

Database Tables documentation

dim_abogados [Main Lawyers Table]

• rut (string): Lawyer's RUT (National ID)*
• nombre (string): Lawyer's name
• apellido (string): Lawyer's last name
• mail (string): Lawyer's email address
• telefono (string): Lawyer's phone number
• horario_at_dias_hab *(string): Needs to be removed
• horario_at_horas_hab *(string): Needs to be removed
• nivel_coincidencia (Integer): Lawyer's matching level with the search criteria
• region (string): Lawyer's region
• comuna (string): Lawyer's commune
• verificado *(string): Lawyer's verification status
  • "activo": Lawyer is VERIFIED
  • "no activo": Lawyer is NOT VERIFIED
• fecha_vigencia (Timestamp/string): Lawyer's subscription expiration date
• (New!) fecha_registro (Timestamp): Lawyer's registration date

dim_ambitos [Lawyer's Areas of Expertise Table (NAMES)]

• id_ambito (Integer): Area of expertise ID
• desc_ambito (string): Area of expertise name
• desc_grupo (string): Group name of the area of expertise

dim_comunas_chile [Chilean Communes Table]

• cut (Integer): Commune code
• comuna (string): Commune name
• provincia (string): Province name
• region (string): Region name
• latitud (float): Latitude of the commune
• longitud (float): Longitude of the commune

dim_credenciales [Needs to be removed]

dim_validados [Needs to be removed]

ft_ambitos [Lawyer's Areas of Expertise Table (POINTERS)]

• id_rut_ambito (string): Lawyer's RUT + Area of expertise ID
• rut (string): Lawyer's RUT (National ID)
• id_ambito (Integer): Area of expertise ID

ft_solicitudes [Requests Table]

• id_solicitud (UUID): Request ID
• rut (string): Lawyer's RUT (National ID)
• nombres (string): Requester's first name
• apellidos (string): Requester's last name
• mail (string): Requester's email address
• region (string): Requester's region
• comuna (string): Requester's commune
• caso (string): Requester's case description
• tipo_costo (string): Need to be removed
• tipo_requerimiento (string): Need to be removed
• antecedentes_penales (string): Need to be removed
• antecedentes_comerciales (string): Need to be removed
• (NEW!) fecha_registro (Timestamp): Request registration date
• (New!) telefono (string): Requester's phone number

ft_envios [Successful Lawyer-Client Matches Table]

• id_envio (UUID): Match ID (Refer to ft_solicitudes: id_solicitud)
• id_operacion (UUID): Request ID
• envio (string): Lawyer's RUT (National ID)
• fecha_envio (Timestamp): Match date

ft_casos_perdidos [Unsuccessful Lawyer-Client Matches Table]

• id_caso_perdido (UUID): Unsuccessful match ID (Refer to ft_solicitudes: id_solicitud)
• id_operacion (UUID): Request ID
• envio (string): Lawyer's RUT (National ID)
• fecha_envio (Timestamp): Unsuccessful match date

Database Quick-Management Commands

[ vigencia:set ] will set the subscription expiration date to THE CURRENT DATE + X MONTHS.

While [ vigencia:add ] will add or subtract X MONTHS from the current expiration date.

pnpm vigencia:set  1  "12.345.567-8"   # Sets expiration date to 1 month from NOW
pnpm vigencia:add -2  "12345678-9"     # subtract 2 months from current value
pnpm vigencia:check  "12345678-9"      # check the last date of a lawyer's subscription

pnpm verificado:set 0 "12345678-9"     # flag 0 → "no activo", flag 1 → "activo"
pnpm verificado:check  "12345678-9"    # check if a lawyer is verified or not

Data Management Commands

pnpm --filter "./server" run dataTest -- tableName