Roomescape

Tables (6)

MEMBER

  • ID — BIGINT — Primary key — NOT NULL
  • EMAIL — VARCHAR(255) — NOT NULL
  • NAME — VARCHAR(255) — NOT NULL
  • PASSWORD — VARCHAR(255) — NOT NULL
  • SESSION_ID — VARCHAR(255)
  • ROLE — VARCHAR(20)

PAYMENT

  • ID — BIGINT — Primary key — NOT NULL
  • RESERVATION_ID — BIGINT — Foreign key → RESERVATION.ID — NOT NULL
  • PAYMENT_KEY — VARCHAR(255)
  • ORDER_ID — VARCHAR(255)
  • AMOUNT — BIGINT — NOT NULL
  • TYPE — VARCHAR(20)

RESERVATION

  • ID — BIGINT — Primary key — NOT NULL
  • DATE — DATE — NOT NULL
  • MEMBER_ID — BIGINT — Foreign key → MEMBER.ID — NOT NULL
  • THEME_ID — BIGINT — Foreign key → RESERVATION_THEME.ID — NOT NULL
  • TIME_ID — BIGINT — Foreign key → RESERVATION_TIME.ID — NOT NULL

RESERVATION_THEME

  • ID — BIGINT — Primary key — NOT NULL
  • NAME — VARCHAR(255) — NOT NULL
  • DESCRIPTION — VARCHAR(255) — NOT NULL
  • THUMBNAIL — VARCHAR(255) — NOT NULL

RESERVATION_TIME

  • ID — BIGINT — Primary key — NOT NULL
  • START_AT — TIME — NOT NULL

RESERVATION_WAITING

  • ID — BIGINT — Primary key — NOT NULL
  • DATE — DATE — NOT NULL
  • MEMBER_ID — BIGINT — Foreign key → MEMBER.ID — NOT NULL
  • THEME_ID — BIGINT — Foreign key → RESERVATION_THEME.ID — NOT NULL
  • TIME_ID — BIGINT — Foreign key → RESERVATION_TIME.ID — NOT NULL
  • CREATED_AT — TIMESTAMP — NOT NULL