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

Indices

indexsuppliercountry

pk_supplier

indexsuppliername