Entity user
Subject areas: Legacy Core
Attributes
| # | Name | Type | Null | Default | Key | Terms | Description |
|---|---|---|---|---|---|---|---|
| 1 | id | bigint | no | PK | |||
| 2 | login | text(50) | no |
Keys
| Kind | Name | Attributes |
|---|---|---|
| primary | pk_user | id |
Relationships
| Name | Role | Other entity | Cardinality | Attributes | Identifying | On delete | On update |
|---|---|---|---|---|---|---|---|
| orders_user | parent | tbl_Orders | zero_or_one to many | tbl_Orders.CreatedBy -> user.id | no | no_action | no_action |
Physical
pg (postgresql): legacy.user
| # | Name | Type | Null | Default | Identity | Collation | Attribute | Comment |
|---|---|---|---|---|---|---|---|---|
| 1 | id | bigint | no | always | id | |||
| 2 | login | varchar(50) | no | login |
- primary key pk_user (id)