바른치킨

테이블 (38)

allergies (Untitled22)

  • Key — 기본 키 — NOT NULL
  • product_name (Field2) — varchar(255)
  • description (Field3) — text

attachments (상품이미지)

  • Key — 기본 키 — NOT NULL
  • model_name (Field5)
  • model_id (Field2)
  • path (Field) — varchar(255)
  • usage (Field3)
  • sort (Field4)

banners (Untitled11)

  • Key — 기본 키 — NOT NULL
  • title (Field)
  • contents (Field2)
  • sort (Field3)
  • location (Field4)
  • is_visible (Field5)

cancel_details (주문취소내역)

  • Key — 기본 키 — NOT NULL
  • order_id (Key2) — 외래 키 → orders.id — NOT NULL
  • cancel_reason (Field)
  • cancel_date (Field2) — timestamp
  • return_coupon (Field3)
  • cancel_method (Field4)
  • return_amount (Field5) — integer
  • created_at (Field6)

clauses (약관)

  • id (Key) — 기본 키 — NOT NULL
  • user_id (id) — unsignedbiginteger — 외래 키 → users.id — NOT NULL
  • category (Field)
  • created_at (Field2)
  • contents (Field4) — text

coupon_conditions (Untitled8)

  • Key — 기본 키 — NOT NULL
  • name (Field)
  • condition (Field2)

coupon_types (Untitled15)

  • Key — 기본 키 — NOT NULL
  • title (Field2)
  • period (Field3)
  • discription (Field4)
  • is_event_coupon (Field)
  • coupon_condition_id (Key3) — 외래 키 → coupon_conditions.Key — NOT NULL
  • discount_amount (Field5)
  • discount_rate (Field6)
  • minimum_price (Field7)
  • Field8

coupons (Untitled14)

  • Key — 기본 키 — NOT NULL
  • serial_number (Field)
  • start_date (Field3)
  • end_date (Field4)
  • is_used (Field5)
  • is_registered (Field2)
  • coupon_type_id (Key2) — 외래 키 → coupon_types.Key — NOT NULL

delivery_region_store (Untitled28)

  • id (Key) — 기본 키 — NOT NULL
  • store_id (Key2) — 외래 키 → stores.id — NOT NULL
  • delivery_region_id (Key3) — 외래 키 → delivery_regions.id — NOT NULL

delivery_regions (Untitled27)

  • id (Key) — 기본 키 — NOT NULL
  • content (Field)
  • delievery_fee (Field2)

faq_categories (Untitled17)

  • Key — 기본 키 — NOT NULL
  • name (Field)

faqs (Untitled13)

  • Key — 기본 키 — NOT NULL
  • user_id (id) — unsignedbiginteger — 외래 키 → users.id — NOT NULL
  • faq_category_id (Key2) — 외래 키 → faq_categories.Key — NOT NULL
  • title (Field)
  • contents (Field2)
  • updated_at (Field6)
  • created_at (Field5)

imquiry_types (Untitled10)

  • Key — 기본 키 — NOT NULL
  • name (Field)

inquiries (Untitled9)

  • Key — 기본 키 — NOT NULL
  • user_id (id) — unsignedbiginteger — 외래 키 → users.id — NOT NULL
  • inquiry_type_id (Key2) — 외래 키 → imquiry_types.Key — NOT NULL
  • order_id (Key3) — 외래 키 → orders.id — NOT NULL
  • title (Field2)
  • contents (Field3)
  • created_at (Field)
  • updated_at (Field4)

inquiry_answers (Untitled20)

  • Key — 기본 키 — NOT NULL
  • user_id (id) — unsignedbiginteger — 외래 키 → users.id — NOT NULL
  • inquiry_id (Key2) — 외래 키 → inquiries.Key — NOT NULL
  • created_at (Field3)

main_products (상품)

  • id (Key) — 기본 키 — NOT NULL
  • product_category_id (Key2) — 외래 키 → product_categories.id — NOT NULL
  • code (Field11)
  • name (Field) — varchar(255)
  • description (Field2) — text
  • sort (Field12)
  • sell_price (Field4) — integer
  • is_best (Field6) — boolean
  • is_new (Field7) — boolean
  • is_visible (Field10) — boolean
  • created_at (Field8) — timestamp
  • updated_at (Field9) — timestamp
  • allow_topping (Field13) — boolean
  • allow_sidemenu (Field14)
  • allow_drink (Field15)

notices (Untitled12)

  • Key — 기본 키 — NOT NULL
  • user_id (id) — unsignedbiginteger — 외래 키 → users.id — NOT NULL
  • title (Field)
  • contents (Field2)
  • pin (Field3)
  • created_at (Field4)
  • updated_at (Field5)
  • is_event (Field6)

nutritions (Untitled23)

  • Key — 기본 키 — NOT NULL
  • product_name (Field2) — varchar(255)
  • calorie (Field3)
  • sodium (Field4)
  • carbohydrate (Field5)
  • sugars (Field6)
  • crude_fat (Field7)
  • trans_fat (Field8)
  • saturated_fat (Field9)
  • cholesterol (Field10)
  • crude_protein (Field11)

