CakedaY

테이블 (8)

가게 테이블 Shops (Shops)

  • shop_id — INT
  • owner_id — INT
  • shop_name — VARCHAR(100)
  • description — TEXT
  • created_at — DATETIME
  • updated_at — DATETIME

결제 테이블 Payments (Payments)

  • payment_id — INT
  • order_id — INT
  • payment_method — ENUM('카카오페이', '카드', '무통장입금')
  • payment_status — ENUM('대기', '완료', '실패', '환불')
  • created_at — DATETIME

사용자 역할 UserRoles (UserRoles)

  • user_id — INT
  • role — ENUM('판매자', '소비자')
  • created_at — DATETIME

사용자 테이블 Users (Users)

  • user_id — INT
  • email — VARCHAR(255)
  • password — VARCHAR(255)
  • phone — VARCHAR(20)
  • address — TEXT
  • nickname — VARCHAR(50)
  • profile_image — VARCHAR(255)
  • created_at — DATETIME
  • updated_at — DATETIME

주문 테이블 Orders (Orders)

  • order_id — INT
  • user_id — INT
  • seller_id — INT
  • cake_id — INT
  • pickup_date — DATE
  • order_status — ENUM('예약', '확정', '제작 중', '완료', '취소')
  • total_price — DECIMAL(10, 2)
  • custom_message — TEXT
  • created_at — DATETIME

찜하기 Favorites (Favorites)

  • user_id — INT
  • cake_id — INT
  • created_at — DATETIME

케이크 카테고리 CakeCategories (CakeCategories)

  • category_id — INT
  • category_name — VARCHAR(100)

케이크 테이블 Cakes (Cakes)

  • cake_id — INT
  • seller_id — INT
  • cake_name — VARCHAR(100)
  • description — TEXT
  • price — DECIMAL(10, 2)
  • category_id — INT
  • created_at — DATETIME
  • updated_at — DATETIME