자고싶다
테이블 (10)
Coupon (coupon)
- coupon_id — bigint(20) — 기본 키 — NOT NULL
- user_id — bigint(20) — 외래 키 → User.user_id — NOT NULL
- initial_price — decimal — NOT NULL
- final_price — decimal
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- status — varchar(255) — NOT NULL
Favorite (favorites)
- favorite_id — bigint(20) — 기본 키 — NOT NULL
- user_id — bigint(20) — 외래 키 → User.user_id — NOT NULL
- store_id — bigint(20) — 외래 키 → Store.store_id — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- status — varchar(255) — NOT NULL
Menu (menus)
- menu_id — bigint(20) — 기본 키 — NOT NULL
- order_id (oreder_id) — bigint(20) — 외래 키 → Order.order_id — NOT NULL
- store_id — bigint(20) — 외래 키 → Store.store_id — NOT NULL
- category — varchar(50) — NOT NULL
- name — varchar(50) — NOT NULL
- price — int(12) — NOT NULL
- image — text
- created_at — timestamp — NOT NULL
- update_at (updated_at) — timestamp — NOT NULL
- status — varchar(255) — NOT NULL
Menu_Option (menu_options)
- menu_option_id — bigint(20) — 기본 키 — NOT NULL
- menu_id — bigint(20) — 외래 키 → Menu.menu_id — NOT NULL
- option — varchar(255)
- content — varchar(255)
- min_price — bigint(20)
- max — bigint(20) — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- status — varchar(255) — NOT NULL
Order (orders)
- order_id — bigint(20) — 기본 키 — NOT NULL
- user_id — bigint(20) — 외래 키 → User.user_id — NOT NULL
- store_id — bigint(20) — 외래 키 → Store.store_id — NOT NULL
- pay_method — varchar(255) — NOT NULL
- requst (request) — varchar(255)
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- status — varchar(255) — NOT NULL
Pocket (pockets)
- pocket_id — bigint(20) — 기본 키 — NOT NULL
- user_id — bigint(20) — 외래 키 → User.user_id — NOT NULL
- order_id — bigint(20) — 외래 키 → Order.order_id — NOT NULL
- quantity — bigint(20) — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- status — varchar(255) — NOT NULL
Review (review)
- review_id — bigint(20) — 기본 키 — NOT NULL
- user_id — bigint(20) — 외래 키 → User.user_id — NOT NULL
- menu_id — bigint(20) — 외래 키 → Menu.menu_id — NOT NULL
- store_id — bigint(20) — 외래 키 → Store.store_id — NOT NULL
- context — varchar(100)
- image — text
- create_at (created_at) — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- status — varchar(255) — NOT NULL
Store (stores)
- store_id — bigint(20) — 기본 키 — NOT NULL
- name — varchar(255) — NOT NULL
- address — varchar(255) — NOT NULL
- phone_number — bigint(12) — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- status — varchar(255) — NOT NULL
User (users)
- user_id — bigint(20) — 기본 키 — NOT NULL
- nickname — varchar(255) — NOT NULL
- name — varchar(50) — NOT NULL
- email — varchar(50) — NOT NULL
- phone_number — varchar(15) — NOT NULL
- address — varchar(255)
- rank — varchar(50) — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- status — varchar(255) — NOT NULL
User_address (user_address)
- user_address_id — bigint(20) — 기본 키 — NOT NULL
- user_id — bigint(20) — 외래 키 → User.user_id — NOT NULL
- type — varchar(255) — NOT NULL — ENUM(집,회사,직접입력)
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- status — varchar(255) — NOT NULL