jcake
Tables (41)
blocks_days
- id — bigint — Primary key — NOT NULL
- store_id — bigint — NOT NULL
- from_date — date — NOT NULL
- from_time — time — NOT NULL
- to_date — date — NOT NULL
- to_time — time — NOT NULL
- created_at — timestamp
- updated_at — timestamp
cakes_categories
- id — bigint — Primary key — NOT NULL
- name_ar — varchar(125) — NOT NULL
- name_en — varchar(125) — NOT NULL
- store_id — bigint — NOT NULL
- created_at — timestamp
- updated_at — timestamp
cakes_items
- cake_product_id — bigint — Primary key — NOT NULL
- items_id — bigint — Primary key — NOT NULL
cakes_products
- id — bigint — Primary key — NOT NULL
- name_ar — varchar(125) — NOT NULL
- name_en — varchar(125) — NOT NULL
- image — varchar(125)
- images — text
- type — enum('cake','gift') — NOT NULL
- is_active — tinyint(1) — NOT NULL
- store_id — bigint — NOT NULL
- cakes_categories_id — bigint
- price — decimal(10,2) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
cart
- id — bigint — Primary key — NOT NULL
- customer_id — bigint — NOT NULL
- store_id — bigint — NOT NULL
- coupon_id — bigint
- created_at — timestamp
- updated_at — timestamp
cart_products
- id — bigint — Primary key — NOT NULL
- cart_id — bigint — NOT NULL
- cakes_product_id — bigint
- special_cake_id — bigint
- quantity — int — NOT NULL
- song_url — varchar(125)
- cake_text — varchar(125)
- background_color — varchar(125)
- write_color — varchar(125)
- created_at — timestamp
- updated_at — timestamp
cities
- id — bigint — Primary key — NOT NULL
- name_en — varchar(125) — NOT NULL
- name_ar — varchar(125) — NOT NULL
- country_id — bigint — NOT NULL
- created_at — timestamp
- updated_at — timestamp
countries
- id — bigint — Primary key — NOT NULL
- name_en — varchar(125) — NOT NULL
- name_ar — varchar(125) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
coupons
- id — bigint — Primary key — NOT NULL
- creator_id — bigint — NOT NULL
- title — varchar(125) — NOT NULL
- discount_type — enum('percentage','fixed_amount') — NOT NULL
- code — varchar(64) — NOT NULL
- amount — int
- max_amount — int
- minimum_order — int
- count — int — NOT NULL
- for_first_purchase — tinyint(1) — NOT NULL
- status — enum('active','disable') — NOT NULL
- expired_at — date — NOT NULL
- created_at — timestamp
- updated_at — timestamp
currencies
- id — bigint — Primary key — NOT NULL
- name_ar — varchar(125) — NOT NULL
- name_en — varchar(125) — NOT NULL
- code — varchar(125) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
customer_addresses
- id — bigint — Primary key — NOT NULL
- customer_id — bigint — NOT NULL
- country_id — bigint — NOT NULL
- city_id — bigint — NOT NULL
- street — varchar(125) — NOT NULL
- floor — varchar(125)
- house — varchar(125)
- address — varchar(125)
- notes — text
- longitude — double
- latitude — double
- created_at — timestamp
- updated_at — timestamp
customers
- id — bigint — Primary key — NOT NULL
- first_name — varchar(125) — NOT NULL
- last_name — varchar(125) — NOT NULL
- phone — varchar(125) — NOT NULL
- is_active — tinyint(1) — NOT NULL
- password — varchar(125) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
discounts
- id — bigint — Primary key — NOT NULL
- name — varchar(125) — NOT NULL
- amount — decimal(5,2) — NOT NULL
- type — enum('percentage','fixed') — NOT NULL
- created_at — timestamp
- updated_at — timestamp
failed_jobs
- id — bigint — Primary key — NOT NULL
- uuid — varchar(125) — NOT NULL
- connection — text — NOT NULL
- queue — text — NOT NULL
- payload — longtext — NOT NULL
- exception — longtext — NOT NULL
- failed_at — timestamp — NOT NULL
item_categories
- id — bigint — Primary key — NOT NULL
- name_ar — varchar(125) — NOT NULL
- name_en — varchar(125) — NOT NULL
- store_id — bigint — NOT NULL
- created_at — timestamp
- updated_at — timestamp
items
- id — bigint — Primary key — NOT NULL
- title — varchar(125) — NOT NULL
- price — decimal(10,2) — NOT NULL
- parent_id — bigint
- type — enum('shape','flavor','color','toppings') — NOT NULL
- image — varchar(125)
- images — varchar(125)
- max_words — int
- item_categories_id — bigint
- store_id — bigint — NOT NULL
- created_at — timestamp
- updated_at — timestamp
max_order_of_day
- id — bigint — Primary key — NOT NULL
- max_order — int — NOT NULL
- date — date — NOT NULL
- store_id — bigint — NOT NULL
- created_at — timestamp
- updated_at — timestamp
messages
- id — bigint — Primary key — NOT NULL
- customer_id — bigint — NOT NULL
- user_id — bigint — NOT NULL
- content — text
- type — enum('text','image','voice') — NOT NULL
- sender_type — enum('user','customer') — NOT NULL
- store_id — bigint — NOT NULL
- created_at — timestamp
- updated_at — timestamp
migrations
- id — int — Primary key — NOT NULL
- migration — varchar(125) — NOT NULL
- batch — int — NOT NULL
model_has_permissions
- permission_id — bigint — Primary key — NOT NULL
- model_id — bigint — Primary key — NOT NULL
- model_type — varchar(125) — Primary key — NOT NULL
model_has_roles
- role_id — bigint — Primary key — NOT NULL
- model_id — bigint — Primary key — NOT NULL
- model_type — varchar(125) — Primary key — NOT NULL
orders
- id — bigint — Primary key — NOT NULL
- customer_id — bigint — NOT NULL
- payment_method_id — bigint — NOT NULL
- discount — decimal(10,2)
- tax — decimal(10,2)
- coupon_code — varchar(125)
- coupon_discount — decimal(10,2)
- grand_total — decimal(10,2) — NOT NULL
- coupon_id — bigint
- sub_total — decimal(10,2) — NOT NULL
- shipping — decimal(10,2) — NOT NULL
- address — varchar(125) — NOT NULL
- address_id — bigint — NOT NULL
- phone — varchar(125) — NOT NULL
- phone2 — varchar(125)
- delivery_man_id — bigint
- delivery_date — date — NOT NULL
- delivery_time — time — NOT NULL
- note — text
- status — enum('pending','processing','completed','canceled') — NOT NULL
- payment_status — enum('pending','payment_failed','payment_succeeded') — NOT NULL
- store_id — bigint — NOT NULL
- created_at — timestamp
- updated_at — timestamp
orders_products
- id — bigint — Primary key — NOT NULL
- order_id — bigint — NOT NULL
- cakes_product_id — bigint
- special_cakes_id — bigint
- price — decimal(10,2) — NOT NULL
- amount — int — NOT NULL
- song_url — varchar(125)
- cake_text — varchar(125)
- background_color — varchar(125)
- write_color — varchar(125)
- created_at — timestamp
- updated_at — timestamp
password_reset_tokens
- email — varchar(125) — Primary key — NOT NULL
- token — varchar(125) — NOT NULL
- created_at — timestamp
payment_coupons
- id — bigint — Primary key — NOT NULL
- created_at — timestamp
- updated_at — timestamp
payment_methods
- id — bigint — Primary key — NOT NULL
- name_ar — varchar(125) — NOT NULL
- name_en — varchar(125) — NOT NULL
- logo — varchar(125) — NOT NULL
- country_id — bigint — NOT NULL
- created_at — timestamp
- updated_at — timestamp
permissions
- id — bigint — Primary key — NOT NULL
- name — varchar(125) — NOT NULL
- guard_name — varchar(125) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
personal_access_tokens
- id — bigint — Primary key — NOT NULL
- tokenable_type — varchar(125) — NOT NULL
- tokenable_id — bigint — NOT NULL
- name — varchar(125) — NOT NULL
- token — varchar(64) — NOT NULL
- abilities — text
- last_used_at — timestamp
- expires_at — timestamp
- created_at — timestamp
- updated_at — timestamp
role_has_permissions
- permission_id — bigint — Primary key — NOT NULL
- role_id — bigint — Primary key — NOT NULL
roles
- id — bigint — Primary key — NOT NULL
- name — varchar(125) — NOT NULL
- guard_name — varchar(125) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
shapes
- id — bigint — Primary key — NOT NULL
- zone_id — bigint — NOT NULL
- shape_type — enum('rectangle','circle','polygon') — NOT NULL
- coordinates — geometry — NOT NULL
- created_at — timestamp
- updated_at — timestamp
special_cakes
- id — bigint — Primary key — NOT NULL
- customer_id — bigint — NOT NULL
- message — text
- images — text — NOT NULL
- recording_url — varchar(125)
- status — enum('pending','ordered','cancelled') — NOT NULL
- store_id — bigint — NOT NULL
- size — varchar(125) — NOT NULL
- words — varchar(125)
- occasion_type — varchar(125) — NOT NULL
- price — decimal(10,2) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
store_user
- id — bigint — Primary key — NOT NULL
- user_id — bigint — NOT NULL
- store_id — bigint — NOT NULL
- created_at — timestamp
- updated_at — timestamp
stores
- id — bigint — Primary key — NOT NULL
- name_ar — varchar(125) — NOT NULL
- name_en — varchar(125) — NOT NULL
- country_id — bigint — NOT NULL
- city_id — bigint — NOT NULL
- address — varchar(125)
- longitude — double
- latitude — double
- slug — varchar(125) — NOT NULL
- currency_id — bigint — NOT NULL
- tax_id — bigint
- discount_id — bigint
- created_at — timestamp
- updated_at — timestamp
stores_delivery_zones
- store_id — bigint — Primary key — NOT NULL
- zone_id — bigint — Primary key — NOT NULL
tax
- id — bigint — Primary key — NOT NULL
- name — varchar(125) — NOT NULL
- amount — decimal(5,2) — NOT NULL
- type — enum('percentage','fixed') — NOT NULL
- created_at — timestamp
- updated_at — timestamp
telescope_entries
- sequence — bigint — Primary key — NOT NULL
- uuid — char(36) — NOT NULL
- batch_id — char(36) — NOT NULL
- family_hash — varchar(125)
- should_display_on_index — tinyint(1) — NOT NULL
- type — varchar(20) — NOT NULL
- content — longtext — NOT NULL
- created_at — datetime
telescope_entries_tags
- entry_uuid — char(36) — Primary key — NOT NULL
- tag — varchar(125) — Primary key — NOT NULL
telescope_monitoring
- tag — varchar(125) — Primary key — NOT NULL
users
- id — bigint — Primary key — NOT NULL
- first_name — varchar(125) — NOT NULL
- last_name — varchar(125) — NOT NULL
- phone — varchar(125)
- email — varchar(125) — NOT NULL
- email_verified_at — timestamp
- password — varchar(125) — NOT NULL
- country_id — bigint
- city_id — bigint
- address — varchar(125)
- longitude — double
- latitude — double
- role_id — bigint
- remember_token — varchar(100)
- created_at — timestamp
- updated_at — timestamp
zones
- id — bigint — Primary key — NOT NULL
- name — varchar(125) — NOT NULL
- description — text
- is_active — tinyint(1) — NOT NULL
- created_at — timestamp
- updated_at — timestamp