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)