Skip to content

Latest commit

 

History

History
206 lines (150 loc) · 7.3 KB

Data_Dictionary.md

File metadata and controls

206 lines (150 loc) · 7.3 KB

📕 Data Dictionary

In this section, the metadata of the proposed model is documented, classified by entities.
Glosary
Id Description
PK Primary Key
FK Foreign Key
N/A Non-Aplicable
AI Auto-Incremental
CDT Currend date and time



dbo Scheme

  • Data Dictionary from BingoCages entity
Name Type of field Length Allows Null Deffautlt value Constrain Description
Id bigint 8 bytes No Si AI PK of the BingoCage entity
GameId int 4 bytes No N/A N/A FK of the Game entity
Number int 4 bytes No N/A N/A Number of the draw ball
Creatd datetime 8 bytes No N/A N/A CDT of the a draw ball

  • Data Dictionary from BingoCards entity
Name Type of field Length Allows Null Deffautlt value Constrain Description
Id bigint 8 bytes No Si AI PK of the BingoCage entity
GameId int 4 bytes No N/A N/A FK of the Game entity
Card tinyint 1 bytes No N/A N/A Number of the bingo card
Numbers varchar 100 bytes No N/A N/A String with the numbers of the bingo card
OrderedN varchar 100 bytes No N/A N/A String with the numbers and the blanks of the bingo card
Completed bit 1 bytes No N/A N/A CDT of the a bingo card

  • Data Dictionary from BingoCardNumbers entity
Name Type of field Length Allows Null Deffautlt value Constrain Description
Id bigint 8 bytes No Si AI PK of the BingoCage entity
BingoCardId bigint 8 bytes No Si AI FK of the BingoCards entity
Number tinyint 1 bytes No N/A N/A Number in the bingo card
Called bit 1 bytes No N/A N/A Status in the game

  • Data Dictionary from GStatus entity
Name Type of field Length Allows Null Deffautlt value Constrain Description
Id tinyint 1 bytes No Si AI PK of the GStatus entity
Status varchar 25 bytes No N/A N/A Name of the game status

  • Data Dictionary from Roles entity
Name Type of field Length Allows Null Deffautlt value Constrain Description
Id tinyint 1 bytes No Si AI PK of the Role entity
Role varchar 25 bytes No N/A N/A Name of the role

  • Data Dictionary from UStatus entity
Name Type of field Length Allows Null Deffautlt value Constrain Description
Id tinyint 1 bytes No Si AI PK of the UStatus entity
Status varchar 25 bytes No N/A N/A Name of the user status

  • Data Dictionary from Users entity
Name Type of field Length Allows Null Deffautlt value Constrain Description
Id int 4 bytes No Si AI PK of the GState entity
StatusId tinyint 1 bytes No N/A N/A FK of the UStatus entity
User varchar 25 bytes No N/A N/A Name of the user
Email varchar 50 bytes No N/A N/A Name of the user's email
Password varchar 64 bytes No N/A N/A User's password
PassTemp varchar 64 bytes No N/A N/A User's temporal password
Created datetime 8 bytes No N/A N/A CDT of the a user

  • Data Dictionary from UserRoles entity
Name Type of field Length Allows Null Deffautlt value Constrain Description
Id int 4 bytes No Si AI PK of the UserRole entity
UserId int 4 bytes No N/A N/A FK of the User entity
RoleId tinyint 1 bytes No N/A N/A FK of the Role entity

  • Data Dictionary from Games entity
Name Type of field Length Allows Null Deffautlt value Constrain Description
Id int 1 bytes No Si AI PK of the Game entity
UserId int 4 bytes No N/A N/A FK of the User entity
StatusId tinyint 1 bytes No N/A N/A FK of the GStatus entity
Start datetime 8 bytes No N/A N/A CDT of the game
End datetime 8 bytes Yes N/A N/A Date and time of the game ends
Status tinyint 1 bytes No N/A N/A Number of the migrated status

Replica Scheme

  • Data Dictionary from BingoCage entity
Name Type of field Length Allows Null Deffautlt value Constrain Description
Id bigint 8 bytes No Si AI PK of the BingoCage entity
GameId int 4 bytes No N/A N/A FK of the Game entity
Number int 4 bytes No N/A N/A Number of the draw ball
Creatd datetime 8 bytes No N/A N/A CDT of the a draw ball

  • Data Dictionary from BingoCard entity
Name Type of field Length Allows Null Deffautlt value Constrain Description
Id bigint 8 bytes No Si AI PK of the BingoCage entity
GameId int 4 bytes No N/A N/A FK of the Game entity
Card tinyint 1 bytes No N/A N/A Number of the bingo card
Numbers varchar 100 bytes No N/A N/A String with the numbers of the bingo card
OrderedN varchar 100 bytes No N/A N/A String with the numbers and the blanks of the bingo card
Completed bit 1 bytes No N/A N/A CDT of the a bingo card

  • Data Dictionary from Game entity
Name Type of field Length Allows Null Deffautlt value Constrain Description
Id int 1 bytes No Si AI PK of the Game entity
UserId int 4 bytes No N/A N/A FK of the User entity
StatusId tinyint 1 bytes No N/A N/A FK of the GStatus entity
Start datetime 8 bytes No N/A N/A CDT of the game
End datetime 8 bytes Yes N/A N/A Date and time of the game ends
Winners varchar 25 bytes No N/A N/A Card Number of the completed bingo cards



◀️ Return