저기
테이블 (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