tbl_userlogin_bkp2023121

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
userid varchar 500 √ null
password varchar 100 √ null
logintype int4 10 √ null
systemadmin bool 1 √ null
fullaccess bool 1 √ null
branchaccess bool 1 √ null
loginstatus bool 1 √ null
logindate timestamp 29,6 √ null
roleid int4 10 √ null
tbl_rolemaster.roleid Implied Constraint R
companyid int4 10 √ null
tbl_companymaster.companyid Implied Constraint R
lastloginattemptime timestamp 29,6 √ null
faillastattempt int4 10 √ null
reason varchar 255 √ null
tenantname varchar 50 √ null
id int4 10 √ null
firebasetoken varchar 500 √ null
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null

Relationships

Close relationships within degrees of separation