Dont12
테이블 (8)
Untitled (lodging)
- Key (id) — BIGINT — 기본 키 — NOT NULL
- Key (category_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
- Field (name) — VARCHAR(50) — NOT NULL
- Field (zip_code) — VARCHAR(10) — NOT NULL
- Field (address) — VARCHAR(200) — NOT NULL
- Field (description) — TEXT — NOT NULL
- Field (longitude) — DECIMAL(18,10) — NOT NULL
- Field (latitude) — DECIMAL(18,10) — NOT NULL
- Field (image_url) — VARCHAR(300) — NOT NULL
- Field (created_at) — TIMESTAMP — NOT NULL
- Field2 (modified_at) — TIMESTAMP — NOT NULL
Untitled (cart)
- Key (id) — BIGINT — 기본 키 — NOT NULL
- Key (user_id) — BIGINT — 외래 키 → 회원.Key — NOT NULL
- Field (created_at) — TIMESTAMP — NOT NULL
- Field2 (modified_at) — TIMESTAMP — NOT NULL
Untitled (orders)
- Key (id) — BIGINT — 기본 키 — NOT NULL
- Key (cart_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
- Field (total_price) — INT — NOT NULL
- Field (created_at) — TIMESTAMP — NOT NULL
- Field (modified_at) — TIMESTAMP — NOT NULL
Untitled (cart_item)
- Key (cart_item_id) — BIGINT — 기본 키 — NOT NULL
- Key (cart_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
- Key (schedule_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
- Field (guest_count) — INT — NOT NULL
- Field (created_at) — TIMESTAMP — NOT NULL
- Field (modified_at) — TIMESTAMP — NOT NULL
Untitled (room)
- Key (id) — BIGINT — 기본 키 — NOT NULL
- Key (lodging_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
- Field (name) — VARCHAR(50) — NOT NULL
- Field (max_guest_count) — INT — NOT NULL
- Field (price) — INT — NOT NULL
- Field (check_in_time) — TIME — NOT NULL
- Field (check_out_time) — TIME — NOT NULL
- Field (created_at) — TIMESTAMP — NOT NULL
- Field2 (modified_at) — TIMESTAMP — NOT NULL
Untitled (room_schedule)
- Key (id) — BIGINT — 기본 키 — NOT NULL
- Key (room_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
- Field (date) — DATE — NOT NULL
- Field (stock) — INT — NOT NULL
- Field (created_at) — TIMESTAMP — NOT NULL
- Field2 (modified_at) — TIMESTAMP — NOT NULL
Untitled (lodging_category)
- Key (id) — BIGINT — 기본 키 — NOT NULL
- Field (name) — VARCHAR(30)
회원 (users)
- Key (id) — BIGINT — 기본 키 — NOT NULL
- Field (email) — VARCHAR(100) — NOT NULL
- Field2 (password) — VARCHAR(255) — NOT NULL
- Field (nickname) — VARCHAR(100) — NOT NULL
- Field (created_at) — TIMESTAMP — NOT NULL
- Field2 (modified_at) — TIMESTAMP — NOT NULL