LiveRooms


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 public.gen_random_uuid()
BannedLiveRoomUsers.LiveRoomId BannedLiveRoomUsers_LiveRoomId_fkey C
LiveRoomHosts.LiveRoomId LiveRoomHosts_LiveRoomId_fkey C
LiveRoomReminders.LiveRoomId LiveRoomReminders_LiveRoomId_fkey C
LiveRoomShares.RoomId LiveRoomShares_RoomId_fkey C
name text 2147483647 null
maxParticipants int4 10 null

Maximum participants allowed in the room.
TopicId int4 10 null
LiveRoomTopics.id LiveRooms_TopicId_fkey R
startsAt timestamptz 35,6 null
endsAt timestamptz 35,6 null
createdAt timestamptz 35,6 null
updatedAt timestamptz 35,6 null
CompanyId uuid 2147483647 √ null
Companies.id LiveRooms_CompanyId_fkey C
showJobOpenings bool 1 √ true

Indexes

Constraint Name Type Sort Column(s)
LiveRooms_pkey Primary key Asc id
LiveRooms_endsAt_idx Performance Asc endsAt
LiveRooms_startsAt_idx Performance Asc startsAt

Check Constraints

Constraint Name Constraint
LiveRooms_maxParticipants_check (("maxParticipants" >= 0))

Relationships

Close relationships within degrees of separation