Iluwa

테이블 (11)

Untitled (loginType)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Field (type) — varchar — NOT NULL

Untitled (room)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • id (member_id) — bigint — 외래 키 → 회원.id — NOT NULL
  • Field (roomName) — varchar — NOT NULL
  • Field (description) — text — NOT NULL
  • Field (price) — bigint — NOT NULL
  • Field (capacity) — bigint — NOT NULL
  • Field (views) — bigint — NOT NULL

Untitled (reservation)

  • Key (id) — bitint — 기본 키 — NOT NULL
  • Key (room_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • id (member_id) — bigint — 외래 키 → 회원.id — NOT NULL
  • Field (people) — bigint — NOT NULL
  • Field (check_in) — date — NOT NULL
  • Field (check_out) — date — NOT NULL
  • Field (created_at) — timestamp — NOT NULL

Untitled (payment)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Key (reservation_id) — bitint — 외래 키 → Untitled.Key — NOT NULL
  • Field (created_at) — timestamp — NOT NULL
  • Field (price) — bigint — NOT NULL

Untitled (review)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Key (room_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • id (member_id) — bigint — 외래 키 → 회원.id — NOT NULL
  • Field (title) — varchr — NOT NULL
  • Field (description) — text — NOT NULL

Untitled (member_roles)

  • id (member_id) — bigint — 외래 키 → 회원.id — NOT NULL
  • Field (roles) — varchar — NOT NULL

Untitled (bookmark)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • id (member_id) — bigint — 외래 키 → 회원.id — NOT NULL
  • Key (room_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Field (created_at) — timestamp — NOT NULL

Untitled (chat_room)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • id (member_id) — bigint — 외래 키 → 회원.id — NOT NULL
  • Key (room_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Field (created_at) — timestamp — NOT NULL

Untitled (image)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • id (member_id) — bigint — 외래 키 → 회원.id
  • Key (room_id) — bigint — 외래 키 → Untitled.Key
  • Field (path) — varchar — NOT NULL
  • Field (created_at) — timestamp — NOT NULL

chat_message (chat_messages)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Key (chat_room_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • id (member_id) — bigint — 외래 키 → 회원.id — NOT NULL
  • Field (created_at) — timestamp — NOT NULL

회원 (member)

  • id — bigint — 기본 키 — NOT NULL
  • Key (loginType_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Field2 (email) — varchar — NOT NULL
  • Field (name) — varchar — NOT NULL
  • Field (password) — varchar — NOT NULL
  • Field3 (phone) — varchar(11)
  • Field (roles) — varchar — NOT NULL
  • Field2 (deleted_at) — timestamp