...

View file
name erd_example_v5.pdf
height 250
Table of Contents

ERD

View file

name	erd_example_v5.pdf
height	250

...

Name	Type	M/O
id	uuid	M
external_id	varchar	O
name	varchar	M
type	varchar	O
mountaint_group	boolean	M
location	geometry	M
addresses	jsonb[ ]	M
phones	jsonb[ ]	M
email	varchar	M
working_hours	jsonb[ ]	O
is_active	boolean	O
legal_entity_id	uuid	M
status	enum ('')	M

REGISTERS

Name	Type	M/O
id	uuid	M
file_name	varchar	M
status	enum[new, processing, processed ]	M
type	DICTIONARY='REGISTER_TYPE'	M
qty	jsonb: {not_found: number, processing: number, errors: number, total: number}	M
errors	array (e.g. ["Row has length 4 - expected length 5 on line 5"])	M
inserted_at	uuid	M
inserted_by	timestamp	M
updated_at	uuid	M
updated_by	timestamp	M

REGISTER_ENTRIES

Name	Source	M/O
id	uuid	M
register_id	uuid	M
tax_id	varchar	O
national_id	varchar	O
passport	varchar	O
birth_certificate	varchar	O
temporary_certificate	varchar	O
status	enum (processing, matched, not_found)	M
inserted_at	uuid	M
inserted_by	timestamp	M
updated_at	uuid	M
updated_by	timestamp	M

This data type defines address structure

Name	Type	M/O	Description and constraints
type	Dictionary: ADDRESS_TYPE	M
country	Dictionary: COUNTRY	M
area	string	M
region	string	O
settlement	string	M
settlement_id	string	M	settlement_id must be a valid UAddresses entity
settlement_type	Dictionary: SETTLEMENT_TYPE	M
street_type	Dictionary: STREET_TYPE	M
street	string	O
building	string	M
apartment	string	O
zip	string	O

...