배달 아저씨 고도화

테이블 (18)

Image

  • image_id — BIGINT — 기본 키 — NOT NULL
  • target_id — BIGINT — NOT NULL
  • target_type — VARCHAR(40) — NOT NULL
  • origin_name — VARCHAR(255) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • path — VARCHAR(2048) — NOT NULL
  • extension — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

USER

  • Key (user_id) — BIGINT — 기본 키 — NOT NULL
  • Key (role) — VARCHAR(10) — NOT NULL
  • Field (nickname) — VARCHAR(10) — NOT NULL
  • Field (birthday) — DATE
  • Field (status) — VARCHAR(10) — NOT NULL
  • Field (created_at) — DATETIME — NOT NULL
  • Field (updated_at) — DATETIME — NOT NULL
  • Field (quitted_at) — DATETIME

Untitled (cart_menu_option_detail)

  • Key (menu_history_id) — BIGINT — 기본 키 — NOT NULL
  • Key (menu_option_detail_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
  • Key (cart_menu_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL

Untitled (coupon_brand)

  • Key (id) — BIGINT — 기본 키 — NOT NULL
  • id (coupon_id) — BIGINT — 외래 키 → coupon.id — NOT NULL
  • Key (shop_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL

Untitled (coupon_user)

  • Key (id) — BIGINT — 기본 키 — NOT NULL
  • Key (user_id) — BIGINT — 외래 키 → USER.Key — NOT NULL
  • id (coupon_id) — BIGINT — 외래 키 → coupon.id — NOT NULL
  • Field (use_yn) — TINYINT(1) — NOT NULL
  • Field (created_at) — DATETIME — NOT NULL

Untitled (order_menu_option)

  • Key (order_menu_option_id) — BIGINT — 기본 키 — NOT NULL
  • Key (order_menu_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
  • Field (name) — VARCHAR(50) — NOT NULL
  • Field (price) — BIGDECIMAL — NOT NULL
  • Field (created_at) — DATETIME — NOT NULL

Untitled (order_menu)

  • Key (order_menu_id) — BIGINT — 기본 키 — NOT NULL
  • Key (order_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
  • Field (menu_name) — VARCHAR(50)
  • Field (menu_price) — BIGDECIMAL
  • Field (menu_option_detail_name) — VARCHAR(50)
  • Field (menu_option_detail_price) — BIGDECIMAL
  • Key (quantity) — INT — NOT NULL
  • Field (created_at) — DATETIME — NOT NULL

Untitled (menu_option_detail)

  • Key (menu_option_detail_id) — BIGINT — 기본 키 — NOT NULL
  • Key (menu_option_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
  • Field (name) — VARCHAR(50) — NOT NULL
  • Field (option_price) — BIGDECIMAL — NOT NULL
  • Field (created_at) — DATETIME — NOT NULL

Untitled (menu_option)

  • Key (menu_option_id) — BIGINT — 기본 키 — NOT NULL
  • Key (menu_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
  • Field (name) — VARCHAR(50) — NOT NULL
  • Field (content) — TEXT
  • Field (order) — INT — NOT NULL
  • Field (selection_limit) — INT — NOT NULL
  • Field (requirement) — BOOLEAN — NOT NULL
  • Field (created_at) — DATETIME — NOT NULL
  • Field (updated_at) — DATETIME — NOT NULL

Untitled (cart_menu)

  • Key (cart_menu_id) — BIGINT — 기본 키 — NOT NULL
  • Key (cart_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
  • Key (menu_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
  • Field (quantity) — INT — NOT NULL
  • Field (created_at) — DATETIME — NOT NULL

Untitled (CART)

  • Key (cart_id) — BIGINT — 기본 키 — NOT NULL
  • Key (user_id) — BIGINT — 외래 키 → USER.Key — NOT NULL
  • Key (shop_id) — VARCHAR(15) — 외래 키 → Untitled.Key — NOT NULL
  • Field (created_at) — DATETIME — NOT NULL

Untitled (REVIEW)

  • Key (review_id) — BIGINT — 기본 키 — NOT NULL
  • Key (user_id) — BIGINT — 외래 키 → USER.Key — NOT NULL
  • Key (order_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
  • Key (shop_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
  • Key (menu_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
  • Field (content) — TEXT
  • Field (rating) — TINYINT — NOT NULL
  • Field (status) — VARCHAR(10) — NOT NULL
  • Field (created_at) — DATETIME — NOT NULL

Untitled (CATEGORY)

  • Key (category_id) — BIGINT — 기본 키 — NOT NULL
  • 계층2 (name) — VARCHAR(10) — NOT NULL
  • Field (status) — VARCHAR(5) — NOT NULL
  • Field (created_at) — TIMESTAMP — NOT NULL
  • Field (updated_at) — TIMESTAMP — NOT NULL

Untitled (BASIC_AUTH)

  • Key (basic_auth_id) — BIGINT — 기본 키 — NOT NULL
  • Key (user_id) — BIGINT — 외래 키 → USER.Key — NOT NULL
  • Field (email) — VARCHAR(20) — NOT NULL
  • Key (password) — VARCHAR(255) — NOT NULL

Untitled (ORDER)

  • Key (order_id) — BIGINT — 기본 키 — NOT NULL
  • Key (shop_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
  • Key (user_id) — BIGINT — 외래 키 → USER.Key — NOT NULL
  • Key (coupon_id) — BIGINT — 외래 키 → Untitled.Key
  • Field (ordered_num) — VARCHAR(20) — NOT NULL
  • Field (requirement) — TEXT
  • Field (status) — VARCHAR(10) — NOT NULL
  • Field (total_price) — BIGDECIMAL — NOT NULL
  • Field (reject_reason) — TEXT
  • Field (created_at) — DATETIME — NOT NULL
  • Field (updated_at) — DATETIME — NOT NULL

Untitled (MENU)

  • Key (menu_id) — BIGINT — 기본 키 — NOT NULL
  • Key (shop_id) — VARCHAR(15) — 외래 키 → Untitled.Key — NOT NULL
  • Field (name) — VARCHAR(20) — NOT NULL
  • Field (contents) — TEXT
  • Field (price) — BIGDECIMAL — NOT NULL
  • Field (status) — VARCHAR(10) — NOT NULL
  • Field (created_at) — DATETIME — NOT NULL
  • Field (updated_at) — DATETIME — NOT NULL

Untitled (SHOP)

  • Key (shop_id) — BIGINT — 기본 키 — NOT NULL
  • Key (owner_id) — BIGINT — 외래 키 → USER.Key — NOT NULL
  • Key (category_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
  • Field (regist_num) — VARCHAR(15) — NOT NULL
  • Field (name) — VARCHAR(20) — NOT NULL
  • Field (address) — VARCHAR(255) — NOT NULL
  • Field (minimun_order_account) — BIGDECIMAL — NOT NULL
  • Field (status) — VARCHAR(10) — NOT NULL
  • Field (open_at) — VARCHAR(10) — NOT NULL
  • Field (closed_at) — VARCHAR(10) — NOT NULL
  • Field (closed_day) — VARCHAR(255) — NOT NULL
  • Field (created_at) — DATETIME — NOT NULL
  • Field (updated_at) — DATETIME — NOT NULL

coupon (fcfs_coupon)

  • id — BIGINT — 기본 키 — NOT NULL
  • Field (name) — VARCHAR(20) — NOT NULL
  • Field (code) — VARCHAR(10) — NOT NULL
  • Field (discount_price) — BIGDECIMAL — NOT NULL
  • Field (expired_at) — DATETIME — NOT NULL
  • Field (created_at) — DATETIME — NOT NULL
  • Field (use_yn) — TINYINT(1) — NOT NULL