Skip to content

Instantly share code, notes, and snippets.

@DannyFeliz
Created March 26, 2021 20:55
Show Gist options
  • Save DannyFeliz/e1d2acdb64abd72218b961d2e100c3b8 to your computer and use it in GitHub Desktop.
Save DannyFeliz/e1d2acdb64abd72218b961d2e100c3b8 to your computer and use it in GitHub Desktop.
entidades.md

Requerimientos

Entidades

El nombre de las tablas debe estar en plural, por ejemplo: Users, Currencies, Companies, ...

Company ✅

Columna Tipo Características
Id int identity, primary key, autoincrement, Not null
CreatedAt DateTime Not null
UpdatedAt DateTime Not null
DeletedAt DateTime Nullable
IsActive boolean Not null
Name varchar(255) Not null
Website varchar(255) Not null
Description varchar(8000) Not null
UserId int Not null
PictureId int Not null

Currency ✅

Columna Tipo Características
Id int identity, primary key, autoincrement, Not null
CreatedAt DateTime Not null
UpdatedAt DateTime Not null
DeletedAt DateTime Nullable
IsActive Boolean Not null
Name varchar(255) Not null
Symbol varchar(10) Not null
ISOCode varchar(10) Not null

Job ✅

Columna Tipo Características
Id int identity, primary key, autoincrement, Not null
CreatedAt DateTime Not null
UpdatedAt DateTime Not null
DeletedAt DateTime Nullable
IsActive Boolean Not null
LocationId int Not null
CompanyId int Not null
UserId int Not null
CurrencyId int Nullable
PaymentTypeId int Nullable
JobTypeId int Not null
LevelId int Not null
Description varchar(8000) Not null
HowToApply varchar(8000) Not null
MinSalary double Nullable
MaxSalary double Nullable
IsRemote Boolean Not null
IsRemoteOnly Boolean Not null

JobType ✅

Columna Tipo Características
Id int identity, primary key, autoincrement, Not null
CreatedAt DateTime Not null
UpdatedAt DateTime Not null
DeletedAt DateTime Nullable
IsActive Boolean Not null
Name varchar(255) Not null

Level ✅

Columna Tipo Características
Id int identity, primary key, autoincrement, Not null
CreatedAt DateTime Not null
UpdatedAt DateTime Not null
DeletedAt DateTime Nullable
IsActive Boolean Not null
Name varchar(255) Not null

Location ✅

Columna Tipo Características
Id int identity, primary key, autoincrement, Not null
CreatedAt DateTime Not null
UpdatedAt DateTime Not null
DeletedAt DateTime Nullable
IsActive Boolean Not null
Name varchar(8000) Not null
Latitude varchar(8000) Not null
Longitude varchar(8000) Not null

User ✅

Columna Tipo Características
Id int identity, primary key, autoincrement, Not null
CreatedAt DateTime Not null
UpdatedAt DateTime Not null
DeletedAt DateTime Nullable
IsActive Boolean Not null
Name varchar(255) Not null
Email varchar(255) Not null
Password varchar(255) Not null

PaymentType ✅

Columna Tipo Características
Id int identity, primary key, autoincrement, Not null
CreatedAt DateTime Not null
UpdatedAt DateTime Not null
DeletedAt DateTime Nullable
IsActive Boolean Not null
Name varchar(255) Not null

Picture

TODO: NO hay que implementar ahora mismo

Columna Tipo Características
Id int identity, primary key, autoincrement, Not null
CreatedAt DateTime Not null
UpdatedAt DateTime Not null
DeletedAt DateTime Nullable
IsActive Boolean Not Null
FileName varchar(255) Not null
Data byte array(MAX) Not null

Tag ✅

Columna Tipo Características
Id int identity, primary key, autoincrement, Not null
CreatedAt DateTime Not null
UpdatedAt DateTime Not null
DeletedAt DateTime Nullable
IsActive Boolean Not Null
Name varchar(255) Not null
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment