Skip to content
This repository has been archived by the owner on Aug 1, 2024. It is now read-only.

Initial postgresql database structure #129

Closed
bariela opened this issue May 12, 2022 · 0 comments
Closed

Initial postgresql database structure #129

bariela opened this issue May 12, 2022 · 0 comments

Comments

@bariela
Copy link
Collaborator

bariela commented May 12, 2022

When starting postgresql database, create initial tables, too

Tables:

layer_geo_data

reference_id PK
format
geo_data_url
data JSONB
metadata JSONB
created_at
updated_at

map_layers

reference_id PK
geo_reference_id (FK from layer_geo_data)
layer_type
category
title
attribute_id (FK from attributes)
attribute_description JSONB
styles JSONB
legend JSONB
layer_options JSONB
created_at
updated_at

attributes

attribute_id PK
attribute_type
attribute_key
name
geo_data JSONB
detail JSONB
metadata JSONB
created_at
updated_at

region_attributes

id UUID PK
attribute_id (FK from attributes)
feature_id
feature_id_lvl
value
value_type
date_ISO
date_data
created_at
updated_at

point_attributes

id UUID PK
attribute_id (FK from attributes)
geometry GEOMETRY
properties JSONB
created_at
updated_at

MartinJurcoGlina added a commit that referenced this issue May 19, 2022
#129-generate postgres table structure at db intialization
@bariela bariela closed this as completed May 24, 2022
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant