coordinates

20 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
coordinate_images.coordinate_id coordinate_images_coordinate_id_fkey R
coordinate_products.coordinate_id coordinate_products_coordinate_id_fkey R
coordinate_tags.coordinate_id coordinate_tags_coordinate_id_fkey R
shop_id INT 10 null
shops.id coordinates_shop_id_fkey R
staff_id INT 10 null
users.id coordinates_staff_id_fkey R
title VARCHAR 100 null
description VARCHAR 500 √ null
is_public BIT 1 1
created_at DATETIME 19 CURRENT_TIMESTAMP
updated_at DATETIME 19 CURRENT_TIMESTAMP
deleted_at DATETIME 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
coordinates_shop_id_fkey Performance Asc shop_id
coordinates_staff_id_fkey Performance Asc staff_id

Relationships

Close relationships within degrees of separation