options (옵션 설정)

  • Key — 기본 키 — NOT NULL
  • product_id (Key2) — 외래 키 → main_products.id — NOT NULL
  • name (Field) — varchar(255)
  • option_price (Field2) — integer
  • half_price (Field3) — integer

orders (주문내역)

  • id (Key) — 기본 키 — NOT NULL
  • user_id (id) — 외래 키 → users.id — NOT NULL
  • address_id (Key2) — 외래 키 → user_addresses.id — NOT NULL
  • store_id (Key3) — 외래 키 → stores.id — NOT NULL
  • shopping_basket_id (Key4) — 외래 키 → shopping_baskets.Key — NOT NULL
  • order_date (Field) — timestamp
  • order_number (Field10)
  • order_type (Field3)
  • status (Field4)
  • payment (Field7)
  • cancel_amount (Field8)
  • payment_method (Field9)

origins (Untitled21)

  • Key — 기본 키 — NOT NULL
  • product_name (Field2) — varchar(255)
  • description (Field3) — text

payment (Untitled5)

    payment_log (Untitled7)

      product_categories (Untitled4)

      • id (Key) — 기본 키 — NOT NULL
      • name (Field) — varchar(255)
      • code (Field2)
      • is_visible (Field3) — boolean
      • sort (Field4)
      • is_sub_menu (Field5) — boolean

      promotions (Untitled16)

      • Key — 기본 키 — NOT NULL
      • user_id (id) — unsignedbiginteger — 외래 키 → users.id — NOT NULL
      • title (Field)
      • content (Field2)
      • code (Field3)
      • response (Field4)

      recognition_path_start_up_ask (Untitled19)

      • Key — 기본 키 — NOT NULL
      • start_up_ask_id (Key2) — 외래 키 → start_up_asks.Key — NOT NULL
      • recognition_path_id (Key3) — 외래 키 → recognition_paths.Key — NOT NULL

      recognition_paths (Untitled29)

      • Key — 기본 키 — NOT NULL
      • name (Field)

      roles (Untitled)

      • Key — 기본 키 — NOT NULL
      • name (Field)
      • group (Field2)
      • code (Field3)

      sales_type_store (Untitled26)

      • id (Key) — 기본 키 — NOT NULL
      • sales_type_id (Key2) — 외래 키 → stores.id — NOT NULL
      • store_id (Key3) — 외래 키 → sales_types.id — NOT NULL

      sales_types (Untitled25)

      • id (Key) — 기본 키 — NOT NULL
      • name (Field)

      shopping_baskets (Untitled30)

      • Key — 기본 키 — NOT NULL
      • is_direct_purchase (Field2)
      • phone (Field3)
      • name (Field4)

      start_up_asks (Untitled18)

      • Key — 기본 키 — NOT NULL
      • user_id (id) — unsignedbiginteger — 외래 키 → users.id — NOT NULL
      • name (Field)
      • phone_number (Field2)
      • age (Field3)
      • sex (Field4)
      • email (Field5)
      • region (Field6)
      • start_up_type (Field7)
      • budget_bottom (Field8)
      • budget_top (Field9)
      • Field10

      stores (Untitled24)

      • id (Key) — 기본 키 — NOT NULL
      • store_name (Field)
      • address_details (Field3)
      • telephone (Field4)
      • mobile (Field5)
      • owner_name (Field6)
      • opening_hour (Field8)
      • closing_hour (Field9)
      • holiday (Field10) — varchar(255)
      • is_visible (Field7)
      • delivery_region (Field11)

      sub_products (Untitled6)

      • Key — 기본 키 — NOT NULL
      • product_category_id (Key2) — 외래 키 → product_categories.id — NOT NULL
      • code (Field)
      • name (Field2)
      • description (Field3)
      • sort (Field4)
      • sell_price (Field5)
      • is_best (Field6)
      • is_new (Field7)
      • is_visible (Field8)
      • created_at (Field9)
      • updated_at (Field10)

      user_addresses (Untitled3)

      • id (Key) — 기본 키 — NOT NULL
      • user_id (id) — unsignedbiginteger — 외래 키 → users.id — NOT NULL
      • content (Field2)
      • type (Field4)
      • is_default (Field)

      users (유저)

      • id — unsignedbiginteger — 기본 키 — NOT NULL
      • role_id (Key) — 외래 키 → roles.Key — NOT NULL
      • email (메일) — string
      • name (Field2) — string
      • password (pw) — string
      • phone_number (Field4)
      • personal_info_retention_peroid (Field)
      • is_marketing_agreed (Field3)
      • register_type (Field5)
      • is_dormant (Field10)
      • created_at (Field6)
      • updated_at (Field7)
      • deleted_at (Field8)

      withdraw_users (CopyOfCopyOfUntitled22)

      • Key — 기본 키 — NOT NULL
      • reason (Field2)
      • 일시 (Field6)
      • comment (Field3)

      장바구니 안의 네모칸들 (조합)

      • Key — 기본 키 — NOT NULL
      • option_id (Key3) — 외래 키 → options.Key — NOT NULL
      • shopping_basket_id (Key4) — 외래 키 → shopping_baskets.Key — NOT NULL
      • sub_product_id (Key2) — 외래 키 → sub_products.Key — NOT NULL
      • add_half (Field5) — boolean
      • amount (Field2)