ЕСОЗ - публічна документація

Copy of [DRAFT] PostgreSQL DB: tables

Owned by Kateryna Yakovleva
Last updated: Nov 26, 2024 by Oksana Demchenko
1 min read

Сторінка знаходиться в процесі розробки. Інформація на ній може бути застарілою.

Properties of document

Document type

Template

Document title

[DRAFT] PostgreSQL DB: tables

Guideline ID

GUI-013

Author

@Kateryna Yakovleva

Document version

v01

Document status

DRAFT

Date of creation

11.04.2024

Date of update

11.04.2024

Table name

declaration

Purpose

template storage

DB ID

PostgreSQL.OPS

Primary key (PK)

id

HL7 version

PostgreSQL.OPS

Table fields

Indexes (optional)

Name

Index attributes

Name

Index attributes

1

N/A

 

2

 

 

Foreign indexes (optional)

Name

Type

Name

Type

1

N/A

 

2

 

 

Triggers (optional)

Name

Description

Name

Description

1

N/A

 

2

 

 

Procedures (optional)

Name

Description

Name

Description

1

N/A

 

2

 

 

Replications (optional)

Database.Table

List of attributes (fields)

Database.Table

List of attributes (fields)

1

N/A

 

2

 

 

Related tables

Attribute (field) of the current table

Attribute (field) of the target table

Relationship type

Database.Target table

Attribute (field) of the current table

Attribute (field) of the target table

Relationship type

Database.Target table

N/A

 

 

 

 

 

 

 

Links to documentation that can create or modify a database object

N/A

ЕСОЗ - публічна документація