Organization

6 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('"Organization_id_seq"'::regclass)
Announcement.organizationId Announcement_organizationId_fkey R
AnnouncementDetails.organizationId Implied Constraint R
AppInfo.organizationId Implied Constraint R
AssignmentResource.organizationId Implied Constraint R
BiometricBuilding.organizationId Implied Constraint R
BiometricDevice.organizationId Implied Constraint R
BiometricRoom.organizationId Implied Constraint R
BiometricRoomDevice.organizationId Implied Constraint R
Category.organizationId Implied Constraint R
ClubType.organizationId Implied Constraint R
CourseClass.organizationId Implied Constraint R
CourseMaster.organizationId Implied Constraint R
CourseMode.organizationId Implied Constraint R
CourseTag.organizationId Implied Constraint R
CourseType.organizationId Implied Constraint R
EmailSequence.organizationId Implied Constraint R
EmailTemplate.organizationId Implied Constraint R
GradingTemplateMaster.organizationId Implied Constraint R
ItemCategory.organizationId Implied Constraint R
LeaveManagement.organizationId Implied Constraint R
Log.organizationId Log_organizationId_fkey R
Notification.organizationId Implied Constraint R
OrganizationIntegration.organizationId Implied Constraint R
Pedagogy.organizationId Implied Constraint R
PlacementLevel.organizationId Implied Constraint R
Policy.organizationId Implied Constraint R
ProgramMaster.organizationId Implied Constraint R
ReachOut.organizationId Implied Constraint R
Resource.organizationId Implied Constraint R
Role.organizationId Implied Constraint R
TempRecord.organizationId Implied Constraint R
User.organizationId User_organizationId_fkey C
uuid uuid 2147483647 null
name varchar 255 null
SequelizeMeta.name Implied Constraint R
description text 2147483647 √ null
websiteUrl varchar 255 √ null
logoUrl varchar 255 √ null
address varchar 255 √ null
city varchar 255 √ null
state varchar 255 √ null
pinCode varchar 255 √ null
isDeleted bool 1 √ false
createdAt timestamptz 35,6 √ null
updatedAt timestamptz 35,6 √ null
domainName json 2147483647 √ null
metaDetails json 2147483647 √ null
json 2147483647 √ null
json 2147483647 √ null
faviconIcons json 2147483647 √ null
selectedAdminTheme json 2147483647 √ '[{"primary":"#1BA9A0","background":"#FBF9F7","heading":"#222631","subText":"#4A4A68","neutral":"#fff"}]'::json
selectedStudentTheme json 2147483647 √ '[{"primary":"#F2BD65","background":"#7B98FF","heading":"#00C1A0","subText":"#fff","neutral":"#0E0E0E"}]'::json
allAdminThemes json 2147483647 √ null
allStudentThemes json 2147483647 √ null
termsAndConditionUrl varchar 255 √ null
privacyPolicyLink varchar 255 √ null
shortName varchar 255 √ null
coachName varchar 255 √ null
lifeAtLarge varchar 255 √ null
lifeAtShort varchar 255 √ null
termAndConditionMessage varchar 255 √ null
ThemeVariables json 2147483647 √ null
loader json 2147483647 √ null
defaultStudentTheme json 2147483647 '{"default":{"primary":"#F2BD65","heading":"#1C1C1C","neutral":"#030303","background":"#0E0E0E"},"othertheme":[{"primary":"#7B98FF","heading":"#252832","neutral":"#030303","background":"#0E0E0E"},{"primary":"#B5F827","heading":"#1C291A","neutral":"#030303","background":"#0E0E0E"},{"primary":"#00C1A0","heading":"#182526","neutral":"#030303","background":"#0E0E0E"},{"primary":"#F28D30","heading":"#28231F","neutral":"#030303","background":"#0E0E0E"}]}'::json
defaultAdminTheme json 2147483647 '{"default":{"primary":"#1BA9A0","heading":"#FBF9F7","neutral":"#222631","background":"#FBF9F7"},"othertheme":[{"primary":"#7B98FF","heading":"#E5EAFF","neutral":"#222631","background":"#F7F7F7"},{"primary":"#0075FF","heading":"#EDF5FF","neutral":"#222631","background":"#F7F7F7"},{"primary":"#894325","heading":"#FFEFE9","neutral":"#222631","background":"#F7F7F7"},{"primary":"#F28D30","heading":"#FFF0E5","neutral":"#222631","background":"#F7F7F7"}]}'::json
fontStyle varchar 255 √ null
zoomHostEmails json 2147483647 √ null
timezone varchar 255 √ 'Asia/Mumbai'::character varying
zoomAttendancePercentage int4 10 √ 70
guesstimateLink varchar 255 √ null
quizTemplateLink varchar 255 √ null
caseStudyLink varchar 255 √ null
linkedinLink varchar 255 √ null
instagramLink varchar 255 √ null
departmentheadLink varchar 255 √ null
qrTimer int4 10 √ 30
doubtSettings jsonb 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
Organization_pkey Primary key Asc id
Organization_id_idx Performance Asc id
Organization_uuid_idx Performance Asc uuid
Organization_uuid_key Must be unique Asc uuid
Organization_uuid_key1 Must be unique Asc uuid
Organization_uuid_key2 Must be unique Asc uuid
Organization_uuid_key3 Must be unique Asc uuid
Organization_uuid_key4 Must be unique Asc uuid
Organization_uuid_key5 Must be unique Asc uuid
Organization_uuid_key6 Must be unique Asc uuid

Relationships

Close relationships within degrees of separation