tbl_userlogin

7 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
userid varchar 500 null
password varchar 100 null
logintype int4 10 null
tbl_userroletypemaster.id fk__tbl_userl__login__4bdfe46f R
systemadmin bool 1 √ false
fullaccess bool 1 √ null
branchaccess bool 1 √ null
loginstatus bool 1 √ true
logindate timestamp 29,6 √ null
roleid int4 10 1
tbl_rolemaster.roleid fk__tbl_userl__rolei__50a4998c R
companyid int4 10 √ null
tbl_companymaster.companyid Implied Constraint R
lastloginattemptime timestamp 29,6 √ null
faillastattempt int4 10 √ 0
reason varchar 255 √ ''''''::character varying
tenantname varchar 50 √ ''''''::character varying
id serial 10 √ nextval('tbl_userlogin_id_seq'::regclass)
tbl_userrolemaster.ulid fk__tbl_userro__ulid__54752a70 R
firebasetoken varchar 500 √ null
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null
lastresettokenhash text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
tbl_userlogin_pk__tbl_user__3213e83ff84ef8ba Primary key Asc id

Relationships

Close relationships within degrees of separation