asd

Tables (3)

Member (유저)

  • id (아이디) — NOT NULL — Primary key — NOT NULL
  • name (이름) — NOT NULL
  • email (이메일) — NOT NULL
  • password (패스워드) — NOT NULL
  • created_at (생성일) — NOT NULL
  • updated_at (수정일) — NOT NULL
  • deleted_at (삭제일)

Reservation (예약정보)

  • id (아이디) — NOT NULL — Primary key — NOT NULL
  • reservation_date (예약 날짜) — NOT NULL
  • hour (예약 시간) — NOT NULL
  • created_at (생성일) — NOT NULL
  • update_at (수정일) — NOT NULL
  • deleted_at (삭제일)
  • member_id (유저 아이디) — NOT NULL — Foreign key → Member.id — NOT NULL
  • room_id (방 아이디) — NOT NULL — Foreign key → Room.id — NOT NULL

Room (미팅룸)

  • id (아이디) — NOT NULL — Primary key — NOT NULL
  • name (이름) — NOT NULL
  • description (설명) — NOT NULL
  • capacity (수용 인원) — NOT NULL
  • created_at (생성일) — NOT NULL
  • updated_at (수정일) — NOT NULL
  • deleted_at (삭제일)