Entity tbl_Orders
Subject areas: Legacy Core
Attributes
| # | Name | Type | Null | Default | Key | Terms | Description |
|---|---|---|---|---|---|---|---|
| 1 | OrderIDpii: direct | bigint | no | PK | |||
| 2 | CustomerID | integer | no | FK | |||
| 3 | CreatedBy | bigint | yes | FK | |||
| 4 | OrderDate | date | yes |
Keys
| Kind | Name | Attributes |
|---|---|---|
| primary | pk_tbl_orders | OrderID |
Relationships
| Name | Role | Other entity | Cardinality | Attributes | Identifying | On delete | On update |
|---|---|---|---|---|---|---|---|
| items_order | parent | Order Items | one to many | Order Items.OrderID -> tbl_Orders.OrderID | no | no_action | no_action |
| orders_customer | child | CUSTOMER MASTER | zero_or_one to many | tbl_Orders.CustomerID -> CUSTOMER MASTER.CUST_ID | no | no_action | no_action |
| orders_user | child | user | zero_or_one to many | tbl_Orders.CreatedBy -> user.id | no | no_action | no_action |
Physical
pg (postgresql): legacy.tbl_Orders
| # | Name | Type | Null | Default | Identity | Collation | Attribute | Comment |
|---|---|---|---|---|---|---|---|---|
| 1 | OrderID | bigint | no | OrderID | ||||
| 2 | CustomerID | integer | no | CustomerID | ||||
| 3 | CreatedBy | bigint | yes | CreatedBy | ||||
| 4 | OrderDate | date | yes | OrderDate |
- primary key pk_tbl_orders (OrderID)
- foreign key fk_orders_customer (CustomerID) references CUSTOMER MASTER (CUST_ID)
- foreign key fk_orders_user (CreatedBy) references user (id)
- index ix_orders_user (CreatedBy)