product
*
Sat Apr 02 15:23:32 CEST 2022
Schema
public
References
Exported Keys
| Column | Constraint | Table | Column |
|---|---|---|---|
| id | fk_orderite_reference_product | orderitem | productid |
Foreign Keys
| Column | Constraint | Table | Column |
|---|---|---|---|
| supplierid | fk_product_reference_supplier | supplier | id |
Columns
id
- Primary Key
- Automatic values
- Type
- INTEGER
- Length
- 10
- Decimals
- 0
- Default Value
- nextval('product_id_seq'::regclass)
- Exports
-
- Schema
- public
- Constraint Name
- fk_orderite_reference_product
- Table
- orderitem
- Column
- productid
productname
- Type
- VARCHAR
- Length
- 50
- Decimals
- 0
supplierid
- Type
- INTEGER
- Length
- 10
- Decimals
- 0
- References (Foreign Key)
-
- Schema
- public
- Constraint Name
- fk_product_reference_supplier
- Table
- supplier
- Column
- id
unitprice
- Nullable
- Type
- NUMERIC
- Length
- 12
- Decimals
- 2
- Default Value
- 0
package
- Nullable
- Type
- VARCHAR
- Length
- 30
- Decimals
- 0
isdiscontinued
- Type
- BIT
- Length
- 1
- Decimals
- 0
- Default Value
- false