jkm

Tables (9)

Delivery (배송)

  • id — Primary key — NOT NULL
  • delivery_reservation_id (배송예약 id) — Foreign key → DeliveryReservation.id — NOT NULL

DeliveryReservation (배송예약)

  • id — Primary key — NOT NULL
  • reservation_id (예약 id) — Foreign key → RepositoryReservation.id — NOT NULL

Luggage (짐)

  • id — Primary key — NOT NULL

Member (회원)

  • id — Primary key — NOT NULL

Repository (보관소)

  • id — Primary key — NOT NULL

RepositoryImage (보관소이미지)

  • id — Primary key — NOT NULL
  • repository_id (보관소 id) — Foreign key → Repository.id — NOT NULL

RepositoryRegistration (보관소등록)

  • id — Primary key — NOT NULL
  • member_id (등록한 회원) — Foreign key → Member.id — NOT NULL
  • repository_id (등록된 보관소) — Foreign key → Repository.id — NOT NULL

RepositoryReservation (보관소예약)

  • id — Primary key — NOT NULL
  • member_id (예약 회원) — Foreign key → Member.id — NOT NULL
  • repository_id (예약 보관소) — Foreign key → Repository.id — NOT NULL

ReservationLuggage (보관소예약 - 짐 매핑)

  • id — Primary key — NOT NULL
  • reservation_id (예약 id) — Foreign key → RepositoryReservation.id — NOT NULL
  • luggage_id (짐 id) — Foreign key → Luggage.id — NOT NULL