supplier
TABLE
Sat Apr 02 15:25:01 CEST 2022
Schema
public
References
Exported Keys
| Column | Constraint | Table | Column |
|---|---|---|---|
| id | fk_product_reference_supplier | product | supplierid |
Columns
id
- Primary Key
- Automatic values
- Type
- INTEGER
- Length
- 10
- Decimals
- 0
- Default Value
- nextval('supplier_id_seq'::regclass)
- Exports
-
- Schema
- public
- Constraint Name
- fk_product_reference_supplier
- Table
- product
- Column
- supplierid
companyname
- Type
- VARCHAR
- Length
- 40
- Decimals
- 0
contactname
- Nullable
- Type
- VARCHAR
- Length
- 50
- Decimals
- 0
contacttitle
- Nullable
- Type
- VARCHAR
- Length
- 40
- Decimals
- 0
city
- Nullable
- Type
- VARCHAR
- Length
- 40
- Decimals
- 0
country
- Nullable
- Type
- VARCHAR
- Length
- 40
- Decimals
- 0
phone
- Nullable
- Type
- VARCHAR
- Length
- 30
- Decimals
- 0
fax
- Nullable
- Type
- VARCHAR
- Length
- 30
- Decimals
- 0