tbl_moodmeterdata

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('tbl_moodmeterdata_id_seq'::regclass)
employeeid varchar 500 null
tbl_employee.employeeid Implied Constraint R
companyid int4 10 null
tbl_companymaster.companyid Implied Constraint R
date date 13 √ null
departmentid int8 19 null
mood varchar 50 √ null
reason varchar 500 √ null
description varchar 2147483647 √ null
question varchar 2147483647 √ null
weightage int4 10 √ null
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null

Indexes

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

Relationships

Close relationships within degrees of separation