Tablers
Tables (9)
menu
- menu_id — TEXT
- store_id — TEXT — NOT NULL
- category_id — TEXT — NOT NULL
- name — TEXT
- description — TEXT — NOT NULL
- price — INTEGER
- image_url — TEXT
- is_available — INTEGER
- is_deleted — INTEGER
- created_at — TEXT
- updated_at — TEXT
- deleted_at — TEXT
- UNIQUE(store_id, — category_id,
menu_categories
- category_id — TEXT
- store_id — TEXT — NOT NULL
- name — TEXT — NOT NULL
- display_order — INTEGER — NOT NULL
- is_active — INTEGER
- created_at — TEXT
- updated_at — TEXT
- UNIQUE(store_id, — category_id)
menu_option_groups
- group_id — TEXT
- store_id — TEXT — NOT NULL
- category_id — TEXT — NOT NULL
- menu_id — TEXT — NOT NULL
- group_name — TEXT — NOT NULL
- group_type — TEXT
- is_required — INTEGER
- min_selections — INTEGER
- max_selections — INTEGER
- display_order — INTEGER
- UNIQUE(store_id, — category_id,
menu_options
- option_id — TEXT
- store_id — TEXT — NOT NULL
- category_id — TEXT — NOT NULL
- menu_id — TEXT — NOT NULL
- group_id — TEXT — NOT NULL
- option_name — TEXT — NOT NULL
- additional_price — INTEGER
- display_order — INTEGER
order_items
- order_item_id — TEXT
- user_id — TEXT — NOT NULL
- store_id — TEXT — NOT NULL
- order_id — TEXT — NOT NULL
- table_id — TEXT — NOT NULL
- table_number — INTEGER — NOT NULL
- menu_id — TEXT — NOT NULL
- menu_name — TEXT
- unit_price — INTEGER
- total_price — INTEGER
- selected_options — TEXT
orders
- order_id — TEXT
- user_id — TEXT — NOT NULL
- store_id — TEXT — NOT NULL
- table_id — TEXT — NOT NULL
- order_number — INTEGER — NOT NULL
- order_type — TEXT — NOT NULL
- status — TEXT
- total_amount — INTEGER
- created_at — TEXT
- UNIQUE(user_id, — store_id,
stores
- store_id — TEXT
- user_id — TEXT — NOT NULL
- name — TEXT — NOT NULL
- description — TEXT
- address — TEXT
- phone — TEXT
- business_hours — TEXT
- status — TEXT
- is_deleted — INTEGER
- created_at — TEXT
- updated_at — TEXT
- deleted_at — TEXT
tables
- table_id — TEXT
- user_id — TEXT — NOT NULL
- store_id — TEXT — NOT NULL
- table_number — TEXT — NOT NULL
- table_name — TEXT
- seats — INTEGER
- status — TEXT — NOT NULL
- UNIQUE(store_id, — table_number)
users
- user_id — TEXT
- provider — TEXT — NOT NULL
- provider_id — TEXT — NOT NULL
- name — TEXT — NOT NULL
- email — TEXT — NOT NULL
- phone — TEXT
- profile_image_url — TEXT
- plan_type — TEXT
- is_deleted — INTEGER
- refresh_tokens — TEXT
- created_at — TEXT
- updated_at — TEXT
- deleted_at — TEXT
- UNIQUE(provider, — provider_id)