럭키버거(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