customer
*
Sat Apr 02 15:23:33 CEST 2022
Schema
public
References
Exported Keys
| Column | Constraint | Table | Column |
|---|---|---|---|
| id | fk_order_reference_customer | theorder | customerid |
Columns
id
A column in a table of placenames with geospatial coordinates
- Primary Key
- Automatic values
- Type
- INTEGER
- Length
- 10
- Decimals
- 0
- Default Value
- nextval('customer_id_seq'::regclass)
- Exports
-
- Schema
- public
- Constraint Name
- fk_order_reference_customer
- Table
- theorder
- Column
- customerid
firstname
- Type
- VARCHAR
- Length
- 40
- Decimals
- 0
lastname
- 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
- 20
- Decimals
- 0