database-project

Tables (7)

Customer

  • customer_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → User.user_id — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • phone — VARCHAR(20) — NOT NULL
  • marketing_agree — TINYINT(1)
  • birth_date — DATE
  • is_deleted — TINYINT(1)
  • deleted_at — DATETIME

Owner

  • owner_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → User.user_id — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • phone — VARCHAR(20) — NOT NULL
  • business_number — VARCHAR(20) — NOT NULL
  • verified_at — DATETIME
  • is_deleted — TINYINT(1)
  • deleted_at — DATETIME

Restaurant

  • restaurant_id — INT — Primary key — NOT NULL
  • owner_id — INT — Foreign key → Owner.owner_id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • address — VARCHAR(255) — NOT NULL
  • phone — VARCHAR(20)
  • category — VARCHAR(50)
  • operating_hours — VARCHAR(100)
  • waiting_available — TINYINT(1)
  • created_at — DATETIME
  • is_deleted — TINYINT(1)
  • deleted_at — DATETIME

Review

  • review_id — INT — Primary key — NOT NULL
  • waiting_id — INT — Foreign key → Waiting.waiting_id — NOT NULL
  • rating — TINYINT — NOT NULL
  • content — TEXT
  • created_at — DATETIME
  • is_deleted — TINYINT(1)
  • deleted_at — DATETIME

ReviewReport

  • report_id — INT — Primary key — NOT NULL
  • review_id (review_id2) — INT — Foreign key → Review.review_id — NOT NULL
  • owner_id — INT — Foreign key → Owner.owner_id — NOT NULL
  • reason — VARCHAR(255) — NOT NULL
  • status — VARCHAR(10)
  • created_at — DATETIME

User

  • user_id — INT — Primary key — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • user_type — VARCHAR(10) — NOT NULL
  • created_at — DATETIME
  • is_deleted — TINYINT(1)
  • deleted_at — DATETIME

Waiting

  • waiting_id — INT — Primary key — NOT NULL
  • restaurant_id — INT — Foreign key → Restaurant.restaurant_id — NOT NULL
  • customer_id — INT — Foreign key → Customer.customer_id — NOT NULL
  • party_size — INT — NOT NULL
  • queue_number — INT — NOT NULL
  • status — VARCHAR(10)
  • created_at — DATETIME
  • entered_at — DATETIME