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¶
Generated by tbls