Competition Logisch model
Home

Competition Logisch model

Competition Logisch model

Het logische datamodel beschrijft de structuur van en de referenties tussen de logische gegevensobjecten, die meer gelijken op tabellen dan op entiteiten.

Data Structure Diagram

Alle uitleg over de DSD van An Orm Apart vind je op Data Structure Diagram voor An Orm Apart.

Competition

Competitie

ModernWays

Player

Speler

FirstName, LastName
Column Name Display Text Searchable Default Value Unique Type Length Variable International Required Reference Table Reference Column Display Column List HTML element HTML type attribute Reserved HTML pattern attribute HTML title attribute HTML placeholder attribute
FirstName Voornaam NO NO NO CHAR 50 YES YES YES NA NA NA YES INPUT TEXT NA NA NA
LastName Achternaam SELECTX NO NO CHAR 120 YES YES YES NA NA NA YES INPUT TEXT NA NA NA
Email E-mail SELECTX NO NO CHAR 255 YES YES NO NA NA NA NO INPUT EMAIL NA NA jan.jannsens@mail.me
Address1 Adres 1 NO NO NO CHAR 255 YES YES NO NA NA NA NO INPUT TEXT NA NA NA
Address2 Adres 2 NO NO NO CHAR 255 YES YES NO NA NA NA NO INPUT TEXT NA NA NA
PostalCode Postcode NO NO NO CHAR 20 YES NO NO NA NA NA NO INPUT TEXT NA NA NA
City Stad NO NO NO CHAR 80 YES YES NO NA NA NA NO INPUT TEXT NA NA NA
Country Land NO NO NO CHAR 40 YES YES NO NA NA NA NO INPUT TEXT NA NA NA
Phone Telefoon NO NO NO CHAR 25 YES NA NO NA NA NA NO INPUT TEXT NA NA NA
Birthday Geboortedatum NO NO NO DATETIME NA NA NA NO NA NA NA NO INPUT DATE NA NA NA
Id NA NA PK YES Integer NA NA NA Yes NA NA NA YES INPUT HIDDEN NA NA NA
TeamId Team NA NO NO Integer NA NA NA NO Team Id Name NO SELECT NA NA NA NA

Liga

Liga

Name
Column Name Display Text Searchable Default Value Unique Type Length Variable International Required Reference Table Reference Column Display Column List HTML element HTML type attribute Reserved HTML pattern attribute HTML title attribute HTML placeholder attribute
Name Naam SELECTX NO NO CHAR 50 YES YES YES NA NA NA YES INPUT TEXT NA NA NA
Year Jaar SELECTX NO NO CHAR 4 NO NO YES NA NA NA YES INPUT TEXT NA NA NA
IsInPlanning Is in pllaning NA NO NO Boolean NA NA NA NO NA NA NA YES INPUT CHECKBOX
Id NA NA PK YES Integer NA NA NA Yes NA NA NA YES INPUT HIDDEN NA NA NA

Team

Team

Name
Column Name Display Text Searchable Default Value Unique Type Length Variable International Required Reference Table Reference Column Display Column List HTML element HTML type attribute Reserved HTML pattern attribute HTML title attribute HTML placeholder attribute
Name Naam SELECTX NO YES CHAR 50 YES YES YES NA NA NA YES INPUT TEXT NA NA NA
Location Locatie SELECTX NO NO CHAR 50 YES YES YES NA NA NA YES INPUT TEXT NA NA NA
Score Score NA NO NO CHAR 50 YES YES YES NA NA NA YES INPUT TEXT NA NA NA
Id NA NA PK YES Integer NA NA NA Yes NA NA NA YES INPUT HIDDEN NA NA NA

Game

Spel

Column Name Display Text Searchable Default Value Unique Type Length Variable International Required Reference Table Reference Column Display Column List HTML element HTML type attribute Reserved HTML pattern attribute HTML title attribute HTML placeholder attribute
Date Datum NO NO NO DATETIME NA NA NA NO NA NA NA NO INPUT DATE NA NA NA
Id NA NA PK YES Integer NA NA NA Yes NA NA NA YES INPUT HIDDEN NA NA NA
Status Status NA NO NO CHAR 120 YES YES YES NA NA NA YES INPUT TEXT NA NA NA
ScoreHome Thuisteam NA NO NO CHAR 120 YES YES YES NA NA NA YES INPUT TEXT NA NA NA
ScoreVisitors Bezoekersteam NA NO NO CHAR 120 YES YES YES NA NA NA YES INPUT TEXT NA NA NA
TeamHomeId EventCategoryId NA NO NO Integer NA NA NA NO Team Id Name NO SELECT NA NA NA NA
TeamVisitorId Liga NA NO NO Integer NA NA NA NO Team Id Name NO SELECT NA NA NA NA
LigaId Liga NA NO NO Integer NA NA NA NO Liga Id Name NO SELECT NA NA NA NA
JI
2018-12-12 00:17:26