weddie

Tables (5)

Availability (예약 가능 여부)

  • Key — Primary key — NOT NULL
  • availabilityId (availability_id) — Integer
  • shop — Shop
  • product — Product
  • dateTime (date_time) — LocalDateTime
  • isAvailable (is_available) — boolean

Option (Untitled)

  • optionId (option_id) — Integer — Primary key — NOT NULL
  • product — Product — Primary key
  • optionName (option_name) — String
  • price — Integer
  • optionImgUrl (option_img_url) — String

Product (상품)

  • productId (product_id) — Integer — Primary key — NOT NULL
  • Shop (shop) — Shop — Primary key — NOT NULL
  • productName (product_name) — String
  • productImgUrl (product_img_url) — String
  • List<Availability> (availability) — List<Availability>
  • List<Option> (options) — List<Option>

Reservation (예약 테이블)

  • reservationId (reservation_id) — Integer — Primary key — NOT NULL
  • shop — Shop — Primary key
  • reservationTime (reservation_time) — LocalDateTime
  • createdAt (created_at) — LocalDateTime
  • couple — Couple

Shop (매장)

  • shopId (shop_id) — Integer — Primary key — NOT NULL
  • shopName (shop_name) — String — Primary key
  • serviceType (service_type) — serviceType
  • number — String
  • location — String
  • List<Product> (products)