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