물품대여서비스
테이블 (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