배달 아저씨 고도화
테이블 (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