cors back

Tables (8)

cart

  • PRIMARY — KEY`
  • FOREIGN — KEY(user_id) — NOT NULL
  • PRIMARY — KEY2` — NOT NULL
  • created_at — DATETIME

order_items

  • PRIMARY — KEY`
  • FOREIGN — KEY(order_id) — NOT NULL
  • FOREIGN — KEY(product_id) — NOT NULL
  • PRIMARY — KEY2`
  • FOREIGN — KEY(user_id) — NOT NULL
  • PRIMARY — KEY22`
  • FOREIGN — KEY(user_id) — NOT NULL
  • PRIMARY — KEY222` — NOT NULL
  • quantity — INT — NOT NULL
  • price_each — DECIMAL(10,2)

orders

  • PRIMARY — KEY`
  • FOREIGN — KEY(user_id) — NOT NULL
  • PRIMARY — KEY2`
  • FOREIGN — KEY(user_id) — NOT NULL
  • PRIMARY — KEY22` — NOT NULL
  • total_price — DECIMAL(10,2)
  • payment_method — VARCHAR(50)
  • status — ENUM('pending', 'paid', 'cancelled', 'completed')
  • created_at — DATETIME

owners

  • Key — Primary key — NOT NULL
  • PRIMARY (PRIMARYKEY) — KEY` — Primary key — NOT NULL
  • FOREIGN — KEY(user_id) — NOT NULL
  • PRIMARY — KEY2` — NOT NULL
  • store_count — INT — NOT NULL

products

  • PRIMARY — KEY`
  • FOREIGN — KEY(store_id) — NOT NULL
  • PRIMARY — KEY`
  • FOREIGN — KEY — NOT NULL
  • PRIMARY — KEY2` — NOT NULL
  • FOREIGN — KEY(user_id) — NOT NULL
  • PRIMARY — KEY22` — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • price — DECIMAL(10,2) — NOT NULL
  • category_id — BIGINT
  • stock — INT
  • is_active — BOOLEAN
  • created_at — DATETIME

reservations

  • PRIMARY — KEY`
  • FOREIGN — KEY(user_id) — NOT NULL
  • FOREIGN — KEY(store_id) — NOT NULL
  • PRIMARY — KEY2` — NOT NULL
  • PRIMARY — KEY`
  • FOREIGN — KEY — NOT NULL
  • PRIMARY — KEY3` — NOT NULL
  • FOREIGN — KEY(user_id) — NOT NULL
  • PRIMARY — KEY22` — NOT NULL
  • reserve_date — DATETIME — NOT NULL
  • status — ENUM('reserved', 'cancelled', 'completed')
  • created_at — DATETIME

stores

  • PRIMARY — KEY`
  • FOREIGN — KEY — NOT NULL
  • PRIMARY — KEY` — NOT NULL
  • FOREIGN — KEY(user_id) — NOT NULL
  • PRIMARY — KEY2` — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • address — VARCHAR(255)
  • lat — DECIMAL(10,7)
  • lng — DECIMAL(10,7)
  • phone — VARCHAR(20)
  • category_id — BIGINT
  • rating_avg — DECIMAL(2,1)
  • created_at — DATETIME

users

  • PRIMARY — KEY` — Primary key — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50)
  • phone — VARCHAR(13)
  • role — ENUM(''customer, 'owner', 'admin')
  • created_at — DATETIME