Myaa - Logisch model
Home

Myaa - Logisch model

Myaa - 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.

StemEffect33

Stem Effect

ModernWays

Person

Persoon

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 SELECTBY NO NO CHAR 120 YES YES YES NA NA NA YES INPUT TEXT NA NA NA
Address Adres 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 80 YES YES NO NA NA NA NO INPUT TEXT NA NA NA
Email E-mail SELECTBY NO NO CHAR 255 YES YES NO NA NA NA NO INPUT EMAIL NA NA jan.jannsens@mail.me
Gender Geslacht NO NO NO CHAR 1 NO NO NO NA Id NA NO INPUT TEXT NA NA NA
Phone1 Telefoon 1 NO NO NO CHAR 25 YES NA NO NA NA NA NO INPUT TEXT NA NA NA
Phone2 Telefoon 2 NO NO NO CHAR 25 YES NA NO NA NA NA NO INPUT TEXT NA NA NA
Id NA NA PK YES Integer NA NA NA Yes NA NA NA YES INPUT HIDDEN NA NA NA

Role

Rol

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 SELECTBY NO YES 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

User

Gebruiker

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 SELECTBY NO YES CHAR 50 YES YES YES NA NA NA YES INPUT TEXT NA NA NA
HashedPassword Hash NA NO NO CHAR 255 YES YES NO NA NA NA YES INPUT TEXT NA NA NA
PersonId Persoon Id NA NO NO Integer NA NA NA NO Person Id FirstName, LastName NO SELECT NA NA NA NA
RoleId Rol Id NA NO NO Integer NA NA NA NO Role Id Name NO SELECT NA NA NA NA
Id NA NA PK YES Integer NA NA NA Yes NA NA NA YES INPUT HIDDEN NA NA NA

JI
2020-06-19 17:24:55