Roomescape
Tables (5)
Member
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(255)
- role — VARCHAR(255)
- email — VARCHAR(255)
- password — VARCHAR(255)
Payment
- id — BIGINT — Primary key — NOT NULL
- reservationId — BIGINT — Foreign key → Reservation.id — NOT NULL
- paymentKey — VARCHAR(255)
- orderName — VARCHAR(255)
- requestedAt — VARCHAR(255)
- approvedAt — VARCHAR(255)
- amount — DECIMAL
- easyPayType — VARCHAR(255)
- currency — VARCHAR(20)
- createdAt — TIMESTAMP
Reservation (RESERVATION)
- id — BIGINT — Primary key — NOT NULL
- timeId — BIGINT — Foreign key → ReservationTime.id — NOT NULL
- themeId — BIGINT — Foreign key → Theme.id — NOT NULL
- memberId — BIGINT — Foreign key → Member.id — NOT NULL
- date — DATE
- status — VARCHAR(255)
- createdAt — TIMESTAMP
ReservationTime
- id — BIGINT — Primary key — NOT NULL
- startAt — TIME
Theme
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(255)
- description — VARCHAR(255)
- thumbnail — VARCHAR(255)