럭키버거(latest)-public

테이블 (15)

accounts (계정)

  • id — BIGINT — 기본 키 — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • role — ENUM('USER','OWNER',ADMIN') — NOT NULL
  • createdAt (created_at) — TIMESTAMP — NOT NULL
  • modifiedAt (modified_at) — TIMESTAMP
  • deletedAt (deleted_at) — TIMESTAMP

cartMenus (장바구니 메뉴)

  • id — BIGINT — 기본 키 — NOT NULL
  • cartId (cart_id) — BIGINT — 외래 키 → carts.id — NOT NULL
  • shopMenuId (shop_menu_id) — BIGINT — 외래 키 → shopMenus.id — NOT NULL
  • quantity — INT — NOT NULL

carts (장바구니)

  • id — BIGINT — 기본 키 — NOT NULL
  • userId (user_id) — BIGINT — 외래 키 → users.id — NOT NULL
  • price — BIGINT — NOT NULL

couponPolicy (쿠폰 정책)

  • id — BIGINT — 기본 키 — NOT NULL
  • shopId (shop_id) — BIGINT — 외래 키 → shops.id — NOT NULL
  • couponId (coupon_id) — BIGINT — 외래 키 → coupons.id — NOT NULL
  • availability — TINYINT — NOT NULL

coupons (쿠폰)

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • percentageDiscount (percentage_discount) — DECIMAL(3,2)
  • fixedDiscount (fixed_discount) — BIGINT
  • count — INT — NOT NULL
  • expirationDate (expiration_date) — TIMPESTAMP — NOT NULL
  • type — ENUM('PERCENTAGE','FIXED') — NOT NULL
  • deletedAt (deleted_at) — TIMESTAMP

events (이벤트)

  • id — BIGINT — 기본 키 — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • content — VARCHAR(200) — NOT NULL
  • createdAt (created_at) — TIMESTAMP — NOT NULL
  • modifiedAt (modified_at) — TIMPSTAMP
  • deletedAt (deleted_at) — TIMESTAMP

holdCoupon (유저 보유 쿠폰)

  • id — BIGINT — 기본 키 — NOT NULL
  • id (id2) — BIGINT — 외래 키 → users.id — NOT NULL
  • id (id3) — BIGINT — 외래 키 → coupons.id — NOT NULL
  • createdAt (created_at) — TIMESTAMP — NOT NULL
  • usedAt (user_at) — TIMESTAMP

menus (메뉴)

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • category — ENUM('HAMBUGER','SIDE','DRINK') — NOT NULL
  • price — DECIMAL(10,2) — NOT NULL

orderMenus (주문 메뉴)

  • id (Key) — 기본 키 — NOT NULL
  • orderId (order_id) — BIGINT — 외래 키 → orders.id — NOT NULL
  • shopMenuId (shop_menu_id) — BIGINT — 외래 키 → shopMenus.id — NOT NULL
  • quantity — INT — NOT NULL

orders (주문)

  • id — BIGINT — 기본 키 — NOT NULL
  • shopId (shop_id) — BIGINT — 외래 키 → shops.id — NOT NULL
  • userId (user_id) — BIGINT — 외래 키 → users.id — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • phone — VARCHAR(50) — NOT NULL
  • address — VARCHAR(255) — NOT NULL
  • request — VARCHAR(255)
  • couponId (coupon_id) — BIGINT — 외래 키 → coupons.id
  • point — INT
  • price — BIGINT — NOT NULL
  • orderDate (order_date) — TIMESTAMP — NOT NULL
  • status — ENUM('WAITING','COOKING','ON_DELIVERY','COMPLETED','CANCEL') — NOT NULL

owners (점주)

  • id — BIGINT — 기본 키 — NOT NULL
  • userId (user_id) — BIGINT — 외래 키 → accounts.id — NOT NULL
  • shopId (shop_id) — BIGINT — 외래 키 → shops.id — NOT NULL

reviews (리뷰)

  • id — BIGINT — 기본 키 — NOT NULL
  • userId (user_id) — BIGINT — 외래 키 → users.id — NOT NULL
  • shopId (shop_id) — BIGINT — 외래 키 → shops.id — NOT NULL
  • orderId (order_id) — BIGINT — 외래 키 → orders.id — NOT NULL
  • content — VARCAHR(255)
  • rating — INT — NOT NULL
  • comment — VARCHAR(255)
  • createdAt (created_at) — TIMESTAMP — NOT NULL
  • modifiedAt (modified_at) — TIMPSTAMP
  • deletedAt (deleted_at) — TIMESTAMP

shopMenus (점포별 메뉴)

  • id — BIGINT — 기본 키 — NOT NULL
  • shopId (shop_id) — BIGINT — 외래 키 → shops.id — NOT NULL
  • menuId (menu_id) — BIGINT — 외래 키 → menus.id — NOT NULL
  • status — ENUM('ON_SALE','OUT_OF_STOCK','DEACTIVATE') — NOT NULL
  • salesVolume (sales_volume) — BIGINT — NOT NULL

shops (점포)

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • status — ENUM('OPEN', 'BREAK', 'CLOSED') — NOT NULL
  • city (Field) — VARCHAR(50) — NOT NULL
  • street (Field2) — VARCHAR(100) — NOT NULL
  • zipcode (Field3) — VARCHAR(100) — NOT NULL
  • deletedAt (deleted_at) — TIMESTAMP

users (유저)

  • id — BIGINT — 기본 키 — NOT NULL
  • accountId (account_id) — BIGINT — 외래 키 → accounts.id — NOT NULL
  • phone — VARCHAR(50) — NOT NULL
  • city — VARCHAR(50) — NOT NULL
  • street — VARCHAR(100) — NOT NULL
  • zipcode — VARCHAR(100) — NOT NULL
  • point — INT — NOT NULL