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