3차 그린커피
테이블 (11)
cart
- cart_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT
- total_cart_price — DOUBLE
- user_id (user_id2) — BIGINT — 외래 키 → user.user_id — NOT NULL
cart_menu
- cartmenu_id — BIGINT — 기본 키 — NOT NULL
- cart_id — BIGINT
- menu_id — BIGINT
- quantity — INT
- size — INT
- ice — INT
- shot — INT
- cream — INT
- sub_cart_price — DOUBLE
- cart_id (cart_id2) — BIGINT — 외래 키 → cart.cart_id — NOT NULL
custom
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT
- user_id (user_id2) — BIGINT — 외래 키 → user.user_id — NOT NULL
custommenu
- custommenu_id — BIGINT — 기본 키 — NOT NULL
- custom_id — BIGINT
- menu_id — BIGINT
- quantity — INT
- myname — VARCHAR(20)
- size — INT
- ice — INT
- shot — INT
- cream — INT
- id (id2) — BIGINT — 외래 키 → custom.id — NOT NULL
event
- eventId — BIGINT — 기본 키 — NOT NULL
- eventimgurl — VARCHAR(255)
home_ad
- id — BIGINT — 기본 키 — NOT NULL
- ad_head — VARCHAR(255)
- ad_content — VARCHAR(255)
- banner_image_url — VARCHAR(255)
- image_url — VARCHAR(255)
- ad_upload_time — DATETIME
- ad_due_date — DATETIME
menu
- menu_id — BIGINT — 기본 키 — NOT NULL
- category — VARCHAR(255)
- name — VARCHAR(255)
- menu_ename — VARCHAR(255)
- menu_explain — VARCHAR(255)
- menu_price — DOUBLE
- menu_imgurl — VARCHAR(255)
- menu_bannerimgurl — VARCHAR(255)
- status — BOOLEAN
- price_size — INT
- price_ice — INT
- price_shot — INT
- price_cream — INT
- visible — BOOLEAN
- recommend — BOOLEAN
orderitem
- order_menu_id — BIGINT — 기본 키 — NOT NULL
- order_id — BIGINT
- menu_id — BIGINT
- sub_price — DOUBLE
- quantity — INT
- size — INT
- ice — INT
- shot — INT
- cream — INT
- order_id (order_id2) — BIGINT — 외래 키 → orders.order_id — NOT NULL
- menu_id (menu_id2) — BIGINT — 외래 키 → menu.menu_id — NOT NULL
orders
- order_id — BIGINT — 기본 키 — NOT NULL
- createdAt — DATETIME
- total_order_price — DOUBLE
- user_id — BIGINT
- store_id — BIGINT
- state — ENUM('ORDERED', 'DELIVERED', 'CANCELLED')
- user_id (user_id2) — BIGINT — 외래 키 → user.user_id — NOT NULL
store
- id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(255)
- address — VARCHAR(255)
- phone — VARCHAR(255)
- open — VARCHAR(255)
- close — VARCHAR(255)
- holiday — VARCHAR(255)
- status — VARCHAR(255) — NOT NULL
- admin_name — VARCHAR(255)
- user_id — BIGINT — 외래 키 → user.user_id — NOT NULL
user
- user_id — BIGINT — 기본 키 — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(255)
- phone — VARCHAR(255)
- birthdate — VARCHAR(255)
- resign — ENUM('N', 'Y')
- resignDate — DATETIME
- loginstate — ENUM('Y', 'N')
- role — ENUM('USER', 'ADMIN')
- store_id — BIGINT
- coupon — INT
- stamp — INT
- token — VARCHAR(255)
- verification_code — VARCHAR(255)
- refreshToken — VARCHAR(255)