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