bubble_ERD

Tables (6)

pose_reservation (Bubble_pose_reservation)

  • 1 (Id) — Intenger — Primary key — NOT NULL — <필요>
  • 2 (spot_pose_Id) — Intenger
  • 3 (pose_reservation_Id) — String — 현재 String > Intenger로 변환필요
  • 4 (spot_Id) — Intenger

reserved_pose (Bubble_reserved_pose)

  • 1 (Id) — Intenger — Primary key — NOT NULL — <필요>
  • 2 (spot_pose_Id) — Intenger
  • 3 (pose_reservation_Id) — String — 현재 String > Intenger로 변환필요
  • 4 (spot_Id) — Intenger

reserved_pose(As-Is) (_)

  • 1 (Id) — Intenger — Primary key — NOT NULL — <필요>
  • 2 (spot_pose_Id) — Intenger
  • 3 (pose_reservation_Id) — String — 현재 String > Intenger로 변환필요
  • 4 (spot_Id) — Intenger

spot_pose (As-Is)

  • 1 (unique_Id) — String — Primary key — NOT NULL
  • 2 (spot_Id) — Intenger
  • 3 (tour_Id) — Intenger
  • 4 (url) — String — S3_IMAGE(포즈사진)

spot_pose (To-Be)

  • 1 (Id) — Intenger — Primary key — NOT NULL — <필요>
  • 2 (spot_Id) — Intenger
  • 3 (tour_Id) — Intenger
  • 4 (url) — String — S3_IMAGE(포즈사진)

tour (Bubble_tour)

  • 1 (Id) — Intenger — Primary key — NOT NULL
  • 2 (max_total) — Intenger — SPOT의 최대치
  • 3 (min_total) — Intenger — SPOT의 최소 예약