Public Abstract classAccountrole//This is an inheritance type {[Key] Public intID {Get;Set; } Public BOOLisdisabled {Get;Set; } Public stringemail {Get;Set; } Public stringRemark {Get;Set; } Public stringFirstName {Get;Set; } Public stringLastName {Get;Set; } Public stringTASKSS {Get;Set; } [ForeignKey (" Account")] Public intaccounts_id {Get;Set; } Public VirtualAccount Account {Get;Set; } [Databasegenerated (databasegeneratedoption.computed)] PublicDateTimeOffset ROWCREATEDDT {Get;Set; } [Databasegenerated (databasegeneratedoption.computed)] [Concurrencycheck] Public byte[] RowVersion {Get;Set; } [ForeignKey ("Rowcreator")] Public int? rowcreatorloginaccounts_id {Get;Set; } [ForeignKey ("Rowlastmodifiedby")] Public int? rowlastmodifiedbyloginaccounts_id {Get;Set; } Public VirtualLoginaccount Rowcreator {Get;Set; } Public VirtualLoginaccount Rowlastmodifiedby {Get;Set; } } Public classmemberrole:accountrole//memberrole inheritance accountrole { PublicMemberrole () {Businessresultcomplex=NewBusinessresultcomplex {}; Monthlytaskcomplex=NewMonthlytaskcomplex {}; } Public stringInvestororib {Get;Set; } Public stringMt4id {Get;Set; } Public stringFullName {Get;Set; } PublicDateTime dateOfBirth {Get;Set; } Public stringAlternativeemail {Get;Set; } Public stringContactnumber {Get;Set; } Public stringGender {Get;Set; } PublicBeneficiarycomplex Beneficiarycomplex {Get;Set; } Complex Type PublicAddresscomplex Addresscomplex {Get;Set; } PublicBankcomplex Bankcomplex {Get;Set; } PublicBusinessresultcomplex Businessresultcomplex {Get;Set; } PublicMonthlytaskcomplex Monthlytaskcomplex {Get;Set; } PublicDateTimeOffset Lastlogindt {Get;Set; }//datetime Primitive Type PublicDateTime Ttdate {Get;Set; } Date primitive Type [ForeignKey ("CurrentLevel")] Public intlevels_id {Get;Set; } PublicMembermlmrelationtree Mlmrelationtree {Get;Set; } PublicBankbalance Bankbalance {Get;Set; } PublicLevel CurrentLevel {Get;Set; } PublicListGet;Set; } PublicListGet;Set; } PublicListGet;Set; } PublicList<withdrawal> Withdrawals {Get;Set; } PublicList<membercontract> Contracts {Get;Set; } } Public classHistorylogin:rowinfo {[Key] Public intID {Get;Set; } [ForeignKey ("member")] Public intmembers_id {Get;Set; } PublicMemberrole Member {Get;Set; } }
Efdb is the structure of SQL, everyone is type (class), but sometimes there is a lot of repetition, so there will be inheritance (abstract)
Primitive types are string, int, datetime, date
There can be other types in the type, if the type is complex is a collection (specification), list (which is a many-to-many or one-to-many relationship), enum
Efdb Basic Specifications & Knowledge