Skip to content

public.location

Description

Columns

Name Type Default Nullable Children Parents Comment
id uuid false Unique identifier for the location(DC2Type:uuid)
created_at timestamp(0) with time zone false Timestamp when the location was created(DC2Type:datetimetz_immutable)
name varchar(255) false Name or description of the location
position_latitude numeric(9,7) false Latitude coordinate of the geographic position (decimal degrees).
position_longitude numeric(9,7) false Longitude coordinate of the geographic position (decimal degrees).

Constraints

Name Type Definition
location_pkey PRIMARY KEY PRIMARY KEY (id)

Indexes

Name Definition
location_pkey CREATE UNIQUE INDEX location_pkey ON public.location USING btree (id)

Relations

er


Generated by tbls