orderitem
TABLE
Sat Apr 02 15:23:32 CEST 2022
Schema
public
References
Foreign Keys
| Column | Constraint | Table | Column |
|---|---|---|---|
| orderid | fk_orderite_reference_order | theorder | id |
| productid | fk_orderite_reference_product | product | id |
Columns
id
- Primary Key
- Automatic values
- Type
- INTEGER
- Length
- 10
- Decimals
- 0
- Default Value
- nextval('orderitem_id_seq'::regclass)
orderid
- Type
- INTEGER
- Length
- 10
- Decimals
- 0
- References (Foreign Key)
-
- Schema
- public
- Constraint Name
- fk_orderite_reference_order
- Table
- theorder
- Column
- id
productid
- Type
- INTEGER
- Length
- 10
- Decimals
- 0
- References (Foreign Key)
-
- Schema
- public
- Constraint Name
- fk_orderite_reference_product
- Table
- product
- Column
- id
unitprice
- Type
- NUMERIC
- Length
- 12
- Decimals
- 2
- Default Value
- 0
quantity
- Type
- INTEGER
- Length
- 10
- Decimals
- 0
- Default Value
- 1