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