stores

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
check_ins.store_id fk_check_ins_store_id R
favorite_stores.store_id fk_favorite_stores_store_id R
games.store_id fk_games_store_id R
live_sessions.store_id fk_live_sessions_store_id R
tables.store_id fk_tables_store_id R
texas_holdem_games.store_id fk_texas_holdem_games_store_id R
organization_id VARCHAR 36 null
organizations.id fk_stores_organization_id R
name VARCHAR 100 null
address VARCHAR 255 null
latitude DECIMAL 10,8 null
longitude DECIMAL 11,8 null
image_url VARCHAR 512 √ null
phone_number VARCHAR 20 √ null
description TEXT 65535 √ null
open_time TIME 8 √ null
close_time TIME 8 √ null
is_open BIT 1 0
total_tables INT 11 0
created_at TIMESTAMP 19 CURRENT_TIMESTAMP
updated_at TIMESTAMP 19 CURRENT_TIMESTAMP

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
fk_stores_organization_id Performance Asc organization_id

Relationships

Close relationships within degrees of separation