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