retailstore

3 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
posterminal.retailStore_id FK_963E89DAC413DC35R
retailstore_cashlesspayment.retailstore_id FK_2165A9063D65BE63C
retailstore_crossclient.retailstore_id FK_E3ED04063D65BE63C
retailstore_payment.retailstore_id FK_BCE69D553D65BE63C
retailstore_warehouse.retailstore_id FK_FABA25AE3D65BE63C
country_id VARCHAR 36 √ null
country.id FK_1364CE6BF92F3E70R
client_id VARCHAR 36 √ null
client.id FK_1364CE6B19EB6921R
title VARCHAR 255 null
contactPerson VARCHAR 255 null
street VARCHAR 255 null
zip VARCHAR 255 null
city VARCHAR 255 null
state VARCHAR 255 √ null
phone VARCHAR 255 √ null
fax VARCHAR 255 √ null
receiptTemplate LONGTEXT 2147483647 √ null
number VARCHAR 255 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_1364CE6B19EB6921 Performance Asc client_id
IDX_1364CE6BF92F3E70 Performance Asc country_id

Relationships

Close relationships within degrees of separation