ㅁㅁ

Tables (12)

category

  • id — int — Primary key — NOT NULL
  • category — varchar(30) — NOT NULL

coupon

  • id — int — Primary key — NOT NULL
  • store_id — int — Foreign key → store.id — NOT NULL
  • period — int
  • discount — int
  • is_deleted — boolean — NOT NULL

favorite_store

  • id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → user.id — NOT NULL
  • store_id — int — Foreign key → store.id — NOT NULL
  • created_at — datetime — NOT NULL
  • is_deleted — boolean — NOT NULL

menu

  • id — int — Primary key — NOT NULL
  • store_id — int — Foreign key → store.id — NOT NULL
  • menu — varchar(200) — NOT NULL
  • price — int — NOT NULL
  • created_at — datetime — NOT NULL
  • update_at — datetime

order

  • id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → user.id — NOT NULL
  • store_id — int — Foreign key → store.id — NOT NULL
  • rider_id — int — Foreign key → rider.id
  • order — varchar(100) — NOT NULL
  • total_price — int — NOT NULL
  • order_time — datetime — NOT NULL

owner

  • id — int — Primary key — NOT NULL
  • owner_id — varchar(30) — NOT NULL
  • owner_passwd — varchar(255) — NOT NULL
  • email — varchar(30) — NOT NULL

payment

  • id — int — Primary key — NOT NULL
  • payment — varchar(30) — NOT NULL

review

  • id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → user.id — NOT NULL
  • store_id — int — Foreign key → store.id — NOT NULL
  • order_id — int — Foreign key → order.id
  • rating — int — NOT NULL
  • content — varchar(200)
  • created_at — datetime — NOT NULL
  • update_at — datetime

rider

  • id — int — Primary key — NOT NULL
  • rider_id — varchar(30) — NOT NULL
  • phone — varchar(20) — NOT NULL
  • vehicle — varchar(30) — NOT NULL

store

  • id — int — Primary key — NOT NULL
  • owner_id — int — Foreign key → owner.id — NOT NULL
  • category_id — int — Foreign key → category.id — NOT NULL
  • payment_id — int — Foreign key → payment.id
  • store_name — varchar(50) — NOT NULL
  • category — varchar(30) — NOT NULL
  • phone — varchar(20) — NOT NULL
  • minprice — varchar(30) — NOT NULL
  • reviewCount — int — NOT NULL
  • operationTime — varchar(250) — NOT NULL
  • closedDay — varchar(250) — NOT NULL
  • information — varchar(500)
  • created_at — datetime — NOT NULL
  • update_at — datetime

store_payment

  • id — int — Primary key — NOT NULL
  • store_id — int — Foreign key → store.id — NOT NULL
  • payment_id — int — Foreign key → payment.id — NOT NULL
  • created_at — datetime — NOT NULL

user

  • id — int — Primary key — NOT NULL
  • user_id — varchar(30) — NOT NULL
  • passwd — varchar(255) — NOT NULL
  • email — varchar(30) — NOT NULL
  • name — varchar(100) — NOT NULL
  • address — varchar(100) — NOT NULL
  • created_at — datetime — NOT NULL
  • update_at — datetime