StudentNotes

7 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('"StudentNotes_id_seq"'::regclass)
uuid uuid 2147483647 gen_random_uuid()
studentId uuid 2147483647 null
User.uuid StudentNotes_studentId_fkey C
title varchar 255 √ ''::character varying
content text 2147483647 √ ''::text
color varchar 50 '#FFE9A0'::character varying
isHidden bool 1 √ false
positionX float8 17,17 100
positionY float8 17,17 100
width float8 17,17 √ 280
height float8 17,17 √ 200
zIndex int4 10 √ 0
bindingTags jsonb 2147483647 √ '[]'::jsonb
customTags jsonb 2147483647 √ '[]'::jsonb
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
StudentNotes_pkey Primary key Asc id
idx_student_notes_binding_tags Performance Asc bindingTags
idx_student_notes_custom_tags Performance Asc customTags
idx_student_notes_student_id Performance Asc studentId
idx_student_notes_student_id_is_hidden Performance Asc/Asc studentId + isHidden
StudentNotes_uuid_key Must be unique Asc uuid

Relationships

Close relationships within degrees of separation