Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int8 | 19 | √ | null |
|
|
|||||
| file_id | int8 | 19 | null |
|
|
||||||
| created_by | int8 | 19 | null |
|
|
||||||
| created_time | timestamptz | 35,6 | null |
|
|
||||||
| modified_by | int8 | 19 | null |
|
|
||||||
| modified_time | timestamptz | 35,6 | null |
|
|
||||||
| title | text | 2147483647 | null |
|
|
The text that displays at the top of the annotation box after it is clicked. |
|||||
| body_text | text | 2147483647 | √ | null |
|
|
The text that displays in the annotation box after it is clicked. |
||||
| label | text | 2147483647 | √ | null |
|
|
The text that displays over the annotations while it’s floating in space. |
||||
| position_x | numeric | 0 | null |
|
|
||||||
| position_y | numeric | 0 | null |
|
|
||||||
| position_z | numeric | 0 | null |
|
|
||||||
| camera_position_x | numeric | 0 | √ | null |
|
|
|||||
| camera_position_y | numeric | 0 | √ | null |
|
|
|||||
| camera_position_z | numeric | 0 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| splat_annotations_pkey | Primary key | Asc | id |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| camera_position_all_or_none | (((camera_position_x IS NULL) AND (camera_position_y IS NULL) AND (camera_position_z IS NULL)) OR ((camera_position_x IS NOT NULL) AND (camera_position_y IS NOT NULL) AND (camera_position_z IS NOT NULL))) |