자고싶다

테이블 (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