물품대여서비스

테이블 (6)

Untitled (users)

  • Key (id) — uuid — 기본 키 — NOT NULL

Untitled (items)

  • Key (id) — uuid — 기본 키 — NOT NULL
  • Key (merchandiseId) — number — 외래 키 → Untitled.Key — NOT NULL
  • Field (title) — string
  • Field (body) — string

Untitled (merchandises)

  • Key (id) — number — 기본 키 — NOT NULL
  • Key (orgId) — number — 외래 키 → shoops.Key — NOT NULL
  • Field (title) — string — NOT NULL
  • Field (image) — string
  • Field (reservations) — number — NOT NULL
  • Field (stocks) — number — NOT NULL
  • Field2 (isClosed) — boolean — NOT NULL

Untitled (reservations)

  • Key (id) — number — 기본 키 — NOT NULL
  • Key (userId) — uuid — 외래 키 → Untitled.Key — NOT NULL
  • Key (merchandiseId) — number — 외래 키 → Untitled.Key — NOT NULL
  • Field (expiresAt) — Date — NOT NULL
  • Field (createdAt) — Date — NOT NULL
  • Field (updatedAt) — Date — NOT NULL

Untitled (transactions)

  • Key (userId) — uuid — 외래 키 → Untitled.Key — NOT NULL
  • Key (reservationId) — number — 외래 키 → Untitled.Key — NOT NULL
  • Key (itemId) — uuid — 외래 키 → Untitled.Key — NOT NULL
  • Field (isExceed) — boolean — NOT NULL
  • Field (expiresAt) — Date — NOT NULL
  • Field (updatedAt) — Date — NOT NULL
  • Field (createdAt) — Date — NOT NULL

shoops (organizations)

  • Key (id) — number — 기본 키 — NOT NULL
  • Key (ownerId) — number — 외래 키 → Untitled.Key — NOT NULL
  • Field (name) — string — NOT NULL
  • Field (image) — string
  • Field (instagram) — string
  • Field (contact) — string
  • Field (maxPeriod) — number — NOT NULL
  • Field (location) — string — NOT NULL
  • Field (openAt) — time — NOT NULL
  • Field (closeAt) — time — NOT NULL
  • Field (isClosed) — boolean — NOT NULL
  • Field (isRequiresTax) — boolean — NOT NULL