kkokko
Tables (5)
Member (Untitled)
- id (bigint) — bigint — Primary key — NOT NULL
- email (Field) — varchar
- password (varchar) — varchar
- nickname (Field3) — varchar
- gender (Field4) — varchar
- age (Field5) — bigint
Reservation (Untitled4)
- id (Key) — bigint — Primary key — NOT NULL
- week_of_day (Field) — varchar
- start_time (Field2) — date
- end_time (Field3) — date
- room_id (Key2) — bigint — Foreign key → Room.id — NOT NULL
ReservationMember (Untitled5)
- id (Key3) — bigint — Primary key — NOT NULL
- reservation_id (Key2) — bigint — Foreign key → Reservation.id — NOT NULL
- member_id (bigint) — bigint — Foreign key → Member.id — NOT NULL
Room (Untitled2)
- id (Key) — bigint — Primary key — NOT NULL
- name (Field) — varchar
- start_time (Field2) — date
- end_time (Field3) — date
- description (Field4) — varchar
- owner_id (bigint) — bigint — Foreign key → Member.id — NOT NULL
Room_Image (Untitled3)
- id (Key) — bigint — Primary key — NOT NULL
- url (Field2) — varchar
- room_id (Key2) — bigint — Foreign key → Room.id — NOT NULL