저기

테이블 (9)

Accommodation

  • id — SERIAL — 기본 키 — NOT NULL
  • partnerId — TEXT — NOT NULL
  • type — "AccommodationType" — NOT NULL
  • name — TEXT — NOT NULL
  • description — TEXT — NOT NULL
  • address1 — TEXT — NOT NULL
  • address2 — TEXT — NOT NULL
  • latitude — DOUBLE — NOT NULL
  • longitude — DOUBLE — NOT NULL
  • imgUrl — TEXT — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL

Partner

  • id — TEXT — 기본 키 — NOT NULL
  • email — TEXT — NOT NULL
  • encryptedPassword — TEXT — NOT NULL
  • businessName — TEXT — NOT NULL
  • phoneNumber — TEXT
  • staffName — TEXT — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL

Region

  • id — SERIAL — 기본 키 — NOT NULL
  • name — TEXT — NOT NULL
  • label — TEXT — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL

Reservation

  • id — TEXT — 기본 키 — NOT NULL
  • reservedById (id2) — TEXT — 외래 키 → User.id — NOT NULL
  • roomId — INTEGER — NOT NULL
  • date — TIMESTAMP(3) — NOT NULL
  • reservedById — TEXT — NOT NULL
  • reservedAt — TIMESTAMP(3)
  • checkedInAt — TIMESTAMP(3)
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL

Review

  • id — SERIAL — 기본 키 — NOT NULL
  • userId — TEXT — NOT NULL
  • roomId — INTEGER — NOT NULL
  • rating — INTEGER — NOT NULL
  • content — TEXT
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL

Room

  • id — SERIAL — 기본 키 — NOT NULL
  • accommodationId — INTEGER — NOT NULL
  • name — TEXT — NOT NULL
  • description — TEXT — NOT NULL
  • originalPrice — INTEGER — NOT NULL
  • price — INTEGER — NOT NULL
  • checkInTime — TEXT — NOT NULL
  • checkOutTime — TEXT — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL

User

  • id — TEXT — 기본 키 — NOT NULL
  • email — TEXT — NOT NULL
  • encryptedPassword — TEXT — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL

UserProfile

  • userId — TEXT — 기본 키 — NOT NULL
  • nickname — TEXT — NOT NULL
  • phoneNumber — TEXT

_AccommodationToRegion

  • A — INTEGER — NOT NULL
  • B — INTEGER — NOT NULL