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