theorder
*
Sat Apr 02 15:23:32 CEST 2022
Schema
public
References
Exported Keys
| Column | Constraint | Table | Column |
|---|---|---|---|
| id | fk_orderite_reference_order | orderitem | orderid |
Foreign Keys
| Column | Constraint | Table | Column |
|---|---|---|---|
| customerid | fk_order_reference_customer | customer | id |
Columns
id
- Primary Key
- Automatic values
- Type
- INTEGER
- Length
- 10
- Decimals
- 0
- Default Value
- nextval('"Order_id_seq"'::regclass)
- Exports
-
- Schema
- public
- Constraint Name
- fk_orderite_reference_order
- Table
- orderitem
- Column
- orderid
orderdate
- Type
- TIMESTAMP
- Length
- 29
- Decimals
- 6
- Default Value
- now()
ordernumber
- Nullable
- Type
- VARCHAR
- Length
- 10
- Decimals
- 0
customerid
- Type
- INTEGER
- Length
- 10
- Decimals
- 0
- References (Foreign Key)
-
- Schema
- public
- Constraint Name
- fk_order_reference_customer
- Table
- customer
- Column
- id
totalamount
- Nullable
- Type
- NUMERIC
- Length
- 12
- Decimals
- 2
- Default Value
- 0