salute
Tables (13)
Addresses (주소)
- id (주소id) — bigint — Primary key — NOT NULL
- address_name (주소 별칭) — varchar
- postcode (우편번호) — varchar
- post_address (기본주소) — varchar
- detail_address (상세주소) — varchar
- extra_address (참고사항) — varchar
- isDefault (기본값 여부) — tinyint
- userId (유저id) — bigint
CocktailFavorites (칵테일 즐겨찾기)
- id (칵테일즐겨찾기id) — bigint — Primary key — NOT NULL
- id (유저id) — bigint — Foreign key → Users.id — NOT NULL
- id (칵테일id) — bigint — Foreign key → Cocktails.id — NOT NULL
CocktailIngredients (칵테일재료)
- id (재료id) — bigint — Foreign key → Ingredients.id — NOT NULL
- id (칵테일id) — bigint — Foreign key → Cocktails.id — NOT NULL
- volume (용량) — int
Cocktails (칵테일)
- id (칵테일id) — bigint — Primary key — NOT NULL
- name (칵테일 이름) — varchar
- description (칵테일 설명) — varchar
- recipe (레시피)
- type (레시피 타입) — varchar
- like_counts (좋아요 갯수) — bigint
- created_at (생성일) — datetime
- modified_at (수정일) — datetime
- id (유저id) — bigint — Foreign key → Users.id — NOT NULL
IngredientReviews (재료리뷰)
- id (재료리뷰id) — bigint — Primary key — NOT NULL
- content (댓글) — varchar
- star (별점) — varchar
- is_deleted (삭제여부) — tinyint
- created_at (생성일) — datetime
- modified_at (수정일) — datetime
- id (유저id) — bigint — Foreign key → Users.id — NOT NULL
- id (재료id) — bigint — Foreign key → Ingredients.id — NOT NULL
Ingredients (재료)
- id (재료id) — bigint — Primary key — NOT NULL
- name (이름) — varchar
- AVB (도수) — double
- description (설명) — varchar
- category (카테고리) — enum
Order_Items (주문 아이템)
- id (Key) — bigint — Primary key — NOT NULL
- id (상품 id) — bigint
- id (주문 id) — bigint
- price (총 액) — int
- quantity (수량) — int
- id (주문id) — bigint — Foreign key → Orders.id — NOT NULL
- id (상품id) — bigint — Foreign key → Product.id — NOT NULL
Orders (주문)
- id (주문id) — bigint — Primary key — NOT NULL
- id (장바구니 id) — bigint
- name (주문명) — varchar
- orderNumber (주문 번호) — varchar
- status (주문 상태) — enum
- amount (총 액) — bigint
- created_at (생성일) — datetime
- modified_at (수정일) — datetime
- id (주소id) — bigint — Foreign key → Addresses.id — NOT NULL
- id (유저id) — bigint — Foreign key → Users.id — NOT NULL
Pantry (팬트리)
- id (Key) — bigint — Primary key — NOT NULL
- id (유저id) — bigint — Foreign key → Users.id — NOT NULL
- id (재료id) — bigint — Foreign key → Ingredients.id — NOT NULL
Product (상품)
- id (상품id) — bigint — Primary key — NOT NULL
- name (상품 이름) — varchar
- description (상품 설명) — varchar
- price (가격) — int
- stockQuantity (상품 재고) — int
- category (카테고리) — enum
- status (상품 상태) — enum
- created_at (생성일) — datetime
- modified_at (수정일) — datetime
- id (유저id) — bigint — Foreign key → Users.id — NOT NULL
RecipeReview (레시피 리뷰)
- id (Key) — bigint — Primary key — NOT NULL
- contents (댓글) — varchar
- star (별점) — varchar
- created_at (생성일) — datetime
- modified_at (수정일) — datetime
- id (레시피id) — bigint — Foreign key → Cocktails.id — NOT NULL
- id (유저id) — bigint — Foreign key → Users.id — NOT NULL
- id (주소id) — bigint — Foreign key → Addresses.id — NOT NULL
Shipping (배송)
- id (배송id) — bigint — Primary key — NOT NULL
- receiverName (수신인) — varchar
- receiverPhone (수신인 연락처) — varchar
- deliveryMessage (배송메시지) — varchar
- trackingNumber (운송장 번호) — varchar
- courierCompany (택배사) — enum
- status (배송 상태) — enum
- order와 나중에 연관 (관계)
Users (사용자)
- id (유저id) — bigint — Primary key — NOT NULL
- email (메일) — varchar
- password (비밀번호) — varchar
- nick_name (닉네임) — varchar
- userRole (권한) — enum
- id_deleted (삭제여부) — tinyint
- created_at (생성일) — datetime
- modified_at (수정일) — datetime
- deleted_at (삭제일) — datetime
- Field