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