Organization

4 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('"Organization_id_seq"'::regclass)
Announcement.organizationId Implied Constraint R
AnnouncementDetails.organizationId Implied Constraint R
AssignmentResource.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
EmailTemplate.organizationId Implied Constraint R
GradingTemplateMaster.organizationId Implied Constraint R
ItemCategory.organizationId Implied Constraint R
Log.organizationId Log_organizationId_fkey R
Notification.organizationId Implied Constraint R
OrganizationIntegration.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 Implied Constraint R
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

Indexes

Constraint Name Type Sort Column(s)
Organization_pkey Primary key Asc id
Organization_uuid_key Must be unique Asc uuid

Relationships

Close relationships within degrees of separation