바른치킨
테이블 (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)