Roomescape
Tables (7)
ADMIN (CopyOfUntitled2)
- id (Key) — Bigint — Primary key — NOT NULL
- email (Field) — VARCHAR(255)
- name (Field2) — VARCHAR(255)
- password (Field3) — VARCHAR(255)
MEMBER (Untitled)
- id (Key) — BIGINT — Primary key — NOT NULL
- email (Field) — VARCHAR(255)
- name (Field2) — VARCHAR(255)
- password (Field3) — VARCHAR(255)
PAYMENT (Untitled5)
- id (Key) — BIGINT — Primary key — NOT NULL
- reservation_id (Key2) — BIGINT — Foreign key → RESERVATION.id — NOT NULL
- order_id (Field2) — VARCHAR(255)
- pament_key (Field3) — VARCHAR(255)
- amount (Field4) — INTEGER
RESERVATION (Untitled2)
- id (Key) — BIGINT — Primary key — NOT NULL
- theme_id (Key2) — BIGINT — Foreign key → THEME.id — NOT NULL
- time_id (Key3) — BIGINT — Foreign key → RESERVATION_TIME.id — NOT NULL
- member_id (Key4) — Bigint — Foreign key → MEMBER.id — NOT NULL
- date (Field) — DATE
- status (Field5) — VARCHAR(255)
RESERVATION_TIME (Untitled3)
- id (Key) — BIGINT — Primary key — NOT NULL
- start_at (Field) — TIME(6)
THEME (Untitled4)
- id (Key) — BIGINT — Primary key — NOT NULL
- description (Field) — VARCHAR(255)
- name (Field2) — VARCHAR(255)
- thumbnail (Field3) — VARCHAR(255)
WAITING (Untitled6)
- id (Key) — BIGINT — Primary key — NOT NULL
- reservation_id (Key2) — BIGINT — Foreign key → RESERVATION.id — NOT NULL
- member_id (Key3) — Bigint — Foreign key → MEMBER.id — NOT NULL