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